| Table Name | AETDF |
| Long Name | Staff Demographic |
| Description | This file contains information which identifies an individual service provider. One service provider can have many relationships to buildings, classes, certifications, endorsements, referrals, meetings, and evaluations. |
| Prefix | TD |
| Field Name | Length | Type | Description | Comments |
|---|---|---|---|---|
| td_addr1 | 30 | char | Address Line 1 | |
| td_addr2 | 30 | char | Address Line 2 | |
| td_cert | 8 | char | Certificate Number | |
| td_city | 20 | char | City | |
| td_dob | 8 | datetime | Birthdate | |
| td_ethnic | 2 | char | Ethnicity | |
| td_first | 15 | char | First Name | |
| td_fte | 5 | decimal | Contract Full Time Equivalency (FTE) | |
| td_gender | 1 | char | Gender | |
| td_jobcode | 3 | char | Staff Job Title | |
| td_last | 30 | char | Last Name | |
| td_phonalt | 10 | char | Alternate Phone Number | |
| td_phonpri | 10 | char | Primary Phone Number | |
| td_ptypalt | 2 | char | Alternate Phone Number Type | |
| td_ptyppri | 2 | char | Primary Phone Number Type | |
| td_ssn | 9 | char | Social Security Number | |
| td_state | 2 | char | State | |
| td_udate | 8 | datetime | Record Updated (Date) | |
| td_uid | 9 | char | Record Updated (User ID) | |
| td_utime | 8 | char | Record Updated (Time) | |
| td_van | 6 | char | Van Route | |
| td_zip | 5 | char | Zip Code | |
| td_zip4 | 4 | char | Zip Code (Extended) | |
| td_staff | 10 | char | Staff ID | |
| td_eval | 10 | char | Evaluator | |
| td_base | 6 | char | Field Office | |
| td_comment | 254 | char | Comments | |
| td_generic | 1 | bit | Generic Staff y/n | |
| td_nomed | 1 | bit | Exclude from Medicaid | |
| td_aea | 10 | char | AEA | |
| td_web | 1 | bit | Using Web Reports | |
| td_email | 250 | char | ||
| td_login | 10 | char | Login | |
| td_passwd | 10 | char | Password | |
| td_level | 5 | decimal | User Level | |
| td_agency | 20 | char | Agency | |
| td_inactive | 1 | bit | Inactive Y/N | |
| td_ieppdfv | 1 | bit | ||
| td_ieppdfd | 1 | bit | ||
| td_iepiepv | 1 | bit | ||
| td_iepiepc | 1 | bit | ||
| td_iepiepe | 1 | bit | ||
| td_iepiepd | 1 | bit | ||
| td_iepiepi | 1 | bit | ||
| td_iepeaddr | 1 | bit | ||
| td_iepstuc | 1 | bit | ||
| td_iepestaff | 1 | bit | ||
| td_primbldg | 8 | char | ||
| td_iepstande | 1 | bit | ||
| td_menu | 2 | smallint | User Menu | |
| td_lastlogin | 8 | datetime | Date/Time Last Login | |
| td_certified | 1 | bit | ||
| td_iepadmin | 1 | bit | Web IEP Administration Mailing List | |
| td_iepsubmit | 1 | bit | ||
| td_iepreview | 1 | bit | ||
| td_ieptransfer | 1 | bit | ||
| td_iepviewallstudents | 1 | bit | ||
| td_notifyemail | 250 | char | ||
| td_iepstatereports | 1 | bit | ||
| td_useragent | 100 | varchar | ||
| td_ReviewProcess | 50 | char | ||
| td_ieplanguage | 1 | bit | ||
| td_LanguageChoice | 50 | char | ||
| td_iepprimec | 1 | bit | Web IEP Primary AEA Mailing List | |
| td_bldglist | 2 | smallint | ||
| td_ip | 15 | char | ||
| td_ViewStudent | 10 | char | ||
| td_misic | 1 | bit | ||
| td_earlylearning | 1 | bit | ||
| td_key | 4 | int | ||
| td_officeCode | 4 | int | Office Location | |
| td_staff2 | 1 | bit | ||
| td_mi | 1 | char |