SSR_ACMEXINS2VW

(SQL View)
 Index Back

Activity Exam Extension

Extension Record for the Exam content item (Activity Manager).

SELECT E.EMPLID ,A.SSR_PERIOD_ID ,X.CRSE_ID ,X.CRSE_OFFER_NBR ,A.SSR_ACTIVITY_ID ,A.INSTITUTION ,S.SSR_ACTIVITY_ID ,A.SSR_CW_EXAM_TYPE ,X.STRM ,X.SESSION_CODE ,A.SSR_CW_EXAM_DUR_H ,A.SSR_CW_EXAM_DUR_M ,E.SSR_CW_EX_STF_TYPE ,E.SSR_AC_RSLT_CNTRL ,P.SSR_PRD_START_DT ,P.SSR_PRD_END_DT ,B.NAME_DISPLAY ,SE.SSR_PRD_SCTN_NBR ,SE.FACILITY_ID FROM PS_SSR_ACMEXAM_EXT A , PS_SSR_ACTIVITY S , PS_SSR_ACM_SCTNEXT SE , PS_SSR_ACM_MT_STF E , PS_SSR_ACT_XREF X , PS_SSR_PERIOD_TBL P , PS_SCC_PRFPRIMNMVW B WHERE S.SSR_ACTIVTY_ID_PAR = A.SSR_ACTIVITY_ID AND S.INSTITUTION = A.INSTITUTION AND SE.INSTITUTION = S.INSTITUTION AND SE.SSR_ACTIVITY_ID = S.SSR_ACTIVITY_ID AND E.SSR_ACTIVITY_ID = S.SSR_ACTIVITY_ID AND E.INSTITUTION = A.INSTITUTION AND X.SSR_ACTIVITY_ID = A.SSR_ACTIVITY_ID AND P.INSTITUTION = A.INSTITUTION AND P.SSR_PERIOD_ID = A.SSR_PERIOD_ID AND B.EMPLID = E.EMPLID

  • Parent record: SSR_ACTIVITY

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 SSR_PERIOD_ID Character(12) VARCHAR2(12) NOT NULL Academic Period ID

    Prompt Table: SSR_AC_EXPRDEVW

    3 CRSE_ID Character(6) VARCHAR2(6) NOT NULL Course ID
    4 CRSE_OFFER_NBR Number(2,0) SMALLINT NOT NULL Course Offering Nbr
    5 SSR_ACTIVITY_ID Character(11) VARCHAR2(11) NOT NULL Academic Activity ID
    6 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
    7 SSR_ACTY_ID_REL Character(11) VARCHAR2(11) NOT NULL Related Activity
    8 SSR_CW_EXAM_TYPE Character(12) VARCHAR2(12) NOT NULL Exam Type

    Prompt Table: SSR_EXAMTYP_TBL

    9 STRM Character(4) VARCHAR2(4) NOT NULL Term
    10 SESSION_CODE Character(3) VARCHAR2(3) NOT NULL Session
    1=Regular Academic Session
    10W=10 Week
    12W=Twelve Week
    4W1=Four Week - First
    4W2=Four Week - Second
    4W3=Four Week - Third
    4W4=Four Week - Fourth
    6W1=Six Week - First
    6W2=Six Week - Second
    8W1=Eight Week - First
    8W2=Eight Week - Second
    A11=Medical Period 1, 4 Weeks
    A12=Medical Period 1, 8 Weeks
    A13=Medical Pd 1, 12 Weeks
    A21=Medical Period 2, 4 Weeks
    A22=Medical Period 2, 8 Weeks
    A23=Medical Period 2, 12 Week
    FYR=Full Year
    MIN=Mini Session
    OEE=Open Entry/Open Exit
    SM1=Semester 1
    SM2=Semester 2
    11 SSR_CW_EXAM_DUR_H Number(3,0) SMALLINT NOT NULL Exam Duration (hours : mins)
    12 SSR_CW_EXAM_DUR_M Number(2,0) SMALLINT NOT NULL Exam Duration (mins)
    13 SSR_CW_EX_STF_TYPE Character(3) VARCHAR2(3) NOT NULL Staff Type
    CEX=Chief Examiner
    EXA=Examiner
    INV=Invigilator
    PRO=Proctor
    14 SSR_AC_RSLT_CNTRL Character(1) VARCHAR2(1) NOT NULL Result Access Control
    C=Calculate
    U=Grade Access
    V=View Only Access
    15 SSR_PRD_START_DT Date(10) DATE Campus Period Start Date
    16 SSR_PRD_END_DT Date(10) DATE Campus Period End Date
    17 NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Display Name - name formatted for Display based on the Country
    18 SSR_PRD_SCTN_NBR Number(6,0) INTEGER NOT NULL Period Section Number
    19 FACILITY_ID Character(10) VARCHAR2(10) NOT NULL Facility ID