EOAA Exit Intervw Stout Data View Documentation

InfoAccess
DATA VIEW NAME	EOAA_EXIT_INTERVW_STOUT
OVERVIEW	This table shows results from the University of Wisconsin-Stout Exit Interview survey. The Exit Interview Survey is sent to all employees who leave UW-Stout.
LOAD FREQUENCY	The data is loaded monthly.
DATA CUSTODIAN	Equal Opportunity/Affirmative Action - Donna Weber
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	11/03 Data view created. 11/03 Data Dictionary created. 09/04 Added DEPARTMENT 103. Additional FISCAL YEAR values were added to the documentation. 11/05 Change Data Custodian.
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.

FISCAL_YEAR

Number(2)

A number indicating the fiscal year the survey was completed
0= 1996-1997
1=1997-1998
2= 1998-1999
3= 1999-2000
4= 2000-2001
5= 2001-2002
6= 1995-1996
7= 1994-1995
8=1993-1994
9= 2002-2003
10= 2003-2004
11=2004-2005
12=2005-2006
13=2006-2007
14=2007-2008
15=2008-2009

FISCAL_YEAR_DESC

Varchar2(10)

Decode of Fiscal_year

DATE_RECIEVED

Date

The date it was received in the Equal Opportunity/Affirmative Action Office

SURVEY_ID

Number(3)

A number assigned to the survey as they are entered into the database.

RETIREMENT

Number(1)

A number assigned as to whether they marked that they were leaving due to retirement
0= no, not marked
1 = yes, marked

RETIREMENT_DESC

Varchar2(50)

Decode of Retirement

RESIGNATION

Number(1)

A number assigned as to whether they marked that they were leaving due to resignation/voluntary termination
0= no, not marked
1 = yes, marked

RESIGNATION_DESC

Varchar2(50)

Decode of Resignation

TRANSFER

Number(1)

A number assigned as to whether they marked that they were leaving due to transferring to another university or state agency
0= no, not marked
1 = yes, marked

TRANSFER_DESC

Varchar2(50)

Decode of Transfer

ELIMINATE_POSITION

Number(1)

A number assigned as to whether they marked that they were leaving due to position elimination
0= no, not marked
1 = yes, marked

ELIMINATE_POSITION_DESC

Varchar2(50)

Decode of Eliminate_position

NOT_RENEWED

Number(1)

A number assigned as to whether they marked that they were leaving due to not renewed
0= no, not marked
1 = yes, marked

NOT_RENEWED_DESC

Varchar2(50)

Decode of Not_renewed

LAYOFF

Number(1)

A number assigned as to whether they marked that they were leaving due to lay off
0= no, not marked
1 = yes, marked

LAYOFF_DESC

Varchar2(50)

Decode of Layoff

DISMISS

Number(1)

A number assigned as to whether they marked that they were leaving due to dismissal for cause
0= no, not marked
1 = yes, marked

DISMISS_DESC

Varchar2(50)

Decode of Dismiss

END_OF_APPT

Number(1)

A number assigned as to whether they marked that they were leaving due to end of appointment term
0= no, not marked
1 = yes, marked

END_OF_APPT_DESC

Varchar2(50)

Decode of End_of_appt

SALARY

Number(1)

A number assigned as to whether they marked that they were leaving due to finding a job with a higher salary
0= no, not marked
1 = yes, marked

SALARY_DESC

Varchar2(50)

Decode of Salary

FRINGE

Number(1)

A number assigned as to whether they marked that they were leaving due to finding a job wit better fringe benefits
0= no, not marked
1 = yes, marked

FRINGE_DESC

Varchar2(50)

Decode of Fringe

RECRUIT

Number(1)

A number assigned as to whether they marked that they were leaving due to being recruited by another employer
0=no, not marked
1=yes, marked

RECRUIT_DESC

Varchar2(50)

Decode of Recruit

EDUCATION

Number(1)

A number assigned as to whether they marked that they were leaving due to furthering education or training
0=no, not marked|
1=yes, marked

EDUCATION_DESC

Varchar2(50)

Decode of Education

ILLNESS

Number(1)

A number assigned as to whether they marked that they were leaving due to illness in the family
0= no, not marked
1 = yes, marked

ILLNESS_DESC

Varchar2(50)

Decode of Illness

PARENT_CARE

Number(1)

A number assigned as to whether they marked that they were leaving due to caring for a parent of child
0= no, not marked
1 = yes, marked

PARENT_CARE_DESC

Varchar2(50)

Decode of Parent_care

NOWORK_SPOUSE

Number(1)

A number assigned as to whether they marked that they were leaving due to no work for spouse/partner in this area
0= no, not marked
1 = yes, marked

