SSR_CRSTOPIC_V3

(SQL View)
Index Back

Course Topics View

This Course Topics Table view is used to issue a warning if a class section of a multi-topic course is scheduled with no Course Topic ID in either the Class Table or at least one of its Class Meeting Patterns.

SELECT crse_id ,effdt ,crs_topic_id ,descr ,descrshort ,descrformal FROM PS_CRSE_TOPICS

  • Related Language Record: SSRCRSTOPICV3LN
  • Parent record: CRSE_CATALOG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CRSE_ID Character(6) VARCHAR2(6) NOT NULL Course ID

    Prompt Table: CRSE_CATALOG

    2 EFFDT Date(10) DATE Effective Date
    3 CRS_TOPIC_ID Number(3,0) SMALLINT NOT NULL Course Topic ID
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    6 DESCRFORMAL Character(50) VARCHAR2(50) NOT NULL Formal Description field