Sections in this page:

Background on School Name, Degree, and Department information

Each school using the ProQuest ETD Administrator tool provides ProQuest with a School Name and a list of degrees and departments that they offer. When a student submits an ETD for review by their faculty, they choose a degree and department from the list. Schools need to contact ProQuest Support in order to make any changes to the degree or department listings. Since the metadata for ETDs sent by ProQuest uses this data, Harvard's ETD processing scripts need to be aware of changes

Variable Definitions Chart

Variable name in Alma MARCXML Template	Source	Required?	Repeatable?	Example

SCHOOL_CODE	directory name suffix for the submission in ‘/in’ directory	Y	N	Directory: proquest20220318-868491-gsas SCHOOL_CODE=”gsas”
DASH_DEPOSIT_ID	File ‘mapfile’ stored in the submission‘s ‘/out’ directory	N	N	Mapfile contents: submission_868491 1/37371106 DASH_DEPOSIT_ID=”37371106” NOTE: If mapfile is empty, then the ETD was not deposited into DASH so there is no DASH_DEPOSIT_ID

Values from ProQuest mets.xml file
ABSTRACT_VALUE	dc.description qualifier=”abstract”	N	N	path: mets\dmdSec\mdWrap\xmlData\dim:dim field example<dim:field mdschema="dc" element="description" qualifier="abstract">Childbirth is often seen as positive ...</dim:field>
ADVISOR_VALUE	dc.contributor qualifier=”advisor”	N	Y	path: mets\dmdSec\mdWrap\xmlData\dim:dim field example: <dim:field mdschema="dc" element="contributor" qualifier="advisor">Morris, James</dim:field>
AUTHOR_VALUE	dc.contributor qualifier=”author”	Y	N	path: mets\dmdSec\mdWrap\xmlData\dim:dim field example: <dim:field mdschema="dash" element="depositing" qualifier="author" authority="">Rausch, Megan Marie</dim:field>
COMMITTEE_MEMBER_VALUE	dc.contributor qualifier=”committeeMember”	N	Y
DATE_CREATED_VALUE	dc.date qualifier=”created”	Y	N	path: mets\dmdSec\mdWrap\xmlData\dim:dim field example: <dim:field mdschema="dc" element="date" qualifier="created">2023</dim:field>
DEGREE_DATE_VALUE	thesis.degree qualifier=”date”	Y	N	path: mets\dmdSec\mdWrap\xmlData\dim:dim field example 1: <dim:field mdschema="thesis" element="degree" qualifier="date">2024</dim:field> field example 2: <dim:field mdschema="thesis" element="degree" qualifier="date">2024-05</dim:field>
DEGREE_LEVEL_VALUE	thesis.degree qualifier=”level” (use first occurance only)	Y	N	path: mets\dmdSec\mdWrap\xmlData\dim:dim field example: <dim:field mdschema="thesis" element="degree" qualifier="level">Master's</dim:field>
DEGREE_NAME_VALUE	thesis.degree qualifier=”name”	Y	N	path: mets\dmdSec\mdWrap\xmlData\dim:dim field example: <dim:field mdschema="thesis" element="degree" qualifier="name">A.L.M.</dim:field>
DEPARTMENT_VALUE	thesis.degree qualifier=”department”	N	N	path: mets\dmdSec\mdWrap\xmlData\dim:dim field example: <dim:field mdschema="thesis" element="degree" qualifier="department">Extension Studies</dim:field>
EMBARGO_DATE_VALUE	dash.embargo qualifier=”until”	N	N	2021-12-23
ORCID_VALUE	dc.idientifier qualifier=”orcid”	N	N	path: mets\dmdSec\mdWrap\xmlData\dim:dim field example: <dim:field mdschema="dc" element="identifier" qualifier="orcid" authority="">0009-0009-0318-2755</dim:field>
PQ_SUBJECT_VALUE	dc.subject qualifier=”PQ”	N	Y	path: mets\dmdSec\mdWrap\xmlData\dim:dim field example: <dim:field mdschema="dc" element="subject" qualifier="PQ">Mental health</dim:field>
PROQUEST_IDENTIFIER_VALUE	dc.identifier qualifier=”other”	Y	N	path: mets\dmdSec\mdWrap\xmlData\dim:dim field example: <dim:field mdschema="dc" element="identifier" qualifier="other">30817422</dim:field>
SCHOOL_VALUE	thesis.degree qualifier=”grantor”	Y	N	path: mets\dmdSec\mdWrap\xmlData\dim:dim field example: <dim:field mdschema="thesis" element="degree" qualifier="grantor">Harvard University Division of Continuing Education</dim:field>
SUBJECT_VALUE	dc.subject	N	Y	path: mets\dmdSec\mdWrap\xmlData\dim:dim field example: <dim:field mdschema="dc" element="subject">Childbirth-related PTSD</dim:field>
TITLE_VALUE	dc.title	Y	N	path: path: mets\dmdSec\mdWrap\xmlData\dim:dim field example: <dim:field mdschema="dc" element="title">Postpartum Psychiatric Morbidity</dim:field>

