WM_INSP_CDSB_VW

(SQL View)
 Index Back

Inspection Code Subtype View


SELECT '1' , A.FIELDVALUE , A.XLATLONGNAME , A.XLATSHORTNAME FROM PSXLATITEM A WHERE A.FIELDNAME = 'INSP_MEASMT_TYPE' UNION SELECT '2' , B.FIELDVALUE , B.XLATLONGNAME , B.XLATSHORTNAME FROM PSXLATITEM B WHERE B.FIELDNAME = 'INSP_OBSRVN_TYPE' UNION SELECT '3' , C.FIELDVALUE , C.XLATLONGNAME , C.XLATSHORTNAME FROM PSXLATITEM C WHERE C.FIELDNAME = 'INSP_CALCLT_TYPE'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 INSP_CODE_TYPE Character(1) VARCHAR2(1) NOT NULL Inspection Code Type
1=Measurement
2=Observation
3=Calculation
2 INSP_CODE_SUBTYPE Character(2) VARCHAR2(2) NOT NULL Inspection Code Subtype
3 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name
4 XLATSHORTNAME Character(10) VARCHAR2(10) NOT NULL Translate Value Short Name