SSR_HE_DEGTYPVW

(SQL View)
 Index Back

Prompt for HESA Degree Type

Prompt record view to display LOV for HESA Degree Types

SELECT ssr_he_code ,descr FROM %Table(ssr_he_codes) WHERE ssr_he_field='DEGTYPE' AND ssr_he_active='Y'

# 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