CRSE_OFFER

(SQL Table)
 Index Back

Course Catalog Offerings

The Course Catalog Offerings indicates what academic units, subject and course catalog numbers a course can be offered under.

  • Parent record: CRSE_CATALOG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CRSE_ID Character(6) VARCHAR2(6) NOT NULL Course ID

    Prompt Table: CRSE_CATALOG

    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 CRSE_OFFER_NBR Number(2,0) SMALLINT NOT NULL Course Offering Nbr
    4 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Default Value: OPR_DEF_TBL_CS.INSTITUTION

    Prompt Table: INSTITUTION_TBL

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

    Default Value: OPR_DEF_TBL_CS.ACAD_GROUP

    Prompt Table: ACAD_GROUP_TBL

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

    Prompt Table: SUBJECT_TBL

    7 CATALOG_NBR Character(10) VARCHAR2(10) NOT NULL Catalog Nbr
    8 COURSE_APPROVED Character(1) VARCHAR2(1) NOT NULL Course Approved
    A=Approved
    D=Denied
    P=Pending

    Default Value: P

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

    Prompt Table: CAMPUS_TBL

    10 SCHEDULE_PRINT Character(1) VARCHAR2(1) NOT NULL Schedule Print
    A=All
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: Y

    11 CATALOG_PRINT Character(1) VARCHAR2(1) NOT NULL Catalog Print

    Y/N Table Edit

    Default Value: Y

    12 SCHED_PRINT_INSTR Character(1) VARCHAR2(1) NOT NULL Print Instructor in Schedule
    A=All
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: Y

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

    Prompt Table: ACAD_ORG_SRCH

    14 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

    Prompt Table: CATLG_CAR_VW

    15 SPLIT_OWNER Character(1) VARCHAR2(1) NOT NULL Split Ownership

    Y/N Table Edit

    Default Value: N

    16 SCHED_TERM_ROLL Character(1) VARCHAR2(1) NOT NULL Schedule Term Roll

    Y/N Table Edit

    Default Value: Y

    17 RQRMNT_GROUP Character(6) VARCHAR2(6) NOT NULL Requirement Group

    Prompt Table: RQ_GRP_ENR_VW

    18 CIP_CODE Character(13) VARCHAR2(13) NOT NULL CIP code

    Default Value: SUBJECT_TBL.CIP_CODE

    Prompt Table: CIP_CODE_TBL

    19 HEGIS_CODE Character(8) VARCHAR2(8) NOT NULL HEGIS Code

    Default Value: SUBJECT_TBL.HEGIS_CODE

    Prompt Table: HEGIS_CODE_TBL

    20 USE_BLIND_GRADING Character(1) VARCHAR2(1) NOT NULL Use Blind Grading

    Y/N Table Edit

    Default Value: SUBJECT_TBL.USE_BLIND_GRADING

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

    Y/N Table Edit

    Default Value: N

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

    Prompt Table: BUS_UNIT_TBL_FS

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

    Prompt Table: LED_DEFN_TBL
    Set Control Field: AP_BUS_UNIT

    24 AP_ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account
    25 AP_DEPTID Character(10) VARCHAR2(10) NOT NULL Department
    26 AP_PROJ_ID Character(15) VARCHAR2(15) NOT NULL Project ID
    27 AP_PRODUCT Character(6) VARCHAR2(6) NOT NULL Product
    28 AP_FUND_CODE Character(5) VARCHAR2(5) NOT NULL Fund
    29 AP_PROG_CODE Character(5) VARCHAR2(5) NOT NULL Program
    30 AP_CLASS_FLD Character(5) VARCHAR2(5) NOT NULL Public Sector Financials Chart Field.
    31 AP_AFFILIATE Character(5) VARCHAR2(5) NOT NULL Public Sector Financials Chart Field
    32 AP_OP_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit
    33 AP_ALTACCT Character(10) VARCHAR2(10) NOT NULL Alternate Account
    34 AP_BUD_REF Character(8) VARCHAR2(8) NOT NULL Budget Reference Chartfield
    35 AP_CF1 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield number 1
    36 AP_CF2 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield number 2
    37 AP_CF3 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield number 3
    38 AP_AFF_INT1 Character(10) VARCHAR2(10) NOT NULL IntraUnit Affiliate1
    39 AP_AFF_INT2 Character(10) VARCHAR2(10) NOT NULL Operating Unit Affiliate
    40 WRITEOFF_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: BUS_UNIT_TBL_FS

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

    Prompt Table: LED_DEFN_TBL
    Set Control Field: WRITEOFF_BUS_UNIT

    42 WRITEOFF_ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account
    43 WRITEOFF_DEPTID Character(10) VARCHAR2(10) NOT NULL Department
    44 WRITEOFF_PROJ_ID Character(15) VARCHAR2(15) NOT NULL Project ID
    45 WRITEOFF_PRODUCT Character(6) VARCHAR2(6) NOT NULL Product
    46 WRITEOFF_FUND_CODE Character(5) VARCHAR2(5) NOT NULL Fund Code
    47 WRITEOFF_PROG_CODE Character(5) VARCHAR2(5) NOT NULL Program Code
    48 WRITEOFF_CLASS_FLD Character(5) VARCHAR2(5) NOT NULL Public Sector Financials Chart Field.
    49 WRITEOFF_AFFILIATE Character(5) VARCHAR2(5) NOT NULL Public Sector Financials Chart Field
    50 WRITEOFF_OP_UNIT Character(8) VARCHAR2(8) NOT NULL Writeoff Operating Unit
    51 WRITEOFF_ALTACCT Character(10) VARCHAR2(10) NOT NULL Writeoff Alternate Account
    52 WRITEOFF_BUD_REF Character(8) VARCHAR2(8) NOT NULL Budget Reference Chartfield
    53 WRITEOFF_CF1 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield number 1
    54 WRITEOFF_CF2 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield number 2
    55 WRITEOFF_CF3 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield number 3
    56 WRITEOFF_AFF_INT1 Character(10) VARCHAR2(10) NOT NULL IntraUnit Affiliate1
    57 WRITEOFF_AFF_INT2 Character(10) VARCHAR2(10) NOT NULL Writeoff Operating Unit Affiliate
    58 EXT_WRITEOFF Character(50) VARCHAR2(50) NOT NULL External Writeoff
    59 GL_INTERFACE_REQ Character(1) VARCHAR2(1) NOT NULL GL Interface Required

    Y/N Table Edit

    Default Value: N

    60 SEL_GROUP Character(10) VARCHAR2(10) NOT NULL Tuition Group

    Prompt Table: SEL_GROUP_IN_VW

    61 SCHEDULE_COURSE Character(1) VARCHAR2(1) NOT NULL Allow Course to be Scheduled

    Y/N Table Edit

    Default Value: Y

    62 DYN_CLASS_DATA Character(10) VARCHAR2(10) NOT NULL Dynamic Class Data Rule

    Default Value: ACAD_CAR_TBL.DYN_CLASS_DATA

    Prompt Table: DYN_CLASS_TVW2

    63 OEE_IND Character(1) VARCHAR2(1) NOT NULL Allow OEE Enrollment

    Y/N Table Edit

    Default Value: N

    64 OEE_DYN_DATE_RULE Character(10) VARCHAR2(10) NOT NULL OEE Dynamic Date Rule

    Prompt Table: DYN_CLASS_TVW1

    65 SSR_CRSE_TYPOFF_CD Character(10) VARCHAR2(10) NOT NULL Course Typically Offered

    Prompt Table: SSR_CRSE_TYPOFF

    66 SSR_AC_EXAM_ONLY Character(1) VARCHAR2(1) NOT NULL Exam Only Course

    Y/N Table Edit

    Default Value: N

    67 SCC_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Created By
    68 SCC_ROW_ADD_DTTM DateTime(26) TIMESTAMP Created
    69 SCC_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Updated By
    70 SCC_ROW_UPD_DTTM DateTime(26) TIMESTAMP Last Update Date/Time