vwANATOMICAL_SITE - CanRegPrevious_v22

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

SITE_CODE

varchar

null

SITE_DESC

varchar

255

√

null

View Definition

CREATE VIEW [dbo].[vwANATOMICAL_SITE]
AS
SELECT
	PROC_CODE AS SITE_CODE,
	PROC_DESC AS SITE_DESC
FROM
	dbo.ltblPROCEDURES
WHERE
	PROC_CODE IN(
'Y228','Z011','Z019','Z069','Z131','Z135','Z139','Z141','Z144','Z159','Z199','Z201','Z209','Z226','Z229','Z239','Z241',
'Z242','Z243','Z244','Z245','Z246','Z247','Z249','Z251','Z255','Z256','Z257','Z259','Z260','Z261','Z262','Z263','Z269',
'Z271','Z272','Z274','Z277','Z279','Z287','Z289','Z291','Z292','Z301','Z304','Z311','Z361','Z407','Z411','Z413','Z419',
'Z421','Z422','Z427','Z429','Z431','Z432','Z441','Z443','Z449','Z451','Z459','Z462','Z463','Z479','Z489','Z491','Z499',
'Z501','Z502','Z504','Z505','Z509','Z521','Z528','Z529','Z611','Z612','Z613','Z614','Z615','Z616','Z619','Z638','Z659',
'Z669','Z746','Z759','Z871','Z874','Z899','Z902','Z909','Z92','Z921','Z923','Z924','Z925','Z926','Z927','Z929','Z999',
'Z157', 'Z447', 'Z537', 'Z88', 'Z881', 'Z888', 'Z889', 'Z856', 'Z905', 'Z893', 'Z894', 'Z846', 'Z929', 'Z891', 'Z829','U0.1',
'Z906', 'Z473'
)

Possibly Referenced Tables/Views

ltblPROCEDURES