TimeSheetTimeGenerator#

TimeSheetTimeGenerator is called by#

  • UEGTS
  • PTSE processLeaveLineChangeEvent

Logic#

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
  • business example: UPTRA generated PTSE (UPTRA Apply Time Rules For Prior Periods)
2. PTSE records created after the PTS.END_DATE
Delete any PTSE records generated after the PTS.END_DATE
  • business example: PTS changed the time frame from PP to weekly or EE termination
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
4. Determine if there are leaves with status “1-Requested” before the last manual change
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)
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
7. Rebuild PTSE for reprocess dates
  • Holiday generation for Hours, Shift Calendar, Shift Pattern & Event scheduled
    • Determine the holiday date (reusable WorkTimeProjector logic)
    • Generate holiday PTSE records
  • Work /Leave Time generation
    • Hours PTS
      • Determine the work day (reusable WorkTimeProjector logic)
      • Create work PTSE conform with the work calendar/assignment/ work rule setup
      • Create leave PTSE For “1-Requested”, “2-Request Processed” approved/not required approval
      • Note: On PTSE insert the “3-In Payroll” AAL will be created(LeaveRequestProcessor logic)
        • ZERO amount “3-In Payroll” AAL indicator
        • When a leave PTSE is delete (IPTS…) a ZERO “3-In Payroll” AAL is created.
        • If this logic is rerun, this indicator will instruct the system to do not regenerate “3-In Payroll” AAL for that d
        • Create time sheet replacement if need it
        • Removes the TRs records, perform auto balancing, calculate Givens and apply TRs (reusable RemoveOffsetRecordsBalacingCalculateGivensAndApplyRulesByTimeSheet logic)
    • Shift Calendar PTS
      • Create TSH
      • Call BuildScheduleAndProcessExceptions form the last manual date to the end date
      • Call BuildScheduleAndProcessExceptions for leave dates before last manual date
    • Shift Patter PTS
      • TSH should be already generated (by running UTTP before UEGTS)
      • Call BuildScheduleAndProcessExceptions form the last manual date to the end date
      • Call BuildScheduleAndProcessExceptions for leave dates before last manual date