Survey

Human Resources 2011-12

Institution: University of 欧美日b大片-Columbia (178396)

User ID: 29C0011

Overview

Human Resources Overview
	Welcome to the IPEDS Human Resources (HR) survey component. This survey collects important information about your institution's staff.
	Data Reporting Reminders
	You must enter data on each displayed screen. If a screen is not applicable, you must enter at least one zero in a field on the screen.



	Resources: To download the survey materials for this component:
	To access your prior year data submission for this component:
If you have questions about completing this survey, please contact the IPEDS Help Desk at 1-877-225-2568.

Institution: University of 欧美日b大片-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.*
	Yes	No
Does your institution have 15 or more full-time staff?

	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, Part G is NOT applicable to your institution and you will NOT be required to report data for Part G.

	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?

You may use the space below to provide context for the data you've reported above.

Institution: University of 欧美日b大片-Columbia (178396)

User ID: 29C0011

Human Resources Screening Questions

Did your institution hire any full-time permanent staff who were included on the payroll of the institution between July 1 and October 31, 2011 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, 2011? (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

Institution: University of 欧美日b大片-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, 2011
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,307
Instruction/research/public service					73
Primarily instruction + Instruction/research/public service	670	236	474	0	1,380
Primarily research					398
Primarily public service					391
Primarily instruction + Instruction/research/public service + Primarily research + Primarily public service	781	260	1,128	0	2,169
Executive/administrative/managerial					710
Other professionals (support/service)					2,484
Technical and paraprofessionals					1,118
Clerical and secretarial					2,036
Skilled crafts					505
Service/Maintenance					1,224
Total full time (non medical)	830	261	1,128	8,027	10,246
Total from prior year	797	275	1,104	8,006	10,182

Institution: University of 欧美日b大片-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, 2011**
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					440
Instruction/research/public service					433
Primarily instruction + Instruction/research/public service	95	56	722	0	873
Primarily research					79
Primarily public service					9
Primarily instruction + Instruction/research/public service + Primarily research + Primarily public service	108	64	789	0	961
Executive/administrative/managerial					79
Other professionals (support/service)					369
Technical and paraprofessionals					109
Clerical and secretarial					455
Skilled crafts					0
Service/Maintenance					5
Total full time (medical school)	108	64	789	1,017	1,978
Total from prior year	108	67	779	984	1,938
If employees in other health-related disciplines are grouped with your medical school employees, please list the other health-related disciplines here.

Institution: University of 欧美日b大片-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, 2011
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					771
Instruction/research/public service					186
Primarily instruction + Instruction/research/public service	7	3	947	0	957	1,865
Primarily research					77
Primarily public service					56
Primarily instruction + Instruction/research/public service + Primarily research + Primarily public service	9	3	1,078	0	1,090	2,499
Executive/administrative/managerial					32
Other professionals (support/service)					1,355
Technical and paraprofessionals					547
Clerical and secretarial					468
Skilled crafts					21
Service/Maintenance					860
Total part time (non medical)	10	3	1,078	3,282	4,373	2,499
Total from prior year	10	4	1,041	3,342	4,397	2,368

Institution: University of 欧美日b大片-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, 2011**
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					203
Instruction/research/public service/clinical					12
Primarily instruction + Instruction/research/public service/clinical	9	7	199	0	215	75
Primarily research					12
Primarily public service					9
Primarily instruction + Instruction/research/public service/clinical + Primarily research + Primarily public service	12	8	216	0	236	114
Executive/administrative/managerial					3
Other professionals (support/service)					89
Technical and paraprofessionals					39
Clerical and secretarial					100
Skilled crafts					0
Service/Maintenance					4
Total part time (medical school)	12	8	216	235	471	114
Total from prior year	11	8	192	153	364	123
If employees in other health-related disciplines are grouped with your medical school employees, please list the other health-related disciplines here.

Institution: University of 欧美日b大片-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 As of November 1, 2011
Primary function/occupational activity	Full-time	Full-time from prior year	Part-time	Part-time from prior year	Graduate assistants	Graduate assistants from prior year	Total including Graduate assistants
Primarily instruction	1,747	1,673	974	888	1,682	1,568	4,403
Instruction/research/public service	506	527	198	223	258	249	962
Primarily instruction + Instruction/research/public service	2,253	2,200	1,172	1,111	1,940	1,817	5,365
Primarily research	477	462	89	87	593	596	1,159
Primarily public service	400	419	65	68	80	78	545
Primarily instruction + Instruction/research/public service + Primarily research + Primarily public service	3,130	3,081	1,326	1,266	2,613	2,491	7,069
Executive/administrative/managerial	789	777	35	44	0		824
Other professionals (support/service)	2,853	2,759	1,444	1,381	0		4,297
Technical and paraprofessionals	1,227	1,257	586	579	0		1,813
Clerical and secretarial	2,491	2,471	568	547	0		3,059
Skilled crafts	505	507	21	21	0		526
Service/Maintenance	1,229	1,268	864	923	0		2,093
Grand total	12,224	12,120	4,844	4,761	2,613	2,491	19,681

Institution: University of 欧美日b大片-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, 2011
Gender and academic rank	Less-than-9-month	9/10-month	11/12-month	Total
Men
Professors				287
Associate professors				254
Assistant professors				179
Instructors				22
Lecturers				2
No academic rank				53
Total men	3	565	229	797
Total men from prior year		554	234
Women
Professors				90
Associate professors				170
Assistant professors				200
Instructors				68
Lecturers				4
No academic rank				51
Total women	12	360	211	583
Total women from prior year		338	203
Total (men + women)	15	925	440	1,380
				1,380
Total from prior year (Salaries section)	20	892	437	1,349

Institution: University of 欧美日b大片-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 and above 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, 2011**
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					209
Associate Professors					194
Assistant Professors					144
Instructors					8
Lecturers					1
No academic rank					9
Total men	364	113	88	0	565
Total men prior year	349	117	88	0	554
Women
Professors					74
Associate Professors					124
Assistant Professors					136
Instructors					23
Lecturers					2
No academic rank					1
Total women	164	95	101	0	360
Total women prior year	153	94	91	0	338
Total (men + women)	528	208	189	0	925

Institution: University of 欧美日b大片-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 and above 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, 2011**
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					78
Associate Professors					60
Assistant Professors					34
Instructors					13
Lecturers					1
No academic rank					43
Total men	107	12	110	0	229
Total men prior year	105	15	114	0	234
Women
Professors					16
Associate Professors					46
Assistant Professors					63
Instructors					37
Lecturers					2
No academic rank					47
Total women	35	16	160	0	211
Total women prior year	31	18	154	0	203
Total (men + women)	142	28	270	0	440

Institution: University of 欧美日b大片-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, 2011
Gender and academic rank	Total from Part D (Headcount screen)	Salary outlays	Average salary	Prior year Average salary
Men
Professors	209		117,933	113,613
Associate professors	194		79,241	77,059
Assistant professors	144		62,764	62,951
Instructors	8		51,736	43,949
Lecturers	1		46,101	41,509
No academic rank	9		54,610	49,069
Total men	565	50,010,116	88,513	85,268
Women
Professors	74		101,904	99,483
Associate professors	124		72,945	69,366
Assistant professors	136		62,371	60,815
Instructors	23		43,330	45,010
Lecturers	2		25,755	24,371
No academic rank	1		47,000	37,250
Total women	360	26,163,560	72,677	70,204
Total (men + women)	925	76,173,676	82,350	79,560

Institution: University of 欧美日b大片-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, 2011
Gender and academic rank	Total from Part D (Headcount screen)	Salary outlays	Average salary	Prior year Average salary
Men
Professors	78		143,726	145,330
Associate professors	60		92,082	89,109
Assistant professors	34		76,671	76,221
Instructors	13		51,309	52,044
Lecturers	1		53,560	52,000
No academic rank	43		41,488	41,452
Total men	229	21,846,881	95,401	93,330
Women
Professors	16		125,225	117,598
Associate professors	46		85,660	84,919
Assistant professors	63		71,886	69,807
Instructors	37		48,859	47,489
Lecturers	2		44,037	42,042
No academic rank	47		35,498	34,195
Total women	211	14,037,045	66,526	63,518
Total (men + women)	440	35,883,926	81,554	79,481

Institution: University of 欧美日b大片-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, 2011
Report Hispanic/Latino individuals of any race as Hispanic/Latino Report race for non-Hispanic/Latino individuals only
Gender and race/ethnicity	Professors	Associate professors	Assistant professors	Instructors	Lecturers	No academic rank	Total
Men
Nonresident alien							0
Hispanic/Latino							16
American Indian or Alaska Native							1
Asian							96
Black or African American							12
Native Hawaiian or Other Pacific Islander							1
White							522
Two or more races							1
Race and ethnicity unknown							9
Total men	392	266	0	0	0	0	658
Women
Nonresident alien							1
Hispanic/Latino							6
American Indian or Alaska Native							0
Asian							17
Black or African American							9
Native Hawaiian or Other Pacific Islander							0
White							197
Two or more races							0
Race and ethnicity unknown							1
Total women	96	132	3	0	0	0	231
Total (men+women)	488	398	3	0	0	0	889
Total from EAP							889

Institution: University of 欧美日b大片-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, 2011
Report Hispanic/Latino individuals of any race as Hispanic/Latino Report race for non-Hispanic/Latino individuals only
Gender and race/ethnicity	Professors	Associate professors	Assistant professors	Instructors	Lecturers	No academic rank	Total
Men
Nonresident alien							25
Hispanic/Latino							12
American Indian or Alaska Native							2
Asian							23
Black or African American							6
Native Hawaiian or Other Pacific Islander							0
White							115
Two or more races							0
Race and ethnicity unknown							2
Total men	1	19	165	0	0	0	185
Women
Nonresident alien							8
Hispanic/Latino							8
American Indian or Alaska Native							0
Asian							15
Black or African American							6
Native Hawaiian or Other Pacific Islander							1
White							98
Two or more races							1
Race and ethnicity unknown							2
Total women	1	11	127	0	0	0	139
Total (men+women)	2	30	292	0	0	0	324
Total from EAP							324

Institution: University of 欧美日b大片-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, 2011
Report Hispanic/Latino individuals of any race as Hispanic/Latino Report race for non-Hispanic/Latino individuals only
Gender and race/ethnicity	Professors	Associate professors	Assistant professors	Instructors	Lecturers	No academic rank	Total
Men
Nonresident alien							202
Hispanic/Latino							20
American Indian or Alaska Native							4
Asian							96
Black or African American							23
Native Hawaiian or Other Pacific Islander							2
White							717
Two or more races							2
Race and ethnicity unknown							6
Total men	44	88	238	39	3	660	1,072
Women
Nonresident alien							90
Hispanic/Latino							15
American Indian or Alaska Native							5
Asian							65
Black or African American							25
Native Hawaiian or Other Pacific Islander							1
White							637
Two or more races							1
Race and ethnicity unknown							6
Total women	15	74	189	84	6	477	845
Total (men+women)	59	162	427	123	9	1,137	1,917
Total from EAP							1,917

Institution: University of 欧美日b大片-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, 2011
Report Hispanic/Latino individuals of any race as Hispanic/Latino Report race for non-Hispanic/Latino individuals only
Gender and race/ethnicity	Total
Men
Nonresident alien
Hispanic/Latino
American Indian or Alaska Native
Asian
Black or African American
Native Hawaiian or Other Pacific Islander
White
Two or more races
Race and ethnicity unknown
Total men	0
Women
Nonresident alien
Hispanic/Latino
American Indian or Alaska Native
Asian
Black or African American
Native Hawaiian or Other Pacific Islander
White
Two or more races
Race and ethnicity unknown
Total women	0
Total (men+women)	0
Total from EAP	0

Institution: University of 欧美日b大片-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, 2011
	Total men	Total women	Total (men+women)
Nonresident alien	227	99	326
Hispanic/Latino	48	29	77
American Indian or Alaska Native	7	5	12
Asian	215	97	312
Black or African American	41	40	81
Native Hawaiian or Other Pacific Islander	3	2	5
White	1,354	932	2,286
Two or more races	3	2	5
Race and ethnicity unknown	17	9	26
Total	1,915	1,215	3,130

Institution: University of 欧美日b大片-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 (excluding instruction/research/public service staff) As of November 1, 2011
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							25
Hispanic/Latino							44
American Indian or Alaska Native							23
Asian							69
Black or African American							279
Native Hawaiian or Other Pacific Islander							3
White							2,838
Two or more races							18
Race and ethnicity unknown							37
Total men	397	1,001	468	280	486	704	3,336
Women
Nonresident alien							26
Hispanic/Latino							97
American Indian or Alaska Native							25
Asian							122
Black or African American							434
Native Hawaiian or Other Pacific Islander							3
White							4,986
Two or more races							16
Race and ethnicity unknown							49
Total women	392	1,852	759	2,211	19	525	5,758
Total (men+women)	789	2,853	1,227	2,491	505	1,229	9,094
Total from EAP	789	2,853	1,227	2,491	505	1,229	9,094

Institution: University of 欧美日b大片-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, 2011
Report Hispanic/Latino individuals of any race as Hispanic/Latino Report race for non-Hispanic/Latino individuals only
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
Hispanic/Latino
American Indian or Alaska Native
Asian
Black or African American
Native Hawaiian or Other Pacific Islander
White
Two or more races
Race and ethnicity unknown
Total men	702	11	285
Women
Nonresident alien
Hispanic/Latino
American Indian or Alaska Native
Asian
Black or African American
Native Hawaiian or Other Pacific Islander
White
Two or more races
Race and ethnicity unknown
Total women	624	24	1,159
Total (men+women)	1,326	35	1,444
Total from EAP	1,326	35	1,444

Institution: University of 欧美日b大片-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, 2011
Report Hispanic/Latino individuals of any race as Hispanic/Latino Report race for non-Hispanic/Latino individuals only
Gender and race/ethnicity	Technical and paraprofessionals	Clerical and secretarial	Skilled crafts	Service/ Maintenance
Men
Nonresident alien
Hispanic/Latino
American Indian or Alaska Native
Asian
Black or African American
Native Hawaiian or Other Pacific Islander
White
Two or more races
Race and ethnicity unknown
Total men	216	95	21	414
Women
Nonresident alien
Hispanic/Latino
American Indian or Alaska Native
Asian
Black or African American
Native Hawaiian or Other Pacific Islander
White
Two or more races
Race and ethnicity unknown
Total women	370	473	0	450
Total (men+women)	586	568	21	864
Total from EAP	586	568	21	864

Institution: University of 欧美日b大片-Columbia (178396)

User ID: 29C0011

Part J - Fall Staff - Graduate assistants and part-time grand total

Number of part-time staff by primary function/occupational activity, gender, and race/ethnicity As of November 1, 2011
Report Hispanic/Latino individuals of any race as Hispanic/Latino Report race for non-Hispanic/Latino individuals only
Gender and race/ethnicity	Total (includes Part-time Professionals and Part-time Non-professionals)	Graduate assistants	Part-time grand total(includes graduate assistants)
Men
Nonresident alien	36		481
Hispanic/Latino	23		48
American Indian or Alaska Native	11		11
Asian	40		71
Black or African American	114		145
Native Hawaiian or Other Pacific Islander	3		5
White	1,485		2,322
Two or more races	4		13
Race and ethnicity unknown	28		38
Total men	1,744	1,390	3,134
Women
Nonresident alien	35		367
Hispanic/Latino	63		97
American Indian or Alaska Native	17		23
Asian	85		120
Black or African American	168		215
Native Hawaiian or Other Pacific Islander	3		3
White	2,690		3,442
Two or more races	10		20
Race and ethnicity unknown	29		36
Total women	3,100	1,223	4,323
Total (men+women)	4,844	2,613	7,457
Total from EAP	4,844	2,613	7,457

Institution: University of 欧美日b大片-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, 2011
Gender and race/ethnicity	Full-time men	Full-time women	Part-time men	Part-time women	Total men	Total women
Nonresident alien	252	125	481	367	733	492
Hispanic/Latino	92	126	48	97	140	223
American Indian or Alaska Native	30	30	11	23	41	53
Asian	284	219	71	120	355	339
Black or African American	320	474	145	215	465	689
Native Hawaiian or Other Pacific Islander	6	5	5	3	11	8
White	4,192	5,918	2,322	3,442	6,514	9,360
Two or more races	21	18	13	20	34	38
Race and ethnicity unknown	54	58	38	36	92	94
Grand total	5,251	6,973	3,134	4,323	8,385	11,296

Institution: University of 欧美日b大片-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, 2011 and still on payroll of the institution as of November 1, 2011)
Report Hispanic/Latino individuals of any race as Hispanic/Latino Report race for non-Hispanic/Latino individuals only
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					38
Hispanic/Latino					10
American Indian or Alaska Native					3
Asian					16
Black or African American					5
Native Hawaiian or Other Pacific Islander					1
White					106
Two or more races					0
Race and ethnicity unknown					2
Total men	6	26	149	0	181
Women
Nonresident alien					20
Hispanic/Latino					2
American Indian or Alaska Native					2
Asian					13
Black or African American					4
Native Hawaiian or Other Pacific Islander					1
White					82
Two or more races					1
Race and ethnicity unknown					1
Total women	2	13	111	0	126
Total (men+women)	8	39	260	0	307

