RETURN TO: Understanding BALANCEaap Data Import Requirements
KEY TOPICS:
- Reference Tables
- Applicant Disposition
- Department
- Grade
- Job Code
- Job Group
- Plan Code (Master Plan)
- Other Tables
- Data Tables
Reference Tables
The term "Required," as shown in the column headers below, refers to a system requirement for operation.
User-defined
Cross-reference: fieldsCustom fields, as defined for specific data needs, may be added to each table. For more information, see:
Data > Advance > 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 |
|
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 |
4 |
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 |
Plan Code (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 |
| Reasonable Recruitment Area |
Text |
250 |
No |
No |
| 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 |
Other Tables
Promotion Code
| Field Name |
Data Type |
Length |
Required |
Master Plan Required |
| Promotion (Prom) 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 |
| Termination (Term) 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 |
User-Defined Drilldown Level
| Field Name |
Data Type |
Length |
Required |
Master Plan Required |
| Drilldown Field |
Text |
|
Yes* |
Yes* |
| Description |
Text |
|
No |
No |
| Zip Code |
Text |
|
No |
No |
User-Defined Rollup Level (Master Plan)
| Field Name |
Data Type |
Length |
Required |
Master Plan Required |
| Rollup Field |
Text |
|
No |
No |
| Description |
Text |
|
No |
No |
| Zip Code |
Text |
|
No |
No |