SSR_ACMEX_INSVW

(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 ,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 SSR_CW_EXAM_DUR_H Number(3,0) SMALLINT NOT NULL Exam Duration (hours : mins)
    10 SSR_CW_EXAM_DUR_M Number(2,0) SMALLINT NOT NULL Exam Duration (mins)
    11 SSR_CW_EX_STF_TYPE Character(3) VARCHAR2(3) NOT NULL Staff Type
    CEX=Chief Examiner
    EXA=Examiner
    INV=Invigilator
    PRO=Proctor
    12 SSR_AC_RSLT_CNTRL Character(1) VARCHAR2(1) NOT NULL Result Access Control
    C=Calculate
    U=Grade Access
    V=View Only Access
    13 SSR_PRD_START_DT Date(10) DATE Campus Period Start Date
    14 SSR_PRD_END_DT Date(10) DATE Campus Period End Date
    15 NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Display Name - name formatted for Display based on the Country
    16 SSR_PRD_SCTN_NBR Number(6,0) INTEGER NOT NULL Period Section Number
    17 FACILITY_ID Character(10) VARCHAR2(10) NOT NULL Facility ID