This is an effective dated table.
| 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 begin with a space (eg. ' 101'), most likely 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 |
| |
| → | CRSE_ID - Course ID | Char6 | Course ID | ||
| → | CRSE_OFFER_NBR - Course Offering Nbr | Num2.0 | Offer Nbr | ||
| DYN_CLASS_DATA - Dynamic Class Data Rule | Char10 | Dynamic Data | |||
| → | 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 | 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 |
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.
