SSR_IAM_BLACTVW

(SQL View)
 Index Back

Activity Block View

Activity Block View

SELECT DISTINCT A.INSTITUTION , A.EMPLID , A.SSR_ACT_ID_ROOT , A.SSR_ACTIVITY_ID , A.SSR_ACT_ID_SEQ_NBR , A.SSR_IAM_ACT_STATUS , C.SSR_IAM_ACT_BLK_ID , C.SSR_SELECT , C.SSR_REMOVE , C.SSR_CONFIRM , B.SSR_IAM_STD_BLK_ID FROM PS_SSR_IAM A , PS_SSR_IAM_STBLKID B , PS_SSR_IAM_ACTBLK2 C WHERE B.INSTITUTION = A.INSTITUTION AND B.EMPLID = A.EMPLID AND C.SSR_ACT_ID_ROOT = A.SSR_ACT_ID_ROOT AND C.SSR_ACTIVITY_ID = A.SSR_ACTIVITY_ID AND (C.SSR_SELECT = 'Y' OR C.SSR_REMOVE = 'Y' OR C.SSR_CONFIRM = 'Y')

  • Parent record: SSR_IAM_ACTBLK1

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
    2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    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

    Prompt Table: SSR_ACM_SCTY

    5 SSR_ACT_ID_SEQ_NBR Number(4,0) SMALLINT NOT NULL Activity ID Sequence Number
    6 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
    7 SSR_IAM_ACT_BLK_ID Character(20) VARCHAR2(20) NOT NULL Activity Block ID
    8 SSR_SELECT Character(1) VARCHAR2(1) NOT NULL Select

    Y/N Table Edit

    9 SSR_REMOVE Character(1) VARCHAR2(1) NOT NULL Removed

    Y/N Table Edit

    10 SSR_CONFIRM Character(1) VARCHAR2(1) NOT NULL Confirmed

    Y/N Table Edit

    11 SSR_IAM_STD_BLK_ID Character(20) VARCHAR2(20) NOT NULL Student Block ID