SSR_IAMRSLT_VW

(SQL View)
 Index Back

IAM View with Result Flag

IAM View with Result Flag

SELECT A.EMPLID , A.INSTITUTION , A.SSR_ACTIVITY_ID , A.SSR_ACT_ID_SEQ_NBR , A.SSR_SEQ_NBR7 , A.SSR_ACO_TREE_LVL , A.SSR_ACTIVTY_ID_PAR , A.SSR_IAM_ACT_STATUS , A.SSR_ACT_ID_ROOT , X.SSR_IAM_RSLT_STAT , B.SSR_CW_REQUIRED FROM PS_SSR_IAM A LEFT OUTER JOIN PS_SSR_IAM_RESULT X ON A.EMPLID = X.EMPLID AND A.INSTITUTION = X.INSTITUTION AND A.SSR_ACTIVITY_ID = X.SSR_ACTIVITY_ID AND A.SSR_ACT_ID_SEQ_NBR = X.SSR_ACT_ID_SEQ_NBR AND X.SSR_RSLT_SEQ = 1 , PS_SSR_ACMMAIN_INC B WHERE B.SSR_ACTIVITY_ID = A.SSR_ACTIVITY_ID AND B.INSTITUTION = A.INSTITUTION

  • Parent record: SSR_IAM_ROOTEXT

    • # 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_ACTIVITY_ID Character(11) VARCHAR2(11) NOT NULL Academic Activity ID
    4 SSR_ACT_ID_SEQ_NBR Number(4,0) SMALLINT NOT NULL Activity ID Sequence Number

    Default Value: 1

    5 SSR_SEQ_NBR7 Number(7,0) INTEGER NOT NULL Sequence Number
    6 SSR_ACO_TREE_LVL Number(3,0) SMALLINT NOT NULL Level 1 Row
    7 SSR_ACTIVTY_ID_PAR Character(11) VARCHAR2(11) NOT NULL Parent Activity ID
    8 SSR_IAM_ACT_STATUS Character(2) VARCHAR2(2) NOT NULL Activity Status
    A=Assigned
    AC=Assigned - confirmed
    AX=Assigned - requires confirmtn
    D=Dropped
    E=Enrolled
    EC=Enrolled - Confirmed
    ED=Enrolled by Default
    EE=Enrolled
    EX=Enrolled - Confirmation Req'd
    RA=Resit Allowed
    RC=Resit Candidate
    RD=Resit Delete
    RN=Resit Not Allowed
    RR=Reassessed
    RS=Resit Select
    S=Selected
    SC=Selected - confirmed
    SD=Selected by Default
    SR=Selected as Resit
    SX=Selected - requires confirmatn
    WD=Withdrawn
    WL=Waitlisted
    X=Inactive
    9 SSR_ACT_ID_ROOT Character(11) VARCHAR2(11) NOT NULL Course Root Activity ID
    10 SSR_IAM_RSLT_STAT Character(2) VARCHAR2(2) NOT NULL Result Status
    00=00-Undetermined
    05=05-Manual
    07=07-Imported
    10=10-Calculated
    20=20-Awaiting Approval
    30=30-Approved
    40=40-Overridden
    50=50-Final
    11 SSR_CW_REQUIRED Character(1) VARCHAR2(1) NOT NULL Mandatory