SSR_HE_SUBJECVW

(SQL View)
Index Back

Acad Program - HESA Subject


SELECT SSR_HE_CODE ,DESCR FROM PS_SSR_HE_CODES WHERE SSR_HE_FIELD = 'SBJCA' AND SSR_HE_ACTIVE = 'Y' AND SSR_HE_CODE NOT BETWEEN '100000' AND '999999'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SSR_HE_CODE Character(30) VARCHAR2(30) NOT NULL Code
2 DESCR Character(30) VARCHAR2(30) NOT NULL Description