SSR_IAM_ANON2VW

(SQL View)
 Index Back

IAM Anonymous ID View

IAM Anonymous ID View

SELECT A.EMPLID , A.INSTITUTION , A.SSR_ACT_ID_ROOT , A.SSR_ACTIVITY_ID , A.SSR_ACT_ID_SEQ_NBR , B.SSR_ANONYMOUS_ID , B.SSR_ANID_SEQ_NBR , A.SSR_IAM_ACTIVE_FLG , A.SSR_IAM_ATTMPT_FLG , A.SSR_SEQ_NBR7 , A.SSR_ACO_TREE_LVL , A.SSR_ACTIVTY_ID_PAR , A.SSR_ACT_PAR_SQ_NBR , A.SSR_ACTIVTY_ID_ORG , A.SSR_ACT_ORG_SQ_NBR , A.SSR_IAM_ACTID_RSIT , A.SSR_IAM_ACT_STATUS , A.SSR_BLIND_GRADED , B.SCC_ROW_ADD_OPRID , B.SCC_ROW_ADD_DTTM , B.SCC_ROW_UPD_OPRID , B.SCC_ROW_UPD_DTTM FROM PS_SSR_IAM_ANON1VW A LEFT OUTER JOIN PS_SSR_ANONMAXSQVW B ON A.EMPLID = B.EMPLID AND ((A.SSR_ACT_ORG_SQ_NBR = 1 AND A.SSR_ACT_ID_ROOT = B.SSR_ACTIVITY_ID AND A.SSR_ACT_ID_SEQ_NBR = B.SSR_ACT_ID_SEQ_NBR) OR (A.SSR_ACT_ORG_SQ_NBR > 1 AND A.SSR_ACTIVITY_ID = B.SSR_ACTIVITY_ID AND A.SSR_ACT_ID_SEQ_NBR = B.SSR_ACT_ID_SEQ_NBR)) AND A.SSR_BLIND_GRADED = 'Y' AND A.SSR_IAM_ACT_STATUS <> ' '

  • Parent record: SSR_IAMRTEXTNVW

    • # 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_ANONYMOUS_ID Number(10,0) DECIMAL(10) NOT NULL Anonymous ID
    7 SSR_ANID_SEQ_NBR Number(3,0) SMALLINT NOT NULL Anonymous ID Sequence Number
    8 SSR_IAM_ACTIVE_FLG Character(1) VARCHAR2(1) NOT NULL Active Flag

    Y/N Table Edit

    Default Value: Y

    9 SSR_IAM_ATTMPT_FLG Character(1) VARCHAR2(1) NOT NULL Valid Attempt

    Y/N Table Edit

    Default Value: Y

    10 SSR_SEQ_NBR7 Number(7,0) INTEGER NOT NULL Sequence Number
    11 SSR_ACO_TREE_LVL Number(3,0) SMALLINT NOT NULL Level 1 Row
    12 SSR_ACTIVTY_ID_PAR Character(11) VARCHAR2(11) NOT NULL Parent Activity ID
    13 SSR_ACT_PAR_SQ_NBR Number(4,0) SMALLINT NOT NULL Parent Activity ID Seq NBR

    Default Value: 1

    14 SSR_ACTIVTY_ID_ORG Character(11) VARCHAR2(11) NOT NULL Original Parent Activity ID
    15 SSR_ACT_ORG_SQ_NBR Number(4,0) SMALLINT NOT NULL Original Activity ID Seq NBR

    Default Value: 1

    16 SSR_IAM_ACTID_RSIT Character(11) VARCHAR2(11) NOT NULL Resit Activity
    17 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
    18 SSR_BLIND_GRADED Character(1) VARCHAR2(1) NOT NULL This field indicates if blind grading is active
    N=Do not Use
    Y=Override Display Values
    19 SCC_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Created By
    20 SCC_ROW_ADD_DTTM DateTime(26) TIMESTAMP Created
    21 SCC_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Updated By
    22 SCC_ROW_UPD_DTTM DateTime(26) TIMESTAMP Last Update Date/Time