IMS Data Dictionary

Back to Table List

Table NameAEAEF
Long NameAEA Profile
DescriptionThis file contains one record for each AEA in the database. This file contains specific information which helps identify and describe information as collected from a variety of sources included certified student enrollment figures.
PrefixAE

Field Name Length Type Description Comments
ae_addr1 50 varchar Address Line 1
ae_addr2 50 varchar Address Line 2
ae_aea 2 char AEA Number
ae_agency 4 char Agency Code
ae_city 50 varchar City
ae_fax 10 char Fax Number
ae_medicsn 9 char Medicaid Number
ae_medic 7 char Medicaid Number
ae_medptc 7 char
ae_name 50 varchar AEA Name
ae_phonalt 10 char Phone Number - Alternate
ae_phonpri 10 char Primary Phone Number
ae_ptypalt 2 char Alternate Phone Number Type
ae_ptyppri 2 char Primary Phone Number Type
ae_state 2 char State
ae_udate 8 datetime Record Updated (Date)
ae_uid 9 char Record Updated (User ID)
ae_utime 8 char Record Updated (Time)
ae_watts 10 char Phone Number - Watts
ae_zip 5 char Zip Code
ae_zip4 4 char Zip Code (Extended)
ae_admin 30 char AEA Administrator
ae_data 30 char Data Entry Contact Person(s)
ae_directr 30 char Director
ae_computr 30 char Computer Services Contact Person(s)
ae_medptcs 7 char
ae_key 4 int