Data Warehouse

APPT_BEGIN_DATE

Appointment begin date.

DATE

APPT_END_DATE

Appointment end date.

DATE

APPT_WAGE_TYPE

Appointment wage type description.

VARCHAR2

25

APPT_WAGE_TYPE_CODE

Appointment wage type code.

VARCHAR2

4

APPT_WORK_BEGIN_DATE

Work begin date associated with the appointment (as defined by source).

DATE

APPT_WORK_END_DATE

Work end date associated with the appointment (as defined by source).

DATE

FTE_ORIGINAL_BASE_AMOUNT

Original base amount adjusted for FTE (as defined by source).

NUMBER

FTE_REPORT_BASE_AMOUNT

Reported base amount adjusted for FTE (as defined by source).

NUMBER

FTE_TEMP_CHANGE_BASE_AMOUNT

Temporary change base amount adjusted for FTE (as defined by source).

NUMBER

HR_APPT_KEY

Appointment identifier/key (as defined by source).

NUMBER

HR_APPT_TYPE_KEY

Surrogate key identifying the appointment type.

VARCHAR2

20

HR_JOB_KEY

Surrogate key identifying the HR job.

VARCHAR2

47

HR_ORG_UNIT_KEY

Surrogate key identifying the HR organizational unit.

VARCHAR2

10

HR_POSITION_KEY

Surrogate key identifying the HR position.

VARCHAR2

10

IS_MOST_RECENT_APPT

Indicator identifying whether this is the most recent appointment record (Y/N).

VARCHAR2

1

IS_SHIFT_ELIGIBLE

Indicator identifying whether the appointment is shift eligible (Y/N).

VARCHAR2

1

LAST_UPDATE_DATE

Date the appointment record was last updated.

DATE

LAST_UPDATE_USER

User identifier of the last updater of the appointment record.

VARCHAR2

12

MIT_ID

MIT ID number of the person. Use this field to join with other tables containing data about people at MIT.

VARCHAR2

9

ORIGINAL_BASE_AMOUNT

Original base salary/amount prior to temporary changes (as defined by source).

NUMBER

ORIGINAL_EMPLOYMENT_PERCENT

Original employment percent prior to temporary changes (as defined by source).

NUMBER

17,8

ORIGINAL_FTE_PERCENT_EFFORT

Original FTE percent effort prior to temporary changes (as defined by source).

NUMBER

13,6

ORIGINAL_HOURLY_RATE

Original hourly rate prior to temporary changes (as defined by source).

NUMBER

ORIGINAL_PERIOD_AMOUNT

Original period amount prior to temporary changes (as defined by source).

NUMBER

ORIGINAL_WORK_WEEK

Original work week measure prior to temporary changes (as defined by source).

NUMBER

5,2

PAY_BASIS

Pay basis description associated with the appointment.

VARCHAR2

50

PAY_BASIS_CODE

Pay basis code associated with the appointment.

VARCHAR2

7

PAY_BASIS_NUMBER_OF_MONTHS

Number of months associated with the pay basis (as defined by source).

NUMBER

PERSONNEL_KEY

Surrogate key identifying the personnel record associated with the appointment.

VARCHAR2

8

RECORD_COUNTER

Record counter used for ETL control or auditing.

NUMBER

REPORT_BASE_AMOUNT

Reported base salary/amount for the appointment.

NUMBER

REPORT_EMPLOYMENT_PERCENT

Reported employment percent for the appointment.

NUMBER

REPORT_FTE_PERCENT_EFFORT

Reported FTE percent effort for the appointment.

NUMBER

REPORT_HOURLY_RATE

Reported hourly rate for the appointment (if applicable).

NUMBER

REPORT_PERIOD_AMOUNT

Reported period amount for the appointment (as defined by source).

NUMBER

REPORT_WORK_WEEK

Reported work week measure (e.g., hours/week) for the appointment.

NUMBER

TEMP_CHANGE_BASE_AMOUNT

Temporary change base amount (as defined by source).

NUMBER

TEMP_CHANGE_EMPLOYMENT_PERCENT

Temporary change employment percent (as defined by source).

NUMBER

17,8

TEMP_CHANGE_FTE_PERCENT_EFFORT

Temporary change FTE percent effort (as defined by source).

NUMBER

13,6

TEMP_CHANGE_HOURLY_RATE

Temporary change hourly rate (as defined by source).

NUMBER

TEMP_CHANGE_PERIOD_AMOUNT

Temporary change period amount (as defined by source).

NUMBER

TEMP_CHANGE_REASON

Description of the reason for a temporary change.

VARCHAR2

100

TEMP_CHANGE_REASON_CODE

Code identifying the reason for a temporary change.

VARCHAR2

2

TEMP_CHANGE_WORK_WEEK

Temporary change work week measure (as defined by source).

NUMBER

5,2

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE

WORKING_WEEK

Working week description associated with the appointment.

VARCHAR2

100

WORKING_WEEK_CODE

Working week code associated with the appointment.

VARCHAR2

2

WORK_SCHEDULE_RULE

Work schedule rule identifier (as defined by source).

VARCHAR2

8

WORK_SCHEDULE_RULE_DESCRIPTION

Description of the work schedule rule.

VARCHAR2

40

YRS_IN_POSITION

Years in position (as defined by source).

NUMBER