Authority

authority_record

Each row of authority_record contains the fixed-length data fields for a specific authority record.

Column

Data Type

Not NULL?

Comment

id

bigint

false

System-generated sequential ID.

record_id

bigint

false

Foreign key to record.

marc_type_code

char

false

Code that identifies whether the record is in MARC 21, UNIMARC, UKMARC, or Chinese MARC format. Possible values are:

  • <blank> - MARC 21
  • c - Chinese MARC
  • u - UNIMARC
  • k - UKMARC

code1

char

false

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

code2

char

false

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

suppress_code

char

false

Code specifying whether to display or suppress the authority record. The library determines the name of this field, its codes, and the codes' definitions.

is_suppressed

boolean

false

Specifies whether the authority record is suppressed from public display.

authority_view

Each row of authority_view includes metadata for one authority record. The metadata includes identification information and library-specified authority codes 1 and 2, 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., 'a'.

record_num

int

false

Record number.

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. Possible values include:

  • <blank> - MARC 21
  • c - Chinese MARC
  • u - UNIMARC
  • k - UKMARC

code1

char

false

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

code2

char

false

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

suppress_code

char

false

Display/suppress authority records. The library determines this code and the code's definition.

record_creation_date_gmt

timestamptz

false

Record creation date.

catmaint

Each row of catmaint describes a change made to record headings data in the catalog.

Column

Data Type

Not NULL?

Comment

id

bigint

false

System-generated sequential ID.

is_locked

boolean

false

An integer that specifies whether the catmaintinfo table is in use to prevent concurrent updates. Possible values include: 0 - The table is unlocked and not in use. 1 - The table is locked; view-only access.

is_viewed

boolean

false

An integer that specifies whether the entry has been viewed. Possible values include: 0 - The entry has not been viewed. 1 - The entry has been viewed.

condition_code_num

int

false

An integer that identifies certain headings conditions applicable to the various headings reports. Possible values include:

  • 1 = First time use (specified by the usg_valid_check EO)
  • 2 = Invalid entries
  • 3 = Duplicate call numbers and other conditions (specified by the usg_dup_check EO)
  • 4 = Blind references
  • 5 = Duplicate authority records
  • 6 = Authority updates (written by auth2bib)
  • 7 = Near matches (written by auth2bib)
  • 8 = Busy matches (written by auth2bib)
  • 9 = Non-unique 4XXs (written by auth2bib)
  • 10 = Cross-thesaurus matches (by auth2bib)
  • 11 = Missing Form or Subfield 8
  • 12 = Missing Form 2
  • 13 = Blank bib CAT DATE updated with date value

index_tag

char

false

The itag of an index string (e.g., 'a'=author, 't'=title, 'd'=subject, etc.) for an entry.

index_entry

text

false

The index string for an entry.

record_metadata_id

bigint

false

Foreign key to record_metadata.

statistics_group_code_num

int

false

The statistics group code number associated with the login name that made the change.

process_gmt

timestamptz

false

The time at which an index entry was made.

program_code

varchar

false

A 2 to 5-character code identifying the program used to make the heading entry.

CODE

PROGRAM

a2b

auth2bib

aitem

additem

appge

appget

appr

apprev

dl

dlbibrec

du

dupkill

macq

acquisitions

maitm

acquisitions

map

acquisitions

mcat

cataloging

mcr

circulation

mcu

cataloging (global update)

meeit

editor
milwspatronio patron update web service

mra

cataloging (rapid update)

mser

serials

oclc

marc2inn, oclcconv

ra

rapidup

su

cataloging

 

iii_user_name

varchar

false

The login name used to enter the heading.

one_xx_entry

text

false

The index entry from an authority record. It includes the itag as the first character in the string (e.g., a=author, t=title, d=subject, etc.)

authority_record_metadata_id

bigint

false

Foreign key to authority_record_metadata.

old_field

text

false

The old form of the bibliographic record field, before it was updated by Sierra.

new_240_field

text

false

The updated 240 field of the bibliographic record.

field

text

false

The field that was the source of the entry.

cataloging_date_gmt

timestamptz

false

The cataloging date of the bibliographic record.

index_prev

text

false

The indexed item that precedes the current entry.

index_next

text

false

The indexed item that follows the current entry.

correct_heading

text

false

The standardized heading used to replace non-standard headings.

author

text

false

The author from the record.

title

text

false

The title from the record.

phrase_entry_id

bigint

false

Foreign key to phrase_entry.

user_defined_acode1_myuser

Each row of user_defined_acode1_myuser identifies a user-defined fixed-length field for authority 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_acode2_myuser

Each row of user_defined_acode2_myuser identifies a user-defined fixed-length field for authority 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.