VIEW_PATHOLOGICAL

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

CARE_ID

int

null

N8_3_RESULT_DATE

smalldatetime

√

null

N8_4_PATHOLOGIST

varchar

√

null

N8_16_PATH_T_STAGE

varchar

√

null

N8_17_PATH_N_STAGE

varchar

√

null

N8_18_PATH_M_STAGE

varchar

√

null

L_PATH_T_LETTER

char

√

null

L_PATH_N_LETTER

char

√

null

L_PATH_M_LETTER

char

√

null

TYPE_DESC

varchar

√

null

IsoDateReported

varchar

√

null

View Definition

CREATE VIEW [dbo].[VIEW_PATHOLOGICAL]
AS
SELECT     TOP (100) PERCENT dbo.tblMAIN_PATHOLOGY.CARE_ID, dbo.tblMAIN_PATHOLOGY.N8_3_RESULT_DATE, 
                      dbo.tblMAIN_PATHOLOGY.N8_4_PATHOLOGIST, dbo.tblMAIN_PATHOLOGY.N8_16_PATH_T_STAGE, 
                      dbo.tblMAIN_PATHOLOGY.N8_17_PATH_N_STAGE, dbo.tblMAIN_PATHOLOGY.N8_18_PATH_M_STAGE, dbo.tblMAIN_PATHOLOGY.L_PATH_T_LETTER, 
                      dbo.tblMAIN_PATHOLOGY.L_PATH_N_LETTER, dbo.tblMAIN_PATHOLOGY.L_PATH_M_LETTER, dbo.ltblINVESTIGATION_TYPE.TYPE_DESC, 
                      CONVERT(varchar(10), dbo.tblMAIN_PATHOLOGY.N8_3_RESULT_DATE, 111) AS IsoDateReported
FROM         dbo.tblMAIN_PATHOLOGY LEFT OUTER JOIN
                      dbo.ltblINVESTIGATION_TYPE ON dbo.tblMAIN_PATHOLOGY.N8_1_PATHOLOGY_TYPE = dbo.ltblINVESTIGATION_TYPE.TYPE_CODE
WHERE     (dbo.tblMAIN_PATHOLOGY.N8_16_PATH_T_STAGE <> '') OR
                      (dbo.tblMAIN_PATHOLOGY.N8_17_PATH_N_STAGE <> '') OR
                      (dbo.tblMAIN_PATHOLOGY.N8_18_PATH_M_STAGE <> '')

Columns

View Definition

Possibly Referenced Tables/Views