SSR_ACMEXSC_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 ,AC.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 , PS_SSR_ACTIVITY AC , PS_SSR_ACM_SCTNEXT SC WHERE X.SSR_ACTIVITY_ID = A.SSR_ACTIVITY_ID AND AC.SSR_ACTIVTY_ID_PAR = A.SSR_ACTIVITY_ID AND SC.SSR_ACTIVITY_ID = AC.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_ACT_ID_ROOT Character(11) VARCHAR2(11) NOT NULL Course Root Activity ID
    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_CW_EXAM_TYPE Character(12) VARCHAR2(12) NOT NULL Exam Type

    Prompt Table: SSR_EXAMTYP_TBL

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