- DATA VIEW NAME
- CDR_CROSSLIST
- OVERVIEW
- This data view is a companion for the 8-week frozen CDR_CURRICULAR data view. This data view provides combined section information extracted from ISIS at the same time as the rest of the CDR data. All combination types are included:
crosslisted (XL)
meetswith (MW)
section-level meetswith (SL)
crosslist-meetswith (XM)Combination members are included regardless of status or lack of enrollments. A combined section group has one primary section and one or more secondary sections. The primary section is the controlling section for the group. Combined sections meet together. In this data view, there will be a row for each member of the group, including the primary. - LOAD FREQUENCY
- This view is updated on request by the Registrar’s Office. Fall and Spring terms would typically be added at the end of the eighth week of the term. Summer terms would typically be added the last week of August. Sometimes, preliminary versions may be loaded prior to the “official” run.
- DATA CUSTODIAN
- Register’s Office
Contact: Phil Hull - AUTHORIZATION
- You must receive approval to access data from the data custodian. For information about how to get authorized for InfoAccess data views, connect to the InfoAccess Home Page
- SPECIAL
CONSIDERATIONS - Desc
- QUESTIONS
- Contact: Division of Information Technology Help Desk
Phone: 264-HELP (4357) - LAST UPDATED
- 8/2002 New VieW
06/2008 – Data Custodian change. C4j
01/2010 – Data Custodian Change C4j
09/2012 – Data Custodian Contact changed from Karen Hanon to Kim Alling - DATA FORMATS
- Primary Key Columns are identified with an asterisk(*)
- Alphanumeric Data
- VARCHAR2( N) (N) = maximum length. Field contains letters and/or numbers. Trailing blanks are eliminated.
Example: VARCHAR2 (5) could contain ‘ABC12’ or ‘ABC’ or ‘A’ - Numeric Data
- NUMBER (N) (N) = length. Field contains only numbers.
NUMBER (X,Y) = format for numbers with decimal positions.
X = total number of digits
Y = the number of digits after the decimal
Examples: NUMBER (6) represents 250012 NUMBER (6,2) represents 2500.12 - Date
- DATE – Date can be in various formats. Date functions available with your query tool can be used to format the date.
Examples: DATE (YYYYMMDD), DATE (YYDDD), DATE (DD-MM-YY)
| Column Name | Format | Description |
|---|---|---|
| *CDR_YEAR_SEM | Varchar2(4) | School term in CDR (not ISIS) format |
| *UNIT | Varchar2(1) | A one-character code indicating one of the fourteen possible institutions. “A” always submitted for Madison campus. |
| *DIVISION | Varchar2(2) | The level of organization immediately under that of Unit for the UW-centers. Blank for Madison Campus as this is for UW-centers only. |
| *PRIMARY_CAC | Varchar2(4) | A 4-digit discipline code assigned by UW System Administration. Example: for the disciplinary area, English-General, this element is “1501”. |
| *PRIMARY_COURSE_NBR | Varchar2(4) | COURSE_NBR is the (typically 3-digit) catalog number of a course. In the CDR tables, a course is identified by ‘AAAA-CCC’ where ‘AAAA’ is the CAC (see above) and ‘CCC’ is the catalog number. E.g. Algebra, a course in the Math department, is ‘1701-112’. This is the ISIS ‘catalog_nbr’, but formatted for the data warehouse. |
| *PRIMARY_CDR_SECT_SS | Varchar2(5) | CDR_SECT_SS is the (typically 3-digit) class section number (ISIS class_section) with a (typically 1-digit) numeric suffix if the section exists in multiple sessions. |
| *MEMBER_CAC | Varchar2(4) | See PRIMARY_CAC above for definition of CAC. |
| *MEMBER_COURSE_NBR | Varchar2(4) | See PRIMARY_COURSE_NBR above for definition of COURSE_NBR. |
| *MEMBER_CDR_SECT_SS | Varchar2(5) | See PRIMARY_CDR_SECT_SS above for a definition of CDR_SECT_SS. |
| Extract_Date_Time | Date | The date and time the data was extracted from the source system. |