SAE_CRSTMPL_VW

(SQL View)
 Index Back

SELECT OFFER.CRSE_ID , OFFER.CRSE_OFFER_NBR , CRSE.COURSE_TITLE_LONG , CRSE.DESCR , CRSE.EFF_STATUS , CRSE.EQUIV_CRSE_ID , CRSE.CONSENT , CRSE.ALLOW_MULT_ENROLL , CRSE.UNITS_MINIMUM , CRSE.UNITS_MAXIMUM , CRSE.UNITS_ACAD_PROG , CRSE.UNITS_FINAID_PROG , CRSE.CRSE_REPEATABLE , CRSE.UNITS_REPEAT_LIMIT , CRSE.CRSE_REPEAT_LIMIT , CRSE.GRADING_BASIS , CRSE.GRADE_ROSTER_PRINT , CRSE.SSR_COMPONENT , CRSE.LST_MULT_TRM_CRS , CRSE.CRSE_CONTACT_HRS , CRSE.RQMNT_DESIGNTN , CRSE.CRSE_COUNT , CRSE.INSTRUCTOR_EDIT , CRSE.FEES_EXIST , CRSE.COMPONENT_PRIMARY , CRSE.ENRL_UN_LD_CLC_TYP , CRSE.SSR_DROP_CONSENT , OFFER.SUBJECT , OFFER.CATALOG_NBR , OFFER.INSTITUTION , OFFER.ACAD_ORG , CRSE_EXT.SAE_MODE , CRSE_EXT.SAE_EVENT_DT FROM %Table(CRSE_CATALOG) CRSE , %Table(SAE_INST_SCOPE) INST_EXT , %Table(SAE_ACADORG_EXT) ORG_EXT , %Table(CRSE_OFFER) OFFER , %Table(SAE_CRSCTLG_EXT) CRSE_EXT WHERE OFFER.CRSE_ID = CRSE.CRSE_ID AND OFFER.COURSE_APPROVED = 'A' AND OFFER.EFFDT = %Coalesce((select max(effdt) FROM PS_CRSE_OFFER CRSE_OFFER1 WHERE CRSE_OFFER1.CRSE_ID =OFFER.CRSE_ID AND CRSE_OFFER1.CRSE_OFFER_NBR=OFFER.CRSE_OFFER_NBR AND CRSE_OFFER1.EFFDT <=%CurrentDateIn ) ,( select min(effdt) FROM PS_CRSE_OFFER CRSE_OFFER1 WHERE CRSE_OFFER1.CRSE_ID =OFFER.CRSE_ID AND CRSE_OFFER1.CRSE_OFFER_NBR=OFFER.CRSE_OFFER_NBR AND CRSE_OFFER1.EFFDT >%CurrentDateIn )) AND CRSE.EFFDT = %Coalesce((select max(effdt) FROM PS_CRSE_CATALOG CRSE_CATALOG1 WHERE CRSE_CATALOG1.CRSE_ID =CRSE.CRSE_ID AND CRSE_CATALOG1.EFFDT <=%CurrentDateIn ) ,(select min(effdt) FROM PS_CRSE_CATALOG CRSE_CATALOG1 WHERE CRSE_CATALOG1.CRSE_ID =CRSE.CRSE_ID AND CRSE_CATALOG1.EFFDT >%CurrentDateIn )) AND INST_EXT.INSTITUTION = OFFER.INSTITUTION AND INST_EXT.SAE_MODE <> 'D' AND ORG_EXT.INSTITUTION = OFFER.INSTITUTION AND ORG_EXT.ACAD_ORG = OFFER.ACAD_ORG AND ORG_EXT.SAE_MODE <> 'D' AND CRSE_EXT.CRSE_ID = OFFER.CRSE_ID AND CRSE_EXT.CRSE_OFFER_NBR = OFFER.CRSE_OFFER_NBR AND CRSE_EXT.SAE_MODE <> 'D' UNION ALL SELECT CRSE_EXT1.CRSE_ID , CRSE_EXT1.CRSE_OFFER_NBR , '' , '' , '' , '' , '' , '' , 0 , 0 , 0 , 0 , '' , 0 , 0 , '' , '' , '' , '' , 0 , '' , 0 , '' , '' , '' , '' , '' , '' , '' , CRSE_EXT1.INSTITUTION , CRSE_EXT1.ACAD_ORG , CRSE_EXT1.SAE_MODE , CRSE_EXT1.SAE_EVENT_DT FROM %Table(SAE_CRSCTLG_EXT) CRSE_EXT1 , %Table(SAE_INST_SCOPE) INST_EXT , %Table(SAE_ACADORG_EXT) ORG_EXT WHERE CRSE_EXT1.SAE_MODE = 'D' AND INST_EXT.INSTITUTION = CRSE_EXT1.INSTITUTION AND INST_EXT.SAE_MODE <> 'D' AND ORG_EXT.INSTITUTION = CRSE_EXT1.INSTITUTION AND ORG_EXT.ACAD_ORG = CRSE_EXT1.ACAD_ORG AND ORG_EXT.SAE_MODE <> 'D'

  • Related Language Record: SAE_CRSTMPL_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CRSE_ID Character(6) VARCHAR2(6) NOT NULL Course ID
    2 CRSE_OFFER_NBR Number(2,0) SMALLINT NOT NULL Course Offering Nbr
    3 COURSE_TITLE_LONG Character(100) VARCHAR2(100) NOT NULL Long Course Title

    Default Value: CRSE_CATALOG.DESCR

    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    6 EQUIV_CRSE_ID Character(5) VARCHAR2(5) NOT NULL Equivalent Course Group

    Prompt Table: CRSE_EQUIV_TBL

    7 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

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

    Y/N Table Edit

    Default Value: N

    9 UNITS_MINIMUM Number(6,2) DECIMAL(5,2) NOT NULL Minimum Units
    10 UNITS_MAXIMUM Number(6,2) DECIMAL(5,2) NOT NULL Maximum Units
    11 UNITS_ACAD_PROG Number(6,2) DECIMAL(5,2) NOT NULL Academic Progress Units
    12 UNITS_FINAID_PROG Number(6,2) DECIMAL(5,2) NOT NULL Financial Aid 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

    Default Value: CRSE_CATALOG.UNITS_MAXIMUM

    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: GRD

    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 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
    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 SUBJECT Character(8) VARCHAR2(8) NOT NULL Subject Area
    29 CATALOG_NBR Character(10) VARCHAR2(10) NOT NULL Catalog Nbr
    30 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
    31 ACAD_ORG Character(10) VARCHAR2(10) NOT NULL Academic Organization
    32 SAE_MODE Character(1) VARCHAR2(1) NOT NULL Operation Mode
    A=Add
    C=Change
    D=Delete
    33 SAE_EVENT_DT DateTime(26) TIMESTAMP Event Driven Timestamp