SSR_HE_INS_VW

(SQL View)
Index Back

Instance Fields View

View to display the Instance Prompt

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_INSTANC_FLG = 'Y' AND F.SSR_HE_SEPARATE IN ('INS','ENP')

# 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