Table Name | AEAGF |
Long Name | Agency Profile |
Description | This 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). |
Prefix | AG |
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 |