Cataloging

Detailed View

b2m_category

Each row of b2m_category identifies a bib to MARC export category code.

Column	Data Type	Not NULL?	Comment
id	bigint	false	System-generated sequential ID.
code	varchar	false	Bib to MARC export category code.
is_staff_enabled	boolean	false	Identifies bib to MARC export categories enabled for staff use.

b2m_category_myuser

Each row of b2m_category_myuser identifies a bib to MARC export category, with the name presented in the language associated with the user's login account. Each library maintains its own bib to MARC categories.

Column	Data Type	Not NULL?	Comment
code	varchar	false	Bib to MARC export category code.
is_staff_enabled	boolean	false	Identifies bib to MARC export categories enabled for staff use.
name	varchar	false	Bib to MARC export category name.

b2m_category_name

Each row of b2m_category_name identifies a bib to MARC export category name.

Column	Data Type	Not NULL?	Comment
b2m_category_id	bigint	false	Foreign key to b2m_category.
iii_language_id	bigint	false	Foreign key to iii_language.
name	varchar	false	Bib to MARC export category name.

bool_info

Each row of bool_info contains state information about a Boolean review file. Each time a user searches, sorts, lists, or exports a Boolean review file search on a Sierra client, the server saves this state information.

Column

Data Type

Not NULL?

Comment

bigint

false

System-generated sequential ID.

name

varchar

false

Review file name.

max

int

false

The maximum number of records the review file holds.

count

int

false

The number of records in the review file result set.

record_type_code

char

false

The type of records to which the range specification applies.

record_range

varchar

false

The range of records specified for the search.

bool_gmt

timestamptz

false

Timestamp indicating the Boolean query's most recent run.

bool_query

text

false

The Boolean search strategy, consisting of one or more lines.

             1                  2             3

            <logical operator>:<record type>:<variable tag>

             4               5                6         7

            <fixflds line#>:<operation type>:<target1>:<target2>

Element

Description

1. <Logical Operator>

Specifies the logical connection between the current line and the line below it. Possible values include:

^ (caret) - interpreted as "AND"
v (lowercase) - interpreted as "OR"
q (lowercase) - specifies the last line of a strategy

2. <Record Type>

Specifies the record type for the current search line, for example, 'b', 'o', 'c', and so on.

The record type element can include an 'S' indicating that the system should search soft links as well as hard links, for example, "oS".

Additionally, the second character can indicate the field group tag of the field that contains the soft-link. For example, section records can be soft-linked to patrons in one of two ways, registered (patron record field group tag 3) or wait-listed (patron record field group tag 4). Thus, a search line might indicate the following:

p3 - search registered Patrons
p4 - search waitlisted Patrons

3. <Variable tag>

Specifies a III field group tag from varflds. It is blank if the variable-length field is not used in this line of the strategy.

4. <Fixflds line#>

Specifies a line number from the fixflds table. It is null (or "0") if the fixed-length field is not used in this line of the strategy.

If the value of this element is less than 0, for example -3, it indicates that the boolean test is made on one of the checkin box elements as follows:

Value	Checkin Box Element
-1	BOX STATUS
-2	COVER DATE
-3	TRANS DATE
-4	CLAIM
-5	ARR COPIES
-6	BOX NOTE
-7	CARD STATUS

5. <Operation type>
(the logical operator used within a line)

Possible values include:

= (equal to)
g (greater than or equal to)
> (greater than)
< (less than)
l (less than or equal to)
~ (not equal to)
w (between)
h (has)
e (exists)
n (does not exist)
x (all fields don't have)
o (at least one field doesn't have)
! (not within)
^ (starts with)
$ (ends with)
r (matches [regular expression])

6. <Target1>

Specifies the data to search for. If a III field group tag appears in data element 3, AND this field is blank, then:

if operation type is '=', the server searches for records lacking the field specified in data element 3.
if operation type is '~', the server searches for records containing the field specified in data element 3.

If data element 3 contains a '^' (link field), the type of the linked record, for example, 'o' for order, goes in Target1.

7. <Target2>

2nd value for operation type 'w' (between); blank if not required.

sql_query

text

false

The SQL representing the query.

is_lookup_call

boolean

false

Indicates whether the user chose to look for the call number in the parent record if the item or holdings record does not contain a call number.

is_lookup_880

boolean

false

Indicates whether the user chose to look for 880 fields when searching.

is_search_holdings

boolean

false

Indicates whether the user chose to include ERM holdings when searching.

sorter_spec

text

false

Specifies the fields used to sort the records contained in the review file.

lister_spec

text

false

Specifies the fields that were selected for the list and its formatting parameters. Each element corresponds to an option in the "List Format" dialog box, accessed by choosing the "List Records" button in Create Lists mode.

status_code

char

false

Status of the review file - 'e' = empty or 'c' = complete.

iii_user_name

varchar

false

Specifies the login name that created the review file.

list_export_spec

text

false

Specifies the fields selected for export and the export parameters. Each element corresponds to an option in the "Export Format" dialog box, accessed by choosing the "Export Records" button in Create Lists mode.

owner_iii_user_name

varchar

false

The login name identified as the owner of the review file.

is_store_field

boolean

false

Indicates whether the user chose to search both the holdings (checkin) record and the checkin card and selected the "Retain each box separately in review file" checkbox.

is_card_search

boolean

false

Indicates whether the query strategy includes conditions for searching checkin cards.

bool_set

Each row of bool_set identifies a record included in a review file result set.

Column	Data Type	Not NULL?	Comment
id	bigint	false	System-generated sequential ID.
record_metadata_id	bigint	false	Foreign key to record_metadata.
bool_info_id	bigint	false	Foreign key to bool_info.
display_order	int	false	Integer to manage the display order of a list.
field_key	varchar	false	(Currently not in use.) Pointer to the source of the data qualifying the current entry for inclusion in the result set.
occ_num	int	false	The ordinal rank of this occurrence of the record in a review file result set.

m2bmap_category

Each row of m2bmap_category contains special instructions pertaining to MARC to bib data conversions.

Column	Data Type	Not NULL?	Comment
id	int	false	System-generated sequential ID.
name	varchar	false	Category name.
original_delimiter	char	false	Field delimiter found in the MARC file.
is_case_sensitive	boolean	false	Specifies whether comparisons and replacements are case-sensitive.
is_bar_subfield	boolean	false	Specifies whether the system replaces the character '\|' with the ASCII character 1F (hex) as the subfield delimiter. If this trigger is set to 'false', the '\|' character is interpreted literally as the '\|' (bar) character and not as the ASCII '1F' (hex) character.
is_chinese	boolean	false	Specifies whether to convert the system braced Chinese diacritics (e.g., {21236E}) to the 4-byte display code used by the JOIN cccii workstations.
is_stop_on_map	boolean	false	Specifies whether the system should NOT check the rest of the lines in the map file once a match is found. By default each line of the incoming file is checked against all lines of the m2bmap file.

m2bmap_entry

Each row of m2bmap_entry contains the conversion strings applied during a database conversion to change the data contained in MARC fields in an incoming record to new data in a target record.

Column	Data Type	Not NULL?	Comment
id	int	false	System-generated sequential ID.
m2bmap_category_id	int	false	Foreign key to m2bmap_category.
display_order	int	false	Integer to manage the display order of a list.
comparison	varchar	false	Literal string and/or a regular expression to search for; if found, the line will be replaced.
replacement	varchar	false	Literal string and/or an expression specifying how to replace the line that was found by the comparison expression search.

marc_export_format

Each row of marc_export_format identifies a MARC export category.

Column	Data Type	Not NULL?	Comment
id	bigint	false	System-generated sequential ID.
code	varchar	false	MARC export category code.
code_name	varchar	false	MARC export category code name.
is_staff_enabled	boolean	false	Identifies MARC export categories enabled for staff use.

marc_preference

Each row of marc_preference identifies a per-user bib-to-MARC preference.

Column	Data Type	Not NULL?	Comment
id	bigint	false	System-generated sequential ID.
iii_user_name	varchar	false	Specifies the user name for the preference settings.
diacritic_category_id	int	false	Foreign key to diacritic_category.
marc_export_format_id	bigint	false	Foreign key to marc_export_format.
b2m_category_code	varchar	false	Bib to MARC export category code.
is_default_preference	boolean	false	Specifies whether the settings are the default preference for the user name.