Human Resources 2019-20

Institution: Columbia University in the City of New York (190150)

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.*
	No
	Yes
	Does your institution have graduate assistants?
	If you answer Yes* to this question, you will be provided the screens to report graduate assistants.*
		No
		Yes
Does your institution have 15 or more full-time staff?
	No
	Yes
	Does your institution have a tenure system?
	If you answer Yes* to this question, you will be provided the screens to report some data by tenure status.*
		No
		Yes
	Did your institution hire any full-time permanent staff who were included on the payroll of the institution between November 1, 2018 and October 31, 2019 either for the first time (new to the institution) or after a break in service? Do not exclude persons who were no longer on the payroll as of November 1, 2019. (Exclude persons who have returned from sabbatical leave and full-time instructional staff who are working less-than-9-month contracts.)
	If you answer Yes* to this question, you will be provided the screens to report full-time permanent new hires in Part H.*
		No
		Yes
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, you will NOT be required to report Part G - Salaries for instructional staff. However, Part G will still be required for reporting data for full-time non-instructional staff.

	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: Columbia University in the City of New York (190150)

Part A1 - Full-time Instructional Staff by Academic Rank and Tenure Status - Tenured

Number of Full-time Instructional Staff With Faculty Status Tenured As of November 1, 2019
Report Hispanic/Latino individuals of any race as Hispanic/Latino Report race for non-Hispanic/Latino individuals only Include both Primarily Instruction and Instruction Combined with Research and/or Public Service Include both medical school and non-medical school staff
Men
Race/ethnicity	Academic Rank					No academic rank	Total
Race/ethnicity	Professors	Associate professors	Assistant professors	Instructors	Lecturers	No academic rank	Total
Nonresident alien	9	1					10
Hispanic/Latino	17	4					21
American Indian or Alaska Native	1						1
Asian	96	26					122
Black or African American	20	7					27
Native Hawaiian or Other Pacific Islander							0
White	556	82					638
Two or more races	3	1					4
Race and ethnicity unknown	20	1					21
Total men	722	122	0	0	0	0	844

Women
Race/ethnicity	Academic Rank					No academic rank	Total
Race/ethnicity	Professors	Associate professors	Assistant professors	Instructors	Lecturers	No academic rank	Total
Nonresident alien		1					1
Hispanic/Latino	5	3					8
American Indian or Alaska Native	1						1
Asian	32	15					47
Black or African American	12	5					17
Native Hawaiian or Other Pacific Islander							0
White	203	43					246
Two or more races	1	1					2
Race and ethnicity unknown	5	1					6
Total women	259	69	0	0	0	0	328

Total (men+women)	981	191	0	0	0	0	1,172
Total from prior year							1,146

Institution: Columbia University in the City of New York (190150)

Part A1 - Full-time Instructional Staff by Academic Rank and Tenure Status - On Tenure Track

Number of Full-time Instructional Staff With Faculty Status On Tenure Track As of November 1, 2019
Report Hispanic/Latino individuals of any race as Hispanic/Latino Report race for non-Hispanic/Latino individuals only Include both Primarily Instruction and Instruction Combined with Research and/or Public Service Include both medical school and non-medical school staff
Men
Race/ethnicity	Academic Rank					No academic rank	Total
Race/ethnicity	Professors	Associate professors	Assistant professors	Instructors	Lecturers	No academic rank	Total
Nonresident alien	8	3	61	2			74
Hispanic/Latino		5	14		1		20
American Indian or Alaska Native							0
Asian	8	13	40	1	2		64
Black or African American		4	8				12
Native Hawaiian or Other Pacific Islander							0
White	14	43	109	1	2		169
Two or more races		1					1
Race and ethnicity unknown		2	10				12
Total men	30	71	242	4	5	0	352

Women
Race/ethnicity	Academic Rank					No academic rank	Total
Race/ethnicity	Professors	Associate professors	Assistant professors	Instructors	Lecturers	No academic rank	Total
Nonresident alien	2	4	24		1		31
Hispanic/Latino		2	13		1		16
American Indian or Alaska Native							0
Asian	2	5	32		1		40
Black or African American		3	8		2		13
Native Hawaiian or Other Pacific Islander							0
White	6	18	85	2	1		112
Two or more races			5				5
Race and ethnicity unknown	1	3	5				9
Total women	11	35	172	2	6	0	226

Total (men+women)	41	106	414	6	11	0	578
Total from prior year							562

Institution: Columbia University in the City of New York (190150)

Part A1 - Full-time Instructional Staff by Academic Rank and Tenure Status - Multi-Year Contract

Number of Full-time Instructional Staff With Faculty Status Not on Tenure Track - Multi-Year Contract As of November 1, 2019
Report Hispanic/Latino individuals of any race as Hispanic/Latino Report race for non-Hispanic/Latino individuals only Include both Primarily Instruction and Instruction Combined with Research and/or Public Service Include both medical school and non-medical school staff
Men
Gender and race/ethnicity	Academic Rank					No academic rank	Total
Gender and race/ethnicity	Professors	Associate professors	Assistant professors	Instructors	Lecturers	No academic rank	Total
Nonresident alien							0
Hispanic/Latino							0
American Indian or Alaska Native							0
Asian	1						1
Black or African American							0
Native Hawaiian or Other Pacific Islander							0
White	16	2					18
Two or more races							0
Race and ethnicity unknown							0
Total men	17	2	0	0	0	0	19

Women
Gender and race/ethnicity	Academic Rank					No academic rank	Total
Gender and race/ethnicity	Professors	Associate professors	Assistant professors	Instructors	Lecturers	No academic rank	Total
Nonresident alien							0
Hispanic/Latino							0
American Indian or Alaska Native							0
Asian							0
Black or African American							0
Native Hawaiian or Other Pacific Islander							0
White	2						2
Two or more races							0
Race and ethnicity unknown							0
Total women	2	0	0	0	0	0	2

Total (men+women)	19	2	0	0	0	0	21
Total from prior year							26

Institution: Columbia University in the City of New York (190150)

Part A1 - Full-time Instructional Staff by Academic Rank and Tenure Status - Annual Contract

Number of Full-time Instructional Staff With Faculty Status Not on Tenure Track - Annual Contract As of November 1, 2019
Report Hispanic/Latino individuals of any race as Hispanic/Latino Report race for non-Hispanic/Latino individuals only Include both Primarily Instruction and Instruction Combined with Research and/or Public Service Include both medical school and non-medical school staff
Men
Race/ethnicity	Academic Rank					No academic rank	Total
Race/ethnicity	Professors	Associate professors	Assistant professors	Instructors	Lecturers	No academic rank	Total
Nonresident alien	1	5	11	4	14		35
Hispanic/Latino	12	6	24	2	11		55
American Indian or Alaska Native							0
Asian	23	41	83	9	36		192
Black or African American	11	6	21	2	7		47
Native Hawaiian or Other Pacific Islander			2	2			4
White	188	141	279	32	118		758
Two or more races	1	1	3	1			6
Race and ethnicity unknown	3	8	18	1	7		37
Total men	239	208	441	53	193	0	1,134

Women
Race/ethnicity	Academic Rank					No academic rank	Total
Race/ethnicity	Professors	Associate professors	Assistant professors	Instructors	Lecturers	No academic rank	Total
Nonresident alien	4	1	13	3	14		35
Hispanic/Latino	5	11	49	5	8		78
American Indian or Alaska Native					1		1
Asian	16	37	162	13	30		258
Black or African American	9	2	37	8	2		58
Native Hawaiian or Other Pacific Islander							0
White	100	135	383	42	150		810
Two or more races	2		7	1	3		13
Race and ethnicity unknown	4	3	22	2	7		38
Total women	140	189	673	74	215	0	1,291