Derived Values
DASH_LINK_VALUE	DASH_DEPOSIT_ID with URN Prefix: https://nrs.harvard.edu/urn-3:HUL.InstRepos:DASH_DEPOSIT_ID	N	N	DASH_DEPOSIT_ID = 37371106 DASH_LINK_VALUE = https://nrs.harvard.edu/urn-3:HUL.InstRepos:37371106
DEGREE_LEVEL_TRACING_VALUE	DEGREE_LEVEL_VALUE as input into DEGREE_LEVEL_TRACING_VALUE Translation Table			DEGREE_LEVEL_VALUE = Masters DEGREE_LEVEL_TRACING_VALUE = Theses
DEGREE_MONTH_NUMBER	DEGREE_DATE_VALUE (two digits after the year)	N	N	DEGREE_DATE_VALUE = 2021-05 DEGREE_MONTH_NUMBER = 05 ------ DEGREE_DATE_VALUE = 2020 DEGREE_MONTH_NUMBER = "NULL or UNDEFINED"
DEGREE_MONTH_VALUE	DEGREE_MONTH_NUMBER (name of month for the number in mixed capitalization)	N	N	DEGREE_MONTH_NUMBER = 5 DEGREE_MONTH_VALUE = May
DEGREE_TRANSLATION_VALUE	DEGREE_NAME_VALUE as input into DEGREE_NAME_TRANSLATION Table	Y	N	DEGREE_NAME_VALUE = Th.D. DEGREE_TRANSLATION_VALUE = Doctor of Theology
DEGREE_YEAR_VALUE	DEGREE_DATE_VALUE (first four characters)	Y	N	DEGREE_DATE_VALUE = 2021-05 DEGREE_YEAR_VALUE = 2021 ------ DEGREE_DATE_VALUE = 2020 DEGREE_YEAR_VALUE = 2020
FIXED_FIELD_008	YYMMDDsDATE_CREATED_VALUE####mau\|\|\|\|\|\|m\|\|\|#000\|0\|eng\|d	Y	N	YYMMDD – Today’s date DATE_CREATED_VALUE = 2017 When writing the XML, substitute a ‘space’ for the ‘#’ character 191219s2017####mau\|\|\|\|\|\|m\|\|\|#000\|0\|eng\|d
LIB_CODE_3_CHAR	SCHOOL_VALUE as input into SCHOOL_VALUE Translation Table	Y	N	SCHOOL_VALUE = Harvard University Division of Continuing Education LIB_CODE_3_CHAR = HUA
ORCID_VALUE_URL	ORCID_VALUE with a URL prefix: https://orcid.org/[ORCID_VALUE]	N	N	ORCID_VALUE = 0000-0001-9142-7269 ORCID_VALUE_URL = https://orcid.org/0000-0001-9142-7269
SCHOOL_TRANSLATION_SUBFIELDA_VALUE	SCHOOL_VALUE as input into SCHOOL_VALUE Translation Table	Y	N	SCHOOL_VALUE = Harvard University Division of Continuing Education SCHOOL_TRANSLATION_SUBFIELDA_VALUE= Harvard University
SCHOOL_TRANSLATION_SUBFIELDB_VALUE	SCHOOL_VALUE as input into SCHOOL_VALUE Translation Table	N	N	SCHOOL_VALUE = Harvard University Division of Continuing Education SCHOOL_TRANSLATION_SUBFIELDB_VALUE = Continuing Education Division
TITLE_INDICATOR_2_VALUE	TITLE_VALUE as input into TITLE_INDICATOR_2_VALUE Table	Y	N	TITLE_VALUE = Linguistic Distancing and Emotion Regulation TITLE_INDICATOR_2_VALUE = 0 ------ TITLE_VALUE =The Day After Tomorrow TITLE_INDICATOR_2_VALUE = 4

