Child pages
  • Batch Loading Variations Metadata from MARC

V3 Batch Loading

Mapping Flowchart – Work Records

[5 June 2008]

 

*Perform these steps for each work identified in the previous algorithm.

 

1         Searching V3 for duplicates:

1.1 Once work is identified, search V3 to see if this work already exists in the database. Perform a two-point search: Creator/Composer and Work Title

1.2 Populating Creator/Composer field

1.2.1       If composer is identified from a 100, use this value

1.2.2       If composer is identified from a 700 |a, |c, use this value

1.3 Populating Work Title field

1.3.1       If work is identified from a 245, use the value in |a

1.3.2       If work is identified from a 240, use the values in |a, |m, |n, |r

1.3.3       If work is identified from a 700, use the values in |t, |m, |n, |r

1.4 If search retrieves one or more results, do not create a work record.

1.5 If search retrieves no results, proceed to step 2.

 

2         Querying LC Authority file:

2.1 Once work is determined not to be a duplicate, query the LC authority file as follows. Perform a two-point search: Author (pn:) and Title (ti:).

2.2 Populating Author field

2.2.1       If composer is identified from a 100, use this value

2.2.2       If composer is identified from a 700 |a, |c, use this value

2.3 Populating Title field

2.3.1       If work is identified from a 245, use the value in |a

2.3.2       If work is identified from a 240, use the values in |a, |m, |n, |r

2.3.3       If work is identified from a 700, use the values in |t, |m, |n, |r

2.4 If search retrieves one or more matches, select and import the record which does not contain |k, |p or |o, if there is exactly one record which fit these criteria.

2.5 Else, if search retrieves no matches or multiple matches which do not contain |k, |p or |o, do not import any Authority records. Proceed to step 4.

 

3         Mapping Work Record from the MARC Authority Record:

3.1 Map the following fields directly from the MARC record ( see mapping table ):

3.1.1       Uniform title

3.1.2       Non-Filing Indicator

3.1.3       Title Source

3.1.4       Variant Titles

3.1.5       Instrumentation

3.1.6       Key

3.1.7       Notes

3.1.8       Other System IDs.

3.1.9       Top level in Work Structure

3.2 Contributors mapping:

3.2.1       Perform a search in V3 on the composer (1xx |a, |q, |b, |c, |d).

3.2.2       If exactly one match, map ContributorID from search result to  NameRecordID field.

3.2.3       Else, do not map to NameRecordID

3.2.4       Set Role to “Composer”

3.3 Set Type to “single”

3.4 Proceed to step 5.

 

4         Mapping Work Record from MARC Bibliographic record [when Authority record search yields no results]:

4.1 Map the following fields from the MARC Bibliographic Record ( see mapping table) :

4.1.1       Uniform Title

4.1.2       Non-Filing Indicator

4.1.3       Title Source

4.1.4       Instrumentation

4.1.5       Key

4.2 Contributors mapping:

4.2.1       Perform a search in V3 on the composer from the field of origin (1xx or 7xx |a, |q, |b, |c, |d)

4.2.2       If exactly one match, map ContributorID from search result to  NameRecordID field.

4.2.3       Else, do not map to NameRecordID

4.2.4       Set Role to “Composer”

4.3 Proceed to step 5.

 

5         Mapping additional Work Record fields from MARC Bibliographic Record [for all works]:

5.1 Map the following fields from the MARC Bibliographic Record ( see mapping table):

5.1.1       Date of Composition

5.1.2       Subject Headings

5.1.3       Form/Genre/Style

5.1.4       Additional Contributors. For each 7xx:

5.1.4.1                         If  |4 is “lbt, cmp, lyr”, proceed to V3 search.

5.1.4.2                         Else, do not map from this 7xx.

5.1.4.3                         Perform a search on the Contributor (7xx, |a, |q, |b, |c, |d).

5.1.4.4                         If exactly one match, map ContributorID from search result to NameRecordID field.

5.1.4.5                         Else, do not map to NameRecordID.

5.1.4.6                         Set role according to value in |4 ( see mapping table ).

 

6         Setting Status:

6.1 Set Status according to criteria in Work Identification algorithm.