SSR_HM_LOC_SRCH

(SQL View)
Index Back

HEIMS Campus Search

Search record for HEIMS Campus location component

SELECT INSTITUTION FROM PS_INSTITUTION_TBL INST WHERE INST.SCC_AUS_DEST = 'Y' AND %EffdtCheck(INSTITUTION_TBL I2,INST, %CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution