HR CURRENT DISTRIBUTION Table
Stores current payroll distribution (costing) allocations for HR acess, for personnel positions and appointment subtypes, including cost collector, suspense cost collector, GL account, org unit, distribution percent, and effective date range. Each row represents an active distribution line for a personnel/position.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
APPT_SUBTYPE |
Appointment subtype description associated with the distribution line. |
VARCHAR2 |
100 |
APPT_SUBTYPE_CODE |
Appointment subtype code associated with the distribution line. |
VARCHAR2 |
4 |
COST_COLLECTOR_KEY |
Cost collector key charged for this distribution line. |
VARCHAR2 |
12 |
GL_ACCOUNT_KEY |
General ledger account key charged for this distribution line. |
VARCHAR2 |
10 |
HR_ORG_UNIT_KEY |
HR organizational unit key associated with the distribution line. |
VARCHAR2 |
10 |
HR_POSITION_KEY |
Identifier for the HR position associated with the distribution line. |
VARCHAR2 |
10 |
IS_HOURLY_PAID_STUDENT |
Indicator identifying whether the distribution line is associated with an hourly paid student (Y/N). |
VARCHAR2 |
1 |
LAST_UPDATE_DATE |
Date the distribution line was last updated in the source system. |
DATE |
|
LAST_UPDATE_USER |
User identifier indicating who last updated the distribution line. |
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 |
PAY_DIST_BEGIN_DATE |
Effective begin date for the payroll distribution line. |
DATE |
|
PAY_DIST_END_DATE |
Effective end date for the payroll distribution line. |
DATE |
|
PAY_DIST_PERCENT |
Percentage of pay distributed to the specified cost collector and GL account. |
NUMBER |
5,2 |
PERSONNEL_KEY |
Surrogate key identifying the personnel record associated with the distribution. |
VARCHAR2 |
8 |
RECORD_COUNTER |
Record counter used for ETL control or auditing. |
NUMBER |
1 |
SUSPENSE_COST_COLLECTOR_KEY |
Suspense cost collector key used when charges cannot be assigned to the primary cost collector. |
VARCHAR2 |
12 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |