EOAA Work Analysis Stout Data View Documentation

InfoAccess
DATA VIEW NAME	EOAA_WORK_ANALYSIS_STOUT
OVERVIEW	Contains data from the Federal Affirmative Action Plan on the number of men, women and minorities employed at UW-Stout by department and job group
LOAD FREQUENCY	Data is updated annually
DATA CUSTODIAN	Budget, Planning and Analysis – 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	None
QUESTIONS	Contact: Division of Information Technology Help Desk Phone: 264-HELP (4357)
LAST UPDATED	02/2004 – New view created. 07/2004 Added 6 new fields: PCT_AVAIL_WOMEN PCT_AVAIL_MINORITY GOAL_RECRUIT_WOMEN GOAL_RECRUIT_WOMEN_DESC GOAL_RECRUIT_MINORITY GOAL_RECRUIT_MINORITY_DESC 09/04 Added DEPARTMENT 103. SUB_PRIME was changed to Number 3 and School of Education was listed as a new value. 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 decimalExamples: 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 of Affirmative Action Plan

DEPARTMENT

Number(3)

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

DEPARTMENT_DESC

Varchar2(100)

Decode of Department

REF_NO

Number(3)

Unique ID number

EEOC_CODE

Number(6)

EEOC code, as listed in the Federal Affirmative Action Plan

JOB_CODE

Number(3)

Job group
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, Engineering and Management
52=Faculty: College of Arts and Sciences
53=Faculty: School of Education

JOB_CODE_DESC

Varchar2(100)

Decode of Job group

LTE_POSITION

Number(1)

Whether or not it is an LTE position:
0=not an LTE position
1=LTE position

LTE_POSITION_DESC

Varchar2(50)

Decode of whether or not it is an LTE position

WHITE_FEMALE

Number(2)

The number of White females

AFRICAN_AMERICAN_FEMALE

Number(2)

The number of African American females

HISPANIC_AMERICAN_FEMALE

Number(2)

The number of Hispanic females

ASIAN_AMERICAN_FEMALE

Number(2)

The number of Asian females

AMERICAN_INDIAN_FEMALE

Number(2)

The number of American Indian females

WHITE_MEN

Number(2)

The number of White men

AFRICAN_AMERICAN_MEN

Number(2)

The number of African American men

HISPANIC_AMERICAN_MEN

Number(2)

The number of Hispanic men

ASIAN_AMERICAN_MEN

Number(2)

The number of Asian men

AMERICAN_INDIAN_MEN

Number(2)

The number of American Indian females

TOTAL_EMPLOYEES

Number(3)

The total number of employees

TOTAL_FEMALE

Number(3)

The total number of women

TOTAL_MINORITY

Number(3)

The total number of minorities

TOTAL_MALE

Number(3)

The total number of men

PRIME

Number(2)

Unit
1=Chancellor
3=Provost
8=Administrative and Student Life Services

PRIME_DESC

Varchar2(50)

Decode of unit

SUB_PRIME

Number(3)

Sub-unit
1=Administration reporting to the
chancellor
2=Technology reporting to the Chancellor
3=Academic support
4=College of Arts and Sciences
5=College of Human Development
6=College of Technology, Engineering and Management
7=Student services
8=Administrative services
9=Student Life Services
10=School of Education

SUB_PRIME_DESC

Varchar2(50)

Decode of Sub-unit

EMPLOYMENT_CATEGORY

NUMBER (2)

Employment category:
1=classified staff
2=academic staff
3=faculty

EMPLOYMENT_CATEGORY_
DESC

Varchar2(50)

Decode of Employment category

PCT_AVAIL_WOMEN

NUMBER (2)

The availability percentage for women faculty in a given college/school (not applicable for non-faculty)

PCT_AVAIL_MINORITY

NUMBER (2)

The availability percentage for minority faculty in a given college/school (not applicable for non-faculty)

GOAL_RECRUIT_WOMEN

NUMBER (1)

Is there a recruitment goal for women in that job group?
0=no
1=yes

GOAL_RECRUIT_WOMEN_ DESC

Varchar2 (50)
Recruitment goal for women description. Valid values: yes or no

GOAL_RECRUIT_MINORITY

NUMBER (1)

Is there a recruitmetn goal for minorities in that job group?
0=no
1=yes

GOAL_RECRUIT_MINORITY_ DESC

Varchar2 (50)

Recruitment goal for minority description. Valid values: yes or no

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.
YEAR	Number(4)	Year of Affirmative Action Plan
DEPARTMENT	Number(3)	Department 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 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
DEPARTMENT_DESC	Varchar2(100)	Decode of Department
REF_NO	Number(3)	Unique ID number
EEOC_CODE	Number(6)	EEOC code, as listed in the Federal Affirmative Action Plan
JOB_CODE	Number(3)	Job group 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, Engineering and Management 52=Faculty: College of Arts and Sciences 53=Faculty: School of Education
JOB_CODE_DESC	Varchar2(100)	Decode of Job group
LTE_POSITION	Number(1)	Whether or not it is an LTE position: 0=not an LTE position 1=LTE position
LTE_POSITION_DESC	Varchar2(50)	Decode of whether or not it is an LTE position
WHITE_FEMALE	Number(2)	The number of White females
AFRICAN_AMERICAN_FEMALE	Number(2)	The number of African American females
HISPANIC_AMERICAN_FEMALE	Number(2)	The number of Hispanic females
ASIAN_AMERICAN_FEMALE	Number(2)	The number of Asian females
AMERICAN_INDIAN_FEMALE	Number(2)	The number of American Indian females
WHITE_MEN	Number(2)	The number of White men
AFRICAN_AMERICAN_MEN	Number(2)	The number of African American men
HISPANIC_AMERICAN_MEN	Number(2)	The number of Hispanic men
ASIAN_AMERICAN_MEN	Number(2)	The number of Asian men
AMERICAN_INDIAN_MEN	Number(2)	The number of American Indian females
TOTAL_EMPLOYEES	Number(3)	The total number of employees
TOTAL_FEMALE	Number(3)	The total number of women
TOTAL_MINORITY	Number(3)	The total number of minorities
TOTAL_MALE	Number(3)	The total number of men
PRIME	Number(2)	Unit 1=Chancellor 3=Provost 8=Administrative and Student Life Services
PRIME_DESC	Varchar2(50)	Decode of unit
SUB_PRIME	Number(3)	Sub-unit 1=Administration reporting to the chancellor 2=Technology reporting to the Chancellor 3=Academic support 4=College of Arts and Sciences 5=College of Human Development 6=College of Technology, Engineering and Management 7=Student services 8=Administrative services 9=Student Life Services 10=School of Education
SUB_PRIME_DESC	Varchar2(50)	Decode of Sub-unit
EMPLOYMENT_CATEGORY	NUMBER (2)	Employment category: 1=classified staff 2=academic staff 3=faculty
EMPLOYMENT_CATEGORY_ DESC	Varchar2(50)	Decode of Employment category
PCT_AVAIL_WOMEN	NUMBER (2)	The availability percentage for women faculty in a given college/school (not applicable for non-faculty)
PCT_AVAIL_MINORITY	NUMBER (2)	The availability percentage for minority faculty in a given college/school (not applicable for non-faculty)
GOAL_RECRUIT_WOMEN	NUMBER (1)	Is there a recruitment goal for women in that job group? 0=no 1=yes
GOAL_RECRUIT_WOMEN_ DESC	Varchar2 (50)	Recruitment goal for women description. Valid values: yes or no
GOAL_RECRUIT_MINORITY	NUMBER (1)	Is there a recruitmetn goal for minorities in that job group? 0=no 1=yes
GOAL_RECRUIT_MINORITY_ DESC	Varchar2 (50)	Recruitment goal for minority description. Valid values: yes or no
LAST_UPDATE_DATE_TIME	Date	The date and time the data was last updated. Format : YYYYMMDD HH24:MI:SS