reserves

primary key

foreign key from the borrowers table defining which patron this hold is for

the date the hold was placed

foreign key from the biblio table defining which bib record this hold is on

foreign key from the branches table defining which branch the patron wishes to pick this hold up at

foreign key from the desks table defining which desk the patron should pick this hold up at

currently unused

currently unused

the date this hold was cancelled

optional authorised value CANCELLATION_REASON

notes related to this hold

where in the queue the patron sits

a one letter code defining what the status is of the hold is after it has been confirmed

the date and time this hold was last updated

foreign key from the items table defining the specific item the patron has placed on hold or the item this hold was filled with

the date the item was marked as waiting for the patron at the library

the date the hold expires (calculated value)

the date the hold expires - usually the date entered by the patron to say they don’t need the hold after a certain date

If record level hold, the optional itemtype of the item the patron is requesting

Is the hpld placed at item level

Is this a non priority hold