Articles in this section

Data Share Release: October 13, 2026

This page lists every change included in the ServiceCore Data Share release dated October 15, 2026, including each field's data type and whether it allows null values.

VW_COMPANY_PREFERENCE (Updated view)

We've added a new preference field showing whether your one-time invoice PDFs display the billing period, giving you visibility into this existing setting.

Column

Data type

Allows null

Notes

HAS_BILLING_PERIOD_ON_ONE_TIME_INVOICE_PDFS_ENABLED

NUMBER(38,0)

No

 

HAS_AUTO_FILL_ONE_TIME_INVOICE_BILLING_PERIODS_ENABLED

NUMBER(38,0)

No

 

 

 

 

 

 

 

 

 

 

 

 

VW_JOB_WORKFLOW (Updated view)

Job workflow records now include the workflow they belong to, so you can tell which workflow a job's locked version is tied to even as new versions of that workflow are published.

Column

Data type

Allows null

Notes

WORKFLOW_ID

NUMBER(38,0)

No

 

 

 

 

 

 

 

VW_WORKFLOW_RENDER_JOB (New view)

You can now see a history of every workflow PDF render, including its status, the related job, and the reason for any failure.

Column

Data type

Allows null

Notes

ID

NUMBER(38,0)

No

 

RENDER_JOB_ID

VARCHAR(36)

No

 

COMPANY_ID

NUMBER(38,0)

No

 

USER_ID

NUMBER(38,0)

No

 

WORKFLOW_SUBMISSION_ID

NUMBER(38,0)

No

 

JOB_ID

NUMBER(38,0)

No

 

STATUS

VARCHAR(20)

No

 

FILE_ID

NUMBER(38,0)

Yes

 

FAILURE_REASON

VARCHAR(255)

Yes

 

CREATED_AT

TIMESTAMP_NTZ(9)

No

 

UPDATED_AT

TIMESTAMP_NTZ(9)

No

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 
 
 

VW_SCHEDULE_ROUTE (New view)

Explore your new schedule routes, including their names, colors, active weekdays, and default yard, driver, vehicle, and departure settings.

Column

Data type

Allows null

Notes

ID

NUMBER(38,0)

No

 

NAME

VARCHAR(255)

No

 

COLOR

VARCHAR(30)

Yes

 

DESCRIPTION

VARCHAR(16777216)

Yes

 

DAYS_OF_WEEK

NUMBER(38,0)

No

 

DEFAULT_YARD_ID

NUMBER(38,0)

Yes

 

DEFAULT_DRIVER_ID

NUMBER(38,0)

Yes

 

DEFAULT_VEHICLE_ID

NUMBER(38,0)

Yes

 

DEFAULT_END_DESTINATION_ID

NUMBER(38,0)

Yes

 

DEFAULT_DEPARTS_AT

TIME

Yes

 

DIVISION_ID

NUMBER(38,0)

Yes

 

COMPANY_ID

NUMBER(38,0)

No

 

CREATED_AT

TIMESTAMP_NTZ(9)

Yes

 

MODIFIED_AT

TIMESTAMP_NTZ(9)

Yes

 

MODIFIED_BY_ID

NUMBER(38,0)

Yes

 

DELETED_AT

TIMESTAMP_NTZ(9)

Yes

 

ACTIVE_KEY

NUMBER(38,0)

Yes

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 
 
 

VW_SCHEDULE_ROUTE_DAY (New view)

See how each schedule route runs on a given day, including assigned driver and vehicle, drive time and distance, and whether a driver or vehicle was left unassigned.

Column

Data type

Allows null

Notes

ID

NUMBER(38,0)

No

 

SCHEDULE_ROUTE_ID

NUMBER(38,0)

No

 

DATE

DATE

No

 

DRIVER_ID

NUMBER(38,0)

Yes

 

VEHICLE_ID

NUMBER(38,0)

Yes

 

START_DESTINATION_ID

NUMBER(38,0)

Yes

 

END_DESTINATION_ID

NUMBER(38,0)

Yes

 

DEPARTS_AT

TIME

Yes

 

ROUTE_LINE

VARCHAR

Yes

 

ROUTE_LINE_HASH

VARCHAR(32)

Yes

 

ROUTE_LINE_UPDATED_AT

TIMESTAMP_NTZ(9)

Yes

 

DRIVE_TIME

NUMBER(38,0)

Yes

 

DRIVE_DISTANCE

NUMBER(38,0)

Yes

 

COMPANY_ID

NUMBER(38,0)

No

 

CREATED_AT

TIMESTAMP_NTZ(9)

Yes

 

MODIFIED_AT

TIMESTAMP_NTZ(9)

Yes

 

MODIFIED_BY_ID

NUMBER(38,0)

Yes

 

DRIVER_UNASSIGNED

