CRSE_OFFER_TCVW

(SQL View)
 Index Back

Course Catalog Offerings View

This vew joins the Course Catalog and the Course Offering tables. It is used in the Transfer Credit panel.

SELECT a.CRSE_ID , b.CRSE_OFFER_NBR , a.EFFDT , a.EFF_STATUS , a.DESCR , b.INSTITUTION , b.SUBJECT , b.CATALOG_NBR , b.SUBJECT %Concat ' ' %Concat b.CATALOG_NBR , b.ACAD_CAREER , a.UNITS_MINIMUM , a.UNITS_MAXIMUM , b.SSR_CRSE_TYPOFF_CD , b.RQRMNT_GROUP , b.CAMPUS , b.ACAD_ORG FROM PS_CRSE_CATALOG a , PS_CRSE_OFFER b WHERE a.CRSE_ID = b.CRSE_ID AND a.EFFDT = b.EFFDT

  • 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 SSS_SUBJ_CATLG Character(20) VARCHAR2(20) NOT NULL Subject / Catalog
    10 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

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

    Prompt Table: SSR_CRSE_TYPOFF

    14 RQRMNT_GROUP Character(6) VARCHAR2(6) NOT NULL Requirement Group
    15 CAMPUS Character(5) VARCHAR2(5) NOT NULL Campus
    16 ACAD_ORG Character(10) VARCHAR2(10) NOT NULL Academic Organization