System Configuration

Detailed View

backup_admin

Each row of backup_admin contains administrative data for a backup job.

Column	Data Type	Not NULL?	Comment
id	int	false	System-generated sequential ID.
name	varchar	false	The name applied to the backup job.
email	varchar	false	The email address to which the system sends success or fail notices for this backup job.

darc_service_view

Each row of darc_service_view identifies and specifies a DARC service parameter value.

Column	Data Type	Not NULL?	Comment
group_name	varchar	false	DARC service group name.
service_name	varchar	false	DARC service name.
param	varchar	false	Parameter name.
value	varchar	false	Parameter value.

diacritic_category

Each row of diacritic_category describes a category of diacritical markings.

Column	Data Type	Not NULL?	Comment
id	int	false	System-generated sequential ID.
name	varchar	false	Category name.
is_unicode_style	boolean	false	Specifies whether the category is Unicode style.
is_big5	boolean	false	Specifies whether the category is Big5 Chinese. The system processes characters in the high-bit range in groups of two, i.e. the system waits for two characters before attempting to do a lookup in the diac.* file. Used with CJK characters.
is_cccii	boolean	false	Specifies whether the category is CCCII Chinese. The system processes characters in the high-bit range in groups of four, i.e. the system waits for four characters before attempting to do a lookup in the diac.* file. Used with CJK characters.
is_eacc	boolean	false	Specifies whether the category is EACC Chinese. The system processes characters in the high-bit range in groups of four, i.e. the system waits for four characters before attempting to do a lookup in the diac.* file. Used with CJK characters.
is_thai	boolean	false	Specifies whether the category is a Thai language. Add 512 to the value of the braced diacritic. For example, the Thai character represented by the ASCII value 0x80 (128) is transformed into the value 640 (i.e., 128 + 512). Used with Thai characters.
is_winpage	boolean	false	Specifies whether the category uses winpage input mode. No special processing necessary. Used with PCs running Microsoft Windows with the following Microsoft Code Pages: 1250 - ISO 6937 for Polish 1251 - for Cyrillic 1252 - ISO Latin1 for Western European languages 1254 - for Turkish 1255 - for Hebrew 1256 - for Arabic 1257 - for Baltic Rim countries
is_multibyte	boolean	false	Specifies whether the category includes multiple-byte characters. Used for multi-byte Asian language encodings and for Unicode (16-bit) characters which have been transformed according to the UTF8 standard. For input, the system processes all characters in groups of two to three characters.
is_decomposed_character_used	boolean	false	Specifies whether the category uses decomposed characters (diacritical marks removed).
is_general_rule_enabled	boolean	false	Specifies whether the category is enabled for compliance with system indexing rules.
is_staff_enabled	boolean	false	Specifies whether the category is enabled for use in staff applications.

diacritic_mapping

Each row of diacritic_mapping describes a diacritical character mapping.

Column	Data Type	Not NULL?	Comment
id	int	false	System-generated sequential ID.
diacritic	varchar	false	The mapped diacritical character.
letter	char	false	A letter substitute for the diacritical character if a mapping does not exist.
description	varchar	false	Description of the mapped diacritical character.
mapped_string	varchar	false	The string to which the diacritical character is mapped.
is_preferred	boolean	false	Specified whether the character mapping is the preferred mapping.
diacritic_category_id	int	false	Foreign key to diacritic_category.
width	int	false	Specifies whether the character is single (1) or double (0) width.
display_order	int	false	Integer to manage the display order of a character list.

keyword_synonym

Each row of keyword_synonym describes a keyword and synonym pair.

Column	Data Type	Not NULL?	Comment
id	bigint	false	System-generated sequential ID.
keyword	varchar	false	The index keyword.
synonym	varchar	false	A synonym for the index keyword.

network_access_view

Each row of network_access_view describes the network access parameters for a single login.

Column	Data Type	Not NULL?	Comment
port	int	false	Port number.
is_enabled	boolean	false	Specifies whether the login is enabled.
is_super_user	boolean	false	Identifies super user logins.
ip_range	varchar	false	A full or partial IP address or the words "all", "LOCAL", or "LOCAL+".
is_accessible	boolean	false	Specifies whether the associated IP address is allowed to connect to the system.
login_name	varchar	false	Login name.
service_level	int	false	Number between 0 and 9 (inclusive) that governs a user's access to alternate databases and library catalogs to which the user's own system connects.
comment	varchar	false	Free text comment field.

oai_crosswalk

Each row of oai_crosswalk contains information to assist the harvesting of OAI/PMH metadata for a configured metadata prefix/marctype pair.

Column	Data Type	Not NULL?	Comment
id	bigint	false	System-generated sequential ID.
marc_type	char	false	MARC type of the data.
metadata_prefix	varchar	false	Identifying prefix of the metadata type, such as "DC" for Dublin Core.
name	varchar	false	Configured pair name, such as "marc21_oai_dc".
description	varchar	false	Description of the configured pair, such as "MARC21 OAI DC Crosswalk".
is_system	boolean	false	Identifies crosswalk configurations for system use.

oai_crosswalk_field

Each row of oai_crosswalk_field identifies the various elements of a data field.

