Aka: pe 4.6.2021 klo 14-15
Paikka: Zoom
Osallistujat: Inkeri Hakulinen, Esa-Pekka Keskital, Minna Kivinen, Christian Nelson
Translated to English for future processing.
KOHA-82 - Getting issue details... STATUS
Need to amend statistics table
The Statistics table now lacks data that is required to determine the nature of actions from th statistical point of view, e.g. at the end of the year. Checking the data from elsewhere will produce skewed results, if, for example, a patron's status changes during the year. A few additions could make data significantly more reliable.
Data nw
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| datetime | DATETIME | 19 | √ | null | date and time of the transaction | |||
| branch | VARCHAR | 10 | √ | null | foreign key, branch where the transaction occurred | |||
| value | DOUBLE | 16,4 | √ | null | monetary value associated with the transaction | |||
| type | VARCHAR | 16 | √ | null | transaction type (localuse, issue, return, renew, writeoff, payment) | |||
| other | LONGTEXT | 2147483647 | √ | null | used by SIP | |||
| itemnumber | INT | 10 | √ | null | foreign key from the items table, links transaction to a specific item | |||
| itemtype | VARCHAR | 10 | √ | null | foreign key from the itemtypes table, links transaction to a specific item type | |||
| location | VARCHAR | 80 | √ | null | authorized value for the shelving location for this item (MARC21 952$c) | |||
| borrowernumber | INT | 10 | √ | null | kirjasto | |||
| ccode | VARCHAR | 80 | √ | null |
Suggestions for added data
- Patron data
- categorycode, patron group
- borrower_attributes: STAT_CAT, statistics group
branchcode, home library. Not used or maintained by all libraries.
- Item data
- homebrach,
- itemcallnumber,
- Method of issuing
- More exactly, data on the API used. Staff member, SIP, other API...