Timecard Entries (Timesheets)

Visual Mapping

Info-Link Tables

The following Info-Link tables are required when syncing Timecard Entries from or to Spectrum:

1. PR_PRE_TC_IMPORT_ERR_MC
2. PR_PRE_TIME_CARD_MC
3. PR_TIME_CARD_DETAIL_MC
4. PR_TIME_CARD_HISTORY_MC
5. PR_VOL_DEDUCT_MASTER_MC

For details on enabling Info-Link tables for your user, see Steps 2.7 in our Spectrum authentication guide.

Batches

The batch number in Spectrum is generated from the end of week date for the Timecard Entry exported from Procore. For example, a Timecard Entry posted on Wednesday, May 15 will have a batch number of 20240518 (for Saturday, May 18) in Viewpoint Spectrum.

Payroll Departments

To ensure Agave Sync is applying the correct Payroll Department (e.g. Direct Job Cost) when exporting a Procore Timecard Entry to Viewpoint Spectrum, we recommend using Procore's "classification" field.

See link for details on how to create classifications in Procore.

Calculating Pay Rates

Procore does not have a concept of pay rates in Timecard Entries. If you would like for us to calculate Pay Rates using Viewpoint Spectrum Employee information when exporting Timecard Entries to Viewpoint Spectrum, let your Agave Account Manager know.

How do I enable Per Diem Timecards?

Agave Sync allows for you to sync Per Diem Timecards from Procore to Spectrum.

You can enable Per Diem Timecards by adding a Time Type and custom field for a pay amount to Procore (details below). You can then notify your Agave Account Manager to enable a setting for you to map this to the "Miscellaneous" Pay Type in Spectrum.

To add a Custom Time Type in Procore:

1. From the Procore main page, select Company Tools --> Timecard.

2. Select the gear icon for settings.

3. Add a Time Type for Per Diem Timecards (e.g. "Per Diem"). Notify your Agave Account Manager of the name of this Time Type so they can enable a setting for you.

To add a custom field for a pay amount in Procore:

1. From the Procore main page, select Company Tools-->Admin.

2. Scrolldown to Timesheets on the right-hand navigation.

3. Select the Custom Fields tab. Press Create Custom Field.

4. Type "Per Diem Amount" for the Field Name and select "Number" as the Field Type.

5. Go to the Fieldset. You can use an existing fieldset that is not the Procore default, or add a new Fieldset and call it "Spectrum Integration".

6. Scroll to the bottom. Select Add Custom Field. Select Choose From Existing.

7. Press Add next to the the field you added above (i.e. "Per Diem Amount").

8. In the bottom right corner, press Save. Then press Save Changes.

9. On the fieldsets page, under "Default for New Project" press Set as Default. You may also need to assign these amounts to existing Projects under "Assigned Projects".

You should now be able to see an input for "Per Diem Amount" in your Procore Timecards.