Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse HR APPT TX LIMITED DETAIL Table


DEPRICATED. Pleaase use HR_APT_TX_DETAIL that restricts for limited access. This table contains all the various states of an employee appointments, excluding salary/pay data. This table contains data for appointments that were current as of the conversion to SAP/HR on 8/29/2003.


Field Name

Description

Data Type

Length

APPOINTMENT_WAGE_TYPE

XXX

VARCHAR2

25

APPOINTMENT_WAGE_TYPE_CODE

XXX

VARCHAR2

4

APPT_BEGIN_DATE

Start date for an employee's appointment to a specific MIT position.

DATE

8

APPT_END_DATE

End date for an employee's appointment to a specific MIT position or 12/31/2999 for indefinite end

DATE

8

APPT_TX_BEGIN_DATE

Effective date of a change to an appointment, i.e. salary increase, leave, change in effort, etc.

DATE

8

APPT_TX_END_DATE

This field does not have any business meaning, and will be hidden in the future

DATE

8

HR_APPT_TYPE_KEY

XXX

VARCHAR2

20

HR_JOB_KEY

This field should be used to join HR_POSITION and HR_JOB tables with such fact tables as HR_APPOINTMENT_DETAIL, HR_APPT_TX_DETAIL, and HR_POSITION_DETAIL and their LIMITED versions.

VARCHAR2

10

HR_ORG_UNIT_KEY

This field should be used to join HR_ORG_UNIT and HR_ORG_UNIT_HIERARCHY tables with such fact tables as HR_APPOINTMENT_DETAIL, HR_APPT_TX_DETAIL, and HR_POSITION_DETAIL and their LIMITED versions.

VARCHAR2

8

HR_PERSONNEL_ACTION_TYPE_KEY

This field is used to join HR_PERSONNEL_ACTION_DETAIL table with HR_PERSONNEL_ACTION_TYPE table.

VARCHAR2

4

HR_POSITION_KEY

This field should be used to join HR_POSITION and HR_POSITION_LIMITED tables with such fact tables as HR_APPOINTMENT_DETAIL, HR_APPT_TX_DETAIL, and HR_POSITION_DETAIL and their LIMITED versions.

VARCHAR2

10

IS_SHIFT_ELIGIBLE

Is this a shift type of position, Y or N

VARCHAR2

1

LAST_UPDATE_DATE

Date the description was created or last altered.

DATE

8

LAST_UPDATE_USER

Last person that changed this 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_EMPLOYMENT_PERCENT

Percent effort based on normal working hours. For Faculty and exempt staff, 100% represents full time effort. For Support staff, it is normal work hours divided by # of hours in work schedule rule

NUMBER

7.4

ORIGINAL_FTE_PERCENT_EFFORT

Percent effort based on normal working hours. For Faculty 100% represents full time effort. For Support and Service staff, 100% represents a 35, 37.5 or 40 hour work week.

NUMBER

7.4

ORIGINAL_WORK_WEEK

Normal weekly hours for hourly paid employees only. This is 0 for monthly paid employees.

NUMBER

4.2

PAY_BASIS

Description of the timeframe for this appointment, eg. 09 months, 12 months, fall (9/1 to 1/15), temporary (< 12 months), etc.

VARCHAR2

50

PAY_BASIS_CODE

Code specifying the number of months or timeframe for this appointment, eg. 09 (for 9 months), 12 (for 12 months), fall (for 9/1 to 1/15), temp (for < 12 months), etc.

VARCHAR2

7

PAY_BASIS_NUMBER_OF_MONTHS

The actual mumber of months for a particular appointment. Examples: 12 months = 12.0, 9 months = 9.0, fall = 5.0, temporary = 12.0, etc.

NUMBER

2

PERSONNEL_KEY

Key field used to join to the PERSONNEL table. This field should only be used for joining data, NOT for reporting.

VARCHAR2

8

RECORD_COUNTER

Used to count records within a group on a report. Always contains a value of 1.

NUMBER

1

REPORT_EMPLOYMENT_PERCENT

Same as Original Employment Percent unless the person has a temporary change in effort, up or down, in which case this field will show the percent based on the temporary change.

NUMBER

7.4

REPORT_FTE_PERCENT_EFFORT

Current percent effort based on normal working hours. For Faculty, 100% represents full time effort. For Support and Service staff, 100% represents a 40 hour work week. If there is a temporary change FTE percent effort amount, it will appear in this field, otherwise the field wil display the original fte percent effort.

NUMBER

7.4

REPORT_WORK_WEEK

Current normal weekly hours for hourly paid employees only. This is 0 for monthly paid employees. If there is a temporary change work week, it will appear in this field, otherwise the field will display the original work week.

NUMBER

4.2

TEMP_CHANGE_EMPLOYMENT_PERCENT

XXX

NUMBER

7.4

TEMP_CHANGE_FTE_PERCENT_EFFORT

Temporary percent effort based on normal working hours. For Faculty 100% represents full time effort. For Support and Service staff, 100% represents a 35, 37.5 or 40 hour work week.

NUMBER

7.4

TEMP_CHANGE_REASON

Description of the temporary action reason, e.g., leave of absence, extended sick leave

VARCHAR2

100

TEMP_CHANGE_REASON_CODE

Code for temporary action reason, e.g., LOA, ESL

VARCHAR2

2

TEMP_CHANGE_WORK_WEEK

Temporary normal weekly hours for hourly paid employees only. This is 0 for monthly paid employees.

NUMBER

4.2

WAREHOUSE_LOAD_DATE

The date the record was loaded into the Data Warehouse from the source system.

DATE

8

WORKING_WEEK

Normal weekly hours

VARCHAR2

100

WORKING_WEEK_CODE

Code for normal weekly hours

VARCHAR2

2

WORK_SCHEDULE_RULE

Code specifying the number of normal hours for the job, e.g., 35_WW

VARCHAR2

8