vwFH_SUMMARY_PREV

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

CARE_ID

int

√

null

L_FAMILY_TAKEN

int

√

null

L_FAMILY_DATE

smalldatetime

√

null

RELATION_DESC

varchar

√

null

DIAG_1

varchar

√

null

DIAG_2

varchar

√

null

PATIENT_ID

int

null

L_CANCER_SITE

varchar

√

null

L_NEW_CA_SITE

varchar

√

null

L_FAMILY_COMMENTS

text

2147483647

√

null

View Definition

CREATE VIEW dbo.vwFH_SUMMARY_PREV
AS
SELECT     dbo.tblFAMILY_HISTORY.CARE_ID, dbo.tblFAMILY_HISTORY.L_FAMILY_TAKEN, dbo.tblFAMILY_HISTORY.L_FAMILY_DATE, 
                      dbo.ltblRELATIONS.RELATION_DESC, ltblDIAGNOSIS_1.DIAG_DESC AS DIAG_1, ltblDIAGNOSIS_2.DIAG_DESC AS DIAG_2, 
                      dbo.tblMAIN_REFERRALS.PATIENT_ID, dbo.tblMAIN_REFERRALS.L_CANCER_SITE, dbo.tblMAIN_REFERRALS.L_NEW_CA_SITE, 
                      dbo.tblFAMILY_HISTORY.L_FAMILY_COMMENTS
FROM         dbo.ltblDIAGNOSIS ltblDIAGNOSIS_1 RIGHT OUTER JOIN
                      dbo.tblFAMILY_HISTORY INNER JOIN
                      dbo.tblMAIN_REFERRALS ON dbo.tblFAMILY_HISTORY.CARE_ID = dbo.tblMAIN_REFERRALS.CARE_ID LEFT OUTER JOIN
                      dbo.ltblDIAGNOSIS ltblDIAGNOSIS_2 ON dbo.tblFAMILY_HISTORY.L_FAMILY_DIAGNOSIS_2 = ltblDIAGNOSIS_2.DIAG_CODE ON 
                      ltblDIAGNOSIS_1.DIAG_CODE = dbo.tblFAMILY_HISTORY.L_FAMILY_DIAGNOSIS LEFT OUTER JOIN
                      dbo.ltblRELATIONS ON dbo.tblFAMILY_HISTORY.L_FAMILY_RELATION = dbo.ltblRELATIONS.RELATION_CODE
WHERE     (dbo.tblFAMILY_HISTORY.L_FAMILY_TAKEN = 1) AND (dbo.tblMAIN_REFERRALS.L_INAP_REF = 1)

Columns

View Definition

Possibly Referenced Tables/Views