BalanceAAP > File Structure Details / Reference Tables
RETURN TO: Understanding BALANCEaap Data and Reference Tables
Applicant
| Field Name | Data Type | Length | Required | Master Plan Required |
| Applicant No | Text | 11 | No | No |
| First Name | Text | 50 | No | No |
| Last Name | Text | 50 | No | No |
| Race Code | Text | 20 | No | No |
| Gender Code | Text | 20 | No | No |
| Job Code | Text | 20 | Yes | Yes |
| Dept Code | Text | 20 | No | No |
| Disp Code | Text | 20 | Yes | Yes |
| Hire Date | Date | No | No | |
| Application Date | Date | No | No | |
| Req | Text | 50 | No | No |
| Referral Source | Text | 50 | No | No |
| Plan Code | Text | 20 | No | No |
| UserField | Text | 255 | No | No |
| Drilldown Field | Text |
Yes* |
Yes* | |
| Rollup Field | Text |
No |
No |
Applicant Disposition
| Field Name | Data Type | Length | Required | Master Plan Required |
| 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 | |
| UserField | Text | 255 | No | No |
Department
| Field Name | Data Type | Length | Required | Master Plan Required |
| Dept Code | Text | 20 | Yes | Yes |
| Dept Name | Text | 50 | No | No |
| Reports To | Text
|
20 |
No
|
No |
| UserField | Text | 255 | No | No |
Grade
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
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
|
|
UserField |
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 |
|
UserField
|
Text |
255 |
No |
No |
New Hire
|
Field Name |
Data Type
|
Length |
Required |
Master Plan Required |
|
Employee
Text |
11 |
Yes
|
Yes |
|
|
First Name
|
Text |
50 |
No |
No |
|
Last Name |
Text |
50
|
No |
No |
|
Race |
Text |
20 |
Yes |
Yes
|
|
Gender |
Text
|
20 |
Yes |
Yes |
|
Veteran Code |
Text |
5 |
No
|
No |
| Vets Date |
Date |
No | No | |
|
Job Code
|
Text |
20 |
Yes |
Yes |
|
Dept Code |
Text |
20
|
No |