IR Alumni Survey Stout Data View Documentation

InfoAccess

IR_ALUMNI_SURVEY_STOUT

OVERVIEW

Contains results from the Alumni Follow-Up Survey which is given to UW-Stout graduates one and three years after graduation.

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/03 – 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
umbers. 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.

YEAR

Number(4)

Year survey conducted.

PERSON_ID

Varchar2(7)

Person Id from the Datatel system.

NAME

Varchar2(22)

Name of the respondent.

ID

Number(4)

Identification number assigned by Chris Ness.

SURVEYID

Number(4)

Identification number assigned by the BPA office.

GRADDATE

Number(4)

Date when graduated from UW-Stout.
1998 Graduated in 1998
2000 Graduated in 2000

PROGCODE

Number(3)

Name of academic program.
101 Tech Ed
102 Industrial Technology
103 Industrial Management
104 Voc/Tech/Adult Education
105 General Business Admin
106 Construction
107 Marketing Education
108 Manufacturing Engineering
109 Packaging
201 Human Dev and Family
202 Apparel Design/Manufacturing
203 Dietetics                       |
204 Early Childhood Education
205 Retail Merch and Mgmt
206 Food Systems and Tech
208 Family/Consumer Sci Educ
210 Hotel/Restaurant/Tour Mgmt
211 Graphic Comm Mgmt
212 Telecommunications
301 Applied Math
302 Art Ed
303 Art
304 Service Management
401 Psychology
402 Voc Rehab BS
503 Home Ec
504 Food Sci and Nutr
505 Ind/Tech Ed MS
506 Ind & Voc Educ EdS
507 School Psych MS508 Voc/Technic Ed MS
509 Guidance and Couns/Mentl
510 Voc Rehab MS
511 Management Tech512 Couns/Psych Serv EdS
513 Risk Control
514 Marriage and Family Therapy
515 Education
516 Hosp/Tour
517 Train & Devt
518 Applied Psychology
529 Guid & Couns/Schl

LEVEL

Number(1)

Undergraduate/graduate student.
Bachelors degree
Masters degree
3   Ed Specialist degree

ITEM_A01

Number(1)

If you had to do it over again, would you attend UW-Stout? (5 point scale)
1   Definitely no
3   Maybe
5   Definitely Yes

ITEM_A02

Number(1)

If you had to do it over again, would you enroll in the same program? (5-point scale).
1   Definitely no
3   Maybe
5   Definitely Yes

ITEM_B

Number(1)

How would you rate the overall effectiveness of your program (major)? (5-point scale).
1   Very low
3   Moderate
5   Very high

ITEM _C01

Number(1)

How important was your education at UW-Stout in contributing to your personal development in the following areas: write effectively (5-point scale).   None
Moderate
5    Strong

ITEM _C02

Number(1)

How important was your education at UW-Stout in contributing to your personal development in the following areas: speak or present ideas effectively (5-point scale).
1   None
3   Moderate
5   Strong

ITEM _C03

Number(1)

How important was your education at UW-Stout in contributing to your personal development in the following areas: use mathematics or statistics (5-point scale).
1   None
3   Moderate
5 5   Strong

ITEM _C04

Number(1)

How important was your education at UW-Stout in contributing to your personal development in the following areas: use computing and information technology (5-point scale).
1   None
3   Moderate
5   Strong

ITEM_C05

Number(1)

How important was your education at UW-Stout in contributing to your personal development in the following areas: solve problems (5-point scale).
1   None
3   Moderate
5   Strong

ITEM_C06

Number(1)

How important was your education at UW-Stout in contributing to your personal development in the following areas: organize information (5-point scale).
1   None
3   Moderate
5   Strong

ITEM_C07

Number(1)

How important was your education at UW-Stout in contributing to your personal development in the following areas: analyze information (5-point scale).
1   None
3   Moderate
5   Strong

ITEM_C08

Number(1)

How important was your education at UW-Stout in contributing to your personal development in the following areas: make decisions (5-point scale).
1   None
3   Moderate
5   Strong

ITEM_C09

Number(1)

How important was your education at UW-Stout in contributing to your personal development in the following areas: conduct a research study/project (5-point scale).
1   None
3   Moderate
5   Strong

ITEM_C10

Number(1)

How important was your education at UW-Stout in contributing to your personal development in the following areas: work in teams (5-point scale).
1   None
3   Moderate
5   Strong

ITEM_C11

Number(1)

How important was your education at UW-Stout in contributing to your personal development in the following areas: provide leadership (5-point scale).
1   None
3   Moderate
5   Strong

ITEM_C12

Number(1)

How important was your education at UW-Stout in contributing to your personal development in the following areas: think creatively (5-point scale).
1   None
3   Moderate
5   Strong

ITEM_C13

Number(1)

How important was your education at UW-Stout in contributing to your personal development in the following areas: understand diverse cultures (5-point scale).
1   None
3   Moderate
5   Strong

ITEM_C14

Number(1)

How important was your education at UW-Stout in contributing to your personal development in the following areas: care for your personal “wellness” (5-point scale).
1   None
3   Moderate
5   Strong

ITEM_C15

Number(1)

How important was your education at UW-Stout in contributing to your personal development in the following areas: develop a critically examined set of values (5-point scale).
1   None
3   Moderate
5   Strong

ITEM_C16

Number(1)

How important was your education at UW-Stout in contributing to your personal development in the following areas: develop an appreciation of the arts (5-point scale).
1   None
3   Moderate
5   Strong

ITEM_C17

Number(1)

How important was your education at UW-Stout in contributing to your personal development in the following areas: appreciate the need for racial equity (5-point scale).
1   None
3   Moderate
5   Strong

ITEM_D

Number(1)

If you have continued your education or currently continuing your education….are you enrolled fulltime or part-time?
1   Full-time
2   Part-time

ITEM_E

Number(1)

How well did UW-Stout prepare you for further education? (5-point scale)
1   Very poor
3   Moderate
5   Very good

ITEM_G01

Number(1)

Please indicate any additional degrees earned since you graduated from UW-Stout: Associate or Technical degree
2   No
1   Yes

ITEM_G02

Number(1)

Please indicate any additional degrees earned since you graduated from UW-Stout: Bachelor’s degree
2   No
1   Yes

ITEM_G03

Number(1)

Please indicate any additional degrees earned since you graduated from UW-Stout: Master’s degree
2   No
1   Yes

ITEM_G04

Number(1)

Please indicate any additional degrees earned since you graduated from UW-Stout: Educational Specialist’s degree
2   No
1   Yes

ITEM_G05

Number(1)

Please indicate any additional degrees earned since you graduated from UW-Stout: PhD
2   No
1   Yes

ITEM_G06

Number(1)

Please indicate any additional degrees earned since you graduated from UW-Stout: Certification
2   No
1   Yes

ITEM_G07

Number(1)

Please indicate any additional degrees earned since you graduated from UW-Stout: License
2   No
1   Yes

ITEM_G08

Number(1)

Please indicate any additional degrees earned since you graduated from UW-Stout: Other
2   No
1   Yes

ITEM_I

Number(1)

May we ask your employer to participate in our employment survey?
1   Yes
2   No

ITEM_J

Number(1)

Is your job related to your UW-Stout major?
1   Not related
2   Somewhat related
3   Directly related

ITEM_K

Number(6)

What is your annual full-time gross salary (before overtime, deductions and taxes)?

ITEM_L01

Number(1)

What is your current work/education status: employed full-time (35+ hours/week)
2   No
1   Yes

ITEM-L02

Number(1)

What is your current work/education status: employed part-time.
2   No
1   Yes

ITEM_L03

Number(1)

What is your current work/education status: full-time employed
2   No
1   Yes

ITEM_L04

Number(1)

What is your current work/education status: part-time student
2   No
1   Yes

ITEM_L05

Number(1)

What is your current work/education status: active military service
2   No
1   Yes

ITEM_L06

Number(1)

What is your current work/education status: full-time homemaker
2   No
1   Yes

ITEM_L07

Number(1)

What is your current work/education status: unemployed and seeking a job
2   No
1   Yes

ITEM_L08

Number(1)

What is your current work/education status: unemployed and not seeking a job
2   No
1   Yes

ITEM_M

Number(1)

How well did UW-Stout prepare you for employment? (5-point scale)
1   Very poor
3   Moderate
5   Very good

ITEM_N01

Number(1)

In thinking about your employment, how satisfied are you with your: level of career development (5-point scale)
1   Very dissatisfied
3   Satisfied
5   Very satisfied

ITEM_N02

Number(1)

In thinking about your employment, how satisfied are you with your: rate of advancement (5-point scale)
1   Very dissatisfied
3   Satisfied
5   Very satisfied

ITEM_O01

Number(1)

How would you rate the following aspects of your education at UW-Stout: Overall quality of instruction (5-point scale)
1   Very dissatisfied
3   Satisfied
5   Very satisfied

ITEM_O02

Number(1)

How would you rate the following aspects of your education at UW-Stout: Quality of instruction in courses directly related to your program of study (5-point scale)
1   Very dissatisfied Satisfied
5   Very satisfied

