SSR_AM_IAMR2_VW

(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_RESULT WHERE PS_SSR_IAM_RESULT.SSR_ACTIVITY_ID = PS_SSR_ACTIVITY.SSR_ACTIVITY_ID AND PS_SSR_IAM_RESULT.INSTITUTION = PS_SSR_ACTIVITY.INSTITUTION AND PS_SSR_IAM_RESULT.SSR_IAM_RSLT_STAT <> '00')

  • 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_IAMRSLT_EXISTS Character(1) VARCHAR2(1) NOT NULL Grades Exists

    Y/N Table Edit

    Default Value: N