Institution: University of 欧美日b大片-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, 2011 and still on payroll of the institution as of November 1, 2011)</)< b>
Report Hispanic/Latino individuals of any race as Hispanic/Latino Report race for non-Hispanic/Latino individuals only
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
Hispanic/Latino							1
American Indian or Alaska Native							0
Asian							4
Black or African American							14
Native Hawaiian or Other Pacific Islander							0
White							134
Two or more races							1
Race and ethnicity unknown							2
Total men	6	61	15	16	5	54	157
Women
Nonresident alien							2
Hispanic/Latino							6
American Indian or Alaska Native							0
Asian							4
Black or African American							22
Native Hawaiian or Other Pacific Islander							1
White							238
Two or more races							1
Race and ethnicity unknown							2
Total women	4	95	50	101	0	26	276
Total (men+women)	10	156	65	117	5	80	433

Institution: University of 欧美日b大片-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, 2011 and still on payroll of the institution as of November 1, 2011)
	Total men	Total women	Total (men+women)
Nonresident alien	39	22	61
Hispanic/Latino	11	8	19
American Indian or Alaska Native	3	2	5
Asian	20	17	37
Black or African American	19	26	45
Native Hawaiian or Other Pacific Islander	1	2	3
White	240	320	560
Two or more races	1	2	3
Race and ethnicity unknown	4	3	7
Grand total	338	402	740

