[{TableOfContents }]

!!!Loading External Entries Into Time Sheets
Loading External Entries Into Time Sheets (UPLTS) application was created to allow you to load external time entries into the system.  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 time sheets 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. 
#Run [SQL LOADER] to populate the table. This CANNOT be called from within [{$applicationname}], it must be called from a DOS prompt. 
#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.