Column	Data Type	Not NULL?	Comment
id	bigint	false	System-generated sequential ID.
oai_crosswalk_id	bigint	false	Foreign key to oai_crosswalk.
element_name	varchar	false	Element name.
varfield_type_code	char	false	III variable-length field type tag.
marc_tag	char	false	MARC tag.
subfields	varchar	false	Subfields of the MARC tag.
is_add_subfield	boolean	false	Identifies additional instances of a subfield.
is_varfield	boolean	false	Identifies variable-length fields.
fixnum	int	false	Identifies the length of fixed-length fields.
order_num	int	false	Integer to manage the order field elements.

request_rule

Each row of request_rule defines a request rule for a specified record type.

Column

Data Type

Not NULL?

Comment

bigint

false

System-generated sequential ID.

record_type_code

char

false

The type of record to which the rule applies. All condition lines for a given rule must contain the same record type, which can be one of the following:

Code	Description
i	Item record
b	Bibliographic record
o	Order record
I	(INN-REACH ONLY) Only apply the test to a specific "current" sub-item field (tag '949' in an INN-Reach "Institution" record). Determines which attached item to check when requesting over the network from the central machine. Note that this record type can only appear in the requestrl file at the CENTRAL machine and that only the Union Database department staff is allowed to edit the central machine's requestrl file.

query

text

false

The Innovative request rule as it appears in the requestrl file.

sql_query

text

false

The SQL "translation" of the request rule.

request_rule_comment

Each row of request_rule_comment defines a request rule comment.

Column	Data Type	Not NULL?	Comment
request_rule_id	int	false	Foreign key to request_rule.
comment	text	false	If the logic operator element in the associated Innovative request rule is 'q', then the system displays this string if the rule has denied the request. Otherwise, the string is a descriptive comment.
iii_language_id	int	false	Foreign key to iii_language.
id	int	false	System-generated sequential ID.

suite_behavior_view

Each row of suite_behavior_view includes data specifying application behavior. (Each behavior has a separate value for each suite in which it appears.)

Column	Data Type	Not NULL?	Comment
suite	varchar	false	Associated suite.
app	varchar	false	Associated application.
code	varchar	false	Behavior code.
value	varchar	false	Behavior value.
type	varchar	false	Behavior's data type.

suite_message_view

Each row of suite_message_view includes data specifying application messages.

Column	Data Type	Not NULL?	Comment
suite	varchar	false	Associated suite.
app	varchar	false	Associated application.
code	varchar	false	Message code.
lang	varchar	false	III language code for the language of the message.
value	varchar	false	Message value.

suite_skin_view

Each row of suite_skin_view includes data specifying application presentation resources.

Column	Data Type	Not NULL?	Comment
suite	varchar	false	Associated suite.
app	varchar	false	Associated application.
code	varchar	false	Resource code.
lang	varchar	false	III language code for the language of the presentation resource.
type	varchar	false	Type of resource, such as HTML, MAP, or STRING.
value	varchar	false	Value of the resource (for applicable resource types).

wamreport

Each row of wamreport stores parameters used to record Web Access Management statistics.

Column	Data Type	Not NULL?	Comment
id	bigint	false	System-generated sequential ID.
logged_gmt	timestamptz	false	Date the request was logged.
requesting_ip	varchar	false	The originating IP for the request. If the WAM_LOG_IP wwwoption has a "false" value or is undefined, the system does not assign a value to this column.
requesting_port	int	false	The port of the proxying server (webpac or wamproxy).
requesting_iii_name	varchar	false	The login name associated with the requesting_ip.
dest_port	int	false	The destination port for the request.
dest_code	varchar	false	A code representing the remote server.
response_category_code_num	int	false	The category code number from the wam_filter file.
patron_record_metadata_id	bigint	false	Foreign key to patron_record_metadata.
ptype_code_num	int	false	The code number of the P TYPE associated with the user if the system requires validation to access the resource.
pcode1	char	false	The PCODE4 patron record fixfld assigned to the patron making the request.
pcode2	char	false	The PCODE4 patron record fixfld assigned to the patron making the request.
pcode3_code_num	int	false	The PCODE3 patron record fixfld assigned to the patron making the request.
pcode4_code_num	int	false	The PCODE4 patron record fixfld assigned to the patron making the request.
rejection_reason_code_num	int	false	The code number matching the reason for rejecting access (if any). The library determines the reason labels. For example: 1\|Service Level not allowed 2\|P Type not allowed 3\|Home Library not allowed 4\|Database not in forward table 5\|Expired patron record 6\|Maximum money owed 7\|Maximum overdue points 8\|Manual block on patron 9\|Patron blocked by local server

zip_code_info

Each row of zip_code_info identifies a postal code and related geographical information.

Column	Data Type	Not NULL?	Comment
id	int	false	System-generated sequential ID.
zip_code	varchar	false	Postal code.
latitude	varchar	false	Latitude of the postal code.
longitude	varchar	false	Longitude of the postal code.
country_code	varchar	false	The country containing the postal code. COUNTRY is based on the MARC 21 Code List of Countries, or ISO 3166/MA standard for UNIMARC systems.