Bib

bib_level_property

Each row of bib_level_property identifies a bib level code.

Column

Data Type

Not NULL?

Comment

id

int

false

System-generated sequential ID.

code

varchar

false

Bib level code.

display_order

int

false

Integer to manage the display order of a list.

bib_level_property_myuser

Each row of bib_level_property_myuser identifies a bibliographic level (based on MARC 21 Leader/07 values or UNIMARC Leader/07 values), with the name presented in the language associated with the user's login account. Possible codes and names include:

CODE

NAME

a

monographic component part

b

serial component part

c

collection

d

subunit

i

integrating resource

m

monograph/item

s

serial

 

Column

Data Type

Not NULL?

Comment

code

varchar

false

Bibliographic level code.

display_order

int

false

Integer to manage the display order of a list.

name

varchar

false

Bibliographic level name.

bib_level_property_name

Each row of bib_level_property_name identifies a bib level name.

Column

Data Type

Not NULL?

Comment

bib_level_property_id

int

false

Foreign key to bib_level_property.

iii_language_id

int

false

Foreign key to iii_language.

name

varchar

false

Bib level name.

bib_record

Each row of bib_record contains data fields for a specific bibliographic record.

Column

Data Type

Not NULL?

Comment

id

bigint

false

System-generated sequential ID.

record_id

bigint

false

Foreign key to record.

language_code

varchar

false

Code representing the language of the material, based on the MARC 21 Code List for Languages (also used by UNIMARC format).

bcode1

char

false

The library determines the name and purpose of this code and the code's definition.

bcode2

char

false

The library determines the name and purpose of this code and the code's definition.

bcode3

char

false

The library determines the name and purpose of this code and the code's definition.

 

EXCEPTION - The system uses bcode3 'c' to suppress the display of the associated order record in the public catalog.

country_code

varchar

false

Code representing the country of publication, based on the MARC 21 Code List of Countries, or ISO 3166/MA standard for UNIMARC systems.

index_change_count

int

false

The number of changes to record indexing.

is_on_course_reserve

boolean

false

Indicates whether the bib is on course reserve.

is_right_result_exact

boolean

false

Controls bib display position in the catalog search results.

allocation_rule_code

char

false

Code representing the rules for single-copy multi-fund orders.

skip_num

int

false

The number of characters that should be skipped before sorting on the TITLE field (including the space). This field is used only in non-MARC records.

cataloging_date_gmt

timestamp

false

The date the record was added to the cataloging database.

marc_type_code

char

false

Identifies whether the record is in MARC 21, Chinese MARC, UNIMARC, or UKMARC format. Used in organizations with authority records in formats other than MARC 21.

CODE

DEFINITION

<blank>

MARC 21

c

Chinese MARC

u

UNIMARC

k

UKMARC

 

is_suppressed

boolean

false

Indicates whether the record is suppressed from public display.

bib_record_call_number_prefix

Each row of bib_record_call_number_prefix identifies a bibliographic record and its associated call number prefix.

Column

Data Type

Not NULL?

Comment

id

bigint

false

System-generated sequential ID.

bib_record_id

bigint

false

Foreign key to bib_record.

call_number_prefix

varchar

false

Call number prefix.

bib_record_location

Each row of bib_record_location identifies the shelving location or branch code associated with a bibliographic record.

Column

Data Type

Not NULL?

Comment

id

bigint

false

System-generated sequential ID.

bib_record_id

bigint

false

Foreign key to bib_record.

copies

int

false

Number of copies.

location_code

varchar

false

Shelving location or branch code.

display_order

int

false

Integer to manage the display order of a list.

bib_record_property

Each row of bib_record_property contains primary descriptive data from a specific bib record.

Column

Data Type

Not NULL?

Comment

id

int

false

System-generated sequential ID.

bib_record_id

bigint

false

Foreign key to bib_record.

best_title

varchar

false

The most authoritative available version of the title.

The system uses the following criteria to determine the best title, in order of precedence:

  1. The first t-tagged MARC 245 field, subfields a, b, g, h, n, p.
  2. The first t-tagged non-MARC field.
  3. The first t-tagged MARC field other than 245, any subfields indexed for the t index display.

