SSR_AM_IAMVW

(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)

  • Parent record: SSR_IAM_ROOTEXT

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SSR_ACTIVITY_ID 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