PAYROLL COMMITMENT DETAIL Table
View exposing payroll commitment detail by person, position, organization, cost collector, general ledger account, and fiscal month including commitment type, origin, adjusted and unadjusted commitment amounts.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
APPT_SUBTYPE |
Appt subtype associated with the record. |
VARCHAR2 |
100 |
APPT_SUBTYPE_CODE |
Code identifying appt subtype. |
VARCHAR2 |
4 |
COMMITMENT_AMOUNT |
Commitment amount associated with the record. |
NUMBER |
|
COMMITMENT_ORIGIN |
Commitment origin associated with the record. |
VARCHAR2 |
3 |
COMMITMENT_TYPE |
Commitment type associated with the record. |
VARCHAR2 |
3 |
COST_COLLECTOR_KEY |
Surrogate key identifying the cost collector. |
VARCHAR2 |
12 |
GL_ACCOUNT_KEY |
Surrogate key identifying the gl account. |
VARCHAR2 |
10 |
HR_ORG_UNIT_KEY |
Surrogate key identifying the hr org unit. |
VARCHAR2 |
10 |
HR_POSITION_KEY |
Surrogate key identifying the hr position. |
VARCHAR2 |
10 |
MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
9 |
PERSONNEL_KEY |
Surrogate key identifying the personnel. |
VARCHAR2 |
8 |
TIME_MONTH_KEY |
Surrogate key identifying the time month. |
VARCHAR2 |
6 |
UNADJUSTED_COMMITMENT_AMOUNT |
Unadjusted commitment amount associated with the record. |
NUMBER |
|
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |