InfoAccess

  

DATA VIEW NAME

IR_COHORT_DEMO_STOUT

OVERVIEW 

Contains demographic information and cohort information for all degree-seeking students who began at Stout in fall 1994 or later

LOAD FREQUENCY

Data is loaded annually

DATA CUSTODIAN

Budget Planning and Analysis - Meridith Wentz

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 InfoAccess Home Page

SPECIAL CONSIDERATIONS

  

QUESTIONS

Contact:  Division of Information Technology Help Desk
Phone:  264-HELP (4357)

LAST UPDATED

12/2003 – New view created.
7/2004 Twelve new fields were added
PROFICIENCY SURVEY
PROFICIENCY SURVEY DESC
TRAIN EXPECT SURVEY
TRAIN EXPECT SURVEY DESC
STUDENT QUEST SURVEY
STUDENT QUEST SURVEY DESC
STUDENT QUEST SURVEY2
STUDENT QUEST SURVEY2 DESC
ONE MINUTE SURVEY
ONE MINUTE SURVEY DESC

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

*SEQ NO

Number(15)

Sequential number generated as a key.

FIRST NAME

Varchar2(30)

First Name of person taking the survey.

LAST NAME

Varchar2(30)

Last Name of person taking the survey.

DOB

Date(19)

Date of Birth

COH YR

Number(2)

Cohort year
0=fall 1994
1=spring 1995
2=fall 1995
3=spring 1996
4=fall 1996
5=spring 1997
6=fall 1997
7=spring 1998
8=fall 1998
9=spring 1999
10=fall 1999
11=spring 2000
12=fall 2000
13=spring 2001
14=fall 2001
15=spring 2002
16=fall 2002

COH YR DESC

Varchar2(12)

Cohort year description

PERSON ID

Varchar2(7)

Student ID

ENTRY

Number(1)

Entrance status
1= first time freshmen (no special students)
2= transfer student (no special students)
3= transfer/re-entry student

ENTRY DESC

Varchar2(40)

Entrance status description

SSN

Varchar2(9)

Social Security Number

RACE

Number(1)

Race/ethnic category
1=Asian
2=Black
3=Indian
4=Hispanic
5=White
6=Alien/unknown
9=data missing

RACE DESC

Varchar2(20)

Race/ethnic category description

AGE

Number(2)

Age during first semester
0=data missing

TRAD NON

Number(1)

Traditional vs. Non-traditional student
1=traditional aged (less than 25)
2=non-traditional aged (25 or older)
0=data missing

TRAD NON DESC

Varchar2(40)

Traditional vs. Non-traditional student description

GENDER

Number(1)

Gender of student
1=male
2=female
0=data missing

GENDER DESC

Varchar2(15)

Gender of student description

FT PT

Number(1)

Full-time/part-time status during first semester
1=full-time
2=part-time
0=data missing

FT PT DESC

Varchar2(15)

Full-time/part-time status during first semester description

RESIDENT

Number(1)

Residency status
1=resident
2=non-resident (includes Minnesota residents)
0=data missing

RESIDENT DESC

Varchar2(35)

Residency status description

ACT COMP

Number(2)

ACT composite score
0=data missing

MAJOR 1

Number(5)

Major declared during first semester
5061= General Bus Admin
5077= Service Mgmt|
5081=Hotel, Rest & Tour Mgmt
6023=Tech Communic
7031=Telecomm Systems
8231=Early Childhood
8311=Art Education
8381=Marketing Educ
8391=Tech Educ
8397=Career Tech & Trng
8561=Fam/Cons Sci Educ
9011=Applied Tech (disc)
9131=Manu Eng
9250=Industrial Mgmt
9252=Engin Tech (formerly Indus tech)
9253=Packaging
9255=Graphic Comm Mgmt
9601=Construction
10021=Art
13014=HE in Business (disc)
13031=Apparel Des & Dev
13033=Ret Merch & Mgmt
13051=Hum Dev & Fam Stud
13052=Marriage & Fam Therapy
13062=Dietetics
13071=Food Systems & Tech
17012=Applied Math
20011=Psychology
21521=Voc Rehab
99992=Undecided/undeclared
0=data missing

MAJOR 1 DESC

Varchar2(35)

Major declared during first semester description

HSSIZE

Number(4)

Number of students in their high school Graduating class
0=data missing

HSRANK

Number(3)

High school class rank (the lower the number the better)
0=data missing

HS CLASS

Number(3)

High school rank percentile

PROFICIENCY SURVEY

Number(1)

Microsoft Office Self Proficiency Survey
0=Not seleced to participate
1=Selected to participate
PROFICIENCY SURVEY DESC Varchar2(50) Microsoft Office Self Proficiency Survey description

TRAIN EXPECT SURVEY

Number(1)

Training and Expectation Survey
0=Not seleced to participate
1=Selected to participate
TRAIN EXPECT SURVEY DESC Varchar2(50) Training and Expectation Survey description

STUDENT QUEST SURVEY

Number(1)

Student Questionnaire Survey
0=Not seleced to participate
1=Selected to participate
STUDENT QUEST SURVEY DESC Varchar2(50) Student Questionnaire Survey description

STUDENT QUEST SURVEY2

Number(1)

Student Questionnaire Survey2
0=Not seleced to participate
1=Selected to participate
STUDENT QUEST SURVEY2 DESC Varchar2(50) Student Questionnaire Survey2 description

ONE MINUTE SURVEY

Number(1)

One Minute Survey
0=Not seleced to participate
1=Selected to participate
ONE MINUTE SURVEY DESC Varchar2(50) One Minute Survey description

PARTICIPATE

Number(1)

Requested not to be surveyed again
0=N/A
1=Requested not to be surveyed again
PARTICIPATE DESC Varchar2(50) Participate description

LAST TERM ATTENDED

Varchar2(8)

Term last attended by the student

LAST UPDATE DATE TIME

Date(19)

The date and time this data was updated.
Format : YYYYMMDD HH24:MI:SS