Clean up some of my admin docs. add schema.xml to repo.
authorRobert Soulliere <rsoulliere@libdog.mohawkcollege.ca>
Fri, 10 Sep 2010 16:00:25 +0000 (12:00 -0400)
committerRobert Soulliere <rsoulliere@libdog.mohawkcollege.ca>
Fri, 10 Sep 2010 16:00:25 +0000 (12:00 -0400)
Add the docbook conversion script to tools directory.
Add postgresql autodoc xml docbook template (xml.tmpl) to tools directory.

1.6/admin/requirements-configuration.xml
1.6/admin/serveradministration.xml
1.6/admin/z3950.xml
1.6/appendices/schema.xml [new file with mode: 0644]
1.6/intro/releasenotes.xml
1.6/root.xml
tools/docbookConvert.sh [new file with mode: 0755]
tools/xml.tmpl [new file with mode: 0644]

index a9295f0..c1a4fb7 100644 (file)
@@ -44,7 +44,7 @@
                        <para>The key to Evergreen scalability is in the openSRF configuration files <filename>/openils/conf/opensrf.xml</filename> and \r
                        <filename>/openils/conf/opensrf_core.xml</filename>. \r
                        By configuring these files, an administrator could cluster evergreen services over multiple hosts, change the host running a specific service \r
-                       or change the host of the postgreSQL database.</para> \r
+                       or change the host of the PostgreSQL database.</para> \r
 \r
                        <note><para>The default configuration of Evergreen in the installation instructions assumes a single <emphasis>localhost</emphasis> server setup. For more complex \r
                        multi-server clustered configurations, some server administration and database administration experience or knowledge will be required.</para></note>           \r
index 394e35d..454d1b2 100644 (file)
@@ -109,7 +109,8 @@ xmlns:xl="http://www.w3.org/1999/xlink" version="5.0" xml:id="serveradministrati
                        <step><para>Select the <guilabel>Organization Unit Type</guilabel> and \r
                        <guilabel>Parent Organization Unit</guilabel>.</para></step>\r
                        <step><para>Check the <guilabel>Can Have Volumes and Copies</guilabel> check box if the \r
-                       organization units of this type will have volumes and copies assigned to it.<indexterm><primary>organization units</primary><secondary>volumes and copies</secondary></indexterm></para></step>\r
+                       organization units of this type will have volumes and copies assigned to it.<indexterm><primary>organization units</primary><secondary>volumes \r
+                       and copies</secondary></indexterm></para></step>\r
                        <step><para>Check the <guilabel>OPAC Visible</guilabel> check box if you want this location to be \r
                        visible in the OPAC for searching.<indexterm><primary>Organization Units</primary><secondary>opac visible</secondary></indexterm></para></step>\r
                        <step><para>Click <guibutton>Save</guibutton> to save your new organizational unit.</para></step>       \r
@@ -272,278 +273,7 @@ xmlns:xl="http://www.w3.org/1999/xlink" version="5.0" xml:id="serveradministrati
           </simplesect>\r
 \r
        </section>\r
-       <section xml:id="relevancyrankings">\r
-               <title>Adjusting Search Relevancy Rankings</title>\r
-               <info>\r
-                       <abstract>\r
-                               <para>This section describes indexed field weighting and matchpoint weighting, which\r
-                               control relevance ranking in Evergreen catalog search results. Adjusting relevancy can only be completed through access to the Evergreen database as of version 1.6.</para>\r
-                               <tip>\r
-                                       <para>In tuning search relevance, it is good practice to make incremental\r
-                                       adjustments, capture search logs, and assess results before making further\r
-                                       adjustments. </para>\r
-                               </tip>\r
-                       </abstract>\r
-               </info>\r
-               <simplesect>\r
-                       <title>Indexed-field Weighting<indexterm><primary>relevancy</primary><secondary>indexed-field weighting</secondary></indexterm> </title>\r
-                       <para>Indexed-field weighting is configured in the Evergreen database in the weight column\r
-                       of the config.metabib_field table, which follows the other four columns in this table:\r
-                       field_class, name, xpath, and format.</para>\r
-                       <para>The following is one representative line from the config.metabib_field table:</para>\r
-                       <para> author | conference | //mods32:mods/mods32:name[@type='conference']/mods32:namePart[../mods32:role/mods32:roleTerm[text()='creator']] | mods32 | 1 ) </para>\r
-                       <para>The default value for index-field weights in config.metabib_field is 1. Adjust the\r
-                       weighting of indexed fields to boost or lower the relevance score for matches on that\r
-                       indexed field. The weight value may be increased or decreased by whole integers. </para>\r
-                       <para>For example, by increasing the weight of the title-proper field from 1 to 2, a search\r
-                       for <emphasis role="bold">jaguar</emphasis> would double the relevance  for the book titled\r
-                       <emphasis role="italic">Aimee and Jaguar</emphasis> than for a record with the term\r
-                       <emphasis role="bold">jaguar</emphasis> in another indexed field. </para>\r
-               </simplesect>\r
-               <simplesect>\r
-                       <title>Match point Weighting<indexterm><primary>relevancy</primary><secondary>match point weighting</secondary></indexterm></title>\r
-                       <para> Match point weighting provides another way to fine-tune Evergreen relevance ranking,\r
-                       and is configured through floating-point multipliers in the multiplier column of the\r
-                       search.relevance_adjustment table.</para>\r
-                       <para> Weighting can be adjusted for one, more, or all multiplier fields in\r
-                       search.relevance_adjustment.</para>\r
-                       <para>You can adjust the following three matchpoints:</para> \r
-                       <itemizedlist>\r
-                       <listitem>\r
-                               <para>first_wordboosts relevance if the query is \r
-                               one term long and matches the first term in the indexed field (search for <emphasis \r
-                               role="bold">twain</emphasis>, get a bonus for <emphasis role="bold">twain, mark</emphasis> \r
-                               but not <emphasis role="bold">mark twain</emphasis>)</para>\r
-                       </listitem>\r
-                       <listitem>\r
-                               <para>word_order increases relevance for words \r
-                               matching the order of search terms, so that the results for the search <emphasis \r
-                               role="bold">legend suicide</emphasis> would match higher for the book <emphasis \r
-                               role="italic">Legend of a Suicide</emphasis> than for the book, \r
-                               <emphasis role="italic">Suicide Legend</emphasis></para>\r
-                       </listitem>\r
-                       <listitem>\r
-                               <para>full_match boosts relevance when the full \r
-                               query exactly matches the entire indexed field (after space, case, and diacritics are \r
-                               normalized). So a title search for <emphasis role="italic">The Future of Ice</emphasis> \r
-                               would get a relevance boost above <emphasis role="italic">Ice>Ages of the \r
-                               Future</emphasis>.</para>\r
-                       </listitem>\r
-                       </itemizedlist>\r
-                       <para> Here are the default settings of the search.relevance_adjustment table: </para>\r
-                       <table xml:id="search.relevance">\r
-                       <title>search.relevance_adjustment table</title>\r
-                       <tgroup cols="4">\r
-                               <thead>\r
-                                       <row>\r
-                                               <entry>field_class</entry>\r
-                                               <entry>name</entry>\r
-                                               <entry>bump_type</entry>\r
-                                               <entry>multiplier</entry>\r
-                                       </row>\r
-                               </thead>\r
-                               <tbody>\r
-                                       <row>\r
-                                               <entry>author</entry>\r
-                                               <entry>conference</entry>\r
-                                               <entry>first_word</entry>\r
-                                               <entry>1.5</entry>\r
-                                       </row>\r
-                                       <row>\r
-                                               <entry>author</entry>\r
-                                               <entry>corporate</entry>\r
-                                               <entry>first_word</entry>\r
-                                               <entry>1.5</entry>\r
-                                       </row>\r
-                                       <row>\r
-                                               <entry>author </entry>\r
-                                               <entry>other </entry>\r
-                                               <entry>first_word</entry>\r
-                                               <entry>1.5</entry>\r
-                                       </row>\r
-                                       <row>\r
-                                               <entry>author</entry>\r
-                                               <entry>personal</entry>\r
-                                               <entry>first_word</entry>\r
-                                               <entry>1.5</entry>\r
-                                       </row>\r
-                                       <row>\r
-                                               <entry>keyword</entry>\r
-                                               <entry>keyword</entry>\r
-                                               <entry>word_order</entry>\r
-                                               <entry>10</entry>\r
-                                       </row>\r
-                                       <row>\r
-                                               <entry>series</entry>\r
-                                               <entry>seriestitle</entry>\r
-                                               <entry>first_word</entry>\r
-                                               <entry>1.5</entry>\r
-                                       </row>\r
-                                       <row>\r
-                                               <entry>series</entry>\r
-                                               <entry>seriestitle</entry>\r
-                                               <entry>full_match</entry>\r
-                                               <entry>20</entry>\r
-                                       </row>\r
-                                       <row>\r
-                                               <entry>title</entry>\r
-                                               <entry>abbreviated</entry>\r
-                                               <entry>first_word</entry>\r
-                                               <entry>1.5</entry>\r
-                                       </row>\r
-                                       <row>\r
-                                               <entry>title</entry>\r
-                                               <entry>abbreviated</entry>\r
-                                               <entry>full_match</entry>\r
-                                               <entry>20</entry>\r
-                                       </row>\r
-                                       <row>\r
-                                               <entry>title</entry>\r
-                                               <entry>abbreviated</entry>\r
-                                               <entry>word_order</entry>\r
-                                               <entry>10</entry>\r
-                                       </row>\r
-                                       <row>\r
-                                               <entry>title</entry>\r
-                                               <entry>alternative</entry>\r
-                                               <entry>first_word</entry>\r
-                                               <entry>1.5</entry>\r
-                                       </row>\r
-                                       <row>\r
-                                               <entry>title</entry>\r
-                                               <entry>alternative</entry>\r
-                                               <entry>full_match</entry>\r
-                                               <entry>20</entry>\r
-                                       </row>\r
-                                       <row>\r
-                                               <entry>title</entry>\r
-                                               <entry>alternative</entry>\r
-                                               <entry>word_order</entry>\r
-                                               <entry>10</entry>\r
-                                       </row>\r
-                                       <row>\r
-                                               <entry>title</entry>\r
-                                               <entry>proper</entry>\r
-                                               <entry>first_word</entry>\r
-                                               <entry>1.5</entry>\r
-                                       </row>\r
-                                       <row>\r
-                                               <entry>title</entry>\r
-                                               <entry>proper</entry>\r
-                                               <entry>full_match</entry>\r
-                                               <entry>20</entry>\r
-                                       </row>\r
-                                       <row>\r
-                                               <entry>title</entry>\r
-                                               <entry>proper</entry>\r
-                                               <entry>word_order</entry>\r
-                                               <entry>10</entry>\r
-                                       </row>\r
-                                       <row>\r
-                                               <entry>title</entry>\r
-                                               <entry>translated</entry>\r
-                                               <entry>first_word</entry>\r
-                                               <entry>1.5</entry>\r
-                                       </row>\r
-                                       <row>\r
-                                               <entry>title</entry>\r
-                                               <entry>translated</entry>\r
-                                               <entry>full_match</entry>\r
-                                               <entry>20</entry>\r
-                                       </row>\r
-                                       <row>\r
-                                               <entry>title</entry>\r
-                                               <entry>translated</entry>\r
-                                               <entry>word_order</entry>\r
-                                               <entry>10</entry>\r
-                                       </row>\r
-                                       <row>\r
-                                               <entry>title</entry>\r
-                                               <entry>uniform</entry>\r
-                                               <entry>first_word</entry>\r
-                                               <entry>1.5</entry>\r
-                                       </row>\r
-                                       <row>\r
-                                               <entry>title</entry>\r
-                                               <entry>uniform</entry>\r
-                                               <entry>full_match</entry>\r
-                                               <entry>20</entry>\r
-                                       </row>\r
-                                       <row>\r
-                                               <entry>title</entry>\r
-                                               <entry>uniform</entry>\r
-                                               <entry>word_order</entry>\r
-                                               <entry>10</entry>\r
-                                       </row>\r
-                               </tbody>\r
-                       </tgroup>\r
-                       </table>\r
-               </simplesect>\r
-               <simplesect>\r
-                       <title>Combining Index Weighting and Match point Weighting</title>\r
-                       <para>Index weighting and matchpoint weighting may be combined. The relevance boost of the combined \r
-                       weighting is equal to the product of the two multiplied values. </para>\r
-                       <para>If the relevance setting in the config.metabib_field were increased to 2, and the multiplier \r
-                       set to 1.2 in the search.relevance_adjustment table, the resulting matchpoint increase would be \r
-                       240%. </para>\r
-                       <note>\r
-                               <para>In practice, these weights are applied serially -- first the index weight, then all \r
-                               the matchpoint weights that apply -- because they are evaluated at different stages of the \r
-                               search process.</para>\r
-                       </note>\r
-               </simplesect>\r
-               <simplesect>\r
-                       <title>Adjusting Relevancy for Keyword Searches<indexterm><primary>relevancy</primary><secondary>keyword searches</secondary></indexterm></title>\r
-                       <para> Searching the out of the box <emphasis>keyword</emphasis> does not boost the ranking for terms appearing in, the title or subject fields since  there is just one \r
-                       keyword index which does not distinguish terms that appear in the title field from those in the notes field for example. In comparison, the title index is actually composed of \r
-                       a number of separate indexes: title|proper, title|uniform, title|alternative, title|translated, etc, that collectively form the title index. You can see this in the \r
-                       config.metabib_field table. The following procedure will add a keyword|title index so that terms found in the title field of an item are given more weight than terms in \r
-                       other fields. </para>\r
-                       <procedure>\r
-                               <step>\r
-                                       <para>From the command line, access the PostgreSQL command line interface</para>\r
-                                       <screen>psql -U evergreen</screen>\r
-                               </step> \r
-                               <step>\r
-                                       <para>Clone the title|proper index to create a keyword|title index</para>\r
-                                       <para>6 = the title|proper index</para>\r
-                                       <screen>INSERT INTO config.metabib_field \r
-                                       (field_class, name, xpath, weight,</screen>\r
-                                       <screen>format, search_field, facet_field)</screen>\r
-                                       <screen>SELECT 'keyword', 'title', xpath, weight, format,</screen> \r
-                                       <screen>search_field, facet_field</screen>\r
-                                       <screen>FROM config.metabib_field</screen>\r
-                                       <screen>WHERE id = 6;</screen>\r
-                               </step>\r
-                               <step>\r
-                                       <para>Populate the keyword|title index with a set of index entries cloned from the metabib.title_field_entry table;</para>\r
-                                       <para>6 = the title|proper index</para>\r
-                                       <screen>INSERT INTO metabib.keyword_field_entry (source, field, value)</screen>\r
-                                       <screen>SELECT source, 17, value (the field value, 17, field be different \r
-                                       in your database so you may need to check the \r
-                                       <emphasis>config.metabib_field</emphasis> for the id of your new index).</screen>\r
-                                       <screen>FROM metabib.title_field_entry</screen>\r
-                                       <screen>WHERE field = 6;</screen>\r
-                               </step>\r
-                               <step> \r
-                                       <para>Bump the relevance when the first search term appears first in the title in a keyword search.</para>\r
-                                       <para>17 = our new keyword|title index (This may be different in your database so you may need to check the <emphasis>config.metabib_field</emphasis> for the id \r
-                                       of your new index).</para>\r
-                                       <screen>INSERT INTO search.relevance_adjustment \r
-                                       (active, field, bump_type, multiplier)</screen>\r
-                                       <screen>VALUES (true, 17, 'first_word', 5); </screen>\r
-                               </step>\r
-                               <step>\r
-                                       <para>Boost the relevance for search terms appearing in the title in general</para>\r
-                                       <para>17 = our new keyword|title index (This may be different in your database so you may need to check the <emphasis>config.metabib_field</emphasis> for the id \r
-                                       of your new index).</para>\r
-                                       <screen>UPDATE config.metabib_field</screen>\r
-                                       <screen>SET weight = 10</screen>\r
-                                       <screen>WHERE id = 17;</screen>\r
-                               </step>\r
-                       </procedure>  \r
-               </simplesect> \r
-       </section>\r
+       \r
        <section xml:id="permissions">\r
                        <title>User and Group Permissions <indexterm><primary>permissions</primary><secondary>group</secondary></indexterm></title>\r
                        <abstract>\r
