| Infoaccess | |
| DATA VIEW NAME | CDR_STUDENT_COURSES_STOUT |
| OVERVIEW |
This table shows University of Wisconsin-Stout courses with students enrolled associated with the official Central Data Request (CDR) reporting date. The file contains all courses for students who are enrolled in 102, 104, remedial, exchange program, CAPP, and study abroad courses. "Official" count students, students reported by UW System and included in Stout and System official data are obtained in the following manner: --Join CDR_STUDENT_COURSES_STOUT
and CDR_STUDENT_STOUT Tables by Person ID and Term |
| LOAD FREQUENCY | The data is loaded at official reporting dates. Fall and Spring CDR data are submitted approximately the 6th week of the semester. Post-term CDR data files are submitted approximately 3 months after the end of the semester. Winter Term CDR files are submitted by approximately the 3rd week in January, with Post-term submission in March. Summer CDR files are submitted the first week in September, with Post-term available the second week of October. Post-term status (Y,N) is a variable on CDR_STUDENT_STOUT. Some variables such as degree-earned are only filled when the Post-term status is marked Y. |
| DATA CUSTODIAN | Budget, Planning and Analysis - Tammy Cutsforth |
| AUTHORIZATION | You must receive approval to access data from the data custodian. For information about the authorization forms and the connections necessary, connect to the InfoAccess home page. |
| SPECIAL CONSIDERATIONS | |
| QUESTIONS | Contact:
Division of Information Technology Help Desk Phone: : 264-HELP (4357) |
| LAST UPDATED | 09/00
Data view created 01/01 Data Dictionary created . |
| FIELD DEFINITIONS | Key
fields are identified with an asterisk(*) Field Formats describe the field type and length. |
| CHAR2( N) or CHAR (N) - Alphanumeric field. (N) is the length of the field. Field contains letters and/or numbers. Example: CHAR (5) could contain ‘ABC12’ or ‘12345’ or ‘ABCDEF’ (N) is the length of the field. Field contains letters and/or numbers. | |
| NUM (N) - Numeric field. (N) is the length of the field. Field contains only numbers. Numbers with decimal points are represented as NUM (X.Y) X = total number of digits Y = the number of decimals after the decimal Examples: NUM (6,2) could contain 2500.12 NUM (6) could contain 000005 or 550000 | |
| DATE (XXXX) - Date field. (XXXX) is the format of the field. Date can be in various formats and date functions available based on your query tool can be used against the field. Examples: DATE (YYMMDD); DATE (YYDDD); DATE (DD-MM-YY) |
|
Field Name |
Format |
Description |
|---|---|---|
|
PERSON ID |
CHAR 7 |
A unique identifier for a person (applicant, student, instructor, etc.) assigned by Datatel system and will never be changed throughout the individual’s relationship with the University. This is not the same as Campus_ID.. |
|
TERM |
CHAR 7 |
Semester or term
of interest; formatted with 4 digit year and suffix of FA, SU, SP,
or WIN denoting term. |
|
NOTE THE NUMBER BEFORE EACH OF THE FOLLOWING DATA ELEMENTS REFERS TO THE CDR DATA FIELD NUMBER |
||
|
2300- CAC- CURRICULAR AREA CODE |
CHAR 4 |
A 4-digit code based upon the HEGIS taxonomy of instructional programs in higher education designating the primary disciplinary area in which the course is being offered within a department. |
|
2310- COURSE NUMBER |
CHAR 4 |
The campus number used to identify a specific course within a campus department's offerings.. |
|
2330- SECTION NUMBER |
CHAR 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 typeof instruction with the same faculty. Sections may not be artificially derived to serve other functions (i.e., number of credits registered for, student level, etc.), except for certain independent-study and field experience sections for which the section number is used to identify the instructor or "dummy" sections which are used when the actual section numbers are not available. If the Curricular Area and Course Number are submitted with dummy codes, the section number must be submitted as a dummy section (XXX). Sections described must actually exist and meet separately from other sections of the same course.. |
|
2320- COURSE, GRADE BASIS |
CHAR 1 |
A
code indicating whether a student is taking a course for grade points,
pass-fail, or audit. |
|
2340- STUDENT CREDITS BY SECTION |
CHAR 4 |
The number of credits associated with the course section. |
|
EXTRACT_DATE_TIME |
DATE |
The System generated date when the data was last refreshed. |
|
2300- Cac- Curricular Area Code |
Valid Codes |
|---|---|
|
Biology |
Cadd/Drafting |
|
Accounting |
Graphic Communications Management |
|
Business Management |
Transportation/Energy |
|
Business Marketing |
Art |
|
International Business |
Art History |
|
Business Retail |
Music |
|
Business Legal |
Theatre |
|
Service Management |
Design |
|
Media Technology |
French |
|
Computer Science |
German |
|
Business Management Information Systems |
Spanish |
|
Telecommunications Systems |
Russian |
|
Education |
Chinese |
|
College Of Human Development |
East Asian Languages And Literature |
|
Special Education |
Apparel Design/Manufacturing |
|
School Counseling |
Hospitality And Tourism |
|
School Psychology |
Food & Nutrition |
|
Human Development & Family Living |
English |
|
Counseling |
Literature |
|
Art Education |
Speech Communication |
|
Health |
Philosophy |
|
Marketing Education/Business Education |
Logic |
|
Technology Education |
Mathematics |
|
Physical Education & Athletics |
Statistics |
|
Vocational Rehabilitation |
Math, Stat & Computer Sci |
|
Vocational, Technical & Adult Education |
Physics |
|
Family & Consumer Sciences Education |
Chemistry |
|
Electricity/Electronics |
Applied Science |
|
Manufacturing Engineering |
Psychology |
|
Packaging |
Social Work |
|
Engineering Mechanics |
Anthropology |
|
College Of Technology, Engineering & Mana |
Economics |
|
Industrial Management |
History |
|
Architecture, Engineering & Construction |
Geography |
|
Power |
Political Science |
|
Design, Research, Development |
Sociology |
|
Manufacturing Technology |
College Of Arts & Sciences |
|
Cadd/Drafting |
Technology |
|
Graphic Communications Management |
Transdisciplinary |
|
Transportation/Energy |
Risk Control |
|
Art |
Womens Studies |
|
Art History |
Training & Human Resource Development |
|
Music |
|
|
Theatre |
|
|
Design |