Koha Holdings data fields (9xx)
Koha Holdings Data Fields (952 / 995)
Data extracted from the Koha Manual (952 - Location and item information).
**Note:** Many date/status fields (e.g., Date Due, Last Seen, Total Checkouts) are automatically populated or managed by the system and **should not be manually edited**.
| MARC21 Field (952$) | UNIMARC Field (995$) | Data Element | SQL Column | Description / Notes |
|---|---|---|---|---|
| **952$a** | **995$b** | Home library | items.homebranch | The **owning branch** of the item. Must be defined in Administration. |
| **952$b** | **995$c** | Current library | items.holdingbranch | The current **holding branch** of the item. |
| 952$c | 995$e | Shelving location | items.location | Coded value, associated with `LOC` authorized values. |
| 952$d | 995$5 | Date acquired | items.dateaccessioned | Date the item was purchased or acquired (Format: **YYYY-MM-DD**). |
| 952$e | 995$a | Source of acquisition | items.booksellerid | Vendor string or code. |
| 952$g | 995$p | Cost, normal purchase price | items.price | Original purchase price (decimal number, no currency symbol). |
| 952$h | 995$v | Serial enumeration / chronology | items.enumchron | Volume and issue information for serial items. |
| 952$i | 995$j | Inventory number | items.stocknumber | Free text inventory number. |
| 952$j | 995$q | Shelving control number | items.stack | Used for sorting items. |
| **952$o** | **995$k** | Full call number | items.itemcallnumber | The item's primary call number. |
| **952$p** | **995$f** | Barcode | items.barcode | The item's barcode. **Required for circulation.** |
| 952$t | 995$6 | Copy number | items.copynumber | Used to enter the copy number (limited to 32 characters). |
| 952$u | 995$7 | URI | items.uri | Uniform Resource Identifier (URL or URN). |
| 952$v | 995$g | Cost, replacement price | items.replacementprice | Replacement cost charged to patron if the item is lost. |
| 952$w | 995$i | Price effective from | items.replacementpricedate | Date the replacement price is effective from (Format: YYYY-MM-DD). |
| 952$x | 995$z | Non-public note | items.itemnotes_nonpublic | Internal staff note. |
| **952$y** | **995$r** | Koha item type | items.itype | Coded value, associated with `ITYPE` authorized values. **Required for circulation.** |
| 952$z | 995$u | Public note | items.itemnotes | Note displayed to patrons. |
| 952$0 | 995$0 | Withdrawn status | items.withdrawn | Used to set the withdrawn status. '0' (or empty) = not withdrawn. |
| 952$1 | 995$2 | Lost status | items.itemlost | Numerical status associated with `LOST` authorized values. |
| 952$4 | 995$1 | Damaged status | items.damaged | Associated with `DAMAGED` authorized values. |
| 952$5 | 995$3 | Use restrictions | items.restricted | Associated with `RESTRICTED` authorized values. |
| 952$7 | 995$o | Not for loan status | items.notforloan | '0' (or empty) = available for loans. Associated with `NOT_LOAN` authorized values. |
| 952$8 | 995$h | Collection | items.ccode | Collection code, associated with `CCODE` authorized values. |
| 952$2 | 995$4 | Source of classification or shelving scheme | items.cn_source | Source used to create the normalized call number (`952$6`). |
| 952$3 | 995$l | Materials specified | items.materials | Specific issues of serials or multi-part items. |
| 952$6 | 995$s | Koha normalized classification for sorting | items.cn_sort | System-generated for sorting. **Do not manually edit.** |
| 952$9 | 995$9 | Itemnumber | items.itemnumber | System-generated unique internal ID. **Do not manually edit.** |
| 952$f | 995$8 | Coded location qualifier | items.coded_location_qualifier | Three-character code (legacy use). |
| 952$l | 995$w | Total checkouts | items.issues | System-generated cumulative total checkouts. **Do not manually edit.** |
| 952$m | 995$x | Total renewals | items.renewals | System-generated cumulative total renewals. **Do not manually edit.** |
| 952$n | 995$t | Total holds | items.reserves | System-generated cumulative total holds. **Do not manually edit.** |
| 952$q | 995$n | Date due | items.onloan | Due date when item is checked out (YYYY-MM-DD). **Do not manually edit.** |
| 952$r | 995$y | Date last seen | items.datelastseen | Date/time item was last transacted (YYYY-MM-DD HH:MM:SS). **Do not manually edit.** |
| 952$s | 995$m | Date last checked out | items.datelastborrowed | Last checkout date (YYYY-MM-DD). **Do not manually edit.** |