AASHTOWare ProjectTM Payroll Spreadsheet Conversion Utility 2.

0 PLEASE READ THESE TERMS OF USE CAREFULLY BEFORE CONTINUING YOUR USE OF THIS SPREADSHEET. IF YOU USE THIS SPREADSHEET YOU ACCEPT
AND AGREE TO ALL OF THE TERMS AND CONDITIONS CONTAINED IN THESE TERMS. IF YOU DO NOT AGREE WITH THESE TERMS AND CONDITIONS, DO
NOT USE THIS SPREADSHEET.
USE OF THIS SPREADSHEET IS AT YOUR SOLE RISK, AND AASHTO ACCEPTS NO RESPONSIBILITY FOR THE RESULTS RETURNED.
Instructions MnDOT Updated 08-12-2019
2014 AASHTO
Copyright ©

1: The blue fields are available for data entry.

2: Click the Yellow highlighted field names for a description.
3: Use 'Save As' in Excel to save file. Note the name and the location where you are saving.
4. Upload the spreadsheet/XML file using prescribed Agency method.

CONTRACTOR X SUBCONTRACTOR CONTRACTOR ADDRESS

Addr 1 (a) WHERE FRINGE BENEFITS ARE PAID TO APPROVED PLANS, FUNDS, OR PROGRAMS
Name of Contractor Addr 2
In addition to the basic hourly wage rates paid to each laborer or mechanic listed in the above referenced payroll, payments of fringe benfits
MN Swift Vendor Number City State: as listed in the contract have been or will be made to appropriate programs for the benefit of such employees, except as noted in section
4(c) below.
Payroll Number Zip :
Week Ending Date xx/xx/xxxx Contract # (b) WHERE FRINGE BENEFITS ARE PAID IN CASH

Each laborer or mechanic listed in the above referenced payroll has been paid, as indicated on the payroll, an amount not less than the sum
Day Select Day Select Day Select Day Select Day Select Day Select Day Select Day of the applicable basic hourly wage rate plus the amount fo the required fringe benefits as listed in the contract, except as noted in section
4(c) below.
Date #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE!

Once you select a "Benefit Program Type", you must complete the corresponding column information for the system to accept the benefit.
Benefit Program Name Benefit Program Type Benefit Account Number Benefit Labor Classification Contact Person Contact Person's Phone
Select Type
Select Type
Select Type
Select Type
Select Type
Select Type
Select Type
Select Type
Select Type
Select Type
Select Type
Select Type
Select Type
Select Type
Select Type
Select Type
Select Type
Select Type

O.T. Total Project RATE OF

