B Timecard Derivation Sequence

This appendix contains the topic:

B.1 Timecard Derivation Sequence

This appendix lists the sequence the system uses to derive values for fields on the timecard entry forms.

Item 1 2 3 4 5
Time card Record Type 1. Payroll 2. Combined 3. Billing Keyed on Timecard Entry Employee Master (F060116) Default - 1    
Pay Type Keyed on Timecard Entry Option - U Union Rate table (F069126) Option - E Occupational Rate table for Regular Pay Only (F060146) Labor Distribution table  
Date Worked Keyed on Timecard Entry Defaults to Pay Period Ending for autopay      
Home Company Keyed on Timecard Entry Employee Master (F060116)      
Home Business Unit Local Union Override (F0693006) Keyed on Timecard Entry Employee Master (F060116)    
Union Code for Wages and Reporting Keyed in Timecard Entry Local Union Override (F0693006) Employee Master (F060116)    
Job Type Keyed on Timecard Entry Employee Master (F060116)      

Item 1 2 3 4 5
Labor Distribution Account Keyed on Timecard Entry Employee Labor Distribution Instructions (for autopay employees) Position Account Instructions (F081012) AAIs (F06904)  
Billing Distribution (Recharges) Keyed on Timecard Entry AAIs for Any Missing Element RD (F06904)      
Equipment Distribution Keyed on Timecard Entry AAIs for Object Account ED (F06904)      
Job Location Keyed on Timecard Entry Business Unit associated with Primary Distribution      
Shift Code Keyed on Timecard Entry Employee Master (F060116)      
Shift Differential and Method Keyed on Timecard Entry Shift Differential table $/HR or % (F069246) If Shift Code is blank, retrieve from Pay Type table $/HR (F0690116)    
Hours Worked Keyed on Timecard Entry Autopay Instructions Labor Distribution table    
Rate Keyed on Timecard Entry Option - U Union Rate table (F0609126) Option - U Occupational Rate table (F060146) Option - E Occupational Rate table (F060146) Employee Master (F060116 or F060118)

The derivation of the Base Rate depends on the derivation of the hourly rate as follows:

  • If the Union Rates table is used, then the Base Rate is found by dividing the rate derived from the Union Rates table by the Pay Type Multiplier.

  • If the Occupation Rates table is used, then the rate from the Occupation table is assumed to be the Base Rate.

  • If the Hourly Rate is manually entered, then the Base Rate is found by dividing the entered rate by the Pay Type Multiplier.

  • If the Employee Master rate is used, the Base Rate is the rate from the Employee Master.

Item 1 2 3 4 5
Gross Pay Entered Lump Sum Amount Calculated      
Flat Burden % Employee Master (F060116) Option - U Use Union Rate table (F069126) Labor Distribution Business Unit (F0006)    
W/C Insurance Keyed on Timecard Entry Labor Distribution Account, update in Cost Code Master (F0901) Employee Labor Distribution Instructions (F06106) Option - U Union Rate table (F069126) Employee Master (F060116)
Work Tax Area Keyed on Timecard Entry Labor Distribution Payroll Business Unit (F0006) Employee Master (F060116)    
Check Route Code Keyed on Timecard Entry Employee Master (F060116)      
Equipment Rate Code Keyed on Timecard Entry (F1301) Distribution Account, update in Cost Code Master (F0901) Labor Distribution Business Unit, update in Payroll Business Unit or Job Master (F0006) Rental Rules table (F1302)  
Equipment Rate Keyed on Timecard Entry Equipment Rate table      
Bank Account Defined in Pre-Payroll processing option Interim check entry AAIs