[Evergreen-general] Money Shcema (was Next Reports Interest Group Meeting - October 26 at 3 PM at the Evergreen Hack A Way!)

[Lindsay Stratton]

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
lstratton at wlsmail.org


On Thu, Oct 27, 2022 at 10:26 AM Jason Stephenson via Evergreen-general <
evergreen-general at 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
> > lstratton at wlsmail.org <mailto:lstratton at wlsmail.org>
> >
> > _______________________________________________
> > Evergreen-general mailing list
> > Evergreen-general at list.evergreen-ils.org
> > http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-general
> _______________________________________________
> Evergreen-general mailing list
> Evergreen-general at list.evergreen-ils.org
> http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-general
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://list.evergreen-ils.org/pipermail/evergreen-general/attachments/20221027/dee83aac/attachment-0001.htm>