| Key | Record.Fieldname | Format | XLAT | Heading Text | Notes |
|---|---|---|---|---|---|
| ACAD_CAREER - Academic Career | Char4 | N | Career |
| |
| 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 | |||
| → | CLASS_SECTION - Class Section | Char4 | Section | ||
| CLASS_STAT - Class Status | Char1 | N | Class Stat |
| |
| CLASS_TYPE - Class Type | Char1 | N | Class Type |
| |
| CNCL_IF_STUD_ENRLD - Cancel if Student Enrolled | Char1 | Cancel Enroll | |||
| COMBINED_SECTION - Combined Section | Char1 | N | Comb Sect |
| |
| CONSENT - Type of Consent Required | Char1 | N | Consent |
| |
| CRS_TOPIC_ID - Course Topic ID | Num3.0 | Topic ID | |||
| → | CRSE_ID - Course ID | Char6 | Course ID | ||
| → | 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 |
| |
| 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 |
| |
| 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 | ||||
| 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 | |||
| → | SESSION_CODE - Session | Char3 | Session | ||
| SSR_COMPONENT - Course Component | Char3 | Component | |||
| SSR_DROP_CONSENT - Type of Consent Required | Char1 | N | Drop Consent |
| |
| START_DT - Start Date | Date | Start Date | |||
| STDNT_SPEC_PERM - Student Specific Permissions | Char1 | Stdnt Spec | |||
| → | 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 |
| |
| 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 |
Data Dictionary Links
Clicking the linked (blue) fields in any table will take you to the Data Dictionary and provide you with more information about that field as well as field values if they are available.
Attachments:
image2021-7-13_8-8-55.png (image/png)
image2021-7-13_8-9-30.png (image/png)
image2021-7-13_8-10-31.png (image/png)
image2021-7-13_8-11-2.png (image/png)
image2021-7-13_8-11-32.png (image/png)
image2021-7-13_8-12-19.png (image/png)
image2021-7-13_8-12-56.png (image/png)
image2021-7-13_8-13-31.png (image/png)
image2021-7-13_8-14-26.png (image/png)