File Structure Details / Reference Tables

+ More

Reference Tables Details

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.

Primary Data Tables

Applicant Disposition

Field Name	Data Type	Length	Required	MP 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	MP 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	MP 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	MP 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
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	MP 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	MP 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	MP 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	MP 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	MP 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	MP 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.

table reference structure overview