SSR_RSLT_ITM2VW

(SQL View)
 Index Back

Result Item View


SELECT DISTINCT a.SSR_RSLT_TYPE , b.INSTITUTION , b.SSR_RES_MAP_ID , b.DEFAULT_FLAG FROM PS_SSR_RSLT_TBL a , PS_SSR_RSLT_INST b , PS_SSR_RSLT_ITMTYP c WHERE a.SSR_VAL_FIELDTYPE = '80' AND a.EFFDT = ( SELECT MAX(a2.EFFDT) FROM PS_SSR_RSLT_TBL a2 WHERE a2.SSR_RSLT_TYPE = a.SSR_RSLT_TYPE AND a2.EFFDT <= %CurrentDateIn) AND a.EFF_STATUS = 'A' AND b.SSR_RSLT_TYPE = a.SSR_RSLT_TYPE AND b.EFFDT = a.EFFDT AND c.SSR_RSLT_TYPE = a.SSR_RSLT_TYPE AND c.EFFDT = a.EFFDT AND c.SSR_ITEM_TYPE = 'COURSE'

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

Prompt Table: INSTITUTION_TBL

3 SSR_RES_MAP_ID Character(12) VARCHAR2(12) NOT NULL Result Scale
4 DEFAULT_FLAG Character(1) VARCHAR2(1) NOT NULL Set As Default