< back

BalanceAAP > File Structure Details / Reference Tables

RETURN TO: Understanding BALANCEaap Data Import Requirements

KEY TOPICS:

  • Reference Tables
    • Applicant Disposition
    • Department
    • Grade
    • Job Code
    • Job Group
    • Plan Code (Master Plan)
    • Promotion Code
    • Termination Code
    • Transfer Code
    • Veteran
  • 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