@@ -2005,4 +1735,282 @@ xmlns:xl="http://www.w3.org/1999/xlink" version="5.0" xml:id="serveradministrati
                        </step>\r
                </procedure>\r
        </section>\r
+       <section xml:id="relevancyrankings">\r
+               <title>Adjusting Search Relevancy Rankings</title>\r
+               <info>\r
+                       <abstract>\r
+                               <para>This section describes indexed field weighting and matchpoint weighting, which\r
+                               control relevance ranking in Evergreen catalog search results. Adjusting relevancy can only be completed through access to the Evergreen database as of version 1.6.</para>\r
+                               <tip>\r
+                                       <para>In tuning search relevance, it is good practice to make incremental\r
+                                       adjustments, capture search logs, and assess results before making further\r
+                                       adjustments. </para>\r
+                               </tip>\r
+                       </abstract>\r
+               </info>\r
+               <simplesect>\r
+                       <title>Indexed-field Weighting<indexterm><primary>relevancy</primary><secondary>indexed-field weighting</secondary></indexterm> </title>\r
+                       <para>Indexed-field weighting is configured in the Evergreen database in the weight column\r
+                       of the config.metabib_field table, which follows the other four columns in this table:\r
+                       field_class, name, xpath, and format.</para>\r
+                       <para>The following is one representative line from the config.metabib_field table:</para>\r
+                       <para> author | conference | //mods32:mods/mods32:name[@type='conference']/mods32:namePart[../mods32:role/mods32:roleTerm[text()='creator']] | mods32 | 1 ) </para>\r
+                       <para>The default value for index-field weights in config.metabib_field is 1. Adjust the\r
+                       weighting of indexed fields to boost or lower the relevance score for matches on that\r
+                       indexed field. The weight value may be increased or decreased by whole integers. </para>\r
+                       <para>For example, by increasing the weight of the title-proper field from 1 to 2, a search\r
+                       for <emphasis role="bold">jaguar</emphasis> would double the relevance  for the book titled\r
+                       <emphasis role="italic">Aimee and Jaguar</emphasis> than for a record with the term\r
+                       <emphasis role="bold">jaguar</emphasis> in another indexed field. </para>\r
+               </simplesect>\r
+               <simplesect>\r
+                       <title>Match point Weighting<indexterm><primary>relevancy</primary><secondary>match point weighting</secondary></indexterm></title>\r
+                       <para> Match point weighting provides another way to fine-tune Evergreen relevance ranking,\r
+                       and is configured through floating-point multipliers in the multiplier column of the\r
+                       search.relevance_adjustment table.</para>\r
+                       <para> Weighting can be adjusted for one, more, or all multiplier fields in\r
+                       search.relevance_adjustment.</para>\r
+                       <para>You can adjust the following three matchpoints:</para> \r
+                       <itemizedlist>\r
+                       <listitem>\r
+                               <para>first_wordboosts relevance if the query is \r
+                               one term long and matches the first term in the indexed field (search for <emphasis \r
+                               role="bold">twain</emphasis>, get a bonus for <emphasis role="bold">twain, mark</emphasis> \r
+                               but not <emphasis role="bold">mark twain</emphasis>)</para>\r
+                       </listitem>\r
+                       <listitem>\r
+                               <para>word_order increases relevance for words \r
+                               matching the order of search terms, so that the results for the search <emphasis \r
+                               role="bold">legend suicide</emphasis> would match higher for the book <emphasis \r
+                               role="italic">Legend of a Suicide</emphasis> than for the book, \r
+                               <emphasis role="italic">Suicide Legend</emphasis></para>\r
+                       </listitem>\r
+                       <listitem>\r
+                               <para>full_match boosts relevance when the full \r
+                               query exactly matches the entire indexed field (after space, case, and diacritics are \r
+                               normalized). So a title search for <emphasis role="italic">The Future of Ice</emphasis> \r
+                               would get a relevance boost above <emphasis role="italic">Ice>Ages of the \r
+                               Future</emphasis>.</para>\r
+                       </listitem>\r
+                       </itemizedlist>\r
+                       <para> Here are the default settings of the search.relevance_adjustment table: </para>\r
+                       <table xml:id="search.relevance">\r
+                       <title>search.relevance_adjustment table</title>\r
+                       <tgroup cols="4">\r
+                               <thead>\r
+                                       <row>\r
+                                               <entry>field_class</entry>\r
+                                               <entry>name</entry>\r
+                                               <entry>bump_type</entry>\r
+                                               <entry>multiplier</entry>\r
+                                       </row>\r
+                               </thead>\r
+                               <tbody>\r
+                                       <row>\r
+                                               <entry>author</entry>\r
+                                               <entry>conference</entry>\r
+                                               <entry>first_word</entry>\r
+                                               <entry>1.5</entry>\r
+                                       </row>\r
+                                       <row>\r
+                                               <entry>author</entry>\r
+                                               <entry>corporate</entry>\r
+                                               <entry>first_word</entry>\r
+                                               <entry>1.5</entry>\r
+                                       </row>\r
+                                       <row>\r
+                                               <entry>author </entry>\r
+                                               <entry>other </entry>\r
+                                               <entry>first_word</entry>\r
+                                               <entry>1.5</entry>\r
+                                       </row>\r
+                                       <row>\r
+                                               <entry>author</entry>\r
+                                               <entry>personal</entry>\r
+                                               <entry>first_word</entry>\r
+                                               <entry>1.5</entry>\r
+                                       </row>\r
+                                       <row>\r
+                                               <entry>keyword</entry>\r
+                                               <entry>keyword</entry>\r
+                                               <entry>word_order</entry>\r
+                                               <entry>10</entry>\r
+                                       </row>\r
+                                       <row>\r
+                                               <entry>series</entry>\r
+                                               <entry>seriestitle</entry>\r
+                                               <entry>first_word</entry>\r
+                                               <entry>1.5</entry>\r
+                                       </row>\r
+                                       <row>\r
+                                               <entry>series</entry>\r
+                                               <entry>seriestitle</entry>\r
+                                               <entry>full_match</entry>\r
+                                               <entry>20</entry>\r
+                                       </row>\r
+                                       <row>\r
+                                               <entry>title</entry>\r
+                                               <entry>abbreviated</entry>\r
+                                               <entry>first_word</entry>\r
+                                               <entry>1.5</entry>\r
+                                       </row>\r
+                                       <row>\r
+                                               <entry>title</entry>\r
+                                               <entry>abbreviated</entry>\r
+                                               <entry>full_match</entry>\r
+                                               <entry>20</entry>\r
+                                       </row>\r
+                                       <row>\r
+                                               <entry>title</entry>\r
+                                               <entry>abbreviated</entry>\r
+                                               <entry>word_order</entry>\r
+                                               <entry>10</entry>\r
+                                       </row>\r
+                                       <row>\r
+                                               <entry>title</entry>\r
+                                               <entry>alternative</entry>\r
+                                               <entry>first_word</entry>\r
+                                               <entry>1.5</entry>\r
+                                       </row>\r
+                                       <row>\r
+                                               <entry>title</entry>\r
+                                               <entry>alternative</entry>\r
+                                               <entry>full_match</entry>\r
+                                               <entry>20</entry>\r
+                                       </row>\r
+                                       <row>\r
+                                               <entry>title</entry>\r
+                                               <entry>alternative</entry>\r
+                                               <entry>word_order</entry>\r
+                                               <entry>10</entry>\r
+                                       </row>\r
+                                       <row>\r
+                                               <entry>title</entry>\r
+                                               <entry>proper</entry>\r
+                                               <entry>first_word</entry>\r
+                                               <entry>1.5</entry>\r
+                                       </row>\r
+                                       <row>\r
+                                               <entry>title</entry>\r
+                                               <entry>proper</entry>\r
+                                               <entry>full_match</entry>\r
+                                               <entry>20</entry>\r
+                                       </row>\r
+                                       <row>\r
+                                               <entry>title</entry>\r
+                                               <entry>proper</entry>\r
+                                               <entry>word_order</entry>\r
+                                               <entry>10</entry>\r
+                                       </row>\r
+                                       <row>\r
+                                               <entry>title</entry>\r
+                                               <entry>translated</entry>\r
+                                               <entry>first_word</entry>\r
+                                               <entry>1.5</entry>\r
+                                       </row>\r
+                                       <row>\r
+                                               <entry>title</entry>\r
+                                               <entry>translated</entry>\r
+                                               <entry>full_match</entry>\r
+                                               <entry>20</entry>\r
+                                       </row>\r
+                                       <row>\r
+                                               <entry>title</entry>\r
+                                               <entry>translated</entry>\r
+                                               <entry>word_order</entry>\r
+                                               <entry>10</entry>\r
+                                       </row>\r
+                                       <row>\r
+                                               <entry>title</entry>\r
+                                               <entry>uniform</entry>\r
+                                               <entry>first_word</entry>\r
+                                               <entry>1.5</entry>\r
+                                       </row>\r
+                                       <row>\r
+                                               <entry>title</entry>\r
+                                               <entry>uniform</entry>\r
+                                               <entry>full_match</entry>\r
+                                               <entry>20</entry>\r
+                                       </row>\r
+                                       <row>\r
+                                               <entry>title</entry>\r
+                                               <entry>uniform</entry>\r
+                                               <entry>word_order</entry>\r
+                                               <entry>10</entry>\r
+                                       </row>\r
+                               </tbody>\r
+                       </tgroup>\r
+                       </table>\r
+               </simplesect>\r
+               <simplesect>\r
+                       <title>Combining Index Weighting and Match point Weighting</title>\r
+                       <para>Index weighting and matchpoint weighting may be combined. The relevance boost of the combined \r
+                       weighting is equal to the product of the two multiplied values. </para>\r
+                       <para>If the relevance setting in the config.metabib_field were increased to 2, and the multiplier \r
+                       set to 1.2 in the search.relevance_adjustment table, the resulting matchpoint increase would be \r
+                       240%. </para>\r
+                       <note>\r
+                               <para>In practice, these weights are applied serially -- first the index weight, then all \r
+                               the matchpoint weights that apply -- because they are evaluated at different stages of the \r
+                               search process.</para>\r
+                       </note>\r
+               </simplesect>\r
+               <simplesect>\r
+                       <title>Adjusting Relevancy for Keyword Searches<indexterm><primary>relevancy</primary><secondary>keyword searches</secondary></indexterm></title>\r
+                       <para> Searching the out of the box <emphasis>keyword</emphasis> does not boost the ranking for terms appearing in, the title or subject fields since  there is just one \r
+                       keyword index which does not distinguish terms that appear in the title field from those in the notes field for example. In comparison, the title index is actually composed of \r
+                       a number of separate indexes: title|proper, title|uniform, title|alternative, title|translated, etc, that collectively form the title index. You can see this in the \r
+                       config.metabib_field table. The following procedure will add a keyword|title index so that terms found in the title field of an item are given more weight than terms in \r
+                       other fields. </para>\r
+                       <procedure>\r
+                               <step>\r
+                                       <para>From the command line, access the PostgreSQL command line interface</para>\r
+                                       <screen>psql -U evergreen</screen>\r
+                               </step> \r
+                               <step>\r
+                                       <para>Clone the title|proper index to create a keyword|title index</para>\r
+                                       <para>6 = the title|proper index</para>\r
+                                       <programlisting>\r
+                                       INSERT INTO config.metabib_field \r
+                                               (field_class, name, xpath, weight, format, search_field, facet_field)\r
+                                               SELECT 'keyword', 'title', xpath, weight, format, search_field, facet_field\r
+                                               FROM config.metabib_field\r
+                                               WHERE id = 6;\r
+                                       </programlisting>\r
+                               </step>\r
+                               <step>\r
+                                       <para>Populate the keyword|title index with a set of index entries cloned from the metabib.title_field_entry table;</para>\r
+                                       <para>6 = the title|proper index</para>\r
+                                       <programlisting>\r
+                                       INSERT INTO metabib.keyword_field_entry \r
+                                               (source, field, value)\r
+                                               SELECT source, 17, value (the field value, 17, field be different in your database so you may need to check the \r
+                                               <emphasis>config.metabib_field</emphasis> for the id of your new index).\r
+                                               FROM metabib.title_field_entry\r
+                                               WHERE field = 6;\r
+                                       </programlisting>\r
+                               </step>\r
+                               <step> \r
+                                       <para>Bump the relevance when the first search term appears first in the title in a keyword search.</para>\r
+                                       <para>17 = our new keyword|title index (This may be different in your database so you may need to check the <emphasis>config.metabib_field</emphasis> for the id \r
+                                       of your new index).</para>\r
+                                       <programlisting>\r
+                                       INSERT INTO search.relevance_adjustment \r
+                                               (active, field, bump_type, multiplier)\r
+                                       VALUES (true, 17, 'first_word', 5); \r
+                                       </programlisting>\r
+                               </step>\r
+                               <step>\r
+                                       <para>Boost the relevance for search terms appearing in the title in general</para>\r
+                                       <para>17 = our new keyword|title index (This may be different in your database so you may need to check the <emphasis>config.metabib_field</emphasis> for the id \r
+                                       of your new index).</para>\r
+                                       <programlisting>\r
+                                       UPDATE config.metabib_field\r
+                                       SET weight = 10\r
+                                       WHERE id = 17;\r
+                                       </programlisting>\r
+                               </step>\r
+                       </procedure>  \r
+               </simplesect> \r
+       </section>\r
 </chapter>\r
