Shift Details
The Shift Details view object consolidates the collection of time segments that decompose the working time of the shift. Only time shifts that are of type flexible or punch have shift details.
Data Store Key : FscmTopModelAM.ScmExtractAM.ScmRcsBiccExtractAM.ShiftDetailsExtractPVO
Primary Keys : ShiftDtlId
Initial Extract Date : CreationDate
Incremental Extract Date : LastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| Attribute1 | Segment of the user-descriptive flexfield. |
| Attribute10 | Segment of the user-descriptive flexfield. |
| Attribute11 | Segment of the user-descriptive flexfield. |
| Attribute12 | Segment of the user-descriptive flexfield. |
| Attribute13 | Segment of the user-descriptive flexfield. |
| Attribute14 | Segment of the user-descriptive flexfield. |
| Attribute15 | Segment of the user-descriptive flexfield. |
| Attribute16 | Segment of the user-descriptive flexfield. |
| Attribute17 | Segment of the user-descriptive flexfield. |
| Attribute18 | Segment of the user-descriptive flexfield. |
| Attribute19 | Segment of the user-descriptive flexfield. |
| Attribute2 | Segment of the user-descriptive flexfield. |
| Attribute20 | Segment of the user-descriptive flexfield. |
| Attribute21 | Segment of the user-descriptive flexfield. |
| Attribute22 | Segment of the user-descriptive flexfield. |
| Attribute23 | Segment of the user-descriptive flexfield. |
| Attribute24 | Segment of the user-descriptive flexfield. |
| Attribute25 | Segment of the user-descriptive flexfield. |
| Attribute26 | Segment of the user-descriptive flexfield. |
| Attribute27 | Segment of the user-descriptive flexfield. |
| Attribute28 | Segment of the user-descriptive flexfield. |
| Attribute29 | Segment of the user-descriptive flexfield. |
| Attribute3 | Segment of the user-descriptive flexfield. |
| Attribute30 | Segment of the user-descriptive flexfield. |
| Attribute4 | Segment of the user-descriptive flexfield. |
| Attribute5 | Segment of the user-descriptive flexfield. |
| Attribute6 | Segment of the user-descriptive flexfield. |
| Attribute7 | Segment of the user-descriptive flexfield. |
| Attribute8 | Segment of the user-descriptive flexfield. |
| Attribute9 | Segment of the user-descriptive flexfield. |
| AttributeCategory | Structure definition of the user descriptive flexfield. |
| CoreFlag | Contains one of the following values: true or false. If true, then the shift detail is core working time. If false, then the shift detail isn't core working time. The default value is false. |
| CreatedBy | User who created the row. |
| CreationDate | Date and time of the creation of the row. |
| DurationMsNum | Value that identifies the duration of the shift detail. |
| DurationUomCode | Unit of time to associate with the time-duration value. |
| EndTimeMsNum | Time when the shift detail ends. |
| LastUpdateDate | Date and time of the last update of the row. |
| LastUpdateLogin | Session login associated to the user who last updated the row. |
| LastUpdatedBy | User who last updated the row. |
| MaxBreakMsNum | Maximum number of minutes that you may take as a break in the shift detail. |
| MinBreakMsNum | Minimum number of minutes that you may take as a break in the shift detail. |
| ObjectVersionNumber | Used to implement optimistic locking. This number is incremented every time that 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. |
| ShiftDetailCode | Name of the shift detail. |
| ShiftDtlId | Value that uniquely identifies the shift detail. It's a primary key that the application generates when it creates a shift detail. This attribute is required. |
| ShiftId | Value that uniquely identifies the shift. It's a primary key that the application generates when it creates a shift. This attribute is required. |
| StartTimeMsNum | Time when the shift detail starts. |