vwSomaticTestStatuses

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

Position

int

null

SomaticTestSetID

int

null

Test

varchar

√

null

ResultStatus

varchar

255

√

null

View Definition

CREATE VIEW [dbo].[vwSomaticTestStatuses]

AS

SELECT 
b.Position,
a.Id AS SomaticTestSetID, 
st.[Description] AS Test, 
CASE 
WHEN SomaticTestID IN (2, 12, 19) THEN b.FreeTextField
WHEN SomaticTestID = 3 THEN 
	CASE
		WHEN mb.[Description] IS NOT NULL AND res600.YN_DESC IS NOT NULL
		THEN mb.[Description] + '; ' + 'BRAF V600 - ' + res600.YN_DESC
		WHEN mb.[Description] IS NOT NULL
		THEN mb.[Description]
		WHEN res600.YN_DESC IS NOT NULL
		THEN res600.YN_DESC
		ELSE NULL
	END
WHEN SomaticTestID = 24 THEN 
	CASE
		WHEN mb.[Description] IS NOT NULL AND m.[Description] IS NOT NULL
		THEN mb.[Description] + '; ' + 'MMR IHC - ' + m.[Description]
		WHEN mb.[Description] IS NOT NULL
		THEN mb.[Description]
		WHEN m.[Description] IS NOT NULL
		THEN m.[Description]
		ELSE NULL
	END
ELSE mb.[Description]
END AS ResultStatus 
FROM MBSomaticTesting a 
JOIN MBSomaticTests b ON a.Id = b.SomaticTestSetID
LEFT JOIN MBSomaticTest mb ON b.SomaticTestStatusID = mb.ID
LEFT JOIN SomaticTest st ON b.SomaticTestID = st.ID
LEFT JOIN ltblYNNK res600 ON b.BRAFV600ResultID = res600.YN_ID
LEFT JOIN MBMMRIHC m ON b.MismatchRepairMMRID = m.ID

Columns

View Definition

Possibly Referenced Tables/Views