InfoAccess

DATA VIEW NAME

IR_ACT_SURVEY_STOUT

OVERVIEW 

This table contains results from the annual ACT student opinion survey given to sophomores and juniors

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

None

QUESTIONS

Contact:  Division of Information Technology Help Desk

Phone:  (608) 264-HELP (4357)

LAST UPDATED

12/2003 – New view created.

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

Numeric identification

Year

NUMBER 4

Year Survey was Taken

Person ID

NUMBER 7

Personal Id

Record

NUMBER 1

‘1’

School

NUMBER 4

Institutional/Composite Code

Ssn

NUMBER 9

Social Security Number

Age

NUMBER 1

Age
1=18 or Under
2=19
3=20
4=21
5=22
6=23 to 25
7=26 to 29
8=30 to 39
9=40 to 61
0=62 or over

Race

NUMBER 1

 Racial/Ethnic Group
1 = African American or Black
2 = Native American (Indian, Alaskan, Hawaiian)
3 = Caucasian or White
4 = Mexican American, Mexican Origin
5 = Asian American, Oriental, Pacific Islander
6 = Puerto Rican, Cuban, Other Latino or Hispanic
7 = Other
8 = I prefer not to respond

Class

NUMBER 1

 Class Level at This College
1 = Freshman
2 = Sophomore
3 = Junior
4 = Senior
5 = Graduate or professional student
6 = Special student
7 = Other/unclassified
8 = Does not apply to this college

Purpose

NUMBER 1

 Purpose for Entering This College
1 = No definite purpose in mind
2 = To take a few job-related courses
3 = To take a few courses for self-improvement
4 = To take courses necessary for transferring to another college
5 = To obtain or maintain a certification
6 = To complete a Vocational/Technical Program
7 = To obtain an Associate Degree
8 = To obtain a Bachelor’s Degree
9 = To obtain a Master’s Degree
0 = To obtain a Doctorate or Professional Degree

Sex

NUMBER 1

Sex
 1=Male
 2=Female

Marital

NUMBER 1

Marital Status
 1=Unmarried
 2=Married
 3=Separated
 4=Prefer not to respond

Enroll

NUMBER 1

Hours Per week Currently Employed
 1=0 or only occasional jobs
 2=1 to 10
 3=11 to 20
 4=21 to 30
 5=31 to 40
 6=Over 40

Status

NUMBER 1

Enrollment Status
 1=Full-time
 2=Part-time

Tuition

NUMBER 1

Type of Tuition
 1=In-State
 2=Out-of-State
 3=Does not apply to this college

Residenc

NUMBER 1

Residence Classification at This College
 1=In=State
 2=Out-of-State
 3=International

Type Sch

NUMBER 1

Type of School Attended Prior to Attending This School
 1=High School
 2=Vocational/Technical School
 3=2-Year College/University
 4=4-Year College
 5=Graduate/Professional College
 6=Other

Residen2

NUMBER 1

Current College Residence
 1=College Residence Hall
 2=Fraternity or Sorority House
 3=College Married Student Housing
 4=Off-Campus Room or Apartment
 5=Home of Parents or Relatives
 6=Own Home
 7=Other

Aid

NUMBER 1

Receiving financial Aid
 1=Yes
 2=No

Major

NUMBER 3

College Major (78-931)
(See List of College Majors and Occupational Choices for codes)

Occupation

NUMBER 3

Occupational Choice (45-943)
(See List of College Majors and Occupational Choices for codes)

Advising

NUMBER 1

College Services, Part A-Usage - Academic advising services
 1=Not available at this college
 2=I have not used this service
 3=I have used this service

Counseling

NUMBER 1

College Services, Part A-Usage - Personal counseling services
 1=Not available at this college
 2=I have not used this service
 3=I have used this service

Career

NUMBER 1

College Services, Part A-Usage – Career planning services
 1=Not available at this college
 2=I have not used this service
 3=I have used this service

Placement

NUMBER 1

College Services, Part A-Usage – Job placement services
 1=Not available at this college
 2=I have not used this service
 3=I have used this service

Intramural

NUMBER 1

College Services, Part A-Usage - Recreational and intramural program services
 1=Not available at this college
 2=I have not used this service
 3=I have used this service

Library

NUMBER 1

College Services, Part A-Usage - Library facilities and services
 1=Not available at this college
 2=I have not used this service
 3=I have used this service

Health

NUMBER 1

College Services, Part A-Usage - Student health services
 1=Not available at this college
 2=I have not used this service
 3=I have used this service

Insurance

NUMBER 1

College Services, Part A-Usage - Student health insurance program
 1=Not available at this college
 2=I have not used this service
 3=I have used this service

Tutorial

NUMBER 1

College Services, Part A-Usage - College-sponsored tutorial services
 1=Not available at this college
 2=I have not used this service
 3=I have used this service

Aid Serv

NUMBER 1

College Services, Part A-Usage - Financial aid services
 1=Not available at this college
 2=I have not used this service
 3=I have used this service

Stu Emp

NUMBER 1

College Services, Part A-Usage - Student Employment services
 1=Not available at this college
 2=I have not used this service
 3=I have used this service

Res Hall

NUMBER 1

College Services, Part A-Usage - Residence hall services and programs
 1=Not available at this college
 2=I have not used this service
 3=I have used this service

Food

NUMBER 1

College Services, Part A-Usage - Food services
 1=Not available at this college
 2=I have not used this service
 3=I have used this service

Social

NUMBER 1

College Services, Part A-Usage - College-sponsored social activities
 1=Not available at this college
 2=I have not used this service
 3=I have used this service

Cultural

NUMBER 1

College Services, Part A-Usage - Cultural programs
 1=Not available at this college
 2=I have not used this service
 3=I have used this service

Orientat

NUMBER 1

College Services, Part A-Usage - College orientation program
 1=Not available at this college
 2=I have not used this service
 3=I have used this service

Credit B

NUMBER 1

College Services, Part A-Usage - Credit-by-examination program (PEP, CLEP, etc.)
 1=Not available at this college
 2=I have not used this service
 3=I have used this service

Honors

NUMBER 1

College Services, Part A-Usage - Honors program
 1=Not available at this college
 2=I have not used this service
 3=I have used this service

Computer

NUMBER 1

College Services, Part A-Usage - Computer services
 1=Not available at this college
 2=I have not used this service
 3=I have used this service

Transit

NUMBER 1

College Services, Part A-Usage - College mass transit services
 1=Not available at this college
 2=I have not used this service
 3=I have used this service

Parking

NUMBER 1

College Services, Part A-Usage - Parking facilities and services
 1=Not available at this college
 2=I have not used this service
 3=I have used this service

Veterans

NUMBER 1

College Services, Part A-Usage - Veterans services
 1=Not available at this college
 2=I have not used this service
 3=I have used this service

Day Care

NUMBER 1

College Services, Part A-Usage - Day care services
 1=Not available at this college
 2=I have not used this service
 3=I have used this service

Advisin2

NUMBER 1

College Services, Part B-Satisfaction - Academic advising services
 1=Very dissatisfied
 2=Dissatisfied
 3=Neutral
 4=Satisfied
 5=Very satisfied

Counse2

NUMBER 1

College Services, Part B-Satisfaction - Personal counseling services
 1=Very dissatisfied
 2=Dissatisfied
 3=Neutral
 4=Satisfied
 5=Very satisfied

Career2

NUMBER 1

College Services, Part B-Satisfaction - Career planning services
 1=Very dissatisfied
 2=Dissatisfied
 3=Neutral
 4=Satisfied
 5=Very satisfied

Placeme2

NUMBER 1

College Services, Part B-Satisfaction - Job placement services
 1=Very dissatisfied
 2=Dissatisfied
 3=Neutral
 4=Satisfied
 5=Very satisfied

Intram2

NUMBER 1

College Services, Part B-Satisfaction - Recreational and intramural program services
 1=Very dissatisfied
 2=Dissatisfied
 3=Neutral
 4=Satisfied
 5=Very satisfied

Librar2

NUMBER 1

College Services, Part B-Satisfaction - Library facilities and services
 1=Very dissatisfied
 2=Dissatisfied
 3=Neutral
 4=Satisfied
 5=Very satisfied

Health2

NUMBER 1

College Services, Part B-Satisfaction - Student health services
 1=Very dissatisfied
 2=Dissatisfied
 3=Neutral
 4=Satisfied
 5=Very satisfied

Insura2

NUMBER 1

