Circulation Detail Report Prototype

Report to Prototype

Report Purpose

provides count of loan transactions for a given date range sorted by library location and patron group

Report Data Elements

Folio Attribute (Module, Path, Attribute)	Folio Data Element Description	Parameters/Query

Folio Attribute (Module, Path, Attribute)	Folio Data Element Description	Parameters/Query
(mod-users:) groups/id	A UUID identifying this (patron) group	sort and count results by (patron group) id
(mod-users:) groups /group	The unique name of this (patron) group
(mod-users:) users/id	A globally unique (UUID) identifier for the user
(mod-users:) users/patronGroup	A UUID corresponding to the group the user belongs to; this is a reference to (mod-users:) groups/id; this is a foreign key to the id attribute under groups
(mod-circulation-storage:/loan-storage/loans)id	Unique ID (generated UUID) of the loan; represents the loan transaction; storage module; we get data from the storage module	count loan transactions
(mod-circulation-storage: /loan-storage/loans) userId	foreign key; ID of the patron the item was lent to. Required for open loans, not required for closed loans (for anonymization).
(mod-circulation-storage: /loan-storage/loans) loanDate	Date time when the loan began	filter loan transaction ids by date range
(mod-circulation: /circulation/loans)id	Unique ID (generated UUID) of the loan; business logic module; called "loanid" in the reporting database, will be marked as a foreign key
(mod-circulation: /circulation/loans)location	The effective location of the item; nested under "items"

Modeling Folio attributes:

mod-users: /groups

mod-users: /users

mod-circulation-storage: /loan-storage/loans

mod-circulation: /circulation/loans