Data Warehouse

APPOINTMENT_WAGE_TYPE

Appointment wage type description.

VARCHAR2

25

APPOINTMENT_WAGE_TYPE_CODE

Appointment wage type code.

VARCHAR2

4

APPT_BEGIN_DATE

Appointment begin date associated with the transaction record.

DATE

APPT_END_DATE

Appointment end date associated with the transaction record.

DATE

APPT_TX_BEGIN_DATE

Transaction begin date for the appointment transaction segment.

DATE

APPT_TX_END_DATE

Transaction end date for the appointment transaction segment.

DATE

HR_APPT_TYPE_KEY

Surrogate key identifying the appointment type.

VARCHAR2

20

HR_JOB_KEY

Surrogate key identifying the HR job.

VARCHAR2

10

HR_ORG_UNIT_KEY

Surrogate key identifying the HR organizational unit.

VARCHAR2

10

HR_PERSONNEL_ACTION_TYPE_KEY

Surrogate key identifying the personnel action type associated with the transaction.

VARCHAR2

4

HR_POSITION_KEY

Surrogate key identifying the HR position.

VARCHAR2

10

IS_ON_MAP

Indicator identifying whether the appointment transaction is on MAP (as defined by source).

VARCHAR2

1

IS_SHIFT_ELIGIBLE

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

VARCHAR2

1

LAST_UPDATE_DATE

Date the transaction record was last updated.

DATE

LAST_UPDATE_USER

User identifier of the last updater of the transaction 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 amount prior to temporary changes (as defined by source).

NUMBER

15,2

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

13,2

ORIGINAL_PERIOD_AMOUNT

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

NUMBER

18,6

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 transaction.

VARCHAR2

50

PAY_BASIS_CODE

Pay basis code associated with the appointment transaction.

VARCHAR2

7

PAY_BASIS_NUMBER_OF_MONTHS

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

NUMBER

PREMIUM_CODE

Premium code associated with the appointment transaction (as defined by source).

VARCHAR2

2

RECORD_COUNTER

Record counter used for ETL control or auditing.

NUMBER

REPORT_BASE_AMOUNT

Reported base salary/amount for the appointment transaction segment.

NUMBER

REPORT_EMPLOYMENT_PERCENT

Reported employment percent for the appointment transaction segment.

NUMBER

REPORT_FTE_PERCENT_EFFORT

Reported FTE percent effort for the appointment transaction segment.

NUMBER

REPORT_HOURLY_RATE

Reported hourly rate for the appointment transaction segment (if applicable).

NUMBER

REPORT_PERIOD_AMOUNT

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

NUMBER

REPORT_WORK_WEEK

Reported work week measure for the appointment transaction segment (as defined by source).

NUMBER

TEMP_CHANGE_BASE_AMOUNT

Temporary change base amount (as defined by source).

NUMBER

15,2

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

13,2

TEMP_CHANGE_PERIOD_AMOUNT

Temporary change period amount (as defined by source).

NUMBER

13,2

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 transaction.

VARCHAR2

100

WORKING_WEEK_CODE

Working week code associated with the appointment transaction.

VARCHAR2

2

WORK_BEGIN_MMDD

Work begin month/day (MMDD) value associated with the appointment transaction (as defined by source).

VARCHAR2

4

WORK_END_MMDD

Work end month/day (MMDD) value associated with the appointment transaction (as defined by source).

VARCHAR2

4

WORK_SCHEDULE_RULE

Work schedule rule identifier (as defined by source).

VARCHAR2

8