1 <?xml version="1.0" encoding="UTF-8"?>
4 <table id="wide-copy" partition="false" fact-table="true">
5 <label>Wide Copy info</label>
6 <description>Base table for creating snapshot reports on copy information</description>
7 <tablename>stats.fleshed_copy</tablename>
16 <description>Copy ID</description>
20 widget-family="string-input"
22 <label>Barcode</label>
23 <description>Copy Barcode</description>
30 <description>ID of the Owning Library</description>
36 <label>Circulator</label>
37 <description>ID of the Circulating Library</description>
40 name="create_date_day"
42 <label>Create Date Joiner</label>
43 <description>Date of the copy's cataloging</description>
46 name="create_date_hour"
47 datatype="timestamptz">
48 <label>Create Date and Hour Joiner</label>
49 <description>Date and Hour of the copy's cataloging</description>
54 datatype="timestamptz"
57 <label>Create Date</label>
58 <description>Timestamp of the copy's cataloging</description>
62 datatype="timestamptz"
65 <label>Edit Date</label>
66 <description>Timestamp of the copy's last edit</description>
72 <label>Edit Date Joiner</label>
73 <description>Date of the copy's last edit</description>
77 datatype="timestamptz">
78 <label>Edit Date and Hour Joiner</label>
79 <description>Date and Hour of the copy's last edit</description>
84 <label>Language</label>
85 <description>MARC Item Language</description>
91 <description>MARC Item Form of Material</description>
97 <description>MARC Item Type</description>
100 name="call_number_label"
101 transform-group="call_number"
102 widget-family="string-input"
104 <label>Call Number</label>
105 <description>Copy Call Number Label</description>
111 field="create_date_day"
112 table="generic_day_series"
117 field="create_date_hour"
118 table="generic_hour_series"
119 id="copy_create_hour"
123 field="edit_date_day"
124 table="generic_day_series"
129 field="edit_date_hour"
130 table="generic_hour_series"
142 table="marc_lang_map"
148 table="marc_form_map"
154 table="marc_type_map"
168 <table id="org_unit" partition="false" fact-table="false">
169 <label>Organizational Units</label>
170 <description>Table containing library hierarchy definition</description>
171 <tablename>actor.org_unit</tablename>
180 <description>Library ID</description>
184 widget-family="lib-choose"
187 <description>Library Name</description>
191 widget-family="string-choose"
193 <label>Short Name</label>
194 <description>Library Short (Policy) Name</description>
199 <table id="marc_lang_map" partition="false" fact-table="false">
200 <label>MARC Language Codes</label>
201 <description>Table mapping MARC three character codes to language names</description>
202 <tablename>config.language_map</tablename>
210 <description>MARC Language Code</description>
214 widget-family="string-choose"
216 <label>Language Name</label>
217 <description>Name associated with the MARC code</description>
222 <table id="generic_day_series" partition="false" fact-table="false">
223 <label>Constant day series</label>
224 <description>View providing a day series starting at 1900 and ending at 'now'</description>
225 <tablename>reporter.date_series</tablename>
232 <label>Date joiner</label>
233 <description>Date joiner</description>
237 datatype="timestamptz">
239 <description>Date</description>
244 <table id="generic_hour_series" partition="false" fact-table="false">
245 <label>Constant hour series</label>
246 <description>View providing a hour series starting at 1900 and ending at 'now'</description>
247 <tablename>reporter.date_hour_series</tablename>
254 <label>time joiner</label>
255 <description>time joiner</description>
258 name="date_hour_label"
259 datatype="timestamptz">
260 <label>Date and Hour</label>
261 <description>Date and Hour</description>
266 <table id="marc_form_map" partition="false" fact-table="false">
267 <label>MARC Item Form Codes</label>
268 <description>Table mapping MARC three character codes to Item Form names</description>
269 <tablename>config.item_form_map</tablename>
277 <description>MARC Item Form Code</description>
281 widget-family="string-choose"
283 <label>Item Form Name</label>
284 <description>Name associated with the MARC code</description>
289 <table id="marc_type_map" partition="false" fact-table="false">
290 <label>MARC Item Type Codes</label>
291 <description>Table mapping MARC three character codes to Item Type names</description>
292 <tablename>config.item_type_map</tablename>
300 <description>MARC Item Type Code</description>
304 widget-family="string-choose"
306 <label>Item Type Name</label>
307 <description>Name associated with the MARC code</description>
312 <table id="silly.fact" partition="true" fact-table="false">
313 <label>Silly Fact table</label>
314 <description>Base table for creating reports on silly words</description>
315 <tablename>stats.silly_fact</tablename>
318 <field>said_when</field>
319 <!-- Valid options: years, months, weeks, days, hours, minutes, seconds -->
320 <chunk>months</chunk>
321 <start>2005-09-01</start>
322 <end>2005-12-31</end>
331 <label>Silly entry id</label>
332 <description>Silly entry id</description>
335 name="silly_word_dim"
338 <label>Silly word dim</label>
339 <description>Silly word entry dimension link</description>
342 name="silly_sayer_dim"
345 <label>Silly sayer dim</label>
346 <description>Silly sayer entry dimension link</description>
350 datatype="timestamptz"
354 <label>Silly word timestamp</label>
355 <description>Silly word entry timestamp</description>
360 field="silly_word_dim"
361 table="silly.word_dim"
365 field="silly_sayer_dim"
366 table="silly.sayer_dim"
372 <table id="silly.word_dim">
373 <label>Silly word list</label>
374 <description>Silly word list</description>
375 <tablename>stats.words</tablename>
382 <label>Silly word id</label>
389 <label>Silly word</label>
394 <table id="silly.sayer_dim">
395 <label>Silly word sayer list</label>
396 <description>Silly word sayer list</description>
397 <tablename>stats.silly_sayers</tablename>
404 <label>Silly person id</label>
408 widget-family="string-choose"
412 <label>Silly person</label>