UN_INST_TBL2

(SQL View)
Index Back

Prompt for SSR_UGRD_INST_CD

Prompt table for SSR_UGRD_INST_CD

SELECT A.SSR_UGRD_INST_CD , A.DESCR , A.DESCRSHORT FROM PS_SSR_INST_DEST A WHERE A.EFFDT = ( SELECT MAX(A_ED.EFFDT) FROM PS_SSR_INST_DEST A_ED WHERE A.SSR_UGRD_INST_CD =A_ED.SSR_UGRD_INST_CD AND A_ED.EFFDT <= %CurrentDateIn) AND A.HEIMS_HEP_CODE = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SSR_UGRD_INST_CD Character(4) VARCHAR2(4) NOT NULL Undergraduate Institution Code
2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
3 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description