SSR_ACMEXMPR_VW

(SQL View)
 Index Back

Activity Exam Extension

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

SELECT E.INSTITUTION ,E.SSR_ACTIVITY_ID ,E.SSR_PERIOD_ID ,P.SSR_PRD_START_DT FROM PS_SSR_ACMEXAM_EXT E , PS_SSR_PERIOD_TBL P WHERE P.INSTITUTION = E.INSTITUTION AND P.SSR_PERIOD_ID = E.SSR_PERIOD_ID

  • Parent record: SSR_ACTIVITY

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

    Prompt Table: SSR_AC_EXPRDEVW

    4 SSR_PRD_START_DT Date(10) DATE Campus Period Start Date