JDBC Driver for Bullhorn CRM

Build 25.0.9539

Shift

Represents Shift records that define work schedule segments for placements or assignments. This table supports timekeeping, scheduling, and billing workflows by storing shift parameters that influence payroll and operational planning.

Columns

Name Type ReadOnly Description
Id [KEY] Int False

Represents the unique identifier (Id) for the Shift record. This value provides the primary reference that Bullhorn CRM uses to retrieve and manage shift definitions.

ClientCorporationId Int False

Specifies the Id of the client corporation that is associated with the Shift record. This value links the shift to the organization that uses or manages the scheduling structure.

Color String False

Represents the color value that is associated with the Shift record. This value supports visual identification and helps users distinguish between different Shift types in calendar displays.

DateLastModified Datetime False

Indicates the date and time when the Shift record is last modified. This value supports audit tracking and helps users identify the most recent updates to Shift details.

DayofWeek Int False

Specifies the numeric value that represents the day of the week associated with the Shift record. This value supports scheduling logic that organizes shifts according to weekly patterns.

EndTime Datetime False

Indicates the end time that is associated with the Shift record. This value defines the closing boundary of the scheduled work period for timekeeping and planning processes.

IsDefault Bool False

Returns a value of 'true' if the Shift record is designated as the default shift. It returns a value of 'false' when the shift is not designated as the default.

LastModifiedById Int False

Specifies the Id of the user who last modifies the Shift record. This value supports auditability and helps identify the user responsible for the most recent change.

LongName String False

Represents the long-form name that is associated with the Shift record. This value provides descriptive context that helps users interpret and select the appropriate shift in scheduling workflows.

MigrateGUID String False

Represents the globally unique migration Id that is associated with the Shift record. This value supports data-migration processes by ensuring continuity and traceability across systems.

ShortName String False

Specifies the short-form name that is associated with the Shift record. This value supports compact display formats and enhances usability in interfaces where space is limited.

StartTime Datetime False

Indicates the start time that is associated with the Shift record. This value establishes the opening boundary of the scheduled work period for planning and attendance tracking.

Type String False

Represents the type classification that is associated with the Shift record. This value helps categorize shifts for scheduling, reporting, and operational workflows.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 25.0.9539