This page (revision-6) was last changed on 26-Nov-2021 10:22 by JMyers

This page was created on 26-Nov-2021 10:22 by JMyers

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
6 26-Nov-2021 10:22 4 KB JMyers to previous
5 26-Nov-2021 10:22 4 KB JMyers to previous | to last
4 26-Nov-2021 10:22 4 KB JMyers to previous | to last
3 26-Nov-2021 10:22 4 KB JMyers to previous | to last
2 26-Nov-2021 10:22 4 KB JMyers to previous | to last
1 26-Nov-2021 10:22 4 KB JMyers to last

Page References

Incoming links Outgoing links
UPLTS
UPLTS

Version management

Difference between version and

At line 1 added 2 lines
[{TableOfContents }]
At line 2 changed 3 lines
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.
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.\\
At line 6 changed 4 lines
• ASSIGNMENT_CODE
• POSITION_CODE
• JOB_CODE
• If none of the above are found then the Prime Assignment is used
*[ASSIGNMENT_CODE]
*[POSITION_CODE]
*[JOB_CODE]
*If none of the above are found then the Prime Assignment is used
At line 11 changed 9 lines
• 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.
*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].
At line 22 changed 5 lines
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.
!!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 Personality, it must be called from a DOS prompt.
#Run [LMTD] choosing [P2K_PR_LOADED_PAY_LINES] as the Destination table. The [LMTD] page provides more information on how to run this function.\\
The IPTL records must have the Destination field set to [IPTS] and the UPTL Status must be set to To Be Loaded in order for the UPLTS to pick them up.
At line 28 changed 5 lines
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.
!!Report Parameters & Filters
||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.
At line 34 changed 24 lines
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.
|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.
At line 46 added 3 lines
||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.
At line 50 added 5 lines
!!Report Output
These are sample errors that you may run into when running the report.\\ \\
[uplts_01.jpg]\\ \\
This is a sample of the report output totals.\\ \\
[uplts_02.jpg]
At line 56 added 3 lines
----
![Notes|Edit:Internal.UPLTS]
[{InsertPage page='Internal.UPLTS' default='Click to create a new notes page'}]
At line 62 removed 10 lines
Report Output
These are sample errors that you may run into when running the report.
This is a sample of the report output totals.
This page (revision-6) was last changed on 26-Nov-2021 10:22 by JMyersTop