Total (men+women)	379	397	1,114	127	408	0	2,425
Total from prior year							2,226

Institution: Columbia University in the City of New York (190150)

Part A1 - Full-time Instructional Staff by Academic Rank and Tenure Status - Less-Than-Annual Contract

Number of Full-time Instructional Staff With Faculty Status Not on Tenure Track - Less-than-annual Contract As of November 1, 2019
Report Hispanic/Latino individuals of any race as Hispanic/Latino Report race for non-Hispanic/Latino individuals only Include both Primarily Instruction and Instruction Combined with Research and/or Public Service Include both medical school and non-medical school staff
Men
Race/ethnicity	Academic Rank					No academic rank	Total
Race/ethnicity	Professors	Associate professors	Assistant professors	Instructors	Lecturers	No academic rank	Total
Nonresident alien		1	3	2	10		16
Hispanic/Latino			1		1		2
American Indian or Alaska Native							0
Asian	3		6	2			11
Black or African American			1		1		2
Native Hawaiian or Other Pacific Islander							0
White	3	6	17	1	5		32
Two or more races			1				1
Race and ethnicity unknown			1				1
Total men	6	7	30	5	17	0	65

Women
Race/ethnicity	Academic Rank					No academic rank	Total
Race/ethnicity	Professors	Associate professors	Assistant professors	Instructors	Lecturers	No academic rank	Total
Nonresident alien			6	5	8		19
Hispanic/Latino			7	1			8
American Indian or Alaska Native							0
Asian			11	2	1		14
Black or African American		1	3	1			5
Native Hawaiian or Other Pacific Islander							0
White	4	4	27	3	5		43
Two or more races			2				2
Race and ethnicity unknown							0
Total women	4	5	56	12	14	0	91

Total (men+women)	10	12	86	17	31	0	156
Total from prior year							173

Institution: Columbia University in the City of New York (190150)

Part A1 - Full-time Instructional Staff by Academic Rank and Tenure Status - Indefinite duration contract

Number of Full-time Instructional Staff With Faculty Status Not on Tenure Track - Indefinite duration contract As of November 1, 2019
Report Hispanic/Latino individuals of any race as Hispanic/Latino Report race for non-Hispanic/Latino individuals only Include both Primarily Instruction and Instruction Combined with Research and/or Public Service Include both medical school and non-medical school staff
Men
Gender and race/ethnicity	Academic Rank					No academic rank	Total
Gender and race/ethnicity	Professors	Associate professors	Assistant professors	Instructors	Lecturers	No academic rank	Total
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

Women
Gender and race/ethnicity	Academic Rank					No academic rank	Total
Gender and race/ethnicity	Professors	Associate professors	Assistant professors	Instructors	Lecturers	No academic rank	Total
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

Total (men+women)
Total from prior year

Institution: Columbia University in the City of New York (190150)

Part A1 - Full-time Instructional Staff - Without Faculty Status

Number of Full-time Instructional Staff Without Faculty Status As of November 1, 2019
Report Hispanic/Latino individuals of any race as Hispanic/Latino Report race for non-Hispanic/Latino individuals only Include both Primarily Instruction and Instruction Combined with Research and/or Public Service Include both medical school and non-medical school staff
Men
Race/ethnicity	Without Faculty Status
Nonresident alien	0
Hispanic/Latino	0
American Indian or Alaska Native	0
Asian	0
Black or African American	0
Native Hawaiian or Other Pacific Islander	0
White	0
Two or more races	0
Race and ethnicity unknown	0
Total men	0

Women
Race/ethnicity	Without Faculty Status
Nonresident alien	0
Hispanic/Latino	0
American Indian or Alaska Native	0
Asian	0
Black or African American	0
Native Hawaiian or Other Pacific Islander	0
White	0
Two or more races	0
Race and ethnicity unknown	0
Total women	0

Total (men+women)	0
Total from prior year

Institution: Columbia University in the City of New York (190150)

Part A2 - Full-time Instructional Staff by Function

Number of Full-time Instructional Staff As of November 1, 2019
Report Primarily Instruction and Instruction combined with Research and/or Public Service separately, as indicated below Report Non-medical school and Medical school staff separately, as indicated below
			With Faculty Status						Without Faculty Status	Total
			Tenured	On Tenure Track	Not on Tenure Track
			Tenured	On Tenure Track	Multi-year	Annual contract	Less-than-annual contract	Indefinite duration (continuing or at-will)
Non-medical school staff			836	347	0	442	27	0	0	1,652
Non-medical school staff from prior year			825	337	0	435	33			1,630
	Primarily Instruction		836	347	0	442	27	0	0	1,652
		Exclusively credit	836	347		442	27			1,652
		Exclusively not-for-credit								0
		Combined credit/not-for-credit								0
	Instruction/research/public service staff									0

Medical school staff			336	231	21	1,983	129	0	0	2,700
Medical school staff from prior year			321	225	26	1,791	140			2,503
	Primarily Instruction		336	231	21	1,983	129	0	0	2,700
		Exclusively credit	336	231	21	1,983	129			2,700
		Exclusively not-for-credit								0
		Combined credit/not-for-credit								0
	Instruction/research/public service staff									0

Total carried forward from previous screens			1,172	578	21	2,425	156		0	4,352

Institution: Columbia University in the City of New York (190150)

Part A3 - Full-time Instructional Staff - Totals

Total number of Full-time Instructional Staff As of November 1, 2019
Race/ethnicity	Total men	Total women	Total (men+women)
Nonresident alien	135	86	221
Hispanic/Latino	98	110	208
American Indian or Alaska Native	1	2	3
Asian	390	359	749
Black or African American	88	93	181
Native Hawaiian or Other Pacific Islander	4	0	4
White	1,615	1,213	2,828
Two or more races	12	22	34
Race and ethnicity unknown	71	53	124
Total	2,414	1,938	4,352
Total from prior year			4,133

Institution: Columbia University in the City of New York (190150)

Part B1 - Full-time Non-instructional Staff by Occupational Category

Number of Full-time Non-instructional Staff by Occupational Category As of November 1, 2019
Report Hispanic/Latino individuals of any race as Hispanic/Latino Report race for non-Hispanic/Latino individuals only Include both medical school and non-medical school staff
Men
Race/ethnicity	Instructional Staff (carried forward from Part A)	Research staff	Public Service staff
Nonresident alien	135	603
Hispanic/Latino	98	50
American Indian or Alaska Native	1
Asian	390	175
Black or African American	88	13
Native Hawaiian or Other Pacific Islander	4
White	1,615	420
Two or more races	12	13
Race and ethnicity unknown	71	28
Total men	2,414	1,302	0

Women
Race/ethnicity	Instructional Staff (carried forward from Part A)	Research staff	Public Service staff
Nonresident alien	86	404
Hispanic/Latino	110	52
American Indian or Alaska Native	2
Asian	359	196
Black or African American	93	30
Native Hawaiian or Other Pacific Islander	0
White	1,213	345
Two or more races	22	23
Race and ethnicity unknown	53	27
Total women	1,938	1,077	0

Total (men+women)	4,352	2,379	0
Total from prior year	4,133	2,116

Institution: Columbia University in the City of New York (190150)

Part B1 - Full-time Non-instructional Staff by Occupational Category