Institution: University of 欧美日b大片-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 欧美日b大片-Columbia (178396)

User ID: 29C0011

Summary

Human Resources Component Summary
(Applicable to Degree-granting institutions and Related Administrative Offices)

IPEDS collects important information regarding your institution. All data reported in IPEDS survey components become available in the IPEDS Data Center and appear as aggregated data in various Department of Education reports. Additionally, some of the reported data appears specifically for your institution through the College Navigator website and is included in your institution抯 Data Feedback Report (DFR). The purpose of this summary is to provide you an opportunity to view some of the data that, when accepted through the IPEDS quality control process, will appear on the College Navigator website and/or your DFR. College Navigator is updated approximately three months after the data collection period closes and Data Feedback Reports will be available through the ExPT and sent to your institution抯 CEO in November 2012.

Please review your data for accuracy. If you have questions about the data displayed below after reviewing the data reported on the survey screens, please contact the IPEDS Help Desk at: 1-877-225-2568 or ipedshelp@rti.org.

Number of staff by employment status and primary function/occupational activity:
Fall 2011

Primary function/occupational activity	Reported values		FTE staff
	Number of full-time staff	Number of part-time staff
Total number of staff	12,224	4,844	13,839
Professional staff	6,772	2,805	7,707
Staff whose primary responsibility is instruction, research, and/or public service	3,130	1,326	3,572
Primary instruction	1,747	974	2,072
Instruction/research/public service	506	198	572
Primarily research	477	89	507
Primarily public service	400	65	422
Executive/administrative/managerial	789	35	801
Other professionals (support/service)	2,853	1,444	3,334
Non-professional staff	5,452	2,039	6,132
Technical and paraprofessional	1,227	586	1,422
Clerical/secretarial	2,491	568	2,680
Skilled crafts	505	21	512
Service/Maintenance	1,229	864	1,517

