CRSE_OFFER - Course Catalog Offerings

 

WARNING: Field Name Definitions are Linked to the UMS Data Cookbook - this requires a University of Maine System ID and password

This Table includes Institutional Course Catalog Offerings detail

Detailed Information

Databases

PeopleSoft Campus Solutions CSPRD 
PeopleSoft Campus Solutions Reporting CSRPT

Key Record.Fieldname Format XLAT Heading Text Notes
  ACAD_CAREER - Academic Career Char4   Career  
  ACAD_GROUP - Academic Group Char5   Acad Group  
  ACAD_ORG - Academic Organization Char10   Acad Org  
  AP_ACCOUNT - Account Char10   Account  
  AP_AFFILIATE - Affiliate Char5   Affl  
  AP_AFF_INT1 - Fund Affiliate Char10   Fund Affil  
  AP_AFF_INT2 - Operating Unit Affiliate Char10   Oper Unit Affil  
  AP_ALTACCT - Alternate Account Char10   Alt. Account  
  AP_BUD_REF - Budget Reference Char8   Budget Ref  
  AP_BUS_UNIT - Business Unit Char5   Bus Unit  
  AP_CF1 - Chartfield 1 Char10   Chartfield1  
  AP_CF2 - Chartfield 2 Char10   Chartfield2  
  AP_CF3 - Chartfield 3 Char10   Chartfield3  
  AP_CLASS_FLD - Class Char5   Class  
  AP_DEPTID - Department Char10   DeptID  
  AP_FUND_CODE - Fund Char5   Fund  
  AP_LEDGER - Ledger Char10   Ledger  
  AP_OP_UNIT - Operating Unit Char8   Operating Unit  
  AP_PRODUCT - Product Char6   Prod  
  AP_PROG_CODE - Program Char5   Program  
  AP_PROJ_ID - Project ID Char15   Project  
  CAMPUS - Campus Char5   Campus  
  CATALOG_NBR - Catalog Nbr Char10   Catalog

CATALOG_NBR field values may begin with a space (eg. ' 101'), to insert a space between SUBJECT and CATALOG_NBR. (eg. ENG 101).
  CATALOG_PRINT - Catalog Print Char1   Cat Print  
  CIP_CODE - CIP Code Char13   CIP Code  
  COURSE_APPROVED - Course Approved Char1 N Approved

FIELD
VALUE DESCR
    A     Approved
    D     Denied
    P     Pending
Key CRSE_ID - Course ID Char6   Course ID  
Key CRSE_OFFER_NBR - Course Offering Nbr Num2.0   Offer Nbr  
  DYN_CLASS_DATA - Dynamic Class Data Rule Char10   Dynamic Data  
Key EFFDT - Effective Date Date   Eff Date  
  EXT_WRITEOFF - External Writeoff Char50   Ext Wrtoff  
  GL_INTERFACE_REQ - GL Interface Required Char1   Required Y (Yes) or N (No)
  HEGIS_CODE - HEGIS Code Char8   HEGIS Code  
  INSTITUTION - Academic Institution Char5   Institution  
  OEE_DYN_DATE_RULE - OEE Dynamic Date Rule Char10   OEE Dynamic Dt  
  OEE_IND - Allow OEE Enrollment Char1   Allow OEE Enrl Y (Yes) or N (No)
  RCV_FROM_ITEM_TYPE - Receivables From Item Type Char1   From ItemTyp Y (Yes) or N (No)
  RQRMNT_GROUP - Requirement Group Char6   Rq Group  
  SCC_ROW_ADD_DTTM - Created DateTm   Created  
  SCC_ROW_ADD_OPRID - Created By Char30   Created By  
  SCC_ROW_UPD_DTTM - Last Update Date/Time DateTm   Updated  
  SCC_ROW_UPD_OPRID - Updated By Char30   By  
  SCHEDULE_COURSE - Allow Course to be Scheduled Char1   Schedule Course Y (Yes) or N (No)
  SCHEDULE_PRINT - Schedule Print Char1   Sch Print Y (Yes) or N (No)
  SCHED_PRINT_INSTR - Print Instructor in Schedule Char1   Print Y (Yes) or N (No)
  SCHED_TERM_ROLL - Schedule Term Roll Char1   Term Roll Y (Yes) or N (No)
  SEL_GROUP - Tuition Group Char10   Group  
  SPLIT_OWNER - Split Ownership Char1   Split Ownr Y (Yes) or N (No)
  SSR_AC_EXAM_ONLY - Exam Only Course Char1   Exam Only Y (Yes) or N (No)
  SSR_CRSE_TYPOFF_CD - Course Typically Offered Char10   Typically Offer  
  SUBJECT - Subject Area Char8   Subject  
  USE_BLIND_GRADING - Use Blind Grading Char1   Blind Grd Y (Yes) or N (No)
  WRITEOFF_ACCOUNT - Account Char10   Account  
  WRITEOFF_AFFILIATE - Affiliate Char5   Affl  
  WRITEOFF_AFF_INT1 - Fund Affiliate Char10   Fund Affil  
  WRITEOFF_AFF_INT2 - Operating Unit Affiliate Char10   Oper Unit Affil  
  WRITEOFF_ALTACCT - Alternate Account Char10   Alt. Account  
  WRITEOFF_BUD_REF - Budget Reference Char8   Budget Ref  
  WRITEOFF_BUS_UNIT - Business Unit Char5   Bus Unit  
  WRITEOFF_CF1 - Chartfield 1 Char10   Chartfield1  
  WRITEOFF_CF2 - Chartfield 2 Char10   Chartfield2  
  WRITEOFF_CF3 - Chartfield 3 Char10   Chartfield3  
  WRITEOFF_CLASS_FLD - Class Field Char5   Class  
  WRITEOFF_DEPTID - Department Char10   DeptID  
  WRITEOFF_FUND_CODE - Fund Code Char5   Fund  
  WRITEOFF_LEDGER - Ledger Char10   Ledger  
  WRITEOFF_OP_UNIT - Operating Unit Char8   Operating Unit  
  WRITEOFF_PRODUCT - Product Char6   Prod  
  WRITEOFF_PROG_CODE - Program Code Char5   Program  
  WRITEOFF_PROJ_ID - Project ID Char15   Project  

 

Print Article

Details

Article ID: 158819
Created
Fri 5/10/24 4:26 AM
Modified
Thu 9/12/24 11:30 AM
Applies To
Faculty
Staff
Community