SAE_CLSFILTR_VW

(SQL View)
 Index Back

Class Scope Table

SAIP Class Section view to verify the scope of Class Sections for third party integration

SELECT /*+ LEADING( CLS_EXT CLS ) */ CLS.CRSE_ID , CLS.CRSE_OFFER_NBR , CLS.STRM , CLS.SESSION_CODE , CLS.CLASS_SECTION , CLS.INSTITUTION , CLS.ACAD_GROUP , CLS.SUBJECT , CLS.CATALOG_NBR , CLS.ACAD_CAREER , CLS.DESCR , CLS.CLASS_NBR , CLS.SSR_COMPONENT , CLS.ENRL_STAT , CLS.CLASS_STAT , CLS.CLASS_TYPE , CLS.ASSOCIATED_CLASS , CLS.WAITLIST_DAEMON , CLS.AUTO_ENRL_WAITLIST , CLS.STDNT_SPEC_PERM , CLS.AUTO_ENROLL_SECT_1 , CLS.AUTO_ENROLL_SECT_2 , CLS.RESECTION , CLS.SCHEDULE_PRINT , CLS.CONSENT , CLS.ENRL_CAP , CLS.WAIT_CAP , CLS.MIN_ENRL , CLS.ENRL_TOT , CLS.WAIT_TOT , CLS.CRS_TOPIC_ID , CLS.PRINT_TOPIC , CLS.ACAD_ORG , CLS.NEXT_STDNT_POSITIN , CLS.EMPLID , CLS.CAMPUS , CLS.LOCATION , CLS.CAMPUS_EVENT_NBR , CLS.INSTRUCTION_MODE , CLS.EQUIV_CRSE_ID , CLS.OVRD_CRSE_EQUIV_ID , CLS.ROOM_CAP_REQUEST , CLS.START_DT , CLS.END_DT , CLS.CANCEL_DT , CLS.PRIM_INSTR_SECT , CLS.COMBINED_SECTION , CLS.HOLIDAY_SCHEDULE , CLS.EXAM_SEAT_SPACING , CLS.DYN_DT_INCLUDE , CLS.DYN_DT_CALC_REQ , CLS.ATTEND_GENERATE , CLS.ATTEND_SYNC_REQD , CLS.FEES_EXIST , CLS.CNCL_IF_STUD_ENRLD , CLS.RCV_FROM_ITEM_TYPE , CLS.AP_BUS_UNIT , CLS.AP_LEDGER , CLS.AP_ACCOUNT , CLS.AP_DEPTID , CLS.AP_PROJ_ID , CLS.AP_PRODUCT , CLS.AP_FUND_CODE , CLS.AP_PROG_CODE , CLS.AP_CLASS_FLD , CLS.AP_AFFILIATE , CLS.AP_OP_UNIT , CLS.AP_ALTACCT , CLS.AP_BUD_REF , CLS.AP_CF1 , CLS.AP_CF2 , CLS.AP_CF3 , CLS.AP_AFF_INT1 , CLS.AP_AFF_INT2 , CLS.WRITEOFF_BUS_UNIT , CLS.WRITEOFF_LEDGER , CLS.WRITEOFF_ACCOUNT , CLS.WRITEOFF_DEPTID , CLS.WRITEOFF_PROJ_ID , CLS.WRITEOFF_PRODUCT , CLS.WRITEOFF_FUND_CODE , CLS.WRITEOFF_PROG_CODE , CLS.WRITEOFF_CLASS_FLD , CLS.WRITEOFF_AFFILIATE , CLS.WRITEOFF_OP_UNIT , CLS.WRITEOFF_ALTACCT , CLS.WRITEOFF_BUD_REF , CLS.WRITEOFF_CF1 , CLS.WRITEOFF_CF2 , CLS.WRITEOFF_CF3 , CLS.WRITEOFF_AFF_INT1 , CLS.WRITEOFF_AFF_INT2 , CLS.EXT_WRITEOFF , CLS.GL_INTERFACE_REQ , CLS.LMS_FILE_TYPE , CLS.LMS_GROUP_ID , CLS.LMS_URL , CLS.LMS_CLASS_EXT_DTTM , CLS.LMS_ENRL_EXT_DTTM , CLS.LMS_PROVIDER , CLS.SSR_DROP_CONSENT , CLS_EXT.SAE_MODE , CLS_EXT.SAE_EVENT_DT , CLS_EXT.SAE_IMS_ASSOC_NBR , CRSE.COURSE_TITLE_LONG FROM %Table(SAE_CLASS_EXT) CLS_EXT , %Table(CRSE_OFFER) OFFER , %Table(CLASS_TBL) CLS , %Table(CRSE_CATALOG) CRSE , %Table(SAE_ACADORG_EXT) ORG_EXT , %Table(SAE_ACADORG_EXT) ORG_EXT1 , %Table(TERM_TBL) TERM , %Table(SAE_TERM_EXT) TERM_EXT , %Table(SAE_INST_SCOPE) INST_EXT ,%Table(SAE_SESSION_EXT) SES_EXT WHERE INST_EXT.INSTITUTION = CLS.INSTITUTION AND INST_EXT.SAE_MODE <> 'D' AND ORG_EXT.INSTITUTION = CLS.INSTITUTION AND ORG_EXT.ACAD_ORG = CLS.ACAD_ORG AND ORG_EXT.SAE_MODE <> 'D' AND ORG_EXT1.INSTITUTION = OFFER.INSTITUTION AND ORG_EXT1.ACAD_ORG = OFFER.ACAD_ORG AND ORG_EXT1.SAE_MODE <> 'D' AND TERM.STRM = CLS.STRM AND TERM.INSTITUTION = CLS.INSTITUTION AND TERM.ACAD_CAREER = CLS.ACAD_CAREER AND TERM_EXT.STRM = CLS_EXT.STRM AND TERM_EXT.INSTITUTION = CLS_EXT.INSTITUTION AND TERM_EXT.ACAD_CAREER = CLS_EXT.ACAD_CAREER AND TERM_EXT.SAE_INCLUDE = 'Y' AND SES_EXT.INSTITUTION = CLS_EXT.INSTITUTION AND SES_EXT.STRM = CLS_EXT.STRM AND SES_EXT.ACAD_CAREER = CLS_EXT.ACAD_CAREER AND SES_EXT.SESSION_CODE = CLS_EXT.SESSION_CODE AND %Coalesce(CLS_EXT.SAE_INTEG_START_DT, %DateAdd(CLS.START_DT, SES_EXT.SAE_START_OFFSET)) <= %CurrentDateIn AND %Coalesce(CLS_EXT.SAE_INTEG_END_DT, %DateAdd(CLS.END_DT, SES_EXT.SAE_END_OFFSET)) >= %CurrentDateIn AND CRSE.CRSE_ID = CLS.CRSE_ID 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 OFFER.CRSE_ID = CLS.CRSE_ID AND OFFER.CRSE_OFFER_NBR = CLS.CRSE_OFFER_NBR 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 OFFER.COURSE_APPROVED = 'A' AND CLS_EXT.CRSE_ID = CLS.CRSE_ID AND CLS_EXT.CRSE_OFFER_NBR = CLS.CRSE_OFFER_NBR AND CLS_EXT.STRM = CLS.STRM AND CLS_EXT.SESSION_CODE = CLS.SESSION_CODE AND CLS_EXT.CLASS_SECTION = CLS.CLASS_SECTION AND CLS_EXT.SAE_INCLUDE = 'Y' AND CLS_EXT.SAE_MODE <> 'D' UNION ALL SELECT /*+ LEADING(CLS_EXT1 OFFER_EXT) */ CLS_EXT1.CRSE_ID , CLS_EXT1.CRSE_OFFER_NBR , CLS_EXT1.STRM , CLS_EXT1.SESSION_CODE , CLS_EXT1.CLASS_SECTION , CLS_EXT1.INSTITUTION , '' , '' , '' , CLS_EXT1.ACAD_CAREER , '' , CLS_EXT1.CLASS_NBR , '' , '' , '' , '' , 0 , '' , '' , '' , '' , '' , '' , '' , '' , 0 , 0 , 0 , 0 , 0 , 0 , '' , CLS_EXT1.ACAD_ORG , 0 , '' , '' , '' , '' , '' , '' , '' , 0 , %DateNull , %DateNull , %DateNull , '' , '' , '' , 0 , '' , '' , '' , '' , '' , '' , '' , '' , '' , '' , '' , '' , '' , '' , '' , '' , '' , '' , '' , '' , '' , '' , '' , '' , '' , '' , '' , '' , '' , '' , '' , '' , '' , '' , '' , '' , '' , '' , '' , '' , '' , '' , '' , '' , '' , '' , '' , '' , %DateTimeNull , %DateTimeNull , '' , '' , CLS_EXT1.SAE_MODE , CLS_EXT1.SAE_EVENT_DT , CLS_EXT1.SAE_IMS_ASSOC_NBR , '' FROM %Table(SAE_CLASS_EXT) CLS_EXT1 , %Table(CRSE_OFFER) OFFER1 , %Table(SAE_ACADORG_EXT) ORG_EXT , %Table(SAE_ACADORG_EXT) ORG_EXT1 , %Table(TERM_TBL) TERM1 , %Table(SAE_TERM_EXT) TERM_EXT1 , %Table(SAE_INST_SCOPE) INST_EXT1 , %Table(SAE_SESSION_EXT) SES_EXT1 WHERE INST_EXT1.INSTITUTION = CLS_EXT1.INSTITUTION AND INST_EXT1.SAE_MODE <> 'D' AND ORG_EXT.INSTITUTION = CLS_EXT1.INSTITUTION AND ORG_EXT.ACAD_ORG = CLS_EXT1.ACAD_ORG AND ORG_EXT.SAE_MODE <> 'D' AND ORG_EXT1.INSTITUTION = OFFER1.INSTITUTION AND ORG_EXT1.ACAD_ORG = OFFER1.ACAD_ORG AND ORG_EXT1.SAE_MODE <> 'D' AND TERM1.STRM = CLS_EXT1.STRM AND TERM1.INSTITUTION = CLS_EXT1.INSTITUTION AND TERM1.ACAD_CAREER = CLS_EXT1.ACAD_CAREER AND TERM_EXT1.STRM = TERM1.STRM AND TERM_EXT1.INSTITUTION = TERM1.INSTITUTION AND TERM_EXT1.ACAD_CAREER = TERM1.ACAD_CAREER AND TERM_EXT1.SAE_INCLUDE = 'Y' AND SES_EXT1.INSTITUTION = CLS_EXT1.INSTITUTION AND SES_EXT1.STRM = CLS_EXT1.STRM AND SES_EXT1.ACAD_CAREER = CLS_EXT1.ACAD_CAREER AND SES_EXT1.SESSION_CODE = CLS_EXT1.SESSION_CODE AND %Coalesce(CLS_EXT1.SAE_INTEG_START_DT, %DateAdd(CLS_EXT1.START_DT, SES_EXT1.SAE_START_OFFSET)) <= %CurrentDateIn AND %Coalesce(CLS_EXT1.SAE_INTEG_END_DT, %DateAdd(CLS_EXT1.END_DT, SES_EXT1.SAE_END_OFFSET)) >= %CurrentDateIn AND OFFER1.CRSE_ID = CLS_EXT1.CRSE_ID AND OFFER1.CRSE_OFFER_NBR = CLS_EXT1.CRSE_OFFER_NBR AND OFFER1.EFFDT = %Coalesce((select max(effdt) FROM PS_CRSE_OFFER CRSE_OFFER1 WHERE CRSE_OFFER1.CRSE_ID =OFFER1.CRSE_ID AND CRSE_OFFER1.CRSE_OFFER_NBR=OFFER1.CRSE_OFFER_NBR AND CRSE_OFFER1.EFFDT <=%CurrentDateIn ) ,( select min(effdt) FROM PS_CRSE_OFFER CRSE_OFFER1 WHERE CRSE_OFFER1.CRSE_ID =OFFER1.CRSE_ID AND CRSE_OFFER1.CRSE_OFFER_NBR=OFFER1.CRSE_OFFER_NBR AND CRSE_OFFER1.EFFDT >%CurrentDateIn )) AND OFFER1.COURSE_APPROVED = 'A' AND CLS_EXT1.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
    105 COURSE_TITLE_LONG Character(100) VARCHAR2(100) NOT NULL Long Course Title