ITEM_O03

Number(1)

How would you rate the following aspects of your education at UW-Stout: Overall faculty availability (5-point scale)
1   Very dissatisfied Satisfied
5   Very satisfied

ITEM_O04

Number(1)

How would you rate the following aspects of your education at UW-Stout: The availability of faculty who taught courses in your programs (5-point scale)
1   Very dissatisfied
3   Satisfied
5   Very satisfied

ITEM_O05

Number(1)

How would you rate the following aspects of your education at UW-Stout: Course content (5-point scale)
1 Very dissatisfied
3   Satisfied
5   Very satisfied

ITEM_O06

Number(1)

How would you rate the following aspects of your education at UW-Stout: Course availability (5-point scale)
1   Very dissatisfied3   Satisfied
5   Very satisfied

ITEM_O07

Number(1)

How would you rate the following aspects of your education at UW-Stout: Course scheduling (time of day) (5-point scale)
1   Very dissatisfied
3   Satisfied
5   Very satisfied

ITEM_O08

Number(1)

How would you rate the following aspects of your education at UW-Stout: Quality of laboratory equipment (5-point scale)
1   Very dissatisfied
3   Satisfied
5   Very satisfied

ITEM_O09

Number(1)

How would you rate the following aspects of your education at UW-Stout: Quality of academic advising (5-point scale)
1   Very dissatisfied
3   Satisfied
5   Very satisfied

ITEM_P

Number(1)

Given the cost of education and your investment of time and effort, how would your rate the value of your education? (4-point scale)
1 Poor
2   Average
3   Good
4   Exceptional

ITEM_Q

Number(1)

How did your training at Stout compare to the training of people hired from other colleges at the same time you were hired, i.e. within six months of your first job? (4-point scale)
1   Much less prepared
2   Somewhat less prepared
3   Somewhat better prepared
4   Much better prepared
0   Cannot compare

ITEM_R

Number(1)

UW-Stout seeks to provide students with the skills to value diversity in personal and professional relationships. How would your rate the contribution of Stout’s ethnic studies class requirements to your development of these skills? (4-point scale)
1   Very little
2   Some
3   Quite a bit
4   Very much

LAST UPDATE DATE TIME

Date

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

