< back

BalanceAAP > File Structure Details / Data Tables

Data 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

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

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

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
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
IWD	True/False		No	No
Veteran Code	Text	5	No	No
VETS Date	Date		No	No
Work Zip Code	Text		No	No
Home Zip Code	Text		No	No
Protected Veteran	True/False		No	No
UserField	Text	255	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

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

Note: Drilldown fields on Data tables, as displayed above, are required by the system ONLY if you include a Drilldown Reference table (as outlined above). These fields are marked with an (*) asterisk.