Stout CDR Studnet Data View Documentation

Infoaccess
DATA VIEW NAME	CDR_STUDENT_STOUT
OVERVIEW	This table shows University of Wisconsin-Stout enrolled students counted as of the official Central Data Request (CDR) reporting date. The file contains all 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 --limit TERM by contains to term of interest (2000FA) --limit COURSE by > = greater or equal to 100 (excludes remedial courses) --limit SECTION by not contains section numbers 600 thru 899. These are Continuing Education sections; CE sections also have letters attached to the section number. You can highlight the block of them by holding down the shift key and moving the arrow keys. --limit STUDY_ABROAD_EXCHANGE to equal to I and N
LOAD FREQUENCY	The data is loaded at official reporting dates. Fall and Spring CDR data are submitted approximately the 6^th 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 3^rd 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.
Examples: 2000FA, 2000SP, 2000SU, 2000WIN.

NOTE THE NUMBER BEFORE EACH OF THE FOLLOWING DATA ELEMENTS REFERS TO THE CDR DATA FIELD NUMBER.

2010-STUDENT SOCIAL SECURITY NUMBER

NUMBER 9

A nine-digit unique number assigned by the Social Security Administration or other proper authorities.

2020- GENDER

CHAR 1

Indication of the gender of a student.
M Male
F Female

2030- RACE

CHAR 1

A code indicating the ancestry and/or racial heritage of the student.
A Asian or Pacific Islander
B Black, not of Hispanic/Latino origin
I American Indian or Alaskan Native
S Hispanic/Latino
W White, not of Hispanic/Latino origin
U Race Unknown

2035- SUB-CATEGORY - RACE/ETHNIC SUB-CATEGORY

CHAR 1

A code purporting to identity more specifically the ancestry and/or racial characteristics of the student.
S Southeast Asian
Blank All other students.

2040- BIRTHDATE

CHAR 6

The year and month in which a student was born.

2050- CITIZENSHIP, STATUS OF

CHAR 1

A code indicating whether the student is a U.S. citizen, a permanent resident to the U.S., non-resident alien, or refugee.
C U.S. citizen
P Permanent resident to the U.S./Resident Alien
A Non-resident Alien
R Refugee or political asylee

2060- VETERAN'S STATUS

CHAR 1

A veteran is a former member of the United States Army, Navy, Air Force, Marines, or Coast Guard who served on active duty and was discharged other than dishonorably.
Y Yes
N No

2080- ADDRESS-PERMANENT (ADDRESS AT TIME OF APPLICATION)

CHAR 8

An eight character code designating a student's address at the time he/she applies for admission. For students from Wisconsin, this field would be the WI county of origin code plus the five digit ZIP code. For students from the U.S. (or U.S. territory) but not from WI, this field would be the two digit state code plus the five digit zip code. For students not from the U.S. the field should be the three digit country code. Request values of codes from Data Custodian.

2090- HIGH SCHOOL CLASS SIZE

NUMBER 4

Actual number in graduating class - for new freshman.

2100- HIGH SCHOOL CLASS RANK

NUMBER 4

Numeric rank in high school graduating class -- the best is ranked 1. For new freshman.

2105- HIGH SCHOOL CLASS RANK PERCENTILE

NUMBER 2

The high school rank percentile - for new freshman.

2110- HIGH SCHOOL GRADUATED FROM

CHAR 6

Code from the CDR high school code table indicating the high school from which a resident new freshman student was graduated.
50*991 No high school diploma
50*992 Equivalent certification or diploma
50*993 Non Resident
50*994 Non-Wisconsin high school
50*995 Home School
50*999 High school no longer exists

2120- HIGH SCHOOL, DATE OF GRADUATION

NUMBER 4

The 4 digits of the year of graduation from a high school..

2130- INSTITUTION LAST ATTENDED

CHAR 4

(OTHER THAN CURRENT INSTITUTION)

This element is to be supplied for undergraduate transfer students who attended another institution of higher education during the last term that they were enrolled, other than during summer session. A four-digit code from the CDR college code structure indicating the institution, whether public or private, that the student attended. Request values of codes from Data Custodian.

2135- ADMISSION CATEGORY

CHAR 1

A code indicating one of four admission categories to which a new freshman is assigned by the Admissions Office upon being admitted to an institution. There are two general types of new freshmen admissions recognized by the Regent approved Freshmen Admissions Policy: conventional (applicant meets the institution's minimum requirements for admission) and non-conventional (applicant does not meet the institution's minimum requirements but has been admitted on the basis of other criteria). There are two admission categories per type.

Conventional Admissions
S Standard Admission Category
D Waitlisted Admission Category

Non-Conventional Admissions
O Older Admission Category
E Exception Admission Category

2145- ACT IND - ACT/SAT TEST INDICATOR

CHAR 1

A code indicating which standardized test score(s) if any, were submitted by a new freshman.
C ACT Enhanced Assessment composite score was submitted.
S SAT Combined score was submitted.
D Both ACT Enhanced Assessment composite and SAT combined scores were submitted.
W The standardized test score was waived.

2150- ACT COMPOSITE SCORE

