SSR_IAMRTERULVW

(SQL View)
 Index Back

IAM Enrl Rule Inc View by Root

IAM Enrollment Rule Inclusion View by Root

SELECT A.EMPLID , A.INSTITUTION , A.SSR_ACT_ID_ROOT , A.SSR_ACTIVITY_ID , A.SSR_ACT_ID_SEQ_NBR , B.SSR_CW_RULE_ID FROM PS_SSR_IAM A , PS_SSR_ACMERUL_INC B WHERE A.INSTITUTION = B.INSTITUTION AND A.SSR_ACTIVITY_ID = B.SSR_ACTIVITY_ID

  • Parent record: SSR_IAM_ROOTVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
    3 SSR_ACT_ID_ROOT Character(11) VARCHAR2(11) NOT NULL Course Root Activity ID
    4 SSR_ACTIVITY_ID Character(11) VARCHAR2(11) NOT NULL Academic Activity ID
    5 SSR_ACT_ID_SEQ_NBR Number(4,0) SMALLINT NOT NULL Activity ID Sequence Number

    Default Value: 1

    6 SSR_CW_RULE_ID Character(10) VARCHAR2(10) NOT NULL Enrollment Rule ID