Data Warehouse

AAP_CATEGORY

Description of the Affirmative Action Program category.

VARCHAR2

30

AAP_CATEGORY_CODE

Code identifying the Affirmative Action Program category.

VARCHAR2

4

BENEFITS_ELIGIBILITY

Description of benefits eligibility.

VARCHAR2

20

BENEFITS_ELIGIBILITY_CODE

Code identifying benefits eligibility for the job.

VARCHAR2

3

COMPENSATE_FREQUENCY

Description of the compensation frequency.

VARCHAR2

20

COMPENSATE_FREQUENCY_CODE

Code identifying the compensation frequency.

VARCHAR2

3

DEFINED_BENEFIT_PLAN_CATEGORY

Description of the defined benefit plan category.

VARCHAR2

50

DEFINED_BENEFIT_PLAN_CAT_CODE

Code identifying the defined benefit plan category.

VARCHAR2

2

EEO_CATEGORY

Description of the EEO category.

VARCHAR2

30

EEO_CATEGORY_CODE

Code identifying the EEO category for compliance reporting.

VARCHAR2

3

EMPLOYEE_GROUP

Description of the employee group.

VARCHAR2

20

EMPLOYEE_GROUP_CODE

Code identifying the employee group.

VARCHAR2

1

EMPLOYEE_SUBGROUP

Description of the employee subgroup.

VARCHAR2

20

EMPLOYEE_SUBGROUP_CODE

Code identifying the employee subgroup.

VARCHAR2

2

EMPLOYEE_TYPE

Employee type associated with the job (e.g., faculty, staff).

VARCHAR2

30

GL_ACCOUNT_ID

General ledger account identifier associated with the job.

VARCHAR2

6

GL_ACCOUNT_NAME

Name of the general ledger account associated with the job.

VARCHAR2

50

HIRING_RANGE_BEGIN_DATE

Start date of the hiring salary range.

DATE

HIRING_RANGE_END_DATE

End date of the hiring salary range.

DATE

HOURLY_HIRING_MAX

Maximum hourly hiring rate.

NUMBER

13,2

HOURLY_HIRING_MIN

Minimum hourly hiring rate.

NUMBER

13,2

HR_JOB_KEY

Surrogate key uniquely identifying a job record in HR systems.

VARCHAR2

10

IPEDS_CATEGORY

Description of the IPEDS reporting category.

VARCHAR2

80

IPEDS_CATEGORY_CODE

Code identifying the IPEDS reporting category.

VARCHAR2

3

IS_9MOD_FOR_LIFE_INS

Indicator specifying eligibility for nine-month life insurance coverage (Y/N).

VARCHAR2

1

IS_EXEMPT

Indicator specifying whether the job is exempt from overtime (Y/N).

VARCHAR2

1

JOB_BEGIN_DATE

Effective start date of the job definition.

DATE

JOB_DESCRIPTION_FLAG

Indicator specifying whether a formal job description exists (Y/N).

VARCHAR2

1

JOB_END_DATE

Effective end date of the job definition, if applicable.

DATE

JOB_FAMILY

Description of the job family.

VARCHAR2

40

JOB_FAMILY_CODE

Code identifying the job family.

VARCHAR2

3

JOB_ID

Source-system job identifier.

VARCHAR2

8

JOB_LEVEL

Description of the job level.

VARCHAR2

10

JOB_LEVEL_CODE

Code identifying the job level.

VARCHAR2

3

JOB_SUBFAMILY

Description of the job subfamily.

VARCHAR2

50

JOB_SUBFAMILY_CODE

Code identifying the job subfamily.

VARCHAR2

3

JOB_TITLE

Standard job title.

VARCHAR2

40

JOB_TITLE_LONG

Extended or long-form job title description.

VARCHAR2

50

JOB_TITLE_UPPERCASE

Uppercase version of the job title for standardized matching and search.

VARCHAR2

40

JOB_TITLE_WO_SRS

Job title without seniority or rank suffixes.

VARCHAR2

40

JOB_TRACK

Description of the job track.

VARCHAR2

22

JOB_TRACK_CODE

Code identifying the job track (e.g., academic, research).

VARCHAR2

3

MAXIMUM_SALARY

Maximum annual salary for the job.

NUMBER

11,2

MINIMUM_SALARY

Minimum annual salary for the job.

NUMBER

11,2

MIT_JOB_CODE

MIT-specific job code associated with the position.

VARCHAR2

12

OCCUPATION_GROUP

Description of the occupation group.

VARCHAR2

100

OCCUPATION_GROUP_CODE

Code identifying the occupation group for reporting.

VARCHAR2

4

PAYROLL_RANK

Description of the payroll rank.

VARCHAR2

30

PAYROLL_RANK_CODE

Code identifying the payroll rank.

VARCHAR2

3

PAY_GRADE

Description of the pay grade.

VARCHAR2

20

PAY_GRADE_AREA

Description of the pay grade area.

VARCHAR2

20

PAY_GRADE_AREA_CODE

Code identifying the pay grade area.

VARCHAR2

3

PAY_GRADE_CODE

Code identifying the pay grade.

VARCHAR2

8

PAY_GRADE_TYPE

Description of the pay grade type.

VARCHAR2

20

PAY_GRADE_TYPE_CODE

Code identifying the pay grade type.

VARCHAR2

3

PERSONNEL_AREA

Description of the personnel area.

VARCHAR2

30

PERSONNEL_AREA_CODE

Code identifying the personnel area for the job.

VARCHAR2

4

PERSONNEL_SUBAREA

Description of the personnel subarea.

VARCHAR2

20

PERSONNEL_SUBAREA_CODE

Code identifying the personnel subarea for the job.

VARCHAR2

4

RECORD_COUNTER

System-generated counter used to distinguish multiple versions of job records.

NUMBER

REFERENCE_SALARY

Reference or midpoint salary for the job.

NUMBER

11,2

TENURE_STATUS

Description of tenure status.

VARCHAR2

20

TENURE_STATUS_CODE

Code identifying tenure status associated with the job.

VARCHAR2

3

VACATION_ELIGIBILITY

Description of vacation eligibility.

VARCHAR2

50

VACATION_ELIGIBILITY_CODE

Code identifying vacation eligibility.

VARCHAR2

2

WAREHOUSE_CLUSTER

Description of the warehouse reporting cluster.

VARCHAR2

30

WAREHOUSE_CLUSTER_CODE

Code identifying the warehouse reporting cluster.

VARCHAR2

5

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE

YEARLY_HIRING_MAX

Maximum annual hiring rate.

NUMBER

13,2

YEARLY_HIRING_MIN

Minimum annual hiring rate.

NUMBER

13,2