Resource Availability Details for Extraction

The Resource Availability Details for Extraction view object collects the work center resources in a plant with the start and end times for each resource on each working day.

Data Store Key : FscmTopModelAM.ScmExtractAM.ScmRcsBiccExtractAM.ResourceAvailabilityDetailsExtractPVO

Primary Keys : ResourceScheduleId

Initial Extract Date : CreationDate

Incremental Extract Date : LastUpdateDate

Attributes

This table provides the list of exposed attributes and their descriptions.

Name	Description
AvailableUnits	Value that identifies the quantity of available units for the work center resource for this availability period.
CreatedBy	User who created the row.
CreationDate	Date and time of the creation of the row.
EndDateTime	Date and time when the work center resource is no longer working.
ExceptionId	Value that identifies the exception that this row belongs to. This value could be mapped to a shift exception or a work center resource exception.
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.
MfgOrgIdentifier	Value that uniquely identifies the inventory organization that's the plant.
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.
ResourceScheduleId	Value that uniquely identifies a resource and schedule combination. The application generates this value when it creates the data.
ScheduleDetailId	Value that uniquely identifies a row in ZMM_SR_SCHEDULE_DTLS that's used to create the availability data for the resource.
ScheduleId	Value that uniquely identifies the production calendar of a plant.
ShiftId	Value that uniquely identifies the shift in the production calendar of a plant.
StartDateTime	Date and time when the work center resource starts working.
WcResourceIdentifier	Value that uniquely identifies the resource.
WorkCenterId	Value that uniquely identifies the work center associated with the resource.