PAYROLL SALARY DIST DETAIL Table
View exposing payroll salary distribution detail records including personnel, position, organizational assignment, cost collector, general ledger account, distribution amounts, and related payroll accounting attributes.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
APPT_BEGIN_DATE |
Date associated with appt begin. |
DATE |
|
APPT_END_DATE |
Date associated with appt end. |
DATE |
|
APPT_SUBTYPE |
Appt subtype associated with the record. |
VARCHAR2 |
100 |
APPT_SUBTYPE_CODE |
Code identifying appt subtype. |
VARCHAR2 |
4 |
BASE_AMT_TO_BE_DISTRIBUTED |
Base amt to be distributed associated with the record. |
NUMBER |
34 |
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 |
IS_HOURLY_PAID_STUDENT |
Indicator identifying whether hourly paid student (Y/N). |
VARCHAR2 |
1 |
IS_STUDENT_APPOINTMENT |
Indicator identifying whether student appointment (Y/N). |
VARCHAR2 |
1 |
LAST_RULE_UPDATE_DATE |
Date associated with last rule update. |
DATE |
|
LAST_RULE_UPDATE_USER |
Last rule update user associated with the record. |
VARCHAR2 |
12 |
LAST_SALARY_UPDATE_DATE |
Date associated with last salary update. |
DATE |
|
LAST_SALARY_UPDATE_USER |
Last salary update user associated with the record. |
VARCHAR2 |
12 |
LINK_FIELD |
Link field associated with the record. |
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 |
ORIGINAL_BASE_AMOUNT |
Original base amount associated with the record. |
NUMBER |
15,2 |
ORIGINAL_EMPLOYMENT_PERCENT |
Original employment percent associated with the record. |
NUMBER |
7,4 |
ORIGINAL_HOURLY_RATE |
Original hourly rate associated with the record. |
NUMBER |
13,2 |
ORIGINAL_PERCENT_TIME |
Time associated with original percent. |
NUMBER |
7,4 |
ORIGINAL_PERIOD_AMOUNT |
Original period amount associated with the record. |
NUMBER |
15,2 |
ORIGINAL_WORK_WEEK |
Original work week associated with the record. |
NUMBER |
5,2 |
PAY_BASIS |
Pay basis associated with the record. |
VARCHAR2 |
50 |
PAY_BASIS_CODE |
Code identifying pay basis. |
VARCHAR2 |
7 |
PAY_BASIS_NUMBER_OF_MONTHS |
Pay basis number of months associated with the record. |
NUMBER |
|
PAY_BEGIN_DATE |
Date associated with pay begin. |
DATE |
|
PAY_DIST_BEGIN_DATE |
Date associated with pay dist begin. |
DATE |
|
PAY_DIST_END_DATE |
Date associated with pay dist end. |
DATE |
|
PAY_DIST_PERCENT |
Pay dist percent associated with the record. |
NUMBER |
5,2 |
PAY_END_DATE |
Date associated with pay end. |
DATE |
|
PERIOD_AMT_TO_BE_DISTRIBUTED |
Period amt to be distributed associated with the record. |
NUMBER |
34 |
PERSONNEL_KEY |
Surrogate key identifying the personnel. |
VARCHAR2 |
8 |
RECORD_COUNTER |
Record counter associated with the record. |
NUMBER |
1 |
REPORT_BASE_AMOUNT |
Report base amount associated with the record. |
NUMBER |
|
REPORT_EMPLOYMENT_PERCENT |
Report employment percent associated with the record. |
NUMBER |
|
REPORT_HOURLY_RATE |
Report hourly rate associated with the record. |
NUMBER |
|
REPORT_PERCENT_TIME |
Time associated with report percent. |
NUMBER |
|
REPORT_PERIOD_AMOUNT |
Report period amount associated with the record. |
NUMBER |
|
REPORT_WORK_WEEK |
Report work week associated with the record. |
NUMBER |
|
SUPPLEMENT_TYPE |
Supplement type associated with the record. |
VARCHAR2 |
30 |
SUPPLEMENT_TYPE_CODE |
Code identifying supplement type. |
VARCHAR2 |
2 |
SUSPENSE_COST_COLLECTOR_KEY |
Surrogate key identifying the suspense cost collector. |
VARCHAR2 |
12 |
TEMP_CHANGE_BASE_AMOUNT |
Temp change base amount associated with the record. |
NUMBER |
15,2 |
TEMP_CHANGE_HOURLY_RATE |
Temp change hourly rate associated with the record. |
NUMBER |
13,2 |
TEMP_CHANGE_PERCENT_TIME |
Time associated with temp change percent. |
NUMBER |
7,4 |
TEMP_CHANGE_PERIOD_AMOUNT |
Temp change period amount associated with the record. |
NUMBER |
13,2 |
TEMP_CHANGE_REASON |
Temp change reason associated with the record. |
VARCHAR2 |
100 |
TEMP_CHANGE_REASON_CODE |
Code identifying temp change reason. |
VARCHAR2 |
2 |
TEMP_CHANGE_WORK_WEEK |
Temp change work week associated with the record. |
NUMBER |
5,2 |
TEMP_EMPLOYMENT_PERCENT |
Temp employment percent associated with the record. |
NUMBER |
7,2 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |