< back

BalanceAAP > File Structure Details / Reference Tables

RETURN TO: Understanding BALANCEaap Data and Reference Tables

Applicant

Field

Reference Name

Data 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 Field Text  

No

 No
Tables

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 TypeLengthRequiredMaster Plan Required
Employee #Text11YesYes
First NameText50NoNo
Last NameText50NoNo
RaceText20 YesYes
GenderText20YesYes
Veteran CodeText5NoNo
Vets DateDate   No No
Job Code Text20YesYes
>Dept Code >Text20NoNo
Hire DateDateNoNo
Referral SourceText50NoNo
Application DateDateNoNo
Plan CodeText 50NoYes
Req Text50NoNo
UserFieldText255NoNo
Drilldown FieldText Yes*Yes*
Rollup FieldText  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 Code

Termination Code

Field Name Data Type Length Required Master Plan Required
Prom CodeText20YesYes
Reason Text50NoNo
UserFieldText255NoNo

Field NameData TypeLengthRequiredMaster Plan Required
Term CodeText20Yes Yes
VoluntaryTrue/False NoNo
ReasonText50No No
UserFieldText255NoNo

Transfer Code

Field NameData TypeLengthRequiredMaster Plan Required
Transfer CodeText20YesYes
ReasonText 50NoNo
UserFieldText255NoNo

Veteran

Field NameData TypeLengthRequiredMaster Plan Required
Veteran CodeText 5YesYes
DescriptionText50NoNo
Vietnam VeteranTrue/FalseNoNo
Special Disabled VeteranTrue/False NoNo
Other VeteranTrue/FalseNoNo
Newly Separated VeteranTrue/FalseNoNo
Service MedalTrue/FalseNoNo

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

No

 No

New Hire

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

Promotion Code

Report Distribution Users

Field Name Data Type Length Required Master Plan Required
Prom CodeText20YesYes
Reason Text50NoNo
UserFieldText255NoNo

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 NameData TypeLengthRequiredMaster Plan Required
Term CodeText20Yes Yes
VoluntaryTrue/False NoNo
ReasonText50No No
UserFieldText255NoNo

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 NameData TypeLengthRequiredMaster Plan Required
Transfer CodeText20YesYes
ReasonText 50NoNo
UserFieldText255NoNo

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 NameData TypeLengthRequiredMaster Plan Required
Veteran CodeText 5YesYes
DescriptionText50NoNo
Vietnam VeteranTrue/FalseNoNo
Special Disabled VeteranTrue/False NoNo
Other VeteranTrue/FalseNoNo
Newly Separated VeteranTrue/FalseNoNo
Service MedalTrue/FalseNoNo

*Note: Drilldown Fields in the Data Tables and a Drilldown reference table is required ONLY if you choose to create drilldown levels.