HR APPT LETTER DETAIL Table
Stores appointment letter details associated with personnel actions, including sponsor/letter codes, appointment amounts, vacation terms, and other letter attributes. Each row represents an appointment letter record for a person and position over a date range.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
APPOINTMENT_AMOUNT |
Appointment amount stated in the appointment letter. |
NUMBER |
15,2 |
APPT_LETTER_BEGIN_DATE |
Begin date for the appointment letter period. |
DATE |
|
APPT_LETTER_END_DATE |
End date for the appointment letter period. |
DATE |
|
COLLECTION_POINT |
Collection point code associated with the letter (as defined by source). |
VARCHAR2 |
3 |
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 letter. |
VARCHAR2 |
4 |
HR_POSITION_KEY |
Surrogate key identifying the HR position. |
VARCHAR2 |
10 |
IS_ACTION_CORRECTION |
Indicator identifying whether the personnel action is a correction (Y/N). |
VARCHAR2 |
1 |
LAST_UPDATE_DATE |
Date the letter record was last updated. |
DATE |
|
LAST_UPDATE_USER |
User identifier of the last updater of the letter record. |
VARCHAR2 |
8 |
LETTER |
Letter description/title associated with the appointment letter. |
VARCHAR2 |
100 |
LETTER_CODE |
Letter code associated with the appointment letter. |
VARCHAR2 |
2 |
MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
9 |
RECORD_COUNTER |
Record counter used for ETL control or auditing. |
NUMBER |
|
SPONSOR |
Sponsor description associated with the appointment letter. |
VARCHAR2 |
100 |
SPONSOR_CODE |
Sponsor code associated with the appointment letter. |
VARCHAR2 |
6 |
STIPEND_PAID_BY |
Indicator describing how/where stipend is paid (as defined by source). |
VARCHAR2 |
1 |
VACATION_DAYS_DUE |
Vacation days due as stated in the appointment letter (as defined by source). |
VARCHAR2 |
10 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |