Data Warehouse

ACTION_AMOUNT

Amount associated with the personnel action (as defined by source).

NUMBER

ACTION_LAST_UPDATE_DATE

Last update date for the personnel action record (as defined by source).

DATE

ACTION_LAST_UPDATE_USER

User identifier of the last updater of the personnel action record (as defined by source).

VARCHAR2

12

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 action record.

DATE

APPT_END_DATE

Appointment end date associated with the action record.

DATE

APPT_LAST_UPDATE_DATE

Last update date for the appointment record associated with the action.

DATE

APPT_LAST_UPDATE_USER

User identifier of the last updater of the appointment record associated with the action.

VARCHAR2

12

APPT_SUBTYPE

Appointment subtype description associated with the personnel action.

VARCHAR2

100

APPT_SUBTYPE_CODE

Appointment subtype code associated with the personnel action.

VARCHAR2

4

APPT_TX_BEGIN_DATE

Appointment transaction begin date (as defined by source).

DATE

APPT_TX_END_DATE

Appointment transaction end date (as defined by source).

DATE

APPT_TX_WORK_BEGIN_DATE

Appointment transaction work begin date (as defined by source).

DATE

APPT_TX_WORK_END_DATE

Appointment transaction work end date (as defined by source).

DATE

APPT_WORK_BEGIN_DATE

Appointment work begin date (as defined by source).

DATE

APPT_WORK_END_DATE

Appointment work end date (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_TX_KEY

Identifier/key for the appointment transaction record associated with the personnel action (as defined by source).

VARCHAR2

50

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.

VARCHAR2

4

HR_POSITION_KEY

Surrogate key identifying the HR position.

VARCHAR2

10

IS_SHIFT_ELIGIBLE

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

VARCHAR2

1

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

ORIGINAL_EMPLOYMENT_PERCENT

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

NUMBER

7,4

ORIGINAL_FTE_PERCENT_EFFORT

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

NUMBER

7,4

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/personnel action.

VARCHAR2

50

PAY_BASIS_CODE

Pay basis code associated with the appointment/personnel action.

VARCHAR2

7

PAY_BASIS_NUMBER_OF_MONTHS

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

NUMBER

PERSONNEL_ACTION_DATE

Effective date of the personnel action (as defined by source).

DATE

PERSONNEL_ACTION_SEQ_NUMBER

Sequence number of the personnel action within the effective date (as defined by source).

VARCHAR2

3

PERSONNEL_KEY

Surrogate key identifying the personnel record associated with the personnel action.

VARCHAR2

8

RECORD_COUNTER

Record counter used for ETL control or auditing.

NUMBER

REPORT_BASE_AMOUNT

Reported base salary/amount for the appointment at the time of the action.

NUMBER

REPORT_EMPLOYMENT_PERCENT

Reported employment percent at the time of the action.

NUMBER

REPORT_FTE_PERCENT_EFFORT

Reported FTE percent effort at the time of the action.

NUMBER

REPORT_HOURLY_RATE

Reported hourly rate for the appointment at the time of the action (if applicable).

NUMBER

REPORT_PERIOD_AMOUNT

Reported period amount for the appointment at the time of the action.

NUMBER

REPORT_WORK_WEEK

Reported work week measure at the time of the action (as defined by source).

NUMBER

SUPPLEMENT_TYPE

Supplement type description associated with the appointment/personnel action.

VARCHAR2

30

SUPPLEMENT_TYPE_CODE

Supplement type code associated with the appointment/personnel action.

VARCHAR2

2

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

7,4

TEMP_CHANGE_FTE_PERCENT_EFFORT

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

NUMBER

7,4

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/personnel action.

VARCHAR2

100

WORKING_WEEK_CODE

Working week code associated with the appointment/personnel action.

VARCHAR2

2

WORK_SCHEDULE_RULE

Work schedule rule identifier (as defined by source).

VARCHAR2

8