RETURN TO: Understanding balanceAAP Data and Reference Tables
Applicant
| 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
| No
|
Hire Date
| Date
| |
No
| No
|
Referral Source
| Text
| 50
|
No
| No
|
Application Date
| Date
| |
No
| No
|
Plan Code
| Text
| 50
|
No
| Yes
|
Req #
| Text
|
50
| No
| No
|
UserField
| Text
|
255
| No
|
No
|
Drilldown Field | Text | | Yes* |
Yes*
|
Rollup Field | Text | | No |
No
|
Plan Code
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
|
UserField
|
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 |
| NewFirst 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 |
|
Old Dept Code | | Text | | 20
|
No
| | No |
New Dept Code
| Text
|
20
| No
| No
|
Prom Code
| Text
|
20
| No
|
No
|
Prom Date
|
Date
| | No
| No
|
Plan Code
| Text
|
50
| No
|
Yes
|
Promotion ID | Text | 20 | No |
No
|
UserField
|
Text
| 255
| No
|
No
|
Drilldown Field |
Text
|
| Yes* | Yes* |
Rollup Field |
Text
|
| 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 Dept Code
| Text
| 20
|
No
| No
|
New Dept Code
| Text
|
20
| No
| No
|
Plan Code
| Text
|
50
| No
|
Yes
|
Promotion ID | Text | 20 | Yes |
No
|
UserField
|
Text
| 255
| No
|
No
|
Drilldown Field |
Text
|
| Yes* | Yes* |
Rollup Field |
Text
|
| No | No |
Promotion Code
Field Name
| Data Type
|
Length
| Required
| Master Plan Required
|
Prom Code
| Text
|
20
| Yes
|
Yes
|
Reason
|
Text
| 50
| No
|
No
|
UserField
|
Text
| 255
|
No
| No
|
Report Distribution 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
| Text
|
50
| 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
|
Department Code
| Text
|
20
| Yes
|
Yes
|
Hire Date
|
Date
| | No
| No
|
Veteran Code
| Text
|
5
| No
|
No
|
Annualized Salary
|
Number
| | No
| No
|
Starting Salary
| Number
|
| 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
|
Text
| 50
| No
|
Yes
|
Supervisor
|
True/False
| | No
|
No
|
Supervisor Emp #
|
Text
| 11
|
No
| No
|
VETS Date
| Date
| | No
|
No
|
UserField
|
Text
| 255
|
No
| No
|
Work Zip Code | Text | |
No
|
No |
Home Zip Code | Text | |
No
|
No |
Drilldown Field | Text | |
Yes*
|
Yes* |
Rollup Field | Text | |
No
|
No |
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
|
Dept Code
|
Text
| 20
|
No
| No
|
Term Code
| Text
| 20
|
Yes
| Yes
|
Term Date
| Date
| |
No
| No
|
Plan Code
| Text
| 50
|
No
| Yes
|
Termination ID | Text | 20 | No | No |
UserField
| Text
|
255
| No
| No
|
Drilldown Field | Text |
|
Yes* | Yes* |
Rollup Field | Text |
|
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
|
Dept Code
| Text
| 20
|
No
| No
|
Plan Code
| Text
|
50
| No
|
Yes
|
Termination ID | Text | 20 | Yes |
No
|
UserField
|
Text
| 255
| No
|
No
|
Drilldown Field |
Text
|
| Yes* | Yes* |
Rollup Field |
Text
|
| No | No |
Termination Code
Field Name
|
Data Type
| Length
|
Required
| Master Plan Required
|
Term Code
| Text
| 20
|
Yes
| Yes
|
Voluntary
| True/False
| |
No
| No
|
Reason
| Text
| 50
|
No
| No
|
UserField
| 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 Dept 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
|
Text
| 50
|
No
| Yes
|
UserField
| Text
| 255
|
No
| No
|
Drilldown Field
|
Text | | Yes* | Yes* |
Rollup Field
|
Text | | No | No |
Transfer Code
Field Name
|
Data Type
| Length
| Required
|
Master Plan Required
|
Transfer Code
|
Text
| 20
|
Yes
| Yes
|
Reason
| Text
| 50
|
No
| No
|
UserField
| Text
|
255
| 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
Field Name
|
Data Type
| Length
|
Required
| Master Plan Required
|
Rollup Field
| Text
|
|
No
| No
|
Description
| Text
|
| No
| No
|
Zip Code
| Text | | No
| No
|
Veteran
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
|
*Note: Drilldown Fields in the Data Tables and a Drilldown reference table is required ONLY if you choose to create drilldown levels.