Response Work Data Tables

Response Work Data includes the work and segment responses. Results from the execution of a Work Request are contained in Work Responses and there may be one or more Work Responses for a Work Request. Work Responses are associated with zero or more Segment Responses. Segment Responses contain information on the individual segments of work execution for a Work Request.

The following table describes the reporting database tables and their descriptions.

TableDescription
Fact_WorkSegmentResponseWork data associated with segment responses and work responses.
Dim_DateCommon date dimension including detailed information on each day, including the month name, day name, whether it is a weekday or not, and so on.
Dim_EquipmentEquipment definitions.
Dim_TimeCommon time dimension including detailed information on time.
Dim_WorkProcessSegmentWork process segment definitions.
Dim_WorkRequestWork request definitions.
Dim_SegmentRequestSegment request definitions.
Dim_SegReq_ParameterParameter definition in segment request.
Dim_SegReq_MaterialSpecificationMaterial specification in segment request.
Dim_SegReq_EquipmentSpecificationEquipment specification in segment request.
Dim_SegReq_PersonnelSpecificationPersonnel specification in segment request.

The following diagrams illustrate the relationship between the Response Work Data tables: