InfoAccess

DATA VIEW NAME

EOAA_DEMO_CARD_STOUT

OVERVIEW 

This table shows results from the demographic card that is given to all applicants for unclassified positions.  The table includes the search PIN number so that results can be linked to other Equal Opportunity/Affirmative Action office databases.

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.
07/04 Added 2 new fields:
NEWSPAPER_NAME2
NEWSPAPER_NAME3
09/04 Added DEPARTMENT 103. YEAR was changed to Number 2 and values 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.

COLLEGE

Number(1)

A number assigned to the college they are applying for if applicable
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 COLLEGE

PIN

Varchar2(15)

A 10 digit number representing the recruitment search #

DEPARTMENT

Number(3)

The number assigned to the department of where the position the applicant applied for is located
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 seeion
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.,
hea. and music
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 buisiness
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

YEAR

Number(2)

A number given to the year of the recruitment search

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 YEAR

PERSONAL_CONTACT

Number(2)

Number assigned as to whether the applicant 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(2)

Number assigned as to whether the applicant marked that they found out about the position through a professional organization (ex: ListServ, conference, website, professional journal)
0= no, not marked
1= yes, marked

ORGANIZATION_DESC

Varchar2(50)

Decode of ORGANIZATION

ORGANIZATION_NAME1

Varchar2(150)

Verbatim given for the above variable, name of the organization

ORGANIZATION_NAME2

Varchar2(150)

Verbatim given for the above variable, name of the organization

ASIAN_PAGES

Number(2)

A number given to if the applicant 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(2)

A number given to if the applicant 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_HIGHER_ED

CHRONICLE_HIGHER_ED

Number(2)

A number given to if the applicant 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 CHRONICLE_HIGHER_ED

HISPANIC_HIGHER_ED

Number(2)

A number given to if the applicant 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_HIGHER_ED

INDIAN_COUNTRY_NEWS

Number(2)

A number given to if the applicant 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 INDIAN_COUNTRY_NEWS

WOMEN_HIGHER_ED

Number(2)

A number given to if the applicant 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_HIGHER_ED

NEWSPAPER

Number(2)

A number given to if the applicant 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(50)

Verbatim given for the above variable, newspaper

NEWSPAPER_NAME2

Varchar2(50)

Second newspaper name

NEWSPAPER_NAME3

Varchar2(50)

Third newspaper name

STOUT_WEBSITE

Number(2)

A number given to if the applicant 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 STOUT_WEBSITE

HIGHER_ED_JOBS

Number(2)

A number given to if the applicant marked that they found out about the position from HigherEdJobs
0= no, not checked
1= yes, checked

HIGHER_ED_JOBS_DESC

Varchar2(50)

Decode of HIGHER_ED_JOBS

OTHER_SOURCE

Number(2)

A number given to if the applicant marked that they found out about the position from an other source
0= no, not checked
1= yes, checked

OTHER_SOURCE_DESC

Varchar2(50)

Decode of OTHER_SOURCE

OTER_SOURCE _LIST1

Varchar2(50)

Verbatim of another place they found their position if not the above

OTER_SOURCE _LIST2

Varchar2(50)

Verbatim of another place they found their position if not the above

OTER_SOURCE _LIST3

Varchar2(50)

Verbatim of another place they found their position if not the above

RACE

Number(2)

Number given to what the applicant marked for their race/ethnicity
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)

RACE_DESC

Varchar2(50)

Decode of RACE

GENDER

Number(2)

Number given to what the applicant marked for their gender
0= female
1= male

GENDER_DESC

Varchar2(10)

Decode of GENDER

DISABILITIES

Number(3)

Number given to what the applicant marked disability
0= no
1= yes

DISABILITIES_DESC

Varchar2(50)

Decode of DISABILITIES

VETERAN_STATUS

Number(3)

Number given to what the applicant marked for their veteran status
0= non-veteran
1= Veteran
2= Disabled Veteran

VETERAN_STATUS_DESC

Varchar2(20)

Decode of VETERAN_STATUS

BIRTH_YEAR

Number(4)

Birth year

POSITION_ID

Number(3)

ID given to each applicant within a position, then the numbering starts over for each new position

DEMOCARD_VERSION

Number(2)

Number given to for the version of the survey card
0= old version
1= new (current) version

DEMOCARD_VERSION_DESC

Varchar2(50)

Decode of DEMOCARD_VERSION

LAST_UPDATE_DATE_TIME

Date

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