SSR_ACMSCTN_VW

(SQL View)
 Index Back

Activity Exam Extension

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

SELECT A.SSR_ACTIVITY_ID ,A.INSTITUTION ,A.SSR_PERIOD_ID ,S.SSR_ACTIVITY_ID ,A.SSR_CW_EXAM_TYPE ,A.SSR_CW_EXAM_DUR_H ,A.SSR_CW_EXAM_DUR_M ,M.SSR_ACM_SCTN_MTSEQ ,M.FACILITY_ID ,M.SSR_ACM_FACIL_STAT ,M.START_DT ,M.END_DT ,M.MEETING_TIME_START ,M.MEETING_TIME_END FROM PS_SSR_ACMEXAM_EXT A , PS_SSR_ACTIVITY S , PS_SSR_ACM_SCTNEXT SE , PS_SSR_ACM_SCTN_MT M WHERE S.SSR_ACTIVTY_ID_PAR = A.SSR_ACTIVITY_ID AND S.INSTITUTION = A.INSTITUTION AND SE.SSR_ACTIVITY_ID = S.SSR_ACTIVITY_ID AND SE.INSTITUTION = S.INSTITUTION AND M.SSR_ACTIVITY_ID = S.SSR_ACTIVITY_ID AND M.INSTITUTION = S.INSTITUTION

  • Parent record: SSR_ACTIVITY

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SSR_ACTIVITY_ID Character(11) VARCHAR2(11) NOT NULL Academic Activity ID
    2 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
    3 SSR_PERIOD_ID Character(12) VARCHAR2(12) NOT NULL Academic Period ID

    Prompt Table: SSR_AC_EXPRDEVW

    4 SSR_ACTY_ID_REL Character(11) VARCHAR2(11) NOT NULL Related Activity
    5 SSR_CW_EXAM_TYPE Character(12) VARCHAR2(12) NOT NULL Exam Type

    Prompt Table: SSR_EXAMTYP_TBL

    6 SSR_CW_EXAM_DUR_H Number(3,0) SMALLINT NOT NULL Exam Duration (hours : mins)
    7 SSR_CW_EXAM_DUR_M Number(2,0) SMALLINT NOT NULL Exam Duration (mins)
    8 SSR_ACM_SCTN_MTSEQ Number(3,0) SMALLINT NOT NULL Section Meeting Sequence
    9 FACILITY_ID Character(10) VARCHAR2(10) NOT NULL Facility ID
    10 SSR_ACM_FACIL_STAT Character(1) VARCHAR2(1) NOT NULL Facility Status
    3=Third Party
    F=Finalized/Scheduled
    P=Pending
    R=Requested
    11 START_DT Date(10) DATE Start Date
    12 END_DT Date(10) DATE end date
    13 MEETING_TIME_START Time(15) TIMESTAMP Meeting Start Time
    14 MEETING_TIME_END Time(15) TIMESTAMP Meeting End Time