index 79c7705..f2d99dd 100644 (file)
                        hostname:</para>\r
                        <note><para>Some older versions of yaz-client have known issues with SRU. Ensure that you are using the latest edition of yaz from \r
                        <link xlink:href="http://www.indexdata.com/yaz">http://www.indexdata.com/yaz</link>.</para></note>\r
-                       <screen>\r
-                       $ yaz-client http://dev.gapines.org/opac/extras/sru\r
-                       Z> sru GET 1.1\r
-                       Z> find hemingway\r
-                       </screen>\r
+                       <screen>$ yaz-client http://dev.gapines.org/opac/extras/sru</screen>\r
+                       <screen>Z> sru GET 1.1</screen>\r
+                       <screen>Z> find hemingway</screen>\r
+                       \r
                         <para>If your database has records that match that term, you will get the corresponding MARCXML records in your response from yaz-client.</para>\r
                         <para>Here's what the SRU request looks like as sent to the Evergreen web server:</para>\r
                         <screen>GET /opac/extras/sru?version=1.1&amp;operation=searchRetrieve&amp;query=hemingway&amp;maximumRecords=0</screen>\r
                                <step>\r
                                        <para>Create a Simple2ZOOM configuration file. Something like the following is a good start, and is based on the Simple2ZOOM documentation example. \r
                                        We'll name the file dgo.conf for our example:</para>    \r
-                                       <screen>\r
+                                       <programlisting>\r
                                        &lt;client&gt;\r
                                                &lt;database name="gapines"&gt;\r
                                                        &lt;zurl&gt;http://dev.gapines.org/opac/extras/sru&lt;/zurl&gt;\r
                                                        &lt;/search&gt;\r
                                                &lt;/database&gt;\r
                                        &lt;/client&gt;\r
-                                       </screen>\r
+                                       </programlisting>\r
                                        <para>You can have multiple &lt;database&gt; sections in a single file, each pointing to a different scope of your consortium. The name attribute on \r
                                        the &lt;database&gt; element is used in your Z39.50 connection string to name the database. The &lt;zurl&gt; element must point to \r
                                        <emphasis>http://hostname/opac/extras/sru</emphasis>. As of Evergreen 1.6, you can append an optional organization unit shortname for search \r
                                        <para>Run simple2ZOOM as a daemon, specifying the configuration files and one or more listener addresses that the Z39.50 server will be accessible on. \r
                                        If you do not specify a port, it will automatically run on port 9999. In the following example, we tell it to listen both to localhost on port 2210, \r
                                        and on dev.gapines.org on port 210:</para>\r
-                                       <screen>\r
+                                       <programlisting>\r
                                         &lt;yazgfs&gt;\r
                                                &lt;server id="server1"&gt;\r
                                                        &lt;retrievalinfo&gt;\r
                                                        &lt;/retrievalinfo&gt;\r
                                                &lt;/server&gt;\r
                                        &lt;/yazgfs&gt;\r
-                                       </screen>\r
+                                       </programlisting>\r
                                </step>\r
                                <step>\r
                                        <para>Run simple2ZOOM as a daemon, specifying the configuration files and one or more listener addresses that the Z39.50 server will be accessible on. \r
                                        <command>simple2zoom -c dgo.conf -- -f xml2marc-yaz.cfg localhost:2210 dev.gapines.org:210</command>\r
                                </step>                         \r
                        </procedure>\r
