HR APPT TX DETAIL Table
View exposing detailed appointment transaction records including appointment dates, personnel action type, pay basis, compensation measures, effort measures, and work schedule attributes used for workforce transaction reporting.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
APPOINTMENT_WAGE_TYPE |
Column APPOINTMENT_WAGE_TYPE. |
VARCHAR2 |
25 |
APPOINTMENT_WAGE_TYPE_CODE |
Column APPOINTMENT_WAGE_TYPE_CODE. |
VARCHAR2 |
4 |
APPT_BEGIN_DATE |
Column APPT_BEGIN_DATE. |
DATE |
|
APPT_END_DATE |
Column APPT_END_DATE. |
DATE |
|
APPT_TX_BEGIN_DATE |
Column APPT_TX_BEGIN_DATE. |
DATE |
|
APPT_TX_END_DATE |
Column APPT_TX_END_DATE. |
DATE |
|
APPT_TX_WORK_BEGIN_DATE |
Column APPT_TX_WORK_BEGIN_DATE. |
DATE |
|
APPT_TX_WORK_END_DATE |
Column APPT_TX_WORK_END_DATE. |
DATE |
|
APPT_WORK_BEGIN_DATE |
Column APPT_WORK_BEGIN_DATE. |
DATE |
|
APPT_WORK_END_DATE |
Column APPT_WORK_END_DATE. |
DATE |
|
FOREIGN_FELLOWSHIP_FLAG |
Column FOREIGN_FELLOWSHIP_FLAG. |
VARCHAR2 |
1 |
FTE_ORIGINAL_BASE_AMOUNT |
Column FTE_ORIGINAL_BASE_AMOUNT. |
NUMBER |
|
FTE_REPORT_BASE_AMOUNT |
Column FTE_REPORT_BASE_AMOUNT. |
NUMBER |
|
FTE_TEMP_CHANGE_BASE_AMOUNT |
Column FTE_TEMP_CHANGE_BASE_AMOUNT. |
NUMBER |
|
HR_APPT_KEY |
Column HR_APPT_KEY. |
NUMBER |
|
HR_APPT_TX_KEY |
Column HR_APPT_TX_KEY. |
VARCHAR2 |
50 |
HR_APPT_TYPE_KEY |
Column HR_APPT_TYPE_KEY. |
VARCHAR2 |
20 |
HR_JOB_KEY |
Column HR_JOB_KEY. |
VARCHAR2 |
10 |
HR_ORG_UNIT_KEY |
Column HR_ORG_UNIT_KEY. |
VARCHAR2 |
10 |
HR_PERSONNEL_ACTION_TYPE_KEY |
Column HR_PERSONNEL_ACTION_TYPE_KEY. |
VARCHAR2 |
4 |
HR_POSITION_KEY |
Column HR_POSITION_KEY. |
VARCHAR2 |
10 |
IS_APPT_FINAL_STATE_SEGMENT |
Column IS_APPT_FINAL_STATE_SEGMENT. |
VARCHAR2 |
1 |
IS_CURRENT_APPOINTMENT_TX |
Column IS_CURRENT_APPOINTMENT_TX. |
VARCHAR2 |
1 |
IS_OFF_CAMPUS |
Column IS_OFF_CAMPUS. |
VARCHAR2 |
1 |
IS_SHIFT_ELIGIBLE |
Column IS_SHIFT_ELIGIBLE. |
VARCHAR2 |
1 |
LAST_UPDATE_DATE |
Column LAST_UPDATE_DATE. |
DATE |
|
LAST_UPDATE_USER |
Column LAST_UPDATE_USER. |
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 |
Column ORIGINAL_BASE_AMOUNT. |
NUMBER |
|
ORIGINAL_EMPLOYMENT_PERCENT |
Column ORIGINAL_EMPLOYMENT_PERCENT. |
NUMBER |
17,8 |
ORIGINAL_FTE_PERCENT_EFFORT |
Column ORIGINAL_FTE_PERCENT_EFFORT. |
NUMBER |
13,6 |
ORIGINAL_HOURLY_RATE |
Column ORIGINAL_HOURLY_RATE. |
NUMBER |
|
ORIGINAL_PERIOD_AMOUNT |
Column ORIGINAL_PERIOD_AMOUNT. |
NUMBER |
|
ORIGINAL_WORK_WEEK |
Column ORIGINAL_WORK_WEEK. |
NUMBER |
5,2 |
PAY_BASIS |
Column PAY_BASIS. |
VARCHAR2 |
50 |
PAY_BASIS_CODE |
Column PAY_BASIS_CODE. |
VARCHAR2 |
7 |
PAY_BASIS_NUMBER_OF_MONTHS |
Column PAY_BASIS_NUMBER_OF_MONTHS. |
NUMBER |
|
PERSONNEL_KEY |
Column PERSONNEL_KEY. |
VARCHAR2 |
8 |
RECORD_COUNTER |
Column RECORD_COUNTER. |
NUMBER |
|
REPORT_BASE_AMOUNT |
Column REPORT_BASE_AMOUNT. |
NUMBER |
|
REPORT_EMPLOYMENT_PERCENT |
Column REPORT_EMPLOYMENT_PERCENT. |
NUMBER |
|
REPORT_FTE_PERCENT_EFFORT |
Column REPORT_FTE_PERCENT_EFFORT. |
NUMBER |
|
REPORT_HOURLY_RATE |
Column REPORT_HOURLY_RATE. |
NUMBER |
|
REPORT_PERIOD_AMOUNT |
Column REPORT_PERIOD_AMOUNT. |
NUMBER |
|
REPORT_WORK_WEEK |
Column REPORT_WORK_WEEK. |
NUMBER |
|
SUPPLEMENT_TYPE |
Column SUPPLEMENT_TYPE. |
VARCHAR2 |
30 |
SUPPLEMENT_TYPE_CODE |
Column SUPPLEMENT_TYPE_CODE. |
VARCHAR2 |
2 |
TEMP_CHANGE_BASE_AMOUNT |
Column TEMP_CHANGE_BASE_AMOUNT. |
NUMBER |
|
TEMP_CHANGE_EMPLOYMENT_PERCENT |
Column TEMP_CHANGE_EMPLOYMENT_PERCENT. |
NUMBER |
17,8 |
TEMP_CHANGE_FTE_PERCENT_EFFORT |
Column TEMP_CHANGE_FTE_PERCENT_EFFORT. |
NUMBER |
13,6 |
TEMP_CHANGE_HOURLY_RATE |
Column TEMP_CHANGE_HOURLY_RATE. |
NUMBER |
|
TEMP_CHANGE_PERIOD_AMOUNT |
Column TEMP_CHANGE_PERIOD_AMOUNT. |
NUMBER |
|
TEMP_CHANGE_REASON |
Column TEMP_CHANGE_REASON. |
VARCHAR2 |
100 |
TEMP_CHANGE_REASON_CODE |
Column TEMP_CHANGE_REASON_CODE. |
VARCHAR2 |
2 |
TEMP_CHANGE_WORK_WEEK |
Column TEMP_CHANGE_WORK_WEEK. |
NUMBER |
5,2 |
WAREHOUSE_LOAD_DATE |
Column WAREHOUSE_LOAD_DATE. |
DATE |
|
WORKING_WEEK |
Column WORKING_WEEK. |
VARCHAR2 |
100 |
WORKING_WEEK_CODE |
Column WORKING_WEEK_CODE. |
VARCHAR2 |
2 |
WORK_SCHEDULE_RULE |
Column WORK_SCHEDULE_RULE. |
VARCHAR2 |
8 |