BIvwSarcomaDiagnosisDetail

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

CARE_ID

int

null

Tumour Site (Bone)

varchar

255

√

null

Tumour Site (Soft Tissue)

varchar

255

√

null

Tumour Sub-Site (Bone)

varchar

√

null

Tumour Sub-Site (Soft Tissue)

varchar

√

null

Multi-Focal or Synchronous Tumour Indicator

varchar

√

null

View Definition

CREATE VIEW [dbo].[BIvwSarcomaDiagnosisDetail]
		AS
		SELECT     dbo.tblREFERRAL_SARCOMA.CARE_ID, ltblPROCEDURES_1.PROC_DESC AS [Tumour Site (Bone)], dbo.ltblPROCEDURES.PROC_DESC AS [Tumour Site (Soft Tissue)], 
							  dbo.ltblSAR_PART_SITE.PART_DESC AS [Tumour Sub-Site (Bone)], dbo.ltblSAR_TISSUE_SUBSITE.SUBSITE_DESC AS [Tumour Sub-Site (Soft Tissue)], 
							  CASE MULTIFOCAL_INDICATOR WHEN 'Y' THEN 'Yes' WHEN 'N' THEN 'No' WHEN '9' THEN 'Not Known' ELSE NULL 
							  END AS [Multi-Focal or Synchronous Tumour Indicator]
		FROM         dbo.ltblSAR_TISSUE_SUBSITE RIGHT OUTER JOIN
							  dbo.tblREFERRAL_SARCOMA LEFT OUTER JOIN
							  dbo.ltblPROCEDURES ON dbo.tblREFERRAL_SARCOMA.N_SA1_TUMOUR_SITE_2 = dbo.ltblPROCEDURES.PROC_CODE LEFT OUTER JOIN
							  dbo.ltblPROCEDURES AS ltblPROCEDURES_1 ON dbo.tblREFERRAL_SARCOMA.N_SA1_TUMOUR_SITE_1 = ltblPROCEDURES_1.PROC_CODE LEFT OUTER JOIN
							  dbo.ltblSAR_PART_SITE ON dbo.tblREFERRAL_SARCOMA.N_SA3_PART_SITE = dbo.ltblSAR_PART_SITE.PART_CODE ON 
							  dbo.ltblSAR_TISSUE_SUBSITE.SUBSITE_ID = dbo.tblREFERRAL_SARCOMA.SUBSITE_SOFT_TISSUE

Columns

View Definition

Possibly Referenced Tables/Views