CRSE_CAT_R2_VW

(SQL View)
 Index Back

Course Catalog Rqmnt View


SELECT B.INSTITUTION ,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.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.EFF_STATUS = 'A')

  • Related Language Record: CRSE_CAT2V_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 CRSE_ID Character(6) VARCHAR2(6) NOT NULL Course ID
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 EQUIV_CRSE_ID Character(5) VARCHAR2(5) NOT NULL Equivalent Course Group

    Prompt Table: CRSE_EQUIV_TBL

    5 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

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

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

    Default Value: 1

    13 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

    14 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

    15 COURSE_TITLE_LONG Character(100) VARCHAR2(100) NOT NULL Long Course Title
    16 LST_MULT_TRM_CRS Character(1) VARCHAR2(1) NOT NULL Last Course of Mult Term Seq

    Y/N Table Edit

    Default Value: N

    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 ACAD_GROUP Character(5) VARCHAR2(5) NOT NULL Academic Group

    Prompt Table: ACAD_GROUP_TBL

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

    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