Resource Shift
The Resource Shift view object contains the number of resource units assigned to each shift of the manufacturing plant. These shift assignments determine the resource availability in its work center.
Data Store Key : FscmTopModelAM.ScmExtractAM.WisBiccExtractAM.ResourceShiftExtractPVO
Primary Keys : ResourceId, ShiftId, WorkCenterId
Initial Extract Date : CreationDate
Incremental Extract Date : LastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| AssignedUnits | Number of resource units assigned to the shift. |
| AttributeCategory | Context name for the Resource Shift descriptive flexfield. |
| AttributeChar1 | Character segment for the Resource Shift descriptive flexfield. |
| AttributeChar10 | Character segment for the Resource Shift descriptive flexfield. |
| AttributeChar11 | Character segment for the Resource Shift descriptive flexfield. |
| AttributeChar12 | Character segment for the Resource Shift descriptive flexfield. |
| AttributeChar13 | Character segment for the Resource Shift descriptive flexfield. |
| AttributeChar14 | Character segment for the Resource Shift descriptive flexfield. |
| AttributeChar15 | Character segment for the Resource Shift descriptive flexfield. |
| AttributeChar16 | Character segment for the Resource Shift descriptive flexfield. |
| AttributeChar17 | Character segment for the Resource Shift descriptive flexfield. |
| AttributeChar18 | Character segment for the Resource Shift descriptive flexfield. |
| AttributeChar19 | Character segment for the Resource Shift descriptive flexfield. |
| AttributeChar2 | Character segment for the Resource Shift descriptive flexfield. |
| AttributeChar20 | Character segment for the Resource Shift descriptive flexfield. |
| AttributeChar3 | Character segment for the Resource Shift descriptive flexfield. |
| AttributeChar4 | Character segment for the Resource Shift descriptive flexfield. |
| AttributeChar5 | Character segment for the Resource Shift descriptive flexfield. |
| AttributeChar6 | Character segment for the Resource Shift descriptive flexfield. |
| AttributeChar7 | Character segment for the Resource Shift descriptive flexfield. |
| AttributeChar8 | Character segment for the Resource Shift descriptive flexfield. |
| AttributeChar9 | Character segment for the Resource Shift descriptive flexfield. |
| AttributeDate1 | Date segment for the Resource Shift descriptive flexfield. |
| AttributeDate2 | Date segment for the Resource Shift descriptive flexfield. |
| AttributeDate3 | Date segment for the Resource Shift descriptive flexfield. |
| AttributeDate4 | Date segment for the Resource Shift descriptive flexfield. |
| AttributeDate5 | Date segment for the Resource Shift descriptive flexfield. |
| AttributeNumber1 | Number segment for the Resource Shift descriptive flexfield. |
| AttributeNumber10 | Number segment for the Resource Shift descriptive flexfield. |
| AttributeNumber2 | Number segment for the Resource Shift descriptive flexfield. |
| AttributeNumber3 | Number segment for the Resource Shift descriptive flexfield. |
| AttributeNumber4 | Number segment for the Resource Shift descriptive flexfield. |
| AttributeNumber5 | Number segment for the Resource Shift descriptive flexfield. |
| AttributeNumber6 | Number segment for the Resource Shift descriptive flexfield. |
| AttributeNumber7 | Number segment for the Resource Shift descriptive flexfield. |
| AttributeNumber8 | Number segment for the Resource Shift descriptive flexfield. |
| AttributeNumber9 | Number segment for the Resource Shift descriptive flexfield. |
| AttributeTimestamp1 | Date and Time segment for the Resource Shift descriptive flexfield. |
| AttributeTimestamp2 | Date and Time segment for the Resource Shift descriptive flexfield. |
| AttributeTimestamp3 | Date and Time segment for the Resource Shift descriptive flexfield. |
| AttributeTimestamp4 | Date and Time segment for the Resource Shift descriptive flexfield. |
| AttributeTimestamp5 | Date and Time segment for the Resource Shift descriptive flexfield. |
| CreatedBy | User who created the resource shift record. |
| CreationDate | Date and time when the resource shift record was created. |
| LastUpdateDate | Date and time when the user last updated the resource shift record. |
| LastUpdateLogin | Session login associated with the user who last updated the resource shift record. |
| LastUpdatedBy | User who last updated the resource shift record. |
| ObjectVersionNumber | Number of times the object row was updated. This attribute is used to implement optimistic locking. This number is incremented every time the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. |
| ResourceId | Value that uniquely identifies the resource in the resource shift. This is a foreign key to the Resource view object. This attribute is a part of the composite key of the Resource Shift view object. |
| ShiftId | Value that uniquely identifies the shift in the resource shift. This is a foreign key to the Shift object. This attribute is a part of the composite key of th Resource Shift view object. |
| WcProdCalendarId | Value that uniquely identifies the calendar in the resource shift. This is a foreign key to the Work Center Calendar view object. |
| WorkCenterId | Value that uniquely identifies the work center in the resource shift. This is a foreign key to the Work Center view object. This attribute is a part of the composite key of the Resource Shift view object. |