NUMBER(38,0)

No

 

VEHICLE_UNASSIGNED

NUMBER(38,0)

No

 

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

VW_JOB (Updated view)

Jobs now include a schedule route ID, letting you tie recurring jobs to their schedule routes.

Column

Data type

Allows null

Notes

SCHEDULE_ROUTE_ID

NUMBER(38,0)

Yes

 

 
 
 
 
 

VW_ROUTE (Updated view)

Routes now include a schedule route ID, so you can connect each route to its matching schedule route once linking is complete.

Column

Data type

Allows null

Notes

SCHEDULE_ROUTE_ID

NUMBER(38,0)

Yes

 

 

 

 
 
 

VW_SCHEDULE_FORMULA (Updated view)

Schedule formulas now include a schedule route ID, letting you tie recurring schedules to the schedule routes they belong to.

Column

Data type

Allows null

Notes

SCHEDULE_ROUTE_ID

NUMBER(38,0)

Yes

 

 
 
 
 
 

VW_BATCH_BILLING_OPERATION (Updated view)

Batch billing operations now show when a recurring transaction failed to produce a pending transaction, making failures easy to spot and retry.

Column

Data type

Allows null

Notes

ERRORED_AT

TIMESTAMP_NTZ(9)

Yes

 

 
 
 
 
 

VW_WORKFLOW_SIGNATURE (New view)

You can now see the signatures collected on completed job workflows, including who signed, when they signed, and the related job and signature file.

Column

Data type

Allows null

Notes

ID

NUMBER(38,0)

No

 

JOB_ID

NUMBER(38,0)

No

 

WORKFLOW_FIELD_ID

NUMBER(38,0)

No

 

FILE_ID

NUMBER(38,0)

No

 

SIGNER_NAME

VARCHAR(255)

Yes

 

SIGNED_AT

TIMESTAMP_NTZ(9)

Yes

 

COMPANY_ID

NUMBER(38,0)

No

 

CREATED_AT

TIMESTAMP_NTZ(9)

Yes

 

MODIFIED_AT

TIMESTAMP_NTZ(9)

Yes

 

MODIFIED_BY_ID

NUMBER(38,0)

Yes

 

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

VW_WORKFLOW_VERSION (Updated view)

The requires-signature flag on workflow versions is being retired now that signatures are recorded directly; it returns empty values until this release goes live, when the column is removed.

Column

Data type

Allows null

Notes

REQUIRES_SIGNATURE

BOOLEAN

Yes

Removed in this release. Returns NULL until the release date, then the column is dropped.

 
 
 
 
 
 
 

VW_INVOICE_TRANSACTION (New view)

You can now see invoice-specific details, including billing type, online payment availability, failed online payment attempts, and the billing period covered by invoices raised from recurring invoices.

Column

Data type

Allows null

Notes

ID

NUMBER(38,0)

No

 

BILLING_TYPE

VARCHAR(10)

Yes

 

IS_PAYABLE_ONLINE

NUMBER(38,0)

No

 

PAYMENT_ATTEMPTS

NUMBER(38,0)

Yes

 

BILLING_START

DATE

Yes

 

BILLING_END

DATE

Yes

 

 
 
 
 
 
 
 
 
 
 
 
 
 
 

VW_WORKFLOW_FIELD_DEFINITION_ENUM_OPTION (New view)

A new view lists the fixed answer choices for dropdown-style custom workflow fields, in the order they should be displayed.

Column

Data type

Allows null

Notes

ID

NUMBER(38,0)

No

 

FIELD_DEFINITION_ID

NUMBER(38,0)

No

 

VALUE

VARCHAR(255)

No

 

SORT_ORDER

NUMBER(38,0)

No

 

 
 
 
 
 
 
 
 
 
 

VW_WORKFLOW_FIELD_DEFINITION (Updated view)

Custom workflow field definitions now include a category, so related fields can be grouped together wherever they're displayed.

 

Column

Data type

Allows null

Notes

CATEGORY

VARCHAR(50)

No

 

SORT_ORDER

NUMBER(38,0)

No

 

OPTION_SOURCE

VARCHAR(50)

Yes

 

 
 
 
 
 
 
 
 
 
 

VW_WORKFLOW_SUBMISSION (Updated view)

Workflow submissions now record the time zone they were filled out in, so submission times can be displayed in the submitter's local time instead of always UTC.

Column

Data type

Allows null

Notes

TIME_ZONE

VARCHAR(255)

Yes

 

 

 

 

 

 

 

Was this article helpful?
0 out of 0 found this helpful

Get Support

  • Submit a Request

    Send us a ticket and we’ll reply during business hours.

  • Support Hours

    We're available Monday–Friday, 7:00am–5:00pm MT.

  • Call Us

    You can call us at 1-888-691-1333.