Field Name |
Length |
Type |
Description |
Comments |
dp_addr1 |
30 |
char |
Address Line 1 |
|
dp_addr2 |
30 |
char |
Address Line 2 |
|
dp_aea |
2 |
char |
AEA Number |
|
dp_city |
20 |
char |
City |
|
dp_contact |
30 |
char |
AEA Contact to Local District |
|
dp_county |
2 |
char |
County Number |
|
dp_current |
1 |
bit |
District Active (T/F) |
|
dp_dist |
4 |
char |
District Number |
|
dp_enddate |
8 |
datetime |
Date the District was discontinued |
As districts are reorganized and merged, keeping information on the former distrist will help in keeping historical information. |
dp_fax |
10 |
char |
Fax Number |
|
dp_name |
50 |
char |
District Legal Name |
|
dp_sname |
30 |
char |
District Short Name |
This description can be use in lieu of the |
dp_phonalt |
10 |
char |
Phone Number - Alternate |
|
dp_phonpri |
10 |
char |
Primary Phone Number |
|
dp_pool |
2 |
char |
District Pooling |
|
dp_ppcost |
5 |
decimal |
Per Pupil Cost |
|
dp_ptypalt |
2 |
char |
Alternate Phone Number Type |
|
dp_ptyppri |
2 |
char |
Primary Phone Number Type |
|
dp_public |
2 |
char |
Public/Non-Public |
|
dp_region |
4 |
char |
Region Number |
|
dp_state |
2 |
char |
State |
|
dp_stdate |
8 |
datetime |
Date the District was organized |
As districts are added through merger etc, the district begin date will be stored here. |
dp_udate |
8 |
datetime |
Record Updated (Date) |
|
dp_uid |
9 |
char |
Record Updated (User ID) |
|
dp_utime |
8 |
char |
Record Updated (Time) |
|
dp_van |
6 |
char |
Van Route |
|
dp_watts |
10 |
char |
Phone Number - Watts |
|
dp_zip |
5 |
char |
Zip Code |
|
dp_zip4 |
4 |
char |
Zip Code (Extended) |
|
dp_med |
7 |
char |
|
|
dp_medsub |
7 |
char |
|
|
dp_npib |
10 |
char |
|
|
dp_npic |
10 |
char |
|
|
dp_medtid |
9 |
char |
|
|
dp_IIP_DC |
50 |
varchar |
|
|