Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Folio Attribute (Module/Path:Object)Folio Data Element DescriptionParameters/Query

Table name: mod-inventory-storage/instances

inventory_instances



inventory_instances

statusId

Instance status identifierfilter; subquery – select everything from the Instance status table, filter on status ids for, e.g., ('Cataloging Complete', 'Batch Loaded', 'Temporary Cataloged')

inventory_instances

staffSuppress

Suppress from Stafffilter

inventory_instances

discoverySuppress

Suppress from discoveryfilter

inventory_instances

previouslyHeld

Held Previouslyfilter

inventory_instances

holdingsRecords2

Associated holdings identifiersto join associated holdings

inventory_instances

instanceTypeId

Resource type

To filter, Resource type = text (txt) OR notated music (ntm) OR cartographic image (cri)

in MARC BLvl M

inventory_instances

modeOfIssuanceID

Mode of issuance identifiers

filter


(no equivalent of MARC 008/6 Date type field in Instance)
To filter, single date (could be pulled from underlying MARC?)

inventory_instances

instanceFormatIds

Format identifiersTo filter, Format category = 'unmediated--volume'

inventory_instances

Identifiers: /identifierTypeId


join to inventory_identifier_types

To Filter Resource identifier type = 'OCLC'

inventory_instances

Identifiers: /value


display OCLC number & ISSN

inventory_instances

physicalDescriptions: /description


filter: contains p. or pages vs v. or vol. or vols. or volumes

Is or is not US Federal Document?

 come back to this: discuss in MM SIG

statistical code in instance?

SuDoc in instance

(in MARC, 008/17 = u and 008/28 = f means is considered document)

inventory_instances

statisticalCodeIds


filter
Table name: mod-inventory-storage/instance-formats

inventory_instance_formats

id


join

inventory_instance_formats

name


filter for unmediated--volume
Table name: mod-inventory-storage/statistical-codes

inventory_statistical_codes

id


join

inventory_statistical_codes

name


filter
Table name: mod-inventory-storage/holdings

inventory_holdings

discoverySuppress


filter

inventory_holdings

id


join to Instance

inventory_holdings

holdingsItems


item IDsto join associated items

inventory_holdings: permanentLocation

permanentLocationId

need all four levels (institution, campus, library, location)

inventory_holdings

statisticalCodeIds






Table name: mod-inventory-storage/locations

inventory_locations

institutionId


all location data is for filtering

inventory_locations

campusId



inventory_locations

libraryId



inventory_locations

id

join

inventory_locations

name



Table name: mod-inventory-storage/locations-units/institutions

inventory_institutions

id



inventory_institutions

name



Table name: mod-inventory-storage/locations-units/campuses

inventory_campuses

id



inventory_campuses

name



Table name: mod-inventory-storage/locations-units/libraries

inventory_libraries

id



inventory_libraries

name



Table name: mod-inventory-storage/item_storage/items

inventory_items

discoverySuppress


filter

inventory_items

status/name


filter on item state (i.e. status)

inventory_items

materialTypeId


join to material-types table

inventory_items

statisticalCodeIds



inventory_items

enumeration


data present or not; to filter (single-part vs multi-part monos)

& display (if present)

inventory_items

chronology


display (if present)

inventory_items

itemsDamagedStatusID



Table name: mod-inventory-storage/inventory_item_damaged_statuses


inventory_item_damaged_status

id



inventory_item_damaged_status

name



Table name: mod-inventory-storage/material-types


inventory_material_types

id


(to filter on item state)

inventory_material_types

name



Table name: mod-inventory-storage/instance-statuses


inventory_instance_statuses

name

Instance status name

inventory_instance_statuses

id

Instance status idjoining on status id to filter by status name
Table name: mod-inventory-storage/modes-of-issuance


inventory_modes_of_issuance

id

Modes of Issuance idjoining on modeOfIssuanceId by modes of issuance name

inventory_modes_of_issuance

name

Modes of Issuance name
Table name: mod-inventory-storage/identifier-types


inventory_identifier_types

id


join to instance table

inventory_identifier_types

name


filter on name = OCLC number

...