NOWORK_SPOUSE_DESC

Varchar2(50)

Decode of Nowork_spouse

RELOCATE_SPOUSE

Number(1)

A number assigned as to whether they marked that they were leaving due to relocation of spouse/partner
0=no, not marked
1=yes, marked

RELOCATE_SPOUSE_DESC

Varchar2(50)

Decode of Relocate_spouse

FAMILY_MATTERS

Number(1)

A number assigned as to whether they marked that they were leaving due to family/personal matters
0= no, not marked
1 = yes, marked

FAMILY_MATTERS_DESC

Varchar2(50)

Decode of Family_matters

WORK_LOAD

Number(1)

A number assigned as to whether they marked that they were leaving due to workload issues
0= no, not marked
1 = yes, marked

WORK_LOAD_DESC

Varchar2(50)

Decode of Work_load

NON_SUPPPORTIVE

Number(1)

A number assigned as to whether they marked that they were leaving due to non-supportive environment
0= no, not marked
1 = yes, marked

NON_SUPPPORTIVE_DESC

Varchar2(50)

Decode of Non_suppportive

DISSATISFACTION

Number(1)

A number assigned as to whether they marked that they were leaving due to dissatisfaction with dept or unit administration
0= no, not marked
1 = yes, marked

DISSATISFACTION_DESC

Varchar2(50)

Decode of Dissatisfaction

PROF_DEVELOPMENT

Number(1)

A number assigned as to whether they marked that they were leaving due to inadequate professional development opportunities
0= no, not marked
1 = yes, marked

PROF_DEVELOPMENT_DESC

Varchar2(50)

Decode of Prof_development

FACILITY_INADEQUATE

Number(1)

A number assigned as to whether they marked that they were leaving due to inadequate research support and/or facilities
0= no, not marked
1 = yes, marked

FACILITY_INADEQUATE_DESC

Varchar2(50)

Decode of Facility_inadequate

POOR_RELATIONSHIPS

Number(1)

A number assigned as to whether they marked that they were leaving due to poor relationships with university employees
0= no, not marked
1 = yes, marked

POOR_RELATIONSHIPS_DESC

Varchar2(50)

Decode of Poor_relationships

GEOGRAPHICS

Number(1)

A number assigned as to whether they marked that they were leaving due to geographic location
0= no, not marked
1 = yes, marked

GEOGRAPHICS_DESC

Varchar2(50)

Decode of Geographics

WINDOW_RETIREMENT

Number(1)

A number assigned as to whether they marked that they were leaving due to retirement window
0= no, not marked
1 = yes, marked

WINDOW_RETIREMENT_DESC

Varchar2(50)

Decode of Window_retirement

OTHER_REASONS

Number(1)

A number assigned to whether or not they listed other reasons for leaving
0= no, not marked
1 = yes, marked

OTHER_REASONS_DESC

Varchar2(50)

Decode of Other_reasons

LIST_OTHER_REASONS

Varchar2(1024)

The verbatim of the reason they gave for leaving in the variable “other_reasons”

SUPERVISOR_RELATIONSHIP

Number(1)

A number assigned to a rating scale of “My supervisor and I had a good working relationship”
1 Strongly Disagree
2
3
4
5 Strongly Agree

SUPERVISOR_RELATIONSHIP_
DESC

Varchar2(50)

Decode of Supervisor_relationship

CO_WORKER_RELATIONSHIP

Number(1)

A number assigned to a rating scale of “My co-workers and I had a good working relationship”
1 Strongly Disagree
2
3
4
5 Strongly Agree

CO_WORKER_RELATIONSHIP_
DESC

Varchar2(50)

Decode of Co_worker_relationship

EXPERIENCE

Number(1)

A number assigned to a rating scale of “I was satisfied with my experience at UW-Stout”
1 Strongly Disagree
2
3
4
5 Strongly Agree

EXPERIENCE_DESC

Varchar2(50)

Decode of EXPERIENCE

RECOMMEND

Number(1)

A number assigned to a rating scale of “I would recommend Stout as a good place to work”
1 Strongly Disagree
2
3
4
5 Strongly Agree

RECOMMEND_DESC

Varchar2(50)

Decode of RECOMMEND

CHALLENGE_JOB

Number(1)

A number assigned to a rating scale of “My job at UW-Stout was NOT challenging”
1 Strongly Disagree
2
3
4
5 Strongly Agree

CHALLENGE_JOB_DESC

Varchar2(50)

Decode of CHALLENGE_JOB

RECOGNITION

Number(1)

