| Table Name | AEAIF |
| Long Name | Staff Assignments |
| Description | This file captures basic information regarding the unique relationship between a service provider and the building where his/she is assigned. One service provider can be assigned to many buildings and there is a record for each assignment. Once assigned to a building, then a service provider could be considered as a building resource to assign to specific classes. |
| Prefix | AI |
| Field Name | Length | Type | Description | Comments |
|---|---|---|---|---|
| ai_attbldg | 4 | char | Attending Building | |
| ai_attdist | 4 | char | Attending District | |
| ai_stdate | 10 | char | Service Start Date | |
| ai_pgid | 3 | char | Service ID | |
| ai_pgseq | 2 | char | Service Sequence Number | |
| ai_begdate | 8 | datetime | Begin Date | |
| ai_dept | 3 | char | Department | |
| ai_agency | 4 | char | Agency Code | |
| ai_fte | 6 | char | Full Time Equivalency (FTE) | |
| ai_jobcode | 3 | char | Position Code (Job Title) | |
| ai_model | 2 | char | Program Model | |
| ai_enddate | 8 | datetime | End Date | |
| ai_udate | 8 | datetime | Record Updated (Date) | |
| ai_utime | 8 | char | Record Updated (Time) | |
| ai_uid | 9 | char | Record Updated (User ID) | |
| ai_staff | 10 | char | Staff ID | |
| ai_super | 10 | char | Supervisor | |
| ai_wef | 5 | char | Associated Assignment Weight | not currently used |
| ai_cntrctr | 4 | char | Employer/Contractor | |
| ai_comment | 254 | char | Comments | |
| ai_type | 1 | char | Service Type | |
| ai_keyaif | 10 | char | AEAIF KEY |