< back

BalanceAAP > File Structure Details / Reference Tables

RETURN TO: Understanding BALANCEaap Data Import Requirements

KEY TOPICS:

  • Reference Tables
  • Data Tables

Reference Tables

The term "Required," as shown in the column headers below, refers to a system requirement for operation.

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 4 No No
Job Family Text 20 No No
Job Family Description Text 255 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

Plan Code (Master Plan)

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 Code

Promotion Code Reason
CP Competitive
NP Natural Progression

Termination 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

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

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

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 (Master Plan only)

Field Name Data Type Length Required Master Plan Required
Rollup Field Text No No
Description Text No No
Zip Code Text No No


Data Tables

Applicant

Field NameData TypeLength Required Master Plan Required
Applicant No Text11No No
First NameText50NoNo
Last NameText50No No
Race CodeText20NoNo
Gender CodeText20 NoNo
Job Code Text20 YesYes
Dept CodeText20NoNo
Disp Code Text20 YesYes
Hire DateDate NoNo
Application DateDate NoNo
ReqText50NoNo
Referral Source Text50No No
Plan CodeText 20NoNo
UserField Text255NoNo
Drilldown FieldText  Yes*Yes*
Rollup FieldText NoNo

New Hire

Field Name Data TypeLengthRequiredMaster Plan Required
Employee #Text11YesYes
First NameText50NoNo
Last NameText50NoNo
RaceText20 YesYes
GenderText20YesYes
Veteran CodeText5NoNo
Vets DateDate NoNo
Job Code Text20YesYes
Dept Code Text20NoNo
Hire DateDateNoNo
Referral SourceText50NoNo
Application DateDateNoNo
Plan CodeText 50NoYes
Req Text50NoNo
UserFieldText255NoNo
Drilldown FieldText Yes*Yes*
Rollup FieldText NoNo

Promotion

Field NameData TypeLengthRequiredMaster Plan Required
Employee #Text11YesYes
First NameText50NoNo
Last NameText50No No
RaceText20YesYes
GenderText20YesYes
Old Job Code Text20YesYes
New Job CodeText20YesYes
Old Dept CodeText20NoNo
New Dept CodeText20NoNo
Prom CodeText20NoNo
Prom DateDateNoNo
Plan Code Text50NoYes
Promotion IDText20NoNo
UserFieldText255NoNo
Drilldown Field Text  Yes*Yes*
Rollup FieldText  No No

Promotion Pool

Field NameData TypeLengthRequiredMaster Plan Required
Employee #Text11YesYes
First NameText50NoNo
Last NameText50No No
RaceText20YesYes
GenderText20YesYes
Old Job CodeText20YesYes
New Job CodeText20YesYes
Old Dept CodeText20NoNo
New Dept CodeText20NoNo
Plan CodeText50NoYes
Promotion IDText20Yes No
UserFieldText255NoNo
Drilldown FieldText   Yes* Yes*
Rollup FieldText NoNo

Report Distribution Users

Field NameData TypeLengthRequiredMaster Plan Required
Email AddressText2500YesYes
First NameText50YesYes
Last NameText50YesYes
Publish GroupText50No No
Plan CodeText50NoNo

Roster

Field NameData TypeLengthRequiredMaster Plan Required
Employee #Text11 YesYes
First NameText50NoNo
Last NameText50NoNo
RaceText20YesYes
GenderText 20YesYes
Job Code Text20YesYes
Department CodeText20Yes Yes
Hire DateDateNoNo
Annualized SalaryNumberNoNo
Starting SalaryNumberNoNo
Reports InTrue/FalseNoNo
Reports Out True/FalseNoNo
Annotation OnlyTrue/False NoNo
Work LocationText50NoNo
Report LocationText50NoNo
Reports to PlanText50NoNo
Plan CodeText50NoYes
SupervisorTrue/FalseNoNo
Supervisor Emp #Text11NoNo
IWDTrue/False NoNo
Veteran CodeText 5NoNo
VETS DateDateNoNo
Work Zip Code Text  No No
Home Zip Code Text  NoNo
Protected VeteranTrue/FalseNoNo
UserFieldText255NoNo
Drilldown FieldText  Yes* Yes*
Rollup FieldText NoNo

Termination

Field NameData TypeLengthRequiredMaster Plan Required
Employee #Text11YesYes
First NameText50NoNo
Last NameText50 NoNo
RaceText 20YesYes
Gender Text20YesYes
Job CodeText20Yes Yes
Dept Code Text 20NoNo
Term CodeText 20YesYes
Term Date DateNo No
Plan CodeText50NoYes
Termination IDText 20No No
UserFieldText255NoNo
Drilldown Field Text Yes*Yes*
Rollup FieldText  NoNo

Termination Pool

Field Name Data TypeLength RequiredMaster Plan Required
Employee # Text11 YesYes
First Name Text50NoNo
Last NameText50No No
RaceText 20YesYes
GenderText20 YesYes
Job Code Text20YesYes

Dept Code

Text20NoNo
Plan CodeText50No Yes
Termination ID Text 20 Yes

No

UserFieldText255NoNo
Drilldown Field Text  Yes*Yes*
Rollup Field Text  No No

Transfer

Field NameData TypeLengthRequiredMaster Plan Required
Employee #Text 11YesYes
First NameText50NoNo
Last NameText50NoNo
RaceText20YesYes
GenderText20YesYes
Old Job CodeText20YesYes
New Job CodeText20YesYes
Old Dept CodeText20NoNo
New Dept CodeText20NoNo
Transfer CodeText 20NoNo
Transfer DateDateNoNo
Plan CodeText50No Yes
UserField Text255 No No
Drilldown Field Text  Yes* Yes*
Rollup FieldText  NoNo

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.