Number of Full-time Non-instructional Staff by Occupational Category As of November 1, 2019
Report Hispanic/Latino individuals of any race as Hispanic/Latino Report race for non-Hispanic/Latino individuals only Include both medical school and non-medical school staff
Men
Race/ethnicity	Archivists, Curators, and Museum Technicians 25-4010	Librarians and Media Collections Specialists 25-4020	Library Technicians 25-4030	Student and Academic Affairs and Other Education Services Occupations 25-2000 + 25-3000 + 25-9000
Nonresident alien	1	1	1	1
Hispanic/Latino		4	15	3
American Indian or Alaska Native
Asian	1	2	4
Black or African American			11	5
Native Hawaiian or Other Pacific Islander
White	9	32	28	27
Two or more races			2	2
Race and ethnicity unknown		1	2
Total men	11	40	63	38

Women
Race/ethnicity	Archivists, Curators, and Museum Technicians 25-4010	Librarians and Media Collections Specialists 25-4020	Library Technicians 25-4030	Student and Academic Affairs and Other Education Services Occupations 25-2000 + 25-3000 + 25-9000
Nonresident alien	1	3		2
Hispanic/Latino	1	2	12	23
American Indian or Alaska Native
Asian	3	8	20	13
Black or African American	1		10	21
Native Hawaiian or Other Pacific Islander
White	20	41	25	40
Two or more races				2
Race and ethnicity unknown	1	4	3	1
Total women	27	58	70	102

Total (men+women)	38	98	133	140
Total from prior year	30	74	142	158

Institution: Columbia University in the City of New York (190150)

Part B1 - Full-time Non-instructional Staff by Occupational Category

Number of Full-time Non-instructional Staff by Occupational Category As of November 1, 2019
Report Hispanic/Latino individuals of any race as Hispanic/Latino Report race for non-Hispanic/Latino individuals only Include both medical school and non-medical school staff
Men
Race/ethnicity	Management Occupations 11-0000	Business and Financial Operations Occupations 13-0000	Computer, Engineering, and Science Occupations 15-0000 + 17-0000 + 19-0000	Community, Social Service, Legal, Arts, Design, Entertainment, Sports, and Media Occupations 21-0000 + 23-0000 + 27-0000	Healthcare Practitioners and Technical Occupations 29-0000
Nonresident alien	9	4	25	2	13
Hispanic/Latino	151	43	122	18	51
American Indian or Alaska Native	4		1		2
Asian	115	42	142	7	48
Black or African American	107	33	77	14	30
Native Hawaiian or Other Pacific Islander	2		3
White	629	95	279	89	92
Two or more races	15	3	15	1	3
Race and ethnicity unknown	107	16	51	14	7
Total men	1,139	236	715	145	246

Women
Race/ethnicity	Management Occupations 11-0000	Business and Financial Operations Occupations 13-0000	Computer, Engineering, and Science Occupations 15-0000 + 17-0000 + 19-0000	Community, Social Service, Legal, Arts, Design, Entertainment, Sports, and Media Occupations 21-0000 + 23-0000 + 27-0000	Healthcare Practitioners and Technical Occupations 29-0000
Nonresident alien	11	4	32	2	26
Hispanic/Latino	329	161	93	7	164
American Indian or Alaska Native	2	2		1	1
Asian	229	81	121	9	118
Black or African American	237	86	55	15	83
Native Hawaiian or Other Pacific Islander	2	4			1
White	1,073	140	173	91	295
Two or more races	45	4	11	2	10
Race and ethnicity unknown	205	33	25	13	27
Total women	2,133	515	510	140	725

Total (men+women)	3,272	751	1,225	285	971
Total from prior year	3,122	761	1,085	280	1,048

Institution: Columbia University in the City of New York (190150)

Part B1 - Full-time Non-instructional Staff by Occupational Category

Number of Full-time Non-instructional Staff by Occupational Category As of November 1, 2019
Report Hispanic/Latino individuals of any race as Hispanic/Latino Report race for non-Hispanic/Latino individuals only Include both medical school and non-medical school staff
Men
Race/ethnicity	Service Occupations 31-0000 + 33-0000 + 35-0000 + 37-0000 + 39-0000	Sales and Related Occupations 41-0000	Office and Administrative Support Occupations 43-0000	Natural Resources, Construction, and Maintenance Occupations 45-0000 + 47-0000 + 49-0000	Production, Transportation, and Material Moving Occupations 51-0000 + 53-0000	Grand Total (All full-time staff)
Nonresident alien	10		14	2		821
Hispanic/Latino	495	1	229	79	20	1,379
American Indian or Alaska Native	1			2		11
Asian	36		95	10	7	1,074
Black or African American	294	1	107	46	11	837
Native Hawaiian or Other Pacific Islander	2		2			13
White	110	2	257	71	22	3,777
Two or more races	3		13		1	83
Race and ethnicity unknown	68	1	46	20	2	434
Total men	1,019	5	763	230	63	8,429

Women
Race/ethnicity	Service Occupations 31-0000 + 33-0000 + 35-0000 + 37-0000 + 39-0000	Sales and Related Occupations 41-0000	Office and Administrative Support Occupations 43-0000	Natural Resources, Construction, and Maintenance Occupations 45-0000 + 47-0000 + 49-0000	Production, Transportation, and Material Moving Occupations 51-0000 + 53-0000	Grand Total (All full-time staff)
Nonresident alien	4		30			605
Hispanic/Latino	166	7	816	3	3	1,949
American Indian or Alaska Native	1		3			12
Asian	4		237			1,398
Black or African American	78	4	415	2	1	1,131
Native Hawaiian or Other Pacific Islander			5			12
White	23		690		2	4,171
Two or more races	2	1	35			157
Race and ethnicity unknown	24	1	158			575
Total women	302	13	2,389	5	6	10,010

Total (men+women)	1,321	18	3,152	235	69	18,439
Total from prior year	1,306	18	3,058	230	67	17,628

Institution: Columbia University in the City of New York (190150)

Part B2 - Full-time Non-instructional Staff by Occupational Category and Tenure Status

Number of Full-time Non-instructional Staff As of November 1, 2019

Non-medical school staff
Occupational category	With Faculty Status						Without Faculty Status	Total
	Tenured	On Tenure Track	Not on Tenure Track
	Tenured	On Tenure Track	Multi-year	Annual contract	Less-than-annual contract	Indefinite duration (continuing or at-will)
Research staff							1,169	1,169
Public Service staff								0
Archivists, Curators, and Museum Technicians 25-4010							35	35
Librarians and Media Collections Specialists 25-4020							90	90
Library Technicians 25-4030							128	128
Student and Academic Affairs and Other Education Services Occupations 25-2000 + 25-3000 + 25-9000							136	136
Management Occupations 11-0000							2,373	2,373
Business and Financial Operations Occupations 13-0000							474	474
Computer, Engineering, and Science Occupations 15-0000 + 17-0000 + 19-0000							678	678
Community, Social Service, Legal, Arts, Design, Entertainment, Sports, and Media Occupations 21-0000 + 23-0000 + 27-0000							269	269
Healthcare Practitioners and Technical Occupations 29-0000							96	96
Total	0	0	0	0	0	0	5,448	5,448
Total from prior year							4,717	4,717

Medical school staff
Occupational category	With Faculty Status						Without Faculty Status	Total
	Tenured	On Tenure Track	Not on Tenure Track
	Tenured	On Tenure Track	Multi-year	Annual contract	Less-than-annual contract	Indefinite duration (continuing or at-will)
Research staff							1,210	1,210
Public Service staff								0
Archivists, Curators, and Museum Technicians 25-4010							3	3
Librarians and Media Collections Specialists 25-4020							8	8
Library Technicians 25-4030							5	5
Student and Academic Affairs and Other Education Services Occupations 25-2000 + 25-3000 + 25-9000							4	4
Management Occupations 11-0000							899	899
Business and Financial Operations Occupations 13-0000							277	277
Computer, Engineering, and Science Occupations 15-0000 + 17-0000 + 19-0000							547	547
Community, Social Service, Legal, Arts, Design, Entertainment, Sports, and Media Occupations 21-0000 + 23-0000 + 27-0000							16	16
Healthcare Practitioners and Technical Occupations 29-0000							875	875
Total	0	0	0	0	0	0	3,844	3,844
Total from prior year							4,099	4,099

Institution: Columbia University in the City of New York (190150)

Part B2 - Full-time Non-instructional Staff by Medical School Status

Number of Full-time Non-instructional Staff As of November 1, 2019

Occupational category	Total (carried forward from Part B1)	Non-medical school staff	Medical school staff
Service Occupations 31-0000 + 33-0000 + 35-0000 + 37-0000 + 39-0000	1,321	1,109	212
Sales and Related Occupations 41-0000	18	18
Office and Administrative Support Occupations 43-0000	3,152	1,402	1,750
Natural Resources, Construction, and Maintenance Occupations 45-0000 + 47-0000 + 49-0000	235	185	50
Production, Transportation, and Material Moving Occupations 51-0000 + 53-0000	69	62	7
Total		2,776	2,019
Total from prior year		2,586	2,093

Institution: Columbia University in the City of New York (190150)

Part C - Full-time Summary Non-medical school staff

Summary of Full-time Non-medical School Staff As of November 1, 2019
Data will not be generated on this screen until the relevant screens in the previous section have been completed.
Occupational category		With Faculty Status						Without Faculty Status	Total
		Tenured	On Tenure Track	Not on Tenure Track
		Tenured	On Tenure Track	Multi-year	Annual contract	Less-than-annual contract	Indefinite duration (continuing or at-will)
Primarily Instruction		836	347	0	442	27	0	0	1,652
	Exclusively credit	836	347		442	27			1,652
	Exclusively not-for-credit								0
	Combined credit/not-for-credit								0
Instruction/research/public service staff									0
Research staff								1,169	1,169
Public Service staff									0
Archivists, Curators, and Museum Technicians 25-4010								35	35
Librarians and Media Collections Specialists 25-4020								90	90
Library Technicians 25-4030								128	128
Student and Academic Affairs and Other Education Services Occupations 25-2000 + 25-3000 + 25-9000								136	136
Management Occupations 11-0000								2,373	2,373
Business and Financial Operations Occupations 13-0000								474	474
Computer, Engineering, and Science Occupations 15-0000 + 17-0000 + 19-0000								678	678
Community, Social Service, Legal, Arts, Design, Entertainment, Sports, and Media Occupations 21-0000 + 23-0000 + 27-0000								269	269
Healthcare Practitioners and Technical Occupations 29-0000								96	96
Service Occupations 31-0000 + 33-0000 + 35-0000 + 37-0000 + 39-0000									1,109
Sales and Related Occupations 41-0000									18
Office and Administrative Support Occupations 43-0000									1,402
Natural Resources, Construction, and Maintenance Occupations 45-0000 + 47-0000 + 49-0000									185
Production, Transportation, and Material Moving Occupations 51-0000 + 53-0000									62
Total									9,876

Institution: Columbia University in the City of New York (190150)

Part C - Full-time Summary Medical school staff

Summary of Full-time Medical School Staff As of November 1, 2019
Data will not be generated on this screen until the relevant screens in the previous section have been completed.
Occupational category		With Faculty Status						Without Faculty Status	Total
		Tenured	On Tenure Track	Not on Tenure Track
		Tenured	On Tenure Track	Multi-year	Annual contract	Less-than-annual contract	Indefinite duration (continuing or at-will)
Primarily Instruction		336	231	21	1,983	129	0	0	2,700
	Exclusively credit	336	231	21	1,983	129			2,700
	Exclusively not-for-credit								0
	Combined credit/not-for-credit								0
Instruction/research/public service staff									0
Research staff								1,210	1,210
Public Service staff									0
Archivists, Curators, and Museum Technicians 25-4010								3	3
Librarians and Media Collections Specialists 25-4020								8	8
Library Technicians 25-4030								5	5
Student and Academic Affairs and Other Education Services Occupations 25-2000 + 25-3000 + 25-9000								4	4
Management Occupations 11-0000								899	899
Business and Financial Operations Occupations 13-0000								277	277
Computer, Engineering, and Science Occupations 15-0000 + 17-0000 + 19-0000								547	547
Community, Social Service, Legal, Arts, Design, Entertainment, Sports, and Media Occupations 21-0000 + 23-0000 + 27-0000								16	16
Healthcare Practitioners and Technical Occupations 29-0000								875	875
Service Occupations 31-0000 + 33-0000 + 35-0000 + 37-0000 + 39-0000									212
Sales and Related Occupations 41-0000
Office and Administrative Support Occupations 43-0000									1,750
Natural Resources, Construction, and Maintenance Occupations 45-0000 + 47-0000 + 49-0000									50
Production, Transportation, and Material Moving Occupations 51-0000 + 53-0000									7
Total									8,563

Institution: Columbia University in the City of New York (190150)

Part G1 - Salaries Worksheet

Number of Full-time Non-medical School Instructional Staff For Calculation of Total Number of Months Annual Salary, 2019-20
Report the number of instructional staff based on the number of months to be worked Months reported should correspond with the number of months that staff worked (which may differ from the number of months over which they are paid) Include ONLY full-time, non-medical school instructional staff Include instructional staff with faculty status and without faculty status Include instructional staff regardless of tenure status
Gender and academic rank	Months worked					Total staff	Total staff for salary reporting
Gender and academic rank	12 months	11 months	10 months	9 months	< 9 months	Total staff	Total staff for salary reporting
Men
Professors				601		601	601
Associate professors				144		144	144
Assistant professors				139		139	139
Instructors				3		3	3
Lecturers				172		172	172
No academic rank						0	0
Total men	0	0	0	1,059	0	1,059	1,059

Women
Professors				224		224	224
Associate professors				82		82	82
Assistant professors				91		91	91
Instructors				2		2	2
Lecturers				194		194	194
No academic rank						0	0
Total women	0	0	0	593	0	593	593

Total (men+women)	0	0	0	1,652	0	1,652	1,652
Total (men+women) full-time non-medical school instructional staff from Part A						1,652

Institution: Columbia University in the City of New York (190150)

Part G2 - Salary Outlays for Instructional Staff

Salary Outlays for Full-time Non-medical School Instructional Staff Annual Salary Outlays, 2019-20
Report the TOTAL ANNUAL salary outlays for the full-time Non-medical School instructional staff reported in the 12 months, 11 months, 10 months, and 9 months columns on the previous screen, Part G1 – Salaries Worksheet Using the TOTAL ANNUAL salary outlays data provided, the system will calculate the Equated 9 months by academic rank and gender.
Gender and academic rank	Total staff for salary reporting (from Part G, screen 1)	Salary Outlays
Gender and academic rank	Total staff for salary reporting (from Part G, screen 1)	12 months	11 months	10 months	9 months	Equated 9 months
Men
Professors	601				140,195,896	140,195,896
Associate professors	144				22,521,678	22,521,678
Assistant professors	139				17,936,543	17,936,543
Instructors	3				403,101	403,101
Lecturers	172				18,741,397	18,741,397
No academic rank	0					0
Total men	1,059	0	0	0	199,798,615	199,798,615

