PAYROLL POSTINGS Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
FINANCIAL_DETAIL_KEY |
XXX |
VARCHAR2 |
17 |
FOR_PAYROLL_PERIOD |
The time period(month or week) and year of the payroll FOR period in the format MM.YYYY or WW.YYYY. |
VARCHAR2 |
7 |
FULL_NAME |
The full name of the person. |
VARCHAR2 |
100 |
IN_PAYROLL_PERIOD |
The time period (month or week) and year of the payroll in period in the format mm.yyyy (monthly) and ww.yyyy(weekly). |
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 |
The date on the off-cycle check |
DATE |
|
PAYROLL_AMOUNT_POSTED |
XXX |
NUMBER |
17,2 |
PAYROLL_DOCUMENT_LINE |
XXX |
NUMBER |
|
PAYROLL_DOCUMENT_NUMBER |
XXX |
NUMBER |
|
PAYROLL_RUN_ID |
XXX |
NUMBER |
|
PAYROLL_SEQUENCE_NUMBER |
XXX |
NUMBER |
34 |
PERSONNEL_KEY |
Key field used to join to the PERSONNEL table. This field should only be used for joining data, NOT for reporting. |
VARCHAR2 |
8 |
RECORD_COUNTER |
Used to count records within a group on a report. Always contains a value of 1. |
NUMBER |
1 |
WAGE_TYPE |
wage type text of the amount, e.g., work, vacation, sick leave, health plan deduction, etc. There are hundreds of wage types; only those most likely to be used for reporting are in the data warehouse. |
VARCHAR2 |
30 |
WAGE_TYPE_CATEGORY |
Shows the category of the wage type, e.g., gross pay, taxes, deductions. |
VARCHAR2 |
70 |
WAGE_TYPE_CODE |
An alphanumeric code for the Wage Type. Numeric (450E, 453E) customized by MIT. With slash (/101, /102) SAP supplied |
VARCHAR2 |
4 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |