vwSKIN_SUB_DIAGNOSIS

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

CARE_ID

int

√

null

N_SK1_DIAGNOSIS_DATE

smalldatetime

√

null

TYPE_DESC

varchar

√

null

SITE_DESC

varchar

√

null

CELL_DESC

varchar

√

null

N_SK6_RECURRENCE

char

√

null

LUNG_METS

varchar

√

null

BONE_METS

varchar

√

null

LIVER_METS

varchar

√

null

OTHER_METS

varchar

√

null

View Definition

CREATE VIEW dbo.vwSKIN_SUB_DIAGNOSIS
AS
SELECT     dbo.tblDERMATOLOGY_RECURRENCES.CARE_ID, dbo.tblDERMATOLOGY_RECURRENCES.N_SK1_DIAGNOSIS_DATE, 
                      dbo.ltblSKIN_TYPE.TYPE_DESC, dbo.ltblBODY_SITE.SITE_DESC, dbo.ltblDERM_BASAL_CELL.CELL_DESC, 
                      dbo.tblDERMATOLOGY_RECURRENCES.N_SK6_RECURRENCE, ltblCOLO_METS_2.MET_DESC AS LUNG_METS, 
                      ltblCOLO_METS_1.MET_DESC AS BONE_METS, ltblCOLO_METS_2.MET_DESC AS LIVER_METS, 
                      ltblCOLO_METS_3.MET_DESC AS OTHER_METS
FROM         dbo.ltblDERM_BASAL_CELL RIGHT OUTER JOIN
                      dbo.ltblCOLO_METS ltblCOLO_METS_4 RIGHT OUTER JOIN
                      dbo.tblDERMATOLOGY_RECURRENCES LEFT OUTER JOIN
                      dbo.ltblSKIN_TYPE ON dbo.tblDERMATOLOGY_RECURRENCES.L_SKIN_TYPE = dbo.ltblSKIN_TYPE.TYPE_CODE ON 
                      ltblCOLO_METS_4.MET_CODE = dbo.tblDERMATOLOGY_RECURRENCES.L_MET_LUNG LEFT OUTER JOIN
                      dbo.ltblCOLO_METS ltblCOLO_METS_2 ON dbo.tblDERMATOLOGY_RECURRENCES.L_MET_LIVER = ltblCOLO_METS_2.MET_CODE LEFT OUTER JOIN
                      dbo.ltblCOLO_METS ltblCOLO_METS_3 ON dbo.tblDERMATOLOGY_RECURRENCES.L_MET_OTHER = ltblCOLO_METS_3.MET_CODE LEFT OUTER JOIN
                      dbo.ltblCOLO_METS ltblCOLO_METS_1 ON dbo.tblDERMATOLOGY_RECURRENCES.L_MET_BONE = ltblCOLO_METS_1.MET_CODE ON 
                      dbo.ltblDERM_BASAL_CELL.CELL_CODE = dbo.tblDERMATOLOGY_RECURRENCES.N_SK4_BCC_MORPHOLOGY LEFT OUTER JOIN
                      dbo.ltblBODY_SITE ON dbo.tblDERMATOLOGY_RECURRENCES.N_SK2_BODY_SITE = dbo.ltblBODY_SITE.SITE_CODE

Columns

View Definition

Possibly Referenced Tables/Views