vwSARCOMA_TISSUE - CanRegPrevious_v22

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

PROC_CODE

varchar

null

PROC_DESC

varchar

287

√

null

PROC_V

varchar

√

null

View Definition

CREATE VIEW [dbo].[vwSARCOMA_TISSUE]
AS
SELECT     PROC_CODE, 
CASE 
	WHEN PROC_CODE = 'Z908'
		THEN PROC_DESC + ' (to include groin, knee, ankle)'
	ELSE
		PROC_DESC
	END as PROC_DESC,
PROC_V
FROM         dbo.ltblPROCEDURES
WHERE     (PROC_CODE = 'Z272') OR
                      (PROC_CODE = 'Z301') OR
                      (PROC_CODE = 'Z459') OR
                      (PROC_CODE = 'Z533') OR
                      (PROC_CODE = 'Z891') OR
                      (PROC_CODE = 'Z892') OR
                      (PROC_CODE = 'Z893') OR
                      (PROC_CODE = 'Z894') OR
                      (PROC_CODE = 'Z898') OR
                      (PROC_CODE = 'Z901') OR
                      (PROC_CODE = 'Z903') OR
                      (PROC_CODE = 'Z904') OR
                      (PROC_CODE = 'Z908') OR
                      (PROC_CODE = 'Z905') OR
                      (PROC_CODE = 'Z921') OR
                      (PROC_CODE = 'Z923') OR
                      (PROC_CODE = 'Z924') OR
                      (PROC_CODE = 'Z927') OR
                      (PROC_CODE = 'Z928') OR
                      (PROC_CODE = 'Z929')

Possibly Referenced Tables/Views

ltblPROCEDURES