Patron and Circ History Data

Patron

More information on Patron such as the tables involved/referenced, data model and interface design can be found in the Patron Technical Documentation.

It is not recommended to load Patron data directly into tables through the back end given the multiple tables and complex foreign key references.

OLE is designed to ingest patron data as XML files. Sample patron XML data is here:

Patron Sample Data - singlePatron.xml

Patron Schema - olePatronRecord.xsd

Patron Data loaded to QA

Loading Multiple Patrons

If you are loading more than one patron, you must include

<patron xmlns="http://ole.kuali.org/standards/ole-patron">

in between each of the patrons. For example:

</patron>
<patron xmlns="http://ole.kuali.org/standards/ole-patron">
<patronID>0001255</patronID>

...

</patron>

<patron xmlns="http://ole.kuali.org/standards/ole-patron">

<patronID>0001299</patronID>

This information is not included in the single patron sample file, of course.

Loading Patrons

The XML file can be uploaded through the 'Batch Process' under Admin tab in the User Interface. More information can be found in the Technical Documentation of Batch Processes and Batch Process Profiles.

An alternate way of loading Patrons is by placing the XML files at a destination defined in the olefs-config-defaults.xml under the patrons.xml.pending.location parameter. This location is checked for XMLs at server start-up and the data is loaded up into the respective tables. A Poller service regularly hits the location to check for updates at predefined intervals to load new data.

 

Individual Patron records can also be created through the User Interface from the Create New link under Patron.

Circulation History Data

Circulation History Data is stored after a successful cycle of check out and check in in two different tables, OLE_DLVR_CIRC_RECORD (OLE- Deliver Circulation Records) and OLE_DLVR_TEMP_CIRC_RECORD (OLE-Deliver Temporary Circulation Records). The data in the former is permanent while the latter is periodically purged through a Batch Job, Delete Temporary History Records Job.

Institutions, while migrating from other Library Management Systems to OLE, would store their old data in the OLE_DLVR_CIRC_RECORD table for future reference purposes.

The columns in the table are as listed below

ColumnData TypeComment
CIR_HIS_REC_IDvarchar(40)Primary Key
LOAN_TRAN_IDvarchar(40) 
CIR_POLICY_IDvarchar(40) 
OLE_PTRN_IDvarchar(40)Foreign Key from OLE_PTRN_T
PTRN_TYP_IDvarchar(40) 
AFFILIATION_IDvarchar(40) 
DEPARTMENT_IDvarchar(40) 
OTHER_AFFILIATIONvarchar(40) 
STATISTICAL_CATEGORYvarchar(40) 
ITM_IDvarchar(40) 
ITM_LOCNvarchar(100) 
HLDNG_LOCNvarchar(100) 
BIB_TITvarchar(4000) 
BIB_AUTHvarchar(500) 
BIB_EDITIONvarchar(500) 
BIB_PUBvarchar(500) 
BIB_PUB_DTdatetime 
BIB_ISBNvarchar(50) 
PROXY_PTRN_IDvarchar(40)Foreign Key from OLE_PTRN_T
DUE_DT_TIMEdatetime 
PAST_DUE_DT_TIMEdatetime 
CRTE_DT_TIMEdatetime 
MODI_DT_TIMEdatetime 
CIRC_LOC_IDvarchar(40) 
OPTR_CRTE_IDvarchar(40) 
OPTR_MODI_IDvarchar(40) 
MACH_IDvarchar(100) 
OVRR_OPTR_IDvarchar(40) 
NUM_RENEWALSvarchar(3) 
NUM_OVERDUE_NOTICES_SENTvarchar(3) 
OVERDUE_NOTICE_DATEdatetime 
OLE_RQST_IDvarchar(40) 
REPMNT_FEE_PTRN_BILL_IDvarchar(40) 
CHECK_IN_DT_TIMEdatetime 
CHECK_IN_OPTR_IDvarchar(40) 
CHECK_IN_MACH_IDvarchar(100) 
ITEM_UUIDvarchar(100) 

 

 

Operated as a Community Resource by the Open Library Foundation