< back

BalanceAAP > File Structure Details / Reference Tables

RETURN TO: Understanding BALANCEaap Data and Reference Tables

Applicant

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