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>
53 datatype="timestamptz"
56 <label>Create Date</label>
57 <description>Timestamp of the copy's cataloging</description>
62 <label>Edit Date Joiner</label>
63 <description>Date of the copy's last edit</description>
67 datatype="timestamptz">
68 <label>Edit Date and Hour Joiner</label>
69 <description>Date and Hour of the copy's last edit</description>
73 datatype="timestamptz"
76 <label>Edit Date</label>
77 <description>Timestamp 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"
128 table="marc_lang_map"
134 table="marc_form_map"
140 table="marc_type_map"
154 <table id="org_unit" partition="false" fact-table="false">
155 <label>Organizational Units</label>
156 <description>Table containing library hierarchy definition</description>
157 <tablename>actor.org_unit</tablename>
166 <description>Library ID</description>
170 widget-family="lib-choose"
173 <description>Library Name</description>
177 widget-family="string-choose"
179 <label>Short Name</label>
180 <description>Library Short (Policy) Name</description>
185 <table id="marc_lang_map" partition="false" fact-table="false">
186 <label>MARC Language Codes</label>
187 <description>Table mapping MARC three character codes to language names</description>
188 <tablename>config.language_map</tablename>
196 <description>MARC Language Code</description>
200 widget-family="string-choose"
202 <label>Language Name</label>
203 <description>Name associated with the MARC code</description>
208 <table id="generic_day_series" partition="false" fact-table="false">
209 <label>Constant day series</label>
210 <description>View providing a day series starting at 1900 and ending at 'now'</description>
211 <tablename>reporter.date_series</tablename>
218 <label>Date joiner</label>
219 <description>Date joiner</description>
225 <description>Date</description>
230 <table id="generic_hour_series" partition="false" fact-table="false">
231 <label>Constant hour series</label>
232 <description>View providing a hour series starting at 1900 and ending at 'now'</description>
233 <tablename>reporter.date_hour_series</tablename>
240 <label>time joiner</label>
241 <description>time joiner</description>
244 name="date_hour_label"
245 datatype="timestamptz">
246 <label>Date and Hour</label>
247 <description>Date and Hour</description>
252 <table id="marc_form_map" partition="false" fact-table="false">
253 <label>MARC Item Form Codes</label>
254 <description>Table mapping MARC three character codes to Item Form names</description>
255 <tablename>config.item_form_map</tablename>
263 <description>MARC Item Form Code</description>
267 widget-family="string-choose"
269 <label>Item Form Name</label>
270 <description>Name associated with the MARC code</description>
275 <table id="marc_type_map" partition="false" fact-table="false">
276 <label>MARC Item Type Codes</label>
277 <description>Table mapping MARC three character codes to Item Type names</description>
278 <tablename>config.item_type_map</tablename>
286 <description>MARC Item Type Code</description>
290 widget-family="string-choose"
292 <label>Item Type Name</label>
293 <description>Name associated with the MARC code</description>
298 <table id="silly.fact" partition="true" fact-table="false">
299 <label>Silly Fact table</label>
300 <description>Base table for creating reports on silly words</description>
301 <tablename>stats.silly_fact</tablename>
304 <field>said_when</field>
305 <!-- Valid options: years, months, weeks, days, hours, minutes, seconds -->
306 <chunk>months</chunk>
307 <start>2005-09-01</start>
308 <end>2005-12-31</end>
317 <label>Silly entry id</label>
318 <description>Silly entry id</description>
321 name="silly_word_dim"
324 <label>Silly word dim</label>
325 <description>Silly word entry dimension link</description>
328 name="silly_sayer_dim"
331 <label>Silly sayer dim</label>
332 <description>Silly sayer entry dimension link</description>
336 datatype="timestamptz"
340 <label>Silly word timestamp</label>
341 <description>Silly word entry timestamp</description>
346 field="silly_word_dim"
347 table="silly.word_dim"
351 field="silly_sayer_dim"
352 table="silly.sayer_dim"
358 <table id="silly.word_dim">
359 <label>Silly word list</label>
360 <description>Silly word list</description>
361 <tablename>stats.words</tablename>
368 <label>Silly word id</label>
375 <label>Silly word</label>
380 <table id="silly.sayer_dim">
381 <label>Silly word sayer list</label>
382 <description>Silly word sayer list</description>
383 <tablename>stats.silly_sayers</tablename>
390 <label>Silly person id</label>
394 widget-family="string-choose"
398 <label>Silly person</label>