bib_level_code

char

false

Bibliographic level code.

material_code

char

false

Identifies the material type code found in the bib record.

publish_year

int

false

Specifies the year of publication from the bib record.

best_title_norm

varchar

false

Normalized version of the most authoritative available version of the title.

best_author

varchar

false

The most authoritative available representation of the author's name.

The system uses the following criteria to determine the best author, in order of precedence:

  1. The first a-tagged MARC 1XX field.
  2. The first b-tagged MARC 7XX field.
  3. The first a-tagged MARC 7XX field.
  4. The first a-tagged non-MARC field.

best_author_norm

varchar

false

The normalized version of the most authoritative available representation of the author's name.

bib_view

Each row of bib_view includes metadata for one bibliographic record. The metadata includes identification and status information, as well as data that determines how the system handles the record.

Column

Data Type

Not NULL?

Comment

id

bigint

false

System-generated sequential ID.

record_type_code

char

false

Record type code, i.e., 'b'.

record_num

int

false

Record number.

language_code

varchar

false

Language of the material. LANG is based on the MARC 21 Code List for Languages (also used by UNIMARC format).

bcode1

char

false

The library determines the name and purpose of this code and the code's definition.

bcode2

char

false

The library determines the name and purpose of this code and the code's definition.

bcode3

char

false

The library determines the name and purpose of this code and the code's definition.

 

EXCEPTION - The system uses bcode3 'c' to suppress the display of the associated order record in the public catalog.

country_code

varchar

false

Country of publication. COUNTRY is based on the MARC 21 Code List of Countries, or ISO 3166/MA standard for UNIMARC systems.

is_available_at_library

boolean

false

Indicates whether the item is available.

index_change_count

int

false

The number of changes to record indexing.

allocation_rule_code

char

false

Code that specifies rules for single-copy multi-fund orders.

is_on_course_reserve

boolean

false

Indicates whether the bib is on course reserve.

is_right_result_exact

boolean

false

Controls bib display position in the catalog search results.

skip_num

int

false

The number of characters that should be skipped prior to sorting on the TITLE field (including the space). This field is used only in non-MARC records.

cataloging_date_gmt

timestamp

false

Cataloging date.

marc_type_code

char

false

Identifies whether the record is in MARC 21, Chinese MARC, UNIMARC, or UKMARC format. Used in organizations with authority records in formats other than MARC 21.

CODE

DEFINITION

<blank>

MARC 21

c

Chinese MARC

u

UNIMARC

k

UKMARC

 

title

varchar

false

The title from the bibliographic record.

record_creation_date_gmt

timestamptz

false

Date on which the record was created.

course_record_bib_record_link

Each row of course_record_bib_record_link identifies a linked course and bibliographic record pair.

Column

Data Type

Not NULL?

Comment

id

bigint

false

System-generated sequential ID.

course_record_id

bigint

false

Foreign key to course_record.

bib_record_id

bigint

false

Foreign key to bib_record.

status_change_date

timestamptz

false

Date on which the status code changed

status_code

varchar

false

Status code of an item placed on course reserve. For example:

  • a - active
  • i - inactive

bibs_display_order

int

false

Integer to manage the display order of a bibliographic record list.

course_view

Each row of course_view includes metadata and data for one course record. The contents include identification, descriptive information, and library-specified course codes 1-3, as well as data that determines how the system handles the record.

Column

Data Type

Not NULL?

Comment

id

bigint

false

System-generated sequential ID.

record_type_code

char

false

Record type code, i.e., 'r'.

record_num

int

false

Record number.

begin_date

timestamptz

false

The date on which the course begins.

end_date

timestamptz

false

The date on which the course ends.

location_code

varchar

false

The code for the physical location of the items placed on reserve.

ccode1

varchar

false

The library determines the name and purpose of this code and the code's definition.

ccode2

varchar

false

The library determines the name and purpose of this code and the code's definition.

ccode3

varchar

false

The library determines the name and purpose of this code and the code's definition.

