CLASS_TBL - Class Table

This Table includes Institutional Academic Classes  detail

Detailed Information

Databases

PeopleSoft Campus Solutions CSPRD and Campus Solutions Reporting CSRPT

 

Key Fields Record.Fieldname Format XLAT Heading Text Notes
  ACAD_CAREER - Academic Career Char4 N Career

GRAD - Graduate
LAW - Law
NCRD - Non Credit
PBAC - Post-Baccalaureate
SSC - Student Success Center
UGRD -  Undergraduate

  ACAD_GROUP - Academic Group Char5   Acad Group  
  ACAD_ORG - Academic Organization Char10   Acad Org  
  AP_ACCOUNT - Account Char10   Account  
  AP_AFF_INT1 - Fund Affiliate Char10   Fund Affil  
  AP_AFF_INT2 - Operating Unit Affiliate Char10   Oper Unit Affil  
  AP_AFFILIATE - Affiliate Char5   Affl  
  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  
  ASSOCIATED_CLASS - Associated Class Num4.0   Assoc  
  ATTEND_GENERATE - Generate Class Mtg Attendance Char1   Generate  
  ATTEND_SYNC_REQD - Sync Attendance with Class Mtg Char1   Synch Mtg  
  AUTO_ENRL_WAITLIST - Auto Enroll from Wait List Char1   Auto Enrol  
  AUTO_ENROLL_SECT_1 - 1st Auto Enroll Section Char4   Auto Enrol  
  AUTO_ENROLL_SECT_2 - 2nd Auto Enroll Section Char4   Auto Enr 2  
  CAMPUS - Campus Char5   Campus  
  CAMPUS_EVENT_NBR - Event ID Char9   Event ID  
  CANCEL_DT - Cancel Date Date   Cancel Dt  
  CATALOG_NBR - Catalog Nbr Char10   Catalog  
  CLASS_NBR - Class Nbr Num5.0   Class Nbr  
Key CLASS_SECTION - Class Section Char4   Section  
  CLASS_STAT - Class Status Char1 N Class Stat

A - Active
S - Stop Further Enrollment
T - Tentative Section
X - Cancelled Section

  CLASS_TYPE - Class Type Char1 N Class Type

E - Enrollment Section
N - Non-Enrollment Section

  CNCL_IF_STUD_ENRLD - Cancel if Student Enrolled Char1   Cancel Enroll  
  COMBINED_SECTION - Combined Section Char1 N Comb Sect

C - Combined Section
S - Combined Section Skip Mtg Pat

  CONSENT - Type of Consent Required Char1 N Consent

D - Department Consent Required
I - Instructor Consent Required
N - No Special Consent Required

  CRS_TOPIC_ID - Course Topic ID Num3.0   Topic ID  
Key CRSE_ID - Course ID Char6   Course ID  
Key CRSE_OFFER_NBR - Course Offering Nbr Num2.0   Offer Nbr  
  DESCR - Description Char30   Descr  
  DYN_DT_CALC_REQ - Dynamic Date Calc Required Char1   Calc Reqd  
  DYN_DT_INCLUDE - Include in Dynamic Date Calc Char1   Include  
  EMPLID - Empl ID Char11   ID  
  END_DT - End Date Date   End Date  
  ENRL_CAP - Enrollment Capacity Num4.0   Cap Enrl  
  ENRL_STAT - Enrollment Status Char1 N Enrl Stat

C - Closed
O - Open
W - Wait List

  ENRL_TOT - Enrollment Total Num4.0   Tot Enrl  
  EQUIV_CRSE_ID - Equivalent Course Group Char5   Equiv Crs  
  EXAM_SEAT_SPACING - Exam Seat Spacing Num1.0   Exam Spcng  
  EXT_WRITEOFF - External Writeoff Char50   Ext Wrtoff  
  FEES_EXIST - Fees Exist Flag Char1   Fees Exist  
  GL_INTERFACE_REQ - GL Interface Required Char1   Required  
  HOLIDAY_SCHEDULE - Holiday Schedule Char6   Hol Sched  
  INSTITUTION - Academic Institution Char5   Institution  
  INSTRUCTION_MODE - Instruction Mode Char2   Mode  
  LMS_CLASS_EXT_DTTM - Last LMS Class Extract Datetm DateTm   Class Ext Dttm  
  LMS_ENRL_EXT_DTTM - Last LMS Enroll Extract Datetm DateTm   Enrl Ext Dttm  
  LMS_FILE_TYPE - LMS Extract File Type Char3 N Extract Type

BKB - Blackboard CourseInfo 4
WCT - API Input (old WebCT format)
XML - XML V1.1 (req to authenticate)

  LMS_GROUP_ID - LMS Extract Group ID Char50   LMS Group ID  
  LMS_PROVIDER - Provider for Authentication Char30   Authentication  
  LMS_URL - LMS URL Char254   LMS URL  
  LOCATION - Location Code Char10   Location  
  MIN_ENRL - Minimum Enrollment Number Num4.0   Min Enrl  
  NEXT_STDNT_POSITIN - Next Student Position Num8.0   Next Pos  
  OVRD_CRSE_EQUIV_ID - Override Equivalent Course Char1   Override  
  PRIM_INSTR_SECT - Primary Instructional Section Char4   Prim Sect  
  PRINT_TOPIC - Print Topic in Schedule Char1   Print  
  RCV_FROM_ITEM_TYPE - Receivables From Item Type Char1   From ItemTyp  
  RESECTION - Resection to Section Char4   Resection  
  ROOM_CAP_REQUEST - Requested Room Capacity Num4.0   Req Rm Cap  
  SCHEDULE_PRINT - Schedule Print Char1   Sch Print  
Key SESSION_CODE - Session Char3   Session  
  SSR_COMPONENT - Course Component Char3   Component  
  SSR_DROP_CONSENT - Type of Consent Required Char1 N Drop Consent

I - Instructor Consent Required
N - No Special Consent Required
D - Department Consent Required

  START_DT - Start Date Date   Start Date  
  STDNT_SPEC_PERM - Student Specific Permissions Char1   Stdnt Spec  
Key STRM - Term Char4   Term  
  SUBJECT - Subject Area Char8   Subject  
  WAIT_CAP - Wait List Capacity Num4.0   Wait Cap  
  WAIT_TOT - Wait List Total Num4.0   Wait Tot  
  WAITLIST_DAEMON - WAITLIST DAEMON SWITCH Char2 N WL Daemon
 C - Candidates Still on Wait List
N - No processing needed
R - Yes-initiated by Reserve Cap
Y - Yes-needs processi
  WRITEOFF_ACCOUNT - Account Char10   Account  
  WRITEOFF_AFF_INT1 - Fund Affiliate Char10   Fund Affil  
  WRITEOFF_AFF_INT2 - Operating Unit Affiliate Char10   Oper Unit Affil  
  WRITEOFF_AFFILIATE - Affiliate Char5   Affl  
  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  

 

Environment

PeopleSoft Campus Solutions