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

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

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
5 26-Nov-2021 10:22 2 KB kparrott to previous
4 26-Nov-2021 10:22 2 KB kparrott to previous | to last
3 26-Nov-2021 10:22 3 KB kparrott to previous | to last
2 26-Nov-2021 10:22 2 KB kparrott to previous | to last
1 26-Nov-2021 10:22 2 KB kparrott to last

Page References

Incoming links Outgoing links

Version management

Difference between version and

At line 6 changed one line
;1. PTSE records created before the PTS.START_DATE:Keep manually entered PTSE records created before the PTS.START_DATE\\Delete any generated PTSE records generated before the PTS.START_DATE
1. PTSE records created before the PTS.START_DATE\\Keep manually entered PTSE records created before the PTS.START_DATE\\Delete any generated PTSE records generated before the PTS.START_DATE
At line 9 changed one line
;2. PTSE records created after the PTS.END_DATE:Delete any PTSE records generated after the PTS.END_DATE
2. PTSE records created after the PTS.END_DATE\\Delete any PTSE records generated after the PTS.END_DATE
At line 12 changed one line
;3. Determine the last “Manual” changed PTSE:Any PTSE record with “Manual” TIME_SHEET_ENTRY_SOURCE\\“Manual” = MANUAL, MANUAL_BY_TTX, LOADED , MANUAL_BY_PAYROLL\\Any PTSE with “GENERATED_SCHEDULED_HOURS” TIME_SHEET_ENTRY_SOURCE where MANUAL_CHANGE_USER is not null
3. Determine the last “Manual” changed PTSE\\Any PTSE record with “Manual” TIME_SHEET_ENTRY_SOURCE
“Manual” = MANUAL, MANUAL_BY_TTX, LOADED , MANUAL_BY_PAYROLL\\Any PTSE with “GENERATED_SCHEDULED_HOURS” TIME_SHEET_ENTRY_SOURCE where MANUAL_CHANGE_USER is not null
At line 14 changed one line
;4. Determine if there are leaves with status “1-Requested” before the last manual change
4. Determine if there are leaves with status “1-Requested” before the last manual change
At line 16 changed one line
;5. Determine dates to be reprocessed:Dates too be reprocessed = any dates after last manual (#3) + any dates for “1-Requested” leave before the last manual change (#4)
5. Determine dates to be reprocessed\\Dates too be reprocessed = any dates after last manual (#3) + any dates for “1-Requested” leave before the last manual change (#4)
At line 18 changed one line
;6. For dates to be reprocessed - delete any PTSE records that are not manual:Attention if we do not have any leaves with status “1-Requested” leave before the last manual change, there will be no need to check for manual PTSE because they will not exist for the reprocess dates
6. For dates to be reprocessed - delete any PTSE records that are not manual\\Attention if we do not have any leaves with status “1-Requested” leave before the last manual change, there will be no need to check for manual PTSE because they will not exist for the reprocess dates
At line 20 changed one line
;7. Rebuild PTSE for reprocess dates
7. Rebuild PTSE for reprocess dates
At line 43 removed one line