- DATA VIEW NAME
- CDR_COURSE
- OVERVIEW
- Provides the student course data submitted by UW-Madison for purposes of the CDR (Central Data Request) requested by UW System Administration. The dataview contains data for each of the four (4) most recent terms (since Fall 1999). For many of the data elements, UW-Madison data has been re-coded and/or re-defined to conform to the CDR specifications.
- 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
- Contact: Phillip Hull, Registrar’s Office
- 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 - QUESTIONS
- Contact: Division of Information Technology Help Desk
Phone: 264-HELP (4357) - LAST UPDATED
- 5/2000 – New view created.
5/2002 – Added Extract_Date_time field. - 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) | The starting year, ending year and semester a student is enrolled at UW-Madison first 2 digit ‘YY’ is the starting year the third ‘Y’ is the ending year the semester value are: 1 = Fall semester 2 = Spring semester S = Summer session. Examples: Summer 1999-2000 value is ‘990S Fall 2000-2001 value is ‘0011’ |
| UNIT | VARCHAR2(1) | A one-character code indicating one of the fourteen possible institutions. “A” in all submission from Madison campus. |
| DIVISION | VARCHAR2(2) | The level of organization immediately under that of Unit for theUW-centers. Blank for Madison Campus as this is for UW-centers only. |
| * EMPLID | VARCHAR2(11) | Emplid for this student |
| * SSN | VARCHAR2(9) | A nine-digit unique number assigned by the Social Security Administration or other proper authorities. Contains the first 9 digits of the CampusID in the event a studentdoes not have a valid Social Security Number. |
| *CURRICULAR_AREA | VARCHAR2(4) | A 4-digit discipline code assigned by UW System Administration. Example: Disciplinary area is English, General; This element is “1501” |
| *COURSE_NUMBER | VARCHAR2(4) | The campus number used to identify a specific course within a campus department’s offerings. Example:The course number for computer science 838 would be “838” |
| *COURSE_SECTION | VARCHAR2(5) | A five character unique identification for each section taught within each course. This identification must appear in the campus timetable file. A section is defined as a group of students meeting at the same time and in the same place for the same type of instruction with the same faculty. |
| GRADE_BASIS | VARCHAR2(1) | Indicates whether a student is taking a course for gradepoints, pass fall, or audit. Valid values: G = graded basis P = pass-fail A = audit O = other C = credit/no credit H = credit in college level course taught in a WI high school |
| CREDITS | NUMBER 2.2 | The number of credits in each course section for which a student is registered. Example: Number of prorated credits for section is 1-1/4:this element is “1.25” |
| EXTRACT_DATE_TIME | DATE | The date and time the data was last extracted from the source system. |
| LOAD_DATE | DATE | System generated date representing when the data was lasts loaded into the data warehouse. |