Alias: PADPI#
ADP Periodic/Quarterly Taxation Information (P2K_PR_PAY_HEADERS)
Unique Keys: Pay Header PPH_ID + Pay Component PPC_ID + ADP_TAX_CODE + ADP_TAX_TYPE + TAX_RECORD_STATUS
This table contains detailed record for each pay for all pay components that are identified in IPPC to be sent to ADP for Tax processing. If a pay is re-processed, the existing records will be marked as status = Deleted and will not be used for filing, but will exist as an audit trail. They should be removed periodically using the UMHP History Purge process.
ERD: ERD-PR95
Table Columns#
| Column name | Data Type / Size | Domain | Mand. | Notes |
|---|---|---|---|---|
| ID | Number(10) | ID | Y | |
| PRN_ID | Number(10) | ID | Y | link to P2K_PR_PAY_RUNS |
| EID_ID | Number(10) | ID | Y | link to P2K_HR_IDENTITIES |
| PPC_ID | Number(10) | ID | Y | link to P2K_PR_PAY_COMPONENTS |
| ADP_TAX_COMPANY | Varchar2(50) | VARCHAR50 | Y | |
| ADP_TAX_CODE | Varchar2(30) | VARCHAR30 | Y | |
| YEAR | Number(5) | NUMBER5 | Y | |
| QUARTER | Number(5) | NUMBER5 | Y | |
| ADP_TAX_TYPE | Varchar2(3) | X_ADP_TAX_TYPE | Y | |
| ADP_FILE_NO | Number(10) | NUMBER10 | Y | |
| AMOUNT | Number(18) | AMT12V6 | Y | |
| LIABILITY_DATE | Date() | DATE | Y | |
| CREATE_DATE | Date() | DATE | Y | |
| CREATE_USER | Varchar2(30) | VARCHAR30 | Y | |
| CHANGE_DATE | Date() | DATE | Y | |
| CHANGE_USER | Varchar2(30) | VARCHAR30 | Y | |
| PPH_ID | Number(10) | ID | link to P2K_PR_PAY_HEADERS | |
| HOURS_WORKED | Number(10) | NUMBER10 | ||
| WEEKS_WORKED | Number(10) | NUMBER10 | ||
| TAX_RECORD_STATUS | Varchar2(2) | X_TAX_RECORD_STATUS | ||
| MONTH | Number(5) | NUMBER5 |