Constant Values
LEADER_VALUE	00000nam#a2200325#i#4500	Y	N	NOTE: replace ‘#’ with single space Should always be the same 24 characters
CONTROL_FIELD_006_VALUE	m####\|o##d########	Y	N	NOTE: replace ‘#’ with single space Should always be the same 18 characters
CONTROL_FIELD_007_VALUE	cr#\|n\|\|\|\|\|\|\|\|\|	Y	N	NOTE: replace ‘#’ with single space

DEGREE_NAME_TRANSLATION Table

DEGREE_NAME_VALUE	DEGREE_TRANSLATION_VALUE	SCHOOL_CODE
D.B.A.	Doctor of Business Administration	hbs
Th.D.	Doctor of Theology
M Arch	Master in Architecture
MDE	Master in Design Engineering
MDes	Master in Design Studies
MLA	Master in Landscape Architecture
MUP	Master in Urban Planning
MAUD	Master of Architecture in Urban Design
MLAUD	Master of Landscape Architecture in Urban Design
DDes	Doctor of Design
MMSCI	Master of Medical Sciences in Clinical Investigation
MMSc-GHD	Master of Medical Sciences in Global Health Delivery
MMSc IMM	Master of Medical Sciences in Immunology
MMSc-Med Ed	Master of Medical Sciences in Medical Education
M.D.	Doctor of Medicine
D.P.H.	Doctor of Public Health
D.S.	Doctor of Science
A.L.M.	Master of Liberal Arts
A.B.	Bachelor of Arts	college
S.B.	Bachelor of Science	college
Ph.D.	Doctor of Philosophy	gsas
D.Ed.	Doctor of Education	gse
Ed.L.D.	Doctor of Education Leadership	gse
D.M.Sc.	Doctor of Medical Sciences	hsdm
DMD-DMSc	Doctor or Medical Dentistry Doctor of Medical Sciences	hsdm
M.M.Sc.	Master of Medical Sciences	hsdm

DEGREE_LEVEL_TRACING_VALUE Translation Table

DEGREE_LEVEL_VALUE	DEGREE_LEVEL_TRACING_VALUE
Bachelor's	Theses
Undergraduate	Theses
Masters	Theses
Doctoral	Dissertations

SCHOOL_VALUE Translation Table

SCHOOL_VALUE	SCHOOL_TRANSLATION_SUBFIELDA_VALUE	SCHOOL_TRANSLATION_SUBFIELDB_VALUE	830 Field?	LIB_CODE_3_CHAR
Harvard Business School	Harvard Business School		N	BAK
Harvard College	Harvard College (1780- )		Y	HUA
Harvard Divinity School	Harvard Divinity School		Y	HUA
Harvard Graduate School of Design	Harvard University	Graduate School of Design	N	DES
Harvard Medical School	Harvard Medical School		N	MED
Harvard T.H. Chan School of Public Health	Harvard T.H. Chan School of Public Health		N	MED
Harvard University Division of Continuing Education	Harvard University	Continuing Education Division	Y	HUA
Harvard University Engineering and Applied Sciences	Harvard College (1780- )		Y	HUA
Harvard University Graduate School of Arts and Sciences	Harvard University	Graduate School of Arts and Sciences	Y	HUA
Harvard University Graduate School of Education	Harvard University	Graduate School of Education	Y	HUA
Harvard University School of Dental Medicine	Harvard School of Dental Medicine		N	MED

TITLE_INDICATOR_2_VALUE Table

If TITLE_VALUE begins with (case insensitive – ignore beginning quotation marks)	TITLE_INDICATOR_2_VALUE
"A " (letter A +space)	2
"An " (An +space)	3
"The " (The + space)	4
none of the above	0

Browser not supported