A number assigned to a rating scale of “I received satisfactory recognition for the work I did”
1 Strongly Disagree
2
3
4
5 Strongly Agree

RECOGNITION_DESC

Varchar2(50)

Decode of RECOGNITION

TRAINING

Number(1)

A number assigned to a rating scale of “There were adequate opportunities for training and professional development at UW-Stout”
1 Strongly Disagree
2
3
4
5 Strongly Agree

TRAINING_DESC

Varchar2(50)

Decode of TRAINING

INTERESTING

Number(1)

A number assigned to a rating scale of “My job at UW-Stout was interesting”
1 Strongly Disagree
2
3
4
5 Strongly Agree

INTERESTING_DESC

Varchar2(50)

Decode of INTERESTING

DISCRIMINATE_RACE

Number(1)

A number assigned to a rating scale of “Do you feel you were discriminated against on the basis of: race/ethnicity”
1 Always
2
3
4
5 Never

DISCRIMINATE_RACE_DESC

Varchar2(50)

Decode of Discriminate_race

DISCRIMINATE_NATION

Number(1)

A number assigned to a rating scale of “Do you feel you were discriminated against on the basis of: national origin
1 Always
2
3
4
5 Never

DISCRIMINATE_NATION_DESC

Varchar2(50)

Decode of Discriminate_nation

DISCRIMINATE_GENDER

Number(1)

A number assigned to a rating scale of “Do you feel you were discriminated against on the basis of: gender”
1 Always
2
3
4
5 Never

DISCRIMINATE_GENDER_DESC

Varchar2(50)

Decode of Discriminate_gender

DISCRIMINATE_DISABILITY

Number(1)

A number assigned to a rating scale of “Do you feel you were discriminated against on the basis of: disability”
1 Always
2
3
4
5 Never

DISCRIMINATE_DISABILITY_
DESC

Varchar2(50)

Decode of Discriminate_disability

DISCRIMINATE_AGE

Number(1)

A number assigned to a rating scale of “Do you feel you were discriminated against on the basis of: age”
1 Always
2
3
4
5 Never

DISCRIMINATE_AGE_DESC

Varchar2(50)

Decode of Discriminate_age

DISCRIMINATE_RELIGION

Number(1)

A number assigned to a rating scale of “Do you feel you were discriminated against on the basis of: religion”
1 Always
2
3
4
5 Never

DISCRIMINATE_RELIGION_DESC

Varchar2(50)

Decode of Discriminate_religion

DISCRIMINATE_MARITAL

Number(1)

A number assigned to a rating scale of “Do you feel you were discriminated against on the basis of: marital status”
1 Always
2
3
4
5 Never

DISCRIMINATE_MARITAL_DESC

Varchar2(50)

Decode of Discriminate_marital

DISCRIMINATE_ORIENT

Number(1)

A number assigned to a rating scale of “Do you feel you were discriminated against on the basis of: sexual orientation”
1 Always
2
3
4
5 Never

DISCRIMINATE_ORIENT_DESC

Varchar2(50)

Decode of Discriminate_orient

DISCRIMINATE_ARREST

Number(1)

A number assigned to a rating scale of “Do you feel you were discriminated against on the basis of: arrest/conviction”
1 Always
2
3
4
5 Never

DISCRIMINATE_ARREST_DESC

Varchar2(50)

Decode of Discriminate_arrest

DISCRIMINATE_POLITICAL

Number(1)

A number assigned to a rating scale of “Do you feel you were discriminated against on the basis of: political affiliation”
1 Always
2
3
4
5 Never

DISCRIMINATE_POLITICAL_
DESC

Varchar2(50)

Decode of Discriminate_political

HARASSED_RACE

Number(1)

A number assigned to a rating scale of “Do you feel you were harassed on the basis of: race”
1 Always
2
3|
4
5 Never

HARASSED_RACE_DESC

Varchar2(50)

Decode of Harassed_race

HARASSED_NATION

Number(1)

A number assigned to a rating scale of “Do you feel you were harassed on the basis of: national origin”
1 Always
2
3
4
5 Never

HARASSED_NATION_DESC

Varchar2(50)

Decode of Harassed_nationality

HARASSED_GENDER

Number(1)

A number assigned to a rating scale of “Do you feel you were harassed on the basis of: gender”
1 Always
2
3
4
5 Never

HARASSED_GENDER_DESC

Varchar2(50)

Decode of Harassed_gender

HARASSED_DISABILITY

Number(1)

A number assigned to a rating scale of “Do you feel you were harassed on the basis of: disability”
1 Always
2
3
4
5 Never

HARASSED_DISABILITY_DESC

Varchar2(50)

Decode of Harassed_disability

HARASSED_AGE

