Expose more fields via circ_loan_rule table
In Sierra 5.5 the circloanrule view was added to SierraDNA, providing SQL access to an abridged form of the loan rule table. A few of the fields missing from this view are particularly notable and their addition would greatly expand on the opportunities to utilize this view in queries:nameis_bookablemax number of auto renewalsamount of fine
Idea Value
SQL access to this fields would enable the construction of more detailed loan rule based queries. In particular being able to look at fine rates and their impact on checkouts would be of great value.
Jeremy Goldstein
shared this idea
-
Joshua Klingbeil
commented
I would classify this more as "missing critical functionality" than a feature or improvement suggestion.
-
Phil Shirley
commented
Just now I got a question from the boss "which things are set to auto-renew" and I have to look at each loan rule using the SDA. If this field were in a SQL table then the answer would be so easy. Glad I don't have as many loan rules as some places do.