Bug 16784: Add table configuration on suggestions table
[srvgit] / admin / columns_settings.yml
1 modules:
2   acqui:
3     histsearch:
4       histsearcht:
5         -
6           columnname: order_line
7         -
8           columnname: status
9         -
10           columnname: basket
11         -
12           columnname: basket_creator
13         -
14           columnname: basket_group
15         -
16           columnname: invoice_number
17         -
18           columnname: summary
19         -
20           columnname: vendor
21         -
22           columnname: placed_on
23         -
24           columnname: received_on
25         -
26           columnname: quantity_received
27         -
28           columnname: pending_order
29         -
30           columnname: unit_cost
31         -
32           columnname: fund
33
34     lateorders:
35       late_orders:
36         -
37           columnname: checkbox
38           cannot_be_toggled: 1
39           cannot_be_modified: 1
40         -
41           columnname: order_date
42         -
43           columnname: estimated_delivery_date
44         -
45           columnname: vendor
46         -
47           columnname: information
48         -
49           columnname: total_cost
50         -
51           columnname: basket
52         -
53           columnname: basket_group
54         -
55           columnname: library
56         -
57           columnname: fund
58         -
59           columnname: claims_count
60         -
61           columnname: claimed_date
62     basket:
63       orders:
64         -
65           columnname: basket_number
66         -
67           columnname: order_information
68         -
69           columnname: recommended_retail_price_tax_excluded
70         -
71           columnname: ecost_tax_excluded
72         -
73           columnname: recommended_retail_price_tax_included
74           is_hidden: 1
75         -
76           columnname: ecost_tax_included
77           is_hidden: 1
78         -
79           columnname: replacement_price
80         -
81           columnname: quantity
82         -
83           columnname: total_tax_excluded
84         -
85           columnname: total_tax_included
86           is_hidden: 1
87         -
88           columnname: goods_and_services_tax_percentage
89         -
90           columnname: goods_and_services_tax
91         -
92           columnname: fund
93         -
94           columnname: supplier_report
95         -
96           columnname: modify
97           cannot_be_toggled: 1
98           cannot_be_modified: 1
99         -
100           columnname: cancel
101           cannot_be_toggled: 1
102           cannot_be_modified: 1
103
104     suggestions:
105       suggestions:
106         -
107           columnname: selections
108           cannot_be_toggled: 1
109           cannot_be_modified: 1
110         -
111           columnname: suggestion
112         -
113           columnname: suggested_by
114         -
115           columnname: suggested_on
116         -
117           columnname: managed_by
118         -
119           columnname: managed_on
120         -
121           columnname: library
122         -
123           columnname: library_fund
124         -
125           columnname: suggestion_status
126         -
127           columnname: actions
128           cannot_be_toggled: 1
129           cannot_be_modified: 1
130
131   admin:
132     currency:
133       currencies-table:
134         -
135           columnname: currency
136           cannot_be_toggled: 1
137           cannot_be_modified: 1
138         -
139           columnname: rate
140           cannot_be_toggled: 1
141           cannot_be_modified: 1
142         -
143           columnname: symbol
144         -
145           columnname: iso_code
146           is_hidden: 1
147         -
148           columnname: last_updated
149         -
150           columnname: active
151         -
152           columnname: actions
153
154     categories:
155       patron_categories:
156         -
157           columnname: code
158         -
159           columnname: category_name
160         -
161           columnname: type
162         -
163           columnname: enrollment_period
164         -
165           columnname: age_required
166         -
167           columnname: upper_age_limit
168         -
169           columnname: enrollment_fee
170         -
171           columnname: overdue
172         -
173           columnname: lost_items
174         -
175           columnname: hold_fee
176         -
177           columnname: messaging
178         -
179           columnname: branches_limitations
180         -
181           columnname: default_privacy
182         -
183           columnname: actions
184           cannot_be_toggled: 1
185           cannot_be_modified: 1
186
187     itemtypes:
188       table_item_type:
189         -
190           columnname: image
191         -
192           columnname: code
193         -
194           columnname: description
195         -
196           columnname: search_category
197         -
198           columnname: not_for_loan
199         -
200           columnname: hide_in_opac
201         -
202           columnname: rental_charge
203         -
204           columnname: daily_rental_charge
205         -
206           columnname: hourly_rental_charge
207         -
208           columnname: default_replacement_cost
209         -
210           columnname: lost_processing_fee
211         -
212           columnname: checkin_message
213         -
214           columnname: library_limitations
215         -
216           columnname: actions
217           cannot_be_toggled: 1
218           cannot_be_modified: 1
219
220     libraries:
221       libraries:
222         -
223           columnname: library_name
224         -
225           columnname: library_code
226         -
227           columnname: library_address
228         -
229           columnname: marc_organization_code
230         -
231           columnname: library_ip
232         -
233           columnname: is_pickup_location
234         -
235           columnname: actions
236           cannot_be_toggled: 1
237           cannot_be_modified: 1
238
239
240   catalogue:
241     detail:
242       acquisitiondetails-table:
243         -
244           columnname: vendor
245         -
246           columnname: invoice
247         -
248           columnname: basketgroup
249         -
250           columnname: basket
251         -
252           columnname: ordernumber
253         -
254           columnname: creation_date
255         -
256           columnname: received_data
257         -
258           columnname: status
259         -
260           columnname: quantity
261         -
262           columnname: order_internalnote
263         -
264           columnname: subscription
265         -
266           columnname: subscription_callnumber
267
268       checkoutshistory-table:
269         -
270           columnname: patron
271           cannot_be_toggled: 1
272           cannot_be_modified: 1
273         -
274           columnname: barcode
275           cannot_be_toggled: 1
276           cannot_be_modified: 1
277         -
278           columnname: checked_out_from
279         -
280           columnname: renewed
281         -
282           columnname: checkout_on
283         -
284           columnname: due_date
285         -
286           columnname: checkin_on
287
288   cataloguing:
289     additem:
290       itemst:
291         # NOTE: These columns are in the same order as kohastructure.sql, and contain all items
292         # columns except for the following internal/obsolete fields: stack, more_subfields_xml,
293         # cn_sort, permanent_location, damaged_on itemlost_on, withdrawn_on, issues, renewals and
294         # reserves.
295         -
296           columnname: barcode
297         -
298           columnname: dateaccessioned
299         -
300           columnname: booksellerid
301         -
302           columnname: homebranch
303         -
304           columnname: price
305         -
306           columnname: replacementprice
307         -
308           columnname: replacementpricedate
309         -
310           columnname: datelastborrowed
311         -
312           columnname: datelastseen
313         -
314           columnname: stack
315         -
316           columnname: notforloan
317         -
318           columnname: damaged
319         -
320           columnname: itemlost
321         -
322           columnname: withdrawn
323         -
324           columnname: itemcallnumber
325         -
326           columnname: coded_location_qualifier
327         -
328           columnname: restricted
329         -
330           columnname: itemnotes
331         -
332           columnname: itemnotes_nonpublic
333         -
334           columnname: holdingbranch
335         -
336           columnname: timestamp
337         -
338           columnname: location
339         -
340           columnname: onloan
341         -
342           columnname: cn_source
343         -
344           columnname: ccode
345         -
346           columnname: materials
347         -
348           columnname: uri
349         -
350           columnname: itype
351         -
352           columnname: enumchron
353         -
354           columnname: copynumber
355         -
356           columnname: stocknumber
357
358     z3950_search:
359       resultst:
360         -
361           columnname: server
362         -
363           columnname: title
364         -
365           columnname: author
366         -
367           columnname: date
368         -
369           columnname: edition
370         -
371           columnname: isbn
372         -
373           columnname: lccn
374         -
375           columnname: actions
376           cannot_be_toggled: 1
377           cannot_be_modified: 1
378
379   coursereserves:
380     courses:
381       course_reserves_table:
382         -
383           columnname: name
384         -
385           columnname: department
386         -
387           columnname: course_no
388         -
389           columnname: section
390         -
391           columnname: term
392         -
393           columnname: instructors
394         -
395           columnname: staff_note
396         -
397           columnname: public_note
398         -
399           columnname: no_of_students
400         -
401           columnname: enabled
402
403     reserves:
404       course_reserves_table:
405         -
406           columnname: title
407         -
408          columnname: author
409         -
410           columnname: barcode
411         -
412           columnname: call_number
413         -
414           columnname: item_type
415         -
416           columnname: collection
417         -
418           columnname: location
419         -
420           columnname: library
421         -
422           columnname: staff_note
423         -
424           columnname: public_note
425         -
426           columnname: link
427         -
428           columnname: other_course_reserves
429         -
430           columnname: actions
431           cannot_be_toggled: 1
432           cannot_be_modified: 1
433
434   illrequests:
435     ill-requests:
436       ill-requests:
437         -
438           columnname: illrequest_id
439         -
440           columnname: metadata_author
441         -
442           columnname: metadata_title
443         -
444           columnname: metadata_article_title
445         -
446           columnname: metadata_issue
447         -
448           columnname: metadata_volume
449         -
450           columnname: metadata_year
451         -
452           columnname: metadata_pages
453         -
454           columnname: metadata_type
455         -
456           columnname: orderid
457         -
458           columnname: patron
459         -
460           columnname: biblio_id
461         -
462           columnname: library_branchname
463         -
464           columnname: status
465         -
466           columnname: placed
467           cannot_be_toggled: 1
468           cannot_be_modified: 1
469           is_hidden: 1
470         -
471           columnname: placed_formatted
472         -
473           columnname: updated
474           cannot_be_toggled: 1
475           cannot_be_modified: 1
476           is_hidden: 1
477         -
478           columnname: updated_formatted
479         -
480           columnname: replied
481         -
482           columnname: completed
483           cannot_be_toggled: 1
484           cannot_be_modified: 1
485           is_hidden: 1
486         -
487           columnname: completed_formatted
488         -
489           columnname: accessurl
490         -
491           columnname: cost
492         -
493           columnname: comments
494         -
495           columnname: notesopac
496         -
497           columnname: notesstaff
498         -
499           columnname: backend
500         -
501           columnname: action
502           cannot_be_toggled: 1
503           cannot_be_modified: 1
504
505   members:
506     fines:
507       account-fines:
508         -
509           columnname: date
510         -
511           columnname: description
512         -
513           columnname: barcode
514         -
515           columnname: date_due
516         -
517           columnname: returndate
518         -
519           columnname: note
520         -
521           columnname: amount
522           cannot_be_toggled: 1
523           cannot_be_modified: 1
524         -
525           columnname: amountoutstanding
526           cannot_be_toggled: 1
527           cannot_be_modified: 1
528         -
529           columnname: actions
530           cannot_be_toggled: 1
531           cannot_be_modified: 1
532
533     pay:
534       pay-fines-table:
535         -
536           columnname: checkbox
537           cannot_be_toggled: 1
538           cannot_be_modified: 1
539         -
540           columnname: actions
541           cannot_be_toggled: 1
542           cannot_be_modified: 1
543         -
544           columnname: description
545         -
546           columnname: date
547         -
548           columnname: barcode
549         -
550           columnname: date_due
551         -
552           columnname: returndate
553         -
554           columnname: note
555         -
556           columnname: account_type
557         -
558           columnname: amount
559         -
560           columnname: amountoutstanding
561
562     member:
563       memberresultst:
564         -
565           columnname: checkbox
566           cannot_be_toggled: 1
567           cannot_be_modified: 1
568         -
569           columnname: cardnumber
570         -
571           columnname: name
572         -
573           columnname: dateofbirth
574         -
575           columnname: category
576         -
577           columnname: library
578         -
579           columnname: expires_on
580         -
581           columnname: od_checkouts
582         -
583           columnname: fines
584         -
585           columnname: circ_notes
586         -
587           columnname: actions
588           cannot_be_toggled: 1
589           cannot_be_modified: 1
590
591     moremember:
592       issues-table:
593         -
594           columnname: sort_order
595           cannot_be_toggled: 1
596           cannot_be_modified: 1
597           is_hidden: 1
598         -
599           columnname: todays_or_previous_checkouts
600           cannot_be_toggled: 1
601           cannot_be_modified: 1
602           is_hidden: 1
603         -
604           columnname: due_date_unformatted
605           cannot_be_toggled: 1
606           cannot_be_modified: 1
607           is_hidden: 1
608         -
609           columnname: due_date
610         -
611           columnname: title
612         -
613           columnname: record_type
614         -
615           columnname: item_type
616         -
617           columnname: collection
618         -
619           columnname: location
620         -
621           columnname: homebranch
622         -
623           columnname: checkout_on_unformatted
624           cannot_be_toggled: 1
625           cannot_be_modified: 1
626           is_hidden: 1
627         -
628           columnname: checkout_on
629         -
630           columnname: checkout_from
631         -
632           columnname: callno
633         -
634           columnname: charge
635         -
636           columnname: fine
637         -
638           columnname: price
639         -
640           columnname: renew
641           cannot_be_toggled: 1
642           cannot_be_modified: 1
643         -
644           columnname: checkin
645         -
646           columnname: export
647           cannot_be_toggled: 1
648           cannot_be_modified: 1
649
650     holdshistory:
651       holdshistory-table:
652         -
653           columnname: title
654           cannot_be_toggled: 1
655           cannot_be_modified: 1
656         -
657           columnname: author
658         -
659           columnname: barcode
660         -
661           columnname: branch
662         -
663           columnname: reservedate
664         -
665           columnname: expirationdate
666         -
667           columnname: waitingdate
668         -
669           columnname: cancellationdate
670         -
671           columnname: itemtype
672         -
673           columnname: status
674
675     checkouthistory:
676       checkouthistory-table:
677         - columnname: type
678           cannot_be_toggled: 1
679           cannot_be_modified: 1
680         -
681           columnname: date
682         -
683           columnname: title
684         -
685           columnname: author
686         -
687           columnname: call_number
688         -
689           columnname: barcode
690         -
691           columnname: number_of_renewals
692         -
693           columnname: checked_out_on
694         -
695           columnname: checked_out_from
696         -
697           columnname: date_due
698         -
699           columnname: return_date
700
701     patron-lists:
702       patron-list-table:
703         -
704           columnname: checkbox
705           cannot_be_toggled: 1
706           cannot_be_modified: 1
707         -
708           columnname: card
709         -
710           columnname: firstname
711         -
712           columnname: surname
713         -
714           columnname: address
715         -
716           columnname: category
717         -
718           columnname: library
719         -
720           columnname: expires_on
721         -
722           columnname: circ_notes
723
724   reports:
725     lostitems:
726       lostitems-table:
727         -
728           columnname: title
729           cannot_be_toggled: 1
730           cannot_be_modified: 1
731         -
732           columnname: author
733         -
734           columnname: lostcode
735         -
736           columnname: itemlost_on
737         -
738           columnname: barcode
739         -
740           columnname: callnumber
741         -
742           columnname: datelastseen
743         -
744           columnname: price
745         -
746           columnname: replacementprice
747         -
748           columnname: library
749         -
750           columnname: itemtype
751         -
752           columnname: collection_code
753         -
754           columnname: current_location
755         -
756           columnname: location
757         -
758           columnname: notforloan
759         -
760           columnname: notes
761
762     saved-sql:
763       table_reports:
764         -
765           columnname: selection
766           cannot_be_toggled: 1
767           cannot_be_modified: 1
768         -
769           columnname: report_id
770           cannot_be_toggled: 1
771           cannot_be_modified: 1
772         -
773           columnname: report_name
774         -
775           columnname: type
776         -
777           columnname: group
778         -
779           columnname: subgroup
780         -
781           columnname: notes
782         -
783           columnname: author
784         -
785           columnname: creation_date
786         -
787           columnname: last_edit
788         -
789           columnname: last_run
790         -
791           columnname: public
792         -
793           columnname: json_url
794         -
795           columnname: cache_expiry
796         -
797           columnname: saved_results
798         -
799           columnname: update
800         -
801           columnname: actions
802           cannot_be_toggled: 1
803           cannot_be_modified: 1
804
805   circ:
806     circulation:
807       issues-table:
808         -
809           columnname: sort_order
810           cannot_be_toggled: 1
811           cannot_be_modified: 1
812           is_hidden: 1
813         -
814           columnname: todays_or_previous_checkouts
815           cannot_be_toggled: 1
816           cannot_be_modified: 1
817           is_hidden: 1
818         -
819           columnname: due_date_unformatted
820           cannot_be_toggled: 1
821           cannot_be_modified: 1
822           is_hidden: 1
823         -
824           columnname: due_date
825         -
826           columnname: title
827         -
828           columnname: record_type
829         -
830           columnname: item_type
831         -
832           columnname: collection
833         -
834           columnname: location
835         -
836           columnname: homebranch
837         -
838           columnname: checkout_on_unformatted
839           cannot_be_toggled: 1
840           cannot_be_modified: 1
841           is_hidden: 1
842         -
843           columnname: checkout_on
844         -
845           columnname: checkout_from
846         -
847           columnname: callno
848         -
849           columnname: charge
850         -
851           columnname: fine
852         -
853           columnname: price
854         -
855           columnname: renew
856           cannot_be_toggled: 1
857           cannot_be_modified: 1
858         -
859           columnname: checkin
860         -
861           columnname: export
862           cannot_be_toggled: 1
863           cannot_be_modified: 1
864       table_borrowers:
865         -
866           columnname: name
867           cannot_be_toggled: 1
868           cannot_be_modified: 1
869         -
870           columnname: cardnumber
871         -
872           columnname: date_of_birth
873         -
874           columnname: category
875         -
876           columnname: library
877         -
878           columnname: address
879         -
880           columnname: phone
881           is_hidden: 1
882     returns:
883       checkedintable:
884         -
885           columnname: due_date
886         -
887           columnname: title
888         -
889           columnname: author
890         -
891           columnname: barcode
892         -
893           columnname: homelibrary
894         -
895           columnname: holdinglibrary
896         -
897           columnname: location
898         -
899           columnname: itemcallnumber
900         -
901           columnname: dateaccessioned
902           is_hidden: 1
903         -
904           columnname: record_type
905         -
906           columnname: itype
907         -
908           columnname: borrower
909         -
910           columnname: itemnote
911
912     view_holdsqueue:
913       holds-table:
914         -
915           columnname: title
916         -
917           columnname: collection
918         -
919           columnname: document_type
920         -
921           columnname: callnumber
922         -
923           columnname: copynumber
924         -
925           columnname: enumeration
926         -
927           columnname: barcode
928         -
929           columnname: patron
930         -
931           columnname: send_to
932         -
933           columnname: date
934         -
935           columnname: notes
936
937     holds:
938       holds-to-pull:
939         -
940           columnname: pull_items
941         -
942           columnname: avalaible_items
943         -
944           columnname: patrons
945         -
946           columnname: patron
947         -
948           columnname: title
949         -
950           columnname: libraries
951         -
952           columnname: call_numbers
953         -
954           columnname: copy_numbers
955         -
956           columnname: enumeration
957         -
958           columnname: itemtypes
959         -
960           columnname: locations
961         -
962           columnname: hold_date
963         -
964           columnname: action
965
966     holdsratios:
967       holds-ratios:
968         -
969           columnname: holds
970         -
971           columnname: items
972         -
973           columnname: holds_ratio
974         -
975           columnname: title
976         -
977           columnname: home_libraries
978         -
979           columnname: holding_libraries
980         -
981           columnname: location
982         -
983           columnname: itemtype
984         -
985           columnname: call_numbers
986         -
987           columnname: items_needed
988
989     overdues:
990       circ-overdues:
991         -
992           columnname: due_date
993         -
994           columnname: patron
995         -
996           columnname: patron_category
997           is_hidden: 1
998         -
999           columnname: patron_library
1000         -
1001           columnname: title
1002         -
1003           columnname: home_library
1004           is_hidden: 1
1005         -
1006           columnname: holding_library
1007           is_hidden: 1
1008         -
1009           columnname: barcode
1010         -
1011           columnname: call_number
1012         -
1013           columnname: item_type
1014           is_hidden: 1
1015         -
1016           columnname: price
1017         -
1018           columnname: non-public_note
1019
1020   opac:
1021     biblio-detail:
1022       holdingst:
1023         -
1024           columnname: item_itemtype
1025         -
1026           columnname: item_current_location
1027         -
1028           columnname: item_home_location
1029         -
1030           columnname: item_shelving_location
1031           is_hidden: 1
1032         -
1033           columnname: item_ccode
1034         -
1035           columnname: item_callnumber
1036         -
1037           columnname: item_enumchron
1038         -
1039           columnname: item_url
1040         -
1041           columnname: item_copy
1042         -
1043           columnname: item_status
1044         -
1045           columnname: item_notes
1046         -
1047           columnname: item_datedue
1048         -
1049           columnname: item_barcode
1050           is_hidden: 1
1051         -
1052           columnname: item_holds
1053         -
1054           columnname: item_priority
1055         -
1056           columnname: item_coursereserves
1057
1058       subscriptionst:
1059         -
1060           columnname: serial_serialseq
1061         -
1062           columnname: serial_publisheddate
1063         -
1064           columnname: serial_planneddate
1065         -
1066           columnname: serial_status
1067         -
1068           columnname: serial_notes
1069
1070   serials:
1071     subscription-detail:
1072       orders:
1073         -
1074           columnname: invoice
1075         -
1076           columnname: basket
1077         -
1078           columnname: ordernumber
1079         -
1080           columnname: creation_date
1081         -
1082           columnname: receive_date
1083         -
1084           columnname: status
1085         -
1086           columnname: order_internalnote
1087         -
1088           columnname: order_vendornote
1089         -
1090           columnname: fund
1091         -
1092           columnname: ordered
1093         -
1094           columnname: spent
1095
1096   tools:
1097     notices:
1098       lettert:
1099         -
1100           columnname: library
1101         -
1102           columnname: module
1103         -
1104           columnname: code
1105         -
1106           columnname: name
1107         -
1108           columnname: copy_notice
1109         -
1110           columnname: actions
1111           cannot_be_toggled: 1
1112           cannot_be_modified: 1
1113
1114     stockrotation:
1115       stock_rotation:
1116         -
1117           columnname: name
1118         -
1119           columnname: cyclical
1120         -
1121           columnname: active
1122         -
1123           columnname: description
1124         -
1125           columnname: number_of_items
1126         -
1127           columnname: actions
1128           cannot_be_toggled: 1
1129           cannot_be_modified: 1
1130
1131       stock_rotation_manage_items:
1132         -
1133           columnname: barcode
1134         -
1135           columnname: title
1136         -
1137           columnname: author
1138         -
1139           columnname: call_number
1140         -
1141           columnname: in_transit
1142         -
1143           columnname: stages
1144         -
1145           columnname: actions
1146           cannot_be_toggled: 1
1147           cannot_be_modified: 1