PAYROLL POSTINGS Table
View exposing payroll postings data.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
FINANCIAL_DETAIL_KEY |
Surrogate key identifying the financial detail. |
VARCHAR2 |
17 |
FOR_PAYROLL_PERIOD |
For payroll period associated with the record. |
VARCHAR2 |
7 |
FULL_NAME |
Full name associated with the person. |
VARCHAR2 |
100 |
IN_PAYROLL_PERIOD |
In payroll period associated with the record. |
VARCHAR2 |
7 |
MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
9 |
OFF_CYCLE_PAYMENT_DATE |
Date associated with off cycle payment. |
DATE |
|
PAYROLL_AMOUNT_POSTED |
Payroll amount posted associated with the record. |
NUMBER |
17,2 |
PAYROLL_DOCUMENT_LINE |
Payroll document line associated with the record. |
NUMBER |
|
PAYROLL_DOCUMENT_NUMBER |
Payroll document number associated with the record. |
NUMBER |
|
PAYROLL_RUN_ID |
Business identifier for the payroll run. |
NUMBER |
|
PAYROLL_SEQUENCE_NUMBER |
Payroll sequence number 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 |
WAGE_TYPE |
Wage type associated with the record. |
VARCHAR2 |
30 |
WAGE_TYPE_CATEGORY |
Wage type category associated with the record. |
VARCHAR2 |
70 |
WAGE_TYPE_CODE |
Code identifying wage type. |
VARCHAR2 |
4 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |