EOAA_APPLICANT_TRACK_STOUT

This table includes data from the recruitment search process including data on the number and diversity of applicants at each stage of the recruitment process.

The data is loaded daily.

Equal Opportunity/Affirmative Action- Donna Weber

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

Contact:  Division of Information Technology Help Desk
Phone:  264-HELP (4357)

02/04 Data view created.
02/04 Data Dictionary created.
11/05 Change Data Custodian.

Primary Key Columns are identified with an asterisk(*)

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’

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 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)

Number (15)

Sequential generated number (primary key)

Number (3)

The last three digits of the search PIN number

Number (1)

Faculty or Academic Staff Position
0=academic staff
1=faculty

Varchar2 (50)

Decode of job category

Number (2)

The job group number as described in the Federal Affirmative Action Program
20=Executive Administrators
21=Academic Administrators
22=Administrative Directors
23=Associate/Assistant Directors
24=Program Managers
25=Academic Support
26=Health Professionals
27=Research and Media Professionals
28=Information Systems Professionals
29=Student Services Support Professionals
30=Coaches/Athletic Trainers
40=Instructional Academic Staff
50=Faculty: College of Human Development
51=Faculty: College of Technology,
ngineering and Management
52=Faculty: College of Arts and Sciences

Varchar2 (100)

Decode of job group number

Number (1)

The fiscal year that the recruitment began
0=1994-95
1=1995-96
2=1996-97
3=1997-98
4=1998-99
5=1999-00
6=2000-01
7=2001-02
8=2002-03
9=2003-04

Varchar2 (50)

Decode of fiscal year

Varchar2 (14)

A unique ID number assigned to each recruitment

Number (3)

The department that is conducting the search
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., thea. 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
99= not applicable or missing

Varchar2 (100)

Decode of department

Varchar2 (50)

The title that is being recruited for

Varchar2 (100)

The discipline that is being recruited for

Number (3)

The number of applicants who turned in a demographic card
999=not applicable

Number (3)

The number of veterans of the Vietnam war who applied (from the demographic card)
999=not applicable

Number (3)

The number of disabled veterans who applied (from the demographic card)
999=not applicable

Number (3)

The number of other veterans who applied (from the demographic card)
999=not applicable

Number (3)

The number of veterans who applied (from the demographic card)
999=not applicable

Number (3)

The number of persons with disabilities who applied (from the demographic card)
999=not applicable

Number (4)

Average year of birth of all applicants (from the demographic card)
999=not applicable

Number (3)

Total number of applicants over the age of 40
999=not applicable

Number (1)

Was the search successful?
0=unsuccessful
1=successful
2=in progress

Varchar2 (50)

Decode of search success

Varchar2 (50)

Result of the search

Number (3)

Total number of people who applied for the position

Number (3)

Total number of men who applied

Number (3)

Total number of women who applied

Number (3)

Total number of American Indians who applied

Number (3)

Total number of African Americans who applied

Number (3)

Total number of Hispanic Americans who applied

Number (3)

Total number of Asian Americans who applied

Number (3)

Total number of other minorities who applied

Number (3)

Total number of applicants over the age of 40

Number (3)

Total number of people who were qualified for the position

Number (3)

Total number of men who were qualified for the position

Number (3)

Total number of women who were qualified for the position

Number (3)

Total number of American Indians who were qualified for the position

Number (3)

Total number of African Americans who were qualified for the position

Number (3)

Total number of Hispanic Americans who were qualified for the position

Number (3)

Total number of Asian Americans who were qualified for the position

Number (3)

Total number of other minorities who were qualified for the position

Number (3)

Total number of people over the age of 40 who were qualified for the position

Number (3)

Total number of people who received a telephone interview

Number (3)

Total number of men who received a telephone interview

Number (3)

Total number of women who received a telephone interview

Number (3)

Total number of American Indians who received a telephone interview

Number (3)

Total number of African Americans who received a telephone interview

Number (3)

Total number of Hispanic Americans who received a telephone interview

Number (3)

Total number of Asian Americans who received a telephone interview

Number (3)

Total number of other minorities who received a telephone interview

Number (3)

Total number of people over the age of 40 who received a telephone interview

Number (3)

Total number of people who received a campus interview

Number (3)

Total number of men who received a campus interview

Number (3)

Total number of women who received a campus interview

Number (3)

Total number of American Indians who received a campus interview

Number (3)

Total number of African Americans who received a campus interview

Number (3)

Total number of Hispanic Americans who received a campus interview

Number (3)

Total number of Asian Americans who received a campus interview

Number (3)

Total number of other minorities who received a campus interview

Number (3)

Total number of people over the age of 40 who received a campus interview

Number (3)

Total number of people who were offered the position

Number (3)

Total number of men who were offered the position

Number (3)

Total number of women who were offered the position

Number (3)

Total number of American Indians who were offered the position

Number (3)

Total number of African Americans who were offered the position

Number (3)

Total number of Hispanic Americans who were offered the position

Number (3)

Total number of Asian Americans who were offered the position

Number (3)

Total number of other minorities who were offered the position

Number (3)

Total number of people over the age of 40 who were offered the position

Number (3)

Total number of people who were hired

Number (3)

Total number of men who were hired

Number (3)

Total number of women who were hired

Number (3)

Total number of American Indians who were hired

Number (3)

Total number of African Americans who were hired

Number (3)

Total number of Hispanic Americans who were hired

Number (3)

Total number of Asian Americans who were hired

Number (3)

Total number of other minorities who were hired

Number (3)

Total number of people over the age of 40 who were hired

Number (3)

Total number of minorities who applied

Number (3)

Total number of minorities who were qualified for the position

Number (3)

Total number of minorities who received a telephone interview

Number (3)

Total number of minorities who received a campus interview.

Number (3)

Total number of minorities who were offered the position

Number (3)

Total number of minorities who were hired

Number (1)

Subdivision
1=Chancellor
2=Technology reporting to the Chancellor
3=Academic Support
4=CAS
5=CHD
6=CTEM
7=Student Services
8=Administrative Services
9=Student Life Services

Varchar2 (50)

Decode of Sub_Prime

Number (1)

Division
1=Chancellor
2=Provost
3=ASLS

Varchar2 (50)

Decode of prime

Date

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