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:
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


NBAK
Harvard CollegeHarvard College (1780- )
YHUA

Harvard Divinity School

Harvard Divinity School


Y

HUA

Harvard Graduate School of Design

Harvard University

Graduate School of Design

NDES

Harvard Medical School

Harvard Medical School


NMED

Harvard T.H. Chan School of Public Health

Harvard T.H. Chan School of Public Health


NMED

Harvard University Division of Continuing Education

Harvard University

Continuing Education Division

YHUA

Harvard University Engineering and Applied Sciences

Harvard College (1780- )


YHUA

Harvard University Graduate School of Arts and Sciences

Harvard University

Graduate School of Arts and Sciences

YHUA

Harvard University Graduate School of Education

Harvard University

Graduate School of Education

YHUA

Harvard University School of Dental Medicine

Harvard School of Dental Medicine


NMED

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