College Services, Part B-Satisfaction - Student health insurance program
 1=Very dissatisfied
 2=Dissatisfied
 3=Neutral
 4=Satisfied
 5=Very satisfied

Tutoria2

NUMBER 1

College Services, Part B-Satisfaction - College-sponsored tutorial services
 1=Very dissatisfied
 2=Dissatisfied
 3=Neutral
 4=Satisfied
 5=Very satisfied

Aid2

NUMBER 1

College Services, Part B-Satisfaction - Financial aid services
 1=Very dissatisfied
 2=Dissatisfied
 3=Neutral
 4=Satisfied
 5=Very satisfied

Stu Em2

NUMBER 1

College Services, Part B-Satisfaction - Student Employment services
 1=Very dissatisfied
 2=Dissatisfied
 3=Neutral
 4=Satisfied
 5=Very satisfied

Res Hal2

NUMBER 1

College Services, Part B-Satisfaction - Residence hall services and programs
 1=Very dissatisfied
 2=Dissatisfied
 3=Neutral
 4=Satisfied
 5=Very satisfied

Food2

NUMBER 1

College Services, Part B-Satisfaction - Food services
 1=Very dissatisfied
 2=Dissatisfied
 3=Neutral
 4=Satisfied
 5=Very satisfied

Social2

NUMBER 1

College Services, Part B-Satisfaction-College - Sponsored social activities
 1=Very dissatisfied
 2=Dissatisfied
 3=Neutral
 4=Satisfied
 5=Very satisfied

Cultura2

NUMBER 1

College Services, Part B-Satisfaction - Cultural programs
 1=Very dissatisfied
 2=Dissatisfied
 3=Neutral
 4=Satisfied
 5=Very satisfied

Orienta2

NUMBER 1

College Services, Part B-Satisfaction - College orientation program
 1=Very dissatisfied
 2=Dissatisfied
 3=Neutral
 4=Satisfied
 5=Very satisfied

Credit2

NUMBER 1

College Services, Part B-Satisfaction - Credit-by-examination program (PEP, CLEP, etc.)
 1=Very dissatisfied
 2=Dissatisfied
 3=Neutral
 4=Satisfied
 5=Very satisfied

Honors2

NUMBER 1

College Services, Part B-Satisfaction - Honors program
 1=Very dissatisfied
 2=Dissatisfied
 3=Neutral
 4=Satisfied
 5=Very satisfied

Comput2

NUMBER 1

College Services, Part B-Satisfaction - Computer services
 1=Very dissatisfied
 2=Dissatisfied
 3=Neutral
 4=Satisfied
 5=Very satisfied

Transit2

NUMBER 1

College Services, Part B-Satisfaction - College mass transit services
 1=Very dissatisfied
 2=Dissatisfied
 3=Neutral
 4=Satisfied
 5=Very satisfied

Parking2

NUMBER 1

College Services, Part B-Satisfaction - Parking facilities and services
 1=Very dissatisfied
 2=Dissatisfied
 3=Neutral
 4=Satisfied
 5=Very satisfied

Veteran2

NUMBER 1

College Services, Part B-Satisfaction - Veterans services
 1=Very dissatisfied
 2=Dissatisfied
 3=Neutral
 4=Satisfied
 5=Very satisfied

Day Ca2

NUMBER 1

College Services, Part B-Satisfaction - Day care services
 1=Very dissatisfied
 2=Dissatisfied
 3=Neutral
 4=Satisfied
 5=Very satisfied

Testing

NUMBER 1

College Environment - Testing/grading system
 0=Does not apply
 1=Very dissatisfied
 2=Dissatisfied
 3=Neutral
 4=Satisfied
 5=Very satisfied

Course

NUMBER 1

College Environment - Course content in you major field
 0=Does not apply
 1=Very dissatisfied
 2=Dissatisfied
 3=Neutral
 4=Satisfied
 5=Very satisfied

Instruct

NUMBER 1

College Environment - Instruction in your major field
 0=Does not apply
 1=Very dissatisfied
 2=Dissatisfied
 3=Neutral
 4=Satisfied
 5=Very satisfied

Availabil

NUMBER 1

College Environment - Out-of-class availability of your instructors
 0=Does not apply
 1=Very dissatisfied
 2=Dissatisfied
 3=Neutral
 4=Satisfied
 5=Very satisfied

