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

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 4 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.
!!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.