Spectrum Export Override Setup

The Export Override Setup page is used to define custom mapping rules that automatically transform data during the export process. This ensures it matches Spectrum’s requirements.

This page can be found in Settings & Permissions > Spectrum Export Override Setup.

This page allows you to configure multiple override types across two tabs: Timesheet Entry and Expense Entry.

Timesheet Entry

Expense Entry

Set an Hours/Rate Type Calculation Override

Follow these steps to set an hours/rate type calculation override.

This setting is commonly used for LOA or Per Diem adjustments. It allows you to redirect time entries to specific rate fields or calculate values based on job title rates.
  1. Navigate to Settings & Permissions > Spectrum Export Override Setup > Timesheet Entry.
  2. Find the Hours/Rate Type Calculation Override section and select the plus icon to add a new override.
  3. Select a Pay Type (such as, Travel or Per Diem) from the dropdown menu to apply the override to.
  4. Select a Phase from the dropdown to restrict the override to that work area.
  5. Select an Export Type from the dropdown to define how Traqspera should calculate the value for the Spectrum export.
    Options include:
    • Hours: Exports the raw hours.
    • Field Value as Rate: Uses a custom field value as the hourly rate.
    • Pay Rate x Field Value: Multiplies the employee's pay rate by a specific field value.
    • Pay Rate: exports the employee's standard hourly Pay Rate for the selected Pay Type, regardless of the hours worked.
    • Pay Rate x Field Value Include Field Value: Multiplies the employee’s Pay Rate by a specific Field Value (such as a custom numeric field on the timesheet). It then includes that same Field Value as a separate component in the export.
      Note: This Export Type is typically used in scenarios where you need to export a calculated cost but also retain the original multiplier value for auditing or further processing within Spectrum.
  6. Select Save at the top of the page.

Set a Cost Center Override by Job/Phases

Follow these steps to redirect financial data to a specific Cost Center based on the Job or Phase selected.

  1. Navigate to Settings & Permissions > Spectrum Export Override Setup > Timesheet Entry.
  2. Find the Cost Center Override by Job/Phases section and select the plus icon to add a new override.
  3. Select from the dropdown the Job/SubJob that this override applies to.
  4. Select a Cost Center from the dropdown for the export.
  5. Select Save at the top of the page.

Set a Pay Type Override

Follow these steps to configure various types of pay type overrides

These override types are ordered from most general to most specific.
  1. Navigate to Settings & Permissions > Spectrum Export Override Setup > Timesheet Entry.
  2. Find the Pay Type Overrides section and scroll to the appropriate override type.
  3. To set a pay type override by rate level:
    1. Select the plus icon to add a new override.
    2. Select a Rate Level from the dropdown.
    3. Select the corresponding Spectrum Pay Type from the dropdown.
    Traqspera automatically assigns a Spectrum pay type based on the selected Rate Level across all jobs.
  4. To set a pay type override by phase number:
    Tip: This is useful for phases that always require a specific pay code, like a Travel phase always exporting as a Travel pay type regardless of the job.
    1. Select the plus icon to add a new override.
    2. Select a Phase from the dropdown.
    3. Select which Spectrum Pay Types should be used for each of the following earning categories using the dropdowns.
      • Regular
      • Overtime
      • Doubletime
      • Travel
      • Per Diem
      • Quantity
    Traqspera automatically assigns aSpectrum pay type based on the selected Phase Number across all jobs.
  5. To set a pay type override by jobs/phases:
    Tip: This overrides the general Rate Level or Phase Number rules for a specific project's requirements.
    1. Select the plus icon to add a new override.
    2. Select a Job from the dropdowns. Optionally, you can also select a SubJob (phase) from the second dropdown. If you don't, the override applies to all phases for that job.
    3. Select which Spectrum Pay Types should be used for each of the following earning categories using the dropdowns.
      • Regular
      • Overtime
      • Doubletime
      • Travel
      • Per Diem
      • Quantity
    Traqspera automatically overrides the Spectrum pay type on the time export for the selected jobs and phases.
  6. To set a pay type, phase code, equipment code, cost type, or rate level override by employee:
    Tip: Use this for specific union requirements or unique employee-based pay structures that differ from standard company rules.
    1. Select the plus icon to add a new override.
    2. Select a Phase from the dropdown.
    3. If needed, enter a Phase Code, Equipment Code, or Cost Type to narrow the override rule.
    4. Select which Spectrum Pay Type should be used for each of the following earning categories using the dropdowns.
      • Reg (Regular)
      • OT (Overtime)
      • DT (Doubletime)
    5. Select a Spectrum Rate Level from the dropdown.
  7. To delete any existing pay type overrides, select the X icon.
  8. Select Save at the top of the page.

Set a Phase Override by Pay Type

Follow these steps to automate the selection of a specific Phase based on the Pay Type selected during time entry.

This is primarily used to ensure that non-productive time or specific pay categories (like Vacation or Sick leave) are always charged to the correct overhead or administrative phase in Spectrum without requiring manual entry by the user.
  1. Navigate to Settings & Permissions > Spectrum Export Override Setup > Expense Entry.
  2. Find the Phase Override by Pay Type section and select the plus icon to add a new override.
  3. Select a Pay Type from the dropdown.
  4. Select a Phase from the dropdown.
  5. Select Save at the top of the page.