NOTE: Full-time-equivalent (FTE) staff is calculated by summing the total number of full-time staff from the Employees by Assigned Position (EAP) section of the IPEDS HR component and adding one-third of the total number of part-time staff from the EAP section. Graduate assistants are not included in the above figures. Many of the FTE figures are included in the DFR.

Salaries of full-time instructional staff by contract length and academic rank:
Academic year 2011-12

Academic rank	Reported values				Equated 9-month
	Full-time instructional staff on 9/10-month contracts		Full-time instructional staff on 11/12-month contracts
	Number of staff	Salary outlays	Number of staff	Salary outlays	Number of staff	Average salaries
All Ranks	925	$76,173,676	440	$35,883,926	1,365	$77,314
Professor	283	$32,188,827	94	$13,214,233	377	$114,060
Associate professor	318	$24,417,878	106	$9,465,262	424	$75,855
Assistant professor	280	$17,520,389	97	$7,135,614	377	$61,960
Instructor	31	$1,410,479	50	$2,474,787	81	$42,412
Lecturer	3	$97,611	3	$141,633	6	$35,583
No academic rank	10	$538,492	90	$3,452,397	100	$33,632

NOTE: The above data are based on the Salaries section of the IPEDS HR component. The number of equated 9-month full-time instructional staff is the sum of staff on 9/10-month and 11/12-month contracts. The equated 9-month average salaries of full-time instructional staff (by rank) are calculated by multiplying the salary outlays (by rank) for staff on 11/12-month contracts by 0.8182 then adding the salary outlays (by rank) for staff on 9/10-month contracts. The resulting sum is then divided by the number of equated 9-month full-time instructional staff (by rank) to determine an average salary for each rank. Salaries of full-time instructional staff on less-than-9-month contracts are not collected. Also, salaries of medical school staff are not collected. The equated 9-month average salaries are included in the DFR.

Institution: University of 欧美日b大片-Columbia (178396)

User ID: 29C0011

Edit Report

Human Resources

Institution: University of 欧美日b大片-Columbia (178396)
Source	Description	Severity	Resolved	Options
Screen: PT medical
Upload File	The number entered, 235, has an expected range of between 100 and 206. Please explain this difference. (Error #1301)	Explanation	Yes	Back to survey data
Reason:	The larger than normal increase of part-time medical Other Professional and Clerical & Secretarial due to the expanding of University of 欧美日b大片 Health Care clinics.
Screen: Salaries 9/10 mo
Perform Edits	The average salary for one of the academic ranks in 9/10-month contracts, 47,000, is not within the expected range of between 29,800 and 44,700 based on the prior year value. Please fix or explain. (Error #1766)	Explanation	Yes	Back to survey data
Reason:	Increase in average is due to a loss of 3 lower paid women without academic rank over the year.
Related Screens:	Salaries 9/10 mo