Business Rules for Time Card Import

Most of the key fields for time card import are optional and can be obtained automatically from the employee file.  The following outline defines the business rules that will be incorporated by the AccuBuild System for importing time card data.  

Required Fields:  This following fields must be included in the import file:

•Employee Number – This field may contain up to six numeric digits.

•Transaction Code – This code identifies the type of time card entry.  Only 4 types of transaction codes are supported: Regular Pay, Overtime Pay @ 1.5, Overtime Pay @ 2.0 and Overtime Pay @ 3.0.

•Hours – This field contains the hours worked.  Certified payroll hours can be included in the import file using the fields listed below for each day's hours. Hours that are NOT included in the certified payroll reports will be printed in RED on the Payroll Time Card Listing report while hours that will be included in the certified reports will be printed in BLACK.

Day1HRS - Sunday

Day2HRS - Monday

Day3HRS - Tuesday

Day4HRS - Wednesday

Day5HRS - Thursday

Day6HRS - Friday

Day7HRS - Saturday

C Flag - (Certified Payroll Flag)

1 = Include in certified payroll reports

0 = Exclude from certified payroll reports.

Optional Fields: The following fields may be included in the import file but are not required.  The business rules for these optional fields are simple: In all cases, the optional field will override any default settings for the employee unless the contents of the optional field are invalid.

The following information outlines the business rules for each field when the field is blank in the Ascii file:

•Union Code - The union code will be handled the same as a transaction code 1, 2, 3, or 4 depending on the Ascii file transaction code for regular or overtime pay.  The union code will be pulled from the employee file along with all pay rates. Note: If the union code is present in the Ascii file, then the entry will be handled as a transaction code 121, 122, 123, or 124 which pulls the rates and auto pays and deducts from the union table.

•Department Code - If not present in the Ascii file, then the department code will be pulled from the union file.  If not present in the union file, then the department code will be pulled from the employee file.

•Job - If not present in the Ascii file, then the entry will not be job costed.

•Job Cost Phase - If not present in the Ascii file, then the phase code linked to the department code will be used. If a phase cannot be found, the entry will NOT be charged to a job and the job field will be cleared.

•State Code - If not present in the Ascii file, the state code will be pulled from the job file.  If the state code in the job file is blank, then it will be pulled from the first state code set up in the employee file.

•Workers Comp Code - If not present in the Ascii file, then the workers comp code will be pulled from the job file.  If the workers comp code in the job file is blank, then it will be pulled from the employee file.

•Equipment - If not present in the Ascii file, the equipment code will be pulled from the employee file if present and the equipment transaction type (rental or maintenance expense) will be determined by the department code settings.