萌妹社区

Human Resources 2007-08

Institution: 萌妹社区-Columbia (178396)

User ID: 29C0011

Human Resources Screening Questions

Does your institution have any part-time staff?
If you answer Yes to this question, you will be provided the screens to report part-time staff in the Employees by Assigned Position (EAP) and Fall Staff sections.
	Yes	No

Do ALL of the instructional staff at your institution fall into any of the following categories?
If you answer Yes to any of the questions below, the Salaries section is NOT applicable to your institution and you will NOT be required to report data for the Salaries section.

	No	Yes	Are ALL of the instructional staff military personnel?
	No	Yes	Do ALL of the instructional staff contribute their services (e.g., members of a religious order)?
	No	Yes	Do ALL of the instructional staff teach pre-clinical or clinical medicine?

Did your institution hire any full-time permanent staff who were included on the payroll of the institution between July 1 and October 31, 2007 either for the first time or after a break in service AND who were still on the payroll of the institution as of November 1, 2007? (Exclude persons who have returned from sabbatical leave OR full-time staff who are working less-than-9-month contracts/teaching periods and whose primary responsibility is instruction, research, and/or public service.)
If you answer Yes to this question and your institution has 15 or more full-time staff, you will be provided the screens to report full-time permanent new hires in the Fall Staff section (long version).
	Yes	No
CAVEATS

Institution: 萌妹社区-Columbia (178396)

User ID: 29C0011

Part A - Employees by Assigned Position - Full-time staff, non-medical school

Number of full-time staff (non medical) by faculty status and primary function/occupational activity As of November 1, 2007
Primary function/ occupational activity (mutually exclusive categories)	Faculty status			Without faculty status	Total
	Tenured	On tenure track	Not on tenure track/ no tenure system	Without faculty status	Total
Primarily instruction					1,242
Instruction/research/public service					63
Primarily instruction + Instruction/research/public service	622	288	395	0	1,305
Primarily research					390
Primarily public service					407
Primarily instruction + Instruction/research/public service + Primarily research + Primarily public service	738	318	1,046	0	2,102
Executive/administrative/managerial					673
Other professionals (support/service)					2,203
Technical and paraprofessionals					1,079
Clerical and secretarial					2,102
Skilled crafts					495
Service/Maintenance					1,144
Total full time (non medical)	785	319	1,046	7,648	9,798
Total from prior year	783	309	1,046	7,680	9,818

Institution: 萌妹社区-Columbia (178396)

User ID: 29C0011

Part A - Employees by Assigned Position - Full-time staff, medical school

** Applicable to institutions with M.D. or D.O. programs Number of full-time staff (medical school) by faculty status and primary function/occupational activity As of November 1, 2007**
Primary function/ occupational activity (mutually exclusive categories)	Faculty status			Without faculty status	Total
	Tenured	On tenure track	Not on tenure track/ no tenure system	Without faculty status	Total
Primarily instruction					380
Instruction/research/public service					376
Primarily instruction + Instruction/research/public service	88	52	616	0	756
Primarily research					107
Primarily public service					18
Primarily instruction + Instruction/research/public service + Primarily research + Primarily public service	107	60	714	0	881
Executive/administrative/managerial					78
Other professionals (support/service)					335
Technical and paraprofessionals					111
Clerical and secretarial					468
Skilled crafts					0
Service/Maintenance					4
Total full time (medical school)	109	60	714	994	1,877
Total from prior year	107	51	662	906	1,726
If employees in other health-related disciplines are grouped with your medical school employees, please list the other health-related disciplines here.

Institution: 萌妹社区-Columbia (178396)

User ID: 29C0011

Part B - Employees by Assigned Position - Part-time staff, non-medical school

Number of part-time staff (non medical) by faculty status and primary function/occupational activity As of November 1, 2007
Primary function/ occupational activity (mutually exclusive categories)	Faculty status			Without faculty status	Total	Graduate assistants
	Tenured	On tenure track	Not on tenure track/ no tenure system	Without faculty status	Total	Graduate assistants
Primarily instruction					626
Instruction/research/public service					197
Primarily instruction + Instruction/research/public service	2	2	819	0	823	1,527
Primarily research					99
Primarily public service					56
Primarily instruction + Instruction/research/public service + Primarily research + Primarily public service	3	3	972	0	978	2,083
Executive/administrative/managerial					34
Other professionals (support/service)					1,134
Technical and paraprofessionals					633
Clerical and secretarial					516
Skilled crafts					21
Service/Maintenance					939
Total part time (non medical)	4	3	972	3,276	4,255	2,083
Total from prior year	3	2	931	3,376	4,312	2,087

Institution: 萌妹社区-Columbia (178396)

User ID: 29C0011

Part B - Employees by Assigned Position - Part-time staff, medical school

** Applicable to institutions with M.D. or D.O. programs Number of part-time staff (medical school) by faculty status and primary function/occupational activity As of November 1, 2007**
Primary function/ occupational activity (mutually exclusive categories)	Faculty status			Without faculty status	Total	Graduate assistants
	Tenured	On tenure track	Not on tenure track/ no tenure system	Without faculty status	Total	Graduate assistants
Primarily instruction					142
Instruction/research/public service/clinical					18
Primarily instruction + Instruction/research/public service/clinical	15	5	140	0	160	58
Primarily research					18
Primarily public service					10
Primarily instruction + Instruction/research/public service/clinical + Primarily research + Primarily public service	17	7	164	0	188	102
Executive/administrative/managerial					6
Other professionals (support/service)					70
Technical and paraprofessionals					39
Clerical and secretarial					74
Skilled crafts					0
Service/Maintenance					7
Total part time (medical school)	17	7	164	196	384	102
Total from prior year	14	5	161	197	377	95
If employees in other health-related disciplines are grouped with your medical school employees, please list the other health-related disciplines here.

Institution: 萌妹社区-Columbia (178396)

User ID: 29C0011

Part C - Employees by Assigned Position - Total number of staff

Total number of staff by employment status and primary function/occupational activity (Excludes graduate assistants) As of November 1, 2007
Primary function/occupational activity	Full-time	Full-time py	Part-time	Part-time py	Total
Primarily instruction	1,622	1,568	768	694	2,390
Instruction/research/public service	439	426	215	224	654
Primarily instruction + Instruction/research/public service	2,061	1,994	983	918	3,044
Primarily research	497	494	117	134	614
Primarily public service	425	419	66	62	491
Primarily instruction + Instruction/research/public service + Primarily research + Primarily public service	2,983	2,907	1,166	1,114	4,149
Executive/administrative/managerial	751	739	40	42	791
Other professionals (support/service)	2,538	2,507	1,204	1,195	3,742
Technical and paraprofessionals	1,190	1,177	672	683	1,862
Clerical and secretarial	2,570	2,556	590	609	3,160
Skilled crafts	495	504	21	26	516
Service/Maintenance	1,148	1,154	946	1,020	2,094
Grand total	11,675	11,544	4,639	4,689	16,314

Institution: 萌妹社区-Columbia (178396)

User ID: 29C0011

Part D - Salaries - Full-time instructional staff by contract length/teaching period - Headcount

Number of full-time instructional staff by contract length/teaching period, gender, and academic rank As of November 1, 2007
Gender and academic rank	Less-than-9-month	9/10-month	11/12-month	Total
Men
Professors				272
Associate professors				220
Assistant professors				218
Instructors				31
Lecturers				21
No academic rank				34
Total men	5	564	227	796
Women
Professors				76
Associate professors				133
Assistant professors				189
Instructors				67
Lecturers				27
No academic rank				17
Total women	8	332	169	509
Total (men + women)	13	896	396	1,305
Total from EAP, full-time non-medical section (Primarily instruction + Instruction/research/public service lines)				1,305
Total from prior year (Salaries section)	7	887	389	1,283

Institution: 萌妹社区-Columbia (178396)

User ID: 29C0011

Part D - Salaries - Full-time instructional staff on 9/10-month contracts/teaching periods - Faculty status

** Applicable to 4-year degree-granting institutions only Number of full-time instructional staff on 9/10-month contracts/teaching periods by faculty status, gender, and academic rank As of November 1, 2007**
Gender and academic rank	Faculty status			Without faculty status	Total from Part D (Headcount screen)
Gender and academic rank	Tenured	On tenure track	Not on tenure track/ no tenure system	Without faculty status	Total from Part D (Headcount screen)
Men
Professors					198
Associate Professors					169
Assistant Professors					172
Instructors					12
Lecturers
No academic rank					13
Total men	340	148	76	0	564
Total men prior year	347	144	74	0	565
Women
Professors					62
Associate Professors					105
Assistant Professors					139
Instructors					21
Lecturers					2
No academic rank					3
Total women	147	103	82	0	332
Total women prior year	139	94	89	0	322
Total (men + women)	487	251	158	0	896

Institution: 萌妹社区-Columbia (178396)

User ID: 29C0011

Part D - Salaries - Full-time instructional staff on 11/12-month contracts/teaching periods - Faculty status

** Applicable to 4-year degree-granting institutions only Number of full-time instructional staff on 11/12-month contracts/teaching periods by faculty status, gender, and academic rank As of November 1, 2007**
Gender and academic rank	Faculty status			Without faculty status	Total from Part D (Headcount screen)
Gender and academic rank	Tenured	On tenure track	Not on tenure track/ no tenure system	Without faculty status	Total from Part D (Headcount screen)
Men
Professors					72
Associate Professors					51
Assistant Professors					46
Instructors					18
Lecturers					21
No academic rank					19
Total men	106	19	102	0	227
Total men prior year	109	20	101	0	230
Women
Professors					14
Associate Professors					28
Assistant Professors					50
Instructors					41
Lecturers					23
No academic rank					13
Total women	29	18	122	0	169
Total women prior year	30	19	110	0	159
Total (men + women)	135	37	224	0	396

Institution: 萌妹社区-Columbia (178396)

User ID: 29C0011

Part E - Salaries - Full-time instructional staff on 9/10-month contracts/teaching periods - Salary outlays

Salaries of full-time instructional staff on 9/10-month contracts/teaching periods by gender and academic rank As of November 1, 2007
Gender and academic rank	Number	Salary outlays	Average salary	Prior year Average salary
Men
Professors	198		104,573	102,015
Associate professors	169		73,417	70,801
Assistant professors	172		60,163	59,632
Instructors	12		42,035	34,404
Lecturers				71,481
No academic rank	13		47,100	48,767
Total men	564	44,577,639
Women
Professors	62		94,391	91,659
Associate professors	105		67,342	64,765
Assistant professors	139		56,394	53,597
Instructors	21		42,403	39,884
Lecturers	2		51,048	46,974
No academic rank	3		37,876	41,429
Total women	332	21,868,055
Total (men + women)	896	66,445,694

Institution: 萌妹社区-Columbia (178396)

User ID: 29C0011

Part E - Salaries - Full-time instructional staff on 11/12-month contracts/teaching periods - Salary outlays

Salaries of full-time instructional staff on 11/12-month contracts/teaching periods by gender and academic rank As of November 1, 2007
Gender and academic rank	Number	Salary outlays	Average salary	Prior year Average salary
Men
Professors	72		131,098	129,928
Associate professors	51		87,533	84,970
Assistant professors	46		71,489	69,382
Instructors	18		48,322	47,284
Lecturers	21		39,105	41,332
No academic rank	19		38,034	36,059
Total men	227	19,605,394
Women
Professors	14		119,092	111,091
Associate professors	28		82,654	79,083
Assistant professors	50		67,725	65,936
Instructors	41		44,874	44,870
Lecturers	23		30,239	31,168
No academic rank	13		35,745	30,911
Total women	169	10,367,877
Total (men + women)	396	29,973,271

Institution: 萌妹社区-Columbia (178396)

User ID: 29C0011

Part F - Salaries - Full-time instructional staff on 9/10-month contracts/teaching periods - Fringe benefits

Fringe benefits of full-time instructional staff on 9/10-month contracts/teaching periods As of November 1, 2007
Fringe benefits	Number covered	Expenditures	Average expenditures	Prior year Average expenditures
Retirement plans (other than Social Security) - Vested within 5-years
Retirement plans (other than Social Security) - Vested after 5-years			7,532	7,313
Medical/dental plans			5,693	5,630
Group life insurance			70	54
Other insurance benefits (cafeteria plan, etc.)
Guaranteed disability income protection			203	310
Tuition plan (dependents only)
Unrestricted
Restricted
Housing plan
Unrestricted
Restricted
Social Security taxes			5,375	5,198
Unemployment compensation taxes			61	59
Worker's compensation taxes			504	552
Other benefits in kind with cash options
Total expenditures		17,251,507

Institution: 萌妹社区-Columbia (178396)

User ID: 29C0011

Part F - Salaries - Full-time instructional staff on 11/12-month contracts/teaching periods - Fringe benefits

Fringe benefits of full-time instructional staff on 11/12-month contracts/teaching periods As of November 1, 2007
Fringe benefits	Number covered	Expenditures	Average expenditures	Prior year Average expenditures
Retirement plans (other than Social Security) - Vested within 5-years
Retirement plans (other than Social Security) - Vested after 5-years			6,968	7,105
Medical/dental plans			5,848	6,064
Group life insurance			73	59
Other insurance benefits (cafeteria plan, etc.)
Guaranteed disability income protection			212	335
Tuition plan (dependents only)
Unrestricted
Restricted
Housing plan
Unrestricted
Restricted
Social Security taxes			5,285	5,251
Unemployment compensation taxes			63	62
Worker's compensation taxes			515	581
Other benefits in kind with cash options
Total expenditures		7,390,479

Institution: 萌妹社区-Columbia (178396)

User ID: 29C0011

Part G - Fall Staff - Full-time instruction/research/public service staff - Tenured

Number of full-time staff with faculty status who are Tenured and whose primary responsibility is instruction, research, and/or public service by academic rank, gender, and race/ethnicity As of November 1, 2007
Gender and race/ethnicity	Professors	Associate professors	Assistant professors	Instructors	Lecturers	No academic rank	Total
Men
Nonresident Alien							1
Black, non-Hispanic							14
American Indian/Alaska Native							0
Asian/Pacific Islander							80
Hispanic							12
White, non-Hispanic							528
Race/ethnicity unknown							0
Total men	386	248	1	0	0	0	635
Women
Nonresident Alien							0
Black, non-Hispanic							14
American Indian/Alaska Native							1
Asian/Pacific Islander							10
Hispanic							5
White, non-Hispanic							180
Race/ethnicity unknown							0
Total women	91	116	1	1	1	0	210
Total (men+women)	477	364	2	1	1	0	845
Total from EAP							845

Institution: 萌妹社区-Columbia (178396)

User ID: 29C0011

Part G - Fall Staff - Full-time instruction/research/public service staff - On tenure track

Number of full-time staff with faculty status who are On tenure track and whose primary responsibility is instruction, research, and/or public service by academic rank, gender, and race/ethnicity As of November 1, 2007
Gender and race/ethnicity	Professors	Associate professors	Assistant professors	Instructors	Lecturers	No academic rank	Total
Men
Nonresident Alien							38
Black, non-Hispanic							7
American Indian/Alaska Native							0
Asian/Pacific Islander							29
Hispanic							9
White, non-Hispanic							155
Race/ethnicity unknown							0
Total men	3	25	209	0	1	0	238
Women
Nonresident Alien							19
Black, non-Hispanic							4
American Indian/Alaska Native							0
Asian/Pacific Islander							12
Hispanic							3
White, non-Hispanic							102
Race/ethnicity unknown							0
Total women	0	8	131	1	0	0	140
Total (men+women)	3	33	340	1	1	0	378
Total from EAP							378

Institution: 萌妹社区-Columbia (178396)

User ID: 29C0011

Part G - Fall Staff - Full-time instruction/research/public service staff - Not on tenure track/no tenure system

Number of full-time staff with faculty status who are Not on tenure track and whose primary responsibility is instruction, research, and/or public service OR number of full-time staff whose primary responsibility is instruction, research, and/or public service and who work at an institution with No tenure system by academic rank, gender, and race/ethnicity As of November 1, 2007
Gender and race/ethnicity	Professors	Associate professors	Assistant professors	Instructors	Lecturers	No academic rank	Total
Men
Nonresident Alien							240
Black, non-Hispanic							18
American Indian/Alaska Native							3
Asian/Pacific Islander							69
Hispanic							17
White, non-Hispanic							653
Race/ethnicity unknown							8
Total men	27	69	212	45	429	226	1,008
Women
Nonresident Alien							106
Black, non-Hispanic							24
American Indian/Alaska Native							3
Asian/Pacific Islander							61
Hispanic							16
White, non-Hispanic							541
Race/ethnicity unknown							1
Total women	5	48	148	89	326	136	752
Total (men+women)	32	117	360	134	755	362	1,760
Total from EAP							1,760

Institution: 萌妹社区-Columbia (178396)

User ID: 29C0011

Part G - Fall Staff - Full-time instruction/research/public service staff - Without faculty status

Number of full-time staff Without faculty status whose primary responsibility is instruction, research, and/or public service by gender and race/ethnicity As of November 1, 2007
Gender and race/ethnicity	Total
Men
Nonresident Alien
Black, non-Hispanic
American Indian/Alaska Native
Asian/Pacific Islander
Hispanic
White, non-Hispanic
Race/ethnicity unknown
Total men
Women
Nonresident Alien
Black, non-Hispanic
American Indian/Alaska Native
Asian/Pacific Islander
Hispanic
White, non-Hispanic
Race/ethnicity unknown
Total women
Total (men+women)
Total from EAP	0

Institution: 萌妹社区-Columbia (178396)

User ID: 29C0011

Part G - Fall Staff - Full-time instruction/research/public service staff - Totals

Total number of full-time staff whose primary responsibility is instruction, research, and/or public service by gender and race/ethnicity As of November 1, 2007
	Total men	Total women	Total (men+women)
Nonresident Alien	279	125	404
Black, non-Hispanic	39	42	81
American Indian/Alaska Native	3	4	7
Asian/Pacific Islander	178	83	261
Hispanic	38	24	62
White, non-Hispanic	1,336	823	2,159
Race/ethnicity unknown	8	1	9
Total (must equal Part H (next part))	1,881	1,102	2,983

Institution: 萌妹社区-Columbia (178396)

User ID: 29C0011

Part H - Fall Staff - Full-time instruction/research/public service staff by contract length/teaching period - Headcount

Number of full-time staff whose primary responsibility is instruction, research, and/or public service by contract length/teaching period, gender, and race/ethnicity (Include all staff from these functions, including those with and without faculty status.) As of November 1, 2007
Gender and race/ethnicity	Less-than-9-month	9/10-month	11/12-month	Total	Total from Part G
Men
Nonresident Alien				279	279
Black, non-Hispanic				39	39
American Indian/Alaska Native				3	3
Asian/Pacific Islander				178	178
Hispanic				38	38
White, non-Hispanic				1,336	1,336
Race/ethnicity unknown				8	8
Total men	10	605	1,266	1,881	1,881
Women
Nonresident Alien				125	125
Black, non-Hispanic				42	42
American Indian/Alaska Native				4	4
Asian/Pacific Islander				83	83
Hispanic				24	24
White, non-Hispanic				823	823
Race/ethnicity unknown				1	1
Total women	9	344	749	1,102	1,102
Total (men+women)	19	949	2,015	2,983	2,983
Total from EAP				2,983
Total (men+women) from Fall 2005	12	903	1,874

Institution: 萌妹社区-Columbia (178396)

User ID: 29C0011

Part H - Fall Staff - Full-time instruction/research/public service staff on 9/10-month contracts/teaching periods - Salary class intervals

Number of full-time staff on 9/10-month contracts/teaching periods whose primary responsibility is instruction, research, and/or public service by salary class intervals, gender, and race/ethnicity (Include all staff from these functions, including those with and without faculty status.) As of November 1, 2007
Gender and race/ethnicity	Below $30,000	30,000-39,999	40,000-49,999	50,000-64,999	65,000-79,999	80,000-99,999	100,000 and above	Total from Part H (Headcount screen)
Men
Nonresident Alien								51
Black, non-Hispanic								20
American Indian/Alaska Native								0
Asian/Pacific Islander								72
Hispanic								15
White, non-Hispanic								447
Race/ethnicity unknown								0
Total men	2	20	63	126	148	123	123	605
Women
Nonresident alien								23
Black, non-Hispanic								16
American Indian/Alaska Native								1
Asian/Pacific Islander								23
Hispanic								8
White, non-Hispanic								273
Race/ethnicity unknown								0
Total women	3	18	56	137	53	43	34	344
Total (men+women)	5	38	119	263	201	166	157	949

Institution: 萌妹社区-Columbia (178396)

User ID: 29C0011

Part H - Fall Staff - Full-time instruction/research/public service staff on 11/12-month contracts/teaching periods - Salary class intervals

Number of full-time staff on 11/12-month contracts/teaching periods whose primary responsibility is instruction, research, and/or public service by salary class intervals, gender, and race/ethnicity (Include all staff from these functions, including those with and without faculty status.) As of November 1, 2007
Gender and race/ethnicity	Below $30,000	30,000-39,999	40,000-49,999	50,000-64,999	65,000-79,999	80,000-99,999	100,000 and above	Total from Part H (Headcount screen)
Men
Nonresident Alien								222
Black, non-Hispanic								19
American Indian/Alaska Native								3
Asian/Pacific Islander								106
Hispanic								23
White, non-Hispanic								885
Race/ethnicity unknown								8
Total men	26	125	340	202	101	121	351	1,266
Women
Nonresident Alien								99
Black, non-Hispanic								26
American Indian/Alaska Native								3
Asian/Pacific Islander								60
Hispanic								14
White, non-Hispanic								546
Race/ethnicity unknown								1
Total women	38	120	245	146	60	47	93	749
Total (men+women)	64	245	585	348	161	168	444	2,015

Institution: 萌妹社区-Columbia (178396)

User ID: 29C0011

Part I - Fall Staff - Full-time executive/administrative/managerial staff - Salary class intervals

Number of full-time executive/administrative/managerial staff by salary class intervals, gender, and race/ethnicity As of November 1, 2007
Gender and race/ethnicity	Below $30,000	30,000-39,999	40,000-49,999	50,000-64,999	65,000-79,999	80,000-99,999	100,000 and above	Total
Men
Nonresident Alien								1
Black, non-Hispanic								16
American Indian/Alaska Native								4
Asian/Pacific Islander								9
Hispanic								0
White, non-Hispanic								376
Race/ethnicity unknown								1
Total men	7	18	33	74	73	71	131	407
Women
Nonresident Alien								0
Black, non-Hispanic								12
American Indian/Alaska Native								2
Asian/Pacific Islander								2
Hispanic								3
White, non-Hispanic								325
Race/ethnicity unknown								0
Total women	10	19	33	112	68	53	49	344
Total (men+women)	17	37	66	186	141	124	180	751
Total from EAP								751

Institution: 萌妹社区-Columbia (178396)

User ID: 29C0011

Part I - Fall Staff - Full-time other professional (support/service) staff - Salary class intervals

Number of full-time other professional (support/service) staff by salary class intervals, gender, and race/ethnicity As of November 1, 2007
Gender and race/ethnicity	Below $30,000	30,000-39,999	40,000-49,999	50,000-64,999	65,000-79,999	80,000-99,999	100,000 and above	Total
Men
Nonresident alien								19
Black, non-Hispanic								38
American Indian/Alaska Native								7
Asian/Pacific Islander								28
Hispanic								14
White, non-Hispanic								822
Race/ethnicity unknown								3
Total men	50	208	250	243	99	33	48	931
Women
Nonresident alien								20
Black, non-Hispanic								40
American Indian/Alaska Native								7
Asian/Pacific Islander								52
Hispanic								19
White, non-Hispanic								1,469
Race/ethnicity unknown								0
Total women	112	389	437	457	153	38	21	1,607
Total (men+women)	162	597	687	700	252	71	69	2,538
Total from EAP								2,538

Institution: 萌妹社区-Columbia (178396)

User ID: 29C0011

Part I - Fall Staff - Full-time technical and paraprofessional staff - Salary class intervals

Number of full-time technical and paraprofessional staff by salary class intervals, gender, and race/ethnicity As of November 1, 2007
Gender and race/ethnicity	Below $20,000	20,000-29,999	30,000-39,999	40,000-49,999	50,000 and above	Total
Men
Nonresident alien						1
Black, non-Hispanic						20
American Indian/Alaska Native						4
Asian/Pacific Islander						16
Hispanic						6
White, non-Hispanic						456
Race/ethnicity unknown						3
Total men	13	136	170	112	75	506
Women
Nonresident alien						4
Black, non-Hispanic						46
American Indian/Alaska Native						3
Asian/Pacific Islander						22
Hispanic						9
White, non-Hispanic						600
Race/ethnicity unknown						0
Total women	8	284	250	80	62	684
Total (men+women)	21	420	420	192	137	1,190
Total from EAP						1,190

Institution: 萌妹社区-Columbia (178396)

User ID: 29C0011

Part I - Fall Staff - Full-time clerical and secretarial staff- Salary class intervals

Number of full-time clerical and secretarial staff by salary class intervals, gender, and race/ethnicity As of November 1, 2007
Gender and race/ethnicity	Below $20,000	20,000-29,999	30,000-39,999	40,000-49,999	50,000 and above	Total
Men
Nonresident alien						3
Black, non-Hispanic						27
American Indian/Alaska Native						2
Asian/Pacific Islander						9
Hispanic						3
White, non-Hispanic						237
Race/ethnicity unknown						6
Total men	44	179	52	11	1	287
Women
Nonresident alien						2
Black, non-Hispanic						197
American Indian/Alaska Native						15
Asian/Pacific Islander						29
Hispanic						37
White, non-Hispanic						2,001
Race/ethnicity unknown						2
Total women	134	1,442	555	133	19	2,283
Total (men+women)	178	1,621	607	144	20	2,570
Total from EAP						2,570

Institution: 萌妹社区-Columbia (178396)

User ID: 29C0011

Part I - Fall Staff - Full-time skilled crafts staff - Salary class intervals

Number of full-time skilled crafts staff by salary class intervals, gender, and race/ethnicity As of November 1, 2007
Gender and race/ethnicity	Below $20,000	20,000-29,999	30,000-39,999	40,000-49,999	50,000 and above	Total
Men
Nonresident alien						0
Black, non-Hispanic						23
American Indian/Alaska Native						5
Asian/Pacific Islander						0
Hispanic						2
White, non-Hispanic						442
Race/ethnicity unknown						0
Total men	1	7	262	169	33	472
Women
Nonresident alien						0
Black, non-Hispanic						2
American Indian/Alaska Native						0
Asian/Pacific Islander						0
Hispanic						0
White, non-Hispanic						21
Race/ethnicity unknown						0
Total women	2	3	13	5	0	23
Total (men+women)	3	10	275	174	33	495
Total from EAP						495

Institution: 萌妹社区-Columbia (178396)

User ID: 29C0011

Part I - Fall Staff - Full-time service/maintenance staff - Salary class intervals

Number of full-time service/maintenance staff by salary class intervals, gender, and race/ethnicity As of November 1, 2007
Gender and race/ethnicity	Below $20,000	20,000-29,999	30,000-39,999	40,000-49,999	50,000 and above	Total
Men
Nonresident alien						1
Black, non-Hispanic						151
American Indian/Alaska Native						11
Asian/Pacific Islander						6
Hispanic						11
White, non-Hispanic						461
Race/ethnicity unknown						5
Total men	142	414	74	14	2	646
Women
Nonresident alien						3
Black, non-Hispanic						136
American Indian/Alaska Native						6
Asian/Pacific Islander						8
Hispanic						32
White, non-Hispanic						317
Race/ethnicity unknown						0
Total women	131	333	36	1	1	502
Total (men+women)	273	747	110	15	3	1,148
Total from EAP						1,148

Institution: 萌妹社区-Columbia (178396)

User ID: 29C0011

Part I - Fall Staff - Full-time staff (excluding instruction/research/public service staff) - Totals