InfoAccess	IR_ALUMNI_SURVEY_STOUT
OVERVIEW	Contains results from the Alumni Follow-Up Survey which is given to UW-Stout graduates one and three years after graduation.
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/03 – 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 umbers. 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.
YEAR	Number(4)	Year survey conducted.
PERSON_ID	Varchar2(7)	Person Id from the Datatel system.
NAME	Varchar2(22)	Name of the respondent.
ID	Number(4)	Identification number assigned by Chris Ness.
SURVEYID	Number(4)	Identification number assigned by the BPA office.
GRADDATE	Number(4)	Date when graduated from UW-Stout. 1998 Graduated in 1998 2000 Graduated in 2000
PROGCODE	Number(3)	Name of academic program. 101 Tech Ed 102 Industrial Technology 103 Industrial Management 104 Voc/Tech/Adult Education 105 General Business Admin 106 Construction 107 Marketing Education 108 Manufacturing Engineering 109 Packaging 201 Human Dev and Family 202 Apparel Design/Manufacturing 203 Dietetics \| 204 Early Childhood Education 205 Retail Merch and Mgmt 206 Food Systems and Tech 208 Family/Consumer Sci Educ 210 Hotel/Restaurant/Tour Mgmt 211 Graphic Comm Mgmt 212 Telecommunications 301 Applied Math 302 Art Ed 303 Art 304 Service Management 401 Psychology 402 Voc Rehab BS 503 Home Ec 504 Food Sci and Nutr 505 Ind/Tech Ed MS 506 Ind & Voc Educ EdS 507 School Psych MS508 Voc/Technic Ed MS 509 Guidance and Couns/Mentl 510 Voc Rehab MS 511 Management Tech512 Couns/Psych Serv EdS 513 Risk Control 514 Marriage and Family Therapy 515 Education 516 Hosp/Tour 517 Train & Devt 518 Applied Psychology 529 Guid & Couns/Schl
LEVEL	Number(1)	Undergraduate/graduate student. Bachelors degree Masters degree 3 Ed Specialist degree
ITEM_A01	Number(1)	If you had to do it over again, would you attend UW-Stout? (5 point scale) 1 Definitely no 3 Maybe 5 Definitely Yes
ITEM_A02	Number(1)	If you had to do it over again, would you enroll in the same program? (5-point scale). 1 Definitely no 3 Maybe 5 Definitely Yes
ITEM_B	Number(1)	How would you rate the overall effectiveness of your program (major)? (5-point scale). 1 Very low 3 Moderate 5 Very high
ITEM _C01	Number(1)	How important was your education at UW-Stout in contributing to your personal development in the following areas: write effectively (5-point scale). None Moderate 5 Strong
ITEM _C02	Number(1)	How important was your education at UW-Stout in contributing to your personal development in the following areas: speak or present ideas effectively (5-point scale). 1 None 3 Moderate 5 Strong
ITEM _C03	Number(1)	How important was your education at UW-Stout in contributing to your personal development in the following areas: use mathematics or statistics (5-point scale). 1 None 3 Moderate 5 5 Strong
ITEM _C04	Number(1)	How important was your education at UW-Stout in contributing to your personal development in the following areas: use computing and information technology (5-point scale). 1 None 3 Moderate 5 Strong
ITEM_C05	Number(1)	How important was your education at UW-Stout in contributing to your personal development in the following areas: solve problems (5-point scale). 1 None 3 Moderate 5 Strong
ITEM_C06	Number(1)	How important was your education at UW-Stout in contributing to your personal development in the following areas: organize information (5-point scale). 1 None 3 Moderate 5 Strong
ITEM_C07	Number(1)	How important was your education at UW-Stout in contributing to your personal development in the following areas: analyze information (5-point scale). 1 None 3 Moderate 5 Strong
ITEM_C08	Number(1)	How important was your education at UW-Stout in contributing to your personal development in the following areas: make decisions (5-point scale). 1 None 3 Moderate 5 Strong
ITEM_C09	Number(1)	How important was your education at UW-Stout in contributing to your personal development in the following areas: conduct a research study/project (5-point scale). 1 None 3 Moderate 5 Strong
ITEM_C10	Number(1)	How important was your education at UW-Stout in contributing to your personal development in the following areas: work in teams (5-point scale). 1 None 3 Moderate 5 Strong
ITEM_C11	Number(1)	How important was your education at UW-Stout in contributing to your personal development in the following areas: provide leadership (5-point scale). 1 None 3 Moderate 5 Strong
ITEM_C12	Number(1)	How important was your education at UW-Stout in contributing to your personal development in the following areas: think creatively (5-point scale). 1 None 3 Moderate 5 Strong
ITEM_C13	Number(1)	How important was your education at UW-Stout in contributing to your personal development in the following areas: understand diverse cultures (5-point scale). 1 None 3 Moderate 5 Strong
ITEM_C14	Number(1)	How important was your education at UW-Stout in contributing to your personal development in the following areas: care for your personal “wellness” (5-point scale). 1 None 3 Moderate 5 Strong
ITEM_C15	Number(1)	How important was your education at UW-Stout in contributing to your personal development in the following areas: develop a critically examined set of values (5-point scale). 1 None 3 Moderate 5 Strong
ITEM_C16	Number(1)	How important was your education at UW-Stout in contributing to your personal development in the following areas: develop an appreciation of the arts (5-point scale). 1 None 3 Moderate 5 Strong
ITEM_C17	Number(1)	How important was your education at UW-Stout in contributing to your personal development in the following areas: appreciate the need for racial equity (5-point scale). 1 None 3 Moderate 5 Strong
ITEM_D	Number(1)	If you have continued your education or currently continuing your education….are you enrolled fulltime or part-time? 1 Full-time 2 Part-time
ITEM_E	Number(1)	How well did UW-Stout prepare you for further education? (5-point scale) 1 Very poor 3 Moderate 5 Very good
ITEM_G01	Number(1)	Please indicate any additional degrees earned since you graduated from UW-Stout: Associate or Technical degree 2 No 1 Yes
ITEM_G02	Number(1)	Please indicate any additional degrees earned since you graduated from UW-Stout: Bachelor’s degree 2 No 1 Yes
ITEM_G03	Number(1)	Please indicate any additional degrees earned since you graduated from UW-Stout: Master’s degree 2 No 1 Yes
ITEM_G04	Number(1)	Please indicate any additional degrees earned since you graduated from UW-Stout: Educational Specialist’s degree 2 No 1 Yes
ITEM_G05	Number(1)	Please indicate any additional degrees earned since you graduated from UW-Stout: PhD 2 No 1 Yes
ITEM_G06	Number(1)	Please indicate any additional degrees earned since you graduated from UW-Stout: Certification 2 No 1 Yes
ITEM_G07	Number(1)	Please indicate any additional degrees earned since you graduated from UW-Stout: License 2 No 1 Yes
ITEM_G08	Number(1)	Please indicate any additional degrees earned since you graduated from UW-Stout: Other 2 No 1 Yes
ITEM_I	Number(1)	May we ask your employer to participate in our employment survey? 1 Yes 2 No
ITEM_J	Number(1)	Is your job related to your UW-Stout major? 1 Not related 2 Somewhat related 3 Directly related
ITEM_K	Number(6)	What is your annual full-time gross salary (before overtime, deductions and taxes)?
ITEM_L01	Number(1)	What is your current work/education status: employed full-time (35+ hours/week) 2 No 1 Yes
ITEM-L02	Number(1)	What is your current work/education status: employed part-time. 2 No 1 Yes
ITEM_L03	Number(1)	What is your current work/education status: full-time employed 2 No 1 Yes
ITEM_L04	Number(1)	What is your current work/education status: part-time student 2 No 1 Yes
ITEM_L05	Number(1)	What is your current work/education status: active military service 2 No 1 Yes
ITEM_L06	Number(1)	What is your current work/education status: full-time homemaker 2 No 1 Yes
ITEM_L07	Number(1)	What is your current work/education status: unemployed and seeking a job 2 No 1 Yes
ITEM_L08	Number(1)	What is your current work/education status: unemployed and not seeking a job 2 No 1 Yes
ITEM_M	Number(1)	How well did UW-Stout prepare you for employment? (5-point scale) 1 Very poor 3 Moderate 5 Very good
ITEM_N01	Number(1)	In thinking about your employment, how satisfied are you with your: level of career development (5-point scale) 1 Very dissatisfied 3 Satisfied 5 Very satisfied
ITEM_N02	Number(1)	In thinking about your employment, how satisfied are you with your: rate of advancement (5-point scale) 1 Very dissatisfied 3 Satisfied 5 Very satisfied
ITEM_O01	Number(1)	How would you rate the following aspects of your education at UW-Stout: Overall quality of instruction (5-point scale) 1 Very dissatisfied 3 Satisfied 5 Very satisfied
ITEM_O02	Number(1)	How would you rate the following aspects of your education at UW-Stout: Quality of instruction in courses directly related to your program of study (5-point scale) 1 Very dissatisfied Satisfied 5 Very satisfied
ITEM_O03	Number(1)	How would you rate the following aspects of your education at UW-Stout: Overall faculty availability (5-point scale) 1 Very dissatisfied Satisfied 5 Very satisfied
ITEM_O04	Number(1)	How would you rate the following aspects of your education at UW-Stout: The availability of faculty who taught courses in your programs (5-point scale) 1 Very dissatisfied 3 Satisfied 5 Very satisfied
ITEM_O05	Number(1)	How would you rate the following aspects of your education at UW-Stout: Course content (5-point scale) 1 Very dissatisfied 3 Satisfied 5 Very satisfied
ITEM_O06	Number(1)	How would you rate the following aspects of your education at UW-Stout: Course availability (5-point scale) 1 Very dissatisfied3 Satisfied 5 Very satisfied
ITEM_O07	Number(1)	How would you rate the following aspects of your education at UW-Stout: Course scheduling (time of day) (5-point scale) 1 Very dissatisfied 3 Satisfied 5 Very satisfied
ITEM_O08	Number(1)	How would you rate the following aspects of your education at UW-Stout: Quality of laboratory equipment (5-point scale) 1 Very dissatisfied 3 Satisfied 5 Very satisfied
ITEM_O09	Number(1)	How would you rate the following aspects of your education at UW-Stout: Quality of academic advising (5-point scale) 1 Very dissatisfied 3 Satisfied 5 Very satisfied
ITEM_P	Number(1)	Given the cost of education and your investment of time and effort, how would your rate the value of your education? (4-point scale) 1 Poor 2 Average 3 Good 4 Exceptional
ITEM_Q	Number(1)	How did your training at Stout compare to the training of people hired from other colleges at the same time you were hired, i.e. within six months of your first job? (4-point scale) 1 Much less prepared 2 Somewhat less prepared 3 Somewhat better prepared 4 Much better prepared 0 Cannot compare
ITEM_R	Number(1)	UW-Stout seeks to provide students with the skills to value diversity in personal and professional relationships. How would your rate the contribution of Stout’s ethnic studies class requirements to your development of these skills? (4-point scale) 1 Very little 2 Some 3 Quite a bit 4 Very much
LAST UPDATE DATE TIME	Date	The date and time the data was last updated. Format : YYYYMMDD HH24:MI:SS