CLASS_TBL - Class Table

Body

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

Details

Details

Article ID: 158814
Created
Fri 5/10/24 4:26 AM
Modified
Thu 9/12/24 4:22 PM
Applies To
Students
Faculty
Staff
Community

Related Services / Offerings

Related Services / Offerings (1)

DARTS (UMS Data) Inquiry
Submit an inquiry about UMS Data (except Data Governance)

Attachments

Attachments (9) Sort By: Sort Attachments ByName Sort Attachments ByDate

png

image2021-7-13_8-10-31.png Computer

Fri 5/10/24 4:26 AM
View
png

image2021-7-13_8-11-2.png Computer

Fri 5/10/24 4:26 AM
View
png

image2021-7-13_8-11-32.png Computer

Fri 5/10/24 4:26 AM
View
png

image2021-7-13_8-12-19.png Computer

Fri 5/10/24 4:26 AM
View
png

image2021-7-13_8-12-56.png Computer

Fri 5/10/24 4:26 AM
View
png

image2021-7-13_8-13-31.png Computer

Fri 5/10/24 4:26 AM
View
png

image2021-7-13_8-14-26.png Computer

Fri 5/10/24 4:26 AM
View
png

image2021-7-13_8-8-55.png Computer

Fri 5/10/24 4:26 AM
View
png

image2021-7-13_8-9-30.png Computer

Fri 5/10/24 4:26 AM
View
;