BALANCEaap > File Structure Details / Reference Tables

RETURN TO: Understanding BALANCEaap Data Import Requirements

KEY TOPICS:

RELATED TOPIC:


Reference Tables

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

Fields in italic below are placeholders for special data. For a list of Help resources on this topic, see: Custom Data Capabilities.

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
Dep(ar)t(ment) Code Text 20 Yes Yes
Dept Name Text 50 No No
Reports To Text 20 No No
Other Location Text 100 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 50 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
~ If an AAP is created with the IPEDS Schedule, this Field Name will be IPEDS Code.

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



Plan Code Reference Table (Master Plan)

Note: Once Plan Codes exist in the system, this information can be accessed by selecting Plan Codes from the side navigation menu.

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

^Number includes two decimal places.