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, 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. 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.- YTD: Year To Date values are always created
- QTD: Quarter To Date values are created if you have indicated you wish a QTD summary on IPPR. QTDs are based on calendar quarters.
- MTD: Month To Date values are created if you have indicated you wish a MTD summary on IPPR.
- 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)
- ATD: Assignment To Date records are created with totals 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 the pay components that have Note that this information is not normally converted, so this record would not be created. Only those pay components that are on the Pay Line Details will be included by assignment.
Known Issues:
- Problem
- If you select a specific year, all FTD and ATD records are removed. ATD are rebuilt, but FTD records are only rebuilt for the specified year:
- Workaround
- If you have FTD values then do not run for only a specific year