SSR_AM_IAMEN2VW

(SQL View)
 Index Back

IAM Data

IAM Data

SELECT SSR_ACTIVITY_ID ,INSTITUTION ,'Y' FROM PS_SSR_ACTIVITY WHERE EXISTS ( SELECT 'X' FROM PS_SSR_IAM WHERE PS_SSR_IAM.SSR_ACTIVITY_ID = PS_SSR_ACTIVITY.SSR_ACTIVITY_ID AND PS_SSR_IAM.INSTITUTION = PS_SSR_ACTIVITY.INSTITUTION AND PS_SSR_IAM.SSR_IAM_ACT_STATUS IN ('E','EC','ED','EE','EX','A','AC','AX','RA','RC'))

  • Parent record: SSR_IAM_ROOTEXT

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SSR_ACTY_ID_SRCH Character(11) VARCHAR2(11) NOT NULL Academic Activity ID
    2 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
    3 SSR_IAM_EXISTS Character(1) VARCHAR2(1) NOT NULL Enrollments Exist

    Y/N Table Edit

    Default Value: N