PAYROLL CHECK DETAIL Table
View exposing payroll check detail including check number, payroll amount, payment date, print and encashment dates, paid and void indicators, replacement check number, and audit fields.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
CHECK_ENCASHMENT_DATE |
Date associated with check encashment. |
DATE |
|
CHECK_NUMBER |
Check number associated with the record. |
VARCHAR2 |
13 |
CHECK_PRINT_DATE |
Date associated with check print. |
DATE |
|
IS_VOID_CHECK |
Indicator identifying whether void check (Y/N). |
VARCHAR2 |
1 |
PAID_CHECK_FLAG |
Indicator identifying whether paid check (Y/N). |
VARCHAR2 |
1 |
PAYROLL_AMOUNT |
Payroll amount associated with the record. |
NUMBER |
17,2 |
PAYROLL_PAYMENT_DATE |
Date associated with payroll payment. |
DATE |
|
PERSONNEL_KEY |
Surrogate key identifying the personnel. |
VARCHAR2 |
8 |
RECORD_COUNTER |
Record counter associated with the record. |
NUMBER |
|
REPLACEMENT_CHECK_NUMBER |
Replacement check number associated with the record. |
VARCHAR2 |
13 |
VOID_CHECK_DATE |
Date associated with void check. |
DATE |
|
VOID_CHECK_REASON |
Void check reason associated with the record. |
VARCHAR2 |
50 |
VOID_CHECK_USER |
Void check user associated with the record. |
VARCHAR2 |
12 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |