Subjects with Linked Records Report Definition, 2017 March Release
Description
The Subjects with Linked Records Report lists basic information about subjects as well as linked resources, accessions or digital objects.
Data Sources
Label | Table | Field | Example |
---|---|---|---|
Term type | term | term_type_id | Occupation |
Source | subject | source_id | lsch |
Subject | subject | title | Educators -- Interviews |
Resource Identifier | resource | identifier | IA20001 |
Resource Title | resource | title | J. Paul Getty papers |
Accession Identifier | accession | identifier | 2016.IA.100 |
Accession Title | accession | title | George Getty's correspondence |
Digital Object ID | digital_object | id | |
Digital Object Title | digital_object | title | Image of art object |
Formatting
Enumeration identifiers should be translated to their corresponding enumeration values for the fields listed below.
- term.term_type_id
- subject.source_id
Brackets, quotation marks, commas, and null values should be removed from the fields listed below. Instead, subfields should be separated by hyphens, e.g. ABC123-DEF456-GHI789-JKL123.
- accession.identifier
- resource.identifier
Export Formats
Users of the Subjects with LInked Records Report may export their data in the following formats.
CSV
PDF
RTF
HTML
- JSON
Additional Notes
- In the case of complex subject headings comprised of multiple terms, the query should return on the first term. For example, Educators -- Interviews is comprised of an occupation term (Educators) and a genre/format term (Interviews). Since Educators is the first term in the subject, the reported term type should be Occupation.