DLT_CIE_ESP_VW (SQL View)	Index Back
ESP Delta CIE Codes VW ESP International Classification of Diseases for Delta, using XML_XLAT_CODE = 'CIE'

DLT_CIE_ESP_VW

(SQL View)

ESP Delta CIE Codes VW

ESP International Classification of Diseases for Delta, using XML_XLAT_CODE = 'CIE'

SELECT %Substring(XML_XLAT_VALUE,1,6) , DESCR50 FROM PS_XML_XLATITEM WHERE XML_XLAT_CODE = 'CIE'

Related Language Record: DLT_CIE_LNG_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 DIAGNOSIS_CD Character(6) VARCHAR2(6) NOT NULL Diagnosis Code

2 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	DIAGNOSIS_CD	Character(6)	VARCHAR2(6) NOT NULL	Diagnosis Code
2	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50