SSR_AC_OFFR_VW

(SQL View)
 Index Back

Course Catalog Offering Search

The Course Catalog Offerings search view lists valid Course Offering Numbers for a specified Course (CRSE_ID_SRCH)..

SELECT CRSE_ID , EFFDT , CRSE_OFFER_NBR FROM PS_CRSE_OFFER

  • Parent record: CRSE_CATALOG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CRSE_ID_SRCH Character(6) VARCHAR2(6) NOT NULL Course ID
    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 SSR_AC_CRSE_OFF Number(2,0) SMALLINT NOT NULL Course Offering Nbr