< 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
    • Other Default and User-Defined Tables
  • Plan Code Reference Table (Master Plan)
  • Data Tables

Reference Tables

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

balanceAAP Help Cross-reference: Custom fields (noted below as: User Field) may be added to a particular Reference or Data table for business-specific needs. See: Data > Advanced > User Fields.

Applicant Disposition

Field Name Data Type Length Required Master Plan Required
Disposition (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
User Field Text 255 No No

Department

Field Name Data Type Length Required Master Plan Required
Department (Dept) Code Text 20 Yes Yes
Dept Name Text 50 No No
Reports To Text 20 No No
Other Location Text 50 No No
User Field Text 255 No No

Grade

Field Name Data Type Length Required Master Plan Required
Grade Text 20 Yes Yes
Salary Midpoint Number 20^ No No
User Field 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
Census Code Description Text 250 No No
Job Family Text 20 No No
Job Family Description Text 255 No No
User Field 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
User Field Text 255 No No

Other Default and User-Defined Tables

Promotion Code

Field Name Data Type Length Required Master Plan Required
Prom(otion) Code Text 20 Yes Yes
Reason Text 50 No No
User Field Text 255 No No

Termination Code

Field Name Data Type Length Required Master Plan Required
Term(ination) Code Text 20 Yes Yes
Voluntary True/False - No No
Reason Text 50 No No
User Field 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
User Field Text 255 No No

Veteran (Legacy table)

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

Drilldown (User-defined)

Field Name Data Type Length Required Master Plan Required
Drilldown Field Text 255 Yes* Yes*
Description Text 255 No No
Zip Code Text 5 No No

Note: If a Drilldown Field is defined (i.e., using the table format above), the column will be added to all Data tables, where entries will be required. Drilldowns that are based on existing system fields will not require a Reference table or an additional column. For more information, refer to: Reporting Levels > Drilldowns.

Rollup (User-defined, Master Plan)

Field Name Data Type Length Required Master Plan Required
Rollup Field Text 255 N/A Yes
Description Text 255 No No
Zip Code Text 5 No No


Plan Code Reference Table (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
City Text 50 No No
State Text >2 No No
County Text 50 No No
Zip Code Number 5 No No
User Field Text 255 No No

Note: If a Rollup Field is defined (i.e., using the table format above), the column will be added to all Data tables. Drilldowns that are based on existing system fields will not require a Reference table or an additional column. For more information, refer to: Reporting Levels > Rollups.

^Number includes two decimal places.