Tables [dbo].[Order_Result_Mapper]
expanded
MS_Description
Maps the Result(s) to the Order at the header level.
expanded
Columns
KeyNameData TypeMax Length (Bytes)NullabilityDescription
Cluster Key CIX_Order_Result_Mapper_OrderActivityHeaderID: OrderActivityHeaderIDForeign Keys FK_Order_Result_Mapper_OrderActivityHeaderID: [dbo].[Order_Activity_Header].OrderActivityHeaderIDOrderActivityHeaderID[dbo].[uniqueid]9NOT NULLOrder Header. Key to the Order_Activity_Header table
Primary Key PK_Order_Result_Mapper_ResultActivityHeaderID_ActivityType: ResultActivityHeaderID\ActivityTypeResultActivityHeaderID[dbo].[uniqueid]9NOT NULLPointer to the Result associated to the Order. If ActivityType = 'FI' this will be the ID in the Act_Hdr_Other table (for Findings). If ActivityType = 'RI' this will be the ID in the Act_Hdr_Result table.
Primary Key PK_Order_Result_Mapper_ResultActivityHeaderID_ActivityType: ResultActivityHeaderID\ActivityTypeActivityTypevarchar(10)10NOT NULL Activity Type of Result. RI - Result FI - Finding