Generic Record

control_field

Each row of control_field contains the variable-length field data for a specific record.

Column

Data Type

Not NULL?

Comment

id

bigint

false

System-generated sequential ID.

record_id

bigint

false

Foreign key to record.

varfield_type_code

char

false

III variable-length field type tag.

control_num

int

false

MARC 21 control field number 6, 7, or 8. (Corresponds to MARC field 006, 007, or 008.)

p00

char

false

The data content at the corresponding leader position.

p01

char

false

The data content at the corresponding leader position.

p02

char

false

The data content at the corresponding leader position.

p03

char

false

The data content at the corresponding leader position.

p04

char

false

The data content at the corresponding leader position.

p05

char

false

The data content at the corresponding leader position.

p06

char

false

The data content at the corresponding leader position.

p07

char

false

The data content at the corresponding leader position.

p08

char

false

The data content at the corresponding leader position.

p09

char

false

The data content at the corresponding leader position.

p10

char

false

The data content at the corresponding leader position.

p11

char

false

The data content at the corresponding leader position.

p12

char

false

The data content at the corresponding leader position.

p13

char

false

The data content at the corresponding leader position.

p14

char

false

The data content at the corresponding leader position.

p15

char

false

The data content at the corresponding leader position.

p16

char

false

The data content at the corresponding leader position.

p17

char

false

The data content at the corresponding leader position.

p18

char

false

The data content at the corresponding leader position.

p19

char

false

The data content at the corresponding leader position.

p20

char

false

The data content at the corresponding leader position.

p21

char

false

The data content at the corresponding leader position.

p22

char

false

The data content at the corresponding leader position.

p23

char

false

The data content at the corresponding leader position.

p24

char

false

The data content at the corresponding leader position.

p25

char

false

The data content at the corresponding leader position.

p26

char

false

The data content at the corresponding leader position.

p27

char

false

The data content at the corresponding leader position.

p28

char

false

The data content at the corresponding leader position.

p29

char

false

The data content at the corresponding leader position.

p30

char

false

The data content at the corresponding leader position.

p31

char

false

The data content at the corresponding leader position.

p32

char

false

The data content at the corresponding leader position.

p33

char

false

The data content at the corresponding leader position.

p34

char

false

The data content at the corresponding leader position.

p35

char

false

The data content at the corresponding leader position.

p36

char

false

The data content at the corresponding leader position.

p37

char

false

The data content at the corresponding leader position.

p38

char

false

The data content at the corresponding leader position.

p39

char

false

The data content at the corresponding leader position.

p40

char

false

The data content at the corresponding leader position.

p41

char

false

The data content at the corresponding leader position.

p42

char

false

The data content at the corresponding leader position.

p43

char

false

The data content at the corresponding leader position.

occ_num

int

false

The occurrence number of the field among other fields with the same tag.

remainder

varchar

false

The data content following the leader.

fixfld_type

Each row of fixfld_type identifies a fixed-length field type code.

Column

Data Type

Not NULL?

Comment

id

int

false

System-generated sequential ID.

code

varchar

false

Fixed-length field type code.

display_order

int

false

Integer to manage the display order of a list.

record_type_code

char

false

Record type code, such as 'a', 'b', 'i', and so on.

is_enabled

boolean

false

Specifies whether the fixed-length field is enabled for the associated record type.

fixfld_type_myuser

Each row of fixfld_type_myuser identifies a fixed-length data field (fixfld), with the name presented in the language associated with the user's login account. Each library maintains its own fixed-length field names.

Column

Data Type

Not NULL?

Comment

code

varchar

false

Fixfld code.

display_order

int

false

Integer to manage the display order of a list.

name

varchar

false

Fixfld name.

fixfld_type_name

Each row of fixfld_type_name identifies a fixed-length field type name.

Column

Data Type

Not NULL?

Comment

fixfld_property_id

int

false

Foreign key to fixfld_property.

iii_language_id

int

false

Foreign key to iii_language.

name

varchar

false

Fixed-length field type name.

leader_field

Each row of leader_field contains standard MARC data from the leader field of a record.

Column

Data Type

Not NULL?

Comment

id

bigint

false

System-generated sequential ID.

record_id

bigint

false

Foreign key to record.

record_status_code

char

