CRSE_CAT_R1_VW

(SQL View)
 Index Back

Course Catalog Rqmnt View


SELECT A.CRSE_ID ,A.DESCR ,A.EQUIV_CRSE_ID ,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.INSTITUTION ,B.ACAD_GROUP ,B.SUBJECT ,B.CATALOG_NBR ,B.ACAD_ORG ,B.COURSE_APPROVED ,A.EFFDT 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.EFFDT <= %CurrentDateIn AND D.EFF_STATUS = 'A')

  • Related Language Record: CRSE_CATRVW_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CRSE_ID Character(6) VARCHAR2(6) NOT NULL Course ID
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 EQUIV_CRSE_ID Character(5) VARCHAR2(5) NOT NULL Equivalent Course Group

    Prompt Table: CRSE_EQUIV_TBL

    4 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

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

    Y/N Table Edit

    Default Value: N

    6 UNITS_MINIMUM Number(6,2) DECIMAL(5,2) NOT NULL Minimum Units
    7 UNITS_MAXIMUM Number(6,2) DECIMAL(5,2) NOT NULL Maximum Units
    8 UNITS_ACAD_PROG Number(6,2) DECIMAL(5,2) NOT NULL Academic Progress Units
    9 CRSE_REPEATABLE Character(1) VARCHAR2(1) NOT NULL Repeat for Credit

    Y/N Table Edit

    Default Value: N

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

    Default Value: CRSE_CATALOG.UNITS_MAXIMUM

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

    Default Value: 1

    12 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

    13 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

    14 COURSE_TITLE_LONG Character(100) VARCHAR2(100) NOT NULL Long Course Title

    Default Value: CRSE_CATALOG.DESCR

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

    Y/N Table Edit

    Default Value: N

    16 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
    17 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Default Value: OPR_DEF_TBL_CS.INSTITUTION

    Prompt Table: INSTITUTION_TBL

    18 ACAD_GROUP Character(5) VARCHAR2(5) NOT NULL Academic Group

    Default Value: OPR_DEF_TBL_CS.ACAD_GROUP

    Prompt Table: ACAD_GROUP_TBL

    19 SUBJECT Character(8) VARCHAR2(8) NOT NULL Subject Area

    Default Value: OPR_DEF_TBL_CS.SUBJECT

    Prompt Table: SUBJECT_TBL

    20 CATALOG_NBR Character(10) VARCHAR2(10) NOT NULL Catalog Nbr

    Prompt Table: CRSE_CATNO_SRCH

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