CAT_CRSE_VW

(SQL View)
 Index Back

Catalog Org Course Prompt Tbl


SELECT DISTINCT A.CATALOG_ORG , B.SCHOOL_SUBJECT , B.SCHOOL_CRSE_NBR , B.EFFDT , B.EFF_STATUS , B.EXT_SUBJECT_AREA , B.EXT_CAREER , B.EXT_CRSE_TYPE , B.COURSE_LEVEL , B.DESCR , B.EXT_UNITS FROM PS_EXT_ORG_TBL_ADM A , PS_SCHOOL_CRSE_TBL B WHERE A.CATALOG_ORG = B.EXT_ORG_ID AND B.EFFDT = ( SELECT MAX(B1.EFFDT) FROM PS_SCHOOL_CRSE_TBL B1 WHERE B1.EXT_ORG_ID=B.EXT_ORG_ID AND B1.SCHOOL_SUBJECT=B.SCHOOL_SUBJECT AND B1.SCHOOL_CRSE_NBR=B.SCHOOL_CRSE_NBR AND B1.EFFDT<=%CurrentDateIn) AND B.EFF_STATUS = 'A'

  • Related Language Record: CAT_CRSE_VW_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CATALOG_ORG Character(11) VARCHAR2(11) NOT NULL Catalog Organization

    Prompt Table: CATALOG_ORG_VW

    2 SCHOOL_SUBJECT Character(8) VARCHAR2(8) NOT NULL School Subject

    Prompt Table: SCHOOL_SUBJ_HDR

    3 SCHOOL_CRSE_NBR Character(10) VARCHAR2(10) NOT NULL School Course Nbr

    Prompt Table: SCHOOL_CRSE_HDR

    4 EFFDT Date(10) DATE NOT NULL Effective Date
    5 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive
    6 EXT_SUBJECT_AREA Character(4) VARCHAR2(4) NOT NULL External Subject Area

    Default Value: SCHOOL_SUBJ_TBL.EXT_SUBJECT_AREA

    Prompt Table: EXT_SUBJECT_TBL

    7 EXT_CAREER Character(4) VARCHAR2(4) NOT NULL External Career
    GRAD=Graduate
    HS=High School
    LAW=Law
    MED=Medical
    UGRD=Undergraduate
    8 EXT_CRSE_TYPE Character(3) VARCHAR2(3) NOT NULL External Course Type
    C=Challenge
    CRS=Course
    E=Equivalency
    EVT=Event or Summary
    N/A=Course - Not Applicable
    REP=Course - Repeated
    WTH=Course - Withdrawn
    9 COURSE_LEVEL Character(2) VARCHAR2(2) NOT NULL Course Level
    11=Grade 11
    12=Grade 12
    AP=Advanced Placement
    DR=Graduate/Doctoral
    FR=Freshman
    GR=Graduate
    HN=Honors
    IB=International Baccalaureate
    JR=Junior
    LD=Lower Division
    MS=Graduate/Master
    RG=Regular
    SO=Sophomore
    SR=Senior
    UD=Upper Division
    10 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    11 EXT_UNITS Number(6,2) DECIMAL(5,2) NOT NULL External Units