JDBC Driver for Oracle Fusion Cloud SCM

Build 25.0.9539

WorkCentersproductionCalendarsresourceShifts

WorkCentersproductionCalendarsresourceShifts

Columns

Name Type Description
WorkCentersWorkCenterId [KEY] Long Identifier of the work center (parent resource).
ProductionCalendarsProductionCalendarId [KEY] Long Identifier of the production calendar (parent).
AssignedUnits Decimal Units assigned to the resource for the shift.
ResourceId [KEY] Long Identifier of the resource assigned to the shift.
ResourceName String Name of the resource assigned to the shift.
ResourceCode String Code used to identify the resource.
ShiftId [KEY] Long Identifier of the shift.
CreatedBy String User who created the shift record.
CreationDate Datetime Date/time when the shift record was created (UTC).
LastUpdateDate Datetime Date/time when the shift was last updated (UTC).
LastUpdateLogin String Login session identifier for the last update.
LastUpdatedBy String User who last updated the shift record.
ShiftName String Name of the shift.
ChangedDate Date Date when the work center or shift record changed.
Finder String Finder identifier used to select finder logic or view.
SubinventoryName String Name of the subinventory associated with the work center.
WorkCenterId Long Identifier of the work center.
WorkCenterName String Name of the work center.

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