Total number of full-time staff by primary function/occupational activity, gender, and race/ethnicity As of November 1, 2007
Gender and race/ethnicity	Executive/ administrative/ managerial	Other professionals (support/service)	Technical and paraprofessionals	Clerical and secretarial	Skilled crafts	Service/ Maintenance	Total
Men
Nonresident alien	1	19	1	3	0	1	25
Black, non-Hispanic	16	38	20	27	23	151	275
American Indian/Alaska Native	4	7	4	2	5	11	33
Asian/Pacific Islander	9	28	16	9	0	6	68
Hispanic	0	14	6	3	2	11	36
White, non-Hispanic	376	822	456	237	442	461	2,794
Race/ethnicity unknown	1	3	3	6	0	5	18
Total men	407	931	506	287	472	646	3,249
Women
Nonresident alien	0	20	4	2	0	3	29
Black, non-Hispanic	12	40	46	197	2	136	433
American Indian/Alaska Native	2	7	3	15	0	6	33
Asian/Pacific Islander	2	52	22	29	0	8	113
Hispanic	3	19	9	37	0	32	100
White, non-Hispanic	325	1,469	600	2,001	21	317	4,733
Race/ethnicity unknown	0	0	0	2	0	0	2
Total women	344	1,607	684	2,283	23	502	5,443
Total (men+women)	751	2,538	1,190	2,570	495	1,148	8,692
Total from EAP	751	2,538	1,190	2,570	495	1,148

Institution: 萌妹社区-Columbia (178396)

User ID: 29C0011

Part J - Fall Staff - Part-time professional staff

Number of part-time staff by primary function/occupational activity, gender, and race/ethnicity As of November 1, 2007
Gender and race/ethnicity	Staff whose primary responsibility is instruction, research, and/or public service	Executive/ administrative/ managerial	Other professionals (support/service)
Men
Nonresident Alien
Black, non-Hispanic
American Indian/Alaska Native
Asian/Pacific Islander
Hispanic
White, non-Hispanic
Race/ethnicity unknown
Total men	626	15	251
Women
Nonresident Alien
Black, non-Hispanic
American Indian/ Alaska Native
Asian/Pacific Islander
Hispanic
White, non-Hispanic
Race/ethnicity unknown
Total women	540	25	953
Total (men+women)	1,166	40	1,204
Total from EAP	1,166	40	1,204

Institution: 萌妹社区-Columbia (178396)

User ID: 29C0011

Part J - Fall Staff - Part-time non-professional staff

Number of part-time staff by primary function/occupational activity, gender, and race/ethnicity As of November 1, 2007
Gender and race/ethnicity	Technical and paraprofessionals	Clerical and secretarial	Skilled crafts	Service/ Maintenance
Men
Nonresident Alien
Black, non-Hispanic
American Indian/Alaska Native
Asian/Pacific Islander
Hispanic
White, non-Hispanic
Race/ethnicity unknown
Total men	238	102	21	482
Women
Nonresident Alien
Black, non-Hispanic
American Indian/Alaska Native
Asian/Pacific Islander
Hispanic
White, non-Hispanic
Race/ethnicity unknown
Total women	434	488	0	464
Total (men+women)	672	590	21	946
Total from EAP	672	590	21	946

Institution: 萌妹社区-Columbia (178396)

User ID: 29C0011

Part J - Fall Staff - Graduate assistants and part-time staff totals

Number of part-time staff by primary function/occupational activity, gender, and race/ethnicity As of November 1, 2007
Gender and race/ethnicity	Subtotal	Graduate assistants	Part-time total
Men
Nonresident Alien	37		465
Black, non-Hispanic	114		139
American Indian/Alaska Native	11		14
Asian/Pacific Islander	36		56
Hispanic	23		41
White, non-Hispanic	1,498		2,164
Race/ethnicity unknown	16		17
Total men	1,735	1,161	2,896
Women
Nonresident Alien	31		327
Black, non-Hispanic	186		233
American Indian/ Alaska Native	20		23
Asian/Pacific Islander	76		98
Hispanic	43		76
White, non-Hispanic	2,544		3,167
Race/ethnicity unknown	4		4
Total women	2,904	1,024	3,928
Total (men+women)	4,639	2,185	6,824
Total from EAP		2,185

Institution: 萌妹社区-Columbia (178396)

User ID: 29C0011

Part K - Fall Staff - Total number of staff

Total number of staff by employment status, gender, and race/ethnicity As of November 1, 2007
Gender and race/ethnicity	Full-time men	Full-time women	Part-time men	Part-time women	Total men	Total women
Nonresident alien	304	154	465	327	769	481
Black, non-Hispanic	314	475	139	233	453	708
American Indian/Alaska Native	36	37	14	23	50	60
Asian/Pacific Islander	246	196	56	98	302	294
Hispanic	74	124	41	76	115	200
White, non-Hispanic	4,130	5,556	2,164	3,167	6,294	8,723
Race/ethnicity unknown	26	3	17	4	43	7
Grand total	5,130	6,545	2,896	3,928	8,026	10,473

Institution: 萌妹社区-Columbia (178396)

User ID: 29C0011

Part L - Fall Staff - New hires - Full-time instruction/research/public service staff - Faculty status

Number of full-time permanent new hires whose primary responsibility is instruction, research, and/or public service by faculty status, gender, and race/ethnicity (Hired full time between July 1 and October 31, 2007 and still on payroll of the institution as of November 1, 2007)
Gender and race/ethnicity	Faculty status			Without faculty status	Total
Gender and race/ethnicity	Tenured	On tenure track	Not on tenure track/ no tenure system	Without faculty status	Total
Men
Nonresident Alien					53
Black, non-Hispanic					0
American Indian/Alaska Native					1
Asian/Pacific Islander					20
Hispanic					4
White, non-Hispanic					90
Race/ethnicity unknown					0
Total men	5	29	134	0	168
Women
Nonresident Alien					29
Black, non-Hispanic					3
American Indian/Alaska Native					0
Asian/Pacific Islander					13
Hispanic					0
White, non-Hispanic					78
Race/ethnicity unknown					0
Total women	1	28	94	0	123
Total (men+women)	6	57	228	0	291

Institution: 萌妹社区-Columbia (178396)

User ID: 29C0011

Part L - Fall Staff - New hires - Full-time staff by position

Number of full-time permanent new hires by primary function/occupational activity, gender, and race/ethnicity (Hired full time between July 1 and October 31, 2007 and still on payroll of the institution as of November 1, 2007)</)< b>
Gender and race/ethnicity	Executive/ administrative/ managerial	Other professionals (support/service)	Technical and paraprofessionals	Clerical and secretarial	Skilled crafts	Service/ Maintenance	Total
Men
Nonresident Alien							4
Black, non-Hispanic							13
American Indian/Alaska Native							1
Asian/Pacific Islander							5
Hispanic							2
White, non-Hispanic							117
Race/ethnicity unknown							0
Total men	13	39	22	29	4	35	142
Women
Nonresident Alien							1
Black, non-Hispanic							30
American Indian/Alaska Native							3
Asian/Pacific Islander							8
Hispanic							8
White, non-Hispanic							247
Race/ethnicity unknown							0
Total women	11	89	49	121	0	27	297
Total (men+women)	24	128	71	150	4	62	439

Institution: 萌妹社区-Columbia (178396)

User ID: 29C0011

Part L - Fall Staff - New hires - Totals

Total number of full-time permanent new hires by gender and race/ethnicity (Hired full time between July 1 and October 31, 2007 and still on payroll of the institution as of November 1, 2007)</)< b>
	Total men	Total women	Total (men+women)
Nonresident Alien	57	30	87
Black, non-Hispanic	13	33	46
American Indian/Alaska Native	2	3	5
Asian/Pacific Islander	25	21	46
Hispanic	6	8	14
White, non-Hispanic	207	325	532
Race/ethnicity unknown	0	0	0
Grand total	310	420	730
Grand total from Fall 2005	267	313	580

Institution: 萌妹社区-Columbia (178396)

User ID: 29C0011

Human Resources Survey Evaluation

Were any staff members difficult to categorize? If so, please explain in the box below.

Institution: University of Missouri-Columbia (178396)

User ID: 29C0011

Explanation Report

Number

Source

Location

Description

Severity

Accepted

Screen: Headcount

Row 25
Column 2

Upload File

The number entered, 19, has an expected range of between 9 and 15. Please explain this difference.

Explanation

Yes

Reason:

Due to the baseline from Fall 2005 being a low amount, a slight or modest increase over a 2-year period will be over the expected 25% range.

Global Edits

Perform Edits

The average salary for one of the academic ranks in 9/10 month contracts 42035, is not within the expected range between 27524 and 41284. Please fix or explain.

Explanation

Yes

Reason:

Verified of the men 9/10 month Instructors; 6 are new hires with an average of $42,625 and 6 are renewed contracts with an average of $41,445.

Perform Edits

The average salary for one of the academic ranks in 9/10 month contracts 0, is not within the expected range between 57185 and 85777. Please fix or explain.

Explanation

Yes

Reason:

There are no male 9/10 Instructors to report this reporting year.

Global Edits

Perform Edits

The average expenditure for one of benefits in 9/10 month contracts 203, is not within the expected range between 217 and 403. Please fix or explain.

Explanation

Yes

Reason:

University reduced employee and employer cost premiums for Long Term Disability by 35%.

Global Edits

Perform Edits

The average expenditure for one of benefits in 11/12 month contracts 212, is not within the expected range between 235 and 435. Please fix or explain.

Explanation

Yes

Reason:

University reduced employee and employer cost premiums for Long Term Disability by 35%.