false

MARC standard status code. (Refer to http://www.loc.gov/marc/)

record_type_code

char

false

MARC standard record type code. (Refer to http://www.loc.gov/marc/)

bib_level_code

char

false

MARC standard bibliographic level code. (Refer to http://www.loc.gov/marc/)

control_type_code

char

false

MARC standard type of control code. (Refer to http://www.loc.gov/marc/)

char_encoding_scheme_code

char

false

MARC standard character coding scheme. (Refer to http://www.loc.gov/marc/)

encoding_level_code

char

false

MARC standard encoding level code. (Refer to http://www.loc.gov/marc/)

descriptive_cat_form_code

char

false

MARC standard descriptive cataloging form code. (Refer to http://www.loc.gov/marc/)

multipart_level_code

char

false

MARC standard multipart resource record level. (Refer to http://www.loc.gov/marc/)

marclabel_type

Each row of marclabel_type identifies a MARC label type.

Column

Data Type

Not NULL?

Comment

id

bigint

false

System-generated sequential ID.

record_type_code

char

false

III record type code.

varfield_type_code

varchar

false

Variable-length field type code.

marc_tag_pattern

varchar

false

Regular expression describing the MARC tag pattern.

display_order

int

false

Integer to manage the display order of a list.

marclabel_type_myuser

Each row of marclabel_type_myuser identifies a MARC label type, with the name presented in the language associated with the user's login account.

Column

Data Type

Not NULL?

Comment

record_type_code

char

false

III record type code.

varfield_type_code

varchar

false

Variable-length field type code.

marctag_pattern

varchar

false

Regular expression describing the MARC tag pattern.

display_order

int

false

Integer to manage the display order of a list.

name

varchar

false

MARC label type name.

marclabel_type_name

Each row of marclabel_type_name identifies a MARC label type name.

Column

Data Type

Not NULL?

Comment

marclabel_type_id

bigint

false

Foreign key to marclabel_type.

iii_language_id

bigint

false

Foreign key to iii_language.

name

varchar

false

MARC label type name.

phrase_entry

Each row of phrase_entry defines a phrase index entry.

USE WITH CAUTIO! The contents of this view are subject to change through system development and enhancement. However, the presentation of SkyRiver, OCLC, and barcode number data will remain stable.

Column

Data Type

Not NULL?

Comment

id

bigint

false

System-generated sequential ID.

record_id

bigint

false

Foreign key to record_metadata; the system-generated ID of the phrase entry's source record.

index_tag

varchar

false

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

varfield_type_code

varchar

false

The tag of the variable-length field to index.

occurrence

int

false

The occurrence number of the entry within like fields in the record, plus one.

is_permuted

boolean

false

Specifies whether the text string is permuted. (Only meaningful for subject entries.)

type2

int

false

An integer used for sorting index entries in the browse display:

Bib records - The ASCII value of the first character of the title.

Authority records:

  • 00 - valid form MARC 1xx
  • 01 - "see" form MARC 4xx
  • 02 - "see also" form MARC 5xx

NOTES

  • See-references file before titles. 400 fields with a subfield |t are handled exactly like bib records (i.e., type2 contains the first character of the title from subfield |t).
  • If Index Rule 12 (reverse_by_date) is set to a value other than '0' (false), the CAT DATE field determines the first two bytes. The system uses these bytes for reverse sorting.
  • If the first character of a bib record title is an opening curly brace ('{'), then the type2 value is the character immediately following the brace (e.g., if the title were {213467}, then the type2 value would be '2').

type3

char

false

The suppression code:

Authority records:

  • 'n' - suppress from public display
  • '1' - unsuppressed valid form
  • '2' - unsuppressed 'see' form
  • '3' - unsuppressed 'see also' form

Bib records:

  • 'n' - suppress from public display
  • ' ' - (blank) do not suppress

NOTE: An 'n' implies that the bibliographic record meets suppression criteria as specified by suppression rules.

index_entry

varchar

false

The index entry string.

insert_title

varchar

false

A normalized form of the title used to sort index entries.

phrase_rule_rule_num

int

false

The number of the index normalization rule applied to this entry.

phrase_rule_operation

varchar

false

One of the following one-letter codes:

Code

Description
A Keep only the subfields following the 'A', but index them only if ALL of the listed subfields appear in the field. Used at COARL sites to index the 's' and '4' subfields only when both are present in virtual record fields.

E

Index every occurrence of the subfield following the 'E'

K

Keep only the subfields following the 'K'

L

Used to index the linking subfield 1 in UNIMARC or Chinese MARC 4xx fields (similar to linking subfields in USMARC 7xx fields). An example of such a 4xx field is:

f410 0|12001 |aLibrary and information science|17021|aBorko,|bHarold
       ^subfield 1                             ^subfield 1

Note that the data following the two '1' subfields contain the MARC tags and all indicators and subfields for the linked fields. In this example, to index the 200 tag in the t-tagged title index and use subfield codes acdeipvh, use the following entry:

b|f|410|L200:Kacdeipvh|t|9|

The colon after the 'L200' is used to delimit the subsequent subfield codes.

R

Remove only the subfields following the 'R'.

If no subfields are listed, that is, null, index any subfields found, or in the case of non-MARC fields, no subfields.

 

phrase_rule_subfield_list

varchar

false

The MARC subfields indexed in the associated phrase rule.

original_content

varchar

false

The non-normalized version of the index entry string.

parent_record_id

bigint

false

The system-generated ID of the parent of the phrase entry's source record.

insert_title_tag

varchar

false

The itag of the field from which the insert title was taken.

insert_title_occ

int

false

The occurrence number from which the insert title was taken.

phrase_rule

Each row of phrase_rule defines a phrase indexing rule.

Column

Data Type

Not NULL?

Comment

id

bigint

false

System-generated sequential ID.

record_type_code

char

false

The type of record in which the field occurs, such as b = bibliographic, i = item, and so on.

varfield_type_code

varchar

false

The tag of the variable-length field to index.

marc_tag_pattern

varchar

false

The MARC tags and indicators for the field to index in the format <MARC tag><indicator1><indicator2>. A period ('.') is used as a wildcard. For example:

Example

Interpretation
? non-MARC field

...

any MARC field

400.0

400 field with any first indicator & second indicator = 0

200..

200 field with any first and any second indicators

100

100 field; ignore indicators

In addition, indexing of another MARC tag which is linked to the specified MARC tag may be requested here. This is used, for example, to index both the alternate character set representation of Chinese MARC 880 tags AND the Romanized representation of the same information as contained in a linked MARC tag. In this case, the MARC tag field is expanded to include the subfield code (preceded by a period) and the MARC tag to which the link is attached as in the following:

<MARC tag><indicator1><indicator2>.<subfield><linked MARC tag>

As an example, to index a MARC 880 tag which is linked to a MARC 245 tag:

880...6245

This will direct that 880 tags with any first and any second indicators with a subfield tag of '6' are to be indexed together with the Romanized representation in MARC tag field 245.

operation

varchar

false

One of the following one-letter codes:

Code

Description

A

RLS 2000-D & LATER Keep only the subfields following the 'A', but index them only if ALL of the listed subfields appear in the field. Used at COARL sites to index the 's' and '4' subfields only when both are present in virtual record fields.

E

Index every occurrence of the subfield following the 'E'

K

Keep only the subfields following the 'K'

L

Used to index the linking subfield 1 in UNIMARC or Chinese MARC 4xx fields (similar to linking subfields in USMARC 7xx fields). An example of such a 4xx field is:

f410 0|12001 |aLibrary and information science|17021|aBorko,|bHarold
       ^subfield 1                             ^subfield 1

Note that the data following the two '1' subfields contain the MARC tags and all indicators and subfields for the linked fields. In this example, to index the 200 tag in the t-tagged title index and use subfield codes acdeipvh, use the following entry:

b|f|410|L200:Kacdeipvh|t|9|

The colon after the 'L200' is used to delimit the subsequent subfield codes.

R

Remove only the subfields following the 'R'.

If no subfields are listed, that is, null, index any subfields found, or in the case of non-MARC fields, no subfields.

 

subfield_list

varchar

false

The MARC subfields to index.

phrase_type_code

varchar

false

The index in which to place data from this field and/or subfield. Use a capital letter to indicate a Keyword index.

rule_num

int

false

The number of the index normalization rule to apply to this field and/or subfield.

is_continue

boolean

false

Specifies whether the rule is a continuation line. The continuation specification is needed only when the MARC tags of the two lines match exactly, including the indicator, if any. (Thus, 400 and 400.0 are not continuations.)

display_order

int

false

Integer to manage the display order of a list.

phrase_type

Each row of phrase_type identifies a phrase index type.

Column

Data Type

Not NULL?

Comment

id

bigint

false

System-generated sequential ID.

record_type_code

char

false

Record type code:

CODE     

RECORD TYPE

b

bibliographic

o

order

c

holdings (checkin)

a

authority

i

item

p

patron

r

course

v

vendor

e

resource

l

license

t

contact

n

invoice

g

program

s

section

j

volume

 

varfield_type_code

char

false

III variable-length field type tag.

display_order

int

false

Integer to manage the display order of a list.

phrase_type_name

Each row of phrase_type_name identifies the name of a phrase index type.

Column

Data Type

Not NULL?

Comment

phrase_type_id

bigint

false

Foreign key to phrase_type.

iii_language_id

bigint

false

Foreign key to iii_language.

name

varchar

false

The phrase index type name.

plural_name

varchar

false

Plural form of the phrase index type name.

record_metadata

Each row of record_metadata contains metadata for a specific record.

Column

Data Type

Not NULL?

Comment

id

bigint

false

System-generated sequential ID.

record_type_code

char

false

Record type code:

CODE 

RECORD TYPE

b

bibliographic

o

order

c

holdings (checkin)

a

authority

i

item

p

patron

r

course

v

vendor

e

resource

l

license

t

contact

n

invoice

g

program

s

section

j

volume

 

record_num

int

false

Record number.

creation_date_gmt

timestamptz

false

Date the record was created.

deletion_date_gmt

date

false

Date the record was deleted.

campus_code

varchar

false

Campus code.

agency_code_num

int2

false

Agency code number.

num_revisions

int

false

Number of revisions to the record.

record_last_updated_gmt

timestamp

false

Date the record was last updated.

previous_last_updated_gmt

timestamp

false

Date the record was updated prior to the last update.

record_range

Each row of record_range defines a range of record numbers.

Column

Data Type

Not NULL?

Comment

id

bigint

false

System-generated sequential ID.

record_type_code

char

false

Record type code:

CODE     

RECORD TYPE

b

bibliographic

o

order

c

holdings (checkin)

a

authority

i

item

p

patron

r

course

v

vendor

e

resource

l

license

t

contact

n

invoice

g

program

s

section

j

volume

 

accounting_unit_code_num

int

false

Code number of the accounting unit associated with the range of records.

start_num

int

false

Starting record number of record range.

last_num

int

false

Highest allocated record number in the range.

current_count

int

false

Number of non-deleted records in the range.

deleted_count

int

false

Number of deleted records in the range.

max_num

int

false

Maximum number of records allowed in this range.

size

int

false

Maximum allocatable number of records.

record_type

Each row of record_type identifies a record type.

Column

Data Type

Not NULL?

Comment

id

int

false

System-generated sequential ID.

code

char

false

Record type code

tag

char

false

III record type tag.

record_type_myuser

Each row of record_type_myuser identifies a record type, with the name presented in the language associated with the user's login account. Standard (English) codes and names include:

STD CODE

RECORD TYPE

TAG

a

AUTHORITY

%

b

BIBLIOGRAPHIC

"

c

HOLDINGS (CHECKIN)

$

e

RESOURCE

@

i

ITEM

&

l

LICENSE

:

n

INVOICE

)

o

ORDER

#

p

PATRON

'

r

COURSE

(

t

CONTACT

;

v

VENDOR

+

 

Column

Data Type

Not NULL?

Comment

code

char

false

Record type code.

tag

char

false

III record type tag.

name

varchar

false

Record type name.

record_type_name

Each row of record_type_name identifies a record type name.

Column

Data Type

Not NULL?

Comment

record_type_id

int

false

Foreign key to record_type.

name

varchar

false

Record type name.

iii_language_id

int

false

Foreign key to iii_language.

subfield

Each row of subfield identifies and describes a record data subfield.

Column

Data Type

Not NULL?

Comment

record_id

bigint

false

Foreign key to record.

varfield_id

bigint

false

Foreign key to varfield.

field_type_code

char

false

III field type tag.

marc_tag

varchar

false

MARC tag.

marc_ind1

char

false

First MARC indicator.

marc_ind2

char

false

Second MARC indicator.

occ_num

int

false

The occurrence number of the field among other fields with the same tag.

display_order

int

false

System-generated sequential ID.

tag

char

false

The subfield identifier tag.

content

varchar

false

The subfield data.

subfield_view

Each row of subfield_view includes data for one subfield. The data includes both identifying metadata and field content.

Column

Data Type

Not NULL?

Comment

record_id

bigint

false

Foreign key to record.

record_type_code

char

false

Record type code.

STD CODE     

RECORD TYPE     

a

AUTHORITY

b

BIBLIOGRAPHIC

c

HOLDINGS (CHECKIN)

e

RESOURCE

i

ITEM

l

LICENSE

n

INVOICE

o

ORDER

p

PATRON

r

COURSE

t

CONTACT

v

VENDOR

record_num

int

false

Record number.

varfield_id

bigint

false

Foreign key to varfield.

field_type_code

char

false

III field type tag.

marc_tag

varchar

false

MARC tag.

marc_ind1

char

false

First MARC indicator.

marc_ind2

char

false

Second MARC indicator.

occ_num

int

false

The occurrence number of the field among other fields with the same tag. Used when a record contains more than one field of the same type.

display_order

int

false

Integer to manage the display order of a list.

tag

char

false

Subfield tag.

content

varchar

false

Content of the subfield.

varfield

Each row of varfield contains data for a specific variable-length field.

Column

Data Type

Not NULL?

Comment

id

bigint

false

System-generated sequential ID.

record_id

bigint

false

Foreign key to record.

varfield_type_code

char

false

III variable-length field type tag.

marc_tag

varchar

false

MARC tag.

marc_ind1

char

false

First MARC indicator.

marc_ind2

char

false

Second MARC indicator.

occ_num

int

false

Occurrence number. Used when a record contains more than one field of the same type.

field_content

varchar

false

Content of the field.

varfield_type

Each row of varfield_type identifies a variable-length field type.

Column

Data Type

Not NULL?

Comment

id

bigint

false

System-generated sequential ID.

record_type_code

char

false

Record type code.

STD CODE     

RECORD TYPE     

a

AUTHORITY

b

BIBLIOGRAPHIC

c

HOLDINGS (CHECKIN)

e

RESOURCE

i

ITEM

l

LICENSE

n

INVOICE

o

ORDER

p

PATRON

r

COURSE

t

CONTACT

v

VENDOR

 

code

char

false

III tag identifying the variable-length field.

marc_tag

varchar

false

MARC tag.

is_enabled

boolean

false

Specifies whether the variable-length field type is enabled for the record type that appears in the record_type_code column.

display_order

int

false

Integer to manage the display order of a variable-length field list.

varfield_type_name

Each row of varfield_type_name identifies a variable-length field name.

Column

Data Type

Not NULL?

Comment

varfield_type_id

bigint

false

Foreign key to varfield_type.

iii_language_id

bigint

false

Foreign key to iii_language.

short_name

varchar

false

Short name for the variable-length field type.

name

varchar

false

Full variable-length field type name.

varfield_view

Each row of varfield_view includes metadata and field content for one variable-length field of one record.

Column

Data Type

Not NULL?

Comment

id

bigint

false

System-generated sequential ID.

record_id

bigint

false

Foreign key to record.

record_type_code

char

false

Record type code.

STD CODE

RECORD TYPE

a

AUTHORITY

b

BIBLIOGRAPHIC

c

HOLDINGS (CHECKIN)

e

RESOURCE

i

ITEM

l

LICENSE

n

INVOICE

o

ORDER

p

PATRON

r

COURSE

t

CONTACT

v

VENDOR

 

record_num

int

false

Record number.

varfield_type_code

char

false

III variable-length field type tag.

marc_tag

varchar

false

MARC tag.

marc_ind1

char

false

First MARC indicator.

marc_ind2

char

false

Second MARC indicator.

occ_num

int

false

Occurrence number. Used when a record contains more than one field of the same type.

field_content

varchar

false

Content of the field.