SCHL_CRSE_TRVW

(SQL View)
Index Back

School Courses View

select a.EXT_ORG_ID , a.SCHOOL_SUBJECT , a.SCHOOL_CRSE_NBR , a.EFFDT , a.EFF_STATUS , a.EXT_SUBJECT_AREA , a.EXT_CAREER , a.EXT_CRSE_TYPE , a.COURSE_LEVEL , a.DESCR , a.DESCRSHORT , a.EXT_UNITS from PS_SCHOOL_CRSE_TBL a

select a.EXT_ORG_ID , a.SCHOOL_SUBJECT , a.SCHOOL_CRSE_NBR , a.EFFDT , a.EFF_STATUS , a.EXT_SUBJECT_AREA , a.EXT_CAREER , a.EXT_CRSE_TYPE , a.COURSE_LEVEL , a.DESCR , a.DESCRSHORT , a.EXT_UNITS from PS_SCHOOL_CRSE_TBL a

  • Related Language Record: SCHL_CRSE_TRVLN
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CATALOG_ORG Character(11) VARCHAR2(11) NOT NULL Catalog Organization
    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
    4 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    5 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    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 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

    Default Value: SCHOOL_CRSE_TBL.DESCR

    12 EXT_UNITS Number(6,2) DECIMAL(5,2) NOT NULL External Units