PROCEDURE_BRAIN - CanRegPrevious_v22

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

PROC_CODE

varchar

null

PROC_DESC

varchar

255

√

null

NOT_IN_USE

int

√

null

View Definition

CREATE VIEW [dbo].[PROCEDURE_BRAIN]
AS
SELECT     PROC_CODE, PROC_DESC, NOT_IN_USE
FROM         dbo.ltblPROCEDURES
WHERE     (PROC_CODE LIKE 'A01%') OR
                      (PROC_CODE LIKE 'A02%') OR
                      (PROC_CODE LIKE 'A03%') OR
          (PROC_CODE LIKE 'A04%') OR
          (PROC_CODE LIKE 'A07%') OR
          (PROC_CODE LIKE 'A08%') OR
          (PROC_CODE LIKE 'A10%') OR
          (PROC_CODE LIKE 'A17%') OR
          (PROC_CODE LIKE 'A18%') OR
          (PROC_CODE LIKE 'A29%') OR
          (PROC_CODE LIKE 'A34%') OR
          (PROC_CODE LIKE 'A36%') OR
          (PROC_CODE LIKE 'A38%') OR
          (PROC_CODE LIKE 'A42%') OR
          (PROC_CODE LIKE 'A44%') OR
          (PROC_CODE LIKE 'A45%') OR
          (PROC_CODE LIKE 'A48%') OR
          (PROC_CODE LIKE 'A51%') OR
          (PROC_CODE LIKE 'A57%') OR
          (PROC_CODE LIKE 'B01%') OR
          (PROC_CODE LIKE 'B02%') OR
          (PROC_CODE LIKE 'B04%') OR
          (PROC_CODE LIKE 'B06%') OR
		  (PROC_CODE = 'Y502') OR
		  (PROC_CODE = 'V241') OR
		  (PROC_CODE = 'V265') OR
		  (PROC_CODE = 'V038') OR
		  (PROC_CODE = 'V253') OR
		  (PROC_CODE = 'V431') OR
		  (PROC_CODE = 'A168') OR
          (PROC_CODE LIKE 'Z94%') OR
          PROC_CODE IN ('A027', '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', 'S627', 'S631', 'S632', 'S633', 'S638',
						'S639', 'T125', 'V017', 'V021', 'V022', 'V023',
						'V028', 'V029', 'V037', 'V106', 'V107', 'V121',
						'V122', 'V123', 'V124', 'V125', 'V128', 'V129',
						'V134', 'V181', 'V182', 'V183', 'V184', 'V185',
						'V186', 'V188', 'V189', 'W246', 'X505', 'Y484',
						'A821', 'A828', 'A829')

Possibly Referenced Tables/Views

ltblPROCEDURES