CHAR 2

A numeric code that is the composite Enhanced ACT Assessment Score submitted by a new freshman.

2151- ACT ENGLISH TEST SCORE

CHAR 2

The numeric score earned by the student on the English test of the Enhanced American College Test (ACT) Assessment submitted by a new freshman.

2152- ACT MATHEMATICS TEST SCORE

CHAR 2

The numeric score earned by the student on the Mathematics test of the Enhanced ACT Assessment submitted by a new freshman.

2153- ACT READING TEST SCORE

CHAR 2

The Numeric score earned by the student on the Reading test of the Enhanced American College Test (ACT) Assessment submitted by a new freshman.

2154- ACT SCIENCE REASONING TEST

CHAR 2

The numeric score earned by the student on the Science Reasoning test of the Enhanced American College Test (ACT) Assessment submitted by a new freshman.

2155- SAT COMBINED SCORE

CHAR 4

A numeric code that is the combined Math and Verbal SAT scores submitted by a new freshman.

2190- PROFICIENCIES --NUMBER OF COMPETENCY BASED PROFICIENCIES

CHAR 1

The number of academic areas in which a new freshman applicant has competency evaluations

2195- ADMISSION DECISION - COMPETENCY BASED ADMISSION DECISION INDICATOR

CHAR 1

A code indicating whether the presence of Competency Based work was a factor in the final admission decision.
Y Competency Based work was a factor in the final admission decision.
N Competency Based work was not a factor in the final admission decision

2210- CLASSIFICATION

CHAR 1

A code indicating the current class level or year of a student (based upon institutionally defined credit levels and/or institution, school, or college acceptance actions).
A Freshman
B Sophomore
C Junior, Pharmacy 1
D Senior, Pharmacy 2 and 3
E Masters
F Education Specialist
G PhD (Pre-prelim)
H PhD (Post-prelim)
I Special (non-matriculated student assessed undergraduate fees, UW COLLEGES use only)
J Special (non-matriculated student assessed undergraduate fees, COMPREHENSIVE and DOCTORAL CLUSTER use only)
K Special (non-matriculated student assessed graduate fees)
L Law
M Medical
N High School
P Pharmacy Professional
S Wisconsin Resident Age 62 and over, audit only
T Wisconsin Resident receiving federal old age survivors and disability insurance benefits (OASDI), audit only
V Veterinary Medicine

2220- RESIDENT STATUS - FEE BASIS, CURRENT

CHAR 1

Resident status based upon determination by the Office of the Registrar.
R resident
M nonresident, Michigan compact
S nonresident, Minnesota compact
N nonresident, other

2230- REMEDIAL MATH REQUIREMENT(S)

CHAR 1

A code indicating whether or not a student has been identified by the institution at which the student is currently enrolled as needing remediation in the math area. This indicator must be reported each term for all new freshmen.
Y Student evaluated for remediation and identified as needing math remediation.
N Student evaluated for remediation and identified as not needing math remediation.
E Student exempted from institutional testing for mathematics remediation.
Blank Student has not been evaluated for or exempted from remediation.

2235- REMEDIAL ENGLISH REQUIREMENT(S)

CHAR 1

A code indicating whether or not a student has been identified by the institution at which the student is currently enrolled as needing remediation in the English area. This indicator should be reported each term for all new freshmen.
Y Student evaluated for remediation and identified as needing English remediation.
N Student evaluated for remediation and identified as not needing English remediation.
E Student exempted from institutional testing for English remediation.
Blank Student has not been evaluated for or exempted from remediation.

2240- ENTRANCE STATUS, CURRENT

CHAR 1

The entrance, or continuing, status of the student excluding senior citizens when he/she entered the institution this term.
N New, Undergrad-student
R Re-entry, applies to undergraduate, graduate and specials
C Continuing, applies to undergraduate, graduate and specials
T Transfer, does not apply to graduate or special students
S Combination Re-entry/transfer; does not apply to graduate or special students.

2250- CUMULATIVE GRADE POINT AVERAGE (CUM GPA)

CHAR 3

DECIMAL POSITION 9V99

The cumulative grade point average the degree-seeking undergraduate and graduate student has earned at your institution as of the "date of record" for the term or session. If a student has done undergraduate work at your institution and the student is now doing graduate or professional school studies at your institution, do not include the student's undergraduate work in the CUM GPA calculation of graduate and professional school students. CUM GPA must be based on a four-point scale, "A" equaling a 4.0 GPA. If your institution uses a different point scale, you must convert your values to the four-point scale as follows. [(GPA VALUE) * 4 / (MAXIMUM OF POINT SCALE)]

2251- CUMULATIVE GRADE POINT CREDITS (CUM GPC)

CHAR 3

DECIMAL POSITION 999V

The cumulative grade point credits the degree-seeking undergraduate and graduate student has earned at your institution as of the "date of record" for the term or session. This is the number of credits used to calculate the student's Cumulative Grade Point Average (DE 2250).

2255-TRANSFER GRADE POINT AVERAGE (TRANS GPA)

CHAR 3

DECIMAL POSITION 9V99