Attitude

NUMBER 1

College Environment - Attitude of the faculty toward students
 0=Does not apply
 1=Very dissatisfied
 2=Dissatisfied
 3=Neutral
 4=Satisfied
 5=Very satisfied

Variety

NUMBER 1

College Environment - Variety of courses offered at this college
 0=Does not apply
 1=Very dissatisfied
 2=Dissatisfied
 3=Neutral
 4=Satisfied
 5=Very satisfied

Class Zi

NUMBER 1

College Environment - Class size relative to the type of course
 0=Does not apply
 1=Very dissatisfied
 2=Dissatisfied
 3=Neutral
 4=Satisfied
 5=Very satisfied

Flexbil

NUMBER 1

College Environment - Flexibility to design your own program of study
 0=Does not apply
 1=Very dissatisfied
 2=Dissatisfied
 3=Neutral
 4=Satisfied
 5=Very satisfied

Avail Ad

NUMBER 1

College Environment - Availability of your advisor
0=Does not apply
1=Very dissatisfied
2=Dissatisfied
3=Neutral
4=Satisfied
5=Very satisfied

Value

NUMBER 1

College Environment - Value of the information provided by your advisor
 0=Does not apply
 1=Very dissatisfied
 2=Dissatisfied
 3=Neutral
 4=Satisfied
 5=Very satisfied

Preparat

NUMBER  1

College Environment - Preparation you are receiving for your future occupation
 0=Does not apply
 1=Very dissatisfied
 2=Dissatisfied
 3=Neutral
 4=Satisfied
 5=Very satisfied

Dmission

NUMBER 1

College Environment - General admission procedures 0=Does not apply
 1=Very dissatisfied
 2=Dissatisfied
 3=Neutral
 4=Satisfied
 5=Very satisfied

Financial

NUMBER 1

College Environment - Availability of financial aid information prior to enrolling
 0=Does not apply
 1=Very dissatisfied
 2=Dissatisfied
 3=Neutral
 4=Satisfied
 5=Very satisfied

Coll Inf

NUMBER 1

College Environment - Accuracy of college information you received before enrolling
 0=Does not apply
 1=Very dissatisfied
 2=Dissatisfied
 3=Neutral
 4=Satisfied
 5=Very satisfied

Catalog

NUMBER 1

College Environment - College catalog/admissions publications
 0=Does not apply
 1=Very dissatisfied
 2=Dissatisfied
 3=Neutral
 4=Satisfied
 5=Very satisfied

Voice

NUMBER 1

College Environment - Student voice in college policies
 0=Does not apply
 1=Very dissatisfied
 2=Dissatisfied
 3=Neutral
 4=Satisfied
 5=Very satisfied

Rules

NUMBER 1

College Environment - Rules governing Student conduct at this college
 0=Does not apply
 1=Very dissatisfied
 2=Dissatisfied
 3=Neutral
 4=Satisfied
 5=Very satisfied

Res Rule

NUMBER 1

College Environment - Residence hall rules and regulations
 0=Does not apply
 1=Very dissatisfied
 2=Dissatisfied
 3=Neutral
 4=Satisfied
 5=Very satisfied

Probation

NUMBER 1

College Environment - Academic probation and suspension policies
 0=Does not apply
 1=Very dissatisfied
 2=Dissatisfied
 3=Neutral
 4=Satisfied
 5=Very satisfied

Activity

NUMBER 1

College Environment - Purpose for which student activity fees are used
 0=Does not apply
 1=Very dissatisfied
 2=Dissatisfied
 3=Neutral
 4=Satisfied
 5=Very satisfied

Safety

NUMBER 1

College Environment - Personal security/safety at this campus
 0=Does not apply
 1=Very dissatisfied
 2=Dissatisfied
 3=Neutral
 4=Satisfied
 5=Very satisfied

Faciliti

NUMBER 1

College Environment - Classroom facilities
 0=Does not apply
 1=Very dissatisfied
 2=Dissatisfied
 3=Neutral
 4=Satisfied
 5=Very satisfied

Laboratory

NUMBER 1

College Environment - Laboratory facilities
 0=Does not apply
 1=Very dissatisfied
 2=Dissatisfied
 3=Neutral
 4=Satisfied
 5=Very satisfied

