Thanks, Jason, that does help. I like it when my best guesses are correct :-D
*Lindsay Stratton* *Systems Librarian* Westchester Library System 570 Taxter Rd., 4th Floor Elmsford, NY 10523 lstrat...@wlsmail.org On Thu, Oct 27, 2022 at 10:26 AM Jason Stephenson via Evergreen-general < evergreen-general@list.evergreen-ils.org> wrote: > On 10/27/22 09:41, Lindsay Stratton via Evergreen-general wrote: > > Hi all - > > > > Kind of a random nitpicky question about Evergreen data tables... > > > > In the database, I'm looking at money schema, specifically the various > > billable/billing summary tables and wondering if the transactions > > included that do not have last billing anything or total owed values > > were returned before accruing any fines, or circ transactions that would > > never have accrued fines because of non-fine bearing circ rules? > > > > Looking at xact_start and xact_finish dates for those records, it looks > > like the former. But... I'm a little hesitant. Does anybody know? > > Lindsay, > > Yes, that is the reason. If you look at the action.circulation table, it > inherits from money.bibllable_xaxt. This means that every circulation > has a corresponding row in money.billable_xact, even if there is no > actual bill. > > Hope that helps, > Jason > > > > > > Lindsay > > > > > > *Lindsay Stratton* > > *Systems Librarian* > > Westchester Library System > > 570 Taxter Rd., 4th Floor > > Elmsford, NY 10523 > > lstrat...@wlsmail.org <mailto:lstrat...@wlsmail.org> > > > > _______________________________________________ > > Evergreen-general mailing list > > Evergreen-general@list.evergreen-ils.org > > http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-general > _______________________________________________ > Evergreen-general mailing list > Evergreen-general@list.evergreen-ils.org > http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-general >
_______________________________________________ Evergreen-general mailing list Evergreen-general@list.evergreen-ils.org http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-general