The cumulative grade point average that a transfer student (Entrance Status (DE 2240) = 'S' or 'T') earned at the Institution Last Attended (DE 2130) prior to transferring. Transfer GPA does not apply to graduate or special students. TRANS GPA must be based on a four-point scale, 'A' equaling a 4.0 GPA. If the value is based on a different point scale, you must convert the value to the four point scale as follows.[(GPA VALUE) * 4 / (MAXIMUM OF POINT SCALE)]

2260- YEAR ABROAD/EXCHANGE INDICATOR

CHAR 1

An indication that the student is engaged in an academic program abroad or involved in an exchange program this term. Either a U.W. student attending a non-UW institution ("away to" student) or an exchange student coming to a UW institution ("here from" student).

Year Abroad Student: A student in a U.W. study abroad program taking courses outside the geographical boundaries of the United States.

Exchange Student: A student involved in one-to-one exchange program, where the U.W. student pays the academic fees at a U.W. institution but attends an institution outside the U.W. ("away to") and the incoming ("here from") exchange student does not pay U.W. academic fees but is enrolled in U.W. coursework.

Y Year abroad: Engaged in year abroad program
E Exchange student: UW student involved in exchange program taking courses elsewhere and not currently enrolled in UW courses.
I Exchange student: Incoming exchange student.
N Student not engaged in either year abroad program or an exchange program.

2270- MAJOR 1, CURRENT

CHAR 5

13031 APPL DES
17012 APP MATH
20021 AP PSYCH
09011 APP TECH
10021 ART
08311 ART EDUCATION
09601 CONSTRUC
13062 DIETETIC
08231 CHILD ED
08011 EDUC
08561 CONSUMED
13061 FOOD NUT
13071 FOOD SYS
05061 BUS ADM
09255 G C M
08261 GUI-COUN
08561 HOME EC
05082 HSPTOUR
5081 HOSPTOUT
3051 HUMN DEV
08396 IN VO ED

09250 IND MAN
09252 IND TECH
08391 IND EDUC
09254 MGMT TEC
09131 MANU ENG
08381 MRKETING
13052 FAM THER
09253 PKG
20011 PSYCH
13033 RETAILMM
09511 RISK CON
08641 SCH PSYC
05077 SERV MGT
06023 TECH-COM
08391 TECH ED
07031 TELE SYS
05153 TRNG&DEV
99992 UNDCL MJ
8393 VOC ED
1521 VOC REHA
08397 VOC TECH

2270- MAJOR 2, CURRENT

CHAR 5

A code indicating the degree program in which a student intends to major at this institution.

2290- DEGREE SOUGHT 1 (GRADUATE DEGREES ONLY)

CHAR 5

A code signifying the graduate degree type sought at UW-Stout:

MS Master of Science

MSE Master of Science-Engineering

MSED Master of Science-Education

EDS Educational Specialist

2290- DEGREE SOUGHT 2 (GRADUATE DEGREES ONLY)

CHAR 5

A code signifying the graduate degree type sought:

MS Master of Science

MSE Master of Science-Engineering

MSED Master of Science-Education

EDS Educational Specialist

2420- DEGREE EARNED THIS TERM 1 (THIS INSTITUTION)

CHAR 5

A code signifying the degree type (B.A., B.S., etc.) earned by a student at UW-Stout in his major field of study in the current term being reported:

BA Bachelor of Arts

BFA Bachelor of Fine Arts

BS Bachelor of Science

MS Master of Science

MSE Master of Science-Engineering

MSED Master of Science-Education

EDS Educational Specialist

2420- - DEGREE EARNED THIS TERM 2 (THIS INSTITUTION)

CHAR 5

2430- MAJOR ASSOCIATED WITH DEGREE EARNED THIS TERM 1

CHAR 5

A code indicating the major(s) that was associated with the degree the student earned this Degree Earned This Term (This Institution) (DE 2420). Reported only for those students who actually received a degree this term.

2430- MAJOR ASSOCIATED WITH DEGREE EARNED THIS TERM 2

CHAR 5

2440- TEACHER EDUCATION COMPLETED THIS TERM (THIS INSTITUTION)

CHAR 1

An indication of whether or not a student has completed a teacher education program which meets teacher certification requirements in the current term being reported.
Y Yes
N No

2460- MATH REMEDIATION COMPLETED THIS TERM

CHAR 1

A code indicating whether or not a student who was identified as needing a remedial math course (or courses if more than one level of math remediation was required), successfully completed ALL his/her remedial math requirements.
Y Yes
N No

2465- ENGLISH REMEDIATION COMPLETED THIS TERM

CHAR 1

A code indicating whether or not a student who was identified as needing a remedial English course (or courses if more than one level of English remediation was required), successfully completed ALL his/her remedial English requirements.
Y Yes
N No

2500- WITHDRAWAL, DATE OF

CHAR 4

The date contained within the instruction period for the term on which the student withdrew from the University. Do not report this data element for Extended Degree Program students.

COURSE CREDITS TOTAL

CHAR 2

POST TERM FLAG

CHAR 1

Y Yes
N No

EXTRACT_DATE_TIME

DATE

The System generated date when the data was last refreshed.