Number(1)

A number assigned to a rating scale of “Do you feel you were harassed on the basis of: age
1 Always
2
3
4
5 Never

HARASSED_AGE_DESC

Varchar2(50)

Decode of Harassed_age

HARASSED_RELIGION

Number(1)

A number assigned to a rating scale of “Do you feel you were harassed on the basis of: religion”
1 Always
2
3
4
5 Never

HARASSED_RELIGION_DESC

Varchar2(50)

Decode of Harassed_religion

HARASSED_MARITAL

Number(1)

A number assigned to a rating scale of “Do you feel you were harassed on the basis of: marital status
1 Always
2
3
4
5 Never

HARASSED_MARITAL_DESC

Varchar2(50)

Decode of Harassed_marital

HARASSED_ ORIENT

Number(1)

A number assigned to a rating scale of “Do you feel you were harassed on the basis of: sexual
rientation”
1 Always
2
3
4
5 Never

HARASSED_ ORIENT_DESC

Varchar2(50)

Decode of Harassed_ orient

HARASSED_ARREST

Number(1)

A number assigned to a rating scale of “Do you feel you were harassed on the basis of: arrest/conviction record.”
1 Always
2
3
4
5 Never

HARASSED_ARREST_DESC

Varchar2(50)

Decode of Harassed_arrest

HARASSED_POLITICAL

Number(1)

A number assigned to a rating scale of “Do you feel you were harassed on the basis of: political affiliation”
1 Always
2
3
4
5 Never

HARASSED_POLITICAL_DESC

Varchar2(50)

Decode of Harassed_political

EMPLOY_CATEGORY

Number(1)

A number assigned for their employment category
0= Administrator (i.e. directors, deans)
1= Faculty (i.e. professors)
2= Academic staff (i.e. lecturer, non-instructional staff)
3= Classified staff (i.e. clerical, support staff, custodial, etc.)

EMPLOY_CATEGORY_DESC

Varchar2(50)

Decode of Employ_category

GENDER

Number(1)

A number assigned to the employees gender
0= female
1= male

GENDER_DESC

Varchar2(25)

Decode of Gender

AGE

Number(3)

Age in years of the employee

VETERAN_STATUS

Number(1)

A number assigned to their veteran status
0= not a veteran
1= Vietnam Era Veteran
2= Veteran

VETERAN_STATUS_DESC

Varchar2(25)

Decode of Veteran_status

DISABILITY

Number(1)

A number assigned to if they self-reported as having a disability
0= yes
1= no

DISABILITY_DESC

Varchar2(25)

Decode of Disability

RACE

Number(1)

A number assigned to their race/ethnicity
0= Black
1= Asian or Pacific Islander
2= White
3= Hispanic
4= American Indian

RACE_DESC

Varchar2(25)

Decode of Race

LONG_WORKED

Number(6,2)

Actual value of how long the employee worked at UW-Stout Years and months

DEPARTMENT

Number(3)

The number assigned to department at which the employee worked in.
10= Chancellor’s office admin
11= affirmative action
12= university development
13= university relations
14= senates: faculty and Academic staff
20= tech and inform services
30= provost’s office
31= graduate college
32= research and promotion services
33= library learning center
34= learning technology services
35= international programs
36= cont. edu and summer session
37= stout solutions
40= CAS administration
41= CAS art and design
42= CAS biology
43= CAS chemistry
44= CAS English and philosophy
45= CAS English lang inst
46= CAS math, stats, and comp. science
47= CAS physics
48= CAS social sciences
49= CAS speech, com. foreign lang., thea. and
usic
50= CHD administration
51= CHD athletics and phy ed
52= CHD edu., school counseling, school psych
53= CHD food and nutrition
54= CHD hosp and tourism management
55= CHD HDFLCES
56= CHD psychology
57= CHD rehab and counseling
58= CHD SVRI
60= CTEM administration
61= CTEM app. txtl & design
62= CTEM business
63= CTEM comm., edu., & training
64= CTEM technology
65= CTEM CVTAE
66= CTEM STTI
67= CTEM industrial management
70= student support services
71= registration and records
72= financial aid services
73=admissions and school rel
80= ASLS administration
81= budget plan & analysis
82= business and financial services
83= human resource
84= physical plant
85= university services
90= student center
91= residence life
92= security and parking
93= university dining services
94= student health center
96= recreation athletic complex
100= SOE/instructional faculty/staff
101= licensing, assessment, & clinical placement
102= child and family studies center
103=SOE, not otherwise specified
99= not applicable or missing

DEPARTMENT_DESC

Varchar2(100)

Decode of Department

COLLEGE

Number(1)