record_creation_date_gmt

timestamptz

false

Record creation date.

itype_property_category_myuser

Each row of itype_property_category_myuser identifies an ITYPE, with the name/description presented in the language associated with the user's login account. Each library maintains its own ITYPE category names.

Column

Data Type

Not NULL?

Comment

code

int

false

ITYPE category code.

display_order

int

false

Integer to manage the display order of a list.

itype_property_category_id

int

false

Foreign key to itype_property_category.

physical_format_id

int

false

Foreign key to physical_format.

target_audience_id

int

false

Foreign key to target_audience.

name

varchar

false

ITYPE category name.

material_property_category

Each row of material_property_category identifies a material category.

Column

Data Type

Not NULL?

Comment

id

int

false

System-generated sequential ID.

display_order

int

false

Integer to manage the display order of a list.

is_default

boolean

false

Identifies the default category.

material_property_category_myuser

Each row of material_property_category_myuser defines a material category, with the name presented in the language associated with the user's login account. Each library maintains its own material category names.

Column

Data Type

Not NULL?

Comment

code

varchar

false

Material category code.

display_order

int

false

System-generated sequential ID.

is_default

boolean

false

Identifies the default category.

name

varchar

false

Material category name.

material_property_category_name

Each row of material_property_category_name identifies a material category name.

Column

Data Type

Not NULL?

Comment

material_property_category_id

int

false

Foreign key to material_property_category.

name

varchar

false

Material category name.

iii_language_id

int

false

Foreign key to iii_language.

material_property_myuser

Each row of material_property_myuser identifies a material type (based on MARC 21 Leader/06 values or UNIMARC Leader/07 values), with the name presented in the language associated with the user's login account. Standard (English) codes and names include:

CODE

NAME

a

language material

c

notated music

d

manuscript notated music

e

cartographic material

f

manuscript cartographic material

g

projected medium

i

nonmusical sound recording

k

two-dimensional nonprojectable graphic

m

computer file

o

kit

p

mixed material

r

three-dimensional artifact or naturally occurring object

t

manuscript language material

 

Column

Data Type

Not NULL?

Comment

code

varchar

false

Material type code.

display_order

int

false

Integer to manage the display order of a list.

is_public

boolean

false

Specifies whether the entry appears in public interfaces.

material_property_category_id

int

false

Foreign key to material_property_category.

physical_format_id

int

false

Foreign key to physical_format.

name

varchar

false

Material type name.

material_property_name

Each row of material_property_name identifies a material type name.

Column

Data Type

Not NULL?

Comment

material_property_id

int

false

Foreign key to material_property.

iii_language_id

int

false

Foreign key to iii_language.

name

varchar

false

Material type name.

facet_text

varchar

false

The text applied to the associated Encore facet.

user_defined_bcode1_myuser

Each row of user_defined_bcode1_myuser identifies a user-defined fixed-length field for bibliographic records.

Column

Data Type

Not NULL?

Comment

code

varchar

false

User-defined code to represent the user-defined field.

user_defined_category_id

int

false

Foreign key to user_defined_category.

display_order

int

false

Integer to manage the display order of a list.

name

varchar

false

The user-defined name assigned to the user-defined field.

user_defined_bcode2_myuser

Each row of user_defined_bcode2_myuser identifies a user-defined fixed-length field for bibliographic records.

Column

Data Type

Not NULL?

Comment

code

varchar

false

User-defined code to represent the user-defined field.

user_defined_category_id

int

false

Foreign key to user_defined_category.

display_order

int

false

Integer to manage the display order of a list.

name

varchar

false

The user-defined name assigned to the user-defined field.

user_defined_bcode3_myuser

Each row of user_defined_bcode3_myuser identifies a user-defined fixed-length field for bibliographic records.

Column

Data Type

Not NULL?

Comment

code

varchar

false

User-defined code to represent the user-defined field.

user_defined_category_id

int

false

Foreign key to user_defined_category.

display_order

int

false

Integer to manage the display order of a list.

name

varchar

false

The user-defined name assigned to the user-defined field.