Resource Shift Exception
The Resource Shift Exception view object contains information about exceptions defined for a resource belonging to its work center. Shift hours of a work center resource can be added, removed, or modified. Likewise, resource units of a work center resource can be added or removed, all of which results in an increase or decrease of the work center resource capacity during a period of time.
Data Store Key : FscmTopModelAM.ScmExtractAM.WisBiccExtractAM.ResourceShiftExceptionExtractPVO
Primary Keys : ResourceShiftExceptionId
Initial Extract Date : CreationDate
Incremental Extract Date : LastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| AttributeCategory | Context name for the Resource Shift Exception descriptive flexfield. |
| AttributeChar1 | Character segment for the Resource Shift Exception descriptive flexfield. |
| AttributeChar10 | Character segment for the Resource Shift Exception descriptive flexfield. |
| AttributeChar11 | Character segment for the Resource Shift Exception descriptive flexfield. |
| AttributeChar12 | Character segment for the Resource Shift Exception descriptive flexfield. |
| AttributeChar13 | Character segment for the Resource Shift Exception descriptive flexfield. |
| AttributeChar14 | Character segment for the Resource Shift Exception descriptive flexfield. |
| AttributeChar15 | Character segment for the Resource Shift Exception descriptive flexfield. |
| AttributeChar16 | Character segment for the Resource Shift Exception descriptive flexfield. |
| AttributeChar17 | Character segment for the Resource Shift Exception descriptive flexfield. |
| AttributeChar18 | Character segment for the Resource Shift Exception descriptive flexfield. |
| AttributeChar19 | Character segment for the Resource Shift Exception descriptive flexfield. |
| AttributeChar2 | Character segment for the Resource Shift Exception descriptive flexfield. |
| AttributeChar20 | Character segment for the Resource Shift Exception descriptive flexfield. |
| AttributeChar3 | Character segment for the Resource Shift Exception descriptive flexfield. |
| AttributeChar4 | Character segment for the Resource Shift Exception descriptive flexfield. |
| AttributeChar5 | Character segment for the Resource Shift Exception descriptive flexfield. |
| AttributeChar6 | Character segment for the Resource Shift Exception descriptive flexfield. |
| AttributeChar7 | Character segment for the Resource Shift Exception descriptive flexfield. |
| AttributeChar8 | Character segment for the Resource Shift Exception descriptive flexfield. |
| AttributeChar9 | Character segment for the Resource Shift Exception descriptive flexfield. |
| AttributeDate1 | Date segment for the Resource Shift Exception descriptive flexfield. |
| AttributeDate2 | Date segment for the Resource Shift Exception descriptive flexfield. |
| AttributeDate3 | Date segment for the Resource Shift Exception descriptive flexfield. |
| AttributeDate4 | Date segment for the Resource Shift Exception descriptive flexfield. |
| AttributeDate5 | Date segment for the Resource Shift Exception descriptive flexfield. |
| AttributeNumber1 | Number segment for the Resource Shift Exception descriptive flexfield. |
| AttributeNumber10 | Number segment for the Resource Shift Exception descriptive flexfield. |
| AttributeNumber2 | Number segment for the Resource Shift Exception descriptive flexfield. |
| AttributeNumber3 | Number segment for the Resource Shift Exception descriptive flexfield. |
| AttributeNumber4 | Number segment for the Resource Shift Exception descriptive flexfield. |
| AttributeNumber5 | Number segment for the Resource Shift Exception descriptive flexfield. |
| AttributeNumber6 | Number segment for the Resource Shift Exception descriptive flexfield. |
| AttributeNumber7 | Number segment for the Resource Shift Exception descriptive flexfield. |
| AttributeNumber8 | Number segment for the Resource Shift Exception descriptive flexfield. |
| AttributeNumber9 | Number segment for the Resource Shift Exception descriptive flexfield. |
| AttributeTimestamp1 | Date and Time segment for the Resource Shift Exception descriptive flexfield. |
| AttributeTimestamp2 | Date and Time segment for the Resource Shift Exception descriptive flexfield. |
| AttributeTimestamp3 | Date and Time segment for the Resource Shift Exception descriptive flexfield. |
| AttributeTimestamp4 | Date and Time segment for the Resource Shift Exception descriptive flexfield. |
| AttributeTimestamp5 | Date and Time segment for the Resource Shift Exception descriptive flexfield. |
| CreatedBy | User who created the resource shift exception record. |
| CreationDate | Date and time when the resource shift exception record was created. |
| ExceptionType | Identifies the type of resource shift exception. |
| FromDate | Represents the start date of the resource shift exception. |
| FromTime | Represents the start time of the resource shift exception. |
| LastUpdateDate | Date and time when the user last updated the resource shift exception record. |
| LastUpdateLogin | Session login associated with the user who last updated the resource shift exception record. |
| LastUpdatedBy | User who last updated the resource shift exception 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. |
| ReasonCode | Indicates the reason for defining the resource shift exception. |
| ResourceId | Value that uniquely identifies the resource. This is a foreign key to the Resource view object. |
| ResourceQuantity | Represents the number of resource units to increase or decrease when a resource shift exception is defined. |
| ResourceShiftExceptionId | Value that uniquely identifies the resource shift exception. This is the primary key of the Resource Shift Exception view object. |
| ScheduleDetailId | Value that uniquely identifies the schedule attached to the manufacturing plant. |
| ToDate | Represents the end date of the resource shift exception. |
| ToTime | Represents the end time of the resource shift exception. |
| WorkCenterId | Value that uniquely identifies the work center. This is a foreign key to the Work Center view object. |