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

---

BALANCEaap Help Cross-references:

Fields listed below in italic are for developing Data and Reporting Levels that godata beyond the AAPAAP's regulatory structure. If you have special data needs,Data, or seeyou would like to develop Reporting Levels, review the following resources.

• User Fields —
• File Structure Details / Reference Tables (linked above)
• Data > Advanced > User Fields
• Custom Data tables — Data > Advanced > User-Defined Personnel Actions
• Custom fields for organizational reporting —
• Optional User-Defined Reference Tables
• Reporting Levels > Drilldowns (including data templates)
• Reporting Levels > Rollups (Master Plan)

---

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	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
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	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
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	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
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	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