BalanceAAP > File Structure Details / Reference Tables
RETURN TO: Understanding balanceAAPBALANCEaap Data and Reference Tables
| 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
| Field Name | Data Type
|
Length | Required |
Master Plan Required |
| Grade |
Text | 20 | Yes
|
Yes |
| Salary Midpoint
|
Number | No |
No | |
| UserField |
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
|
| 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 |