SNOMED_LUNG - CanRegPrevious_v22

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

M_CODE

varchar

50

null

ltblSNOMed.M_CODE

Implied ConstraintR

M_DESC

varchar

255

null

M_LIST

varchar

308

null

Relationships

Close relationships within degrees of separation

View Definition

/*-----------------------------------------------------------------------
 UPDATE [SNOMED_LUNG]
-----------------------------------------------------------------------*/
CREATE VIEW [dbo].[SNOMED_LUNG]
AS
SELECT     M_CODE, M_DESC, M_DESC + ' - ' + M_CODE AS M_LIST
FROM         dbo.ltblSNOMed
WHERE				  (M_CODE = 'M80102') OR
                      (M_CODE = 'M80106') OR
                      (M_CODE = 'M80413') OR
                      (M_CODE = 'M80463') OR
                      (M_CODE = 'M80703') OR
                      (M_CODE = 'M81403') OR
                      (M_CODE = 'M82503') OR
                      (M_CODE = 'M80123') OR
                      (M_CODE = 'M80203') OR
                      (M_CODE = 'M80133') OR
                      (M_CODE = 'M82403') OR
                      (M_CODE = 'M89803') OR
                      (M_CODE = 'M90503') OR
                      (M_CODE = 'M90523') OR
                      (M_CODE = 'M90513') OR
                      (M_CODE = 'M89403') OR
                      (M_CODE = 'M90533') OR
                      (M_CODE = 'M80103') OR
                      (M_CODE = 'M80713') OR
                      (M_CODE = 'M80706') OR
                      (M_CODE = 'M80013') OR
                      (M_CODE = 'M81406') OR
                      (M_CODE = 'M89900') OR
                      (M_CODE = 'M89901') OR
                      (M_CODE = 'M89903') OR
                      (M_CODE = 'M85753') OR
                      (M_CODE = 'M82401') OR
					  (M_CODE = 'M82443') OR
					  (M_CODE = 'M82463') OR
					  (M_CODE = 'M95800') OR
					  (M_CODE = 'M80003') OR
					  (M_CODE = 'M85800') OR
					  (M_CODE = 'M85803') OR
					  (M_CODE = 'M85603') OR
					  (M_CODE = 'M88003') OR
					  (M_CODE = 'M88900') OR
					  (M_CODE = 'M80503') OR
					  (M_CODE = 'M82493') OR
					  (M_CODE = 'M80333') OR
					  (M_CODE = 'M89723') OR
					  (M_CODE = 'M74000') OR
                      (M_CODE LIKE 'M0901%') OR
                      (M_CODE LIKE 'M00%')                      
                      OR (M_CODE LIKE 'M82003')
                      OR (M_CODE LIKE 'M80702')
                      OR (M_CODE LIKE 'M80323')
                      OR (M_CODE LIKE 'M80223')
                      OR (M_CODE LIKE 'M89633')
                      OR (M_CODE LIKE 'M95083')
                      OR (M_CODE LIKE 'M81405')
					  OR (M_CODE LIKE 'M83333')
					  OR (M_CODE LIKE 'M80843')
					  OR (M_CODE LIKE 'M82523')
					  OR (M_CODE LIKE 'M82533')
					  OR (M_CODE LIKE 'M82543')
					  OR (M_CODE LIKE 'M84703')
OR ltblSNOMed.M_CODE = 'M83303' OR ltblSNOMed.M_CODE = 'M80706'

Possibly Referenced Tables/Views

ltblSNOMed