vwSUMMARY_FOLLOWUP

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

ASSESSMENT_ID

int

null

CARE_ID

int

null

N14_1_ASSESSMENT_DATE

smalldatetime

√

null

TUMOUR_DESC

varchar

100

√

null

NODAL_DESC

varchar

100

√

null

METS_DESC

varchar

100

√

null

N14_6_WHO_STATUS

int

√

null

L_FOLLOWUP

varchar

√

null

MODE_DESC

varchar

√

null

View Definition

CREATE VIEW dbo.vwSUMMARY_FOLLOWUP
AS
SELECT     TOP 100 PERCENT dbo.tblMAIN_ASSESSMENT.ASSESSMENT_ID, dbo.tblMAIN_ASSESSMENT.CARE_ID, 
                      dbo.tblMAIN_ASSESSMENT.N14_1_ASSESSMENT_DATE, dbo.ltblTUMOUR_STATUS.TUMOUR_DESC, dbo.ltblNODAL_STATUS.NODAL_DESC, 
                      dbo.ltblMETS_STATUS.METS_DESC, dbo.tblMAIN_ASSESSMENT.N14_6_WHO_STATUS, dbo.tblMAIN_ASSESSMENT.L_FOLLOWUP, 
                      dbo.ltblCOLO_FOLLOWUP.MODE_DESC
FROM         dbo.tblMAIN_ASSESSMENT LEFT OUTER JOIN
                      dbo.ltblCOLO_FOLLOWUP ON dbo.tblMAIN_ASSESSMENT.R_MODE_FOLLOWUP = dbo.ltblCOLO_FOLLOWUP.MODE_CODE LEFT OUTER JOIN
                      dbo.ltblMETS_STATUS ON dbo.tblMAIN_ASSESSMENT.N14_4_METS_STATUS = dbo.ltblMETS_STATUS.METS_CODE LEFT OUTER JOIN
                      dbo.ltblNODAL_STATUS ON dbo.tblMAIN_ASSESSMENT.N14_3_NODE_STATUS = dbo.ltblNODAL_STATUS.NODAL_CODE LEFT OUTER JOIN
                      dbo.ltblTUMOUR_STATUS ON dbo.tblMAIN_ASSESSMENT.N14_2_TUMOUR_STATUS = dbo.ltblTUMOUR_STATUS.TUMOUR_CODE

Columns

View Definition

Possibly Referenced Tables/Views