1 <?xml version="1.0" encoding="UTF-8"?>
4 <table id="wide-circulation" partition="false" fact-table="true">
5 <label>Circulation</label>
6 <description>Base table for creating circulation reports</description>
7 <tablename>stats.fleshed_circulation</tablename>
16 <description>Circulation ID</description>
22 <label>Circulator</label>
23 <description>ID of the Circulating Library</description>
29 <label>Checkin Library</label>
30 <description>ID of the Checkin Library</description>
37 <description>ID of the Owning Library</description>
42 <label>Start Date</label>
43 <description>Date of the copy's cataloging</description>
46 name="start_date_hour"
47 datatype="timestamptz">
48 <label>Start Date and Hour</label>
49 <description>Date and Hour of the circulation start</description>
55 <label>Due Date</label>
56 <description>Day the circulation is due</description>
60 datatype="timestamptz"
62 <label>Due Date and Hour</label>
63 <description>Day and Hour the circulation is due</description>
67 datatype="timestamptz"
70 <label>Due Date</label>
71 <description>Timestamp of the circulation due date</description>
75 datatype="timestamptz"
78 <label>Start Time</label>
79 <description>Timestamp of the circulation start</description>
83 datatype="timestamptz"
86 <label>Finish Time</label>
87 <description>Timestamp of the circulation end</description>
90 name="finish_date_day"
92 <label>Finsh Date</label>
93 <description>Date of the circulation end</description>
96 name="finish_date_hour"
97 datatype="timestamptz">
98 <label>Finish Date and Hour</label>
99 <description>Date and Hour of the circulation end</description>
104 <label>Language</label>
105 <description>MARC Item Language</description>
111 <description>MARC Item Form of Material</description>
117 <description>MARC Item Type</description>
120 name="call_number_label"
121 transform-group="call_number"
122 widget-family="string-input"
124 <label>Call Number</label>
125 <description>Copy Call Number Label</description>
131 field="start_date_day"
132 table="generic_day_series"
137 field="start_date_hour"
138 table="generic_hour_series"
143 field="finish_date_day"
144 table="generic_day_series"
149 field="due_date_hour"
150 table="generic_hour_series"
151 id="circ_due_date_hour"
156 table="generic_day_series"
157 id="circ_due_date_day"
161 field="finish_date_hour"
162 table="generic_hour_series"
163 id="circ_finish_hour"
169 id="circ_checkin_lib"
180 table="marc_lang_map"
186 table="marc_form_map"
192 table="marc_type_map"
206 <table id="wide-copy" partition="false" fact-table="true">
207 <label>Copies</label>
208 <description>Base table for creating snapshot reports on copy information</description>
209 <tablename>stats.fleshed_copy</tablename>
218 <description>Copy ID</description>
222 widget-family="string-input"
224 <label>Barcode</label>
225 <description>Copy Barcode</description>
232 <description>ID of the Owning Library</description>
238 <label>Circulator</label>
239 <description>ID of the Circulating Library</description>
242 name="create_date_day"
244 <label>Create Date</label>
245 <description>Date of the copy's cataloging</description>
248 name="create_date_hour"
249 datatype="timestamptz">
250 <label>Create Date and Hour</label>
251 <description>Date and Hour of the copy's cataloging</description>
255 datatype="timestamptz"
258 <label>Create Date</label>
259 <description>Timestamp of the copy's cataloging</description>
263 datatype="timestamptz"
266 <label>Edit Date</label>
267 <description>Timestamp of the copy's last edit</description>
272 <label>Edit Date</label>
273 <description>Date of the copy's last edit</description>
276 name="edit_date_hour"
277 datatype="timestamptz">
278 <label>Edit Date and Hour</label>
279 <description>Date and Hour of the copy's last edit</description>
284 <label>Language</label>
285 <description>MARC Item Language</description>
291 <description>MARC Item Form of Material</description>
297 <description>MARC Item Type</description>
300 name="call_number_label"
301 transform-group="call_number"
302 widget-family="string-input"
304 <label>Call Number</label>
305 <description>Copy Call Number Label</description>
311 field="create_date_day"
312 table="generic_day_series"
317 field="create_date_hour"
318 table="generic_hour_series"
319 id="copy_create_hour"
323 field="edit_date_day"
324 table="generic_day_series"
329 field="edit_date_hour"
330 table="generic_hour_series"
342 table="marc_lang_map"
348 table="marc_form_map"
354 table="marc_type_map"
368 <table id="wide-call-number" partition="false" fact-table="true">
369 <label>Call Numbers/Volumes</label>
370 <description>Base table for creating snapshot reports on call number/volume information</description>
371 <tablename>stats.fleshed_call_number</tablename>
380 <description>Call Number ID</description>
387 <description>ID of the Owning Library</description>
390 name="create_date_day"
392 <label>Create Date</label>
393 <description>Date of the call number's cataloging</description>
396 name="create_date_hour"
397 datatype="timestamptz">
398 <label>Create Date and Hour</label>
399 <description>Date and Hour of the call number's cataloging</description>
403 datatype="timestamptz"
406 <label>Create Date</label>
407 <description>Timestamp of the call number's cataloging</description>
411 datatype="timestamptz"
414 <label>Edit Date</label>
415 <description>Timestamp of the call number's last edit</description>
420 <label>Edit Date</label>
421 <description>Date of the call number's last edit</description>
424 name="edit_date_hour"
425 datatype="timestamptz">
426 <label>Edit Date and Hour</label>
427 <description>Date and Hour of the call number's last edit</description>
432 <label>Language</label>
433 <description>MARC Item Language</description>
439 <description>MARC Item Form of Material</description>
445 <description>MARC Item Type</description>
449 transform-group="call_number"
450 widget-family="string-input"
452 <label>Call Number</label>
453 <description>Call Number Label</description>
459 field="create_date_day"
460 table="generic_day_series"
461 id="call_number_create_day"
465 field="create_date_hour"
466 table="generic_hour_series"
467 id="call_number_create_hour"
471 field="edit_date_day"
472 table="generic_day_series"
473 id="call_number_edit_day"
477 field="edit_date_hour"
478 table="generic_hour_series"
479 id="call_number_edit_hour"
485 id="call_number_owning_lib"
490 table="marc_lang_map"
491 id="call_number_language"
496 table="marc_form_map"
497 id="call_number_item_form"
502 table="marc_type_map"
503 id="call_number_item_type"
510 <table id="org_unit" partition="false" fact-table="false">
511 <label>Organizational Units</label>
512 <description>Table containing library hierarchy definition</description>
513 <tablename>actor.org_unit</tablename>
520 widget-family="lib-choose"
523 <label>Unique Library ID</label>
524 <description>Unique Library ID</description>
528 widget-family="string-choose"
531 <description>Library Name</description>
535 widget-family="string-choose"
537 <label>Short Name</label>
538 <description>Library Short (Policy) Name</description>
543 <table id="marc_lang_map" partition="false" fact-table="false">
544 <label>MARC Language Codes</label>
545 <description>Table mapping MARC three character codes to language names</description>
546 <tablename>config.language_map</tablename>
554 <description>MARC Language Code</description>
558 widget-family="string-choose"
560 <label>Language Name</label>
561 <description>Name associated with the MARC code</description>
566 <table id="generic_day_series" partition="false" fact-table="false">
567 <label>Constant day series</label>
568 <description>View providing a day series starting at 1900 and ending at 'now'</description>
569 <tablename>reporter.date_series</tablename>
577 datatype="timestamptz">
579 <description>Date</description>
584 <table id="generic_hour_series" partition="false" fact-table="false">
585 <label>Constant hour series</label>
586 <description>View providing a hour series starting at 1900 and ending at 'now'</description>
587 <tablename>reporter.date_hour_series</tablename>
595 datatype="timestamptz">
596 <label>Date and Hour</label>
597 <description>Date and Hour</description>
602 <table id="marc_form_map" partition="false" fact-table="false">
603 <label>MARC Item Form Codes</label>
604 <description>Table mapping MARC three character codes to Item Form names</description>
605 <tablename>config.item_form_map</tablename>
613 <description>MARC Item Form Code</description>
617 widget-family="string-choose"
619 <label>Item Form Name</label>
620 <description>Name associated with the MARC code</description>
625 <table id="marc_type_map" partition="false" fact-table="false">
626 <label>MARC Item Type Codes</label>
627 <description>Table mapping MARC three character codes to Item Type names</description>
628 <tablename>config.item_type_map</tablename>
636 <description>MARC Item Type Code</description>
640 widget-family="string-choose"
642 <label>Item Type Name</label>
643 <description>Name associated with the MARC code</description>
650 <table id="silly.fact" partition="true" fact-table="false">
651 <label>Silly Fact table</label>
652 <description>Base table for creating reports on silly words</description>
653 <tablename>stats.silly_fact</tablename>
656 <field>said_when</field>
657 --><!-- Valid options: years, months, weeks, days, hours, minutes, seconds --><!--
658 <chunk>months</chunk>
659 <start>2005-09-01</start>
660 <end>2005-12-31</end>
669 <label>Silly entry id</label>
670 <description>Silly entry id</description>
673 name="silly_word_dim"
676 <label>Silly word dim</label>
677 <description>Silly word entry dimension link</description>
680 name="silly_sayer_dim"
683 <label>Silly sayer dim</label>
684 <description>Silly sayer entry dimension link</description>
688 datatype="timestamptz"
692 <label>Silly word timestamp</label>
693 <description>Silly word entry timestamp</description>
698 field="silly_word_dim"
699 table="silly.word_dim"
703 field="silly_sayer_dim"
704 table="silly.sayer_dim"
710 <table id="silly.word_dim">
711 <label>Silly word list</label>
712 <description>Silly word list</description>
713 <tablename>stats.words</tablename>
720 <label>Silly word id</label>
727 <label>Silly word</label>
732 <table id="silly.sayer_dim">
733 <label>Silly word sayer list</label>
734 <description>Silly word sayer list</description>
735 <tablename>stats.silly_sayers</tablename>
742 <label>Silly person id</label>
746 widget-family="string-choose"
750 <label>Silly person</label>