BalanceAAP > File Structure Details / Data Tables
RETURN TO: File Structure Details / Reference Tables
KEY TOPICS:
- Applicant
- New Hire
- Promotion
- Roster
- Termination
- Transfer
- Promotion Pool
- Termination Pool
- Report Distribution (Hub) Users
If you have special data needs —
balanceAAP Help Cross-references:
- Custom tables for unique personnel actions may be added to the system's Data Tables. For more information, see: Data > Advanced > User-Defined Personnel Actions.
- For more on building Drilldowns (custom organizational units within the plan), see: Reporting Levels > Drilldowns.
- Master Plan preparers may learn about custom Rollups, or reporting levels that go above the plan, at: Reporting Levels > Rollups.
Data Tables
The term "Required," as shown in the column headers below, refers to a system requirement for operation.
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 | 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 |
| New Job Code | Text | 20 | Yes | Yes |
| Old Dep(ar)t(ment) Code | Text | 20 | No | No |
| New Dept Code | Text | 20 | No | No |
| Prom(otion) Code | Text | 20 | No | No |
| Prom Date | Date | - | No | No |
| Plan Code | Text | 50 | No | Yes |
| Prom # | Text | 20 | No | No |
| User Field | Text | 255 | No | No |
| Drilldown Field | Text | 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 | No | No | |
| Starting Salary | Number | 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 | No | No | |
| Home Zip Code | Text | No | No | |
| Protected Veteran (Status) | True/False | - | No | No |
| User Field | Text | 255 | No | No |
| Drilldown Field | Text | 255 | Yes* | Yes* |
| Rollup Field | Text | 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 |
| Dep(ar)t(ment) Code | Text | 20 | No | No |
| Term(ination) Code | Text | 20 | Yes | Yes |
| 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 | 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 |
| New Job Code | Text | 20 | Yes | Yes |
| Old Dep(ar)t(ment) Code | Text | 20 | No | No |
| New Dept Code | Text | 20 | No | No |
| Transfer Code | Text | 20 | No | No |
| Transfer Date | Date | - | 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 |
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 | 255Text | Yes* | Yes* | |
| Rollup Field | Text | 255 | No | No |
Note: Drilldown fields on Data tables, as displayed above, are required by the system ONLY if you include a Drilldown Reference table. These fields are marked with an (*) asterisk.
Report Distribution (Hub) Users
| Field Name | Data Type | Length | Required | Master Plan Required |
| Email Address | Text | 2500 | 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 |