PAYROLL DEDUCTION DETAIL Table
This table contains payroll deductions information, including requested deduction amount, the amount taken during the payroll run, arrears/deduction not taken amount, as well as -- for some types of deductions -- the amount paid-to-date and the remaining balance. The data starts in July 2006 and records are added to this table after every payroll.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ARREARS_AMOUNT |
The total deduction amount that Payroll was not able to take up to and including this pay period. Some, but not all, deductions, if not paid as expected, are set up to go into arrears, meaning that Payroll attempts to take this amount in the next pay period. Ex: An amount might go into arrears if a person is on leave without pay, and there is no salary from which to take the deduction. |
NUMBER |
22 |
DEDUCTED_TO_DATE_AMOUNT |
The total amount deducted to date for this deduction wage type (populated only for a small number of deduction types). |
NUMBER |
22 |
DEDUCTION_AMOUNT |
The amount deducted for this specific deduction wage type in the specified pay period. |
NUMBER |
22 |
DROPPED_AMOUNT |
If a deduction could not be taken, and the deduction type was not set up to go into arrears, then the amount not taken is dropped, i.e., Payroll does not attempt to take it in the next pay period. |
NUMBER |
22 |
INCOMING_ARREARS_AMOUNT |
The amount of arrears up to this in-period (e.g., there was a previous arrears of $400; this month an additional $100 is not deducted; incoming arrears will show $400 in this pay period and will show $500 in the next pay period). Also see arrears amount. |
NUMBER |
22 |
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 |
RECORD_COUNTER |
Used to count records within a group on a report. Always contains a value of 1. |
NUMBER |
1 |
REMAINING_BALANCE_AMOUNT |
Only exists for those deductions where a fixed balance is set up and has not been met; in these cases, remaining balance amount is the amount still to be deducted |
NUMBER |
22 |
REQUESTED_DEDUCTION_AMOUNT |
The amount to be deducted in the current pay period. Note this amount may not be deducted. |
NUMBER |
22 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |