PAYROLL GROSS PAY DETAIL Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
GROSS_PAY_AMOUNT |
The amount of an employee's remuneration before any deductions are made. |
NUMBER |
22 |
IS_OFF_CYCLE_PAYROLL |
A flag, Y or N, indicating if the payment is off cycle. |
VARCHAR2 |
1 |
OFF_CYCLE_PAYMENT_DATE |
The date on the off-cycle check |
DATE |
8 |
OFF_CYCLE_REASON |
The reason in SAP for the off-cycle payment, e.g., Year-end adjustment, Additional payment, etc. |
VARCHAR2 |
30 |
OFF_CYCLE_REASON_IN |
XXX |
VARCHAR2 |
30 |
PAYROLL_FOR_PERIOD_KEY |
Key field used to join the PAYROLL_FOR_PERIOD table to Payroll fact tables. Use for joining data, not for reporting. |
VARCHAR2 |
8 |
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_RUN_DATE |
The date the regular or off-cycle payroll was run in SAP |
DATE |
8 |
PAYROLL_RUN_PERSON_ATTRIB_KEY |
XXX |
VARCHAR2 |
13 |
PAYROLL_RUN_SEQNO |
The payroll run sequence number associated with the gross pay; each reqular and off-cycle payroll run has a unique sequence number |
NUMBER |
22 |
PAYROLL_VOID_REVERSED_DATE |
The date the payment was reversed in SAP |
DATE |
8 |
PAYROLL_VOID_REVERSED_REASON |
XXX |
VARCHAR2 |
30 |
PAYROLL_VOID_REVERSED_STATUS |
XXX |
VARCHAR2 |
10 |
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 |
RECORD_COUNTER |
Used to count records within a group on a report. Always contains a value of 1. |
NUMBER |
1 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |