Files
2026-07-28 08:26:53 -04:00

324 lines
27 KiB
HTML
Raw Permalink Blame History

This file contains ambiguous Unicode characters
This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.
<!DOCTYPE html>
<html xmlns:MadCap="http://www.madcapsoftware.com/Schemas/MadCap.xsd" lang="en-us" xml:lang="en-us" data-mc-search-type="Stem" data-mc-help-system-file-name="Default.xml" data-mc-path-to-help-system="../../../" data-mc-toc-path="Administration |Administration Tables Reference" data-mc-target-type="WebHelp2" data-mc-runtime-file-type="Topic" data-mc-preload-images="false" data-mc-in-preview-mode="false">
<head>
<meta name="viewport" content="width=device-width, initial-scale=1.0" />
<meta charset="utf-8" />
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" /><title>Database Tables Reference</title>
<!-- Global site tag (gtag.js) - Google Analytics -->
<link href="../../../Skins/Default/Stylesheets/Slideshow.css" rel="stylesheet" type="text/css" data-mc-generated="True" />
<link href="../../../Skins/Default/Stylesheets/TextEffects.css" rel="stylesheet" type="text/css" data-mc-generated="True" />
<link href="../../../Skins/Default/Stylesheets/Topic.css" rel="stylesheet" type="text/css" data-mc-generated="True" />
<link href="../../../Skins/Default/Stylesheets/Components/Styles.css" rel="stylesheet" type="text/css" data-mc-generated="True" />
<link href="../../../Skins/Default/Stylesheets/Components/Tablet.css" rel="stylesheet" type="text/css" data-mc-generated="True" />
<link href="../../../Skins/Default/Stylesheets/Components/Mobile.css" rel="stylesheet" type="text/css" data-mc-generated="True" />
<link href="../../../Skins/Default/Stylesheets/Components/Print.css" rel="stylesheet" type="text/css" data-mc-generated="True" />
<link href="../../../Resources/Stylesheets/BookStyles.css" rel="stylesheet" type="text/css" />
<link href="../../../Resources/TableStyles/BlueHeader.css" rel="stylesheet" data-mc-stylesheet-type="table" />
<script src="../../../Resources/Scripts/jquery.min.js" type="text/javascript">
</script>
<script src="../../../Resources/Scripts/purify.min.js" type="text/javascript" defer="defer">
</script>
<script src="../../../Resources/Scripts/require.min.js" type="text/javascript" defer="defer">
</script>
<script src="../../../Resources/Scripts/require.config.js" type="text/javascript" defer="defer">
</script>
<script src="../../../Resources/Scripts/foundation.min.js" type="text/javascript" defer="defer">
</script>
<script src="../../../Resources/Scripts/plugins.min.js" type="text/javascript" defer="defer">
</script>
<script src="../../../Resources/Scripts/MadCapAll.js" type="text/javascript" defer="defer">
</script>
<script async="" src="https://www.googletagmanager.com/gtag/js?id=G-CFH4DBPHLD">
</script>
<script>/* <![CDATA[ */
window.dataLayer = window.dataLayer || [];
function gtag(){dataLayer.push(arguments);}
gtag('js', new Date());
gtag('config', 'G-CFH4DBPHLD');
/* ]]> */</script>
</head>
<body>
<p class="MCWebHelpFramesetLink MCWebHelpFramesetLinkTop"><a href="../../../Default.htm#PolarisStaffHelp/Administration/PDTablesRef/DataTabRef.htm">Open topic with navigation</a>
</p>
<div class="nocontent">
<div class="MCBreadcrumbsBox_0 breadcrumbs" role="navigation" aria-label="Breadcrumbs" data-mc-breadcrumbs-divider=" &gt; " data-mc-breadcrumbs-count="3" data-mc-toc="True"><span class="MCBreadcrumbsPrefix">You are here: </span>
</div>
</div>
<div class="content">
<div role="main" id="mc-main-content">
<h1>Database Table Reference </h1>
<table style="mc-table-style: url('../../../Resources/TableStyles/BlueHeader.css');margin-left: 3;margin-right: 3;width: 100%;" class="TableStyle-BlueHeader" cellspacing="1">
<col class="TableStyle-BlueHeader-Column-Column1" />
<col class="TableStyle-BlueHeader-Column-Column1" style="width: 2.72in;" />
<col class="TableStyle-BlueHeader-Column-Column1" />
<thead>
<tr class="TableStyle-BlueHeader-Head-Header1">
<th class="TableStyle-BlueHeader-HeadE-Column1-Header1">Database Table Name</th>
<th class="TableStyle-BlueHeader-HeadE-Column1-Header1">Description</th>
<th class="TableStyle-BlueHeader-HeadD-Column1-Header1">Organization Levels</th>
</tr>
</thead>
<tbody>
<tr class="TableStyle-BlueHeader-Body-Body1">
<td class="TableStyle-BlueHeader-BodyE-Column1-Body1">
<p class="TableBody">Authority Control<br /></p>
</td>
<td class="TableStyle-BlueHeader-BodyE-Column1-Body1">
<p class="TableBody">Read-only. Specifies which bibliographic tags are subject to authority control, as well as which authority tags are used for each bib tag in the table. </p>
</td>
<td class="TableStyle-BlueHeader-BodyD-Column1-Body1">System, Library, Branch</td>
</tr>
<tr class="TableStyle-BlueHeader-Body-Body1">
<td class="TableStyle-BlueHeader-BodyE-Column1-Body1">
<p class="TableBody">Authority Deduplication<br /></p>
<p class="indent2"><a name="kanchor2628"></a><a name="IX_table_49"></a>
</p>
</td>
<td class="TableStyle-BlueHeader-BodyE-Column1-Body1">Rules in this table determine if imported or saved authority records are duplicates of existing records.</td>
<td class="TableStyle-BlueHeader-BodyD-Column1-Body1">
<p class="TableBody">System, Library, Branch</p>
</td>
</tr>
<tr class="TableStyle-BlueHeader-Body-Body1">
<td class="TableStyle-BlueHeader-BodyE-Column1-Body1">
<p class="TableBody">Bibliographic Deduplication<br /></p>
<p class="indent2"><a name="kanchor2629"></a><a name="IX_table_50"></a>
</p>
</td>
<td class="TableStyle-BlueHeader-BodyE-Column1-Body1">
<p class="TableBody">Rules in this table determine if imported or saved bibliographic records are duplicates of existing records. </p>
</td>
<td class="TableStyle-BlueHeader-BodyD-Column1-Body1">
<p class="TableBody">System, Library, Branch</p>
</td>
</tr>
<tr class="TableStyle-BlueHeader-Body-Body1">
<td class="TableStyle-BlueHeader-BodyE-Column1-Body1">
<p class="TableBody">Circulation Statuses<br /></p>
</td>
<td class="TableStyle-BlueHeader-BodyE-Column1-Body1">
<p>Identifies the standard names for item circulation statuses. You can change the descriptive names but the actual statuses are read-only.</p>
<p>Applies to Leap.</p>
<p>The <b>Description</b> column applies to both the staff client and Leap. The <b>Banner Text</b> column applies to Leap only. If a circulation status is entered in the <b>Banner Text</b> column, it appears on the banner at the bottom of the book jacket image on the Item Record workform in Leap.</p>
</td>
<td class="TableStyle-BlueHeader-BodyD-Column1-Body1">
<p class="TableBody">System, Library, Branch</p>
</td>
</tr>
<tr class="TableStyle-BlueHeader-Body-Body1">
<td class="TableStyle-BlueHeader-BodyE-Column1-Body1">
<p class="TableBody">Computype Label Printer Commands</p>
</td>
<td class="TableStyle-BlueHeader-BodyE-Column1-Body1">
<p class="TableBody">Lists Computype printer commands. See also: <a href="../../Patron_Services_Admin/PDlabelprinter/Find_Computype_printer_commands.htm">Find Computype printer commands</a> and <a href="../../Patron_Services_Admin/PDlabelprinter/Enter_a_Computype_printer_command.htm">Enter a Computype printer command</a>.</p>
</td>
<td class="TableStyle-BlueHeader-BodyD-Column1-Body1">
<p class="TableBody">System, Library, Branch</p>
</td>
</tr>
<tr class="TableStyle-BlueHeader-Body-Body1">
<td class="TableStyle-BlueHeader-BodyE-Column1-Body1">
<p class="TableBody">Did You Mean Overrides<br /></p>
<p class="indent2"><a name="kanchor2630"></a><a name="IX_table_52"></a>
</p>
</td>
<td class="TableStyle-BlueHeader-BodyE-Column1-Body1">
<p class="TableBody">For PAC, specifies your own 'Did You Mean' suggestions for specific search terms to be displayed instead of the programs suggestions. </p>
</td>
<td class="TableStyle-BlueHeader-BodyD-Column1-Body1">
<p class="TableBody">System, Library, Branch</p>
</td>
</tr>
<tr class="TableStyle-BlueHeader-Body-Body1">
<td class="TableStyle-BlueHeader-BodyE-Column1-Body1">ExpressCheck themes</td>
<td class="TableStyle-BlueHeader-BodyE-Column1-Body1">
<p>Specifies which themes are available for selection in Parameters &gt; SelfCheck Unit &gt; Polaris ExpressCheck theme. <br /></p>
<p>This database table controls only the web-based ExpressCheck.</p>
</td>
<td class="TableStyle-BlueHeader-BodyD-Column1-Body1">System, Library, Branch, and Workstation</td>
</tr>
<tr class="TableStyle-BlueHeader-Body-Body1">
<td class="TableStyle-BlueHeader-BodyE-Column1-Body1">Genders</td>
<td class="TableStyle-BlueHeader-BodyE-Column1-Body1">Manages Gender options for all users. Entries can be added/modified/deleted.</td>
<td class="TableStyle-BlueHeader-BodyD-Column1-Body1">System, Library, Branch</td>
</tr>
<tr class="TableStyle-BlueHeader-Body-Body1">
<td class="TableStyle-BlueHeader-BodyE-Column1-Body1">
<p class="TableBody">Geographic Coordinates<br /></p>
<p class="indent2"><a name="kanchor2631"></a><a name="IX_table_53"></a>
</p>
</td>
<td class="TableStyle-BlueHeader-BodyE-Column1-Body1">For Polaris PowerPAC, holds the latitude and longitude values for organizations that might be displayed with the Map It (Google Maps™) feature in PowerPAC search results. </td>
<td class="TableStyle-BlueHeader-BodyD-Column1-Body1">
<p class="TableBody">System</p>
</td>
</tr>
<tr class="TableStyle-BlueHeader-Body-Body1">
<td class="TableStyle-BlueHeader-BodyE-Column1-Body1">
<p class="TableBody">Hold Request Statuses<br /></p>
<p class="indent2"><a name="kanchor2632"></a><a name="IX_table_54"></a>
</p>
</td>
<td class="TableStyle-BlueHeader-BodyE-Column1-Body1">Specifies the hold request status descriptions displayed in the staff client and PAC patron account. </td>
<td class="TableStyle-BlueHeader-BodyD-Column1-Body1">
<p class="TableBody">System, Library, Branch</p>
</td>
</tr>
<tr class="TableStyle-BlueHeader-Body-Body1">
<td class="TableStyle-BlueHeader-BodyE-Column1-Body1">
<p class="TableBody">In-House IP Addresses<br /></p>
<p class="indent2"><a name="kanchor2633"></a><a name="IX_table_55"></a>
</p>
</td>
<td class="TableStyle-BlueHeader-BodyE-Column1-Body1">Identifies specific IP addresses to be considered local (in-house) workstations, even though they are not registered as workstations in Polaris. See <a href="../PDresourc/Identifying_In-House_Computers.htm#XREF_75055_Indentifying_In">Identifying In-House Computers</a>.</td>
<td class="TableStyle-BlueHeader-BodyD-Column1-Body1">
<p class="TableBody">System</p>
</td>
</tr>
<tr class="TableStyle-BlueHeader-Body-Body1">
<td class="TableStyle-BlueHeader-BodyE-Column1-Body1">
<p class="TableBody">Item Block Descriptions<br /></p>
<p class="indent2"><a name="kanchor2634"></a><a name="IX_table_56"></a>
</p>
</td>
<td class="TableStyle-BlueHeader-BodyE-Column1-Body1">Defines the library-assigned item blocks that can stop circulation, listed as options in the <b>Library assigned</b> box on the Notes and Notices view of the Item Record workform. </td>
<td class="TableStyle-BlueHeader-BodyD-Column1-Body1">
<p class="TableBody">System, Library, Branch</p>
</td>
</tr>
<tr class="TableStyle-BlueHeader-Body-Body1">
<td class="TableStyle-BlueHeader-BodyE-Column1-Body1">
<p class="TableBody">Item Create Call Number Hierarchy <br /></p>
<p class="indent2"><a name="kanchor2635"></a><a name="IX_table_57"></a>
</p>
</td>
<td class="TableStyle-BlueHeader-BodyE-Column1-Body1">
<p class="TableBody">Specifies the tags in the bibliographic record to use for the call number in the linked item record and the precedence in which the tags are checked for the call number. </p>
</td>
<td class="TableStyle-BlueHeader-BodyD-Column1-Body1">
<p class="TableBody">System, Library, Branch</p>
</td>
</tr>
<tr class="TableStyle-BlueHeader-Body-Body1">
<td class="TableStyle-BlueHeader-BodyE-Column1-Body1">
<p class="TableBody">Item Create Price Hierarchy<br /></p>
<p class="indent2"><a name="kanchor2636"></a><a name="IX_table_58"></a>
</p>
</td>
<td class="TableStyle-BlueHeader-BodyE-Column1-Body1">Specifies the order of bibliographic record fields to check for price when creating a linked item.</td>
<td class="TableStyle-BlueHeader-BodyD-Column1-Body1">System, Library, Branch</td>
</tr>
<tr class="TableStyle-BlueHeader-Body-Body1">
<td class="TableStyle-BlueHeader-BodyE-Column1-Body1">
<p class="TableBody">Mobile Phone Carriers<br /></p>
<p class="indent2"><a name="kanchor2637"></a><a name="IX_table_59"></a>
</p>
</td>
<td class="TableStyle-BlueHeader-BodyE-Column1-Body1">Identifies the mobile phone service carriers that will appear as options for selection in the Patron Registration workform and when patrons register or update their account information from the PAC.</td>
<td class="TableStyle-BlueHeader-BodyD-Column1-Body1">System</td>
</tr>
<tr class="TableStyle-BlueHeader-Body-Body1">
<td class="TableStyle-BlueHeader-BodyE-Column1-Body1">
<p class="TableBody">Network Domains<br /></p>
<p class="indent2"><a name="kanchor2638"></a><a name="IX_table_60"></a>
</p>
</td>
<td class="TableStyle-BlueHeader-BodyE-Column1-Body1">
<p class="TableBody">For multi-domain networks, specifies the NetBIOS Name and DNSName for each domain in your network. See <a href="../PDresourc/Multi-Domain_System_Support.htm#XREF_12766_Multi_Domain">Multi-Domain System Support</a>.</p>
</td>
<td class="TableStyle-BlueHeader-BodyD-Column1-Body1">System</td>
</tr>
<tr class="TableStyle-BlueHeader-Body-Body1">
<td class="TableStyle-BlueHeader-BodyE-Column1-Body1">
<p class="TableBody">Object Locks<br /></p>
<p><a name="kanchor2639"></a><a name="IX_table_61"></a>
</p>
</td>
<td class="TableStyle-BlueHeader-BodyE-Column1-Body1">
<p class="TableBody">When a Polaris record is open, an entry is automatically made in the Object Locks table so that no one else can change the record. When the record is closed, the entry is automatically removed from the Object Locks table. You can manually remove an object lock from the table. See <a href="../PDstart/Managing_Record_Locks.htm#XREF_49617_Object_Locks">Managing Record Locks</a>.</p>
</td>
<td class="TableStyle-BlueHeader-BodyD-Column1-Body1">System, Library, Branch</td>
</tr>
<tr class="TableStyle-BlueHeader-Body-Body1">
<td class="TableStyle-BlueHeader-BodyE-Column1-Body1">Patron Address Types</td>
<td class="TableStyle-BlueHeader-BodyE-Column1-Body1">Defines the address types that appear when adding or changing a patron's address in the Polaris staff client or Leap. See <MadCap:conditionalText data-mc-conditions="Primary.Online,Primary.Hidden"><a href="../../Patron_Services_Admin/PDPpatacct/Setting_Patron_Registration_Lists.htm">Maintaining Patron Registration Address Types</a></MadCap:conditionalText>.</td>
<td class="TableStyle-BlueHeader-BodyD-Column1-Body1">System, Library, Branch</td>
</tr>
<tr class="TableStyle-BlueHeader-Body-Body1">
<td class="TableStyle-BlueHeader-BodyE-Column1-Body1">
<p class="TableBody">Postal Codes<br /></p>
<p><a name="kanchor2640"></a><a name="IX_table_62"></a>
</p>
</td>
<td class="TableStyle-BlueHeader-BodyE-Column1-Body1">
<p>Initially contains the entire list of valid U.S. Zip codes; works with the Countries policy table. When you enter an address in Polaris, you select a country (U.S. or Canada) and type a valid postal code. The <b>City</b> and <b>State</b> boxes are automatically filled in. Use the Postal Codes table to keep the entries current. See <a href="../PDorgnizatn/Setting_System_Postal_Codes.htm#XREF_42844_Setting_Postal">Setting System Postal Codes</a>.</p>
</td>
<td class="TableStyle-BlueHeader-BodyD-Column1-Body1">System, Library, Branch</td>
</tr>
<tr class="TableStyle-BlueHeader-Body-Body1">
<td class="TableStyle-BlueHeader-BodyE-Column1-Body1">PowerPAC themes</td>
<td class="TableStyle-BlueHeader-BodyE-Column1-Body1">Contains the entire list of valid PowerPAC themes for PowerPAC customization. Also lists custom themes that are added after installation.</td>
<td class="TableStyle-BlueHeader-BodyD-Column1-Body1">System, Library, Branch</td>
</tr>
<tr class="TableStyle-BlueHeader-Body-Body1">
<td class="TableStyle-BlueHeader-BodyE-Column1-Body1">
<p class="TableBody">Primary Display Author<br /></p>
<p><a name="kanchor2641"></a><a name="IX_table_63"></a>
</p>
</td>
<td class="TableStyle-BlueHeader-BodyE-Column1-Body1">Specifies the author tags and subfields and their order of precedence used to construct the display of an author in search results. See <a href="../PDsearch/Viewing_Title_and_Author_Elements.htm#XREF_44881_Viewing_Title">Viewing Title and Author Elements</a>.</td>
<td class="TableStyle-BlueHeader-BodyD-Column1-Body1">System, Library, Branch</td>
</tr>
<tr class="TableStyle-BlueHeader-Body-Body1">
<td class="TableStyle-BlueHeader-BodyE-Column1-Body1">
<p class="TableBody">Primary Display Title<br /></p>
<p><a name="kanchor2642"></a><a name="IX_table_64"></a>
</p>
</td>
<td class="TableStyle-BlueHeader-BodyE-Column1-Body1">
<p>Specifies the title tags and subfields and their order of precedence used to construct the display of a title in search results. See <a href="../PDsearch/Viewing_Title_and_Author_Elements.htm#XREF_44881_Viewing_Title">Viewing Title and Author Elements</a>.</p>
</td>
<td class="TableStyle-BlueHeader-BodyD-Column1-Body1">System, Library, Branch</td>
</tr>
<tr class="TableStyle-BlueHeader-Body-Body1">
<td class="TableStyle-BlueHeader-BodyE-Column1-Body1">
<p class="TableBody">Shelf Locations<br /></p>
<p class="indent2"><a name="kanchor2643"></a><a name="IX_table_65"></a>
</p>
</td>
<td class="TableStyle-BlueHeader-BodyE-Column1-Body1">Determines the branchs shelf location options in an item record. </td>
<td class="TableStyle-BlueHeader-BodyD-Column1-Body1">System, Library, Branch</td>
</tr>
<tr class="TableStyle-BlueHeader-Body-Body1">
<td class="TableStyle-BlueHeader-BodyE-Column1-Body1">Tax Rates</td>
<td class="TableStyle-BlueHeader-BodyE-Column1-Body1">Contains the amount and description of the tax rate for fees.</td>
<td class="TableStyle-BlueHeader-BodyD-Column1-Body1">System</td>
</tr>
<tr class="TableStyle-BlueHeader-Body-Body1">
<td class="TableStyle-BlueHeader-BodyB-Column1-Body1">
<p class="TableBody">Transaction Logging<br /></p>
<p class="indent2"><a name="kanchor2644"></a><a name="IX_table_66"></a>
</p>
</td>
<td class="TableStyle-BlueHeader-BodyB-Column1-Body1">Specifies which Polaris transactions are logged for statistical and reporting purposes. See <a href="../PDlogging/Logging_Transactions.htm#XREF_22808_Logging">Logging Transactions</a>.</td>
<td class="TableStyle-BlueHeader-BodyA-Column1-Body1">System, Library, Branch</td>
</tr>
</tbody>
</table>
<p />
</div>
</div>
<div id="footer">
<div id="copyright"><a href="../../../FrontMatter/LegalNotices.htm">© 2025 Innovative (Part of Clarivate)</a><![CDATA[
]]></div>
<div>Polaris Version <span class="mc-variable III_Variables.VersionNumber variable">7.8</span></div>
<div>
<p align="center">
<script type="text/javascript">/*<![CDATA[*/document.write("<a href='mailto:doccust@iii.com?subject=documentation%20feedback%20(Polaris staff client): "+document.title+"&body=Topic%20reference%20(for%20Innovative%20use%20only):%20"+location.pathname+"%0A%0APlease provide comments, report discrepancies, or suggest improvements for Innovative documentation. Your suggestions and corrections will be emailed to Innovative staff, who review them for future versions of the documentation. Thank you for your feedback.%0A%0APlease do not report technical or software issues here. Authorized staff at your organization should submit a service request for those issues.%0A%0AEnter%20your%20comments%20below:%0A%0A'>Send documentation feedback to Innovative</a>");
/*]]>*/</script>
</p>
</div>
</div>
</body>
</html>