CMS Report Help

PROGRESSIVE HOUR / OT REPORT

 

General
  1. Category : Crew Particulars
  2. Name: PROGRESSIVE HOUR / OT REPORT
  3. Input / Selection : Lobby Name, crew Type, Slot, Traction (not for Guard)
  4. Sort (Default) : Traction
  5. Sort by Choosing : Crew ID, Crew Name, PF No
  6. Filtered By : Traction
  7. Details:
    	TOTAL DUTY  No of duty Hrs for given slot
    	OVERTIME DUTY 
    		in case of crew is non shunter then
    			if TOTAL DUTY > 104 HOURS then  OVERTIME DUTY will be TOTAL DUTY-104 HOURS else it will be Zero.
    		in case of crew is shunter then 
    			if TOTAL DUTY > 96 HOURS then  OVERTIME DUTY will be TOTAL DUTY-96 HOURS else it will be Zero.
    	LOW RATE OT
    		In case of non Shunter
    			if (TOTAL DUTY > 104 HOURS and TOTAL DUTY - 104 HOURS > 4 HOURS) LOW RATE OT will be 4 HOURS
    			if (TOTAL DUTY > 104 HOURS and TOTAL DUTY - 104 HOURS < 4 HOURS) LOW RATE OT will be TOTAL DUTY HOURS -104 HOURS
    			else LOW RATE OT will be zero.
    		In case of Shunter
    			if (TOTAL DUTY > 96 HOURS and TOTAL DUTY - 96 HOURS > 4 HOURS) LOW RATE OT will be 4 HOURS
    			if (TOTAL DUTY > 96 HOURS and TOTAL DUTY - 96 HOURS < 4 HOURS) LOW RATE OT will be TOTAL DUTY HOURS -96 HOURS
    			else LOW RATE OT will be zero.
    	HIGH RATE OT
    		In case of non Shunter
    			if (TOTAL DUTY > 104 HOURS and TOTAL DUTY - 104 HOURS > 4 HOURS) HIGH RATE OT will be TOTAL DUTY HOURS - 108 HOURS
    			else HIGH RATE OT will be zero.
    		In case of Shunter
    			if (TOTAL DUTY > 96 HOURS and TOTAL DUTY - 96 HOURS > 4 HOURS) HIGH RATE OT will be TOTAL DUTY HOURS - 100 HOURS
    			else HIGH RATE OT will be zero.
    	NON RUN DAYS no of nonrun days during given slot.
    	RUNNING DAYS no of running days during given slot 
    	NO OF LEAVE no of nonrun leave days for given slot
    	ROSTER HRS	In case of non Shunter (104 HOURS - 7.26 HOURS) * no of leaves 
    			In case of Shunter (96 HOURS - 6.51 HOURS) * no of leaves 
    	

 

Data in Report Header
  1. S.No.
  2. CREW
  3. NAME
  4. PF NO
  5. TOTAL DUTY
  6. OVERTIME DUTY
  7. LOW RATE OT
  8. HIGH RATE OT
  9. NON RUN DAYS
  10. RUNNING DAYS
  11. NO OF LEAVE
  12. ROSTER HRS

Format

S.No. CREW NAME PF NO TOTAL DUTY OVERTIME DUTY LOW RATE OT HIGH RATE OT NON RUN DAYS RUNNING DAYS NO OF LEAVE ROSTER HRS