SSR_CRSE_TYP_VW

(SQL View)
 Index Back

Course Typically Offered

This vew joins the Course Catalog, the Course Offering and the Typically Offered tables.

SELECT a.CRSE_ID , b.CRSE_OFFER_NBR , a.EFFDT , a.EFF_STATUS , a.DESCR , b.INSTITUTION , b.SUBJECT , b.CATALOG_NBR , b.ACAD_CAREER , a.UNITS_MINIMUM , a.UNITS_MAXIMUM , b.SSR_CRSE_TYPOFF_CD , c.DESCR FROM PS_CRSE_CATALOG a , PS_CRSE_OFFER b , PS_SSR_CRSE_TYPOFF c WHERE a.CRSE_ID = b.CRSE_ID AND a.EFFDT = b.EFFDT AND b.INSTITUTION = c.INSTITUTION AND b.SSR_CRSE_TYPOFF_CD = c.SSR_CRSE_TYPOFF_CD AND c.EFFDT = ( SELECT MAX(c1.EFFDT) FROM PS_SSR_CRSE_TYPOFF c1 WHERE c1.INSTITUTION=c.INSTITUTION AND c1.SSR_CRSE_TYPOFF_CD=c.SSR_CRSE_TYPOFF_CD AND c1.EFFDT <= a.EFFDT) AND c.EFF_STATUS='A'

  • Related Language Record: CRSE_OFF_TCV_LN

    • # 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 CRSE_OFFER_NBR Number(2,0) SMALLINT NOT NULL Course Offering Nbr
    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Default Value: OPR_DEF_TBL_CS.INSTITUTION

    Prompt Table: INSTITUTION_TBL

    7 SUBJECT Character(8) VARCHAR2(8) NOT NULL Subject Area

    Default Value: OPR_DEF_TBL_CS.SUBJECT

    Prompt Table: SUBJECT_TBL

    8 CATALOG_NBR Character(10) VARCHAR2(10) NOT NULL Catalog Nbr
    9 ACAD_CAREER Character(4) VARCHAR2(4) NOT NULL Academic Career
    BAC=Bachelor (NLD)
    BBL=Vocational Coaching (NLD)
    BOL=Vocational Training (NLD)
    BUSN=Graduate Business
    CNED=Continuing Education
    CRED=Semester Credit
    EDU=Education (NLD)
    EXED=Extended Education
    GRAD=Graduate
    LAW=Law
    MEDS=Medical School
    NONA=Non Award
    PGRD=Postgraduate
    RSCH=Research
    TECH=Technical
    UENG=Undergraduate Engineering
    UGRD=Undergraduate
    VAVO=Advanced General Educ. (NLD)
    VETM=Veterinary Medicine

    Prompt Table: CATLG_CAR_TBL

    10 UNITS_MINIMUM Number(6,2) DECIMAL(5,2) NOT NULL Minimum Units
    11 UNITS_MAXIMUM Number(6,2) DECIMAL(5,2) NOT NULL Maximum Units
    12 SSR_CRSE_TYPOFF_CD Character(10) VARCHAR2(10) NOT NULL Course Typically Offered

    Prompt Table: SSR_CRSE_TYPOFF

    13 SSR_TYP_OFFERED Character(30) VARCHAR2(30) NOT NULL Typically Offered