Women
Professors	224				49,038,073	49,038,073
Associate professors	82				12,349,855	12,349,855
Assistant professors	91				10,951,138	10,951,138
Instructors	2				401,000	401,000
Lecturers	194				16,361,287	16,361,287
No academic rank	0					0
Total women	593	0	0	0	89,101,353	89,101,353

Total (men + women)	1,652	0	0	0	288,899,968	288,899,968

Institution: Columbia University in the City of New York (190150)

Part G3 - Average Salaries for Instructional Staff by Academic Rank

Average Salary by academic rank for Full-time Non-medical School Instructional Staff Annual Average Salaries, 2019-20
Gender and academic rank	Total staff for salary reporting (from Part G, screen 1)	Annual Average Salaries
Gender and academic rank	Total staff for salary reporting (from Part G, screen 1)	12 months	11 months	10 months	9 months	Equated 9 months
Men
Professors	601				233,271	233,271
Associate professors	144				156,401	156,401
Assistant professors	139				129,040	129,040
Instructors	3				134,367	134,367
Lecturers	172				108,962	108,962
No academic rank	0
Total men	1,059				188,667	188,667

Women
Professors	224				218,920	218,920
Associate professors	82				150,608	150,608
Assistant professors	91				120,342	120,342
Instructors	2				200,500	200,500
Lecturers	194				84,337	84,337
No academic rank	0
Total women	593				150,255	150,255

Total (men+women)	1,652				174,879	174,879

Institution: Columbia University in the City of New York (190150)

Part G4 - Salary Outlays for Non-instructional Staff

Salary Outlays for Full-time Non-medical School Non-instructional Staff Annual Salary Outlays, 2019-20
Occupational category	Number of full-time staff (carried forward from the Part B - FT, non-instructional staff screens)	Total annual salary outlays
Research staff	1,169	94,429,128
Public Service staff	0	0
Library and Student and Academic Affairs and Other Education Services Occupations 25-4000 + 25-2000 + 25-3000 + 25-9000	389	29,401,130
Management Occupations 11-0000	2,373	284,265,489
Business and Financial Operations Occupations 13-0000	474	43,029,604
Computer, Engineering, and Science Occupations 15-0000 + 17-0000 + 19-0000	678	57,433,222
Community, Social Service, Legal, Arts, Design, Entertainment, Sports, and Media Occupations 21-0000 + 23-0000 + 27-0000	269	25,541,190
Healthcare Practitioners and Technical Occupations 29-0000	96	8,878,059
Service Occupations 31-0000 + 33-0000 + 35-0000 + 37-0000 + 39-0000	1,109	60,253,634
Sales and Related Occupations 41-0000	18	1,046,938
Office and Administrative Support Occupations 43-0000	1,402	94,808,282
Natural Resources, Construction, and Maintenance Occupations 45-0000 + 47-0000 + 49-0000	185	14,878,481
Production, Transportation, and Material Moving Occupations 51-0000 + 53-0000	62	4,613,765

Institution: Columbia University in the City of New York (190150)

Part D - Part-time Staff by Occupational Category

Number of Part-time Staff by Occupational Category As of November 1, 2019
Report Hispanic/Latino individuals of any race as Hispanic/Latino Report race for non-Hispanic/Latino individuals only Include both medical school and non-medical school staff
Men
Race/ethnicity	Instructional staff	Research staff	Public Service staff
Nonresident alien	45	22
Hispanic/Latino	58	3
American Indian or Alaska Native	2
Asian	136	12
Black or African American	49	3
Native Hawaiian or Other Pacific Islander
White	830	51
Two or more races	13
Race and ethnicity unknown	70	3
Total men	1,203	94	0

Women
Race/ethnicity	Instructional staff	Research staff	Public Service staff
Nonresident alien	56	17
Hispanic/Latino	80	1
American Indian or Alaska Native	1	1
Asian	114	7
Black or African American	98	3
Native Hawaiian or Other Pacific Islander	1
White	655	46
Two or more races	30	1
Race and ethnicity unknown	66	4
Total women	1,101	80	0

Total (men+women)	2,304	174	0
Total from prior year	2,087	198

Institution: Columbia University in the City of New York (190150)

Part D - Part-time Staff by Occupational Category

Number of Part-time Staff by Occupational Category As of November 1, 2019
Report Hispanic/Latino individuals of any race as Hispanic/Latino Report race for non-Hispanic/Latino individuals only Include both medical school and non-medical school staff
Men
Race/ethnicity	Archivists, Curators, and Museum Technicians 25-4010	Librarians and Media Collections Specialists 25-4020	Library Technicians 25-4030	Student and Academic Affairs and Other Education Services Occupations 25-2000 + 25-3000 + 25-9000	Library and Student and Academic Affairs and Other Education Services Occupations
Nonresident alien					0
Hispanic/Latino			1		1
American Indian or Alaska Native					0
Asian			1		1
Black or African American				2	2
Native Hawaiian or Other Pacific Islander					0
White				5	5
Two or more races					0
Race and ethnicity unknown				3	3
Total men	0	0	2	10	12

Women
Race/ethnicity	Archivists, Curators, and Museum Technicians 25-4010	Librarians and Media Collections Specialists 25-4020	Library Technicians 25-4030	Student and Academic Affairs and Other Education Services Occupations 25-2000 + 25-3000 + 25-9000	Library and Student and Academic Affairs and Other Education Services Occupations
Nonresident alien					0
Hispanic/Latino			1	2	3
American Indian or Alaska Native					0
Asian				1	1
Black or African American					0
Native Hawaiian or Other Pacific Islander					0
White	1		1	7	9
Two or more races					0
Race and ethnicity unknown				1	1
Total women	1	0	2	11	14

Total (men+women)	1	0	4	21	26
Total from prior year	1		5	10	16

Institution: Columbia University in the City of New York (190150)

Part D - Part-time Staff by Occupational Category

Number of Part-time Staff As of November 1, 2019
Report Hispanic/Latino individuals of any race as Hispanic/Latino Report race for non-Hispanic/Latino individuals only Include both medical school and non-medical school staff
Men
Race/ethnicity	Management Occupations 11-0000	Business and Financial Operations Occupations 13-0000	Computer, Engineering, and Science Occupations 15-0000 + 17-0000 + 19-0000	Community, Social Service, Legal, Arts, Design, Entertainment, Sports, and Media Occupations 21-0000 + 23-0000 + 27-0000	Healthcare Practitioners and Technical Occupations 29-0000
Nonresident alien			2
Hispanic/Latino			4
American Indian or Alaska Native
Asian		1	3		3
Black or African American			2		1
Native Hawaiian or Other Pacific Islander
White	11	6	20	5	3
Two or more races			1
Race and ethnicity unknown	2	1		1	1
Total men	13	8	32	6	8

Women
Race/ethnicity	Management Occupations 11-0000	Business and Financial Operations Occupations 13-0000	Computer, Engineering, and Science Occupations 15-0000 + 17-0000 + 19-0000	Community, Social Service, Legal, Arts, Design, Entertainment, Sports, and Media Occupations 21-0000 + 23-0000 + 27-0000	Healthcare Practitioners and Technical Occupations 29-0000
Nonresident alien	2		4	1	2
Hispanic/Latino	1	1	9		6
American Indian or Alaska Native
Asian	2	1	5	1	11
Black or African American	3	1	4		2
Native Hawaiian or Other Pacific Islander
White	24	4	16	2	19
Two or more races
Race and ethnicity unknown	2	1			3
Total women	34	8	38	4	43

Total (men+women)	47	16	70	10	51
Total from prior year	35	11	58	11	55

Institution: Columbia University in the City of New York (190150)

