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</label>
43 <description>Date of the copy's cataloging</description>
46 name="create_date_hour"
47 datatype="timestamptz">
48 <label>Create Date and Hour</label>
49 <description>Date and Hour of the copy's cataloging</description>
53 datatype="timestamptz"
56 <label>Create Date</label>
57 <description>Timestamp of the copy's cataloging</description>
61 datatype="timestamptz"
64 <label>Edit Date</label>
65 <description>Timestamp of the copy's last edit</description>
70 <label>Edit Date</label>
71 <description>Date of the copy's last edit</description>
75 datatype="timestamptz">
76 <label>Edit Date and Hour</label>
77 <description>Date and Hour of the copy's last edit</description>
82 <label>Language</label>
83 <description>MARC Item Language</description>
89 <description>MARC Item Form of Material</description>
95 <description>MARC Item Type</description>
98 name="call_number_label"
99 transform-group="call_number"
100 widget-family="string-input"
102 <label>Call Number</label>
103 <description>Copy Call Number Label</description>
109 field="create_date_day"
110 table="generic_day_series"
115 field="create_date_hour"
116 table="generic_hour_series"
117 id="copy_create_hour"
121 field="edit_date_day"
122 table="generic_day_series"
127 field="edit_date_hour"
128 table="generic_hour_series"
140 table="marc_lang_map"
146 table="marc_form_map"
152 table="marc_type_map"
166 <table id="org_unit" partition="false" fact-table="false">
167 <label>Organizational Units</label>
168 <description>Table containing library hierarchy definition</description>
169 <tablename>actor.org_unit</tablename>
176 widget-family="lib-choose"
179 <label>Unique Library ID</label>
180 <description>Unique Library ID</description>
184 widget-family="string-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>
233 datatype="timestamptz">
235 <description>Date</description>
240 <table id="generic_hour_series" partition="false" fact-table="false">
241 <label>Constant hour series</label>
242 <description>View providing a hour series starting at 1900 and ending at 'now'</description>
243 <tablename>reporter.date_hour_series</tablename>
251 datatype="timestamptz">
252 <label>Date and Hour</label>
253 <description>Date and Hour</description>
258 <table id="marc_form_map" partition="false" fact-table="false">
259 <label>MARC Item Form Codes</label>
260 <description>Table mapping MARC three character codes to Item Form names</description>
261 <tablename>config.item_form_map</tablename>
269 <description>MARC Item Form Code</description>
273 widget-family="string-choose"
275 <label>Item Form Name</label>
276 <description>Name associated with the MARC code</description>
281 <table id="marc_type_map" partition="false" fact-table="false">
282 <label>MARC Item Type Codes</label>
283 <description>Table mapping MARC three character codes to Item Type names</description>
284 <tablename>config.item_type_map</tablename>
292 <description>MARC Item Type Code</description>
296 widget-family="string-choose"
298 <label>Item Type Name</label>
299 <description>Name associated with the MARC code</description>
304 <table id="silly.fact" partition="true" fact-table="false">
305 <label>Silly Fact table</label>
306 <description>Base table for creating reports on silly words</description>
307 <tablename>stats.silly_fact</tablename>
310 <field>said_when</field>
311 <!-- Valid options: years, months, weeks, days, hours, minutes, seconds -->
312 <chunk>months</chunk>
313 <start>2005-09-01</start>
314 <end>2005-12-31</end>
323 <label>Silly entry id</label>
324 <description>Silly entry id</description>
327 name="silly_word_dim"
330 <label>Silly word dim</label>
331 <description>Silly word entry dimension link</description>
334 name="silly_sayer_dim"
337 <label>Silly sayer dim</label>
338 <description>Silly sayer entry dimension link</description>
342 datatype="timestamptz"
346 <label>Silly word timestamp</label>
347 <description>Silly word entry timestamp</description>
352 field="silly_word_dim"
353 table="silly.word_dim"
357 field="silly_sayer_dim"
358 table="silly.sayer_dim"
364 <table id="silly.word_dim">
365 <label>Silly word list</label>
366 <description>Silly word list</description>
367 <tablename>stats.words</tablename>
374 <label>Silly word id</label>
381 <label>Silly word</label>
386 <table id="silly.sayer_dim">
387 <label>Silly word sayer list</label>
388 <description>Silly word sayer list</description>
389 <tablename>stats.silly_sayers</tablename>
396 <label>Silly person id</label>
400 widget-family="string-choose"
404 <label>Silly person</label>