/
Variable definitions for use in Alma MARCXML Template

Variable definitions for use in Alma MARCXML Template

May 08, 2024

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


We don't have a way to export this macro.