Part D - Part-time Staff by Occupational Category

Number of Part-time Staff As of November 1, 2019
Report Hispanic/Latino individuals of any race as Hispanic/Latino Report race for non-Hispanic/Latino individuals only Include both medical school and non-medical school staff
Men
Race/ethnicity	Service Occupations 31-0000 + 33-0000 + 35-0000 + 37-0000 + 39-0000	Sales and Related Occupations 41-0000	Office and Administrative Support Occupations 43-0000	Natural Resources, Construction, and Maintenance Occupations 45-0000 + 47-0000 + 49-0000	Production, Transportation, and Material Moving Occupations 51-0000 + 53-0000	Grand Total (All part-time staff)
Nonresident alien						69
Hispanic/Latino	4		15			85
American Indian or Alaska Native			1			3
Asian			11			167
Black or African American	4		12			73
Native Hawaiian or Other Pacific Islander						0
White	2		75			1,008
Two or more races			2			16
Race and ethnicity unknown	2		14			97
Total men	12	0	130	0	0	1,518

Women
Race/ethnicity	Service Occupations 31-0000 + 33-0000 + 35-0000 + 37-0000 + 39-0000	Sales and Related Occupations 41-0000	Office and Administrative Support Occupations 43-0000	Natural Resources, Construction, and Maintenance Occupations 45-0000 + 47-0000 + 49-0000	Production, Transportation, and Material Moving Occupations 51-0000 + 53-0000	Grand Total (All part-time staff)
Nonresident alien			4			86
Hispanic/Latino	7		44			152
American Indian or Alaska Native			2			4
Asian			28			170
Black or African American	4		26			141
Native Hawaiian or Other Pacific Islander			2			3
White	2		182			959
Two or more races			9			40
Race and ethnicity unknown	5	1	25		1	109
Total women	18	1	322	0	1	1,664

Total (men+women)	30	1	452	0	1	3,182
Total from prior year	33	1	420		1	2,926

Institution: Columbia University in the City of New York (190150)

Part D - Graduate assistants

Number of Graduate Assistants As of November 1, 2019
Report Hispanic/Latino individuals of any race as Hispanic/Latino Report race for non-Hispanic/Latino individuals only
Men
Race/ethnicity	Teaching 25-9044	Research	Other 11-0000, 13-0000, 15-0000, 17-0000, 19-0000, 21-0000, 23-0000, 27-0000, 25-4000, 25-4010, 25-4020, 25-4030, 25-2000, 25-3000, 25-9000, 29-0000	Total
Nonresident alien	450	324		774
Hispanic/Latino	46	23		69
American Indian or Alaska Native				0
Asian	78	69		147
Black or African American	19	4		23
Native Hawaiian or Other Pacific Islander				0
White	274	210		484
Two or more races	12	8		20
Race and ethnicity unknown	39	7		46
Total men	918	645	0	1,563

Women
Race/ethnicity	Teaching 25-9044	Research	Other 11-0000, 13-0000, 15-0000, 17-0000, 19-0000, 21-0000, 23-0000, 27-0000, 25-4000, 25-4010, 25-4020, 25-4030, 25-2000, 25-3000, 25-9000, 29-0000	Total
Nonresident alien	409	166		575
Hispanic/Latino	41	19		60
American Indian or Alaska Native	1	1		2
Asian	111	41		152
Black or African American	25	11		36
Native Hawaiian or Other Pacific Islander				0
White	313	140		453
Two or more races	34	15		49
Race and ethnicity unknown	45	9		54
Total women	979	402	0	1,381

Total (men+women)	1,897	1,047	0	2,944
Total from prior year	1,847	972		2,819

Institution: Columbia University in the City of New York (190150)

Part E - Part-time Staff by Occupational Category and Tenure Status

Number of Part-time Staff As of November 1, 2019

Non-medical school staff
Occupational category		With Faculty Status						Without Faculty Status	Total
		Tenured	On Tenure Track	Not on Tenure Track
		Tenured	On Tenure Track	Multi-year	Annual contract	Less-than-annual contract	Indefinite duration (continuing or at-will)
Primarily Instruction		0	0	0	0	0	0	0	0
	Exclusively credit								0
	Exclusively not-for-credit								0
	Combined credit/not-for-credit								0
Instruction/research/public service staff					6	1,996			2,002
Research staff								138	138
Public Service staff									0
Archivists, Curators, and Museum Technicians 25-4010								1	1
Librarians and Media Collections Specialists 25-4020									0
Library Technicians 25-4030								4	4
Student and Academic Affairs and Other Education Services Occupations 25-2000 + 25-3000 + 25-9000								21	21
Management Occupations 11-0000								37	37
Business and Financial Operations Occupations 13-0000								14	14
Computer, Engineering, and Science Occupations 15-0000 + 17-0000 + 19-0000								37	37
Community, Social Service, Legal, Arts, Design, Entertainment, Sports, and Media Occupations 21-0000 + 23-0000 + 27-0000								10	10
Healthcare Practitioners and Technical Occupations 29-0000								9	9
Total		0	0	0	6	1,996	0	271	2,273
Total from prior year		0	0	0	9	1,823		248	2,080

Medical school staff
Occupational category		With Faculty Status						Without Faculty Status	Total
		Tenured	On Tenure Track	Not on Tenure Track
		Tenured	On Tenure Track	Multi-year	Annual contract	Less-than-annual contract	Indefinite duration (continuing or at-will)
Primarily Instruction		0	0	0	0	0	0	0	0
	Exclusively credit								0
	Exclusively not-for-credit								0
	Combined credit/not-for-credit								0
Instruction/research/public service staff				1	150	151			302
Research staff								36	36
Public Service staff									0
Archivists, Curators, and Museum Technicians 25-4010									0
Librarians and Media Collections Specialists 25-4020									0
Library Technicians 25-4030									0
Student and Academic Affairs and Other Education Services Occupations 25-2000 + 25-3000 + 25-9000									0
Management Occupations 11-0000								10	10
Business and Financial Operations Occupations 13-0000								2	2
Computer, Engineering, and Science Occupations 15-0000 + 17-0000 + 19-0000								33	33
Community, Social Service, Legal, Arts, Design, Entertainment, Sports, and Media Occupations 21-0000 + 23-0000 + 27-0000									0
Healthcare Practitioners and Technical Occupations 29-0000								42	42
Total		0	0	1	150	151	0	123	425
Total from prior year		0	0	1	142	112		136	391

Institution: Columbia University in the City of New York (190150)

Part E - Part-time Staff by Medical School Status

Number of Part-time Staff As of November 1, 2019

Occupational category		Total (carried forward from Part D)	Non-medical school staff	Medical school staff
Service Occupations 31-0000 + 33-0000 + 35-0000 + 37-0000 + 39-0000		30	28	2
Sales and Related Occupations 41-0000		1	1
Office and Administrative Support Occupations 43-0000		452	291	161
Natural Resources, Construction, and Maintenance Occupations 45-0000 + 47-0000 + 49-0000		0
Production, Transportation, and Material Moving Occupations 51-0000 + 53-0000		1	1
Total			321	163
PY Total			289	166

Graduate Assistants
	Teaching 25-9044	1,897	1,715	182
	Research	1,047	852	195
	Other 11-0000, 13-0000, 15-0000, 17-0000, 19-0000, 21-0000, 23-0000, 27-0000, 25-4000, 25-4010, 25-4020, 25-4030, 25-2000, 25-3000, 25-9000, 29-0000	0
Total		2,944	2,567	377
PY Graduate Assistants			2,434	385

