Column Name	Format	Description
*SEQ_NO	Number(15)	Sequential number generated as a key.
COLLEGE	Number(1)	Number given if the new hire works in one of the 4 colleges 1= college of arts and sciences 2= college of human development 3= college of technology, engineering, and management 4= school of education
COLLEGE_DESC	Varchar2(50)	Decode of colleges
PIN	Varchar2(15)	A code given to identify the recruitment search number
NAME	Varchar2(50)	Name of the new hire, if the person is an emergency hire, it will say Emerg. Hire
UNIVERSITY_WIDE_AD	Number (1)	Number given to whether the position was advertised for on a University-wide ad 0= no 1= yes
UNIVERSITY_WIDE_AD_DESC	Varchar2(50)	Decode of University-wide ad
SURVEY_ID	Number(3)	An identification number given to the survey, following number order of the last survey in the database
DEPARTMENT	Number(3)	The number assigned to the department of the position the new hire works 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 music 50= CHD administration 51= CHD athletics and phy ed 52= CHD edu., school counseling, school sych 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 the position the new hire works in
YEAR	Number(2)	Number assigned to indicate the fiscal year the new employee began work 0= 1999-2000 6= 2004-2005 1= 2000-2001 7= 2005-2006 2= 2001-2002 8= 2006-2007 3= 2002-2003 9= 2007-2008 4= 1998-1999 10= 2008-2009 5= 2003-2004
YEAR_DESC	Varchar2(10)	Decode of the new employee began to work
GENDER	Number(2)	Number given to what the new hire marked for their gender 0= female 1= male
GENDER_DESC	Varchar2(50)	Decode of new hire marked for their gender
MINORITY	Number(2)	Number given to what the new hire marked for their minority status 0= American Indian or Alaskan Native 1= African American (not Hispanic origin) 2= Asian or Pacific Islander 3= Hispanic (regardless of race) 4= White (not of Hispanic origin)
MINORITY_DESC	Varchar2(40)	Decode of minority status
EMPLOYMENT_CATEGORY	Number(2)	Number assigned to what the new hire put for their employment category 0= academic staff 1= faculty
EMPLOYMENT_CATEGORY_ DESC	Varchar2(50)	Decode of employment category
PERSONAL_CONTACT	Number(1)	Number assigned as to whether the new hire marked that they found out about the position through personal contact 0= no, not marked 1= yes, marked
PERSONAL_CONTACT_DESC	Varchar2(50)	Decode of personal contact
ORGANIZATION	Number(1)	Number assigned as to whether the new hire marked that they found out about the position through a professional organization (ex: List Serv, conference, website, professional journal) 0= no, not marked 1= yes, marked 2= yes, but was written as other
ORGANIZATION_DESC	Varchar2(50)	Decode of professional organization
ORGNIZATION_NAME	Varchar2(150)	Verbatim of the above variable. Lists the other professional organizations
ASIAN_PAGES	Number(2)	A number given to if the new hire marked that they found out about the position from Asian Pages 0= no, not checked 1= yes, checked
ASIAN_PAGES_DESC	Varchar2(50)	Decode of Asian Pages
BLACK_ISSUES_HIGHER_ED	Number(1)	A number given to if the new hire marked that they found out about the position from Black Issues in Higher Education 0= no, not checked 1= yes, checked
BLACK_ISSUES_HIGHER_ED_ DESC	Varchar2(50)	Decode of Black Issues in Higher Education
CHRONICLE_HIGHER_ED	Number(1)	A number given to if the new hire marked that they found out about the position from The Chronicle of Higher Education 0= no, not checked 1= yes, checked
CHRONICLE_HIGHER_ED_ DESC	Varchar2(50)	Decode of The Chronicle of Higher Education
HISPANIC_HIGHER_ED	Number(1)	A number given to if the new hire marked that they found out about the position from Hispanic Outlook in Higher Education 0= no, not checked 1= yes, checked
HISPANIC_HIGHER_ED_DESC	Varchar2(50)	Decode of Hispanic Outlook in Higher Education
INDIAN_COUNTRY_NEWS	Number(1)	A number given to if the new hire marked that they found out about the position from News From Indian Country 0= no, not checked 1= yes, checked
INDIAN_COUNTRY_NEWS_DESC	Varchar2(50)	Decode of News From Indian Country
WOMEN_HIGHER_ED	Number(1)	A number given to if the new hire marked that they found out about the position from Women in Higher Education 0= no, not checked 1= yes, checked
WOMEN_HIGHER_ED_DESC	Varchar2(50)	Decode of Women in Higher Education
NEWSPAPER	Number(1)	A number given to if the new hire marked that they found out about the position from a newspaper 0= no, not checked 1= yes, checked
NEWSPAPER_DESC	Varchar2(50)	Decode of newspaper
NEWSPAPER_NAME	Varchar2(150)	Verbatim of the above variable if provided, “newspaper” source
STOUT_WEBSITE	Number(1)	A number given to if the new hire marked that they found out about the position from UW-Stout website 0= no, not checked 1= yes, checked
STOUT_WEBSITE_DESC	Varchar2(50)	Decode of UW-Stout website
HIGHER_ED_JOBS	Number(1)	A number given to if the new hire marked that they found out about the position from Higher Ed Jobs 0= no, not checked 1= yes, checked 7= position not advertised 8= logical skip
HIGHER_ED_JOBS_DESC	Varchar2(50)	Decode of Higher Ed Jobs
OTHER_SOURCE	Number(1)	A number given to if the new hire marked that they found out about the position from another source 0= no, if nothing was marked 1= yes, if something was marked
OTHER_SOURCE_DESC	Varchar2(50)	Decode of another source
OTHER_SOURCE_LIST	Varchar2(1024)	Verbatim of the above variable, listing the other source of where the new hire found out about the position
NOT_STOUT	Varchar2(1024)	Verbatim of other places utilized where the new hire did not find Stout
SEE_UNIVERSITY_WIDE_AD	Number(2)	Number assigned to whether the new hire saw a university-wide ad in their search process 0= no 1= yes 8= logical skip
SEE_UNIVERSITY_WIDE_AD_ DESC	Varchar2(50)	Decode of university-wide ad in their search process
INFLUENTIAL_UW_AD	Number(2)	Number assigned to if they thought the university-wide ad was influential 0= no 1= yes 8= logical skip 9= blank
INFLUENTIAL_UW_AD_DESC	Varchar2(50)	Decode of university-wide ad was influential
WHICH_AD_INFLUENCED	Number(2)	Number assigned to the options for the question “in your opinion, which type of ad would most influence your decision to apply for a position at UW-Stout 0= don’t know 1= university-wide ad 2= individual ad 3= either type of ad 99= blank
WHICH_AD_INFLUENCED_DESC	Varchar2(50)	Decode of your decision to apply for a position at UW-Stout
ADDITIONAL_COMMENTS	Varchar2(1024)	Verbatim of additional comments
SUGGESTIONS	Varchar2(1024)	Verbatim of suggested publication or websites or on line job search service where UW-Stout should advertise
EMERGENCY_HIRE	Number(1)	Number assigned for whether the new hire was an emergency hire 0= no 1= yes
EMERGENCY_HIRE_DESC	Varchar2(50)	Decode of new hire was an emergency hire
LAST_UPDATE_DATE_TIME	Date	The date and time the data was last updated. Format : YYYYMMDD HH24:MI:SS