CRSE_CATALOG

(SQL Table)
Index Back

Course Catalog Data

The Course Catalog Table contains course data that is printed in the academic institution's course catalog. One row exists in this table for each course the institution offers.

  • Related Language Record: CRSE_CATLG_LNG
  • Parent Record Of ATTEND_TYPE_LVW ATTEND_TYPE_VW ATTEND_TYPSBLVW ATTND_TYP_SUBVW CRSETOPICSVW2LN CRSETOPICSVWLNG CRSE_ATTENDANCE CRSE_ATTRIBUTES CRSE_COMPONENT CRSE_COMP_VW CRSE_COMP_VW2 CRSE_COMP_VW3 CRSE_OFFER CRSE_TOPICS CRSE_TOPICS_LNG CRSE_TOPICS_VW CRSE_TOPICS_VW2 SSRCRSTOPICV3LN SSR_ACMCRSEOFVW SSR_AC_CRSEOFVW SSR_AC_OFFR_VW SSR_AC_TOP_SVW SSR_COMPONENTVW SSR_CRSE_OFR_VW SSR_CRSTOPIC_V3 SSR_CRS_OFFR_E2 SSR_CRS_OFFR_ES SSR_CRS_OFFR_V2 SSR_CRS_OFFR_VW SSR_CRS_OFR_AUS SSR_SRCH_TOP SSR_SRCH_TOP_LN
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CRSE_ID Character(6) VARCHAR2(6) NOT NULL Course ID
    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

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

    Default Value: A

    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 EQUIV_CRSE_ID Character(5) VARCHAR2(5) NOT NULL Equivalent Course Group

    Prompt Table: CRSE_EQUIV_TBL

    6 CONSENT Character(1) VARCHAR2(1) NOT NULL Used by Course Catalog, Class Table, and Class Permissions.
    D=Department Consent Required
    I=Instructor Consent Required
    N=No Special Consent Required

    Default Value: N

    7 ALLOW_MULT_ENROLL Character(1) VARCHAR2(1) NOT NULL Allow Multiple Enroll in Term

    Y/N Table Edit

    Default Value: N

    8 UNITS_MINIMUM Number(6,2) DECIMAL(5,2) NOT NULL Minimum Units
    9 UNITS_MAXIMUM Number(6,2) DECIMAL(5,2) NOT NULL Maximum Units
    10 UNITS_ACAD_PROG Number(6,2) DECIMAL(5,2) NOT NULL Academic Progress Units
    11 UNITS_FINAID_PROG Number(6,2) DECIMAL(5,2) NOT NULL Financial Aid Progress Units
    12 CRSE_REPEATABLE Character(1) VARCHAR2(1) NOT NULL Repeat for Credit

    Y/N Table Edit

    Default Value: N

    13 UNITS_REPEAT_LIMIT Number(6,2) DECIMAL(5,2) NOT NULL Total Units Allowed

    Default Value: CRSE_CATALOG.UNITS_MAXIMUM

    14 CRSE_REPEAT_LIMIT Number(2,0) SMALLINT NOT NULL Total Completions Allowed

    Default Value: 1

    15 GRADING_BASIS Character(3) VARCHAR2(3) NOT NULL Grading Basis
    ANC=ABC/NC Grading
    AUD=Audit
    BMT=Multi-Term Course: Not Graded
    CNC=Credit / No Credit
    EQV=Equivalent
    GRD=Graded
    HSC=Hundred Point Scale (NLD)
    LAW=Law
    MED=Medical School Grades
    NOG=No Grade Associated
    NON=Non-Graded Component
    NQF=NQF Scale
    OPT=Student Option
    PNP=Pass/Not Pass
    SUS=Satisfactory/Unsatisfactory
    TRN=Transfer Grading Basis
    TSC=Ten Point Scale (NLD)

    Default Value: GRD

    16 GRADE_ROSTER_PRINT Character(1) VARCHAR2(1) NOT NULL Grade Roster Print
    C=Component
    I=By Instructor
    N=None
    S=By Student

    Default Value: C

    17 SSR_COMPONENT Character(3) VARCHAR2(3) NOT NULL Course Component.
    CLN=Clinical
    CON=Continuance
    DIS=Discussion
    FLD=Field Studies
    IND=Independent Study
    LAB=Laboratory
    LEC=Lecture
    PRA=Practicum
    RSC=Research
    SEM=Seminar
    SUP=Supervision
    THE=Thesis Research
    TUT=Tutorial
    18 COURSE_TITLE_LONG Character(100) VARCHAR2(100) NOT NULL Long Course Title

    Default Value: CRSE_CATALOG.DESCR

    19 LST_MULT_TRM_CRS Character(1) VARCHAR2(1) NOT NULL Last Course of Mult Term Seq

    Y/N Table Edit

    Default Value: N

    20 CRSE_CONTACT_HRS Number(6,2) DECIMAL(5,2) NOT NULL Course Contact Hours
    21 RQMNT_DESIGNTN Character(4) VARCHAR2(4) NOT NULL This field is used to track the Requirement Designation attached to a course in Student Records. This field is also used for tracking information through Academic Advisement.

    Prompt Table: RQMNT_DESIG_TBL

    22 CRSE_COUNT Number(5,2) DECIMAL(4,2) NOT NULL Course Count

    Default Value: 1

    23 INSTRUCTOR_EDIT Character(2) VARCHAR2(2) NOT NULL Instructor Edit
    C=Class Instructor Table Edit
    I=Instructor/Advisor Table Edit
    N=No Enrollment Choice

    Default Value: N

    24 FEES_EXIST Character(1) VARCHAR2(1) NOT NULL Fees Exist Flag

    Y/N Table Edit

    Default Value: N

    25 COMPONENT_PRIMARY Character(3) VARCHAR2(3) NOT NULL Primary Component

    Prompt Table: XLAT_SA_VW

    26 ENRL_UN_LD_CLC_TYP Character(1) VARCHAR2(1) NOT NULL Enrollment Unit Load Calc Type
    1=Actual Units
    2=Academic Progress Units

    Default Value: 1

    27 SSR_DROP_CONSENT Character(1) VARCHAR2(1) NOT NULL Used by Course Catalog, Class Table, and Class Permissions.
    D=Department Consent Required
    I=Instructor Consent Required
    N=No Special Consent Required

    Default Value: N

    28 DESCRLONG Long Character CLOB Long Description
    29 SCC_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Created By
    30 SCC_ROW_ADD_DTTM DateTime(26) TIMESTAMP Created
    31 SCC_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Updated By
    32 SCC_ROW_UPD_DTTM DateTime(26) TIMESTAMP Last Update Date/Time