Institution: Columbia University in the City of New York (190150)

Part F - Part-time Summary Non-medical school staff

Summary of Part-time Non-medical School Staff As of November 1, 2019

Occupational category		With Faculty Status						Without Faculty Status	Total
		Tenured	On Tenure Track	Not on Tenure Track
		Tenured	On Tenure Track	Multi-year	Annual contract	Less-than-annual contract	Indefinite duration (continuing or at-will)
Primarily Instruction		0	0	0	0	0	0	0	0
	Exclusively credit								0
	Exclusively not-for-credit								0
	Combined credit/not-for-credit								0
Instruction/research/public service staff					6	1,996			2,002
Research staff								138	138
Public Service staff									0
Archivists, Curators, and Museum Technicians 25-4010								1	1
Librarians and Media Collections Specialists 25-4020									0
Library Technicians 25-4030								4	4
Student and Academic Affairs and Other Education Services Occupations 25-2000 + 25-3000 + 25-9000								21	21
Management Occupations 11-0000								37	37
Business and Financial Operations Occupations 13-0000								14	14
Computer, Engineering, and Science Occupations 15-0000 + 17-0000 + 19-0000								37	37
Community, Social Service, Legal, Arts, Design, Entertainment, Sports, and Media Occupations 21-0000 + 23-0000 + 27-0000								10	10
Healthcare Practitioners and Technical Occupations 29-0000								9	9
Service Occupations 31-0000 + 33-0000 + 35-0000 + 37-0000 + 39-0000									28
Sales and Related Occupations 41-0000									1
Office and Administrative Support Occupations 43-0000									291
Natural Resources, Construction, and Maintenance Occupations 45-0000 + 47-0000 + 49-0000
Production, Transportation, and Material Moving Occupations 51-0000 + 53-0000									1
Graduate Assistants									2,567
	Teaching 25-9044								1,715
	Research								852
	Other 11-0000, 13-0000, 15-0000, 17-0000, 19-0000, 21-0000, 23-0000, 27-0000, 25-4000, 25-4010, 25-4020, 25-4030, 25-2000, 25-3000, 25-9000, 29-0000
Total									5,161

Institution: Columbia University in the City of New York (190150)

Part F - Part-time Summary Medical school staff

Summary of Part-time Medical School Staff As of November 1, 2019

Occupational category		With Faculty Status						Without Faculty Status	Total
		Tenured	On Tenure Track	Not on Tenure Track
		Tenured	On Tenure Track	Multi-year	Annual contract	Less-than-annual contract	Indefinite duration (continuing or at-will)
Primarily Instruction		0	0	0	0	0	0	0	0
	Exclusively credit								0
	Exclusively not-for-credit								0
	Combined credit/not-for-credit								0
Instruction/research/public service staff				1	150	151			302
Research staff								36	36
Public Service staff									0
Archivists, Curators, and Museum Technicians 25-2000 + 25-3000 + 25-9000									0
Librarians and Media Collections Specialists 25-4020									0
Library Technicians 25-4030									0
Student and Academic Affairs and Other Education Services Occupations 25-2000 + 25-3000 + 25-9000									0
Management Occupations 11-0000								10	10
Business and Financial Operations Occupations 13-0000								2	2
Computer, Engineering, and Science Occupations 15-0000 + 17-0000 + 19-0000								33	33
Community, Social Service, Legal, Arts, Design, Entertainment, Sports, and Media Occupations 21-0000 + 23-0000 + 27-0000									0
Healthcare Practitioners and Technical Occupations 29-0000								42	42
Service Occupations 31-0000 + 33-0000 + 35-0000 + 37-0000 + 39-0000									2
Sales and Related Occupations 41-0000
Office and Administrative Support Occupations 43-0000									161
Natural Resources, Construction, and Maintenance Occupations 45-0000 + 47-0000 + 49-0000
Production, Transportation, and Material Moving Occupations 51-0000 + 53-0000
Graduate Assistants									377
	Teaching 25-9044								182
	Research								195
	Other 11-0000, 13-0000, 15-0000, 17-0000, 19-0000, 21-0000, 23-0000, 27-0000, 25-4000, 25-4010, 25-4020, 25-4030, 25-2000, 25-3000, 25-9000, 29-0000
Total									965

Institution: Columbia University in the City of New York (190150)

Part H - New Hires, Full-time Instructional Staff by Tenure Status

Number of Newly Hired Full-time Permanent Instructional Staff (Hired full-time between November 1, 2018 - October 31, 2019)
Report Hispanic/Latino individuals of any race as Hispanic/Latino Report race for non-Hispanic/Latino individuals only Include Primarily Instruction and Instruction Combined with Research and Public Service Include both medical school and non-medical school staff
Men
Race/ethnicity	With Faculty Status						Without Faculty Status	Total
	Tenured	On Tenure Track	Not on Tenure Track
	Tenured	On Tenure Track	Multi-year	Annual contract	Less-than-annual contract	Indefinite duration (continuing or at-will)
Nonresident alien		24		5	8			37
Hispanic/Latino		4		3	2			9
American Indian or Alaska Native								0
Asian	1	3		17	5			26
Black or African American		3		1	1			5
Native Hawaiian or Other Pacific Islander				1				1
White	3	20		45	20			88
Two or more races					1			1
Race and ethnicity unknown		1		2	1			4
Total men	4	55	0	74	38	0	0	171

Women
Race/ethnicity	With Faculty Status						Without Faculty Status	Total
	Tenured	On Tenure Track	Not on Tenure Track
	Tenured	On Tenure Track	Multi-year	Annual contract	Less-than-annual contract	Indefinite duration (continuing or at-will)
Nonresident alien		9		6	8			23
Hispanic/Latino		1		5	7			13
American Indian or Alaska Native								0
Asian	3	6		25	10			44
Black or African American		1		7	4			12
Native Hawaiian or Other Pacific Islander								0
White	7	21		40	24			92
Two or more races					1			1
Race and ethnicity unknown		1		1				2
Total women	10	39	0	84	54	0	0	187

Total (men+women)	14	94	0	158	92	0	0	358

Institution: Columbia University in the City of New York (190150)

Part H - New Hires, Full-time Staff by Occupational Category

Number of Newly Hired Full-time Staff (Hired full-time between November 1, 2018 - October 31, 2019)
Report Hispanic/Latino individuals of any race as Hispanic/Latino Report race for non-Hispanic/Latino individuals only Include both medical school and non-medical school staff
Men
Race/ethnicity	Instructional Staff (from Part H, screen 1)	Research staff	Public Service staff	Library and Student and Academic Affairs and Other Education Services Occupations 25-4000 + 25-2000 + 25-3000 + 25-9000
Nonresident alien	37	192		3
Hispanic/Latino	9	6		1
American Indian or Alaska Native	0
Asian	26	18
Black or African American	5	4		3
Native Hawaiian or Other Pacific Islander	1
White	88	71		6
Two or more races	1	5		1
Race and ethnicity unknown	4	5
Total men	171	301	0	14

Women
Race/ethnicity	Instructional Staff (from Part H, screen 1)	Research staff	Public Service staff	Library and Student and Academic Affairs and Other Education Services Occupations 25-4000 + 25-2000 + 25-3000 + 25-9000
Nonresident alien	23	154		3
Hispanic/Latino	13	9		6
American Indian or Alaska Native	0
Asian	44	27		6
Black or African American	12	7		4
Native Hawaiian or Other Pacific Islander	0
White	92	69		12
Two or more races	1	7		2
Race and ethnicity unknown	2	5		1
Total women	187	278	0	34

Total (men+women)	358	579	0	48

