SSR_ACMEXAM_VW

(SQL View)
 Index Back

Activity Exam Extension

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

SELECT A.SSR_PERIOD_ID ,X.CRSE_ID ,X.CRSE_OFFER_NBR ,A.SSR_ACTIVITY_ID ,A.INSTITUTION ,A.SSR_CW_EXAM_TYPE ,A.SSR_CW_EXAM_DUR_H ,A.SSR_CW_EXAM_DUR_M FROM PS_SSR_ACMEXAM_EXT A , PS_SSR_ACT_XREF X WHERE X.SSR_ACTIVITY_ID = A.SSR_ACTIVITY_ID

  • Parent record: SSR_ACTIVITY

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

    Prompt Table: SSR_AC_EXPRDEVW

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

    Prompt Table: SSR_EXAMTYP_TBL

    7 SSR_CW_EXAM_DUR_H Number(3,0) SMALLINT NOT NULL Exam Duration (hours : mins)
    8 SSR_CW_EXAM_DUR_M Number(2,0) SMALLINT NOT NULL Exam Duration (mins)