PAYROLL MBTA VAN DEDUCT DETAIL Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
AMOUNT |
The total actual dollar amount charged for the fiscal period or periods selected. In GRADUATE AWARDS, this field contains the graduate award (RA, TA, etc.) amount. |
NUMBER |
|
PAYROLL_IN_PERIOD_KEY |
Key field used to join the PAYROLL_IN_PERIOD table to Payroll fact tables. Use for joining data, not for reporting. |
VARCHAR2 |
8 |
PAYROLL_WAGE_TYPE_KEY |
Key field used to join the PAYROLL_WAGE_TYPE table to Payroll fact tables. Use for joining data, not for reporting. |
VARCHAR2 |
4 |
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 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |