PAYROLL ACH DETAIL Table
View exposing ACH payroll payment detail including MIT identifier, payroll amount, payment date, void and replacement information, and warehouse load date.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
100 |
PAYROLL_AMOUNT |
Payroll amount associated with the record. |
NUMBER |
10,2 |
PAYROLL_PAYMENT_DATE |
Date associated with payroll payment. |
DATE |
|
PERSONNEL_KEY |
Surrogate key identifying the personnel. |
VARCHAR2 |
15 |
REPLACEMENT_AMOUNT |
Replacement amount associated with the record. |
NUMBER |
10,2 |
REPLACEMENT_METHOD |
Replacement method associated with the record. |
VARCHAR2 |
1 |
REPLACEMENT_NUMBER |
Replacement number associated with the record. |
VARCHAR2 |
18 |
VOID_REPLACEMENT_DATE |
Date associated with void replacement. |
DATE |
|
VOID_REPLACEMENT_STATUS |
Void replacement status associated with the record. |
VARCHAR2 |
8 |
VOID_REPLACEMENT_USER |
Void replacement user associated with the record. |
VARCHAR2 |
12 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |