Bug 29134: Use a subquery to increase performance of patron attributes search
[koha.git] / admin / columns_settings.yml
1 modules:
2   acqui:
3     histsearch:
4       histsearcht:
5         columns:
6             -
7               columnname: order_line
8             -
9               columnname: status
10             -
11               columnname: basket
12             -
13               columnname: basket_creator
14             -
15               columnname: basket_group
16             -
17               columnname: invoice_number
18             -
19               columnname: summary
20             -
21               columnname: vendor
22             -
23               columnname: placed_on
24             -
25               columnname: received_on
26             -
27               columnname: quantity_received
28             -
29               columnname: pending_order
30             -
31               columnname: unit_cost
32             -
33               columnname: fund
34
35     lateorders:
36       late_orders:
37         columns:
38             -
39               columnname: checkbox
40               cannot_be_toggled: 1
41               cannot_be_modified: 1
42             -
43               columnname: order_line
44             -
45               columnname: order_date
46             -
47               columnname: estimated_delivery_date
48             -
49               columnname: vendor
50             -
51               columnname: information
52             -
53               columnname: quantity
54             -
55               columnname: total_cost
56             -
57               columnname: basket
58             -
59               columnname: basket_group
60             -
61               columnname: library
62             -
63               columnname: budget
64             -
65               columnname: fund
66             -
67               columnname: claims_count
68             -
69               columnname: claimed_date
70             -
71               columnname: internal_note
72             -
73               columnname: vendor_note
74             -
75               columnname: isbn
76
77     basket:
78       orders:
79         default_display_length: 20
80         default_sort_order: 0
81         columns:
82             -
83               columnname: basket_number
84             -
85               columnname: order_information
86             -
87               columnname: recommended_retail_price_tax_excluded
88             -
89               columnname: actual_cost_tax_excluded
90             -
91               columnname: budgeted_cost_price_tax_included
92             -
93               columnname: recommended_retail_price_tax_included
94               is_hidden: 1
95             -
96               columnname: actual_cost_tax_included
97               is_hidden: 1
98             -
99               columnname: budgeted_cost_tax_included
100             -
101               columnname: replacement_price
102             -
103               columnname: quantity
104             -
105               columnname: total_tax_excluded
106             -
107               columnname: total_tax_included
108               is_hidden: 1
109             -
110               columnname: goods_and_services_tax_percentage
111             -
112               columnname: goods_and_services_tax
113             -
114               columnname: fund
115             -
116               columnname: supplier_report
117             -
118               columnname: modify
119               cannot_be_toggled: 1
120               cannot_be_modified: 1
121             -
122               columnname: cancel
123               cannot_be_toggled: 1
124               cannot_be_modified: 1
125
126     suggestions:
127       suggestions:
128         columns:
129             -
130               columnname: selections
131               cannot_be_toggled: 1
132               cannot_be_modified: 1
133             -
134               columnname: suggestion
135             -
136               columnname: suggested_by
137             -
138               columnname: suggested_on
139             -
140               columnname: managed_by
141             -
142               columnname: managed_on
143             -
144               columnname: lastmodificationby
145             -
146               columnname: lastmodificationdate
147             -
148               columnname: last_updated_date
149             -
150               columnname: library
151             -
152               columnname: library_fund
153             -
154               columnname: suggestion_status
155             -
156               columnname: actions
157               cannot_be_toggled: 1
158               cannot_be_modified: 1
159   admin:
160     currency:
161       currencies-table:
162         columns:
163             -
164               columnname: currency
165               cannot_be_toggled: 1
166               cannot_be_modified: 1
167             -
168               columnname: rate
169               cannot_be_toggled: 1
170               cannot_be_modified: 1
171             -
172               columnname: symbol
173             -
174               columnname: iso_code
175               is_hidden: 1
176             -
177               columnname: last_updated
178             -
179               columnname: active
180             -
181               columnname: actions
182
183     categories:
184       patron_categories:
185         columns:
186             -
187               columnname: code
188             -
189               columnname: category_name
190             -
191               columnname: type
192             -
193               columnname: enrollment_period
194             -
195               columnname: age_required
196             -
197               columnname: upper_age_limit
198             -
199               columnname: enrollment_fee
200             -
201               columnname: overdue
202             -
203               columnname: lost_items
204             -
205               columnname: hold_fee
206             -
207               columnname: messaging
208             -
209               columnname: branches_limitations
210             -
211               columnname: default_privacy
212             -
213               columnname: actions
214               cannot_be_toggled: 1
215               cannot_be_modified: 1
216
217     itemtypes:
218       table_item_type:
219         columns:
220             -
221               columnname: image
222             -
223               columnname: description
224             -
225               columnname: code
226             -
227               columnname: parent_code
228             -
229               columnname: search_category
230             -
231               columnname: not_for_loan
232             -
233               columnname: hide_in_opac
234             -
235               columnname: rental_charge
236             -
237               columnname: daily_rental_charge
238             -
239               columnname: hourly_rental_charge
240             -
241               columnname: default_replacement_cost
242             -
243               columnname: lost_processing_fee
244             -
245               columnname: checkin_message
246             -
247               columnname: library_limitations
248             -
249               columnname: actions
250               cannot_be_toggled: 1
251               cannot_be_modified: 1
252
253     libraries:
254       libraries:
255         columns:
256             -
257               columnname: library_name
258             -
259               columnname: library_code
260             -
261               columnname: library_address
262             -
263               columnname: marc_organization_code
264             -
265               columnname: library_ip
266             -
267               columnname: is_pickup_location
268             -
269               columnname: smtp_server
270             -
271               columnname: actions
272               cannot_be_toggled: 1
273               cannot_be_modified: 1
274
275   catalogue:
276     detail:
277       holdings_table:
278         columns:
279             -
280               columnname: holdings_checkbox
281               cannot_be_toggled: 1
282               cannot_be_modified: 1
283             -
284               columnname: holdings_cover_image
285             -
286               columnname: holdings_itype
287             -
288               columnname: holdings_holdingbranch
289             -
290               columnname: holdings_homebranch
291             -
292               columnname: holdings_ccode
293             -
294               columnname: holdings_itemcallnumber
295             -
296               columnname: holdings_status
297             -
298               columnname: holdings_lastseen
299             -
300               columnname: holdings_dateaccessioned
301             -
302               columnname: holdings_datelastborrowed
303             -
304               columnname: holdings_barcode
305             -
306               columnname: holdings_enumchron
307             -
308               columnname: holdings_uri
309             -
310               columnname: holdings_copynumber
311             -
312               columnname: holdings_stocknumber
313             -
314               columnname: holdings_materials
315             -
316               columnname: holdings_itemnotes
317             -
318               columnname: holdings_itemnotes_nonpublic
319             -
320               columnname: holdings_hostrecord
321             -
322               columnname: holdings_usedin
323             -
324               columnname: holdings_usedin_col
325             -
326               columnname: holdings_course_reserves
327             -
328               columnname: holdings_spinelabel
329             -
330               columnname: holdings_actions
331               cannot_be_toggled: 1
332               cannot_be_modified: 1
333
334       otherholdings_table:
335         columns:
336             -
337               columnname: otherholdings_checkbox
338               cannot_be_toggled: 1
339               cannot_be_modified: 1
340             -
341               columnname: otherholdings_cover_image
342             -
343               columnname: otherholdings_itype
344             -
345               columnname: otherholdings_holdingbranch
346             -
347               columnname: otherholdings_homebranch
348             -
349               columnname: otherholdings_ccode
350             -
351               columnname: otherholdings_itemcallnumber
352             -
353               columnname: otherholdings_status
354             -
355               columnname: otherholdings_lastseen
356             -
357               columnname: otherholdings_dateaccessioned
358             -
359               columnname: otherholdings_barcode
360             -
361               columnname: otherholdings_enumchron
362             -
363               columnname: otherholdings_uri
364             -
365               columnname: otherholdings_copynumber
366             -
367               columnname: otherholdings_stocknumber
368             -
369               columnname: otherholdings_materials
370             -
371               columnname: otherholdings_itemnotes
372             -
373               columnname: otherholdings_itemnotes_nonpublic
374             -
375               columnname: otherholdings_hostrecord
376             -
377               columnname: otherholdings_usedin
378             -
379               columnname: otherholdings_usedin_col
380             -
381               columnname: otherholdings_course_reserves
382             -
383               columnname: otherholdings_spinelabel
384             -
385               columnname: otherholdings_actions
386               cannot_be_toggled: 1
387               cannot_be_modified: 1
388
389       acquisitiondetails-table:
390         columns:
391             -
392               columnname: vendor
393             -
394               columnname: invoice
395             -
396               columnname: basketgroup
397             -
398               columnname: basket
399             -
400               columnname: ordernumber
401             -
402               columnname: creation_date
403             -
404               columnname: received_data
405             -
406               columnname: status
407             -
408               columnname: quantity
409             -
410               columnname: price
411             -
412               columnname: order_internalnote
413             -
414               columnname: subscription
415             -
416               columnname: subscription_callnumber
417
418       checkoutshistory-table:
419         columns:
420             -
421               columnname: patron
422               cannot_be_toggled: 1
423               cannot_be_modified: 1
424             -
425               columnname: barcode
426               cannot_be_toggled: 1
427               cannot_be_modified: 1
428             -
429               columnname: checked_out_from
430             -
431               columnname: renewed
432             -
433               columnname: checkout_on
434             -
435               columnname: due_date
436             -
437               columnname: checkin_on
438
439   cataloguing:
440     additem:
441       itemst:
442         # NOTE: These columns are in the same order as kohastructure.sql, and contain all items
443         # columns except for the following internal/obsolete fields: stack, more_subfields_xml,
444         # cn_sort, permanent_location, damaged_on itemlost_on, withdrawn_on, issues, renewals and
445         # reserves.
446         columns:
447             -
448               columnname: barcode
449             -
450               columnname: dateaccessioned
451             -
452               columnname: booksellerid
453             -
454               columnname: homebranch
455             -
456               columnname: price
457             -
458               columnname: replacementprice
459             -
460               columnname: replacementpricedate
461             -
462               columnname: datelastborrowed
463             -
464               columnname: datelastseen
465             -
466               columnname: stack
467             -
468               columnname: notforloan
469             -
470               columnname: damaged
471             -
472               columnname: itemlost
473             -
474               columnname: withdrawn
475             -
476               columnname: itemcallnumber
477             -
478               columnname: coded_location_qualifier
479             -
480               columnname: restricted
481             -
482               columnname: itemnotes
483             -
484               columnname: itemnotes_nonpublic
485             -
486               columnname: holdingbranch
487             -
488               columnname: timestamp
489             -
490               columnname: location
491             -
492               columnname: onloan
493             -
494               columnname: cn_source
495             -
496               columnname: ccode
497             -
498               columnname: materials
499             -
500               columnname: uri
501             -
502               columnname: itype
503             -
504               columnname: enumchron
505             -
506               columnname: copynumber
507             -
508               columnname: stocknumber
509
510     z3950_search:
511       resultst:
512         columns:
513             -
514               columnname: server
515             -
516               columnname: title
517             -
518               columnname: author
519             -
520               columnname: date
521             -
522               columnname: edition
523             -
524               columnname: isbn
525             -
526               columnname: lccn
527             -
528               columnname: actions
529               cannot_be_toggled: 1
530               cannot_be_modified: 1
531
532   coursereserves:
533     courses:
534       course_reserves_table:
535         columns:
536             -
537               columnname: name
538             -
539               columnname: department
540             -
541               columnname: course_no
542             -
543               columnname: section
544             -
545               columnname: term
546             -
547               columnname: instructors
548             -
549               columnname: staff_note
550             -
551               columnname: public_note
552             -
553               columnname: no_of_students
554             -
555               columnname: enabled
556
557     reserves:
558       course_reserves_table:
559         columns:
560             -
561               columnname: title
562             -
563              columnname: author
564             -
565               columnname: barcode
566             -
567               columnname: call_number
568             -
569               columnname: item_type
570             -
571               columnname: collection
572             -
573               columnname: location
574             -
575               columnname: library
576             -
577               columnname: staff_note
578             -
579               columnname: public_note
580             -
581               columnname: link
582             -
583               columnname: other_course_reserves
584             -
585               columnname: actions
586               cannot_be_toggled: 1
587               cannot_be_modified: 1
588
589   illrequests:
590     ill-requests:
591       ill-requests:
592         columns:
593             -
594               columnname: illrequest_id
595             -
596               columnname: metadata_author
597             -
598               columnname: metadata_title
599             -
600               columnname: metadata_article_title
601             -
602               columnname: metadata_issue
603             -
604               columnname: metadata_volume
605             -
606               columnname: metadata_year
607             -
608               columnname: metadata_pages
609             -
610               columnname: metadata_type
611             -
612               columnname: orderid
613             -
614               columnname: patron
615             -
616               columnname: biblio_id
617             -
618               columnname: library_branchname
619             -
620               columnname: status
621             -
622               columnname: placed
623               cannot_be_toggled: 1
624               cannot_be_modified: 1
625               is_hidden: 1
626             -
627               columnname: placed_formatted
628             -
629               columnname: updated
630               cannot_be_toggled: 1
631               cannot_be_modified: 1
632               is_hidden: 1
633             -
634               columnname: updated_formatted
635             -
636               columnname: replied
637             -
638               columnname: completed
639               cannot_be_toggled: 1
640               cannot_be_modified: 1
641               is_hidden: 1
642             -
643               columnname: completed_formatted
644             -
645               columnname: accessurl
646             -
647               columnname: cost
648             -
649               columnname: comments
650             -
651               columnname: notesopac
652             -
653               columnname: notesstaff
654             -
655               columnname: backend
656             -
657               columnname: action
658               cannot_be_toggled: 1
659               cannot_be_modified: 1
660
661   members:
662     fines:
663       account-fines:
664         columns:
665             -
666               columnname: date
667             -
668               columnname: credit_number
669               is_hidden: 1
670             -
671               columnname: account_type
672             -
673               columnname: description
674             -
675               columnname: barcode
676             -
677               columnname: date_due
678             -
679               columnname: returndate
680             -
681               columnname: issuedate
682             -
683               columnname: home_library
684             -
685               columnname: checked_out_from
686             -
687               columnname: note
688             -
689               columnname: amount
690               cannot_be_toggled: 1
691               cannot_be_modified: 1
692             -
693               columnname: amountoutstanding
694               cannot_be_toggled: 1
695               cannot_be_modified: 1
696             -
697               columnname: actions
698               cannot_be_toggled: 1
699               cannot_be_modified: 1
700
701     pay:
702       pay-fines-table:
703         columns:
704             -
705               columnname: checkbox
706               cannot_be_toggled: 1
707               cannot_be_modified: 1
708             -
709               columnname: actions
710               cannot_be_toggled: 1
711               cannot_be_modified: 1
712             -
713               columnname: account_type
714             -
715               columnname: description
716             -
717               columnname: date
718             -
719               columnname: barcode
720             -
721               columnname: date_due
722             -
723               columnname: returndate
724             -
725               columnname: issuedate
726             -
727               columnname: checked_out_from
728             -
729               columnname: note
730             -
731               columnname: amount
732             -
733               columnname: amountoutstanding
734
735     member:
736       memberresultst:
737         columns:
738             -
739               columnname: checkbox
740               cannot_be_toggled: 1
741               cannot_be_modified: 1
742             -
743               columnname: cardnumber
744             -
745               columnname: name
746             -
747               columnname: dateofbirth
748             -
749               columnname: category
750             -
751               columnname: library
752             -
753               columnname: expires_on
754             -
755               columnname: od_checkouts
756             -
757               columnname: fines
758             -
759               columnname: circ_notes
760             -
761               columnname: actions
762               cannot_be_toggled: 1
763               cannot_be_modified: 1
764
765     moremember:
766       issues-table:
767         columns:
768             -
769               columnname: sort_order
770               cannot_be_toggled: 1
771               cannot_be_modified: 1
772               is_hidden: 1
773             -
774               columnname: todays_or_previous_checkouts
775               cannot_be_toggled: 1
776               cannot_be_modified: 1
777               is_hidden: 1
778             -
779               columnname: due_date_unformatted
780               cannot_be_toggled: 1
781               cannot_be_modified: 1
782               is_hidden: 1
783             -
784               columnname: due_date
785             -
786               columnname: title
787             -
788               columnname: record_type
789             -
790               columnname: item_type
791             -
792               columnname: collection
793             -
794               columnname: location
795             -
796               columnname: homebranch
797             -
798               columnname: checkout_on_unformatted
799               cannot_be_toggled: 1
800               cannot_be_modified: 1
801               is_hidden: 1
802             -
803               columnname: checkout_on
804             -
805               columnname: checkout_from
806             -
807               columnname: callno
808             -
809               columnname: copynumber
810             -
811               columnname: charge
812             -
813               columnname: fine
814             -
815               columnname: price
816             -
817               columnname: renew
818               cannot_be_toggled: 1
819               cannot_be_modified: 1
820             -
821               columnname: checkin
822             -
823               columnname: claims_returned
824             -
825               columnname: export
826               cannot_be_toggled: 1
827               cannot_be_modified: 1
828
829     holdshistory:
830       holdshistory-table:
831         columns:
832             -
833               columnname: title
834               cannot_be_toggled: 1
835               cannot_be_modified: 1
836             -
837               columnname: author
838             -
839               columnname: barcode
840             -
841               columnname: branch
842             -
843               columnname: reservedate
844             -
845               columnname: expirationdate
846             -
847               columnname: waitingdate
848             -
849               columnname: cancellationdate
850             -
851               columnname: itemtype
852             -
853               columnname: status
854
855     checkouthistory:
856       checkouthistory-table:
857         columns:
858             - columnname: type
859               cannot_be_toggled: 1
860               cannot_be_modified: 1
861             -
862               columnname: date
863             -
864               columnname: title
865             -
866               columnname: author
867             -
868               columnname: call_number
869             -
870               columnname: barcode
871             -
872               columnname: number_of_renewals
873             -
874               columnname: checked_out_on
875             -
876               columnname: checked_out_from
877             -
878               columnname: date_due
879             -
880               columnname: return_date
881
882     patron-lists:
883       patron-list-table:
884         columns:
885             -
886               columnname: checkbox
887               cannot_be_toggled: 1
888               cannot_be_modified: 1
889             -
890               columnname: card
891             -
892               columnname: firstname
893             -
894               columnname: surname
895             -
896               columnname: address
897             -
898               columnname: category
899             -
900               columnname: library
901             -
902               columnname: expires_on
903             -
904               columnname: circ_notes
905
906   reports:
907     lostitems:
908       lostitems-table:
909         columns:
910             -
911               columnname: title
912               cannot_be_toggled: 1
913               cannot_be_modified: 1
914             -
915               columnname: author
916             -
917               columnname: lostcode
918             -
919               columnname: itemlost_on
920             -
921               columnname: barcode
922             -
923               columnname: callnumber
924             -
925               columnname: datelastseen
926             -
927               columnname: price
928             -
929               columnname: replacementprice
930             -
931               columnname: library
932             -
933               columnname: itemtype
934             -
935               columnname: collection_code
936             -
937               columnname: current_location
938             -
939               columnname: location
940             -
941               columnname: notforloan
942             -
943               columnname: notes
944
945     orders_by_fund:
946       funds-table:
947         default_display_length: 20
948         default_sort_order: 0
949         columns:
950             -
951               columnname: fund
952             -
953               columnname: basket
954               cannot_be_toggled: 1
955               cannot_be_modified: 1
956             -
957               columnname: basket_name
958             -
959               columnname: basket_by
960             -
961               columnname: title
962             -
963               columnname: currency
964             -
965               columnname: list_price
966             -
967               columnname: rrp
968             -
969               columnname: budgeted_cost
970             -
971               columnname: quantity
972             -
973               columnname: total_rrp
974             -
975               columnname: total_cost
976             -
977               columnname: entry_date
978             -
979               columnname: date_received
980             -
981               columnname: internal_note
982             -
983               columnname: vendor_note
984
985     saved-sql:
986       table_reports:
987         columns:
988             -
989               columnname: selection
990               cannot_be_toggled: 1
991               cannot_be_modified: 1
992             -
993               columnname: report_id
994               cannot_be_toggled: 1
995               cannot_be_modified: 1
996             -
997               columnname: report_name
998             -
999               columnname: type
1000             -
1001               columnname: group
1002             -
1003               columnname: subgroup
1004             -
1005               columnname: notes
1006             -
1007               columnname: author
1008             -
1009               columnname: creation_date
1010             -
1011               columnname: last_edit
1012             -
1013               columnname: last_run
1014             -
1015               columnname: public
1016             -
1017               columnname: json_url
1018             -
1019               columnname: cache_expiry
1020             -
1021               columnname: saved_results
1022             -
1023               columnname: update
1024             -
1025               columnname: actions
1026               cannot_be_toggled: 1
1027               cannot_be_modified: 1
1028
1029   circ:
1030     circulation:
1031       issues-table:
1032         columns:
1033             -
1034               columnname: sort_order
1035               cannot_be_toggled: 1
1036               cannot_be_modified: 1
1037               is_hidden: 1
1038             -
1039               columnname: todays_or_previous_checkouts
1040               cannot_be_toggled: 1
1041               cannot_be_modified: 1
1042               is_hidden: 1
1043             -
1044               columnname: due_date_unformatted
1045               cannot_be_toggled: 1
1046               cannot_be_modified: 1
1047               is_hidden: 1
1048             -
1049               columnname: due_date
1050             -
1051               columnname: title
1052             -
1053               columnname: record_type
1054             -
1055               columnname: item_type
1056             -
1057               columnname: collection
1058             -
1059               columnname: location
1060             -
1061               columnname: homebranch
1062             -
1063               columnname: checkout_on_unformatted
1064               cannot_be_toggled: 1
1065               cannot_be_modified: 1
1066               is_hidden: 1
1067             -
1068               columnname: checkout_on
1069             -
1070               columnname: checkout_from
1071             -
1072               columnname: callno
1073             -
1074               columnname: copynumber
1075             -
1076               columnname: charge
1077             -
1078               columnname: fine
1079             -
1080               columnname: price
1081             -
1082               columnname: renew
1083               cannot_be_toggled: 1
1084               cannot_be_modified: 1
1085             -
1086               columnname: checkin
1087             -
1088               columnname: claims_returned
1089             -
1090               columnname: export
1091               cannot_be_toggled: 1
1092               cannot_be_modified: 1
1093
1094       table_borrowers:
1095         columns:
1096             -
1097               columnname: name
1098               cannot_be_toggled: 1
1099               cannot_be_modified: 1
1100             -
1101               columnname: cardnumber
1102             -
1103               columnname: date_of_birth
1104             -
1105               columnname: category
1106             -
1107               columnname: library
1108             -
1109               columnname: address
1110             -
1111               columnname: phone
1112               is_hidden: 1
1113
1114     returns:
1115       checkedintable:
1116         columns:
1117             -
1118               columnname: due_date
1119             -
1120               columnname: title
1121             -
1122               columnname: author
1123             -
1124               columnname: barcode
1125             -
1126               columnname: homelibrary
1127             -
1128               columnname: holdinglibrary
1129             -
1130               columnname: location
1131             -
1132               columnname: itemcallnumber
1133             -
1134               columnname: dateaccessioned
1135               is_hidden: 1
1136             -
1137               columnname: record_type
1138             -
1139               columnname: itype
1140             -
1141               columnname: ccode
1142             -
1143               columnname: borrower
1144             -
1145               columnname: itemnote
1146
1147     view_holdsqueue:
1148       holds-table:
1149         columns:
1150             -
1151               columnname: title
1152             -
1153               columnname: collection
1154             -
1155               columnname: document_type
1156             -
1157               columnname: callnumber
1158             -
1159               columnname: copynumber
1160             -
1161               columnname: enumeration
1162             -
1163               columnname: barcode
1164             -
1165               columnname: patron
1166             -
1167               columnname: send_to
1168             -
1169               columnname: date
1170             -
1171               columnname: notes
1172
1173     holds:
1174       holds-to-pull:
1175         columns:
1176             -
1177               columnname: pull_items
1178             -
1179               columnname: avalaible_items
1180             -
1181               columnname: patrons
1182             -
1183               columnname: patron
1184             -
1185               columnname: title
1186             -
1187               columnname: libraries
1188             -
1189               columnname: barcodes
1190             -
1191               columnname: call_numbers
1192             -
1193               columnname: copy_numbers
1194             -
1195               columnname: enumeration
1196             -
1197               columnname: itemtypes
1198             -
1199               columnname: locations
1200             -
1201               columnname: hold_date
1202             -
1203               columnname: action
1204
1205     holdsratios:
1206       holds-ratios:
1207         columns:
1208             -
1209               columnname: holds
1210             -
1211               columnname: items
1212             -
1213               columnname: holds_ratio
1214             -
1215               columnname: title
1216             -
1217               columnname: home_libraries
1218             -
1219               columnname: holding_libraries
1220             -
1221               columnname: location
1222             -
1223               columnname: itemtype
1224             -
1225               columnname: call_numbers
1226             -
1227               columnname: items_needed
1228
1229     holds_awaiting_pickup:
1230       holdst:
1231         columns:
1232             -
1233               columnname: waiting_since
1234             -
1235               columnname: date_hold_placed
1236             -
1237               columnname: title
1238             -
1239               columnname: patron
1240             -
1241               columnname: home_library
1242             -
1243               columnname: current_location
1244             -
1245               columnname: shelving_location
1246             -
1247               columnname: call_number
1248             -
1249               columnname: copy_number
1250             -
1251               columnname: enumeration
1252             -
1253               columnname: action
1254
1255       holdso:
1256         columns:
1257             -
1258               columnname: waiting_since
1259             -
1260               columnname: date_hold_placed
1261             -
1262               columnname: title
1263             -
1264               columnname: patron
1265             -
1266               columnname: home_library
1267             -
1268               columnname: current_location
1269             -
1270               columnname: shelving_location
1271             -
1272               columnname: call_number
1273             -
1274               columnname: copy_number
1275             -
1276               columnname: enumeration
1277             -
1278               columnname: action
1279
1280     overdues:
1281       circ-overdues:
1282         columns:
1283             -
1284               columnname: due_date
1285             -
1286               columnname: patron
1287             -
1288               columnname: patron_category
1289               is_hidden: 1
1290             -
1291               columnname: patron_library
1292             -
1293               columnname: title
1294             -
1295               columnname: home_library
1296               is_hidden: 1
1297             -
1298               columnname: holding_library
1299               is_hidden: 1
1300             -
1301               columnname: barcode
1302             -
1303               columnname: call_number
1304             -
1305               columnname: item_type
1306               is_hidden: 1
1307             -
1308               columnname: price
1309             -
1310               columnname: non-public_note
1311
1312   opac:
1313     biblio-detail:
1314       holdingst:
1315         columns:
1316             -
1317               columnname: item_cover
1318             -
1319               columnname: item_itemtype
1320             -
1321               columnname: item_current_location
1322             -
1323               columnname: item_home_location
1324             -
1325               columnname: item_shelving_location
1326               is_hidden: 1
1327             -
1328               columnname: item_ccode
1329             -
1330               columnname: item_callnumber
1331             -
1332               columnname: item_materials
1333               is_hidden: 1
1334             -
1335               columnname: item_enumchron
1336             -
1337               columnname: item_url
1338             -
1339               columnname: item_copy
1340             -
1341               columnname: item_status
1342             -
1343               columnname: item_notes
1344             -
1345               columnname: item_datedue
1346             -
1347               columnname: item_barcode
1348               is_hidden: 1
1349             -
1350               columnname: item_holds
1351             -
1352               columnname: item_priority
1353             -
1354               columnname: item_coursereserves
1355
1356       course_reserves_table:
1357         columns:
1358             -
1359               columnname: coursename
1360             -
1361               columnname: department
1362             -
1363               columnname: course_number
1364             -
1365               columnname: section
1366             -
1367               columnname: term
1368             -
1369               columnname: instructor
1370             -
1371               columnname: notes
1372
1373       subscriptionst:
1374         columns:
1375             -
1376               columnname: serial_serialseq
1377             -
1378               columnname: serial_publisheddate
1379             -
1380               columnname: serial_planneddate
1381             -
1382               columnname: serial_status
1383             -
1384               columnname: serial_notes
1385
1386       course-items-table:
1387         columns:
1388             -
1389               columnname: title
1390             -
1391               columnname: author
1392             -
1393               columnname: itemtype
1394             -
1395               columnname: location
1396             -
1397               columnname: collection
1398             -
1399               columnname: callnumber
1400             -
1401               columnname: copynumber
1402             -
1403               columnname: status
1404             -
1405               columnname: datedue
1406             -
1407               columnname: notes
1408             -
1409               columnname: link
1410
1411   serials:
1412     subscription-detail:
1413       orders:
1414         columns:
1415             -
1416               columnname: invoice
1417             -
1418               columnname: basket
1419             -
1420               columnname: ordernumber
1421             -
1422               columnname: creation_date
1423             -
1424               columnname: receive_date
1425             -
1426               columnname: status
1427             -
1428               columnname: order_internalnote
1429             -
1430               columnname: order_vendornote
1431             -
1432               columnname: fund
1433             -
1434               columnname: ordered
1435             -
1436               columnname: spent
1437
1438   tools:
1439     logviewer:
1440       logst:
1441         columns:
1442             -
1443               columnname: date
1444             -
1445               columnname: librarian
1446             -
1447               columnname: module
1448             -
1449               columnname: action
1450             -
1451               columnname: object
1452             -
1453               columnname: info
1454             -
1455               columnname: interface
1456     marc-modification-templates:
1457       templatest:
1458         columns:
1459             -
1460               columnname: id
1461               is_hidden: 1
1462             -
1463               columnname: template
1464             -
1465               columnname: actions
1466               cannot_be_toggled: 1
1467               cannot_be_modified: 1
1468     notices:
1469       lettert:
1470         columns:
1471             -
1472               columnname: library
1473             -
1474               columnname: module
1475             -
1476               columnname: code
1477             -
1478               columnname: name
1479             -
1480               columnname: updated_on
1481             -
1482               columnname: copy_notice
1483             -
1484               columnname: actions
1485               cannot_be_toggled: 1
1486               cannot_be_modified: 1
1487
1488     stockrotation:
1489       stock_rotation:
1490         columns:
1491             -
1492               columnname: name
1493             -
1494               columnname: cyclical
1495             -
1496               columnname: active
1497             -
1498               columnname: description
1499             -
1500               columnname: number_of_items
1501             -
1502               columnname: actions
1503               cannot_be_toggled: 1
1504               cannot_be_modified: 1
1505
1506       stock_rotation_manage_items:
1507         columns:
1508             -
1509               columnname: barcode
1510             -
1511               columnname: title
1512             -
1513               columnname: author
1514             -
1515               columnname: call_number
1516             -
1517               columnname: in_transit
1518             -
1519               columnname: stages
1520             -
1521               columnname: actions
1522               cannot_be_toggled: 1
1523               cannot_be_modified: 1
1524
1525   pos:
1526     pay:
1527       invoices:
1528         columns:
1529             -
1530               columnname: code
1531             -
1532               columnname: description
1533             -
1534               columnname: cost
1535             -
1536               columnname: actions
1537               cannot_be_toggled: 1
1538               cannot_be_modified: 1