SSR_IAMNORSLTVW

(SQL View)
 Index Back

IAM Result View


SELECT A.INSTITUTION , A.EMPLID , A.SSR_ACTIVITY_ID FROM PS_SSR_IAM_ROOTEXT A WHERE A.SSR_ACTIVITY_ID NOT IN ( SELECT AA.SSR_ACT_ID_ROOT FROM PS_SSR_IAM_RES_VW AA , PS_INSTITUTION_TBL B WHERE AA.INSTITUTION = A.INSTITUTION AND AA.EMPLID = A.EMPLID AND AA.SSR_ACT_ID_ROOT = A.SSR_ACTIVITY_ID AND AA.SSR_IAM_RSLT_STAT > '00' AND B.INSTITUTION = AA.INSTITUTION AND B.SSR_RSLT_TYPE = AA.SSR_RSLT_TYPE AND B.EFFDT = ( SELECT MAX(EFFDT) FROM PS_INSTITUTION_TBL BB WHERE B.INSTITUTION = BB.INSTITUTION AND EFFDT <= %CurrentDateIn))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
3 SSR_ACTIVITY_ID Character(11) VARCHAR2(11) NOT NULL Academic Activity ID