Please enable JavaScript.
Coggle requires JavaScript to display documents.
Paysheet Update (Holiday/Premium & Overtime) - Coggle Diagram
Paysheet Update
(Holiday/Premium & Overtime)
Purpose
Separate payment for Holiday/Special Holiday or Premium Days (Weekends) between 8:30 AM–5:30 PM
"Normal OT or work after 6:00 PM shown under existing Overtime section"
Scope
Horizontal paysheet: Previewing Overtime as per customized layout
Includes showing:
Holiday Pay
Premium Pay
Overtime
Requirement
Display rules:
Work on Holiday/Special Holiday or Weekend between 8:30–5:30 PM → Shown in **Holiday Pay/Premium Pay (one or two columns)
Work after 6:00 PM on:
Normal days
Holidays
Premium days
Shown under
Overtime
Data Inputs
Employee Shift Records
Time IN / Time OUT
Day Type (Normal,
Normal Holiday, Special Holiday,
Weekend/Premium Day)
Overtime Rules
System Logic
Identify work Date Type
Identify Time Slot
Apply Calculation Rules
Allocate pay to correct category
Logic Conditions:
IF Holiday/Premium + 8:30–5:30
→ Holiday/Premium Pay Column
IF After 6:00 PM
→ Overtime Column
Outputs View
OT report:
Holiday Pay Column
Premium Pay Column
Overtime Column
Expected Behavior:
Separate section for Holiday/Premium Pay
Existing Overtime column unaffected
No mixing of pay categories
OT method
Normal
Prior OT