Database Tables Reference

Database Table Name	Description	Organization Levels
Authority Control	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.	System, Library, Branch
Authority Deduplication	Rules in this table determine if imported or saved authority records are duplicates of existing records.	System, Library, Branch
Bibliographic Deduplication	Rules in this table determine if imported or saved bibliographic records are duplicates of existing records.	System, Library, Branch
Circulation Statuses	Identifies the standard names for item circulation statuses. You can change the descriptive names but the actual statuses are read-only. Applies to Leap. The Description column applies to both the staff client and Leap. The Banner Text column applies to Leap only. If a circulation status is entered in the Banner Text column, it appears on the banner at the bottom of the book jacket image on the Item Record workform in Leap.	System, Library, Branch
Computype Label Printer Commands	Lists Computype printer commands. See also: Find Computype printer commands and Enter a Computype printer command.	System, Library, Branch
Did You Mean Overrides	For PAC, specifies your own 'Did You Mean' suggestions for specific search terms to be displayed instead of the program’s suggestions.	System, Library, Branch
Genders	Manages Gender options for all users. Entries can be added/modified/deleted.	System, Library, Branch
Geographic Coordinates	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.	System
Hold Request Statuses	Specifies the hold request status descriptions displayed in the staff client and PAC patron account.	System, Library, Branch
In-House IP Addresses	Identifies specific IP addresses to be considered local (in-house) workstations, even though they are not registered as workstations in Polaris. See Identifying In-House Computers.	System
Item Block Descriptions	Defines the library-assigned item blocks that can stop circulation, listed as options in the Library assigned box on the Notes and Notices view of the Item Record workform.	System, Library, Branch
Item Create Call Number Hierarchy	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.	System, Library, Branch
Item Create Price Hierarchy	Specifies the order of bibliographic record fields to check for price when creating a linked item.	System, Library, Branch
Mobile Phone Carriers	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.	System
Network Domains	For multi-domain networks, specifies the NetBIOS Name and DNSName for each domain in your network. See Multi-Domain System Support.	System
Object Locks	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 Managing Record Locks.	System, Library, Branch
Patron Address Types	Defines the address types that appear when adding or changing a patron's address in the Polaris staff client or Leap. See Maintaining Patron Registration Address Types.	System, Library, Branch
Postal Codes	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 City and State boxes are automatically filled in. Use the Postal Codes table to keep the entries current. See Setting System Postal Codes.	System, Library, Branch
PowerPAC themes	Contains the entire list of valid PowerPAC themes for PowerPAC customization. Also lists custom themes that are added after installation.	System, Library, Branch
Primary Display Author	Specifies the author tags and subfields and their order of precedence used to construct the display of an author in search results. See Viewing Title and Author Elements.	System, Library, Branch
Primary Display Title	Specifies the title tags and subfields and their order of precedence used to construct the display of a title in search results. See Viewing Title and Author Elements.	System, Library, Branch
Shelf Locations	Determines the branch’s shelf location options in an item record.	System, Library, Branch
Tax Rates	Contains the amount and description of the tax rate for fees.	System
Transaction Logging	Specifies which Polaris transactions are logged for statistical and reporting purposes. See Logging Transactions.	System, Library, Branch

Authority Control

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.

System, Library, Branch

Authority Deduplication

Rules in this table determine if imported or saved authority records are duplicates of existing records.

System, Library, Branch

Bibliographic Deduplication

Rules in this table determine if imported or saved bibliographic records are duplicates of existing records.

System, Library, Branch

Circulation Statuses

Identifies the standard names for item circulation statuses. You can change the descriptive names but the actual statuses are read-only.

Applies to Leap.

The Description column applies to both the staff client and Leap. The Banner Text column applies to Leap only. If a circulation status is entered in the Banner Text column, it appears on the banner at the bottom of the book jacket image on the Item Record workform in Leap.

System, Library, Branch

Computype Label Printer Commands

Lists Computype printer commands. See also: Find Computype printer commands and Enter a Computype printer command.

System, Library, Branch

Did You Mean Overrides

For PAC, specifies your own 'Did You Mean' suggestions for specific search terms to be displayed instead of the program’s suggestions.

System, Library, Branch

Genders

Manages Gender options for all users. Entries can be added/modified/deleted.

System, Library, Branch

Geographic Coordinates

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.

System

Hold Request Statuses

Specifies the hold request status descriptions displayed in the staff client and PAC patron account.

System, Library, Branch

In-House IP Addresses

Identifies specific IP addresses to be considered local (in-house) workstations, even though they are not registered as workstations in Polaris. See Identifying In-House Computers.

System

Item Block Descriptions

Defines the library-assigned item blocks that can stop circulation, listed as options in the Library assigned box on the Notes and Notices view of the Item Record workform.

System, Library, Branch

Item Create Call Number Hierarchy

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.

System, Library, Branch

Item Create Price Hierarchy

Specifies the order of bibliographic record fields to check for price when creating a linked item.

System, Library, Branch

Mobile Phone Carriers

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.

System

Network Domains

For multi-domain networks, specifies the NetBIOS Name and DNSName for each domain in your network. See Multi-Domain System Support.

System

Object Locks

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 Managing Record Locks.

System, Library, Branch

Patron Address Types

Defines the address types that appear when adding or changing a patron's address in the Polaris staff client or Leap. See Maintaining Patron Registration Address Types.

System, Library, Branch

Postal Codes

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 City and State boxes are automatically filled in. Use the Postal Codes table to keep the entries current. See Setting System Postal Codes.

System, Library, Branch

PowerPAC themes

Contains the entire list of valid PowerPAC themes for PowerPAC customization. Also lists custom themes that are added after installation.

System, Library, Branch

Primary Display Author

Specifies the author tags and subfields and their order of precedence used to construct the display of an author in search results. See Viewing Title and Author Elements.

System, Library, Branch

Primary Display Title

Specifies the title tags and subfields and their order of precedence used to construct the display of a title in search results. See Viewing Title and Author Elements.

System, Library, Branch

Shelf Locations

Determines the branch’s shelf location options in an item record.

System, Library, Branch

Tax Rates

Contains the amount and description of the tax rate for fees.

System

Transaction Logging

Specifies which Polaris transactions are logged for statistical and reporting purposes. See Logging Transactions.

System, Library, Branch