DORIS Logo
 Back

  LibraryItemTransaction


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

Data includes individual title checkout details for an associated branch.

Entity relationship: LibraryBranch + FiscalYear = LibraryItemTransaction

Fields
  branchId   string    LibraryBranch->branchId
Academic library branch identifier
  checkoutDate   date   
The check-out date of the material item
  checkoutPersonId   string    Person->personId
The person ID of the individual who conducted the transaction
  fiscalYear2Char   string    FiscalYear->fiscalYear2Char
Fiscal year in YY format
Additional Notes
Example data: 19 (2019)
  isIPEDSReportable   boolean   
If record is applicable for IPEDS reporting, value = 1, else 0
  itemId   string    LibraryInventory->itemId
Library inventory item identifier
  recordActivityDate   date   
Date source record inserted or modified
  returnDate   date   
The return or check-in date of the material item

Example SQL

CSV Datasource