Tables [dbo].[Order_Result_Mapper]
Maps the Result(s) to the Order at the header level.
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
Indexes NIX_orderresult_Resultactivityheaderid, NIX_Order_Result_Mapper_ResultActivityHeaderID_ActivityType(2)ResultActivityHeaderID[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.
Indexes NIX_Order_Result_Mapper_ResultActivityHeaderID_ActivityTypeActivityTypevarchar(10)10NOT NULL Activity Type of Result. RI - Result FI - Finding