4. Reports

4.1. Define Codes Stored in DB

4.1.1. Fines Table

Question: What do the codes in the accounttype field in the accountlines table stand for?

Answer:

  • A = acc't management fee

  • C = credit

  • F = overdue fine

  • FOR =forgiven

  • FU = overdue, still acccruing

  • L = Lost Item

  • M = Sundry

  • N = New Card

  • PAY = payment

  • W = writeoff

4.1.2. Statistics Table

Question: What are the possible codes for the type field in the statistics table?

Answer:

  • localuse

    • Registers if an item that had been checked out to a statistics patron (category type = 'X') is returned

  • issue

  • return

  • renew

  • writeoff

  • payment

  • CreditXXX

    • stores different types of fee credits, so a query to catch them all would include a clause like "type LIKE 'Credit%'"