Institution: Columbia University in the City of New York (190150)

Part H - New Hires, Full-time Staff by Occupational Category

Number of Newly Hired Full-time Staff (Hired full-time between November 1, 2018 - October 31, 2019)
Report Hispanic/Latino individuals of any race as Hispanic/Latino Report race for non-Hispanic/Latino individuals only
Men
Race/ethnicity	Management Occupations 11-0000	Business and Financial Operations Occupations 13-0000	Computer, Engineering, and Science Occupations 15-0000 + 17-0000 + 19-0000	Community, Social Service, Legal, Arts, Design, Entertainment, Sports, and Media Occupations 21-0000 + 23-0000 + 27-0000	Healthcare Practitioners and Technical Occupations 29-0000
Nonresident alien	2	1	10		4
Hispanic/Latino	10	8	21		10
American Indian or Alaska Native	1
Asian	15	2	28	1	15
Black or African American	16	2	14	5	6
Native Hawaiian or Other Pacific Islander
White	60	4	41	7	23
Two or more races	4	1	2
Race and ethnicity unknown	16		7	2
Total men	124	18	123	15	58

Women
Race/ethnicity	Management Occupations 11-0000	Business and Financial Operations Occupations 13-0000	Computer, Engineering, and Science Occupations 15-0000 + 17-0000 + 19-0000	Community, Social Service, Legal, Arts, Design, Entertainment, Sports, and Media Occupations 21-0000 + 23-0000 + 27-0000	Healthcare Practitioners and Technical Occupations 29-0000
Nonresident alien	6	2	15		11
Hispanic/Latino	27	10	25	1	32
American Indian or Alaska Native		1
Asian	26	10	38	3	24
Black or African American	25	11	15	3	23
Native Hawaiian or Other Pacific Islander
White	105	12	50	10	73
Two or more races	6		5		3
Race and ethnicity unknown	26	4	5	2	7
Total women	221	50	153	19	173

Total (men+women)	345	68	276	34	231

Institution: Columbia University in the City of New York (190150)

Part H - New Hires, Full-time Staff by Occupational Category

Number of Newly Hired Full-time Staff (Hired full-time between November 1, 2018 - October 31, 2019)
Report Hispanic/Latino individuals of any race as Hispanic/Latino Report race for non-Hispanic/Latino individuals only Include both medical school and non-medical school staff
Men
Race/ethnicity	Service Occupations 31-0000 + 33-0000 + 35-0000 + 37-0000 + 39-0000	Sales and Related Occupations 41-0000	Office and Administrative Support Occupations 43-0000	Natural Resources, Construction, and Maintenance Occupations 45-0000 + 47-0000 + 49-0000	Production, Transportation, and Material Moving Occupations 51-0000 + 53-0000	Grand Total (All full-time new hires)
Nonresident alien	2		6			257
Hispanic/Latino	33		29	2	1	130
American Indian or Alaska Native						1
Asian	4		17	2		128
Black or African American	25	1	15	4	2	102
Native Hawaiian or Other Pacific Islander						1
White	10		50	7	3	370
Two or more races			2		1	17
Race and ethnicity unknown	14		8			56
Total men	88	1	127	15	7	1,062

Women
Race/ethnicity	Service Occupations 31-0000 + 33-0000 + 35-0000 + 37-0000 + 39-0000	Sales and Related Occupations 41-0000	Office and Administrative Support Occupations 43-0000	Natural Resources, Construction, and Maintenance Occupations 45-0000 + 47-0000 + 49-0000	Production, Transportation, and Material Moving Occupations 51-0000 + 53-0000	Grand Total (All full-time new hires)
Nonresident alien	1		13			228
Hispanic/Latino	7		117	1		248
American Indian or Alaska Native			1			2
Asian			63			241
Black or African American	2		53			155
Native Hawaiian or Other Pacific Islander			1			1
White			132		1	556
Two or more races			9			33
Race and ethnicity unknown	2		28			82
Total women	12	0	417	1	1	1,546

Total (men+women)	100	1	544	16	8	2,608

Institution: Columbia University in the City of New York (190150)

Summary

Human Resources Component Summary

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’s 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 Data Center and sent to your institution’s CEO in November 2019.

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 occupational category: Fall 2019
Occupational category	Reported values		FTE staff
	Number of full-time staff	Number of part-time staff
Total number of staff	18,439	3,182	19,500
Instructional Staff	4,352	2,304	5,120
Primary Instruction	4,352	0	4,352
Exclusively credit	4,352	0	4,352
Exclusively not-for-credit	0	0	0
Combined credit/not-for-credit	0	0	0
Instruction/research/public service	0	2,304	768
Research Staff	2,379	174	2,437
Public Service Staff	0	0	0
Library and Student and Academic Affairs and Other Education Services Occupations SOC	409	26	418
Librarians, Curators, and Archivists SOC 25-4000	269	5	271
Archivists, Curators, and Museum Technicians SOC 25-4010	38	1	38
Librarians SOC 25-4020	98	0	98
Library Technicians SOC 25-4030	133	4	134
Student and Academic Affairs and Other Education Services Occupations SOC 25-2000 + 25-3000 + 25-9000	140	21	147
Management Occupations SOC 11-0000	3,272	47	3,288
Business and Financial Operations Occupations SOC 13-0000	751	16	756
Computer, Engineering, and Science Occupations SOC 15-0000 + 17-0000 + 19-0000	1,225	70	1,248
Community, Social Service, Legal, Arts, Design, Entertainment, Sports and Media Occupations SOC 21-0000 + 23-0000 + 27-0000	285	10	288
Healthcare Practitioners and Technical Occupations SOC 29-0000	971	51	988
Service Occupations SOC 31-0000 + 33-0000 + 35-0000 + 37-0000 + 39-0000	1,321	30	1,331
Sales and Related Occupations SOC 41-0000	18	1	18
Office and Administrative Support Occupations SOC 43-0000	3,152	452	3,303
Natural Resources, Construction, and Maintenance Occupations SOC 45-0000 + 47-0000 + 49-0000	235		235
Production, Transportation, and Material Moving Occupations SOC 51-0000 + 53-0000	69	1	69
NOTE: Full-time-equivalent (FTE) staff is calculated by summing the total number of full-time staff and adding one-third of the total number of part-time staff. Graduate assistants are not included in the above figures. Many of the FTE figures may be included in the DFR.

Salaries of full-time instructional staff by contract length and academic rank: Academic year 2019-20
Academic rank	Months Covered by Annual Salary				Total Staff for Salary reporting	Total Number of Months	Salary Outlays	Weighted Average Monthly Salaries
Academic rank	12 months	11 months	10 months	9 months	Total Staff for Salary reporting	Total Number of Months	Salary Outlays	Weighted Average Monthly Salaries
All Ranks				1,652	1,652	14,868	$288,899,968	$19,431
Professor				825	825	7,425	$189,233,969	$25,486
Associate professor				226	226	2,034	$34,871,533	$17,144
Assistant professor				230	230	2,070	$28,887,681	$13,955
Instructor				5	5	45	$804,101	$17,869
Lecturer				366	366	3,294	$35,102,684	$10,657
No academic rank
NOTE: The above data are based on the Salary Outlays part of the IPEDS HR component. The Weighted average monthly salaries of full-time instructional staff by academic rank are calculated by adding the salary outlays reported for Men plus Women by academic rank, then dividing the sum by the "Total Number of Months" for Men plus Women by academic rank. Salaries of full-time instructional staff paid less than 9 months per year are not collected. Also, salaries of medical school staff are not collected. The weighted average monthly salaries may be included in the DFR.