IMS Data Dictionary

Back to Table List

Table NameAEAGF
Long NameAgency Profile
DescriptionThis file captures the relationship between a child and on outside agency service provider. It will also specify the service provider's Agency and the plan type that is directing his/her involvement (e.g. IEP, IFSP).
PrefixAG

Field Name Length Type Description Comments
ag_addr1 30 char Address Line 1
ag_addr2 30 char Address Line 2
ag_agency 4 char Agency Code
ag_city 20 char City
ag_fax 10 char Fax Number
ag_medic 8 char Medicaid Number
ag_name 80 char Agency Name
ag_phonalt 10 char Phone Number - Alternate
ag_phonpri 10 char Primary Phone Number
ag_ptypalt 2 char Alternate Phone Number Type
ag_ptyppri 2 char Primary Phone Number Type
ag_state 2 char State
ag_udate 8 datetime Record Updated (Date)
ag_uid 9 char Record Updated (User ID)
ag_utime 8 char Record Updated (Time)
ag_watts 10 char Phone Number - Watts
ag_zip 5 char Zip Code
ag_zip4 4 char Zip Code (Extended)
ag_contact 30 char Contact Person
ag_type 4 char Agency type code
ag_comment 254 char Comments
ag_keyagf 10 char AEAGF KEY