A number assigned to the college they worked in1=college of arts and sciences
2= college of human development
3= college of technology, engineering, and management
4= school of education

COLLEGE_DESC

Varchar2(100)

Decode of College

LAST_UPDATE_DATE_TIME

Date

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

Column Name	Format	Description
* SEQ_NO	NUMBER (15)	Sequential number generated as a key.
FISCAL_YEAR	Number(2)	A number indicating the fiscal year the survey was completed 0= 1996-1997 1=1997-1998 2= 1998-1999 3= 1999-2000 4= 2000-2001 5= 2001-2002 6= 1995-1996 7= 1994-1995 8=1993-1994 9= 2002-2003 10= 2003-2004 11=2004-2005 12=2005-2006 13=2006-2007 14=2007-2008 15=2008-2009
FISCAL_YEAR_DESC	Varchar2(10)	Decode of Fiscal_year
DATE_RECIEVED	Date	The date it was received in the Equal Opportunity/Affirmative Action Office
SURVEY_ID	Number(3)	A number assigned to the survey as they are entered into the database.
RETIREMENT	Number(1)	A number assigned as to whether they marked that they were leaving due to retirement 0= no, not marked 1 = yes, marked
RETIREMENT_DESC	Varchar2(50)	Decode of Retirement
RESIGNATION	Number(1)	A number assigned as to whether they marked that they were leaving due to resignation/voluntary termination 0= no, not marked 1 = yes, marked
RESIGNATION_DESC	Varchar2(50)	Decode of Resignation
TRANSFER	Number(1)	A number assigned as to whether they marked that they were leaving due to transferring to another university or state agency 0= no, not marked 1 = yes, marked
TRANSFER_DESC	Varchar2(50)	Decode of Transfer
ELIMINATE_POSITION	Number(1)	A number assigned as to whether they marked that they were leaving due to position elimination 0= no, not marked 1 = yes, marked
ELIMINATE_POSITION_DESC	Varchar2(50)	Decode of Eliminate_position
NOT_RENEWED	Number(1)	A number assigned as to whether they marked that they were leaving due to not renewed 0= no, not marked 1 = yes, marked
NOT_RENEWED_DESC	Varchar2(50)	Decode of Not_renewed
LAYOFF	Number(1)	A number assigned as to whether they marked that they were leaving due to lay off 0= no, not marked 1 = yes, marked
LAYOFF_DESC	Varchar2(50)	Decode of Layoff
DISMISS	Number(1)	A number assigned as to whether they marked that they were leaving due to dismissal for cause 0= no, not marked 1 = yes, marked
DISMISS_DESC	Varchar2(50)	Decode of Dismiss
END_OF_APPT	Number(1)	A number assigned as to whether they marked that they were leaving due to end of appointment term 0= no, not marked 1 = yes, marked
END_OF_APPT_DESC	Varchar2(50)	Decode of End_of_appt
SALARY	Number(1)	A number assigned as to whether they marked that they were leaving due to finding a job with a higher salary 0= no, not marked 1 = yes, marked
SALARY_DESC	Varchar2(50)	Decode of Salary
FRINGE	Number(1)	A number assigned as to whether they marked that they were leaving due to finding a job wit better fringe benefits 0= no, not marked 1 = yes, marked
FRINGE_DESC	Varchar2(50)	Decode of Fringe
RECRUIT	Number(1)	A number assigned as to whether they marked that they were leaving due to being recruited by another employer 0=no, not marked 1=yes, marked
RECRUIT_DESC	Varchar2(50)	Decode of Recruit
EDUCATION	Number(1)	A number assigned as to whether they marked that they were leaving due to furthering education or training 0=no, not marked\| 1=yes, marked
EDUCATION_DESC	Varchar2(50)	Decode of Education
ILLNESS	Number(1)	A number assigned as to whether they marked that they were leaving due to illness in the family 0= no, not marked 1 = yes, marked
ILLNESS_DESC	Varchar2(50)	Decode of Illness
PARENT_CARE	Number(1)	A number assigned as to whether they marked that they were leaving due to caring for a parent of child 0= no, not marked 1 = yes, marked
PARENT_CARE_DESC	Varchar2(50)	Decode of Parent_care
NOWORK_SPOUSE	Number(1)	A number assigned as to whether they marked that they were leaving due to no work for spouse/partner in this area 0= no, not marked 1 = yes, marked
NOWORK_SPOUSE_DESC	Varchar2(50)	Decode of Nowork_spouse
RELOCATE_SPOUSE	Number(1)	A number assigned as to whether they marked that they were leaving due to relocation of spouse/partner 0=no, not marked 1=yes, marked
RELOCATE_SPOUSE_DESC	Varchar2(50)	Decode of Relocate_spouse
FAMILY_MATTERS	Number(1)	A number assigned as to whether they marked that they were leaving due to family/personal matters 0= no, not marked 1 = yes, marked
FAMILY_MATTERS_DESC	Varchar2(50)	Decode of Family_matters
WORK_LOAD	Number(1)	A number assigned as to whether they marked that they were leaving due to workload issues 0= no, not marked 1 = yes, marked
WORK_LOAD_DESC	Varchar2(50)	Decode of Work_load
NON_SUPPPORTIVE	Number(1)	A number assigned as to whether they marked that they were leaving due to non-supportive environment 0= no, not marked 1 = yes, marked
NON_SUPPPORTIVE_DESC	Varchar2(50)	Decode of Non_suppportive
DISSATISFACTION	Number(1)	A number assigned as to whether they marked that they were leaving due to dissatisfaction with dept or unit administration 0= no, not marked 1 = yes, marked
DISSATISFACTION_DESC	Varchar2(50)	Decode of Dissatisfaction
PROF_DEVELOPMENT	Number(1)	A number assigned as to whether they marked that they were leaving due to inadequate professional development opportunities 0= no, not marked 1 = yes, marked
PROF_DEVELOPMENT_DESC	Varchar2(50)	Decode of Prof_development
FACILITY_INADEQUATE	Number(1)	A number assigned as to whether they marked that they were leaving due to inadequate research support and/or facilities 0= no, not marked 1 = yes, marked
FACILITY_INADEQUATE_DESC	Varchar2(50)	Decode of Facility_inadequate
POOR_RELATIONSHIPS	Number(1)	A number assigned as to whether they marked that they were leaving due to poor relationships with university employees 0= no, not marked 1 = yes, marked
POOR_RELATIONSHIPS_DESC	Varchar2(50)	Decode of Poor_relationships
GEOGRAPHICS	Number(1)	A number assigned as to whether they marked that they were leaving due to geographic location 0= no, not marked 1 = yes, marked
GEOGRAPHICS_DESC	Varchar2(50)	Decode of Geographics
WINDOW_RETIREMENT	Number(1)	A number assigned as to whether they marked that they were leaving due to retirement window 0= no, not marked 1 = yes, marked
WINDOW_RETIREMENT_DESC	Varchar2(50)	Decode of Window_retirement
OTHER_REASONS	Number(1)	A number assigned to whether or not they listed other reasons for leaving 0= no, not marked 1 = yes, marked
OTHER_REASONS_DESC	Varchar2(50)	Decode of Other_reasons
LIST_OTHER_REASONS	Varchar2(1024)	The verbatim of the reason they gave for leaving in the variable “other_reasons”
SUPERVISOR_RELATIONSHIP	Number(1)	A number assigned to a rating scale of “My supervisor and I had a good working relationship” 1 Strongly Disagree 2 3 4 5 Strongly Agree
SUPERVISOR_RELATIONSHIP_ DESC	Varchar2(50)	Decode of Supervisor_relationship
CO_WORKER_RELATIONSHIP	Number(1)	A number assigned to a rating scale of “My co-workers and I had a good working relationship” 1 Strongly Disagree 2 3 4 5 Strongly Agree
CO_WORKER_RELATIONSHIP_ DESC	Varchar2(50)	Decode of Co_worker_relationship
EXPERIENCE	Number(1)	A number assigned to a rating scale of “I was satisfied with my experience at UW-Stout” 1 Strongly Disagree 2 3 4 5 Strongly Agree
EXPERIENCE_DESC	Varchar2(50)	Decode of EXPERIENCE
RECOMMEND	Number(1)	A number assigned to a rating scale of “I would recommend Stout as a good place to work” 1 Strongly Disagree 2 3 4 5 Strongly Agree
RECOMMEND_DESC	Varchar2(50)	Decode of RECOMMEND
CHALLENGE_JOB	Number(1)	A number assigned to a rating scale of “My job at UW-Stout was NOT challenging” 1 Strongly Disagree 2 3 4 5 Strongly Agree
CHALLENGE_JOB_DESC	Varchar2(50)	Decode of CHALLENGE_JOB
RECOGNITION	Number(1)	A number assigned to a rating scale of “I received satisfactory recognition for the work I did” 1 Strongly Disagree 2 3 4 5 Strongly Agree
RECOGNITION_DESC	Varchar2(50)	Decode of RECOGNITION
TRAINING	Number(1)	A number assigned to a rating scale of “There were adequate opportunities for training and professional development at UW-Stout” 1 Strongly Disagree 2 3 4 5 Strongly Agree
TRAINING_DESC	Varchar2(50)	Decode of TRAINING
INTERESTING	Number(1)	A number assigned to a rating scale of “My job at UW-Stout was interesting” 1 Strongly Disagree 2 3 4 5 Strongly Agree
INTERESTING_DESC	Varchar2(50)	Decode of INTERESTING
DISCRIMINATE_RACE	Number(1)	A number assigned to a rating scale of “Do you feel you were discriminated against on the basis of: race/ethnicity” 1 Always 2 3 4 5 Never
DISCRIMINATE_RACE_DESC	Varchar2(50)	Decode of Discriminate_race
DISCRIMINATE_NATION	Number(1)	A number assigned to a rating scale of “Do you feel you were discriminated against on the basis of: national origin 1 Always 2 3 4 5 Never
DISCRIMINATE_NATION_DESC	Varchar2(50)	Decode of Discriminate_nation
DISCRIMINATE_GENDER	Number(1)	A number assigned to a rating scale of “Do you feel you were discriminated against on the basis of: gender” 1 Always 2 3 4 5 Never
DISCRIMINATE_GENDER_DESC	Varchar2(50)	Decode of Discriminate_gender
DISCRIMINATE_DISABILITY	Number(1)	A number assigned to a rating scale of “Do you feel you were discriminated against on the basis of: disability” 1 Always 2 3 4 5 Never
DISCRIMINATE_DISABILITY_ DESC	Varchar2(50)	Decode of Discriminate_disability
DISCRIMINATE_AGE	Number(1)	A number assigned to a rating scale of “Do you feel you were discriminated against on the basis of: age” 1 Always 2 3 4 5 Never
DISCRIMINATE_AGE_DESC	Varchar2(50)	Decode of Discriminate_age
DISCRIMINATE_RELIGION	Number(1)	A number assigned to a rating scale of “Do you feel you were discriminated against on the basis of: religion” 1 Always 2 3 4 5 Never
DISCRIMINATE_RELIGION_DESC	Varchar2(50)	Decode of Discriminate_religion
DISCRIMINATE_MARITAL	Number(1)	A number assigned to a rating scale of “Do you feel you were discriminated against on the basis of: marital status” 1 Always 2 3 4 5 Never
DISCRIMINATE_MARITAL_DESC	Varchar2(50)	Decode of Discriminate_marital
DISCRIMINATE_ORIENT	Number(1)	A number assigned to a rating scale of “Do you feel you were discriminated against on the basis of: sexual orientation” 1 Always 2 3 4 5 Never
DISCRIMINATE_ORIENT_DESC	Varchar2(50)	Decode of Discriminate_orient
DISCRIMINATE_ARREST	Number(1)	A number assigned to a rating scale of “Do you feel you were discriminated against on the basis of: arrest/conviction” 1 Always 2 3 4 5 Never
DISCRIMINATE_ARREST_DESC	Varchar2(50)	Decode of Discriminate_arrest
DISCRIMINATE_POLITICAL	Number(1)	A number assigned to a rating scale of “Do you feel you were discriminated against on the basis of: political affiliation” 1 Always 2 3 4 5 Never
DISCRIMINATE_POLITICAL_ DESC	Varchar2(50)	Decode of Discriminate_political
HARASSED_RACE	Number(1)	A number assigned to a rating scale of “Do you feel you were harassed on the basis of: race” 1 Always 2 3\| 4 5 Never
HARASSED_RACE_DESC	Varchar2(50)	Decode of Harassed_race
HARASSED_NATION	Number(1)	A number assigned to a rating scale of “Do you feel you were harassed on the basis of: national origin” 1 Always 2 3 4 5 Never
HARASSED_NATION_DESC	Varchar2(50)	Decode of Harassed_nationality
HARASSED_GENDER	Number(1)	A number assigned to a rating scale of “Do you feel you were harassed on the basis of: gender” 1 Always 2 3 4 5 Never
HARASSED_GENDER_DESC	Varchar2(50)	Decode of Harassed_gender
HARASSED_DISABILITY	Number(1)	A number assigned to a rating scale of “Do you feel you were harassed on the basis of: disability” 1 Always 2 3 4 5 Never
HARASSED_DISABILITY_DESC	Varchar2(50)	Decode of Harassed_disability
HARASSED_AGE	Number(1)	A number assigned to a rating scale of “Do you feel you were harassed on the basis of: age 1 Always 2 3 4 5 Never
HARASSED_AGE_DESC	Varchar2(50)	Decode of Harassed_age
HARASSED_RELIGION	Number(1)	A number assigned to a rating scale of “Do you feel you were harassed on the basis of: religion” 1 Always 2 3 4 5 Never
HARASSED_RELIGION_DESC	Varchar2(50)	Decode of Harassed_religion
HARASSED_MARITAL	Number(1)	A number assigned to a rating scale of “Do you feel you were harassed on the basis of: marital status 1 Always 2 3 4 5 Never
HARASSED_MARITAL_DESC	Varchar2(50)	Decode of Harassed_marital
HARASSED_ ORIENT	Number(1)	A number assigned to a rating scale of “Do you feel you were harassed on the basis of: sexual rientation” 1 Always 2 3 4 5 Never
HARASSED_ ORIENT_DESC	Varchar2(50)	Decode of Harassed_ orient
HARASSED_ARREST	Number(1)	A number assigned to a rating scale of “Do you feel you were harassed on the basis of: arrest/conviction record.” 1 Always 2 3 4 5 Never
HARASSED_ARREST_DESC	Varchar2(50)	Decode of Harassed_arrest
HARASSED_POLITICAL	Number(1)	A number assigned to a rating scale of “Do you feel you were harassed on the basis of: political affiliation” 1 Always 2 3 4 5 Never
HARASSED_POLITICAL_DESC	Varchar2(50)	Decode of Harassed_political
EMPLOY_CATEGORY	Number(1)	A number assigned for their employment category 0= Administrator (i.e. directors, deans) 1= Faculty (i.e. professors) 2= Academic staff (i.e. lecturer, non-instructional staff) 3= Classified staff (i.e. clerical, support staff, custodial, etc.)
EMPLOY_CATEGORY_DESC	Varchar2(50)	Decode of Employ_category
GENDER	Number(1)	A number assigned to the employees gender 0= female 1= male
GENDER_DESC	Varchar2(25)	Decode of Gender
AGE	Number(3)	Age in years of the employee
VETERAN_STATUS	Number(1)	A number assigned to their veteran status 0= not a veteran 1= Vietnam Era Veteran 2= Veteran
VETERAN_STATUS_DESC	Varchar2(25)	Decode of Veteran_status
DISABILITY	Number(1)	A number assigned to if they self-reported as having a disability 0= yes 1= no
DISABILITY_DESC	Varchar2(25)	Decode of Disability
RACE	Number(1)	A number assigned to their race/ethnicity 0= Black 1= Asian or Pacific Islander 2= White 3= Hispanic 4= American Indian
RACE_DESC	Varchar2(25)	Decode of Race
LONG_WORKED	Number(6,2)	Actual value of how long the employee worked at UW-Stout Years and months
DEPARTMENT	Number(3)	The number assigned to department at which the employee worked in. 10= Chancellor’s office admin 11= affirmative action 12= university development 13= university relations 14= senates: faculty and Academic staff 20= tech and inform services 30= provost’s office 31= graduate college 32= research and promotion services 33= library learning center 34= learning technology services 35= international programs 36= cont. edu and summer session 37= stout solutions 40= CAS administration 41= CAS art and design 42= CAS biology 43= CAS chemistry 44= CAS English and philosophy 45= CAS English lang inst 46= CAS math, stats, and comp. science 47= CAS physics 48= CAS social sciences 49= CAS speech, com. foreign lang., thea. and usic 50= CHD administration 51= CHD athletics and phy ed 52= CHD edu., school counseling, school psych 53= CHD food and nutrition 54= CHD hosp and tourism management 55= CHD HDFLCES 56= CHD psychology 57= CHD rehab and counseling 58= CHD SVRI 60= CTEM administration 61= CTEM app. txtl & design 62= CTEM business 63= CTEM comm., edu., & training 64= CTEM technology 65= CTEM CVTAE 66= CTEM STTI 67= CTEM industrial management 70= student support services 71= registration and records 72= financial aid services 73=admissions and school rel 80= ASLS administration 81= budget plan & analysis 82= business and financial services 83= human resource 84= physical plant 85= university services 90= student center 91= residence life 92= security and parking 93= university dining services 94= student health center 96= recreation athletic complex 100= SOE/instructional faculty/staff 101= licensing, assessment, & clinical placement 102= child and family studies center 103=SOE, not otherwise specified 99= not applicable or missing
DEPARTMENT_DESC	Varchar2(100)	Decode of Department
COLLEGE	Number(1)	A number assigned to the college they worked in1=college of arts and sciences 2= college of human development 3= college of technology, engineering, and management 4= school of education
COLLEGE_DESC	Varchar2(100)	Decode of College
LAST_UPDATE_DATE_TIME	Date	The date and time the data was last updated. Format : YYYYMMDD HH24:MI:SS