Timecard Derivation Sequence

When you set the processing options for the Time Entry MBF Processing Options business function, you determine the sequence that the system uses to derive values for fields on the timecard entry forms.

The system first uses the field value that is described in the Step 1 column. If no value exists, the system then uses the field value that is described in the Step 2 column. If no value is found, the system uses the value that is described in the Step 3 column, and so on, until the system derives a value for the specified field.

For example, the system derives a value for the Timecard Record Type field as follows:

• Step 1

  The system determines whether a value has been manually entered into that field on the timecard. If a value has been manually entered on the timecard, the system uses this value to process the timecard, and no further action is taken. If no value was entered on the timecard, the system proceeds to Step 2.

• Step 2

  The system tries to retrieve the value that is in the Timecard Record Type field in the F060116 table. If a value exists in this table, the system uses it to process the timecard and no further action is taken. If no value exists in this table, the system proceeds to Step 3.

• Step 3

  The system populates the Timecard Record Type field on the timecard with a default value of 1.

This table lists the sequence that the system uses to populate fields on the timecard:

Field on the Timecard	Step 1	Step 2	Step 3	Step 4	Step 5
Timecard Record Type	Manually entered on timecard.	F060116 table	Default - 1	Blank	Blank
Pay Type	Manually entered on timecard.	Option - U, F069126 table	Option - E, F060146 table	Labor Distribution table	Blank
Date Worked	Manually entered on header of timecard.	Pay Period Ending for Autopay	Blank	Blank	Blank
Home Company	Manually entered on timecard.	F060116 table	Blank	Blank	Blank
Home Business Unit	F0693006 table	Manually entered on timecard	F060116 table	Blank	Blank
Union Code for Wages and Reporting	Manually entered on timecard.	F069306 table	F060116 table	Blank	Blank
Job Type	Manually entered on timecard.	F060116 table	Blank	Blank	Blank
Job Step	Manually entered on timecard.	F060116 table	Blank	Blank	Blank
Labor Distribution Account	Manually entered on timecard.	Employee Labor Distribution Instructions (for autopay employees)	F081012 table	F06904 table	Blank
Billing Distribution (Recharges)	Manually entered on timecard.	AAIs for any Missing Element RD (F06904)	Blank	Blank	Blank
Equipment Distribution	Manually entered on timecard.	AAIs for Object Account ED (F06904)	Blank	Blank	Blank
Job Location	Manually entered on timecard.	Business Unit associated with Primary Distribution	Blank	Blank	Blank
Shift Code	Manually entered on timecard.	F060116 table	Blank	Blank	Blank
Shift Differential and Method	Manually entered on timecard.	Shift Differential Table $/HR or% (F069246)	If Shift Code is blank, retrieve from Pay Type table $/HR (F0690116)	Blank	Blank
Hours Worked	Manually entered on timecard.	Autopay Instructions	Labor Distribution table	Blank	Blank
Rate	Manually entered on timecard.	Option - U, F069126 table	Option - U, F060146 table	Option - E, F060146 table	F060116 table Xe Table: F060118
Base Rate	See explanation.	Blank	Blank	Blank	Blank
Gross Pay	Entered Lump Sum Amount.	Calculated	Blank	Blank	Blank
Flat Burden per cent	F060116 table	Option - U, F069126 table	Labor Distribution Business Unit (F0006)	Blank	Blank
W/C Insurance	Manually entered on timecard.	Labor Distribution Account, update in F0901	F06106 table	Option - U, F069126 table	F060116 table
Work Tax Area	Manually entered on timecard.	Labor Distribution Payroll Business Unit (F0006)	F060116 table	Blank	Blank
Check Route Code	Manually entered on timecard.	F060116 table	Blank	Blank	Blank
Equipment Rate Code	Manually entered on timecard (F1301).	Distribution Account, update in the F0901 table	Labor Distribution Business Unit, update in Payroll Business Unit or F0006 table	F1302 table	Blank
Equipment Rate	Manually entered on timecard.	F1301 table	Blank	Blank	Blank
Bank Account	Defined in prepayroll processing option.	Interim check entry	AAIs	Blank	Blank

The base rate is not derived from the hourly rate. The hourly rate is derived from the base rate, usually by applying a multiplier. The extended hourly rate is derived by applying shift and uprate amounts to the hourly rate.The derivation of the base rate depends on the derivation of the hourly rate:

Note: The shift sequence can alter the sequence used when applying multipliers and shift amounts to the base hourly rate when deriving the hourly and extended rates.

• You can retrieve the base rate from the record in the F069126 table. The base hourly rate does not include any multiplier associated with the pay type. The multiplier is used to derive the hourly rate (PHRT) from the base hourly rate (BHRT). The base hourly rate and hourly rate can be retrieved from the F069126. The Time Entry MBF determines which rate to retrieve from Union Rates table based on the pay type of the timecard and the pay types specified in the Time Entry MBF POs. If the timecard's pay type is the same pay type as listed in the "Pay Type - Hourly" processing option, then both the base rate and hourly rate is the hourly rate retrieved from the F069126. If the timecard's pay type is the same pay type listed in the "Pay Type - Regular Overtime" processing option, then the base hourly rate is the F069126 hourly rate and the hourly rate is either the F069126 overtime rate (if an overtime rate was specified on the Union Rate's record) or the base rate times the pay type multiplier from the timecard (if the OT rate was not specified on the Union Rates record). The same process continues for the other overtime and holiday rates. For the overtime rates, the pay type multiplier will only be applied to the base hourly rate if the overtime rate is not found in the F069126 Union Rates record. Otherwise, the hourly rate will be the OT rate retrieved from the F069126.

• If the system uses F060146 to derive the hourly rate, the system uses the same rate as the base rate.

• If you manually enter the hourly rate, the system determines the base rate by dividing the hourly rate by the pay-type multiplier. If an override rate is entered on the timecard, the override rate becomes the base rate, hourly rate, and extended rate. No other modifications are made to these three rates by the Time Entry MBF.

• If the hourly rate is retrieved from the F060116 table, the system uses the same rate as the base rate.