RETURN TO: Understanding BALANCEaap Data Import Requirements
KEY TOPICS:
- Reference Tables
- Applicant Disposition
- Department
- Grade
- Job Code
- Job Group
- Other Default and User-Defined Tables
- Plan Code Reference Table (Master Plan)
- Data Tables
Reference Tables
The term "Required," as shown in the column headers below, refers to a system requirement for operation.
balanceAAP Help Cross-reference: Custom fields (noted below as: User Field) may be added to a particular Reference or Data table for business-specific needs. See: Data > Advanced > User Fields.
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 and User-Defined 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 |
Drilldown (User-defined)
| Field Name |
Data Type |
Length |
Required |
Master Plan Required |
| Drilldown Field |
Text |
255 |
Yes* |
Yes* |
| Description |
Text |
255 |
No |
No |
| Zip Code |
Text |
5 |
No |
No |
Rollup (User-defined, (MasterMaster Plan, User-defined)Plan)
| Field Name |
Data Type |
Length |
Required |
Master Plan Required |
| Rollup Field |
Text |
255 |
No |
No |
| Description |
Text |
255 |
No |
No |
| Zip Code |
Text |
5 |
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.