< back

BalanceAAP > File Structure Details / Reference Tables

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
New 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
Prom ~~UserField~~ Code	Text	~~255~~ 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 Text	~~Yes~~ 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.