vwTimedPathwayMDTData

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

OrderingRank

int

null

CareID

int

√

null

MDTID

varchar

255

√

null

MDTDate

smalldatetime

√

null

MDTType

int

√

null

View Definition

CREATE VIEW [dbo].[vwTimedPathwayMDTData] 

AS

SELECT 0 as OrderingRank, mdt1.CARE_ID AS CareID, CAST(mdt1.MDT_ID AS varchar(25)) AS MDTID, mdt1.MDT_DATE AS MDTDate, mdt2.MEETING_ID AS MDTType FROM 
tblMDT_LIST mdt1 JOIN tblMDT_LIST mdt2 ON mdt1.MEETING_ID = mdt2.MDT_ID WHERE ISNULL(mdt1.DONE, 1) = 2 AND mdt1.CARE_ID IS NOT NULL
UNION
SELECT 1 as OrderingRank, CARE_ID AS CareID, mdt.MDT_ID AS MDTID, mdt.MDT_DATE AS MDTDate, 1 AS MDTType FROM tblBRAIN_MDT mdt WHERE TRY_CAST(mdt.MDT_ID AS int) IS NULL AND UPDATED = 'Yes' AND mdt.CARE_ID IS NOT NULL
UNION
SELECT 1 as OrderingRank, CARE_ID AS CareID, mdt.MDT_ID AS MDTID, mdt.MDT_DATE AS MDTDate, 2 AS MDTType FROM tblBREAST_MDT mdt WHERE TRY_CAST(mdt.MDT_ID AS int) IS NULL AND UPDATED = 'Yes' AND mdt.CARE_ID IS NOT NULL
UNION
SELECT 1 as OrderingRank, CARE_ID AS CareID, mdt.MDT_ID AS MDTID, mdt.MDT_DATE AS MDTDate, 3 AS MDTType FROM tblCOLORECTAL_MDT mdt WHERE TRY_CAST(mdt.MDT_ID AS int) IS NULL AND UPDATED = 'Yes' AND mdt.CARE_ID IS NOT NULL
UNION
SELECT 1 as OrderingRank, CARE_ID AS CareID, mdt.MDT_ID AS MDTID, mdt.MDT_DATE AS MDTDate, 15 AS MDTType FROM tblCUP_MDT mdt WHERE TRY_CAST(mdt.MDT_ID AS int) IS NULL AND UPDATED = 'Yes' AND mdt.CARE_ID IS NOT NULL
UNION
SELECT 1 as OrderingRank, CARE_ID AS CareID, mdt.MDT_ID AS MDTID, mdt.MDT_DATE AS MDTDate, 4 AS MDTType FROM tblGYNAECOLOGY_MDT mdt WHERE TRY_CAST(mdt.MDT_ID AS int) IS NULL AND UPDATED = 'Yes' AND mdt.CARE_ID IS NOT NULL
UNION
SELECT 1 as OrderingRank, CARE_ID AS CareID, mdt.MDT_ID AS MDTID, mdt.MDT_DATE AS MDTDate, 5 AS MDTType FROM tblHAEMATOLOGY_MDT mdt WHERE TRY_CAST(mdt.MDT_ID AS int) IS NULL AND UPDATED = 'Yes' AND mdt.CARE_ID IS NOT NULL
UNION
SELECT 1 as OrderingRank, CARE_ID AS CareID, mdt.MDT_ID AS MDTID, mdt.MDT_DATE AS MDTDate, 6 AS MDTType FROM tblHEAD_NECK_MDT mdt WHERE TRY_CAST(mdt.MDT_ID AS int) IS NULL AND UPDATED = 'Yes' AND mdt.CARE_ID IS NOT NULL
UNION
SELECT 1 as OrderingRank, CARE_ID AS CareID, mdt.MDT_ID AS MDTID, mdt.MDT_DATE AS MDTDate, 7 AS MDTType FROM tblLUNG_MDT mdt WHERE TRY_CAST(mdt.MDT_ID AS int) IS NULL AND UPDATED = 'Yes' AND mdt.CARE_ID IS NOT NULL
UNION
SELECT 1 as OrderingRank, CARE_ID AS CareID, mdt.MDT_ID AS MDTID, mdt.MDT_DATE AS MDTDate, 8 AS MDTType FROM tblOTHER_MDT mdt WHERE TRY_CAST(mdt.MDT_ID AS int) IS NULL AND UPDATED = 'Yes' AND mdt.CARE_ID IS NOT NULL
UNION
SELECT 1 as OrderingRank, CARE_ID AS CareID, mdt.MDT_ID AS MDTID, mdt.MDT_DATE AS MDTDate, 9 AS MDTType FROM tblPAEDIATRIC_MDT mdt WHERE TRY_CAST(mdt.MDT_ID AS int) IS NULL AND UPDATED = 'Yes' AND mdt.CARE_ID IS NOT NULL
UNION
SELECT 1 as OrderingRank, CARE_ID AS CareID, mdt.MDT_ID AS MDTID, mdt.MDT_DATE AS MDTDate, 10 AS MDTType FROM tblSARCOMA_MDT mdt WHERE TRY_CAST(mdt.MDT_ID AS int) IS NULL AND UPDATED = 'Yes' AND mdt.CARE_ID IS NOT NULL
UNION
SELECT 1 as OrderingRank, CARE_ID AS CareID, mdt.MDT_ID AS MDTID, mdt.MDT_DATE AS MDTDate, 11 AS MDTType FROM tblSKIN_MDT mdt WHERE TRY_CAST(mdt.MDT_ID AS int) IS NULL AND UPDATED = 'Yes' AND mdt.CARE_ID IS NOT NULL
UNION
SELECT 1 as OrderingRank, CARE_ID AS CareID, mdt.MDT_ID AS MDTID, mdt.MDT_DATE AS MDTDate, 12 AS MDTType FROM tblUGI_MDT mdt WHERE TRY_CAST(mdt.MDT_ID AS int) IS NULL AND UPDATED = 'Yes' AND mdt.CARE_ID IS NOT NULL
UNION
SELECT 1 as OrderingRank, CARE_ID AS CareID, mdt.MDT_ID AS MDTID, mdt.MDT_DATE AS MDTDate, 13 AS MDTType FROM tblUROLOGY_MDT mdt WHERE TRY_CAST(mdt.MDT_ID AS int) IS NULL AND UPDATED = 'Yes' AND mdt.CARE_ID IS NOT NULL

Columns

View Definition

Possibly Referenced Tables/Views