The UPTODATE function rebuilds to-date totals as seen on IPVT from information available in IPPH. This function is intended exclusively for rebuilding to-date values based upon converted data.
UPTODATE may be run by person or by payroll code and for a specific year or all years.
Processing:#
As it reads each employee's IPPH (pay header) information it will delete any existing IPVT (P2K_PR_TODATE_HEADERS) records for the to-date records selected in the parameters. It will then go through all the P2K_PR_PAY_HEADERS records and rebuild them from the P2K_PR_PAY_PC_AMOUNTS data (the Pay Amounts tab on IPPH) based upon the PAY_ISSUE_DATE.New parameters have been implemented for the following:
- MTD: Month To Date values are created if you have indicated you wish a MTD summary on IPPR.
- QTD: Quarter To Date values are created if you have indicated you wish a QTD summary on IPPR. QTDs are based on calendar quarters.
- YTD: Year To Date values are always created
- FTD: Fiscal Month To Date are created if you have indicated you wish a FTD summary on IPPR. FTDs are based on the Fiscal months as defined on Fiscal Calendar for the GL Company (IDGC). The FTD will not be processed when a year is provided in the YEAR Parameter.
- ATD: Assignment To Date records are created if you have indicated you wish Assignment Summary on IPPR. The totals are by Assignment Code. This information is taken from P2K_PR_PAY_LINES and P2K_PR_PAY_LINE_DETAILS, which are shown on the Pay Lines tab of IPPH, rather than the PC Amounts. Only those pay components that are on the Pay Line Details will be included by assignment. The ATD will not be processed when a year is provided in the YEAR Parameter.
- YEAR(YYYY): The for which the To-date records are to be updated for.
For M/Q/Y records, process either all IPPH or the Year matching the report parameter