Individual Employee Name and Identifier S.T. Over Time Hours HOURS WORKED EACH DAY Classification
S.H. Straight Time Hours Hours PAY
Salaried Time Hours
Last Name
First Name O.T. 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Project #
Middle Initial S.T. 0.00 0.00 0.00 0.00 0.00 0.00 0.00
SSN (full 9-digit #) S.H. 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Employee Comments
Partial SSN Craft Code Select Craft Code
OJT % Apprentice ID Apprentice
Wage % Lump Sum Project Gross
Vendor Emp ID Labor Code Select Labor Code
Gender Select Gender Code Code
Ethnicity Code Select Ethnicity Salaried Employee Only Pay Period Check Stub Area
Addr Line 1 Federal State Income Other Total NET
Total Pay Period Normal Salary Gross Pay FICA Medicare
Addr Line 2 Salaried Hours Income Tax Tax Deductions Deductions WAGES
City
State Select State Code Classification Fringe Benefit Hourly Rate Credits
Zip Health Vacation Apprentice Total Project Fringe Benefits Paid for this Classification for
Welfare Holiday Fund Pension Other 1 Other 2 this Pay Period (Rates x Hours)
Has Changed? false
Salaried (y/n) : No

4(c) EXCEPTION (CRAFT) Put the Craft in the first cell below and the reason in the second cell below Other Payroll Deductions
If you enter a description you need to enter a dollar amount. If you enter an dollar amount you need to enter a description
Other Deduction Description Amount

O.T. Total Project RATE OF

Individual Employee Name and Identifier S.T. Over Time Hours Hours Worked Classification
S.H. Straight Time Hours Hours PAY
Salaried Time Hours
Last Name
First Name O.T. 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Project #
Middle Initial S.T. 0.00 0.00 0.00 0.00 0.00 0.00 0.00
SSN (full 9-digit #) S.H. 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Employee Comments
Partial SSN Craft Code Select Craft Code
OJT % Apprentice ID Apprentice
Wage % Lump Sum Project Gross
Vendor Emp ID Labor Code Select Labor Code
Gender Select Gender Code Code
Ethnicity Code Select Ethnicity Salaried Employee Only Pay Period Check Stub Area
Addr Line 1 Federal State Income Other Total NET
Total Pay Period Normal Salary Gross Pay FICA Medicare
Addr Line 2 Salaried Hours Income Tax Tax Deductions Deductions WAGES
City
State Select State Code Classification Fringe Benefit Hourly Rate Credits
Zip Health Vacation Apprentice Fringe
Welfare Holiday Fund Pension Other 1 Other 2 Benefits
Has Changed? false Total
Salaried (y/n) : No

4(c) EXCEPTION (CRAFT) Put the Craft in the first cell below and the reason in the second cell below Other Payroll Deductions

Other Deduction Description Amount

O.T. Total Project RATE OF

Individual Employee Name and Identifier S.T. Over Time Hours Hours Worked Classification
S.H. Straight Time Hours Hours PAY
Salaried Time Hours
Last Name
First Name O.T. 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Project #
Middle Initial S.T. 0.00 0.00 0.00 0.00 0.00 0.00 0.00
SSN (full 9-digit #) S.H. 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Employee Comments
Partial SSN Craft Code Select Craft Code
OJT % Apprentice ID Apprentice
Wage % Lump Sum Project Gross
Vendor Emp ID Labor Code Select Labor Code
Gender Select Gender Code Code
Ethnicity Code Select Ethnicity Salaried Employee Only Pay Period Check Stub Area
Addr Line 1 Federal State Income Other Total NET
Total Pay Period Normal Salary Gross Pay FICA Medicare
Addr Line 2 Salaried Hours Income Tax Tax Deductions Deductions WAGES
City
State Select State Code Classification Fringe Benefit Hourly Rate Credits
Zip Health Vacation Apprentice Fringe
Welfare Holiday Fund Pension Other 1 Other 2 Benefits
Has Changed? false Total
Salaried (y/n) : No

4(c) EXCEPTION (CRAFT) Put the Craft in the first cell below and the reason in the second cell below Other Payroll Deductions

Other Deduction Description Amount

O.T. Total Project RATE OF

Individual Employee Name and Identifier S.T. Over Time Hours Hours Worked Classification
S.H. Straight Time Hours Hours PAY
Salaried Time Hours
Last Name
First Name O.T. 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Project #
Middle Initial S.T. 0.00 0.00 0.00 0.00 0.00 0.00 0.00
SSN (full 9-digit #) S.H. 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Employee Comments
Partial SSN Craft Code Select Craft Code
OJT % Apprentice ID Apprentice
Wage % Lump Sum Project Gross
Vendor Emp ID Labor Code Select Labor Code
Gender Select Gender Code Code
Ethnicity Code Select Ethnicity Salaried Employee Only Pay Period Check Stub Area
Addr Line 1 Federal State Income Other Total NET
Total Pay Period Normal Salary Gross Pay FICA Medicare
Addr Line 2 Salaried Hours Income Tax Tax Deductions Deductions WAGES
City
State Select State Code Classification Fringe Benefit Hourly Rate Credits
Zip Health Vacation Apprentice Fringe
Welfare Holiday Fund Pension Other 1 Other 2 Benefits
Has Changed? false Total
Salaried (y/n) : No

4(c) EXCEPTION (CRAFT) Put the Craft in the first cell below and the reason in the second cell below Other Payroll Deductions

Other Deduction Description Amount

O.T. Total Project RATE OF

Individual Employee Name and Identifier S.T. Over Time Hours Hours Worked Classification
S.H. Straight Time Hours Hours PAY
Salaried Time Hours
Last Name
First Name O.T. 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Project #
Middle Initial S.T. 0.00 0.00 0.00 0.00 0.00 0.00 0.00
SSN (full 9-digit #) S.H. 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Employee Comments
Partial SSN Craft Code Select Craft Code
OJT % Apprentice ID Apprentice
Wage % Lump Sum Project Gross
Vendor Emp ID Labor Code Select Labor Code
Gender Select Gender Code Code
Ethnicity Code Select Ethnicity Salaried Employee Only Pay Period Check Stub Area
Addr Line 1 Federal State Income Other Total NET
Total Pay Period Normal Salary Gross Pay FICA Medicare
Addr Line 2 Salaried Hours Income Tax Tax Deductions Deductions WAGES
City
State Select State Code Classification Fringe Benefit Hourly Rate Credits
Zip Health Vacation Apprentice Fringe
Welfare Holiday Fund Pension Other 1 Other 2 Benefits
Has Changed? false Total
Salaried (y/n) : No

4(c) EXCEPTION (CRAFT) Put the Craft in the first cell below and the reason in the second cell below Other Payroll Deductions

Other Deduction Description Amount

O.T. Total Project RATE OF

Individual Employee Name and Identifier S.T. Over Time Hours Hours Worked Classification
S.H. Straight Time Hours Hours PAY
Salaried Time Hours
Last Name
First Name O.T. 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Project #
Middle Initial S.T. 0.00 0.00 0.00 0.00 0.00 0.00 0.00
SSN (full 9-digit #) S.H. 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Employee Comments
Partial SSN Craft Code Select Craft Code
OJT % Apprentice ID Apprentice
Wage % Lump Sum Project Gross
Vendor Emp ID Labor Code Select Labor Code
Gender Select Gender Code Code
Ethnicity Code Select Ethnicity Salaried Employee Only Pay Period Check Stub Area
Addr Line 1 Federal State Income Other Total NET
Total Pay Period Normal Salary Gross Pay FICA Medicare
Addr Line 2 Salaried Hours Income Tax Tax Deductions Deductions WAGES
City
State Select State Code Classification Fringe Benefit Hourly Rate Credits
Zip Health Vacation Apprentice Fringe
Welfare Holiday Fund Pension Other 1 Other 2 Benefits
Has Changed? false Total
Salaried (y/n) : No

4(c) EXCEPTION (CRAFT) Put the Craft in the first cell below and the reason in the second cell below Other Payroll Deductions

Other Deduction Description Amount

O.T. Total Project RATE OF

Individual Employee Name and Identifier S.T. Over Time Hours Hours Worked Classification
S.H. Straight Time Hours Hours PAY
Salaried Time Hours
Last Name
First Name O.T. 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Project #
Middle Initial S.T. 0.00 0.00 0.00 0.00 0.00 0.00 0.00
SSN (full 9-digit #) S.H. 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Employee Comments
Partial SSN Craft Code Select Craft Code
OJT % Apprentice ID Apprentice
Wage % Lump Sum Project Gross
Vendor Emp ID Labor Code Select Labor Code
Gender Select Gender Code Code
Ethnicity Code Select Ethnicity Salaried Employee Only Pay Period Check Stub Area
Addr Line 1 Federal State Income Other Total NET
Total Pay Period Normal Salary Gross Pay FICA Medicare
Addr Line 2 Salaried Hours Income Tax Tax Deductions Deductions WAGES
City
State Select State Code Classification Fringe Benefit Hourly Rate Credits
Zip Health Vacation Apprentice Fringe
Welfare Holiday Fund Pension Other 1 Other 2 Benefits
Has Changed? false Total
Salaried (y/n) : No

4(c) EXCEPTION (CRAFT) Put the Craft in the first cell below and the reason in the second cell below Other Payroll Deductions

Other Deduction Description Amount

O.T. Total Project RATE OF

Individual Employee Name and Identifier S.T. Over Time Hours Hours Worked Classification
S.H. Straight Time Hours Hours PAY
Salaried Time Hours
Last Name
First Name O.T. 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Project #
Middle Initial S.T. 0.00 0.00 0.00 0.00 0.00 0.00 0.00
SSN (full 9-digit #) S.H. 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Employee Comments
Partial SSN Craft Code Select Craft Code
OJT % Apprentice ID Apprentice
Wage % Lump Sum Project Gross
Vendor Emp ID Labor Code Select Labor Code
Gender Select Gender Code Code
Ethnicity Code Select Ethnicity Salaried Employee Only Pay Period Check Stub Area
Addr Line 1 Federal State Income Other Total NET
Total Pay Period Normal Salary Gross Pay FICA Medicare
Addr Line 2 Salaried Hours Income Tax Tax Deductions Deductions WAGES
City
State Select State Code Classification Fringe Benefit Hourly Rate Credits
Zip Health Vacation Apprentice Fringe
Welfare Holiday Fund Pension Other 1 Other 2 Benefits
Has Changed? false Total
Salaried (y/n) : No

4(c) EXCEPTION (CRAFT) Put the Craft in the first cell below and the reason in the second cell below Other Payroll Deductions

Other Deduction Description Amount

O.T. Total Project RATE OF

Individual Employee Name and Identifier S.T. Over Time Hours Hours Worked Classification
S.H. Straight Time Hours Hours PAY
Salaried Time Hours
Last Name
First Name O.T. 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Project #
Middle Initial S.T. 0.00 0.00 0.00 0.00 0.00 0.00 0.00
SSN (full 9-digit #) S.H. 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Employee Comments
Partial SSN Craft Code Select Craft Code
OJT % Apprentice ID Apprentice
Wage % Lump Sum Project Gross
Vendor Emp ID Labor Code Select Labor Code
Gender Select Gender Code Code
Ethnicity Code Select Ethnicity Salaried Employee Only Pay Period Check Stub Area
Addr Line 1 Federal State Income Other Total NET
Total Pay Period Normal Salary Gross Pay FICA Medicare
Addr Line 2 Salaried Hours Income Tax Tax Deductions Deductions WAGES
City
State Select State Code Classification Fringe Benefit Hourly Rate Credits
Zip Health Vacation Apprentice Fringe
Welfare Holiday Fund Pension Other 1 Other 2 Benefits
Has Changed? false Total
Salaried (y/n) : No

4(c) EXCEPTION (CRAFT) Put the Craft in the first cell below and the reason in the second cell below Other Payroll Deductions

Other Deduction Description Amount

O.T. Total Project RATE OF

Individual Employee Name and Identifier S.T. Over Time Hours Hours Worked Classification
S.H. Straight Time Hours Hours PAY
Salaried Time Hours
Last Name
First Name O.T. 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Project #
Middle Initial S.T. 0.00 0.00 0.00 0.00 0.00 0.00 0.00
SSN (full 9-digit #) S.H. 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Employee Comments
Partial SSN Craft Code Select Craft Code
OJT % Apprentice ID Apprentice
Wage % Lump Sum Project Gross
Vendor Emp ID Labor Code Select Labor Code
Gender Select Gender Code Code
Ethnicity Code Select Ethnicity Salaried Employee Only Pay Period Check Stub Area
Addr Line 1 Federal State Income Other Total NET
Total Pay Period Normal Salary Gross Pay FICA Medicare
Addr Line 2 Salaried Hours Income Tax Tax Deductions Deductions WAGES
City
State Select State Code Classification Fringe Benefit Hourly Rate Credits
Zip Health Vacation Apprentice Fringe
Welfare Holiday Fund Pension Other 1 Other 2 Benefits
Has Changed? false Total
Salaried (y/n) : No

4(c) EXCEPTION (CRAFT) Put the Craft in the first cell below and the reason in the second cell below Other Payroll Deductions

Other Deduction Description Amount

O.T. Total Project RATE OF

Individual Employee Name and Identifier S.T. Over Time Hours Hours Worked Classification
S.H. Straight Time Hours Hours PAY
Salaried Time Hours
Last Name
First Name O.T. 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Project #
Middle Initial S.T. 0.00 0.00 0.00 0.00 0.00 0.00 0.00
SSN (full 9-digit #) S.H. 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Employee Comments
Partial SSN Craft Code Select Craft Code
OJT % Apprentice ID Apprentice
Wage % Lump Sum Project Gross
Vendor Emp ID Labor Code Select Labor Code
Gender Select Gender Code Code
Ethnicity Code Select Ethnicity Salaried Employee Only Pay Period Check Stub Area
Addr Line 1 Federal State Income Other Total NET
Total Pay Period Normal Salary Gross Pay FICA Medicare
Addr Line 2 Salaried Hours Income Tax Tax Deductions Deductions WAGES
City
State Select State Code Classification Fringe Benefit Hourly Rate Credits
Zip Health Vacation Apprentice Fringe
Welfare Holiday Fund Pension Other 1 Other 2 Benefits
Has Changed? false Total
Salaried (y/n) : No

4(c) EXCEPTION (CRAFT) Put the Craft in the first cell below and the reason in the second cell below Other Payroll Deductions

Other Deduction Description Amount

O.T. Total Project RATE OF

Individual Employee Name and Identifier S.T. Over Time Hours Hours Worked Classification
S.H. Straight Time Hours Hours PAY
Salaried Time Hours
Last Name
First Name O.T. 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Project #
Middle Initial S.T. 0.00 0.00 0.00 0.00 0.00 0.00 0.00
SSN (full 9-digit #) S.H. 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Employee Comments
Partial SSN Craft Code Select Craft Code
OJT % Apprentice ID Apprentice
Wage % Lump Sum Project Gross
Vendor Emp ID Labor Code Select Labor Code
Gender Select Gender Code Code
Ethnicity Code Select Ethnicity Salaried Employee Only Pay Period Check Stub Area
Addr Line 1 Federal State Income Other Total NET
Total Pay Period Normal Salary Gross Pay FICA Medicare
Addr Line 2 Salaried Hours Income Tax Tax Deductions Deductions WAGES
City
State Select State Code Classification Fringe Benefit Hourly Rate Credits
Zip Health Vacation Apprentice Fringe
Welfare Holiday Fund Pension Other 1 Other 2 Benefits
Has Changed? false Total
Salaried (y/n) : No

4(c) EXCEPTION (CRAFT) Put the Craft in the first cell below and the reason in the second cell below Other Payroll Deductions

Other Deduction Description Amount

O.T. Total Project RATE OF

Individual Employee Name and Identifier S.T. Over Time Hours Hours Worked Classification
S.H. Straight Time Hours Hours PAY
Salaried Time Hours
Last Name
First Name O.T. 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Project #
Middle Initial S.T. 0.00 0.00 0.00 0.00 0.00 0.00 0.00
SSN (full 9-digit #) S.H. 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Employee Comments
Partial SSN Craft Code Select Craft Code
OJT % Apprentice ID Apprentice
Wage % Lump Sum Project Gross
Vendor Emp ID Labor Code Select Labor Code
Gender Select Gender Code Code
Ethnicity Code Select Ethnicity Salaried Employee Only Pay Period Check Stub Area
Addr Line 1 Federal State Income Other Total NET
Total Pay Period Normal Salary Gross Pay FICA Medicare
Addr Line 2 Salaried Hours Income Tax Tax Deductions Deductions WAGES
City
State Select State Code Classification Fringe Benefit Hourly Rate Credits
Zip Health Vacation Apprentice Fringe
Welfare Holiday Fund Pension Other 1 Other 2 Benefits
Has Changed? false Total
Salaried (y/n) : No

4(c) EXCEPTION (CRAFT) Put the Craft in the first cell below and the reason in the second cell below Other Payroll Deductions

Other Deduction Description Amount

O.T. Total Project RATE OF

Individual Employee Name and Identifier S.T. Over Time Hours Hours Worked Classification
S.H. Straight Time Hours Hours PAY
Salaried Time Hours
Last Name
First Name O.T. 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Project #
Middle Initial S.T. 0.00 0.00 0.00 0.00 0.00 0.00 0.00
SSN (full 9-digit #) S.H. 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Employee Comments
Partial SSN Craft Code Select Craft Code
OJT % Apprentice ID Apprentice
Wage % Lump Sum Project Gross
Vendor Emp ID Labor Code Select Labor Code
Gender Select Gender Code Code
Ethnicity Code Select Ethnicity Salaried Employee Only Pay Period Check Stub Area
Addr Line 1 Federal State Income Other Total NET
Total Pay Period Normal Salary Gross Pay FICA Medicare
Addr Line 2 Salaried Hours Income Tax Tax Deductions Deductions WAGES
City
State Select State Code Classification Fringe Benefit Hourly Rate Credits
Zip Health Vacation Apprentice Fringe
Welfare Holiday Fund Pension Other 1 Other 2 Benefits
Has Changed? false Total
Salaried (y/n) : No

4(c) EXCEPTION (CRAFT) Put the Craft in the first cell below and the reason in the second cell below Other Payroll Deductions

Other Deduction Description Amount

O.T. Total Project RATE OF

Individual Employee Name and Identifier S.T. Over Time Hours Hours Worked Classification
S.H. Straight Time Hours Hours PAY
Salaried Time Hours
Last Name
First Name O.T. 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Project #
Middle Initial S.T. 0.00 0.00 0.00 0.00 0.00 0.00 0.00
SSN (full 9-digit #) S.H. 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Employee Comments
Partial SSN Craft Code Select Craft Code
OJT % Apprentice ID Apprentice
Wage % Lump Sum Project Gross
Vendor Emp ID Labor Code Select Labor Code
Gender Select Gender Code Code
 Ethnicity Code Select Ethnicity Salaried Employee Only Pay Period Check Stub Area
Addr Line 1 Federal State Income Other Total NET
Total Pay Period Normal Salary Gross Pay FICA Medicare
Addr Line 2 Salaried Hours Income Tax Tax Deductions Deductions WAGES
City
State Select State Code Classification Fringe Benefit Hourly Rate Credits
Zip Health Vacation Apprentice Fringe
Welfare Holiday Fund Pension Other 1 Other 2 Benefits
Has Changed? false Total
Salaried (y/n) : No

4(c) EXCEPTION (CRAFT) Put the Craft in the first cell below and the reason in the second cell below Other Payroll Deductions

Other Deduction Description Amount

O.T. Total Project RATE OF

Individual Employee Name and Identifier S.T. Over Time Hours Hours Worked Classification
S.H. Straight Time Hours Hours PAY
Salaried Time Hours
Last Name
First Name O.T. 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Project #
Middle Initial S.T. 0.00 0.00 0.00 0.00 0.00 0.00 0.00
SSN (full 9-digit #) S.H. 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Employee Comments
Partial SSN Craft Code Select Craft Code
OJT % Apprentice ID Apprentice
Wage % Lump Sum Project Gross
Vendor Emp ID Labor Code Select Labor Code
Gender Select Gender Code Code
Ethnicity Code Select Ethnicity Salaried Employee Only Pay Period Check Stub Area
Addr Line 1 Federal State Income Other Total NET
Total Pay Period Normal Salary Gross Pay FICA Medicare
Addr Line 2 Salaried Hours Income Tax Tax Deductions Deductions WAGES
City
State Select State Code Classification Fringe Benefit Hourly Rate Credits
Zip Health Vacation Apprentice Fringe
Welfare Holiday Fund Pension Other 1 Other 2 Benefits
Has Changed? false Total
Salaried (y/n) : No

4(c) EXCEPTION (CRAFT) Put the Craft in the first cell below and the reason in the second cell below Other Payroll Deductions

Other Deduction Description Amount

O.T. Total Project RATE OF

Individual Employee Name and Identifier S.T. Over Time Hours Hours Worked Classification
S.H. Straight Time Hours Hours PAY
Salaried Time Hours
Last Name
First Name O.T. 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Project #
Middle Initial S.T. 0.00 0.00 0.00 0.00 0.00 0.00 0.00
SSN (full 9-digit #) S.H. 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Employee Comments
Partial SSN Craft Code Select Craft Code
OJT % Apprentice ID Apprentice
Wage % Lump Sum Project Gross
Vendor Emp ID Labor Code Select Labor Code
Gender Select Gender Code Code
Ethnicity Code Select Ethnicity Salaried Employee Only Pay Period Check Stub Area
Addr Line 1 Federal State Income Other Total NET
Total Pay Period Normal Salary Gross Pay FICA Medicare
Addr Line 2 Salaried Hours Income Tax Tax Deductions Deductions WAGES
City
State Select State Code Classification Fringe Benefit Hourly Rate Credits
Zip Health Vacation Apprentice Fringe
Welfare Holiday Fund Pension Other 1 Other 2 Benefits
Has Changed? false Total
Salaried (y/n) : No

4(c) EXCEPTION (CRAFT) Put the Craft in the first cell below and the reason in the second cell below Other Payroll Deductions

Other Deduction Description Amount

O.T. Total Project RATE OF

Individual Employee Name and Identifier S.T. Over Time Hours Hours Worked Classification
S.H. Straight Time Hours Hours PAY
Salaried Time Hours
Last Name
First Name O.T. 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Project #
Middle Initial S.T. 0.00 0.00 0.00 0.00 0.00 0.00 0.00
SSN (full 9-digit #) S.H. 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Employee Comments
Partial SSN Craft Code Select Craft Code
OJT % Apprentice ID Apprentice
Wage % Lump Sum Project Gross
Vendor Emp ID Labor Code Select Labor Code
Gender Select Gender Code Code
Ethnicity Code Select Ethnicity Salaried Employee Only Pay Period Check Stub Area
Addr Line 1 Federal State Income Other Total NET
Total Pay Period Normal Salary Gross Pay FICA Medicare
Addr Line 2 Salaried Hours Income Tax Tax Deductions Deductions WAGES
City
State Select State Code Classification Fringe Benefit Hourly Rate Credits
Zip Health Vacation Apprentice Fringe
Welfare Holiday Fund Pension Other 1 Other 2 Benefits
Has Changed? false Total
Salaried (y/n) : No

4(c) EXCEPTION (CRAFT) Put the Craft in the first cell below and the reason in the second cell below Other Payroll Deductions

Other Deduction Description Amount

O.T. Total Project RATE OF

Individual Employee Name and Identifier S.T. Over Time Hours Hours Worked Classification
S.H. Straight Time Hours Hours PAY
Salaried Time Hours
Last Name
First Name O.T. 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Project #
Middle Initial S.T. 0.00 0.00 0.00 0.00 0.00 0.00 0.00
SSN (full 9-digit #) S.H. 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Employee Comments
Partial SSN Craft Code Select Craft Code
OJT % Apprentice ID Apprentice
Wage % Lump Sum Project Gross
Vendor Emp ID Labor Code Select Labor Code
Gender Select Gender Code Code
Ethnicity Code Select Ethnicity Salaried Employee Only Pay Period Check Stub Area
Addr Line 1 Federal State Income Other Total NET
Total Pay Period Normal Salary Gross Pay FICA Medicare
Addr Line 2 Salaried Hours Income Tax Tax Deductions Deductions WAGES
City
State Select State Code Classification Fringe Benefit Hourly Rate Credits
Zip Health Vacation Apprentice Fringe
Welfare Holiday Fund Pension Other 1 Other 2 Benefits
Has Changed? false Total
Salaried (y/n) : No

4(c) EXCEPTION (CRAFT) Put the Craft in the first cell below and the reason in the second cell below Other Payroll Deductions

Other Deduction Description Amount

O.T. Total Project RATE OF

Individual Employee Name and Identifier S.T. Over Time Hours Hours Worked Classification
S.H. Straight Time Hours Hours PAY
Salaried Time Hours
Last Name
First Name O.T. 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Project #
Middle Initial S.T. 0.00 0.00 0.00 0.00 0.00 0.00 0.00
SSN (full 9-digit #) S.H. 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Employee Comments
Partial SSN Craft Code Select Craft Code
OJT % Apprentice ID Apprentice
Wage % Lump Sum Project Gross
Vendor Emp ID Labor Code Select Labor Code
Gender Select Gender Code Code
Ethnicity Code Select Ethnicity Salaried Employee Only Pay Period Check Stub Area
Addr Line 1 Federal State Income Other Total NET
Total Pay Period Normal Salary Gross Pay FICA Medicare
Addr Line 2 Salaried Hours Income Tax Tax Deductions Deductions WAGES
City
State Select State Code Classification Fringe Benefit Hourly Rate Credits
Zip Health Vacation Apprentice Fringe
Welfare Holiday Fund Pension Other 1 Other 2 Benefits
Has Changed? false Total
Salaried (y/n) : No

4(c) EXCEPTION (CRAFT) Put the Craft in the first cell below and the reason in the second cell below Other Payroll Deductions

Other Deduction Description Amount

O.T. Total Project RATE OF

Individual Employee Name and Identifier S.T. Over Time Hours Hours Worked Classification
S.H. Straight Time Hours Hours PAY
Salaried Time Hours
Last Name
First Name O.T. 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Project #
Middle Initial S.T. 0.00 0.00 0.00 0.00 0.00 0.00 0.00
SSN (full 9-digit #) S.H. 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Employee Comments
Partial SSN Craft Code Select Craft Code
OJT % Apprentice ID Apprentice
Wage % Lump Sum Project Gross
Vendor Emp ID Labor Code Select Labor Code
Gender Select Gender Code Code
Ethnicity Code Select Ethnicity Salaried Employee Only Pay Period Check Stub Area
Addr Line 1 Federal State Income Other Total NET
Total Pay Period Normal Salary Gross Pay FICA Medicare
Addr Line 2 Salaried Hours Income Tax Tax Deductions Deductions WAGES
City
State Select State Code Classification Fringe Benefit Hourly Rate Credits
Zip Health Vacation Apprentice Fringe
Welfare Holiday Fund Pension Other 1 Other 2 Benefits
Has Changed? false Total
Salaried (y/n) : No

4(c) EXCEPTION (CRAFT) Put the Craft in the first cell below and the reason in the second cell below Other Payroll Deductions

Other Deduction Description Amount

O.T. Total Project RATE OF

Individual Employee Name and Identifier S.T. Over Time Hours Hours Worked Classification
S.H. Straight Time Hours Hours PAY
Salaried Time Hours
Last Name
First Name O.T. 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Project #
Middle Initial S.T. 0.00 0.00 0.00 0.00 0.00 0.00 0.00
SSN (full 9-digit #) S.H. 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Employee Comments
Partial SSN Craft Code Select Craft Code
OJT % Apprentice ID Apprentice
Wage % Lump Sum Project Gross
Vendor Emp ID Labor Code Select Labor Code
Gender Select Gender Code Code
Ethnicity Code Select Ethnicity Salaried Employee Only Pay Period Check Stub Area
Addr Line 1 Federal State Income Other Total NET
Total Pay Period Normal Salary Gross Pay FICA Medicare
Addr Line 2 Salaried Hours Income Tax Tax Deductions Deductions WAGES
City
State Select State Code Classification Fringe Benefit Hourly Rate Credits
Zip Health Vacation Apprentice Fringe
Welfare Holiday Fund Pension Other 1 Other 2 Benefits
Has Changed? false Total
Salaried (y/n) : No

4(c) EXCEPTION (CRAFT) Put the Craft in the first cell below and the reason in the second cell below Other Payroll Deductions

Other Deduction Description Amount

O.T. Total Project RATE OF

Individual Employee Name and Identifier S.T. Over Time Hours Hours Worked Classification
S.H. Straight Time Hours Hours PAY
Salaried Time Hours
Last Name
First Name O.T. 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Project #
Middle Initial S.T. 0.00 0.00 0.00 0.00 0.00 0.00 0.00
SSN (full 9-digit #) S.H. 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Employee Comments
Partial SSN Craft Code Select Craft Code
OJT % Apprentice ID Apprentice
Wage % Lump Sum Project Gross
Vendor Emp ID Labor Code Select Labor Code
Gender Select Gender Code Code
Ethnicity Code Select Ethnicity Salaried Employee Only Pay Period Check Stub Area
Addr Line 1 Federal State Income Other Total NET
Total Pay Period Normal Salary Gross Pay FICA Medicare
Addr Line 2 Salaried Hours Income Tax Tax Deductions Deductions WAGES
City
State Select State Code Classification Fringe Benefit Hourly Rate Credits
Zip Health Vacation Apprentice Fringe
Welfare Holiday Fund Pension Other 1 Other 2 Benefits
Has Changed? false Total
Salaried (y/n) : No

4(c) EXCEPTION (CRAFT) Put the Craft in the first cell below and the reason in the second cell below Other Payroll Deductions

Other Deduction Description Amount

O.T. Total Project RATE OF

Individual Employee Name and Identifier S.T. Over Time Hours Hours Worked Classification
S.H. Straight Time Hours Hours PAY
Salaried Time Hours
Last Name
First Name O.T. 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Project #
Middle Initial S.T. 0.00 0.00 0.00 0.00 0.00 0.00 0.00
SSN (full 9-digit #) S.H. 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Employee Comments
Partial SSN Craft Code Select Craft Code
OJT % Apprentice ID Apprentice
Wage % Lump Sum Project Gross
Vendor Emp ID Labor Code Select Labor Code
Gender Select Gender Code Code
Ethnicity Code Select Ethnicity Salaried Employee Only Pay Period Check Stub Area
Addr Line 1 Federal State Income Other Total NET
Total Pay Period Normal Salary Gross Pay FICA Medicare
Addr Line 2 Salaried Hours Income Tax Tax Deductions Deductions WAGES
City
State Select State Code Classification Fringe Benefit Hourly Rate Credits
Zip Health Vacation Apprentice Fringe
Welfare Holiday Fund Pension Other 1 Other 2 Benefits
Has Changed? false Total
Salaried (y/n) : No

4(c) EXCEPTION (CRAFT) Put the Craft in the first cell below and the reason in the second cell below Other Payroll Deductions

Other Deduction Description Amount

O.T. Total Project RATE OF

Individual Employee Name and Identifier S.T. Over Time Hours Hours Worked Classification
S.H. Straight Time Hours Hours PAY
Salaried Time Hours
Last Name
First Name O.T. 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Project #
Middle Initial S.T. 0.00 0.00 0.00 0.00 0.00 0.00 0.00
SSN (full 9-digit #) S.H. 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Employee Comments
Partial SSN Craft Code Select Craft Code
OJT % Apprentice ID Apprentice
Wage % Lump Sum Project Gross
Vendor Emp ID Labor Code Select Labor Code
Gender Select Gender Code Code
Ethnicity Code Select Ethnicity Salaried Employee Only Pay Period Check Stub Area
Addr Line 1 Federal State Income Other Total NET
Total Pay Period Normal Salary Gross Pay FICA Medicare
Addr Line 2 Salaried Hours Income Tax Tax Deductions Deductions WAGES
City
State Select State Code Classification Fringe Benefit Hourly Rate Credits
Zip Health Vacation Apprentice Fringe
Welfare Holiday Fund Pension Other 1 Other 2 Benefits
Has Changed? false Total
Salaried (y/n) : No

4(c) EXCEPTION (CRAFT) Put the Craft in the first cell below and the reason in the second cell below Other Payroll Deductions

Other Deduction Description Amount

O.T. Total Project RATE OF

Individual Employee Name and Identifier S.T. Over Time Hours Hours Worked Classification
S.H. Straight Time Hours Hours PAY
Salaried Time Hours
Last Name
First Name O.T. 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Project #
Middle Initial S.T. 0.00 0.00 0.00 0.00 0.00 0.00 0.00
SSN (full 9-digit #) S.H. 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Employee Comments
Partial SSN Craft Code Select Craft Code
OJT % Apprentice ID Apprentice
Wage % Lump Sum Project Gross
Vendor Emp ID Labor Code Select Labor Code
Gender Select Gender Code Code
Ethnicity Code Select Ethnicity Salaried Employee Only Pay Period Check Stub Area
Addr Line 1 Federal State Income Other Total NET
Total Pay Period Normal Salary Gross Pay FICA Medicare
Addr Line 2 Salaried Hours Income Tax Tax Deductions Deductions WAGES
City
State Select State Code Classification Fringe Benefit Hourly Rate Credits
Zip Health Vacation Apprentice Fringe
Welfare Holiday Fund Pension Other 1 Other 2 Benefits
Has Changed? false Total
Salaried (y/n) : No

4(c) EXCEPTION (CRAFT) Put the Craft in the first cell below and the reason in the second cell below Other Payroll Deductions

Other Deduction Description Amount

O.T. Total Project RATE OF

Individual Employee Name and Identifier S.T. Over Time Hours Hours Worked Classification
S.H. Straight Time Hours Hours PAY
Salaried Time Hours
Last Name
First Name O.T. 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Project #
Middle Initial S.T. 0.00 0.00 0.00 0.00 0.00 0.00 0.00
SSN (full 9-digit #) S.H. 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Employee Comments
Partial SSN Craft Code Select Craft Code
OJT % Apprentice ID Apprentice
Wage % Lump Sum Project Gross
Vendor Emp ID Labor Code Select Labor Code
Gender Select Gender Code Code
Ethnicity Code Select Ethnicity Salaried Employee Only Pay Period Check Stub Area
Addr Line 1 Federal State Income Other Total NET
Total Pay Period Normal Salary Gross Pay FICA Medicare
Addr Line 2 Salaried Hours Income Tax Tax Deductions Deductions WAGES
City
State Select State Code Classification Fringe Benefit Hourly Rate Credits
Zip Health Vacation Apprentice Fringe
Welfare Holiday Fund Pension Other 1 Other 2 Benefits
Has Changed? false Total
Salaried (y/n) : No

4(c) EXCEPTION (CRAFT) Put the Craft in the first cell below and the reason in the second cell below Other Payroll Deductions

Other Deduction Description Amount

O.T. Total Project RATE OF

Individual Employee Name and Identifier S.T. Over Time Hours Hours Worked Classification
S.H. Straight Time Hours Hours PAY
Salaried Time Hours
Last Name
First Name O.T. 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Project #
Middle Initial S.T. 0.00 0.00 0.00 0.00 0.00 0.00 0.00
SSN (full 9-digit #) S.H. 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Employee Comments
Partial SSN Craft Code Select Craft Code
OJT % Apprentice ID Apprentice
Wage % Lump Sum Project Gross
Vendor Emp ID Labor Code Select Labor Code
Gender Select Gender Code Code
Ethnicity Code Select Ethnicity Salaried Employee Only Pay Period Check Stub Area
Addr Line 1 Federal State Income Other Total NET
Total Pay Period Normal Salary Gross Pay FICA Medicare
Addr Line 2 Salaried Hours Income Tax Tax Deductions Deductions WAGES
City
State Select State Code Classification Fringe Benefit Hourly Rate Credits
Zip Health Vacation Apprentice Fringe
Welfare Holiday Fund Pension Other 1 Other 2 Benefits
Has Changed? false Total
Salaried (y/n) : No

4(c) EXCEPTION (CRAFT) Put the Craft in the first cell below and the reason in the second cell below Other Payroll Deductions

Other Deduction Description Amount

O.T. Total Project RATE OF

Individual Employee Name and Identifier S.T. Over Time Hours Hours Worked Classification
S.H. Straight Time Hours Hours PAY
Salaried Time Hours
Last Name
First Name O.T. 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Project #
Middle Initial S.T. 0.00 0.00 0.00 0.00 0.00 0.00 0.00
SSN (full 9-digit #) S.H. 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Employee Comments
Partial SSN Craft Code Select Craft Code
OJT % Apprentice ID Apprentice
Wage % Lump Sum Project Gross
Vendor Emp ID Labor Code Select Labor Code
Gender Select Gender Code Code
Ethnicity Code Select Ethnicity Salaried Employee Only Pay Period Check Stub Area
Addr Line 1 Federal State Income Other Total NET
Total Pay Period Normal Salary Gross Pay FICA Medicare
Addr Line 2 Salaried Hours Income Tax Tax Deductions Deductions WAGES
City
State Select State Code Classification Fringe Benefit Hourly Rate Credits
Zip Health Vacation Apprentice Fringe
Welfare Holiday Fund Pension Other 1 Other 2 Benefits
Has Changed? false Total
Salaried (y/n) : No

4(c) EXCEPTION (CRAFT) Put the Craft in the first cell below and the reason in the second cell below Other Payroll Deductions

Other Deduction Description Amount

O.T. Total Project RATE OF

Individual Employee Name and Identifier S.T. Over Time Hours Hours Worked Classification
S.H. Straight Time Hours Hours PAY
Salaried Time Hours
Last Name
First Name O.T. 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Project #
Middle Initial S.T. 0.00 0.00 0.00 0.00 0.00 0.00 0.00
SSN (full 9-digit #) S.H. 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Employee Comments
Partial SSN Craft Code Select Craft Code
OJT % Apprentice ID Apprentice
Wage % Lump Sum Project Gross
Vendor Emp ID Labor Code Select Labor Code
Gender Select Gender Code Code
Ethnicity Code Select Ethnicity Salaried Employee Only Pay Period Check Stub Area
Addr Line 1 Federal State Income Other Total NET
Total Pay Period Normal Salary Gross Pay FICA Medicare
Addr Line 2 Salaried Hours Income Tax Tax Deductions Deductions WAGES
City
State Select State Code Classification Fringe Benefit Hourly Rate Credits
Zip Health Vacation Apprentice Fringe
Welfare Holiday Fund Pension Other 1 Other 2 Benefits
Has Changed? false Total
Salaried (y/n) : No

4(c) EXCEPTION (CRAFT) Put the Craft in the first cell below and the reason in the second cell below Other Payroll Deductions

Other Deduction Description Amount

O.T. Total Project RATE OF

Individual Employee Name and Identifier S.T. Over Time Hours Hours Worked Classification
S.H. Straight Time Hours Hours PAY
Salaried Time Hours
Last Name
First Name O.T. 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Project #
Middle Initial S.T. 0.00 0.00 0.00 0.00 0.00 0.00 0.00
SSN (full 9-digit #) S.H. 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Employee Comments
Partial SSN Craft Code Select Craft Code
OJT % Apprentice ID Apprentice
Wage % Lump Sum Project Gross
 OJT % Apprentice ID Apprentice
Wage % Lump Sum Project Gross
Vendor Emp ID Labor Code Select Labor Code
Gender Select Gender Code Code
Ethnicity Code Select Ethnicity Salaried Employee Only Pay Period Check Stub Area
Addr Line 1 Federal State Income Other Total NET
Total Pay Period Normal Salary Gross Pay FICA Medicare
Addr Line 2 Salaried Hours Income Tax Tax Deductions Deductions WAGES
City
State Select State Code Classification Fringe Benefit Hourly Rate Credits
Zip Health Vacation Apprentice Fringe
Welfare Holiday Fund Pension Other 1 Other 2 Benefits
Has Changed? false Total
Salaried (y/n) : No

4(c) EXCEPTION (CRAFT) Put the Craft in the first cell below and the reason in the second cell below Other Payroll Deductions

Other Deduction Description Amount

O.T. Total Project RATE OF

Individual Employee Name and Identifier S.T. Over Time Hours Hours Worked Classification
S.H. Straight Time Hours Hours PAY
Salaried Time Hours
Last Name
First Name O.T. 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Project #
Middle Initial S.T. 0.00 0.00 0.00 0.00 0.00 0.00 0.00
SSN (full 9-digit #) S.H. 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Employee Comments
Partial SSN Craft Code Select Craft Code
OJT % Apprentice ID Apprentice
Wage % Lump Sum Project Gross
Vendor Emp ID Labor Code Select Labor Code
Gender Select Gender Code Code
Ethnicity Code Select Ethnicity Salaried Employee Only Pay Period Check Stub Area
Addr Line 1 Federal State Income Other Total NET
Total Pay Period Normal Salary Gross Pay FICA Medicare
Addr Line 2 Salaried Hours Income Tax Tax Deductions Deductions WAGES
City
State Select State Code Classification Fringe Benefit Hourly Rate Credits
Zip Health Vacation Apprentice Fringe
Welfare Holiday Fund Pension Other 1 Other 2 Benefits
Has Changed? false Total
Salaried (y/n) : No

4(c) EXCEPTION (CRAFT) Put the Craft in the first cell below and the reason in the second cell below Other Payroll Deductions

Other Deduction Description Amount

O.T. Total Project RATE OF

Individual Employee Name and Identifier S.T. Over Time Hours Hours Worked Classification
S.H. Straight Time Hours Hours PAY
Salaried Time Hours
Last Name
First Name O.T. 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Project #
Middle Initial S.T. 0.00 0.00 0.00 0.00 0.00 0.00 0.00
SSN (full 9-digit #) S.H. 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Employee Comments
Partial SSN Craft Code Select Craft Code
OJT % Apprentice ID Apprentice
Wage % Lump Sum Project Gross
Vendor Emp ID Labor Code Select Labor Code
Gender Select Gender Code Code
Ethnicity Code Select Ethnicity Salaried Employee Only Pay Period Check Stub Area
Addr Line 1 Federal State Income Other Total NET
Total Pay Period Normal Salary Gross Pay FICA Medicare
Addr Line 2 Salaried Hours Income Tax Tax Deductions Deductions WAGES
City
State Select State Code Classification Fringe Benefit Hourly Rate Credits
Zip Health Vacation Apprentice Fringe
Welfare Holiday Fund Pension Other 1 Other 2 Benefits
Has Changed? false Total
Salaried (y/n) : No

4(c) EXCEPTION (CRAFT) Put the Craft in the first cell below and the reason in the second cell below Other Payroll Deductions

Other Deduction Description Amount

O.T. Total Project RATE OF

Individual Employee Name and Identifier S.T. Over Time Hours Hours Worked Classification
S.H. Straight Time Hours Hours PAY
Salaried Time Hours
Last Name
First Name O.T. 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Project #
Middle Initial S.T. 0.00 0.00 0.00 0.00 0.00 0.00 0.00
SSN (full 9-digit #) S.H. 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Employee Comments
Partial SSN Craft Code Select Craft Code
OJT % Apprentice ID Apprentice
Wage % Lump Sum Project Gross
Vendor Emp ID Labor Code Select Labor Code
Gender Select Gender Code Code
Ethnicity Code Select Ethnicity Salaried Employee Only Pay Period Check Stub Area
Addr Line 1 Federal State Income Other Total NET
Total Pay Period Normal Salary Gross Pay FICA Medicare
Addr Line 2 Salaried Hours Income Tax Tax Deductions Deductions WAGES
City
State Select State Code Classification Fringe Benefit Hourly Rate Credits
Zip Health Vacation Apprentice Fringe
Welfare Holiday Fund Pension Other 1 Other 2 Benefits
Has Changed? false Total
Salaried (y/n) : No

4(c) EXCEPTION (CRAFT) Put the Craft in the first cell below and the reason in the second cell below Other Payroll Deductions

Other Deduction Description Amount

O.T. Total Project RATE OF

Individual Employee Name and Identifier S.T. Over Time Hours Hours Worked Classification
S.H. Straight Time Hours Hours PAY
Salaried Time Hours
Last Name
First Name O.T. 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Project #
Middle Initial S.T. 0.00 0.00 0.00 0.00 0.00 0.00 0.00
SSN (full 9-digit #) S.H. 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Employee Comments
Partial SSN Craft Code Select Craft Code
OJT % Apprentice ID Apprentice
Wage % Lump Sum Project Gross
Vendor Emp ID Labor Code Select Labor Code
Gender Select Gender Code Code
Ethnicity Code Select Ethnicity Salaried Employee Only Pay Period Check Stub Area
Addr Line 1 Federal State Income Other Total NET
Total Pay Period Normal Salary Gross Pay FICA Medicare
Addr Line 2 Salaried Hours Income Tax Tax Deductions Deductions WAGES
City
State Select State Code Classification Fringe Benefit Hourly Rate Credits
Zip Health Vacation Apprentice Fringe
Welfare Holiday Fund Pension Other 1 Other 2 Benefits
Has Changed? false Total
Salaried (y/n) : No

4(c) EXCEPTION (CRAFT) Put the Craft in the first cell below and the reason in the second cell below Other Payroll Deductions

Other Deduction Description Amount

O.T. Total Project RATE OF

Individual Employee Name and Identifier S.T. Over Time Hours Hours Worked Classification
S.H. Straight Time Hours Hours PAY
Salaried Time Hours
Last Name
First Name O.T. 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Project #
Middle Initial S.T. 0.00 0.00 0.00 0.00 0.00 0.00 0.00
SSN (full 9-digit #) S.H. 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Employee Comments
Partial SSN Craft Code Select Craft Code
OJT % Apprentice ID Apprentice
Wage % Lump Sum Project Gross
Vendor Emp ID Labor Code Select Labor Code
Gender Select Gender Code Code
Ethnicity Code Select Ethnicity Salaried Employee Only Pay Period Check Stub Area
Addr Line 1 Federal State Income Other Total NET
Total Pay Period Normal Salary Gross Pay FICA Medicare
Addr Line 2 Salaried Hours Income Tax Tax Deductions Deductions WAGES
City
State Select State Code Classification Fringe Benefit Hourly Rate Credits
Zip Health Vacation Apprentice Fringe
Welfare Holiday Fund Pension Other 1 Other 2 Benefits
Has Changed? false Total
Salaried (y/n) : No

4(c) EXCEPTION (CRAFT) Put the Craft in the first cell below and the reason in the second cell below Other Payroll Deductions

Other Deduction Description Amount

O.T. Total Project RATE OF

Individual Employee Name and Identifier S.T. Over Time Hours Hours Worked Classification
S.H. Straight Time Hours Hours PAY
Salaried Time Hours
Last Name
First Name O.T. 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Project #
Middle Initial S.T. 0.00 0.00 0.00 0.00 0.00 0.00 0.00
SSN (full 9-digit #) S.H. 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Employee Comments
Partial SSN Craft Code Select Craft Code
OJT % Apprentice ID Apprentice
Wage % Lump Sum Project Gross
Vendor Emp ID Labor Code Select Labor Code
Gender Select Gender Code Code
Ethnicity Code Select Ethnicity Salaried Employee Only Pay Period Check Stub Area
Addr Line 1 Federal State Income Other Total NET
Total Pay Period Normal Salary Gross Pay FICA Medicare
Addr Line 2 Salaried Hours Income Tax Tax Deductions Deductions WAGES
City
State Select State Code Classification Fringe Benefit Hourly Rate Credits
Zip Health Vacation Apprentice Fringe
Welfare Holiday Fund Pension Other 1 Other 2 Benefits
Has Changed? false Total
Salaried (y/n) : No

4(c) EXCEPTION (CRAFT) Put the Craft in the first cell below and the reason in the second cell below Other Payroll Deductions

Other Deduction Description Amount

O.T. Total Project RATE OF

Individual Employee Name and Identifier S.T. Over Time Hours Hours Worked Classification
S.H. Straight Time Hours Hours PAY
Salaried Time Hours
Last Name
First Name O.T. 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Project #
Middle Initial S.T. 0.00 0.00 0.00 0.00 0.00 0.00 0.00
SSN (full 9-digit #) S.H. 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Employee Comments
Partial SSN Craft Code Select Craft Code
OJT % Apprentice ID Apprentice
Wage % Lump Sum Project Gross
Vendor Emp ID Labor Code Select Labor Code
Gender Select Gender Code Code
Ethnicity Code Select Ethnicity Salaried Employee Only Pay Period Check Stub Area
Addr Line 1 Federal State Income Other Total NET
Total Pay Period Normal Salary Gross Pay FICA Medicare
Addr Line 2 Salaried Hours Income Tax Tax Deductions Deductions WAGES
City
State Select State Code Classification Fringe Benefit Hourly Rate Credits
Zip Health Vacation Apprentice Fringe
Welfare Holiday Fund Pension Other 1 Other 2 Benefits
Has Changed? false Total
Salaried (y/n) : No

4(c) EXCEPTION (CRAFT) Put the Craft in the first cell below and the reason in the second cell below Other Payroll Deductions

Other Deduction Description Amount

O.T. Total Project RATE OF

Individual Employee Name and Identifier S.T. Over Time Hours Hours Worked Classification
S.H. Straight Time Hours Hours PAY
Salaried Time Hours
Last Name
First Name O.T. 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Project #
Middle Initial S.T. 0.00 0.00 0.00 0.00 0.00 0.00 0.00
SSN (full 9-digit #) S.H. 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Employee Comments
Partial SSN Craft Code Select Craft Code
OJT % Apprentice ID Apprentice
Wage % Lump Sum Project Gross
Vendor Emp ID Labor Code Select Labor Code
Gender Select Gender Code Code
Ethnicity Code Select Ethnicity Salaried Employee Only Pay Period Check Stub Area
Addr Line 1 Federal State Income Other Total NET
Total Pay Period Normal Salary Gross Pay FICA Medicare
Addr Line 2 Salaried Hours Income Tax Tax Deductions Deductions WAGES
City
State Select State Code Classification Fringe Benefit Hourly Rate Credits
Zip Health Vacation Apprentice Fringe
Welfare Holiday Fund Pension Other 1 Other 2 Benefits
Has Changed? false Total
Salaried (y/n) : No

4(c) EXCEPTION (CRAFT) Put the Craft in the first cell below and the reason in the second cell below Other Payroll Deductions

Other Deduction Description Amount

O.T. Total Project RATE OF

Individual Employee Name and Identifier S.T. Over Time Hours Hours Worked Classification
S.H. Straight Time Hours Hours PAY
Salaried Time Hours
Last Name
First Name O.T. 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Project #
Middle Initial S.T. 0.00 0.00 0.00 0.00 0.00 0.00 0.00
SSN (full 9-digit #) S.H. 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Employee Comments
Partial SSN Craft Code Select Craft Code
OJT % Apprentice ID Apprentice
Wage % Lump Sum Project Gross
Vendor Emp ID Labor Code Select Labor Code
Gender Select Gender Code Code
Ethnicity Code Select Ethnicity Salaried Employee Only Pay Period Check Stub Area
Addr Line 1 Federal State Income Other Total NET
Total Pay Period Normal Salary Gross Pay FICA Medicare
Addr Line 2 Salaried Hours Income Tax Tax Deductions Deductions WAGES
City
State Select State Code Classification Fringe Benefit Hourly Rate Credits
Zip Health Vacation Apprentice Fringe
Welfare Holiday Fund Pension Other 1 Other 2 Benefits
Has Changed? false Total
Salaried (y/n) : No

4(c) EXCEPTION (CRAFT) Put the Craft in the first cell below and the reason in the second cell below Other Payroll Deductions

Other Deduction Description Amount

O.T. Total Project RATE OF

Individual Employee Name and Identifier S.T. Over Time Hours Hours Worked Classification
S.H. Straight Time Hours Hours PAY
Salaried Time Hours
Last Name
First Name O.T. 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Project #
Middle Initial S.T. 0.00 0.00 0.00 0.00 0.00 0.00 0.00
SSN (full 9-digit #) S.H. 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Employee Comments
Partial SSN Craft Code Select Craft Code
OJT % Apprentice ID Apprentice
Wage % Lump Sum Project Gross
Vendor Emp ID Labor Code Select Labor Code
Gender Select Gender Code Code
Ethnicity Code Select Ethnicity Salaried Employee Only Pay Period Check Stub Area
Addr Line 1 Federal State Income Other Total NET
Total Pay Period Normal Salary Gross Pay FICA Medicare
Addr Line 2 Salaried Hours Income Tax Tax Deductions Deductions WAGES
City
State Select State Code Classification Fringe Benefit Hourly Rate Credits
Zip Health Vacation Apprentice Fringe
Welfare Holiday Fund Pension Other 1 Other 2 Benefits
Has Changed? false Total
Salaried (y/n) : No

4(c) EXCEPTION (CRAFT) Put the Craft in the first cell below and the reason in the second cell below Other Payroll Deductions

Other Deduction Description Amount

O.T. Total Project RATE OF

Individual Employee Name and Identifier S.T. Over Time Hours Hours Worked Classification
S.H. Straight Time Hours Hours PAY
Salaried Time Hours
Last Name
First Name O.T. 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Project #
Middle Initial S.T. 0.00 0.00 0.00 0.00 0.00 0.00 0.00
SSN (full 9-digit #) S.H. 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Employee Comments
Partial SSN Craft Code Select Craft Code
OJT % Apprentice ID Apprentice
Wage % Lump Sum Project Gross
Vendor Emp ID Labor Code Select Labor Code
Gender Select Gender Code Code
Ethnicity Code Select Ethnicity Salaried Employee Only Pay Period Check Stub Area
Addr Line 1 Federal State Income Other Total NET
Total Pay Period Normal Salary Gross Pay FICA Medicare
Addr Line 2 Salaried Hours Income Tax Tax Deductions Deductions WAGES
City
State Select State Code Classification Fringe Benefit Hourly Rate Credits
Zip Health Vacation Apprentice Fringe
Welfare Holiday Fund Pension Other 1 Other 2 Benefits
Has Changed? false Total
Salaried (y/n) : No

4(c) EXCEPTION (CRAFT) Put the Craft in the first cell below and the reason in the second cell below Other Payroll Deductions

Other Deduction Description Amount

O.T. Total Project RATE OF

Individual Employee Name and Identifier S.T. Over Time Hours Hours Worked Classification
S.H. Straight Time Hours Hours PAY
Salaried Time Hours
Last Name
First Name O.T. 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Project #
Middle Initial S.T. 0.00 0.00 0.00 0.00 0.00 0.00 0.00
SSN (full 9-digit #) S.H. 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Employee Comments
Partial SSN Craft Code Select Craft Code
OJT % Apprentice ID Apprentice
Wage % Lump Sum Project Gross
Vendor Emp ID Labor Code Select Labor Code
Gender Select Gender Code Code
Ethnicity Code Select Ethnicity Salaried Employee Only Pay Period Check Stub Area
Addr Line 1 Federal State Income Other Total NET
Total Pay Period Normal Salary Gross Pay FICA Medicare
Addr Line 2 Salaried Hours Income Tax Tax Deductions Deductions WAGES
City
State Select State Code Classification Fringe Benefit Hourly Rate Credits
Zip Health Vacation Apprentice Fringe
Welfare Holiday Fund Pension Other 1 Other 2 Benefits
Has Changed? false Total
Salaried (y/n) : No

4(c) EXCEPTION (CRAFT) Put the Craft in the first cell below and the reason in the second cell below Other Payroll Deductions

Other Deduction Description Amount

O.T. Total Project RATE OF

Individual Employee Name and Identifier S.T. Over Time Hours Hours Worked Classification
S.H. Straight Time Hours Hours PAY
Salaried Time Hours
Last Name
First Name O.T. 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Project #
Middle Initial S.T. 0.00 0.00 0.00 0.00 0.00 0.00 0.00
SSN (full 9-digit #) S.H. 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Employee Comments
Partial SSN Craft Code Select Craft Code
OJT % Apprentice ID Apprentice
Wage % Lump Sum Project Gross
Vendor Emp ID Labor Code Select Labor Code
Gender Select Gender Code Code
Ethnicity Code Select Ethnicity Salaried Employee Only Pay Period Check Stub Area
Addr Line 1 Federal State Income Other Total NET
Total Pay Period Normal Salary Gross Pay FICA Medicare
Addr Line 2 Salaried Hours Income Tax Tax Deductions Deductions WAGES
City
State Select State Code Classification Fringe Benefit Hourly Rate Credits
Zip Health Vacation Apprentice Fringe
Welfare Holiday Fund Pension Other 1 Other 2 Benefits
Has Changed? false Total
Salaried (y/n) : No

4(c) EXCEPTION (CRAFT) Put the Craft in the first cell below and the reason in the second cell below Other Payroll Deductions

Other Deduction Description Amount

O.T. Total Project RATE OF

Individual Employee Name and Identifier S.T. Over Time Hours Hours Worked Classification
S.H. Straight Time Hours Hours PAY
Salaried Time Hours
Last Name
First Name O.T. 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Project #
Middle Initial S.T. 0.00 0.00 0.00 0.00 0.00 0.00 0.00
SSN (full 9-digit #) S.H. 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Employee Comments
Partial SSN Craft Code Select Craft Code
OJT % Apprentice ID Apprentice
Wage % Lump Sum Project Gross
Vendor Emp ID Labor Code Select Labor Code
Gender Select Gender Code Code
Ethnicity Code Select Ethnicity Salaried Employee Only Pay Period Check Stub Area
Addr Line 1 Federal State Income Other Total NET
Total Pay Period Normal Salary Gross Pay FICA Medicare
Addr Line 2 Salaried Hours Income Tax Tax Deductions Deductions WAGES
City
State Select State Code Classification Fringe Benefit Hourly Rate Credits
Zip Health Vacation Apprentice Fringe
Welfare Holiday Fund Pension Other 1 Other 2 Benefits
Has Changed? false Total
Salaried (y/n) : No

4(c) EXCEPTION (CRAFT) Put the Craft in the first cell below and the reason in the second cell below Other Payroll Deductions

Other Deduction Description Amount

O.T. Total Project RATE OF

Individual Employee Name and Identifier S.T. Over Time Hours Hours Worked Classification
S.H. Straight Time Hours Hours PAY
Salaried Time Hours
Last Name
First Name O.T. 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Project #
Middle Initial S.T. 0.00 0.00 0.00 0.00 0.00 0.00 0.00
SSN (full 9-digit #) S.H. 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Employee Comments
Partial SSN Craft Code Select Craft Code
OJT % Apprentice ID Apprentice
Wage % Lump Sum Project Gross
Vendor Emp ID Labor Code Select Labor Code
Gender Select Gender Code Code
Ethnicity Code Select Ethnicity Salaried Employee Only Pay Period Check Stub Area
Addr Line 1 Federal State Income Other Total NET
Total Pay Period Normal Salary Gross Pay FICA Medicare
Addr Line 2 Salaried Hours Income Tax Tax Deductions Deductions WAGES
City
State Select State Code Classification Fringe Benefit Hourly Rate Credits
Zip Health Vacation Apprentice Fringe
Welfare Holiday Fund Pension Other 1 Other 2 Benefits
Has Changed? false Total
Salaried (y/n) : No

4(c) EXCEPTION (CRAFT) Put the Craft in the first cell below and the reason in the second cell below Other Payroll Deductions

Other Deduction Description Amount

O.T. Total Project RATE OF

Individual Employee Name and Identifier S.T. Over Time Hours Hours Worked Classification
S.H. Straight Time Hours Hours PAY
Salaried Time Hours
Last Name
First Name O.T. 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Project #
 Project #
Middle Initial S.T. 0.00 0.00 0.00 0.00 0.00 0.00 0.00
SSN (full 9-digit #) S.H. 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Employee Comments
Partial SSN Craft Code Select Craft Code
OJT % Apprentice ID Apprentice
Wage % Lump Sum Project Gross
Vendor Emp ID Labor Code Select Labor Code
Gender Select Gender Code Code
Ethnicity Code Select Ethnicity Salaried Employee Only Pay Period Check Stub Area
Addr Line 1 Federal State Income Other Total NET
Total Pay Period Normal Salary Gross Pay FICA Medicare
Addr Line 2 Salaried Hours Income Tax Tax Deductions Deductions WAGES
City
State Select State Code Classification Fringe Benefit Hourly Rate Credits
Zip Health Vacation Apprentice Fringe
Welfare Holiday Fund Pension Other 1 Other 2 Benefits
Has Changed? false Total
Salaried (y/n) : No

4(c) EXCEPTION (CRAFT) Put the Craft in the first cell below and the reason in the second cell below Other Payroll Deductions

Other Deduction Description Amount

O.T. Total Project RATE OF

Individual Employee Name and Identifier S.T. Over Time Hours Hours Worked Classification
S.H. Straight Time Hours Hours PAY
Salaried Time Hours
Last Name
First Name O.T. 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Project #
Middle Initial S.T. 0.00 0.00 0.00 0.00 0.00 0.00 0.00
SSN (full 9-digit #) S.H. 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Employee Comments
Partial SSN Craft Code Select Craft Code
OJT % Apprentice ID Apprentice
Wage % Lump Sum Project Gross
Vendor Emp ID Labor Code Select Labor Code
Gender Select Gender Code Code
Ethnicity Code Select Ethnicity Salaried Employee Only Pay Period Check Stub Area
Addr Line 1 Federal State Income Other Total NET
Total Pay Period Normal Salary Gross Pay FICA Medicare
Addr Line 2 Salaried Hours Income Tax Tax Deductions Deductions WAGES
City
State Select State Code Classification Fringe Benefit Hourly Rate Credits
Zip Health Vacation Apprentice Fringe
Welfare Holiday Fund Pension Other 1 Other 2 Benefits
Has Changed? false Total
Salaried (y/n) : No

4(c) EXCEPTION (CRAFT) Put the Craft in the first cell below and the reason in the second cell below Other Payroll Deductions

Other Deduction Description Amount

O.T. Total Project RATE OF

Individual Employee Name and Identifier S.T. Over Time Hours Hours Worked Classification
S.H. Straight Time Hours Hours PAY
Salaried Time Hours
Last Name
First Name O.T. 0.00 0.00 0.00 0.00 0.00 0.00 0.00 30
Project #
Middle Initial S.T. 0.00 0.00 0.00 0.00 0.00 0.00 0.00
SSN (full 9-digit #) S.H. 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Employee Comments
Partial SSN Craft Code Select Craft Code
OJT % Apprentice ID Apprentice
Wage % Lump Sum Project Gross
Vendor Emp ID Labor Code Select Labor Code
Gender Select Gender Code Code 0.00
Ethnicity Code Select Ethnicity Salaried Employee Only Pay Period Check Stub Area
Addr Line 1
Normal Salary Gross Pay FICA Federal State Income Medicare Other Total NET
Total Pay Period Income Tax Tax Deductions Deductions WAGES
Addr Line 2 Salaried Hours
City
State Select State Code Classification Fringe Benefit Hourly Rate Credits
Zip Health Vacation Apprentice Fringe
Welfare Holiday Fund Pension Other 1 Other 2 Benefits
Has Changed? false Total
Salaried (y/n) : No

4(c) EXCEPTION (CRAFT) Put the Craft in the first cell below and the reason in the second cell below Other Payroll Deductions

Other Deduction Description Amount

Child Support
Union Dues

O.T. Total Project RATE OF

Individual Employee Name and Identifier S.T. Over Time Hours Hours Worked Classification
S.H. Straight Time Hours Hours PAY
Salaried Time Hours
Last Name
First Name O.T. 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Project #
Middle Initial S.T. 0.00 0.00 0.00 0.00 0.00 0.00 0.00
SSN (full 9-digit #) S.H. 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Employee Comments
Partial SSN Craft Code Select Craft Code
OJT % Apprentice ID Apprentice
Wage % Lump Sum Project Gross
Vendor Emp ID Labor Code Select Labor Code
Gender Select Gender Code Code
Ethnicity Code Select Ethnicity Salaried Employee Only Pay Period Check Stub Area
Addr Line 1 Federal State Income Other Total NET
Total Pay Period Normal Salary Gross Pay FICA Medicare
Addr Line 2 Salaried Hours Income Tax Tax Deductions Deductions WAGES
City
State Select State Code Classification Fringe Benefit Hourly Rate Credits
Zip Health Vacation Apprentice Fringe
Welfare Holiday Fund Pension Other 1 Other 2 Benefits
Has Changed? false Total
Salaried (y/n) : No

4(c) EXCEPTION (CRAFT) Put the Craft in the first cell below and the reason in the second cell below Other Payroll Deductions

Other Deduction Description Amount

Ethnicity Values
Select Ethnicity
ASIAN (Asian Indian, Subcont Asian America, Asian-Pacific American)
NATIVE HAWAIIAN or OTHER PACIFIC ISLANDER
BLACK or AFRICAN AMERICAN
CAUCASIAN or WHITE
HISPANIC or LATINO AMERICAN
AMERICAN INDIAN or ALASKA NATIVE
TWO or MORE RACES
Code
Code
A-IN The spreadsheet is set up to accommodate 500 rows each for Ethnicity, Craft, Labor and S
A-PF
BLK
If you need additional rows, you can add them, but you must also edit the Data Validation
CAUC corresponding drop down cell on the Payroll Form tab and expand the List range to accom
HISP rows. For instructions about how to edit the Data Validation, refer to Microsoft Excel Help
N-AM
T-MR For each code, enter a description that helps identify the purpose of the corresponding co

The descriptions will be displayed in the drop-down menu for the Select Ethnicity, Select C
Labor Select State code fields on the Payroll Form tab

Approximately the first 45 characters of the description will be visible.

Enter a corresponding code value in the 'Code' column.

This is the value that will be used for the Payroll XML submission.

The Code values MUST be valid code table values for the Agency to which the payroll is be
thnicity, Craft, Labor and State codes.

so edit the Data Validation for the

nd the List range to accommodate the added
fer to Microsoft Excel Help.

se of the corresponding code value.

he Select Ethnicity, Select Craft Code, Select

visible.

n.

y to which the payroll is being submitted.

Craft Values
Select Craft Code
100 - Laborers
200 - Special Equipment
300 - Highway & Heavy Equipment Operators
500 - Commercial Equipment Operators
600 - Truck Drivers
700 - Special Crafts
Code
Code
100 The spreadsheet is set up to accommodate 500 rows each for Ethnicity, Craft, Labor and S
200
300
If you need additional rows, you can add them, but you must also edit the Data Validation
500 corresponding drop down cell on the Payroll Form tab and expand the List range to accom
600 rows. For instructions about how to edit the Data Validation, refer to Microsoft Excel Help
700
For each code, enter a description that helps identify the purpose of the corresponding co

The descriptions will be displayed in the drop-down menu for the Select Ethnicity, Select C
Labor Select State code fields on the Payroll Form tab

Approximately the first 45 characters of the description will be visible.

Enter a corresponding code value in the 'Code' column.

This is the value that will be used for the Payroll XML submission.

The Code values MUST be valid code table values for the Agency to which the payroll is be
thnicity, Craft, Labor and State codes.

so edit the Data Validation for the

nd the List range to accommodate the added
fer to Microsoft Excel Help.

se of the corresponding code value.

he Select Ethnicity, Select Craft Code, Select

visible.

n.

y to which the payroll is being submitted.

Labor Values
Select Labor Code
101 ─ LABORER COMMON (GENERAL LABOR WORK)
102 ─ LABORER, SKILLED (ASSISTING SKILLED CRAFT JOURNEYMAN)
103 ─ LABORER, LANDSCAPING (GARDENER, SOD LAYER, AND NURSERY OPERATOR)
104 ─ FLAG PERSON
105 ─ WATCH PERSON
106 ─ BLASTER
107 ─ PIPELAYER (WATER, SEWER AND GAS)
108 ─ TUNNEL MINER
109 ─ UNDERGROUND AND OPEN DITCH LABORER (EIGHT FEET BELOW STARTING GRADE LEVEL)
110 ─ SURVEY FIELD TECHNICIAN (SEE MASTER CLASSIFICATION LIST UNDER MINN. RULE 5200.1100 FOR FULL DISCRIPTION)
111 ─ TRAFFIC CONTROL PERSON (TEMPORARY SIGNAGE)
112 ─ QUALITY CONTROL TESTER (FIELD AND COVERED OFF-SITE FACILITIES; TESTING OF AGGREGATE, ASPHALT, AND CONCRE
201 ─ ARTICULATED HAULER
202 ─ BOOM TRUCK
203 ─ LANDSCAPING EQUIPMENT, INCLUDES HYDRO SEEDER OR MULCHER, SOD ROLLER, FARM TRACTOR WITH ATTACHMENT
204 ─ OFF-ROAD TRUCK
205 ─ PAVEMENT MARKING OR MARKING REMOVAL EQUIPMENT
302 ─ HELICOPTER PILOT
303 ─ CONCRETE PUMP
304 ─ ALL CRANES WITH OVER 135-FOOT BOOM, EXCLUDING JIB
305 ─ DRAGLINE, CRAWLER, HYDRAULIC BACKHOE (TRACK OR WHEEL MOUNTED) AND/OR OTHER SIMILAR EQUIPMENT WITH
306 ─ GRADER OR MOTOR PATROL
307 ─ PILE DRIVING
308 ─ TUGBOAT - 100 H.P. AND OVER WHEN LICENSE REQUIRED
309 ─ ASPHALT BITUMINOUS STABILIZER PLANT
310 ─ CABLEWAY
311 ─ CONCRETE MIXER, STATIONARY PLANT
312 ─ DERRICK (GUY OR STIFFLEG) (POWER) (SKIDS OR STATIONARY)
313 ─ DRAGLINE, CRAWLER, HYDRAULIC BACKHOE (TRACK OR WHEEL MOUNTED) AND/OR SIMILAR EQUIPMENT WITH SHOVE
314 ─ DREDGE OR ENGINEERS, DREDGE (POWER) AND ENGINEER
315 ─ FRONT END LOADER, FIVE CUBIC YARDS AND OVER INCLUDING ATTACHMENTS
316 ─ LOCOMOTIVE CRANE OPERATOR
317 ─ MIXER (PAVING) CONCRETE PAVING, ROAD MOLE, INCLUDING MUCKING OPERATIONS, CONWAY OR SIMILAR TYPE
318 ─ MECHANIC - WELDER ON POWER EQUIPMENT
319 ─ TRACTOR - BOOM TYPE
320 ─ TANDEM SCRAPER
321 ─ TRUCK CRANE - CRAWLER CRANE
322 ─ TUGBOAT 100 H.P. AND OVER
323 ─ AIR TRACK ROCK DRILL
324 ─ AUTOMATIC ROAD MACHINE (CMI OR SIMILAR)
325 ─ BACKFILLER OPERATOR
326 ─ CONCRETE BATCH PLANT OPERATOR
327 ─ BITUMINOUS ROLLERS, RUBBER TIRED OR STEEL DRUMMED (EIGHT TONS AND OVER)
328 ─ BITUMINOUS SPREADER AND FINISHING MACHINES (POWER), INCLUDING PAVERS, MACRO SURFACING AND MICRO SU
329 ─ BROKK OR R.T.C. REMOTE CONTROL OR SIMILAR TYPE WITH ALL ATTACHMENTS
330 ─ CAT CHALLENGER TRACTORS OR SIMILAR TYPES PULLING ROCK WAGONS, BULLDOZERS, AND SCRAPERS
331 ─ CHIP HARVESTER AND TREE CUTTER
332 ─ CONCRETE DISTRIBUTOR AND SPREADER FINISHING MACHINE, LONGITUDINAL FLOAT, JOINT MACHINE, AND SPRAY MA
333 ─ CONCRETE MIXER ON JOBSITE
334 ─ CONCRETE MOBIL
335 ─ CRUSHING PLANT (GRAVEL AND STONE) OR GRAVEL WASHING, CRUSHING AND SCREENING PLANT
336 ─ CURB MACHINE
337 ─ DIRECTIONAL BORING MACHINE
338 ─ DOPE MACHINE (PIPELINE)
339 ─ DRILL RIGS, HEAVY ROTARY OR CHURN OR CABLE DRILL
340 ─ DUAL TRACTOR
341 ─ ELEVATING GRADER
342 ─ FORK LIFT OR STRADDLE CARRIER
343 ─ FORK LIFT OR LUMBER STACKER
344 ─ FRONT END, POSI-TRACK, OR SKID STEER LOADERS, OVER ONE CUBIC YARD UP TO FIVE CUBIC YARDS WITH ATTACHMEN
345 ─ GPS REMOTE OPERATING OF EQUIPMENT
346 ─ HOIST ENGINEER (POWER)
347 ─ HYDRAULIC TREE PLANTER
348 ─ LAUNCHER PERSON (TANKER PERSON OR PILOT LICENSE)
349 ─ LOCOMOTIVE
350 ─ MILLING, GRINDING, PLANING, FINE GRADE, OR TRIMMER MACHINE
351 ─ MULTIPLE MACHINES, SUCH AS AIR COMPRESSORS, WELDING MACHINES, GENERATORS, PUMPS
352 ─ PAVEMENT BREAKER OR TAMPING MACHINE (POWER DRIVEN) MIGHT MITE SIMILAR TYPE
353 ─ PICKUP SWEEPER, ONE CUBIC YARD AND OVER HOPPER CAPACITY
354 ─ PIPELINE WRAPPING, CLEANING OR BENDING MACHINE
355 ─ POWER PLANT ENGINEER, 100 KWH AND OVER
356 ─ POWER ACTUATED HORIZONTAL BORING MACHINE, OVER SIX INCHES
357 ─ PUGMILL
358 ─ PUMPCRETE
359 ─ RUBBER-TIRED FARM TRACTOR WITH BACKHOE INCLUDING ATTACHMENTS
360 ─ SCRAPER
361 ─ SELF-PROPELLED SOIL STABILIZER
362 ─ SLIP FORM (POWER DRIVEN) (PAVING)`
363 ─ TIE TAMPER AND BALLAST MACHINE
364 ─ TRACTOR, BULLDOZER
365 ─ TRACTOR, WHEEL TYPE, OVER 50 H.P. WITH PTO UNRELATED TO LANDSCAPING
366 ─ TRENCHING MACHINE (SEWER, WATER, GAS) EXCLUDES WALK BEHIND TRENCHER
367 ─ TUB GRINDER, MORBARK, OR SIMILAR TYPE
368 ─ WELL POINT DISMANTLING OR INSTALLATION
369 ─ AIR COMPRESSOR, 600 CFM OR OVER
370 ─ BITUMINOUS ROLLER (UNDER EIGHT TONS)
371 ─ CONCRETE SAW (MULTIPLE BLADE) (POWER OPERATED)
372 ─ FORM TRENCH DIGGER (POWER)
373 ─ FRONT END, SKID STEER, OR POSI-TRACK LOADERS, UP TO AND INCLUDING ONE CUBIC YARD WITH ATTACHMENTS
374 ─ GUNITE GUNALL
375 ─ HYDRAULIC LOG SPLITTER
376 ─ LOADER (BARBER GREENE OR SIMILAR TYPE)
377 ─ POST HOLE DRIVING MACHINE/POST HOLE AUGER
378 ─ POWER ACTUATED AUGER AND BORING MACHINE
379 ─ POWER ACTUATED JACK
380 ─ PUMP
381 ─ SELF-PROPELLED CHIP SPREADER (FLAHERTY OR SIMILAR)
382 ─ SHEEP FOOT COMPACTOR WITH BLADE - 200 H.P. AND OVER
383 ─ SHOULDERING MACHINE (POWER) APSCO OR SIMILAR TYPE INCLUDING SELF-PROPELLED SAND AND CHIP SPREADER
384 ─ STUMP CHIPPER AND TREE CHIPPER
385 ─ TREE FARMER (MACHINE)
387 ─ CAT, CHALLENGER, OR SIMILAR TYPE OF TRACTORS, WHEN PULLING DISK OR ROLLER
388 ─ CONVEYOR
389 ─ DREDGE DECK HAND
390 ─ FIRE PERSON OR TANK CAR HEATER
391 ─ GRAVEL SCREENING PLANT (PORTABLE NOT CRUSHING OR WASHING)
392 ─ GREASER (TRACTOR)
393 ─ LEVER PERSON
394 ─ OILER (POWER SHOVEL, CRANE, TRUCK CRANE, DRAGLINE, CRUSHERS, AND MILLING MACHINES, OR OTHER SIMILAR HE
395 ─ POWER SWEEPER
396 ─ SHEEP FOOT ROLLER AND ROLLERS ON GRAVEL COMPACTION, INCLUDING VIBRATING ROLLERS
397 ─ TRACTOR, WHEEL TYPE, OVER 50 H.P., UNRELATED TO LANDSCAPING
501 ─ HELICOPTER PILOT
502 ─ TOWER CRANE 250 FEET AND OVER
503 ─ TRUCK OR CRAWLER CRANE WITH 200 FEET OF BOOM AND OVER, INCLUDING JIB
504 ─ CONCRETE PUMP WITH 50 METERS/164 FEET OF BOOM AND OVER
505 ─ PILE DRIVING WHEN THREE DRUMS IN USE
506 ─ TOWER CRANE 200 FEET AND OVER
507 ─ TRUCK OR CRAWLER CRANE WITH 150 FEET OF BOOM UP TO AND NOT INCLUDING 200 FEET, INCLUDING JIB
508 ─ ALL-TERRAIN VEHICLE CRANES
509 ─ CONCRETE PUMP 32-49 METERS/102-164 FEET
510 ─ DERRICK (GUY & STIFFLEG)
511 ─ STATIONARY TOWER CRANE UP TO 200 FEET
512 ─ SELF-ERECTING TOWER CRANE 100 FEET AND OVER MEASURED FROM BOOM FOOT PIN
513 ─ TRAVELING TOWER CRANE
514 ─ TRUCK OR CRAWLER CRANE UP TO AND NOT INCLUDING 150 FEET OF BOOM, INCLUDING JIB
515 ─ CRAWLER BACKHOE INCLUDING ATTACHMENTS
516 ─ FIREPERSON, CHIEF BOILER LICENSE
517 ─ HOIST ENGINEER (THREE DRUMS OR MORE)
518 ─ LOCOMOTIVE
519 ─ OVERHEAD CRANE (INSIDE BUILDING PERIMETER)
520 ─ TRACTOR - BOOM TYPE
521 ─ AIR COMPRESSOR 450 CFM OR OVER (TWO OR MORE MACHINES)
522 ─ CONCRETE MIXER
523 ─ CONCRETE PUMP UP TO 31 METERS/101 FEET OF BOOM
524 ─ DRILL RIGS, HEAVY ROTARY OR CHURN OR CABLE DRILL WHEN USED FOR CAISSON FOR ELEVATOR OR BUILDING CONST
525 ─ FORKLIFT
526 ─ FRONT END, POSI-TRACK, AND SKID STEER TYPE LOADERS ONE CUBIC YARD AND OVER, INCLUDING ATTACHMENTS
527 ─ HOIST ENGINEER (ONE OR TWO DRUMS)
528 ─ MECHANIC-WELDER (ON POWER EQUIPMENT)
529 ─ POWER PLANT (100 KW AND OVER OR MULTIPLES EQUAL TO 100 KW AND OVER)
530 ─ PUMP OPERATOR AND/OR CONVEYOR (TWO OR MORE MACHINES)
531 ─ SELF-ERECTING TOWER CRANE UNDER 100 FEET MEASURED FROM BOOM FOOT PIN
532 ─ STRADDLE CARRIER
533 ─ TRACTOR OVER D2
534 ─ WELL POINT PUMP
535 ─ CONCRETE BATCH PLANT
536 ─ FIREPERSON, FIRST CLASS BOILER LICENSE
537 ─ FRONT END, POSI-TRACK, AND SKID STEER TYPE LOADERS UP TO ONE CUBIC YARD, INCLUDING ATTACHMENTS
538 ─ GUNITE MACHINE
539 ─ TRACTOR OPERATOR D2 OR SIMILAR SIZE
540 ─ TRENCHING MACHINE (SEWER, WATER, GAS) EXCLUDES WALK BEHIND TRENCHER
541 ─ AIR COMPRESSOR 600 CFM OR OVER
542 ─ BRAKEPERSON
543 ─ CONCRETE PUMP/PUMPCRETE OR COMPLACO TYPE
544 ─ FIREPERSON, TEMPORARY HEAT SECOND CLASS BOILER LICENSE
545 ─ OILER (POWER SHOVEL, CRANE, TRUCK CRANE, DRAGLINE, CRUSHERS AND MILLING MACHINES, OR OTHER SIMILAR PO
546 ─ PICK-UP SWEEPER (ONE CUBIC YARD HOPPER CAPACITY)
547 ─ PUMP AND/OR CONVEYOR
548 ─ ELEVATOR OPERATOR
549 ─ GREASER
550 ─ MECHANICAL SPACE HEATER (TEMPORARY HEAT NO BOILER LICENSE REQUIRED)
601 ─ MECHANIC - WELDER
602 ─ TRACTOR TRAILER DRIVER
603 ─ TRUCK DRIVER (HAULING MACHINERY INCLUDING OPERATION OF HAND AND POWER OPERATED WINCHES)
604 ─ FOUR OR MORE AXLE UNIT, STRAIGHT BODY TRUCK
605 ─ BITUMINOUS DISTRIBUTOR DRIVER
606 ─ BITUMINOUS DISTRIBUTOR (ONE PERSON OPERATION)
607 ─ THREE AXLE UNITS
608 ─ BITUMINOUS DISTRIBUTOR SPRAY OPERATOR (REAR AND OILER)
609 ─ DUMP PERSON
610 ─ GREASER
611 ─ PILOT CAR DRIVER
612 ─ RUBBER-TIRED, SELF-PROPELLED PACKER, UNDER EIGHT TONS
613 ─ TWO AXLE UNIT
614 ─ SLURRY OPERATOR
615 ─ TANK TRUCK HELPER (GAS, OIL, ROAD OIL, AND WATER)
616 ─ TRACTOR OPERATOR, UNDER 50 H.P.
701 ─ HEATING AND FROST INSULATORS
702 ─ BOILERMAKERS
703 ─ BRICKLAYERS
704 ─ CARPENTERS
705 ─ CARPET LAYERS (LINOLEUM)
706 ─ CEMENT MASONS
707 ─ ELECTRICIANS
707A - ELECTRICIANS WORKING ON A ELECTRICAL CONTRACT OVER A SET AMOUNT LISTED ON THE CONTRACT WAGE DECISIO
707B - ELECTRICIANS WORKING ON A ELECTRICAL CONTRACT UNDER A SET AMOUNT LISTED ON THE CONTRACT WAGE DECIS
708 ─ ELEVATOR CONSTRUCTORS
709 ─ GLAZIERS
710 ─ LATHERS
711 ─ GROUND PERSON
712 ─ IRONWORKERS
713 ─ LINEMAN
714 ─ MILLWRIGHT
715 ─ PAINTERS (INCLUDING HAND BRUSHED, HAND SPRAYED, AND THE TAPING OF PAVEMENT MARKINGS)
716 ─ PILEDRIVER (INCLUDING VIBRATORY DRIVER OR EXTRACTOR FOR PILING AND SHEETING OPERATIONS)
717 ─ PIPEFITTERS - STEAMFITTERS
718 ─ PLASTERERS
719 ─ PLUMBERS
720 ─ ROOFER
721 ─ SHEET METAL WORKERS
722 ─ SPRINKLER FITTERS
723 ─ TERRAZZO WORKERS
724 ─ TILE SETTERS
725 ─ TILE FINISHERS (SEE MASTER CLASSIFICATION LIST UNDER MINN. RULE 5200.1100 FOR FULL DISCRIPTION)
726 ─ DRYWALL TAPER
727 ─ WIRING SYSTEM TECHNICIAN
728 ─ WIRING SYSTEM INSTALLER
729 ─ ASBESTOS ABATEMENT WORKER
730 ─ SIGN ERECTOR
Code
Code
101 The spreadsheet is set up to accommodate 500 rows each for Ethnicity, Craft, Labor and S
102
103
If you need additional rows, you can add them, but you must also edit the Data Validation
104 corresponding drop down cell on the Payroll Form tab and expand the List range to accom
105 rows. For instructions about how to edit the Data Validation, refer to Microsoft Excel Help
106
107 For each code, enter a description that helps identify the purpose of the corresponding co
108
109 The descriptions will be displayed in the drop-down menu for the Select Ethnicity, Select C
110 Labor Select State code fields on the Payroll Form tab
111
112 Approximately the first 45 characters of the description will be visible.
201
202 Enter a corresponding code value in the 'Code' column.
203
204 This is the value that will be used for the Payroll XML submission.
205
302 The Code values MUST be valid code table values for the Agency to which the payroll is be
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
387
388
389
390
391
392
393
394
395
396
397
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
701
702
703
704
705
706
707
707A
707B
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
thnicity, Craft, Labor and State codes.

so edit the Data Validation for the

nd the List range to accommodate the added
fer to Microsoft Excel Help.

se of the corresponding code value.

he Select Ethnicity, Select Craft Code, Select

visible.

n.

y to which the payroll is being submitted.

State Values
Select State Code
Minnesota
Wisconsin
Alabama
Alaska
Arizona
Arkansas
California
Colorado
Connecticut
Deleware
District of Columbia
Florida
Georgia
Haewaii
Idaho
Illinois
Indiana
Iowa
Kansas
Kentucky
Louisiana
Maine
Maryland
Massachusetts
Michigan
Minnesota
Mississippi
Missouri
Montana
Nebraska
Nevada
New hampshire
New jersey
New mexico
New Yourk
North carolina
North Dakota
Ohio
Oklahoma
Oregon
Pennsylvania
Rhode Island
South Carolina
South Dakota
Tennessee
Texas
Utah
vermont
Virginia
Washington
West Virginia
Wisconsin
Wyoming
Code

MN The spreadsheet is set up to accommodate 500 rows each for Ethnicity, Craft, Labor and S
WI
AL
If you need additional rows, you can add them, but you must also edit the Data Validation
AK corresponding drop down cell on the Payroll Form tab and expand the List range to accom
AZ rows. For instructions about how to edit the Data Validation, refer to Microsoft Excel Help
AR
CA
CO For each code, enter a description that helps identify the purpose of the corresponding co
CT
DE The descriptions will be displayed in the drop-down menu for the Select Ethnicity, Select C
DC Labor Select State code fields on the Payroll Form tab
FL
GA Approximately the first 45 characters of the description will be visible.
HI
ID Enter a corresponding code value in the 'Code' column.
IL
IN This is the value that will be used for the Payroll XML submission.
IA
KS The Code values MUST be valid code table values for the Agency to which the payroll is be
KY
LA
ME
MD
MA
MI
MN
MS
MO
MT
NE
NV
NH
NJ
NM
NY
NC
ND
OH
OK
OR
PA
RI
SC
SD
TN
TX
UT
VT
VA
WA
WV
WI
WY
thnicity, Craft, Labor and State codes.

so edit the Data Validation for the

nd the List range to accommodate the added
fer to Microsoft Excel Help.

se of the corresponding code value.

he Select Ethnicity, Select Craft Code, Select

visible.

n.

y to which the payroll is being submitted.

CRL Webpage
Vendor ID Lookup
Project ID Lookup
Contract ID Lookup
Online Converter
Spreadsheet manual
CRL E-Learning Tool
Contractor vendor form
Trucking Entity vendor form
Request to sublet
MTO request to sublet
CRL User Registration Request
CRL AASHTOWare Login page
Federal Comformance request
State Classification request
State Wage Rate Request
 [Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]
[Link]

If link is broken contact, LCU 651-366-4238 or [Link]@[Link]