PROCEDURE_SARCOMA - CanRegPrevious_v22

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

PROC_CODE

varchar

null

PROC_DESC

varchar

255

√

null

View Definition

CREATE VIEW [dbo].[PROCEDURE_SARCOMA]
AS
SELECT     PROC_CODE, PROC_DESC
FROM         dbo.ltblPROCEDURES
WHERE		NOT_IN_USE <> 1 AND     
			((PROC_CODE LIKE 'W33%') OR (PROC_CODE LIKE 'W35%') OR
          (PROC_CODE LIKE 'W36%') OR (PROC_CODE LIKE 'X01%') OR
          (PROC_CODE LIKE 'X02%') OR (PROC_CODE LIKE 'X03%') OR
          (PROC_CODE LIKE 'X04%') OR (PROC_CODE LIKE 'X05%') OR
          (PROC_CODE LIKE 'X07%') OR (PROC_CODE LIKE 'X08%') OR
          (PROC_CODE LIKE 'X09%') OR (PROC_CODE LIKE 'X10%') OR
          (PROC_CODE LIKE 'X11%') OR (PROC_CODE LIKE 'X12%') OR
          (PROC_CODE LIKE 'Z94%') OR (PROC_CODE LIKE 'S%') OR
          (PROC_CODE LIKE 'T%')   OR (PROC_CODE LIKE 'X521') OR
          (PROC_CODE LIKE 'W085') OR (PROC_CODE LIKE 'W581') OR
          (PROC_CODE LIKE 'O211') OR (PROC_CODE LIKE 'E595') OR
          (PROC_CODE LIKE 'J124') OR (PROC_CODE = 'Y502') OR
          (PROC_CODE = 'M137') OR
		   PROC_CODE IN ('A061', 'A062', 'A063', 'A064', 'A068', 'A069',
						 'C172', 'C173', 'C231', 'C232', 'C233', 'C238',
						 'C239', 'E137', 'E154', 'E162', 'E243', 'E641',
						 'E648', 'E649', 'E651', 'E658', 'E659', 'F366',
						 'G261', 'G268', 'G269', 'K223', 'K625', 'K721',
						 'K722', 'K723', 'K724', 'K728', 'K729', 'L436',
						 'L747', 'M027', 'M482', 'M543', 'M603', 'N053',
						 'N066', 'O320', 'O321', 'O322', 'O323', 'O324',
						 'O325', 'O328', 'O329', 'S591', 'S592', 'S598',
						 'S599', 'S627', 'S631', 'S632', 'S633', 'S638',
						 'S639', 'T125', 'T611', 'T613', 'T618', 'T619',
						 'V016', 'X505', 'X932', 'X933', 'X952', 'Y484'))

Possibly Referenced Tables/Views

ltblPROCEDURES