vwBAUS_NEPHRECTOMY_PATHOLOGY_BIOPSY

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

PATHOLOGY_ID

int

null

CARE_ID

int

null

PATH_BIOPSY_SAMPLE_DATE

smalldatetime

√

null

PATH_BIOPSY_BIOPSY_RESULT

int

√

null

PATH_BIOPSY_N8_11_GRADE_DIFF

varchar

√

null

PATH_BIOPSY_R_SIZE_TUMOUR_RCC

real

√

null

View Definition

CREATE VIEW [dbo].[vwBAUS_NEPHRECTOMY_PATHOLOGY_BIOPSY]
AS
	SELECT
		a.PATHOLOGY_ID,
		a.CARE_ID,
		a.SAMPLE_DATE AS PATH_BIOPSY_SAMPLE_DATE,
		tblPATHOLOGY_UROLOGY.BIOPSY_RESULT AS PATH_BIOPSY_BIOPSY_RESULT,
		a.N8_11_GRADE_DIFF AS PATH_BIOPSY_N8_11_GRADE_DIFF,
		R_SIZE_TUMOUR_RCC AS PATH_BIOPSY_R_SIZE_TUMOUR_RCC
	FROM tblMAIN_PATHOLOGY a
		JOIN vwBAUS_NEPHRECTOMY_BASIC
			ON a.CARE_ID = vwBAUS_NEPHRECTOMY_BASIC.CARE_ID 
		LEFT JOIN tblMAIN_PATHOLOGY b
			ON a.CARE_ID = b.CARE_ID
				AND (a.SAMPLE_DATE > b.SAMPLE_DATE
						OR (a.SAMPLE_DATE = b.SAMPLE_DATE AND a.PATHOLOGY_ID > b.PATHOLOGY_ID))
				AND ISNULL(b.N8_1_PATHOLOGY_TYPE, '') IN ('BU', 'IB', 'PB', 'SB')
				AND b.N8_22_SPECIMEN_NATURE = '1'
				AND b.N8_21_REPORT_STATUS = '1'
		JOIN tblPATHOLOGY_UROLOGY
			ON tblPATHOLOGY_UROLOGY.PATHOLOGY_ID = a.PATHOLOGY_ID
	WHERE b.PATHOLOGY_ID IS NULL AND
			ISNULL(a.N8_1_PATHOLOGY_TYPE, '') IN ('BU', 'IB', 'PB', 'SB') AND
			a.N8_22_SPECIMEN_NATURE = '1' AND
			a.N8_21_REPORT_STATUS = '1'

Columns

View Definition

Possibly Referenced Tables/Views