The following explains where the information set up on the spreadsheet is also set up in Spectrum.

1. Contractor's Vendor ID: This is your Vendor ID number in the CRL website. Enter your ID into the Contractor ID field within the Other XML Info button.
2. Contract #: This is the Agency's identification for the work and is a six digit contract number found on the CRL website. Enter it in the Contract # field in Job Main Properties.
3. Fringes Paid in Cash or to Plan: This information is entered on the Certified Payroll Report's start screen. Select the appropriate checkboxes to indicate how fringes are paid.
4. Benefit Program Information: This information is entered on the Properties tab of the Certified Benefit Program Maintenance screen.
   1. Benefit Program Name
   2. Benefit Program Type: Select one of the pre-populated types
      • Apprentice Fund
      • Health/Welfare
      • Pension
      • Vacation/Holiday
      • Other 1
      • Other 2
   3. Benefit Account Number
   4. Benefit Program Classification
   5. Contact Person
   6. Contact Phone

1. Employee Information: This information comes from the employee's record (see next section). Salaried employees are converted to a rate per hour automatically here. Spectrum does not track whether or not the employee information has changed on the XML file.
2. Craft Code and Labor Code: The Craft Code comes from the Certified craft code on the union. The Labor Code comes from the Certified labor code on the wage code.
3. Apprentice ID and Apprentice Wage %: These are set up on the Employee Pay Rates page.
4. Classification Fringe Benefit Hourly Rate Credits: Fringes, add-ons and deductions that have been mapped to a Benefit Program Type will default to this section of the file automatically. Provided you have set up the Certified Benefit Program Maintenance screen, no additional Spectrum setup is required.
5. Exceptions: This information is entered on the Certified Payroll Report's start screen.
6. Other Deductions: automatically populates the other add-ons and deductions not already mapped to a benefit program here. No setup is required here.