-                       <para>To test the Z39.50 server, we can use yaz-client again:</para>]\r
+                       <para>To test the Z39.50 server, we can use yaz-client again:</para>\r
                        <screen>\r
                        yaz-client\r
                        Z&gt; open localhost:2210/gapines\r
diff --git a/1.6/appendices/schema.xml b/1.6/appendices/schema.xml
new file mode 100644 (file)
index 0000000..1496441
--- /dev/null
@@ -0,0 +1,43534 @@
+<?xml version="1.0" encoding="UTF-8" ?>
+<chapter id="databaseschema">
+       <title>Database Schema</title>
+       <para>This is the schema for the Evergreen database.</para>
+       
+       <section id="acq.schema">
+               <title>Schema acq</title>
+               
+               <simplesect id="acq.table.currency-type" xreflabel="acq.currency_type">         
+                       <title>currency_type</title>
+                       <informaltable>
+                               <tgroup cols="3">
+                                       <colspec colnum="1" colname="col1" colwidth="1*"/>
+                                       <colspec colnum="2" colname="col2" colwidth="1*"/>
+                                       <colspec colnum="3" colname="col3" colwidth="2*"/>
+                                       <thead>
+                                               <row>
+                                                       <entry>Field</entry>
+                                                       <entry>Data Type</entry>
+                                                       <entry>Constraints and References</entry>
+                                               </row>
+                                               </thead>
+                                               <tbody>
+                                               
+                                                       <row>
+                                                               <entry>code</entry>
+                                                               <entry>text</entry>
+                                                               <entry><para>
+                                                                       
+                                                                               
+                                                                                       PRIMARY KEY
+                                                                                                               
+                                                                       
+                                                                       
+                                                                       
+                                                                       
+                                                                       
+                                                                               
+                                                                       
+                                                                       </para></entry>
+                                                       </row>
+                                               
+                                                       <row>
+                                                               <entry>label</entry>
+                                                               <entry>text</entry>
+                                                               <entry><para>
+                                                                       
+                                                                       
+                                                                       
+                                                                       
+                                                                       </para></entry>
+                                                       </row>
+                                               
+                                               </tbody>
+                                       </tgroup>
+                               </informaltable>
+                               <para>
+                               
+                               
+                               
+                                       <itemizedlist>
+                                               <title>
+                                                       Tables referencing acq.exchange_rate via Foreign Key Constraints
+                                               </title>
+                               
+                                                       <listitem>
+                                                               <para><xref linkend="acq.table.exchange-rate"/></para>
+                                                       </listitem>
+                                                       
+                               
+                               
+                                                       <listitem>
+                                                               <para><xref linkend="acq.table.fund"/></para>
+                                                       </listitem>
+                                                       
+                               
+                               
+                                                       <listitem>
+                                                               <para><xref linkend="acq.table.fund-debit"/></para>
+                                                       </listitem>
+                                                       
+                               
+                               
+                                                       <listitem>
+                                                               <para><xref linkend="acq.table.funding-source"/></para>
+                                                       </listitem>
+                                                       
+                               
+                               
+                                                       <listitem>
+                                                               <para><xref linkend="acq.table.provider"/></para>
+                                                       </listitem>
+                                                       
+                                       </itemizedlist>
+                               
+                               
+                               
+                               
+               </para>
+               </simplesect>
+               
+               <simplesect id="acq.table.distribution-formula" xreflabel="acq.distribution_formula">           
+                       <title>distribution_formula</title>
+                       <informaltable>
+                               <tgroup cols="3">
+                                       <colspec colnum="1" colname="col1" colwidth="1*"/>
+                                       <colspec colnum="2" colname="col2" colwidth="1*"/>
+                                       <colspec colnum="3" colname="col3" colwidth="2*"/>
+                                       <thead>
+                                               <row>
+                                                       <entry>Field</entry>
+                                                       <entry>Data Type</entry>
+                                                       <entry>Constraints and References</entry>
+                                               </row>
+                                               </thead>
+                                               <tbody>
+                                               
+                                                       <row>
+                                                               <entry>id</entry>
+                                                               <entry>serial</entry>
+                                                               <entry><para>
+                                                                       
+                                                                               
+                                                                                       PRIMARY KEY
+                                                                                                               
+                                                                       
+                                                                       
+                                                                       
+                                                                       
+                                                                       
+                                                                               
+                                                                       
+                                                                       </para></entry>
+                                                       </row>
+                                               
+                                                       <row>
+                                                               <entry>owner</entry>
+                                                               <entry>integer</entry>
+                                                               <entry><para>
+                                                                       
+                                                                                                               
+                                                                       
+                                                                               UNIQUE#1
+                                                                               ;
+                                                                               
+                                                                       
+                                                                                                               
+                                                                       
+                                                                       
+                                                                       
+                                                                               NOT NULL;
+                                                                       
+                                                                       
+                                                                       
+                                                                               
+                                                                       
+                                                                               
+                                                                               <xref linkend="actor.table.org-unit"/>
+                                                                               
+                                                                       
+                                                                       </para></entry>
+                                                       </row>
+                                               
+                                                       <row>
+                                                               <entry>name</entry>
+                                                               <entry>text</entry>
+                                                               <entry><para>
+                                                                       
+                                                                                                               
+                                                                       
+                                                                               UNIQUE#1
+                                                                               ;
+                                                                               
+                                                                       
+                                                                       
+                                                                               NOT NULL;
+                                                                       
+                                                                       
+                                                                       
+                                                                               
+                                                                       
+                                                                       </para></entry>
+                                                       </row>
+                                               
+                                                       <row>
+                                                               <entry>skip_count</entry>
+                                                               <entry>integer</entry>
+                                                               <entry><para>
+                                                                       
+                                                                       
+                                                                               NOT NULL;
+                                                                       
+                                                                       
+                                                                       
+                                                                       </para></entry>
+                                                       </row>
+                                               
+                                               </tbody>
+                                       </tgroup>
+                               </informaltable>
+                               <para>
+                               
+                               
+                               
+                                       <itemizedlist>
+                                               <title>
+                                                       Tables referencing acq.distribution_formula_entry via Foreign Key Constraints
+                                               </title>
+                               
+                                                       <listitem>
+                                                               <para><xref linkend="acq.table.distribution-formula-entry"/></para>
+                                                       </listitem>
+                                                       
+                                       </itemizedlist>
+                               
+                               
+                               
+                               
+               </para>
+               </simplesect>
+               
+               <simplesect id="acq.table.distribution-formula-entry" xreflabel="acq.distribution_formula_entry">               
+                       <title>distribution_formula_entry</title>
+                       <informaltable>
+                               <tgroup cols="3">
+                                       <colspec colnum="1" colname="col1" colwidth="1*"/>
+                                       <colspec colnum="2" colname="col2" colwidth="1*"/>
+                                       <colspec colnum="3" colname="col3" colwidth="2*"/>
+                                       <thead>
+                                               <row>
+                                                       <entry>Field</entry>
+                                                       <entry>Data Type</entry>
+                                                       <entry>Constraints and References</entry>
+                                               </row>
+                                               </thead>
+                                               <tbody>
+                                               
+                                                       <row>
+                                                               <entry>id</entry>
+                                                               <entry>serial</entry>
+                                                               <entry><para>
+                                                                       
+                                                                               
+                                                                                       PRIMARY KEY
+                                                                                                               
+                                                                       
+                                                                       
+                                                                       
+                                                                       
+                                                                       
+                                                                               
+                                                                       
+                                                                       </para></entry>
+                                                       </row>
+                                               
+                                                       <row>
+                                                               <entry>formula</entry>
+                                                               <entry>integer</entry>
+                                                               <entry><para>
+                                                                       
+                                                                                                               
+                                                                       
+                                                                               UNIQUE#1
+                                                                               ;
+                                                                               
+                                                                       
+                                                                                                               
+                                                                       
+                                                                       
+                                                                       
+                                                                               NOT NULL;
+                                                                       
+                                                                       
+                                                                       
+                                                                               
+                                                                       
+                                                                               
+                                                                               <xref linkend="acq.table.distribution-formula"/>
+                                                                               
+                                                                       
+                                                                       </para></entry>
+                                                       </row>
+                                               
+                                                       <row>
+                                                               <entry>position</entry>
+                                                               <entry>integer</entry>
+                                                               <entry><para>
+                                                                       
+                                                                                                               
+                                                                       
+                                                                               UNIQUE#1
+                                                                               ;
+                                                                               
+                                                                       
+                                                                       
+                                                                               NOT NULL;
+                                                                       
+                                                                       
+                                                                       
+                                                                               
+                                                                       
+                                                                       </para></entry>
+                                                       </row>
+                                               
+                                                       <row>
+                                                               <entry>item_count</entry>
+                                                               <entry>integer</entry>
+                                                               <entry><para>
+                                                                       
+                                                                       
+                                                                               NOT NULL;
+                                                                       
+                                                                       
+                                                                       
+                                                                       </para></entry>
+                                                       </row>
+                                               
+                                                       <row>
+                                                               <entry>owning_lib</entry>
+                                                               <entry>integer</entry>
+                                                               <entry><para>
+                                                                       
+                                                                                                               
+                                                                       
+                                                                       
+                                                                       
+                                                                       
+                                                                       
+                                                                               
+                                                                               <xref linkend="actor.table.org-unit"/>
+                                                                               
+                                                                       
+                                                                       </para></entry>
+                                                       </row>
+                                               
+                                                       <row>
+                                                               <entry>location</entry>
+                                                               <entry>integer</entry>
+                                                               <entry><para>
+                                                                       
+                                                                                                               
+                                                                       
+                                                                       
+                                                                       
+                                                                       
+                                                                       
+                                                                               
+                                                                               <xref linkend="asset.table.copy-location"/>
+                                                                               
+                                                                       
+                                                                       </para></entry>
+                                                       </row>
+                                               
+                                               </tbody>
+                                       </tgroup>
+                               </informaltable>
+                               <para>
+                               
+                               
+                                       <variablelist>
+                                               <title>Constraints on distribution_formula_entry</title>
+                                               
+                                               <varlistentry>
+                                                       <term>acqdfe_must_be_somewhere</term>
+                                                       <listitem><para>CHECK (((owning_lib IS NOT NULL) OR (location IS NOT NULL)))</para></listitem>
+                                               </varlistentry>
+                                               
+                                       </variablelist>
+                               
+                               
+                               
+                               
+                               
+               </para>
+               </simplesect>
+               
+               <simplesect id="acq.table.exchange-rate" xreflabel="acq.exchange_rate">         
+                       <title>exchange_rate</title>
+                       <informaltable>
+                               <tgroup cols="3">
+                                       <colspec colnum="1" colname="col1" colwidth="1*"/>
+                                       <colspec colnum="2" colname="col2" colwidth="1*"/>
+                                       <colspec colnum="3" colname="col3" colwidth="2*"/>
+                                       <thead>
+                                               <row>
+                                                       <entry>Field</entry>
+                                                       <entry>Data Type</entry>
+                                                       <entry>Constraints and References</entry>
+                                               </row>
+                                               </thead>
+                                               <tbody>
+                                               
+                                                       <row>
+                                                               <entry>id</entry>
+                                                               <entry>serial</entry>
+                                                               <entry><para>
+                                                                       
+                                                                               
+                                                                                       PRIMARY KEY
+                                                                                                               
+                                                                       
+                                                                       
+                                                                       
+                                                                       
+                                                                       
+                                                                               
+                                                                       
+                                                                       </para></entry>
+                                                       </row>
+                                               
+                                                       <row>
+                                                               <entry>from_currency</entry>
+                                                               <entry>text</entry>
+                                                               <entry><para>
+                                                                       
+                                                                                                               
+                                                                       
+                                                                       
+                                                                                                               
+                                                                       
+                                                                               UNIQUE#1
+                                                                               ;
+                                                                               
+                                                                       
+                                                                       
+                                                                               NOT NULL;
+                                                                       
+                                                                       
+                                                                       
+                                                                               
+                                                                               <xref linkend="acq.table.currency-type"/>
+                                                                               
+                                                                       
+                                                                               
+                                                                       
+                                                                       </para></entry>
+                                                       </row>
+                                               
+                                                       <row>
+                                                               <entry>to_currency</entry>
+                                                               <entry>text</entry>
+                                                               <entry><para>
+                                                                       
+                                                                                                               
+                                                                       
+                                                                               UNIQUE#1
+                                                                               ;
+                                                                               
+                                                                       
+                                                                                                               
+                                                                       
+                                                                       
+                                                                       
+                                                                               NOT NULL;
+                                                                       
+                                                                       
+                                                                       
+                                                                               
+                                                                       
+                                                                               
+                                                                               <xref linkend="acq.table.currency-type"/>
+                                                                               
+                                                                       
+                                                                       </para></entry>
+                                                       </row>
+                                               
+                                                       <row>
+                                                               <entry>ratio</entry>
+                                                               <entry>numeric</entry>
+                                                               <entry><para>
+                                                                       
+                                                                       
+                                                                               NOT NULL;
+                                                                       
+                                                                       
+                                                                       
+                                                                       </para></entry>
+                                                       </row>
+                                               
+                                               </tbody>
+                                       </tgroup>
+                               </informaltable>
+                               <para>
+                               
+                               
+                               
+                               
+               </para>
+               </simplesect>
+               
+               <simplesect id="acq.table.fiscal-calendar" xreflabel="acq.fiscal_calendar">             
+                       <title>fiscal_calendar</title>
+                       <informaltable>
+                               <tgroup cols="3">
+                                       <colspec colnum="1" colname="col1" colwidth="1*"/>
+                                       <colspec colnum="2" colname="col2" colwidth="1*"/>
+                                       <colspec colnum="3" colname="col3" colwidth="2*"/>
+                                       <thead>
+                                               <row>
+                                                       <entry>Field</entry>
+                                                       <entry>Data Type</entry>
+                                                       <entry>Constraints and References</entry>
+                                               </row>
+                                               </thead>
+                                               <tbody>
+                                               
+                                                       <row>
+                                                               <entry>id</entry>
+                                                               <entry>serial</entry>
+                                                               <entry><para>
+                                                                       
+                                                                               
+                                                                                       PRIMARY KEY
+                                                                                                               
+                                                                       
+                                                                       
+                                                                       
+                                                                       
+                                                                       
+                                                                               
+                                                                       
+                                                                       </para></entry>
+                                                       </row>
+                                               
+                                                       <row>
+                                                               <entry>name</entry>
+                                                               <entry>text</entry>
+                                                               <entry><para>
+                                                                       
+                                                                       
+                                                                               NOT NULL;
+                                                                       
+                                                                       
+                                                                       
+                                                                       </para></entry>
+                                                       </row>
+                                               
+                                               </tbody>
+                                       </tgroup>
+                               </informaltable>
+                               <para>
+                               
+                               
+                               
+                                       <itemizedlist>
+                                               <title>
+                                                       Tables referencing acq.fiscal_year via Foreign Key Constraints
+                                               </title>
+                               
+                                                       <listitem>
+                                                               <para><xref linkend="acq.table.fiscal-year"/></para>
+                                                       </listitem>
+                                                       
+                                       </itemizedlist>
+                               
+                               
+                               
+                               
+               </para>
+               </simplesect>
+               
+               <simplesect id="acq.table.fiscal-year" xreflabel="acq.fiscal_year">             
+                       <title>fiscal_year</title>
+                       <informaltable>
+                               <tgroup cols="3">
+                                       <colspec colnum="1" colname="col1" colwidth="1*"/>
+                                       <colspec colnum="2" colname="col2" colwidth="1*"/>
+                                       <colspec colnum="3" colname="col3" colwidth="2*"/>
+                                       <thead>
+                                               <row>
+                                                       <entry>Field</entry>
+                                                       <entry>Data Type</entry>
+                                                       <entry>Constraints and References</entry>
+                                               </row>
+                                               </thead>
+                                               <tbody>
+                                               
+                                                       <row>
+                                                               <entry>id</entry>
+                                                               <entry>serial</entry>
+                                                               <entry><para>
+                                                                       
+                                                                               
+                                                                                       PRIMARY KEY
+                                                                                                               
+                                                                       
+                                                                       
+                                                                       
+                                                                       
+                                                                       
+                                                                               
+                                                                       
+                                                                       </para></entry>
+                                                       </row>
+                                               
+                                                       <row>
+                                                               <entry>calendar</entry>
+                                                               <entry>integer</entry>
+                                                               <entry><para>
+                                                                       
+                                                                                                               
+                                                                       
+                                                                               UNIQUE#1
+                                                                               ;
+                                                                               
+                                                                       
+                                                                                                               
+                                                                       
+                                                                               UNIQUE#2
+                                                                               ;
+                                                                               
+                                                                       
+                                                                                                               
+                                                                       
+                                                                       
+                                                                       
+                                                                               NOT NULL;
+                                                                       
+                                                                       
+                                                                       
+                                                                               
+                                                                       
+                                                                               
+                                                                       
+                                                                               
+                                                                               <xref linkend="acq.table.fiscal-calendar"/>
+                                                                               
+                                                                       
+                                                                       </para></entry>
+                                                       </row>
+                                               
+                                                       <row>
+                                                               <entry>year</entry>
+                                                               <entry>integer</entry>
+                                                               <entry><para>
+                                                                       
+                                                                                                               
+                                                                       
+                                                                               UNIQUE#1
+                                                                               ;
+                                                                               
+                                                                       
+                                                                       
+                                                                               NOT NULL;
+                                                                       
+                                                                       
+                                                                       
+                                                                               
+                                                                       
+                                                                       </para></entry>
+                                                       </row>
+                                               
+                                                       <row>
+                                                               <entry>year_begin</entry>
+                                                               <entry>timestamp with time zone</entry>
+                                                               <entry><para>
+                                                                       
+                                                                                                               
+                                                                       
+                                                                               UNIQUE#2
+                                                                               ;
+                                                                               
+                                                                       
+                                                                       
+                                                                               NOT NULL;
+                                                                       
+                                                                       
+                                                                       
+                                                                               
+                                                                       
+                                                                       </para></entry>
+                                                       </row>
+                                               
+                                                       <row>
+                                                               <entry>year_end</entry>
+                                                               <entry>timestamp with time zone</entry>
+                                                               <entry><para>
+                                                                       
+                                                                       
+                                                                               NOT NULL;
+                                                                       
+                                                                       
+                                                                       
+                                                                       </para></entry>
+                                                       </row>
+                                               
+                                               </tbody>
+                                       </tgroup>
+                               </informaltable>
+                               <para>
+                               
+                               
+                               
+                               
+               </para>
+               </simplesect>
+               
+               <simplesect id="acq.table.fund" xreflabel="acq.fund">           
+                       <title>fund</title>
+                       <informaltable>
+                               <tgroup cols="3">
+                                       <colspec colnum="1" colname="col1" colwidth="1*"/>
+                                       <colspec colnum="2" colname="col2" colwidth="1*"/>
+                                       <colspec colnum="3" colname="col3" colwidth="2*"/>
+                                       <thead>
+                                               <row>
+                                                       <entry>Field</entry>
+                                                       <entry>Data Type</entry>
+                                                       <entry>Constraints and References</entry>
+                                               </row>
+                                               </thead>
+                                               <tbody>
+                                               
+                                                       <row>
+                                                               <entry>id</entry>
+                                                               <entry>serial</entry>
+                                                               <entry><para>
+                                                                       
+                                                                               
+                                                                                       PRIMARY KEY
+                                                                                                               
+                                                                       
+                                                                       
+                                                                       
+                                                                       
+                                                                       
+                                                                               
+                                                                       
+                                                                       </para></entry>
+                                                       </row>
+                                               
+                                                       <row>
+                                                               <entry>org</entry>
+                                                               <entry>integer</entry>
+                                                               <entry><para>
+                                                                       
+                                                                                                               
+                                                                       
+                                                                               UNIQUE#2
+                                                                               ;
+                                                                               
+                                                                       
+                                                                                                               
+                                                                       
+                                                                       
+                                                                                                               
+                                                                       
+                                                                               UNIQUE#1
+                                                                               ;
+                                                                               
+                                                                       
+                                                                       
+                                                                               NOT NULL;
+                                                                       
+                                                                       
+                                                                       
+                                                                               
+                                                                       
+                                                                               
+                                                                               <xref linkend="actor.table.org-unit"/>
+                                                                               
+                                                                       
+                                                                               
+                                                                       
+                                                                       </para></entry>
+                                                       </row>
+                                               
+                                                       <row>
+                                                               <entry>name</entry>
+                                                               <entry>text</entry>
+                                                               <entry><para>
+                                                                       
+                                                                                                               
+                                                                       
+                                                                               UNIQUE#1
+                                                                               ;
+                                                                               
+                                                                       
+                                                                       
+                                                                               NOT NULL;
+                                                                       
+                                                                       
+                                                                       
+                                                                               
+                                                                       
+                                                                       </para></entry>
+                                                       </row>
+                                               
+                                                       <row>
+                                                               <entry>year</entry>
+                                                               <entry>integer</entry>
+                                                               <entry><para>
+                                                                       
+                                                                                                               
+                                                                       
+                                                                               UNIQUE#2
+                                                                               ;
+                                                                               
+                                                                       
+                                                                                                               
+                                                                       
+                                                                               UNIQUE#1
+                                                                               ;
+                                                                               
+                                                                       
+                                                                       
+                                                                               NOT NULL;
+                                                                       
+                                                                       
+                                                                               DEFAULT date_part(&apos;year&apos;::text, now());
+                                                                       
+                                                                       
+                                                                               
+                                                                       
+                                                                               
+                                                                       
+                                                                       </para></entry>
+                                                       </row>
+                                               
+                                                       <row>
+                                                               <entry>currency_type</entry>
+                                                               <entry>text</entry>
+                                                               <entry><para>
+                                                                       
+                                                                                                               
+                                                                       
+                                                                       
+                                                                       
+                                                                               NOT NULL;
+                                                                       
+                                                                       
+                                                                       
+                                                                               
+                                                                               <xref linkend="acq.table.currency-type"/>
+                                                                               
+                                                                       
+                                                                       </para></entry>
+                                                       </row>
+                                               
+                                                       <row>
+                                                               <entry>code</entry>
+                                                               <entry>text</entry>
+                                                               <entry><para>
+                                                                       
+                                                                                                               
+                                                                       
+                                                                               UNIQUE#2
+                                                                               ;
+                                                                               
+                                                                       
+                                                                       
+                                                                       
+                                                                       
+                                                                               
+                                                                       
+                                                                       </para></entry>
+                                                       </row>
+                                               
+                                               </tbody>
+                                       </tgroup>
+                               </informaltable>
+                               <para>
+                               
+                               
+                               
+                                       <itemizedlist>
+                                               <title>
+                                                       Tables referencing acq.fund_allocation via Foreign Key Constraints
+                                               </title>
+                               
+                                                       <listitem>
+                                                               <para><xref linkend="acq.table.fund-allocation"/></para>
+                                                       </listitem>
+                                                       
+                               
+                               
+                                                       <listitem>
+                                                               <para><xref linkend="acq.table.fund-debit"/></para>
+                                                       </listitem>
+                                                       
+                               
+                               
+                                                       <listitem>
+                                                               <para><xref linkend="acq.table.fund-tag-map"/></para>
+                                                       </listitem>
+                                                       
+                               
+                               
+                                                       <listitem>
+                                                               <para><xref linkend="acq.table.lineitem-detail"/></para>
+                                                       </listitem>
+                                                       
+                                       </itemizedlist>
+                               
+                               
+                               
+                               
+               </para>
+               </simplesect>
+               
+               <simplesect id="acq.table.fund-allocation" xreflabel="acq.fund_allocation">             
+                       <title>fund_allocation</title>
+                       <informaltable>
+                               <tgroup cols="3">
+                                       <colspec colnum="1" colname="col1" colwidth="1*"/>
+                                       <colspec colnum="2" colname="col2" colwidth="1*"/>
+                                       <colspec colnum="3" colname="col3" colwidth="2*"/>
+                                       <thead>
+                                               <row>
+                                                       <entry>Field</entry>
+                                                       <entry>Data Type</entry>
+                                                       <entry>Constraints and References</entry>
+                                               </row>
+                                               </thead>
+                                               <tbody>
+                                               
+                                                       <row>
+                                                               <entry>id</entry>
+                                                               <entry>serial</entry>
+                                                               <entry><para>
+                                                                       
+                                                                               
+                                                                                       PRIMARY KEY
+                                                                                                               
+                                                                       
+                                                                       
+                                                                       
+                                                                       
+                                                                       
+                                                                               
+                                                                       
+                                                                       </para></entry>
+                                                       </row>
+                                               
+                                                       <row>
+                                                               <entry>funding_source</entry>
+                                                               <entry>integer</entry>
+                                                               <entry><para>
+                                                                       
+                                                                                                               
+                                                                       
+                                                                       
+                                                                       
+                                                                               NOT NULL;
+                                                                       
+                                                                       
+                                                                       
+                                                                               
+                                                                               <xref linkend="acq.table.funding-source"/>
+                                                                               
+                                                                       
+                                                                       </para></entry>
+                                                       </row>
+                                               
+                                                       <row>
+                                                               <entry>fund</entry>
+                                                               <entry>integer</entry>
+                                                               <entry><para>
+                                                                       
+                                                                                                               
+                                                                       
+                                                                       
+                                                                       
+                                                                               NOT NULL;
+                                                                       
+                                                                       
+                                                                       
+                                                                               
+                                                                               <xref linkend="acq.table.fund"/>
+                                                                               
+                                                                       
+                                                                       </para></entry>
+                                                       </row>
+                                               
+                                                       <row>
+                                                               <entry>amount</entry>
+                                                               <entry>numeric</entry>
+                                                               <entry><para>
+                                                                       
+                                                                       
+                                                                       
+                                                                       
+                                                                       </para></entry>
+                                                       </row>
+                                               
+                                                       <row>
+                                                               <entry>percent</entry>
+                                                               <entry>numeric</entry>
+                                                               <entry><para>
+                                                                       
+                                                                       
+                                                                       
+                                                                       
+                                                                       </para></entry>
+                                                       </row>
+                                               
+                                                       <row>
+                                                               <entry>allocator</entry>
+                                                               <entry>integer</entry>
+                                                               <entry><para>
+                                                                       
+                                                                                                               
+                                                                       
+                                                                       
+                                                                       
+                                                                               NOT NULL;
+                                                                       
+                                                                       
+                                                                       
+                                                                               
+                                                                               <xref linkend="actor.table.usr"/>
+                                                                               
+                                                                       
+                                                                       </para></entry>
+                                                       </row>
+                                               
+                                                       <row>
+                                                               <entry>note</entry>
+                                                               <entry>text</entry>
+                                                               <entry><para>
+                                                                       
+                                                                       
+                                                                       
+                                                                       
+                                                                       </para></entry>
+                                                       </row>
+                                               
+                                                       <row>
+                                                               <entry>create_time</entry>
+                                                               <entry>timestamp with time zone</entry>
+                                                               <entry><para>
+                                                                       
+                                                                       
+                                                                               NOT NULL;
+                                                                       
+                                                                       
+                                                                               DEFAULT now();
+                                                                       
+                                                                       
+                                                                       </para></entry>
+                                                       </row>
+                                               
+                                               </tbody>
+                                       </tgroup>
+                               </informaltable>
+                               <para>
+                               
+                               
+                                       <variablelist>
+                                               <title>Constraints on fund_allocation</title>
+                                               
+                                               <varlistentry>
+                                                       <term>allocation_amount_or_percent</term>
+                                                       <listitem><para>CHECK ((((percent IS NULL) AND (amount IS NOT NULL)) OR ((percent IS NOT NULL) AND (amount IS NULL))))</para></listitem>
+                                               </varlistentry>
+                                               
+                               
+                               
+                                               <varlistentry>
+                                                       <term>fund_allocation_percent_check</term>
+                                                       <listitem><para>CHECK (((percent IS NULL) OR ((percent &gt;= 0.0) AND (percent &lt;= 100.0))))</para></listitem>
+                                               </varlistentry>
+                                               
+                                       </variablelist>
+                               
+                               
+                               
+                               
+                               
+               </para>
+               </simplesect>
+               
+               <simplesect id="acq.view.fund-allocation-total" xreflabel="acq.fund_allocation_total">          
+                       <title>fund_allocation_total</title>
+                       <informaltable>
+                               <tgroup cols="3">
+                                       <colspec colnum="1" colname="col1" colwidth="1*"/>
+                                       <colspec colnum="2" colname="col2" colwidth="1*"/>
+                                       <colspec colnum="3" colname="col3" colwidth="2*"/>
+                                       <thead>
+                                               <row>
+                                                       <entry>Field</entry>
+                                                       <entry>Data Type</entry>
+                                                       <entry>Constraints and References</entry>
+                                               </row>
+                                               </thead>
+                                               <tbody>
+                                               
+                                                       <row>
+                                                               <entry>fund</entry>
+                                                               <entry>integer</entry>
+                                                               <entry><para>
+                                                                       
+                                                                       
+                                                                       
+                                                                       
+                                                                       </para></entry>
+                                                       </row>
+                                               
+                                                       <row>
+                                                               <entry>amount</entry>
+                                                               <entry>numeric(100,2)</entry>
+                                                               <entry><para>
+                                                                       
+                                                                       
+                                                                       
+                                                                       
+                                                                       </para></entry>
+                                                       </row>
+                                               
+                                               </tbody>
+                                       </tgroup>
+                               </informaltable>
+                               <para>
+                               
+                               
+                               
+                               
+               </para>
+               </simplesect>
+               
+               <simplesect id="acq.view.fund-combined-balance" xreflabel="acq.fund_combined_balance">          
+                       <title>fund_combined_balance</title>
+                       <informaltable>
+                               <tgroup cols="3">
+                                       <colspec colnum="1" colname="col1" colwidth="1*"/>
+                                       <colspec colnum="2" colname="col2" colwidth="1*"/>
+                                       <colspec colnum="3" colname="col3" colwidth="2*"/>
+                                       <thead>
+                                               <row>
+                                                       <entry>Field</entry>
+                                                       <entry>Data Type</entry>
+                                                       <entry>Constraints and References</entry>
+                                               </row>
+                                               </thead>
+                                               <tbody>
+                                               
+                                                       <row>
+                                                               <entry>fund</entry>
+                                                               <entry>integer</entry>
+                                                               <entry><para>
+                                                                       
+                                                                       
+                                                                       
+                                                                       
+                                                                       </para></entry>
+                                                       </row>
+                                               
+                                                       <row>
+                                                               <entry>amount</entry>
+                                                               <entry>numeric</entry>
+                                                               <entry><para>
+                                                                       
+                                                                       
+                                                                       
+                                                                       
+                                                                       </para></entry>
+                                                       </row>
+                                               
+                                               </tbody>
+                                       </tgroup>
+                               </informaltable>
+                               <para>
+                               
+                               
+                               
+                               
+               </para>
+               </simplesect>
+               
+               <simplesect id="acq.table.fund-debit" xreflabel="acq.fund_debit">               
+                       <title>fund_debit</title>
+                       <informaltable>
+                               <tgroup cols="3">
+                                       <colspec colnum="1" colname="col1" colwidth="1*"/>
+                                       <colspec colnum="2" colname="col2" colwidth="1*"/>
+                                       <colspec colnum="3" colname="col3" colwidth="2*"/>
+                                       <thead>
+                                               <row>
+                                                       <entry>Field</entry>
+                                                       <entry>Data Type</entry>
+                                                       <entry>Constraints and References</entry>
+                                               </row>
+                                               </thead>
+                                               <tbody>
+                                               
+                                                       <row>
+                                                               <entry>id</entry>
+                                                               <entry>serial</entry>
+                                                               <entry><para>
+                                                                       
+                                                                               
+                                                                                       PRIMARY KEY
+                                                                                                               
+                                                                       
+                                                                       
+                                                                       
+                                                                       
+                                                                       
+                                                                               
+                                                                       
+                                                                       </para></entry>
+                                                       </row>
+                                               
+                                                       <row>
+                                                               <entry>fund</entry>
+                                                               <entry>integer</entry>
+                                                               <entry><para>
+                                                                       
+                                                                                                               
+                                                                       
+                                                                       
+                                                                       
+                                                                               NOT NULL;
+                                                                       
+                                                                       
+                                                                       
+                                                                               
+                                                                               <xref linkend="acq.table.fund"/>
+                                                                               
+                                                                       
+                                                                       </para></entry>
+                                                       </row>
+                                               
+                                                       <row>
+                                                               <entry>origin_amount</entry>
+                                                               <entry>numeric</entry>
+                                                               <entry><para>
+                                                                       
+                                                                       
+                                                                               NOT NULL;
+                                                                       
+                                                                       
+                                                                       
+                                                                       </para></entry>
+                                                       </row>
+                                               
+                                                       <row>
+                                                               <entry>origin_currency_type</entry>
+                                                               <entry>text</entry>
+                                                               <entry><para>
+                                                                       
+                                                                                                               
+                                                                       
+                                                                       
+                                                                       
+                                                                               NOT NULL;
+                                                                       
+                                                                       
+                                                                       
+                                                                               
+                                                                               <xref linkend="acq.table.currency-type"/>
+                                                                               
+                                                                       
+                                                                       </para></entry>
+                                                       </row>
+                                               
+                                                       <row>
+                                                               <entry>amount</entry>
+                                                               <entry>numeric</entry>
+                                                               <entry><para>
+                                                                       
+                                                                       
+                                                                               NOT NULL;
+                                                                       
+                                                                       
+                                                                       
+                                                                       </para></entry>
+                                                       </row>
+                                               
+                                                       <row>
+                                                               <entry>encumbrance</entry>
+                                                               <entry>boolean</entry>
+                                                               <entry><para>
+                                                                       
+                                                                       
+                                                                               NOT NULL;
+                                                                       
+                                                                       
+                                                                               DEFAULT true;
+                                                                       
+                                                                       
+                                                                       </para></entry>
+                                                       </row>
+                                               
+                                                       <row>
+                                                               <entry>debit_type</entry>
+                                                               <entry>text</entry>
+                                                               <entry><para>
+                                                                       
+                                                                       
+                                                                               NOT NULL;
+                                                                       
+                                                                       
+                                                                       
+                                                                       </para></entry>
+                                                       </row>
+                                               
+                                                       <row>
+                                                               <entry>xfer_destination</entry>
+                                                               <entry>integer</entry>
+                                                               <entry><para>
+                                                                       
+                                                                                                               
+                                                                       
+                                                                       
+                                                                       
+                                                                       
+                                                                       
+                                                                               
+                                                                               <xref linkend="acq.table.fund"/>
+                                                                               
+                                                                       
+                                                                       </para></entry>
+                                                       </row>
+                                               
+                                                       <row>
+                                                               <entry>create_time</entry>
+                                                               <entry>timestamp with time zone</entry>
+                                                               <entry><para>
+                                                                       
+                                                                       
+                                                                               NOT NULL;
+                                                                       
+                                                                       
+                                                                               DEFAULT now();
+                                                                       
+                                                                       
+                                                                       </para></entry>
+                                                       </row>
+                                               
+                                               </tbody>
+                                       </tgroup>
+                               </informaltable>
+                               <para>
+                               
+                               
+                               
+                                       <itemizedlist>
+                                               <title>
+                                                       Tables referencing acq.lineitem_detail via Foreign Key Constraints
+                                               </title>
+                               
+                                                       <listitem>
+                                                               <para><xref linkend="acq.table.lineitem-detail"/></para>
+                                                       </listitem>
+                                                       
+                                       </itemizedlist>
+                               
+                               
+                               
+                               
+               </para>
+               </simplesect>
+               
+               <simplesect id="acq.view.fund-debit-total" xreflabel="acq.fund_debit_total">            
+                       <title>fund_debit_total</title>
+                       <informaltable>
+                               <tgroup cols="3">
+                                       <colspec colnum="1" colname="col1" colwidth="1*"/>
+                                       <colspec colnum="2" colname="col2" colwidth="1*"/>
+                                       <colspec colnum="3" colname="col3" colwidth="2*"/>
+                                       <thead>
+                                               <row>
+                                                       <entry>Field</entry>
+                                                       <entry>Data Type</entry>
+                                                       <entry>Constraints and References</entry>
+                                               </row>
+                                               </thead>
+                                               <tbody>
+                                               
+                                                       <row>
+                                                               <entry>fund</entry>
+                                                               <entry>integer</entry>
+                                                               <entry><para>
+                                                                       
+                                                                       
+                                                                       
+                                                                       
+                                                                       </para></entry>
+                                                       </row>
+                                               
+                                                       <row>
+                                                               <entry>encumbrance</entry>
+                                                               <entry>boolean</entry>
+                                                               <entry><para>
+                                                                       
+                                                                       
+                                                                       
+                                                                       
+                                                                       </para></entry>
+                                                       </row>
+                                               
+                                                       <row>
+                                                               <entry>amount</entry>
+                                                               <entry>numeric</entry>
+                                                               <entry><para>
+                                                                       
+                                                                       
+                                                                       
+                                                                       
+                                                                       </para></entry>
+                                                       </row>
+                                               
+                                               </tbody>
+                                       </tgroup>
+                               </informaltable>
+                               <para>
+                               
+                               
+                               
+                               
+               </para>
+               </simplesect>
+               
+               <simplesect id="acq.view.fund-encumbrance-total" xreflabel="acq.fund_encumbrance_total">                
+                       <title>fund_encumbrance_total</title>
+                       <informaltable>
+                               <tgroup cols="3">
+                                       <colspec colnum="1" colname="col1" colwidth="1*"/>
+                                       <colspec colnum="2" colname="col2" colwidth="1*"/>
+                                       <colspec colnum="3" colname="col3" colwidth="2*"/>
+                                       <thead>
+                                               <row>
+                                                       <entry>Field</entry>
+                                                       <entry>Data Type</entry>
+                                                       <entry>Constraints and References</entry>
+                                               </row>
+                                               </thead>
+                                               <tbody>
+                                               
+                                                       <row>
+                                                               <entry>fund</entry>
+                                                               <entry>integer</entry>
+                                                               <entry><para>
+                                                                       
+                                                                       
+                                                                       
+                                                                       
+                                                                       </para></entry>
+                                                       </row>
+                                               
+                                                       <row>
+                                                               <entry>amount</entry>
+                                                               <entry>numeric</entry>
+                                                               <entry><para>
+                                                                       
+                                                                       
+                                                                       
+                                                                       
+                                                                       </para></entry>
+                                                       </row>
+                                               
+                                               </tbody>
+                                       </tgroup>
+                               </informaltable>
+                               <para>
+                               
+                               
+                               
+                               
+               </para>
+               </simplesect>
+               
+               <simplesect id="acq.view.fund-spent-balance" xreflabel="acq.fund_spent_balance">                
+                       <title>fund_spent_balance</title>
+                       <informaltable>
+                               <tgroup cols="3">
+                                       <colspec colnum="1" colname="col1" colwidth="1*"/>
+                                       <colspec colnum="2" colname="col2" colwidth="1*"/>
+                                       <colspec colnum="3" colname="col3" colwidth="2*"/>
+                                       <thead>
+                                               <row>
+                                                       <entry>Field</entry>
+                                                       <entry>Data Type</entry>
+                                                       <entry>Constraints and References</entry>
+                                               </row>
+                                               </thead>
+                                               <tbody>
+                                               
+                                                       <row>
+                                                               <entry>fund</entry>
+                                                               <entry>integer</entry>
+                                                               <entry><para>
+                                                                       
+                                                                       
+                                                                       
+                                                                       
+                                                                       </para></entry>
+                                                       </row>
+                                               
+                                                       <row>
+                                                               <entry>amount</entry>
+                                                               <entry>numeric</entry>
+                                                               <entry><para>
+                                                                       
+                                                                       
+                                                                       
+                                                                       
+                                                                       </para></entry>
+                                                       </row>
+                                               
+                                               </tbody>
+                                       </tgroup>
+                               </informaltable>
+                               <para>
+                               
+                               
+                               
+                               
+               </para>
+               </simplesect>
+               
+               <simplesect id="acq.view.fund-spent-total" xreflabel="acq.fund_spent_total">            
+                       <title>fund_spent_total</title>
+                       <informaltable>
+                               <tgroup cols="3">
+                                       <colspec colnum="1" colname="col1" colwidth="1*"/>
+                                       <colspec colnum="2" colname="col2" colwidth="1*"/>
+                                       <colspec colnum="3" colname="col3" colwidth="2*"/>
+                                       <thead>
+                                               <row>
+                                                       <entry>Field</entry>
+                                                       <entry>Data Type</entry>
+                                                       <entry>Constraints and References</entry>
+                                               </row>
+                                               </thead>
+                                               <tbody>
+                                               
+                                                       <row>
+                                                               <entry>fund</entry>
+                                                               <entry>integer</entry>
+                                                               <entry><para>
+                                                                       
+                                                                       
+                                                                       
+                                                                       
+                                                                       </para></entry>
+                                                       </row>
+                                               
+                                                       <row>
+                                                               <entry>amount</entry>
+                                                               <entry>numeric</entry>
+                                                               <entry><para>
+                                                                       
+                                                                       
+                                                                       
+                                                                       
+                                                                       </para></entry>
+                                                       </row>
+                                               
+                                               </tbody>
+                                       </tgroup>
+                               </informaltable>
+                               <para>
+                               
+                               
+                               
+                               
+               </para>
+               </simplesect>
+               
+               <simplesect id="acq.table.fund-tag" xreflabel="acq.fund_tag">           
+                       <title>fund_tag</title>
+                       <informaltable>
+                               <tgroup cols="3">
+                                       <colspec colnum="1" colname="col1" colwidth="1*"/>
+                                       <colspec colnum="2" colname="col2" colwidth="1*"/>
+                                       <colspec colnum="3" colname="col3" colwidth="2*"/>
+                                       <thead>
+                                               <row>
+                                                       <entry>Field</entry>
+                                                       <entry>Data Type</entry>
+                                                       <entry>Constraints and References</entry>
+                                               </row>
+                                               </thead>
+                                               <tbody>
+                                               
+                                                       <row>
+                                                               <entry>id</entry>
+                                                               <entry>serial</entry>
+                                                               <entry><para>
+                                                                       
+                                                                               
+                                                                                       PRIMARY KEY
+                                                                                                               
+                                                                       
+                                                                       
+                                                                       
+                                                                       
+                                                                       
+                                                                               
+                                                                       
+                                                                       </para></entry>
+                                                       </row>
+                                               
+                                                       <row>
+                                                               <entry>owner</entry>
+                                                               <entry>integer</entry>
+                                                               <entry><para>
+                                                                       
+                                                                                                               
+                                                                       
+                                                                               UNIQUE#1
+                                                                               ;
+                                                                               
+                                                                       
+                                                                                                               
+                                                                       
+                                                                       
+                                                                       
+                                                                               NOT NULL;
+                                                                       
+                                                                       
+                                                                       
+                                                                               
+                                                                       
+                                                                               
+                                                                               <xref linkend="actor.table.org-unit"/>
+                                                                               
+                                                                       
+                                                                       </para></entry>
+                                                       </row>
+                                               
+                                                       <row>
+                                                               <entry>name</entry>
+                                                               <entry>text</entry>
+                                                               <entry><para>
+                                                                       
+                                                                                                               
+                                                                       
+                                                                               UNIQUE#1
+                                                                               ;
+                                                                               
+                                                                       
+                                                                       
+                                                                               NOT NULL;
+                                                                       
+                                                                       
+                                                                       
+                                                                               
+                                                                       
+                                                                       </para></entry>
+                                                       </row>
+                                               
+                                               </tbody>
+                                       </tgroup>
+                               </informaltable>
+                               <para>
+                               
+                               
+                               
+                                       <itemizedlist>
+                                               <title>
+                                                       Tables referencing acq.fund_tag_map via Foreign Key Constraints
+                                               </title>
+                               
+                                                       <listitem>
+                                                               <para><xref linkend="acq.table.fund-tag-map"/></para>
+                                                       </listitem>
+                                                       
+                                       </itemizedlist>
+                               
+                               
+                               
+                               
+               </para>
+               </simplesect>
+               
+               <simplesect id="acq.table.fund-tag-map" xreflabel="acq.fund_tag_map">           
+                       <title>fund_tag_map</title>
+                       <informaltable>
+                               <tgroup cols="3">
+                                       <colspec colnum="1" colname="col1" colwidth="1*"/>
+                                       <colspec colnum="2" colname="col2" colwidth="1*"/>
+                                       <colspec colnum="3" colname="col3" colwidth="2*"/>
+                                       <thead>
+                                               <row>
+                                                       <entry>Field</entry>
+                                                       <entry>Data Type</entry>
+                                                       <entry>Constraints and References</entry>
+                                               </row>
+                                               </thead>
+                                               <tbody>
+                                               
+                                                       <row>
+                                                               <entry>id</entry>
+                                                               <entry>serial</entry>
+                                                               <entry><para>
+                                                                       
+                                                                               
+                                                                                       PRIMARY KEY
+                                                                                                               
+                                                                       
+                                                                       
+                                                                       
+                                                                       
+                                                                       
+                                                                               
+                                                                       
+                                                                       </para></entry>
+                                                       </row>
+                                               
+                                                       <row>
+                                                               <entry>fund</entry>
+                                                               <entry>integer</entry>
+                                                               <entry><para>
+                                                                       
+                                                                                                               
+                                                                       
+                                                                               UNIQUE#1
+                                                                               ;
+                                                                               
+                                                                       
+                                                                                                               
+                                                                       
+                                                                       
+                                                                       
+                                                                               NOT NULL;
+                                                                       
+                                                                       
+                                                                       
+                                                                               
+                                                                       
+                                                                               
+                                                                               <xref linkend="acq.table.fund"/>
+                                                                               
+                                                                       
+                                                                       </para></entry>
+                                                       </row>
+                                               
+                                                       <row>
+                                                               <entry>tag</entry>
+                                                               <entry>integer</entry>
+                                                               <entry><para>
+                                                                       
+                                                                                                               
+                                                                       
+                                                                               UNIQUE#1
+                                                                               ;
+                                                                               
+                                                                       
+                                                                                                               
+                                                                       
+                                                                       
+                                                                       
+                                                                       
+                                                                       
+                                                                               
+                                                                       
+                                                                               
+                                                                               <xref linkend="acq.table.fund-tag"/>
+                                                                               
+                                                                       
+                                                                       </para></entry>
+                                                       </row>
+                                               
+                                               </tbody>
+                                       </tgroup>
+                               </informaltable>
+                               <para>
+                               
+                               
+                               
+                               
+               </para>
+               </simplesect>
+               
+               <simplesect id="acq.table.funding-source" xreflabel="acq.funding_source">               
+                       <title>funding_source</title>
+                       <informaltable>
+                               <tgroup cols="3">
+                                       <colspec colnum="1" colname="col1" colwidth="1*"/>
+                                       <colspec colnum="2" colname="col2" colwidth="1*"/>
+                                       <colspec colnum="3" colname="col3" colwidth="2*"/>
+                                       <thead>
+                                               <row>
+                                                       <entry>Field</entry>
+                                                       <entry>Data Type</entry>
+                                                       <entry>Constraints and References</entry>
+                                               </row>
+                                               </thead>
+                                               <tbody>
+                                               
+                                                       <row>
+                                                               <entry>id</entry>
+                                                               <entry>serial</entry>
+                                                               <entry><para>
+                                                                       
+                                                                               
+                                                                                       PRIMARY KEY
+                                                                                                               
+                                                                       
+                                                                       
+                                                                       
+                                                                       
+                                                                       
+                                                                               
+                                                                       
+                                                                       </para></entry>
+                                                       </row>
+                                               
+                                                       <row>
+                                                               <entry>name</entry>
+                                                               <entry>text</entry>
+                                                               <entry><para>
+                                                                       
+                                                                                                               
+                                                                       
+                                                                               UNIQUE#1
+                                                                               ;
+                                                                               
+                                                                       
+                                                                       
+                                                                               NOT NULL;
+                                                                       
+                                                                       
+                                                                       
+                                                                               
+                                                                       
+                                                                       </para></entry>
+                                                       </row>
+                                               
+                                                       <row>
+                                                               <entry>owner</entry>
+                                                               <entry>integer</entry>
+                                                               <entry><para>
+                                                                       
+                                                                                                               
+                                                                       
+                                                                               UNIQUE#1
+                                                                               ;
+                                                                               
+                                                                       
+                                                                                                               
+                                                                       
+                                                                       
+                                                                       
+                                                                               NOT NULL;
+                                                                       
+                                                                       
+                                                                       
+                                                                               
+                                                                       
+                                                                               
+                                                                               <xref linkend="actor.table.org-unit"/>
+                                                                               
+                                                                       
+                                                                       </para></entry>
+                                                       </row>
+                                               
+                                                       <row>
+                                                               <entry>currency_type</entry>
+                                                               <entry>text</entry>
+                                                               <entry><para>
+                                                                       
+                                                                                                               
+                                                                       
+                                                                       
+                                                                       
+                                                                               NOT NULL;
+                                                                       
+                                                                       
+                                                                       
+                                                                               
+                                                                               <xref linkend="acq.table.currency-type"/>
+                                                                               
+                                                                       
+                                                                       </para></entry>
+                                                       </row>
+                                               
+                                                       <row>
+                                                               <entry>code</entry>
+                                                               <entry>text</entry>
+                                                               <entry><para>
+                                                                       
+                                                                                                               
+                                                                       
+                                                                               UNIQUE;
+                                                                               
+                                                                       
+                                                                       
+                                                                       
+                                                                       
+                                                                               
+                                                                       
+                                                                       </para></entry>
+                                                       </row>
+                                               
+                                               </tbody>
+                                       </tgroup>
+                               </informaltable>
+                               <para>
+                               
+                               
+                               
+                                       <itemizedlist>
+                                               <title>
+                                                       Tables referencing acq.fund_allocation via Foreign Key Constraints
+                                               </title>
+                               
+                                                       <listitem>
+                                                               <para><xref linkend="acq.table.fund-allocation"/></para>
+                                                       </listitem>
+                                                       
+                               
+                               
+                                                       <listitem>
+                                                               <para><xref linkend="acq.table.funding-source-credit"/></para>
+                                                       </listitem>
+                                                       
+                                       </itemizedlist>
+                               
+                               
+                               
+                               
+               </para>
+               </simplesect>
+               
+               <simplesect id="acq.view.funding-source-allocation-total" xreflabel="acq.funding_source_allocation_total">              
+                       <title>funding_source_allocation_total</title>
+                       <informaltable>
+                               <tgroup cols="3">
+                                       <colspec colnum="1" colname="col1" colwidth="1*"/>
+                                       <colspec colnum="2" colname="col2" colwidth="1*"/>
+                                       <colspec colnum="3" colname="col3" colwidth="2*"/>
+                                       <thead>
+                                               <row>
+                                                       <entry>Field</entry>
+                                                       <entry>Data Type</entry>
+                                                       <entry>Constraints and References</entry>
+                                               </row>
+                                               </thead>
+                                               <tbody>
+                                               
+                                                       <row>
+                                                               <entry>funding_source</entry>
+                                                               <entry>integer</entry>
+                                                               <entry><para>
+                                                                       
+                                                                       
+                                                                       
+                                                                       
+                                                                       </para></entry>
+                                                       </row>
+                                               
+                                                       <row>
+                                                               <entry>amount</entry>
+                                                               <entry>numeric(100,2)</entry>
+                                                               <entry><para>
+                                                                       
+                                                                       
+                                                                       
+                                                                       
+                                                                       </para></entry>
+                                                       </row>
+                                               
+                                               </tbody>
+                                       </tgroup>
+                               </informaltable>
+                               <para>
+                               
+                               
+                               
+                               
+               </para>
+               </simplesect>
+               
+               <simplesect id="acq.view.funding-source-balance" xreflabel="acq.funding_source_balance">                
+                       <title>funding_source_balance</title>
+                       <informaltable>
+                               <tgroup cols="3">
+                                       <colspec colnum="1" colname="col1" colwidth="1*"/>
+                                       <colspec colnum="2" colname="col2" colwidth="1*"/>
+                                       <colspec colnum="3" colname="col3" colwidth="2*"/>
+                                       <thead>
+                                               <row>
+                                                       <entry>Field</entry>
+                                                       <entry>Data Type</entry>
+                                                       <entry>Constraints and References</entry>
+                                               </row>
+                                               </thead>
+                                               <tbody>
+                                               
+                                                       <row>
+                                                               <entry>funding_source</entry>
+                                                               <entry>integer</entry>
+                                                               <entry><para>
+                                                                       
+                                                                       
+                                                                       
+                                                                       
+                                                                       </para></entry>
+                                                       </row>
+                                               
+                                                       <row>
+                                                               <entry>amount</entry>
+                                                               <entry>numeric(100,2)</entry>
+                                                               <entry><para>
+                                                                       
+                                                                       
+                                                                       
+                                                                       
+                                                                       </para></entry>
+                                                       </row>
+                                               
+                                               </tbody>
+                                       </tgroup>
+                               </informaltable>
+                               <para>
+                               
+                               
+                               
+                               
+               </para>
+               </simplesect>
+               
+               <simplesect id="acq.table.funding-source-credit" xreflabel="acq.funding_source_credit">         
+                       <title>funding_source_credit</title>
+                       <informaltable>
+                               <tgroup cols="3">
+                                       <colspec colnum="1" colname="col1" colwidth="1*"/>
+                                       <colspec colnum="2" colname="col2" colwidth="1*"/>
+                                       <colspec colnum="3" colname="col3" colwidth="2*"/>
+                                       <thead>
+                                               <row>
+                                                       <entry>Field</entry>
+                                                       <entry>Data Type</entry>
+                                                       <entry>Constraints and References</entry>
+                                               </row>
+                                               </thead>
+                                               <tbody>
+                                               
+                                                       <row>
+                                                               <entry>id</entry>
+                                                               <entry>serial</entry>
+                                                               <entry><para>
+                                                                       
+                                                                               
+                                                                                       PRIMARY KEY
+                                                                                                               
+                                                                       
+                                                                       
+                                                                       
+                                                                       
+                                                                       
+                                                                               
+                                                                       
+                                                                       </para></entry>
+                                                       </row>
+                                               
+                                                       <row>
+                                                               <entry>funding_source</entry>
+                                                               <entry>integer</entry>
+                                                               <entry&