Athletic

NUMBER 1

College Environment - Athletic facilities
 0=Does not apply
 1=Very dissatisfied
 2=Dissatisfied
 3=Neutral
 4=Satisfied
 5=Very satisfied

Study

NUMBER 1

College Environment - Study areas
 0=Does not apply
 1=Very dissatisfied
 2=Dissatisfied
 3=Neutral
 4=Satisfied
 5=Very satisfied

Unions

NUMBER 1

College Environment - Student union
 0=Does not apply
 1=Very dissatisfied
 2=Dissatisfied
 3=Neutral
 4=Satisfied
 5=Very satisfied

Bookstore

NUMBER 1

College Environment - Campus bookstore
 0=Does not apply
 1=Very dissatisfied
 2=Dissatisfied
 3=Neutral
 4=Satisfied
 5=Very satisfied

Housing

NUMBER 1

College Environment - Availability of student housing
 0=Does not apply
 1=Very dissatisfied
 2=Dissatisfied
 3=Neutral
 4=Satisfied
 5=Very satisfied

Building

NUMBER 1

College Environment - General condition of buildings and grounds
 0=Does not apply
 1=Very dissatisfied
 2=Dissatisfied
 3=Neutral
 4=Satisfied
 5=Very satisfied

Registration

NUMBER 1

College Environment - General registration procedures
 0=Does not apply
 1=Very dissatisfied
 2=Dissatisfied
 3=Neutral
 4=Satisfied
 5=Very satisfied

Avail Co

NUMBER 1

College Environment - Availability of the courses you want at times you can take them
 0=Does not apply
 1=Very dissatisfied
 2=Dissatisfied
 3=Neutral
 4=Satisfied
 5=Very satisfied

Calendar

NUMBER 1

College Environment - Academic calendar for this college (e.g., semester or quarter system)
 0=Does not apply
 1=Very dissatisfied
 2=Dissatisfied
 3=Neutral
 4=Satisfied
 5=Very satisfied

Billing

NUMBER 1

College Environment - Billing and fee payment procedures
 0=Does not apply
 1=Very dissatisfied
 2=Dissatisfied
 3=Neutral
 4=Satisfied
 5=Very satisfied

Concern

NUMBER 1

College Environment - Concern for you as an individual
 0=Does not apply
 1=Very dissatisfied
 2=Dissatisfied
 3=Neutral
 4=Satisfied
 5=Very satisfied

Attit No

NUMBER 1

College Environment - Attitude of the college non-teaching staff toward students
 0=Does not apply
 1=Very dissatisfied
 2=Dissatisfied
 3=Neutral
 4=Satisfied
 5=Very satisfied

Harmony

NUMBER 1

College Environment - Racial harmony at this college
 0=Does not apply
 1=Very dissatisfied
 2=Dissatisfied
 3=Neutral
 4=Satisfied
 5=Very satisfied

Employment

NUMBER 1

College Environment - Opportunities for student employment
 0=Does not apply
 1=Very dissatisfied
 2=Dissatisfied
 3=Neutral
 4=Satisfied
 5=Very satisfied

Involvement

NUMBER 1

College Environment - Opportunities for personal involvement on campus activities
 0=Does not apply
 1=Very dissatisfied
 2=Dissatisfied
 3=Neutral
 4=Satisfied
 5=Very satisfied

Government

NUMBER 1

College Environment - Student government
 0=Does not apply
 1=Very dissatisfied
 2=Dissatisfied
 3=Neutral
 4=Satisfied
 5=Very satisfied

Religious

NUMBER 1

College Environment - Religious activities and programs
 0=Does not apply
 1=Very dissatisfied
 2=Dissatisfied
 3=Neutral
 4=Satisfied
 5=Very satisfied

Media

NUMBER 1

College Environment - Campus media (student newspaper, campus radio, etc.)
 0=Does not apply
 1=Very dissatisfied
 2=Dissatisfied
 3=Neutral
 4=Satisfied
 5=Very satisfied

Overall

NUMBER 1

College Environment - This college in general
 0=Does not apply
 1=Very dissatisfied
 2=Dissatisfied
 3=Neutral
 4=Satisfied
 5=Very satisfied

Last Update Date Time

DATE

The date and time these data were extracted.
Format: YYYYMMDD HH24:MI:SS