Loading External Entries Into Time Sheets#
Loading External Entries Into Time Sheets (UPLTS) application was created to provide users with a method of loading external entries into time sheets. UPLTS reads the data from the P2K_PR_LOADED_PAY_LINES table and will then create/update time sheets in the Enter Employee Time Sheets (IPTS) screen with those entries. UPLTS Functionality UPLTS will load time sheet entries from the P2K_PR_LOADED_PAY_LINES table and will create or update timesheets in IPTS. UPLTS is for loading ‘hours only’ time sheet entries; it does not support loading entries with From/To times. If From/To times are required then the Load Time Sheet Entries (LPTS) application must be used to load those types of entries directly into time sheets. When determining the correct employee assignment to use, UPLTS will review the following information in the order shown: • ASSIGNMENT_CODE • POSITION_CODE • JOB_CODE • If none of the above are found then the Prime Assignment is used Once the assignment has been found, UPLTS will default the values for the following columns if the information for them is not provided: • Position • Unit • Job • Department • Payroll • Pay Period If the program is unable to identify all of the mandatory information for creating time sheets/entries, the record will be skipped. These records will be noted in the report output. If some of the non-mandatory information provided in the P2K_PR_LOADED_PAY_LINES does not match with what the system has, the entry will be loaded but with warnings. Again, these warnings will be listed in the report output when UPLTS has been run with exception level 1. UPLTS provides you with the option of loading prior period entries into a current period. You can also opt to remove the loaded entries from IPTL. UPLTS will load not just time worked but also premiums, leaves, and negative adjustments. Time rules will also be processed once the entries have been loaded into time sheets. The time sheets are created with a status of ‘Rules Applied’.Loading Entries into IPTL The IPTL can be populated in two ways. 1. Run SQL LOADER to populate the table. Unlike P2K, this CANNOT be called from within ePersonality, it must be called from a DOS prompt. 2. Run LMTD choosing P2K_PR_LOADED_PAY_LINES as the Destination Table. For more information on how to run LMTD please see the white paper EP-WP-TableDataLoader-v01. The IPTL records must have the Destination field set to IPTS and the UPTL Status must be To Be Loaded in order for the UPLTS to pick them up. Report Parameters Entity Mandatory This field is used to identify the entity associated with the report. Payroll This field identifies the payroll(s) being processed in this report.
Load Pay Period This field provides the option of loading prior pay period entries into a current pay period. You should enter the pay period which represents the majority of the time sheets and then manually select the necessary From / To dates to cover the prior period entries time frame. The From / To dates may not necessarily be the same time frame of the pay period that they choose. From Date Mandatory This field is used to identify the pay period start date. To Date Mandatory This field is used to identify the pay period end date By Assignment This provides the option of creating time sheets by assignment. If YES, then a time sheet will be created for each assignment with time entries for the period selected above. If NO, then one time sheet will be created for all an employee’s assignments with time entries for the period selected above. Remove Loaded Entries This provides the option of having the loaded external entries removed from IPTL when the UPLTS has successfully completed. If YES, then all of the Loaded Clean or Loaded With Errors entries will be removed in IPTL. The entries that did not get loaded will remain. If NO, then all of the entries will remain in IPTL regardless of their UPTL Status. Exception Level Mandatory This represents the level of detail that will be produced when the report is run. Trial, Yes or No If Yes, then the update is not committed to the database and UPLTS can be run again. If No, then the update is committed to the database and UPLTS may not be run again. Report Filters People List A people list may be used to indicate specific employee pay lines to be created Person This field represents the person(s) of specific employee(s) to be processed. This should not be used if a people list is used.
Report Output These are sample errors that you may run into when running the report. This is a sample of the report output totals.
