SSR_HE_SBPLFLVW

(SQL View)
 Index Back

Prompt for HESA SubPlan 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_SPLAN_FLAG = 'Y' AND F.SSR_HE_SEPARATE = 'OTH'

# 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