SAE_LDAPCLASSVW

(SQL View)
 Index Back

Class Scope Table


SELECT CLSTBL.CRSE_ID , CLSTBL.CRSE_OFFER_NBR , CLSTBL.STRM , CLSTBL.SESSION_CODE , CLSTBL.CLASS_SECTION , CLSTBL.INSTITUTION , CLSTBL.ACAD_GROUP , CLSTBL.SUBJECT , CLSTBL.CATALOG_NBR , CLSTBL.ACAD_CAREER , CLSTBL.DESCR , CLSTBL.CLASS_NBR , CLSTBL.SSR_COMPONENT , CLSTBL.ENRL_STAT , CLSTBL.CLASS_STAT , CLSTBL.CLASS_TYPE , CLSTBL.ASSOCIATED_CLASS , CLSTBL.WAITLIST_DAEMON , CLSTBL.AUTO_ENRL_WAITLIST , CLSTBL.STDNT_SPEC_PERM , CLSTBL.AUTO_ENROLL_SECT_1 , CLSTBL.AUTO_ENROLL_SECT_2 , CLSTBL.RESECTION , CLSTBL.SCHEDULE_PRINT , CLSTBL.CONSENT , CLSTBL.ENRL_CAP , CLSTBL.WAIT_CAP , CLSTBL.MIN_ENRL , CLSTBL.ENRL_TOT , CLSTBL.WAIT_TOT , CLSTBL.CRS_TOPIC_ID , CLSTBL.PRINT_TOPIC , CLSTBL.ACAD_ORG , CLSTBL.NEXT_STDNT_POSITIN , CLSTBL.EMPLID , CLSTBL.CAMPUS , CLSTBL.LOCATION , CLSTBL.CAMPUS_EVENT_NBR , CLSTBL.INSTRUCTION_MODE , CLSTBL.EQUIV_CRSE_ID , CLSTBL.OVRD_CRSE_EQUIV_ID , CLSTBL.ROOM_CAP_REQUEST , CLSTBL.START_DT , CLSTBL.END_DT , CLSTBL.CANCEL_DT , CLSTBL.PRIM_INSTR_SECT , CLSTBL.COMBINED_SECTION , CLSTBL.HOLIDAY_SCHEDULE , CLSTBL.EXAM_SEAT_SPACING , CLSTBL.DYN_DT_INCLUDE , CLSTBL.DYN_DT_CALC_REQ , CLSTBL.ATTEND_GENERATE , CLSTBL.ATTEND_SYNC_REQD , CLSTBL.FEES_EXIST , CLSTBL.CNCL_IF_STUD_ENRLD , CLSTBL.RCV_FROM_ITEM_TYPE , CLSTBL.AP_BUS_UNIT , CLSTBL.AP_LEDGER , CLSTBL.AP_ACCOUNT , CLSTBL.AP_DEPTID , CLSTBL.AP_PROJ_ID , CLSTBL.AP_PRODUCT , CLSTBL.AP_FUND_CODE , CLSTBL.AP_PROG_CODE , CLSTBL.AP_CLASS_FLD , CLSTBL.AP_AFFILIATE , CLSTBL.AP_OP_UNIT , CLSTBL.AP_ALTACCT , CLSTBL.AP_BUD_REF , CLSTBL.AP_CF1 , CLSTBL.AP_CF2 , CLSTBL.AP_CF3 , CLSTBL.AP_AFF_INT1 , CLSTBL.AP_AFF_INT2 , CLSTBL.WRITEOFF_BUS_UNIT , CLSTBL.WRITEOFF_LEDGER , CLSTBL.WRITEOFF_ACCOUNT , CLSTBL.WRITEOFF_DEPTID , CLSTBL.WRITEOFF_PROJ_ID , CLSTBL.WRITEOFF_PRODUCT , CLSTBL.WRITEOFF_FUND_CODE , CLSTBL.WRITEOFF_PROG_CODE , CLSTBL.WRITEOFF_CLASS_FLD , CLSTBL.WRITEOFF_AFFILIATE , CLSTBL.WRITEOFF_OP_UNIT , CLSTBL.WRITEOFF_ALTACCT , CLSTBL.WRITEOFF_BUD_REF , CLSTBL.WRITEOFF_CF1 , CLSTBL.WRITEOFF_CF2 , CLSTBL.WRITEOFF_CF3 , CLSTBL.WRITEOFF_AFF_INT1 , CLSTBL.WRITEOFF_AFF_INT2 , CLSTBL.EXT_WRITEOFF , CLSTBL.GL_INTERFACE_REQ , CLSTBL.LMS_FILE_TYPE , CLSTBL.LMS_GROUP_ID , CLSTBL.LMS_URL , CLSTBL.LMS_CLASS_EXT_DTTM , CLSTBL.LMS_ENRL_EXT_DTTM , CLSTBL.LMS_PROVIDER , CLSTBL.SSR_DROP_CONSENT , CLASS_EXT.SAE_MODE , CLASS_EXT.SAE_EVENT_DT , CLASS_EXT.SAE_IMS_ASSOC_NBR FROM %Table(SAE_CLASS_EXT) CLASS_EXT , %Table(CLASS_TBL) CLSTBL , %Table(TERM_TBL) TERM , %Table(SAE_TERM_EXT) TERM_EXT ,%Table(SAE_SESSION_EXT) SES_EXT , %Table(SAE_INST_SCOPE) INSTSCOPE , %Table(SAE_ACADORG_EXT) ORGSCOPE WHERE CLASS_EXT.SAE_INCLUDE = 'Y' AND CLSTBL.CRSE_ID = CLASS_EXT.CRSE_ID AND CLSTBL.CRSE_OFFER_NBR = CLASS_EXT.CRSE_OFFER_NBR AND CLSTBL.STRM = CLASS_EXT.STRM AND CLSTBL.SESSION_CODE = CLASS_EXT.SESSION_CODE AND CLSTBL.CLASS_SECTION = CLASS_EXT.CLASS_SECTION AND TERM.INSTITUTION = CLSTBL.INSTITUTION AND TERM.ACAD_CAREER = CLSTBL.ACAD_CAREER AND TERM.STRM = CLSTBL.STRM AND TERM_EXT.INSTITUTION = TERM.INSTITUTION AND TERM_EXT.ACAD_CAREER = TERM.ACAD_CAREER AND TERM_EXT.STRM = TERM.STRM AND SES_EXT.INSTITUTION = CLASS_EXT.INSTITUTION AND SES_EXT.STRM = CLASS_EXT.STRM AND SES_EXT.ACAD_CAREER = CLASS_EXT.ACAD_CAREER AND SES_EXT.SESSION_CODE = CLASS_EXT.SESSION_CODE AND %Coalesce(CLASS_EXT.SAE_INTEG_START_DT, %DateAdd(CLASS_EXT.START_DT, SES_EXT.SAE_START_OFFSET)) <= %CurrentDateIn AND %Coalesce(CLASS_EXT.SAE_INTEG_END_DT, %DateAdd(CLASS_EXT.END_DT, SES_EXT.SAE_END_OFFSET)) >= %CurrentDateIn AND INSTSCOPE.INSTITUTION = CLASS_EXT.INSTITUTION AND INSTSCOPE.SAE_MODE <> 'D' AND ORGSCOPE.INSTITUTION = CLASS_EXT.INSTITUTION AND ORGSCOPE.ACAD_ORG = CLASS_EXT.ACAD_ORG AND ORGSCOPE.SAE_MODE <> 'D'

  • Related Language Record: CLASS_TBL_LANG

    • # 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 STRM Character(4) VARCHAR2(4) NOT NULL Term
    4 SESSION_CODE Character(3) VARCHAR2(3) NOT NULL Session
    1=Regular Academic Session
    10W=10 Week
    12W=Twelve Week
    4W1=Four Week - First
    4W2=Four Week - Second
    4W3=Four Week - Third
    4W4=Four Week - Fourth
    6W1=Six Week - First
    6W2=Six Week - Second
    8W1=Eight Week - First
    8W2=Eight Week - Second
    A11=Medical Period 1, 4 Weeks
    A12=Medical Period 1, 8 Weeks
    A13=Medical Pd 1, 12 Weeks
    A21=Medical Period 2, 4 Weeks
    A22=Medical Period 2, 8 Weeks
    A23=Medical Period 2, 12 Week
    FYR=Full Year
    MIN=Mini Session
    OEE=Open Entry/Open Exit
    SM1=Semester 1
    SM2=Semester 2

    Default Value: TERM_TBL.SESSION_CODE

    Prompt Table: SESSION_TBL

    5 CLASS_SECTION Character(4) VARCHAR2(4) NOT NULL Class Section
    6 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Default Value: CRSE_OFFER.INSTITUTION

    Prompt Table: INSTITUTION_TBL

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

    Default Value: CRSE_OFFER.ACAD_GROUP

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

    Default Value: CRSE_OFFER.SUBJECT

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

    Default Value: CRSE_OFFER.CATALOG_NBR

    10 ACAD_CAREER Character(4) VARCHAR2(4) NOT NULL Academic Career
    BAC=Bachelor (NLD)
    BBL=Vocational Coaching (NLD)
    BOL=Vocational Training (NLD)
    BUSN=Graduate Business
    CNED=Continuing Education
    CRED=Semester Credit
    EDU=Education (NLD)
    EXED=Extended Education
    GRAD=Graduate
    LAW=Law
    MEDS=Medical School
    NONA=Non Award
    PGRD=Postgraduate
    RSCH=Research
    TECH=Technical
    UENG=Undergraduate Engineering
    UGRD=Undergraduate
    VAVO=Advanced General Educ. (NLD)
    VETM=Veterinary Medicine

    Default Value: CRSE_OFFER.ACAD_CAREER

    11 DESCR Character(30) VARCHAR2(30) NOT NULL Description

    Default Value: CRSE_CATALOG.DESCR

    12 CLASS_NBR Number(5,0) INTEGER NOT NULL Class Nbr
    13 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

    Prompt Table: %EDITTABLE2

    14 ENRL_STAT Character(1) VARCHAR2(1) NOT NULL Enrollment Status
    C=Closed
    O=Open
    W=Wait List

    Default Value: C

    15 CLASS_STAT Character(1) VARCHAR2(1) NOT NULL Class Status
    A=Active
    S=Stop Further Enrollment
    T=Tentative Section
    X=Cancelled Section

    Default Value: A

    16 CLASS_TYPE Character(1) VARCHAR2(1) NOT NULL Class Type
    E=Enrollment Section
    N=Non-Enrollment Section

    Default Value: E

    17 ASSOCIATED_CLASS Number(4,0) SMALLINT NOT NULL Associated Class

    Default Value: 1

    Prompt Table: CLASS_ASSOC

    18 WAITLIST_DAEMON Character(2) VARCHAR2(2) NOT NULL WAITLIST DAEMON SWITCH
    C=Candidates Still on Wait List
    N=No processing needed
    R=Yes - initiated by Reserve Cap
    Y=Yes-needs processing

    Default Value: N

    19 AUTO_ENRL_WAITLIST Character(1) VARCHAR2(1) NOT NULL Auto Enroll from Wait List

    Y/N Table Edit

    Default Value: ACAD_GROUP_TBL.AUTO_ENRL_WAITLIST

    20 STDNT_SPEC_PERM Character(1) VARCHAR2(1) NOT NULL Student Specific Permissions

    Y/N Table Edit

    Default Value: ACAD_GROUP_TBL.STDNT_SPEC_PERM

    21 AUTO_ENROLL_SECT_1 Character(4) VARCHAR2(4) NOT NULL 1st Auto Enroll Section
    22 AUTO_ENROLL_SECT_2 Character(4) VARCHAR2(4) NOT NULL 2nd Auto Enroll Section
    23 RESECTION Character(4) VARCHAR2(4) NOT NULL Resection to Section
    24 SCHEDULE_PRINT Character(1) VARCHAR2(1) NOT NULL Schedule Print
    A=All
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: CRSE_OFFER.SCHEDULE_PRINT

    25 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: CRSE_CATALOG.CONSENT

    26 ENRL_CAP Number(4,0) SMALLINT NOT NULL Enrollment Capacity
    27 WAIT_CAP Number(4,0) SMALLINT NOT NULL Wait List Capacity
    28 MIN_ENRL Number(4,0) SMALLINT NOT NULL Minimum Enrollment Number
    29 ENRL_TOT Number(4,0) SMALLINT NOT NULL Enrollment Total
    30 WAIT_TOT Number(4,0) SMALLINT NOT NULL Wait List Total
    31 CRS_TOPIC_ID Number(3,0) SMALLINT NOT NULL Course Topic ID

    Prompt Table: CRSE_TOPICS_VW2

    32 PRINT_TOPIC Character(1) VARCHAR2(1) NOT NULL Print Topic in Schedule

    Y/N Table Edit

    Default Value: N

    33 ACAD_ORG Character(10) VARCHAR2(10) NOT NULL Academic Organization

    Default Value: CRSE_OFFER.ACAD_ORG

    Prompt Table: ACAD_ORG_SRCH

    34 NEXT_STDNT_POSITIN Number(8,0) INTEGER NOT NULL Next Student Position

    Default Value: 10

    35 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: %EDITTABLE

    36 CAMPUS Character(5) VARCHAR2(5) NOT NULL Campus

    Prompt Table: CAMPUS_TBL

    37 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

    Default Value: CAMPUS_TBL.LOCATION

    Prompt Table: CAMPUS_LOC_VW

    38 CAMPUS_EVENT_NBR Character(9) VARCHAR2(9) NOT NULL Event ID
    39 INSTRUCTION_MODE Character(2) VARCHAR2(2) NOT NULL Instruction Mode

    Default Value: P

    Prompt Table: INSTRUCT_MODE

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

    Prompt Table: CRSE_EQUIV_TBL

    41 OVRD_CRSE_EQUIV_ID Character(1) VARCHAR2(1) NOT NULL Override Equivalent Course

    Y/N Table Edit

    Default Value: N

    42 ROOM_CAP_REQUEST Number(4,0) SMALLINT NOT NULL Requested Room Capacity

    Default Value: CLASS_TBL.ENRL_CAP

    43 START_DT Date(10) DATE NOT NULL Start Date

    Default Value: SESSION_TBL.SESS_BEGIN_DT

    44 END_DT Date(10) DATE NOT NULL end date

    Default Value: SESSION_TBL.SESS_END_DT

    45 CANCEL_DT Date(10) DATE Cancel Date
    46 PRIM_INSTR_SECT Character(4) VARCHAR2(4) NOT NULL Primary Instructional Section

    Default Value: CLASS_TBL.CLASS_SECTION

    47 COMBINED_SECTION Character(1) VARCHAR2(1) NOT NULL Combined Section
    C=Combined Section
    S=Combined Section Skip Mtg Pat
    48 HOLIDAY_SCHEDULE Character(6) VARCHAR2(6) NOT NULL Holiday Schedule

    Default Value: SESSION_TBL.HOLIDAY_SCHEDULE

    Prompt Table: HOLIDAY_TBL

    49 EXAM_SEAT_SPACING Number(1,0) SMALLINT NOT NULL Exam Seat Spacing

    Default Value: CRSE_COMPONENT.EXAM_SEAT_SPACING

    50 DYN_DT_INCLUDE Character(1) VARCHAR2(1) NOT NULL Include in Dynamic Date Calc

    Y/N Table Edit

    Default Value: N

    51 DYN_DT_CALC_REQ Character(1) VARCHAR2(1) NOT NULL Dynamic Date Calc Required

    Y/N Table Edit

    Default Value: N

    52 ATTEND_GENERATE Character(1) VARCHAR2(1) NOT NULL Generate Class Mtg Attendance

    Y/N Table Edit

    Default Value: N

    53 ATTEND_SYNC_REQD Character(1) VARCHAR2(1) NOT NULL Sync Attendance with Class Mtg

    Y/N Table Edit

    Default Value: N

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

    Default Value: N

    55 CNCL_IF_STUD_ENRLD Character(1) VARCHAR2(1) NOT NULL Cancel if Student Enrolled

    Y/N Table Edit

    Default Value: N

    56 RCV_FROM_ITEM_TYPE Character(1) VARCHAR2(1) NOT NULL Receivables From Item Type

    Y/N Table Edit

    Default Value: N

    57 AP_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: BUS_UNIT_TBL_FS

    58 AP_LEDGER Character(10) VARCHAR2(10) NOT NULL Ledger

    Prompt Table: LED_DEFN_TBL
    Set Control Field: AP_BUS_UNIT

    59 AP_ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account
    60 AP_DEPTID Character(10) VARCHAR2(10) NOT NULL Department
    61 AP_PROJ_ID Character(15) VARCHAR2(15) NOT NULL Project ID
    62 AP_PRODUCT Character(6) VARCHAR2(6) NOT NULL Product
    63 AP_FUND_CODE Character(5) VARCHAR2(5) NOT NULL Fund
    64 AP_PROG_CODE Character(5) VARCHAR2(5) NOT NULL Program
    65 AP_CLASS_FLD Character(5) VARCHAR2(5) NOT NULL Public Sector Financials Chart Field.
    66 AP_AFFILIATE Character(5) VARCHAR2(5) NOT NULL Public Sector Financials Chart Field
    67 AP_OP_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit
    68 AP_ALTACCT Character(10) VARCHAR2(10) NOT NULL Alternate Account
    69 AP_BUD_REF Character(8) VARCHAR2(8) NOT NULL Budget Reference Chartfield
    70 AP_CF1 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield number 1
    71 AP_CF2 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield number 2
    72 AP_CF3 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield number 3
    73 AP_AFF_INT1 Character(10) VARCHAR2(10) NOT NULL IntraUnit Affiliate1
    74 AP_AFF_INT2 Character(10) VARCHAR2(10) NOT NULL Operating Unit Affiliate
    75 WRITEOFF_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: BUS_UNIT_TBL_FS

    76 WRITEOFF_LEDGER Character(10) VARCHAR2(10) NOT NULL Ledger

    Prompt Table: LED_DEFN_TBL
    Set Control Field: WRITEOFF_BUS_UNIT

    77 WRITEOFF_ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account
    78 WRITEOFF_DEPTID Character(10) VARCHAR2(10) NOT NULL Department
    79 WRITEOFF_PROJ_ID Character(15) VARCHAR2(15) NOT NULL Project ID
    80 WRITEOFF_PRODUCT Character(6) VARCHAR2(6) NOT NULL Product
    81 WRITEOFF_FUND_CODE Character(5) VARCHAR2(5) NOT NULL Fund Code
    82 WRITEOFF_PROG_CODE Character(5) VARCHAR2(5) NOT NULL Program Code
    83 WRITEOFF_CLASS_FLD Character(5) VARCHAR2(5) NOT NULL Public Sector Financials Chart Field.
    84 WRITEOFF_AFFILIATE Character(5) VARCHAR2(5) NOT NULL Public Sector Financials Chart Field
    85 WRITEOFF_OP_UNIT Character(8) VARCHAR2(8) NOT NULL Writeoff Operating Unit
    86 WRITEOFF_ALTACCT Character(10) VARCHAR2(10) NOT NULL Writeoff Alternate Account
    87 WRITEOFF_BUD_REF Character(8) VARCHAR2(8) NOT NULL Budget Reference Chartfield
    88 WRITEOFF_CF1 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield number 1
    89 WRITEOFF_CF2 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield number 2
    90 WRITEOFF_CF3 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield number 3
    91 WRITEOFF_AFF_INT1 Character(10) VARCHAR2(10) NOT NULL IntraUnit Affiliate1
    92 WRITEOFF_AFF_INT2 Character(10) VARCHAR2(10) NOT NULL Writeoff Operating Unit Affiliate
    93 EXT_WRITEOFF Character(50) VARCHAR2(50) NOT NULL External Writeoff
    94 GL_INTERFACE_REQ Character(1) VARCHAR2(1) NOT NULL GL Interface Required

    Y/N Table Edit

    Default Value: N

    95 LMS_FILE_TYPE Character(3) VARCHAR2(3) NOT NULL LMS extract file type: XML compliant, Blackboard specific, and WebCT specific
    BKB=Blackboard CourseInfo 4
    WCT=API Input (old WebCT format)
    XML=XML V1.1 (req to authenticate)
    96 LMS_GROUP_ID Character(50) VARCHAR2(50) NOT NULL LMS group object id
    97 LMS_URL Character(254) VARCHAR2(254) NOT NULL LMS class URL
    98 LMS_CLASS_EXT_DTTM DateTime(26) TIMESTAMP LMS class extract datetime.
    99 LMS_ENRL_EXT_DTTM DateTime(26) TIMESTAMP Class enrollment extract datetime
    100 LMS_PROVIDER Character(30) VARCHAR2(30) NOT NULL Provider for Authentication

    Prompt Table: LMS_INT_SETUP
    Set Control Field: LMS_PROVIDER

    101 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: CRSE_CATALOG.SSR_DROP_CONSENT

    102 SAE_MODE Character(1) VARCHAR2(1) NOT NULL Operation Mode
    A=Add
    C=Change
    D=Delete
    103 SAE_EVENT_DT DateTime(26) TIMESTAMP Event Driven Timestamp
    104 SAE_IMS_ASSOC_NBR Number(4,0) SMALLINT NOT NULL IMS Association Number