Cleaning Up Conversion Data #

Date Adjustments#

All the date sensitive tables in the application, such as JOBS, POSITIONS and ASSIGNMENTS need to have a complete set of records that span from the beginning of time to the end of time. If there is a gap in time or an overlap within the records there could be errors generated during normal use of the screens or reports.

Each date sensitive table has a corresponding date adjustment function within the application that will need to be run after the records have been loaded and converted. Each function will read through the records in the appropriate detail table in the P2K schema and look for overlapping records and gaps in time, starting with the records with the highest effective date and working backwards.

If the first record it finds does not have an expiry date of 31-Dec-3999, the routine will change it to this date, making it the end of time. The routine will then continue going through the records in descending order looking at the expiry date of each record. If the expiry date is not equal to the effective date of the previous record less a day, the expiry date will be adjusted. This process will eliminate the gaps and overlaps in time for the table. However, if the last record it finds in the table does not start on 01-Jan-0001 it will not alter this record. Instead it will create a duplicate of the record with an effective date of the beginning of time and an expiry of the day before this record. This will fill in the gap at the beginning of time without altering the effective date of the record loaded and converted.

The process of adjusting the dates requires the records to have the correct effective date on them. If the current record is loaded and converted with the beginning of time and then the historical records are loaded in after this the routine will cause the current record to become the most historical record in the table. It will expiry before all of the other records that have valid effective dates on them.

The following table is a list of the date adjustment utilities in the application and the tables that they will scan through looking for gap and overlaps in time:

Function name	Date Adjustment for …
UMDA_ALP	... Leave Policies
UMDA_BCG	... Benefit Coverage
UMDA_BEN	... Enrollments
UMDA_DDP	... Departments
UMDA_DEN	... Entities
UMDA_DGR	... Groups
UMDA_DJB	... Jobs
UMDA_DPS	... Positions
UMDA_DUN	... Units
UMDA_DWR	... Work Rules
UMDA_EAS	... Assignments
UMDA_EPS	... Personals
UMDA_MVR	... User Variables
UMDA_PPR	... Payment Rules
UMDA_PPRC	... Canadian Pay Rules
UMDA_PPRU	... USA Pay Rules
UMDA_SPM	... Premiums
UMDA_SSR	... Salary Ranges
UMDA_SWSS	... Wage Scale Steps
UMDA_XPA	... Pension Accounts
UMDA_XPO	... Pension Options
UMDA_XPR	... Pension Recipients
UMDA_XPT	... Pension Tables

Only run the functions from this list that you are actually loading and converting data for. If the data in these tables is being keyed into the application, the data entry screen will ensure that the beginning of time and end of time records are created correctly without gaps or overlaps.

---

Notes #

Click to create a new notes page