SCHOOL_CRSE_TBL

(SQL Table)
 Index Back

School Courses Tbl

Use SCHOOL_CRSE_TBL to categorize courses by EXT_CAREER, COURSE_LEVEL, and EXT_SUBJECT_AREA. The EXT_SUBJECT_AREA is defaulted to the EXT_SUBJECT_AREA of the SCHOOL_SUBJECT. However, this can be changed. For instance a specialized math course for economics majors may be offered by the economics department at a school. When setting up that course in the SCHOOL_CRSE_TBL the EXT_SUBJECT_AREA for the course will default in as economics but you may re-classify the course to mathematics as the EXT_SUBJECT_AREA.

  • Related Language Record: SCHOOL_CRSE_LNG

  • Parent record: SCHOOL_CRSE_HDR

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID

    Prompt Table: EXT_ORG_TBL

    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

    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

    Default Value: EXT_ORG_TBL_ADM.EXT_CAREER

    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