Variable definitions for use in Alma MARCXML Template
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: |
DASH_DEPOSIT_ID | File ‘mapfile’ stored in the submission‘s ‘/out’ directory | N | N | Mapfile contents: submission_868491 1/37371106 DASH_DEPOSIT_ID=”37371106” |
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” | 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: | N | N | DASH_DEPOSIT_ID = 37371106 DASH_LINK_VALUE = |
DEGREE_LEVEL_TRACING_VALUE | DEGREE_LEVEL_VALUE | DEGREE_LEVEL_VALUE = Masters DEGREE_LEVEL_TRACING_VALUE = Theses | ||
DEGREE_MONTH_NUMBER | DEGREE_DATE_VALUE | N | N | DEGREE_DATE_VALUE = 2021-05 DEGREE_MONTH_NUMBER = 05 |
DEGREE_MONTH_VALUE | DEGREE_MONTH_NUMBER | N | N | DEGREE_MONTH_NUMBER = 5 |
DEGREE_TRANSLATION_VALUE | DEGREE_NAME_VALUE | Y | N | DEGREE_NAME_VALUE = Th.D. DEGREE_TRANSLATION_VALUE = Doctor of Theology |
DEGREE_YEAR_VALUE | DEGREE_DATE_VALUE | Y | N | DEGREE_DATE_VALUE = 2021-05 DEGREE_YEAR_VALUE = 2021 |
FIXED_FIELD_008 | YYMMDDsDATE_CREATED_VALUE####mau||||||m|||#000|0|eng|d | Y | N | YYMMDD – Today’s date DATE_CREATED_VALUE = 2017
|
LIB_CODE_3_CHAR | SCHOOL_VALUE | Y | N | SCHOOL_VALUE = Harvard University Division of Continuing Education LIB_CODE_3_CHAR = HUA |
ORCID_VALUE_URL | ORCID_VALUE with a URL prefix: | N | N | ORCID_VALUE = 0000-0001-9142-7269 |
SCHOOL_TRANSLATION_SUBFIELDA_VALUE | SCHOOL_VALUE | Y | N | SCHOOL_VALUE = Harvard University Division of Continuing Education |
SCHOOL_TRANSLATION_SUBFIELDB_VALUE | SCHOOL_VALUE | N | N | SCHOOL_VALUE = Harvard University Division of Continuing Education |
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 |
Constant Values | ||||
LEADER_VALUE | 00000nam#a2200325#i#4500 | Y | N | NOTE: replace ‘#’ with single space |
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 |