item_status_property
30 rows
This data as json, CSV (advanced)
| Link | rowid ▼ | item_status_code | display_order | item_status_name |
|---|---|---|---|---|
| 1 | 1 | ! | 0 | ON HOLDSHELF |
| 2 | 2 | # | 1 | SearchOH/OL RECEIVED |
| 3 | 3 | $ | 2 | LOST AND PAID |
| 4 | 4 | % | 3 | SearchOH/OL RETURNED |
| 5 | 5 | & | 4 | SearchOH/OHIOLINK REQUEST |
| 6 | 6 | ( | 5 | SearchOH/OL PAGED |
| 7 | 7 | ) | 6 | SearchOH/OL CANCEL'D |
| 8 | 8 | + | 7 | RENEWAL PENDING |
| 9 | 9 | - | 8 | CHECK SHELVES |
| 10 | 10 | = | 9 | RENEWAL DENIED |
| 11 | 11 | @ | 10 | SearchOH/OL OFFSITE |
| 12 | 12 | _ | 11 | SearchOH/OL RE-REQUEST |
| 13 | 13 | b | 12 | AT BINDERY |
| 14 | 14 | d | 13 | ON ORDER |
| 15 | 15 | e | 14 | EXCUSED LOSS |
| 16 | 16 | f | 15 | DISCARD TO FRIENDS |
| 17 | 17 | g | 16 | LONG INTRANSIT |
| 18 | 18 | i | 17 | MISSING IN INVENTORY |
| 19 | 19 | l | 18 | LOST IN SYMPHONY |
| 20 | 20 | m | 19 | MISSING |
| 21 | 21 | n | 20 | BILLED |
| 22 | 22 | o | 21 | LIBRARY USE ONLY |
| 23 | 23 | p | 22 | IN PROCESSING |
| 24 | 24 | r | 23 | IN REPAIR |
| 25 | 25 | t | 24 | IN TRANSIT |
| 26 | 26 | u | 25 | ORDER PENDING |
| 27 | 27 | v | 26 | ONLINE |
| 28 | 28 | w | 27 | WITHDRAWN |
| 29 | 29 | y | 28 | UNAVAILABLE |
| 30 | 30 | z | 29 | CLMS RETD |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [item_status_property] ( [item_status_code] TEXT, [display_order] INTEGER, [item_status_name] TEXT );