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

APPT_TX_WORK_BEGIN_DATE

Transaction work begin date (as defined by source).

DATE

APPT_TX_WORK_END_DATE

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

FOREIGN_FELLOWSHIP_FLAG

Indicator identifying whether the appointment is associated with a foreign fellowship (Y/N).

VARCHAR2

1

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_TX_KEY

Appointment transaction identifier/key (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 associated with the transaction.

VARCHAR2

4

HR_POSITION_KEY

Surrogate key identifying the HR position.

VARCHAR2

10

IS_APPT_FINAL_STATE_SEGMENT

Indicator identifying whether this transaction segment is in a final state (Y/N).

VARCHAR2

1

IS_CURRENT_APPOINTMENT_TX

Indicator identifying whether this transaction segment is the current appointment transaction (Y/N).

VARCHAR2

1

IS_OFF_CAMPUS

Indicator identifying whether the appointment is off campus (Y/N).

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

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

PERSONNEL_KEY

Surrogate key identifying the personnel record associated with the appointment transaction.

VARCHAR2

8

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

SUPPLEMENT_TYPE

Supplement type description associated with the transaction.

VARCHAR2

30

SUPPLEMENT_TYPE_CODE

Supplement type code associated with the transaction (as defined by source).

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

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

VARCHAR2

100

WORKING_WEEK_CODE

Working week code associated with the appointment transaction.

VARCHAR2

2

WORK_SCHEDULE_RULE

Work schedule rule identifier (as defined by source).

VARCHAR2

8