SAD_UC_QUALCDVW

(SQL View)
Index Back

HESA Code View


SELECT %Substring(SSR_HE_CODE,1,3 ) ,DESCR ,SSR_HE_DESCR254 FROM PS_SSR_HE_CODES WHERE SSR_HE_FIELD ='QUALENT3' AND SSR_HE_ACTIVE ='Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SAD_UC_EXP_QUAL3 Character(3) VARCHAR2(3) NOT NULL Expected Qual Code
2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
3 SSR_HE_DESCR254 Character(254) VARCHAR2(254) NOT NULL Long Description