CRSE_CAT_R3_VW

(SQL View)
 Index Back

Course Catalog Rqmnt View

This view is used to pull data for courses to be displayed in academic advisement. It has been adjusted to handle courses that no longer have an active catalog record available in the CRSE_CATALOG table.

SELECT B.INSTITUTION ,B.SUBJECT ,B.CATALOG_NBR ,A.CRSE_ID ,A.DESCR ,A.EQUIV_CRSE_ID ,A.EFFDT ,A.CONSENT ,A.ALLOW_MULT_ENROLL ,A.UNITS_MINIMUM ,A.UNITS_MAXIMUM ,A.UNITS_ACAD_PROG ,A.CRSE_REPEATABLE ,A.UNITS_REPEAT_LIMIT ,A.CRSE_REPEAT_LIMIT ,A.GRADING_BASIS ,A.GRADE_ROSTER_PRINT ,A.COURSE_TITLE_LONG ,A.LST_MULT_TRM_CRS ,A.SSR_COMPONENT ,B.ACAD_ORG ,B.COURSE_APPROVED ,B.ACAD_GROUP FROM PS_CRSE_CATALOG A , PS_CRSE_OFFER B WHERE A.CRSE_ID = B.CRSE_ID AND A.EFFDT = B.EFFDT AND A.EFFDT = ( SELECT MAX(D.EFFDT) FROM PS_CRSE_CATALOG D WHERE D.CRSE_ID = A.CRSE_ID AND D.EFF_STATUS = 'A')

  • Related Language Record: CRSE_CATR3_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Default Value: OPR_DEF_TBL_CS.INSTITUTION

    Prompt Table: INSTITUTION_TBL

    2 SUBJECT_SRCH Character(8) VARCHAR2(8) NOT NULL Subject Area

    Prompt Table: SUBJECT_TBL

    3 CATALOG_NBR_SRCH Character(10) VARCHAR2(10) NOT NULL Catalog Nbr

    Prompt Table: CRSE_CATNP_SRCH

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

    Prompt Table: CRSE_EQUIV_TBL

    7 DATE1 Date(10) DATE Date 1
    8 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

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

    14 UNITS_REPEAT_LIMIT Number(6,2) DECIMAL(5,2) NOT NULL Total Units Allowed
    15 CRSE_REPEAT_LIMIT Number(2,0) SMALLINT NOT NULL Total Completions Allowed

    Default Value: 1

    16 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: OPT

    17 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

    18 COURSE_TITLE_LONG Character(100) VARCHAR2(100) NOT NULL Long Course Title
    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 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
    21 ACAD_ORG Character(10) VARCHAR2(10) NOT NULL Academic Organization
    22 COURSE_APPROVED Character(1) VARCHAR2(1) NOT NULL Course Approved
    A=Approved
    D=Denied
    P=Pending
    23 ACAD_GROUP Character(5) VARCHAR2(5) NOT NULL Academic Group