IMS Data Dictionary

Back to Table List

Table NameAEDPF
Long NameDistrict Profile
DescriptionThis District Profile file contains one record for each district that is referenced in the database. This file contains specific information which helps identify and describe each district. Information is collected from a variety of sources including certified student enrollment figures. One district can contain many zones and one district can contain many buildings.
PrefixDP

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