Data Warehouse

AAP_CATEGORY

Descriptive AAP category for workforce analysis.

VARCHAR2

30

AAP_CATEGORY_CODE

Affirmative Action Plan (AAP) category code in effect during the historical period.

VARCHAR2

4

BENEFITS_ELIGIBILITY

Descriptive benefits eligibility status.

VARCHAR2

20

BENEFITS_ELIGIBILITY_CODE

Code indicating benefits eligibility classification during the period.

VARCHAR2

3

COMPENSATE_FREQUENCY

Descriptive compensation frequency.

VARCHAR2

20

COMPENSATE_FREQUENCY_CODE

Code identifying compensation frequency.

VARCHAR2

3

DEFINED_BENEFIT_PLAN_CATEGORY

Descriptive defined benefit plan category.

VARCHAR2

50

DEFINED_BENEFIT_PLAN_CAT_CODE

Code identifying defined benefit plan category.

VARCHAR2

2

EEO_CATEGORY

Descriptive EEO category for historical compliance reporting.

VARCHAR2

30

EEO_CATEGORY_CODE

Equal Employment Opportunity (EEO) category code applicable at the time of the snapshot.

VARCHAR2

3

EMPLOYEE_GROUP

Descriptive employee group.

VARCHAR2

20

EMPLOYEE_GROUP_CODE

Code identifying the employee group.

VARCHAR2

1

EMPLOYEE_SUBGROUP

Descriptive employee subgroup.

VARCHAR2

20

EMPLOYEE_SUBGROUP_CODE

Code identifying the employee subgroup.

VARCHAR2

2

GL_ACCOUNT_ID

General ledger account identifier associated with the job.

VARCHAR2

6

GL_ACCOUNT_NAME

Descriptive general ledger account name.

VARCHAR2

50

HIRING_RANGE_BEGIN_DATE

Effective start date for the hiring range.

DATE

HIRING_RANGE_END_DATE

Effective end date for the hiring range.

DATE

HOURLY_HIRING_MAX

Maximum hourly hiring rate applicable during the historical period.

NUMBER

13,2

HOURLY_HIRING_MIN

Minimum hourly hiring rate applicable during the historical period.

NUMBER

13,2

HR_JOB_FP_KEY

Surrogate key uniquely identifying a historical job record for a specific fiscal period.

VARCHAR2

14

IPEDS_CATEGORY

Descriptive IPEDS category.

VARCHAR2

80

IPEDS_CATEGORY_CODE

IPEDS category code for federal reporting.

VARCHAR2

3

IS_9MOD_FOR_LIFE_INS

Indicator specifying nine-month appointment eligibility for life insurance.

VARCHAR2

1

IS_EXEMPT

Indicator specifying whether the job was exempt from overtime rules.

VARCHAR2

1

JOB_DESCRIPTION_FLAG

Indicator showing whether a formal job description exists.

VARCHAR2

1

JOB_FAMILY

Descriptive name of the job family during the historical period.

VARCHAR2

40

JOB_FAMILY_CODE

Code identifying the job family grouping at the time of the snapshot.

VARCHAR2

3

JOB_ID

Source-system job identifier used to link job records across HR systems.

VARCHAR2

8

JOB_LEVEL

Descriptive job level for the historical period.

VARCHAR2

10

JOB_LEVEL_CODE

Code representing the job level at the time of the snapshot.

VARCHAR2

3

JOB_SUBFAMILY

Descriptive job subfamily name.

VARCHAR2

50

JOB_SUBFAMILY_CODE

Code identifying the job subfamily within the job family.

VARCHAR2

3

JOB_TITLE

Official job title as defined at the time of the historical snapshot.

VARCHAR2

40

JOB_TITLE_UPPERCASE

Job title converted to uppercase for standardized historical matching and reporting.

VARCHAR2

40

JOB_TITLE_WO_SRS

Job title with SRS or special designation text removed, as of the historical period.

VARCHAR2

40

JOB_TRACK

Descriptive job track for the historical snapshot.

VARCHAR2

22

JOB_TRACK_CODE

Code representing the job track in effect for the historical record.

VARCHAR2

3

MAXIMUM_SALARY

Maximum salary amount applicable during the historical period.

NUMBER

11,2

MINIMUM_SALARY

Minimum salary amount applicable during the historical period.

NUMBER

11,2

MIT_JOB_CODE

MIT-specific job classification code applicable during the historical period.

VARCHAR2

12

OCCUPATION_GROUP

Descriptive occupational group classification.

VARCHAR2

100

OCCUPATION_GROUP_CODE

Code identifying the occupational group for compliance reporting.

VARCHAR2

4

PAYROLL_RANK

Descriptive payroll rank associated with the job.

VARCHAR2

30

PAYROLL_RANK_CODE

Code representing payroll rank or hierarchy.

VARCHAR2

3

PAY_GRADE

Descriptive pay grade associated with the job.

VARCHAR2

20

PAY_GRADE_AREA

Descriptive 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

Descriptive pay grade type.

VARCHAR2

20

PAY_GRADE_TYPE_CODE

Code identifying the pay grade type.

VARCHAR2

3

PERSONNEL_AREA

Descriptive personnel area.

VARCHAR2

30

PERSONNEL_AREA_CODE

Code identifying the personnel area.

VARCHAR2

4

PERSONNEL_SUBAREA

Descriptive personnel subarea.

VARCHAR2

20

PERSONNEL_SUBAREA_CODE

Code identifying the personnel subarea.

VARCHAR2

4

RECORD_COUNTER

Sequential counter used for ETL processing and change tracking.

NUMBER

REFERENCE_SALARY

Reference or midpoint salary used for planning and analysis.

NUMBER

11,2

TENURE_STATUS

Descriptive tenure status.

VARCHAR2

20

TENURE_STATUS_CODE

Code indicating tenure eligibility or status.

VARCHAR2

3

TIME_MONTH_KEY

Time dimension key representing the fiscal month of the historical snapshot.

VARCHAR2

6

VACATION_ELIGIBILITY

Descriptive vacation eligibility.

VARCHAR2

50

VACATION_ELIGIBILITY_CODE

Code identifying vacation eligibility classification.

VARCHAR2

2

WAREHOUSE_CLUSTER

Descriptive warehouse reporting cluster name.

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 salary applicable during the historical period.

NUMBER

13,2

YEARLY_HIRING_MIN

Minimum annual hiring salary applicable during the historical period.

NUMBER

13,2