| Table Name | AESRF |
| Long Name | Staff Department Assignments |
| Description | This file describes the unique relationship of a staff member to his/her agency, position and department. Data such as FTE for this specific position is captured in this file. At the agency level, a listing of staff by department and position would reveal the total resources in FTE for a department. |
| Prefix | SR |
| Field Name | Length | Type | Description | Comments |
|---|---|---|---|---|
| sr_agency | 4 | char | Agency Code | |
| sr_begdate | 8 | datetime | Begin Date | |
| sr_cntrctr | 4 | char | Employer/Contractor | |
| sr_dept | 3 | char | Department | |
| sr_enddate | 8 | datetime | End Date | |
| sr_expert | 3 | char | Area of Expertise | |
| sr_fte | 5 | decimal | Full Time Equivalency (FTE) | |
| sr_jobcode | 3 | char | Position (Job Title) | |
| sr_partici | 2 | char | Particular | |
| sr_udate | 8 | datetime | Record Updated (Date) | |
| sr_uid | 9 | char | Record Updated (User ID) | |
| sr_utime | 8 | char | Record Updated (Time) | |
| sr_van | 6 | char | Van Route | |
| sr_staff | 10 | char | Staff ID | |
| sr_eval | 10 | char | Evaluator | |
| sr_super | 10 | char | Supervisor | |
| sr_keysrf | 10 | char | ||
| sr_funding | 3 | char | Funding Source | |
| sr_comment | 254 | char | ||
| sr_region | 4 | char |