BalanceAAP > File Structure Details / Reference Tables
RETURN TO: Understanding BALANCEaap Data Import Requirements
KEY TOPICS:
- Reference Tables
- Applicant Disposition
- Department
- Grade
- Job Code
- Job Group
- Other Default Tables
- Plan Code Reference Table (Master Plan)
- User-Defined Reference Tables
- File Structure Details / Data Tables
balanceAAP Help Cross-reference: If you would like to add a custom field (i.e., User Field) to a particular table, see: Data > Advanced > User Fields.
Reference Tables
Note: The term "Required," as shown in the column headers below, refers to a system requirement for operation of the particular table.
Applicant Disposition
| Field Name | Data Type | Length | Required | Master Plan Required |
| Disposition (Disp) Code | Text | 20 | Yes | Yes |
| Hired | True/False | - | No | No |
| Offer Extended | True/False | - | No | No |
| Internal Successful | True/False | - | No | No |
| Reason | Text | 50 | No | No |
| Exclude | True/False | - | No | No |
| User Field | Text | 255 | No | No |
Department
| Field Name | Data Type | Length | Required | Master Plan Required |
| Department (Dept) Code | Text | 20 | Yes | Yes |
| Dept Name | Text | 50 | No | No |
| Reports To | Text | 20 | No | No | Other Location | Text | 50 | No | No |
| User Field | Text | 255 | No | No |
Grade
| Field Name | Data Type | Length | Required | Master Plan Required |
| Grade | Text | 20 | Yes | Yes |
| Salary Midpoint | Number | 20^ | No | No |
| User Field | Text | 255 | No | No |
Job Code
| Field Name | Data Type | Length | Required | Master Plan Required |
| Job Code | Text | 20 | Yes | Yes |
| Job Title | Text | 50 | No | No |
| Grade | Text | 20 | No | No |
| Job Group | Text | 20 | Yes | Yes |
| Census Code | Text | 3 | No | No |
| Census Code Description | Text | 250 | No | No |
| Job Family | Text | 20 | No | No |
| Job Family Description | Text | 255 | No | No |
| User Field | Text | 255 | No | No |
Job Group
| Field Name | Data Type | Length | Required | Master Plan Required |
| Job Group | Text | 20 | Yes | Yes |
| Group Name | Text | 50 | No | No |
| EEO Code | Text | 3 | Yes | Yes |
| User Field | Text | 255 | No | No |
Other Default Tables
Promotion Code
| Field Name | Data Type | Length | Required | Master Plan Required |
| Prom(otion) Code | Text | 20 | Yes | Yes |
| Reason | Text | 50 | No | No |
| User Field | Text | 255 | No | No |
Termination Code
| Field Name | Data Type | Length | Required | Master Plan Required |
| Term(ination) Code | Text | 20 | Yes | Yes |
| Voluntary | True/False | - | No | No |
| Reason | Text | 50 | No | No |
| User Field | Text | 255 | No | No |
Transfer Code
| Field Name | Data Type | Length | Required | Master Plan Required |
| Transfer Code | Text | 20 | Yes | Yes |
| Reason | Text | 50 | No | No |
| User Field | Text | 255 | No | No |
Veteran (Legacy table)
| Field Name | Data Type | Length | Required | Master Plan Required |
| Veteran Code | Text | 5 | Yes | Yes |
| Description | Text | 50 | No | No |
| Vietnam Veteran | True/False | - | No | No |
| Special Disabled Veteran | True/False | - | No | No |
| Other Veteran | True/False | - | No | No |
| Newly Separated Veteran | True/False | - | No | No |
| Service Medal | True/False | - | No | No |
Plan Code Reference Table (Master Plan)
| Field Name | Data Type | Length | Required | Master Plan Required |
| Plan Code | Text | 50 | No | Yes |
| Company | Text | 250 | No | Yes |
| Establishment | Text | 250 | No | Yes |
| City | Text | 50 | No | No |
| State | Text | 2 | No | No |
| County | Text | 50 | No | No |
| Zip Code | Number | 5 | No | No |
| User Field | Text | 255 | No | No |
^Number includes two decimal places.