SSR_HE_PLNOFLVW

(SQL View)
 Index Back

Prompt for HESA Plan Offering

Prompt for displaying HESA Plan Offering fields

SELECT ID.INSTITUTION , ID.SSR_HE_FIELD ,ID.DESCR FROM PS_SSR_HE_INST_DAT ID , PS_SSR_HE_FIELDS F WHERE ID.SSR_HE_FIELD = F.SSR_HE_FIELD AND F.SSR_HE_ACTIVE = 'Y' AND ID.SSR_HE_PLN_OFFRFLG = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
2 SSR_HE_FIELD Character(20) VARCHAR2(20) NOT NULL Field
3 DESCR Character(30) VARCHAR2(30) NOT NULL Description