BalanceAAP > File Structure Details / Data Tables
RETURN TO: File Structure Details / Reference Tables
KEY TOPICS:
- Applicant
- New Hire
- Promotion
- Roster
- Termination
- Transfer
- Pools
- Promotion Pool
- Termination Pool
- Report Distribution (Hub) Users
Data Tables
Notes: The term "Required," as shown in the column headers below, refers to a system requirement for operation of the Data table.
Fields in italic below are placeholders for special data. For a list of Help resources on special data, see: Custom Data Capabilities.
Applicant
| Field Name | Data Type | Length | Required | Master Plan Required |
| Applicant # | 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 |
| Job Title | Text | 50 | No | No |
| Job Group | Text | 20 | No | No |
| Job Group Name | Text | 50 | No | No |
| Dep(ar)t(ment) Code | Text | 20 | No | No |
| Disp(osition) Code | Text | 20 | Yes | Yes |
| Reason | Text | 50 | Yes | Yes |
| Hire Date | Date^ | - | No | No |
| Application Date | Date^ | - | No | No |
| Req(uisition) # | Text | 50 | No | No |
| Referral Source | Text | 50 | No | No |
| Plan Code (Master Plan) | Text | 20 | No | No |
| User Field | Text | 255 | No | No |
| Drilldown Field | Text | 255 | Yes* | Yes* |
| Rollup Field | 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 |
| Job Code | Text | 20 | Yes | Yes |
| Job Title | Text | 50 | No | No |
| Job Group | Text | 20 | No | No |
| Job Group Name | Text | 50 | No | No |
| Dep(ar)t(ment) Code | Text | 20 | No | No |
| Dept Name | Text | 50 | No | No |
| Hire Date | Date^ | - | No | No |
| Referral Source | Text | 50 | No | No | Req(uisition) # | Text | 50 | No | No |
| Application Date | Date^ | - | No | No |
| Plan Code | Text | 50 | No | Yes |
| Veteran Code (Legacy) | Text | 5 | No | No |
| VETS Date | Date^ | - | No | No |
| IWD (Disability Status) | True/False | - | No | No |
| Protected Veteran (Status) | True/False | - | No | No |
| User Field | Text | 255 | No | No |
| Drilldown Field | Text | 255 | Yes* | Yes* |
| Rollup Field | Text | 255 | No | No |
Promotion
| 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 |
| Old Job Code | Text | 20 | Yes | Yes |
| Old Dep(ar)t(ment) Code | Text | 20 | No | No |
| Old Job Title | Text | 50 | No | No |
| Old Job Group | Text | 20 | No | No |
| Old Job Group Name | Text | 50 | No | No |
| New Job Code | Text | 20 | Yes | Yes |
| New Dept Code | Text | 20 | No | No |
| New Job Title | Text | 50 | No | No |
| New Job Group | Text | 20 | No | No |
| New Job Group Name | Text | 50 | No | No |
| Prom Date | Date^ | - | No | No |
| Reason | Text | 50 | Yes | Yes |
| Plan Code | Text | 50 | No | Yes |
| Promotion ID | Text | 20 | No | No |
| User Field | Text | 255 | No | No |
| Drilldown Field | Text | 255 | Yes* | Yes* |
| Rollup Field | Text | 255 | No | No |
Roster
| 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 |
| Job Code | Text | 20 | Yes | Yes |
| Job Title | Text | 50 | No | No |
| Job Group | Text | 20 | No | No |
| Job Group Name | Text | 50 | No | No |
| Grade | Text | 20 | No | No |
| Dep(ar)t(ment) Code | Text | 20 | Yes | Yes |
| Dept Name | Text | 50 | No | No |
| Annualized Salary | Number^ | 20 | No | No |
| Starting Salary | Number^ | 20 | No | No |
| Hire Date | Date^ | - | No | No |
| Reports In | True/False | - | No | No |
| Reports Out | True/False | - | No | No |
| Annotation Only | True/False | - | No | No |
| Work Location | Text | 50 | No | No |
| Report Location | Text | 50 | No | No |
| Reports to Plan | Text | 50 | No | No |
| Plan Code (Master Plan) | Text | 50 | No | Yes |
| Supervisor | True/False | - | No | No |
| Supervisor Emp(loyee) # | Text | 11 | No | No |
| IWD (Disability Status) | True/False | No | No | |
| Veteran Code (Legacy) | Text | 5 | No | No |
| VETS Date | Date^ | - | No | No |
| Work Zip Code | Text | 5 | No | No |
| Home Zip Code | Text | 5 | No | No |
| Protected Veteran (Status) | True/False | - | No | No |
| User Field | Text | 255 | No | No |
| Drilldown Field | Text | 255 | Yes* | Yes* |
| Rollup Field | Text | 255 | No | No |
Roster: Additional Fields for Compensation Export
| Field Name | Data Type | Length | Required | Master Plan Required |
| Wage Rate | Number^ | 20 | Yes | Yes |
| Typical Hours | Integer | 20 | Yes | Yes |
| Other Comp(ensation) | Number^ | 20 | Yes | Yes |
| Status | Text | 20 | Yes | Yes |
Termination
| 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 |
| Job Code | Text | 20 | Yes | Yes |
| Job Title | Text | 50 | No | No |
| Job Group | Text | 20 | No | No |
| Job Group Name | Text | 50 | No | No |
| Dep(ar)t(ment) Code | Text | 20 | No | No |
| Department Name | Text | 50 | No | No |
| Term(ination) Code | Text | 20 | Yes | Yes |
| Voluntary | True/False | - | No | No |
| Reason | Text | 50 | No | No |
| Term Date | Date^ | - | No | No |
| Plan Code (Master Plan) | Text | 50 | No | Yes |
| Term(ination) ID | Text | 20 | No | No |
| User Field | Text | 255 | No | No |
| Drilldown Field | Text | 255 | Yes* | Yes* |
| Rollup Field | Text | 255 | No | No |
Transfer
| 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 |
| Old Job Code | Text | 20 | Yes | Yes |
| Old Dep(ar)t(ment) Code | Text | 20 | No | No |
| Old Job Title | Text | 50 | No | No |
| Old Job Group | Text | 20 | No | No |
| Old Job Group Name | Text | 50 | No | No |
| New Job Code | Text | 20 | Yes | Yes |
| New Dept Code | Text | 20 | No | No |
| New Job Title | Text | 50 | No | No |
| New Job Group | Text | 20 | No | No |
| New Job Group Name | Text | 50 | No | No |
| Transfer Code | Text | 20 | No | No |
| Transfer Date | Date^ | - | No | No |
| Reason | Text | 50 | No | No |
| Plan Code (Master Plan) | Text | 50 | No | Yes |
| User Field | Text | 255 | No | No |
| Drilldown Field | Text | 255 | Yes* | Yes* |
| Rollup Field | Text | 255 | No | No |
Pools
balanceAAP Help Cross-reference: The tables below support coding employees for Adverse Impact reporting. To learn about the calculation, see: Adverse Impact.
Promotion Pool
| 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 |
| Old Job Code | Text | 20 | Yes | Yes |
| New Job Code | Text | 20 | Yes | Yes |
| Old Dep(ar)t(ment) Code | Text | 20 | No | No |
| New Dept Code | Text | 20 | No | No |
| Plan Code | Text | 50 | No | Yes |
| Prom(otion) ID | Text | 20 | Yes | No |
| User Field | Text | 255 | No | No |
| Drilldown Field | Text | 255 | Yes* | Yes* |
| Rollup Field | Text | 255 | No | No |
Termination Pool
| 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 |
| Job Code | Text | 20 | Yes | Yes |
|
Dep(ar)t(ment) Code |
Text | 20 | No | No |
| Plan Code (Master Plan) | Text | 50 | No | Yes |
| Term(ination) ID | Text | 20 | Yes | No |
| User Field | Text | 255 | No | No |
| Drilldown Field | Text | 255 | Yes* | Yes* |
| Rollup Field | Text | 255 | No | No |
Notes:
Drilldown Fields: As marked above with an (*) asterisk, Drilldown fields are required by the system ONLY if you include a Drilldown Reference table.
^Year format is: 2-digit month/2-digit day/2- or 4-digit year. Number includes two decimal places.Report Distribution (Hub) Users
| Field Name | Data Type | Length | Required | Master Plan Required |
| Email Address | Text | 250 | Yes | Yes |
| First Name | Text | 50 | Yes | Yes |
| Last Name | Text | 50 | Yes | Yes |
| Publish Group | Text | 50 | No | No |
| Plan Code (Master Plan) | Text | 50 | No | No |
balanceAAP Help Cross-reference: The table above supports setting up users to securely view AAP results by role. See: BALANCEhub Settings > Import Users.