DORIS Logo
 Back

  LibraryInventory


Description
Itemized archive of library branch inventory transactions within a fiscal year.

Data includes individual title details such as medium and the circulation life timeframe.

Entity relationship: LibraryBranch + FiscalYear = LibraryInventory

Fields
  branchId   string    LibraryBranch->branchId
Academic library branch identifier
  fiscalYear2Char   string    FiscalYear->fiscalYear2Char
Fiscal year in YY format
Additional Notes
Example data: 19 (2019)
  inCirculationDate   date   
The date the library item went into circulation
  isDigital   boolean   
If the item is considered a digital or electronic product, value = 1, else 0
  isIPEDSReportable   boolean   
If record is applicable for IPEDS reporting, value = 1, else 0
  itemId   string   
Unique ID for each library inventory item
Additional Notes
Inventory material titles owned or leased by the library if individual titles are cataloged and/or searchable through the library catalog or discovery system. Exclude serials, microforms, maps, nonprint materials, and uncataloged items.
  itemTitle   string   
Library inventory item title
  itemType   enum   
Library item type
Allowed Values
  • Book
  • Database
  • Media
  • Serial
  • Other
Allowed Value Details
'Book' - Non-serial printed publications that are in the hard/soft cover or loose-leaf format (includes music).

'Database' - Collection of electronically stored data or unit records with a common user interface and software for the retrieval and manipulation of the data. (e.g., facts, bibliographic data, and texts)

'Media' - Includes audio visual materials, cartographic materials, graphic materials, and three-dimensional artefacts and realia.

'Serial' - A digital/non-digital publication issued in successive parts bearing numerical or chronological designations and intended to be continued indefinitely. (e.g., periodicals, newspapers, and annuals)

'Other' - Library item is not defined by one of the above.
  outOfCirculationDate   date   
The date the library item was moved out of circulation
  recordActivityDate   date   
Date source record inserted or modified

Example SQL

CSV Datasource