Bibliographic Record Fixed Length Field Definitions (Sierra)

Field Number

Field Label

Description

Code is

Data in Field Entered by

Limits

024

LANG

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

Alphanumeric

The system uses MARC language codes, which you can augment.

Maximum of 800 language codes.

Maximum code length: 3 characters

025

SKIP

The number of characters should be skipped before sorting on the TITLE field (including the space).

If specified in the default template, SKIP may be prompted when new orders are entered. This enables a title to be joined with the first article in place while ensuring that the article will be ignored during indexing.

The system uses the value in the second indicator position in the 245 field for records transmitted from a bibliographic utility.

Numeric

The system automatically supplies the SKIP. code for English language articles (a, an, the).

You must supply the SKIP code for foreign language articles.

See Initial Articles: Coordinating Cataloging Practices with User Searches for more information.

a Maximum code length of 1 character

026

LOCATION

Shelving location or branch.

For multiple locations, see the variable-length field LOCATIONS.

The same set of codes is used for the LOCATION field recorded in the bibliographic, item, order, and check-in records.

NOTE: If you are using the system for cataloging, the use of LOCATION codes is determined by the MLN1 cataloging policy.

Your organization defines the codes, which are stored in one file for use in bibliographic, order, item, check-in, patron, and course records. (In patron records, the codes are used in the HOME LIBR field.)

Lowercase alphabetic or numeric

Marmot

The Maximum number of codes is 10,000.

The maximum code length is 5 characters

The Maximum length of code definitions is 25 characters

Maximum 100 LOCATION fields in one order record.

028

CAT DATE

Cataloging date

Month-day-year (mm-dd-yy or mm-dd-yyyy) or day-month-year (dd-mm-yy or dd-mm-yyyy)

Marmot

A single entry in valid date format

029

BIB LVL

Bibliographic level, based on MARC 21 Leader/07 values or UNIMARC Leader/07 values.

Alphanumeric

Marmot

The maximum code length: 1 character

The maximum number of codes: 32 for each field

The maximum length of code definitions: 25 characters

030

MAT TYPE

or Material Type

Material type, such as a book, serial, map, etc., based on MARC 21 Leader/06 values or UNIMARC Leader/07 values.

Alphanumeric

Marmot

Maximum code length:

3 characters 

The maximum number of codes: 500

The maximum length of code definitions: 25 characters

031

SPEC’L USE

Your organization determines the name and purpose of this field, its codes, and the codes' definitions, except the code 'c,' which is used by the system to suppress the display of the order record in the classic catalog.

SPEC’L USE can also be used to mark items for later deletion.

Order record information is automatically suppressed when SPEC’L USE is set to 'n', '1', '2', or '3'.

Alphanumeric

Marmot

• How the SPEC’L Use field affects record display in the catalog 

The maximum code length is 1 character

The maximum number of codes is 32 for each field

The maximum length of code definitions is 25 characters

089

COUNTRY

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

Lowercase alphabetic or numeric

The system uses MARC country codes, which you can augment.

For example 

Fr - France

Cau - U.S. (California)

The maximum of 500 country codes.

The maximum code length is 3 characters

081

RECORD #

The record number associated with the bibliography record.

Alphanumeric

The system generates the record number automatically when the record is created.

N/A

083

CREATED

Date the record was created.

Date

The system generates the created date when the record is created.

N/A

084

UPDATED

Date of the last update to the record. The system updates this field whenever the record is edited or involved in a transaction.

Date

The system

N/A

085

REVISIONS

The number of revisions to the record.

Numeric

The system

N/A

Column

Data Type

Not NULL?

Comment

B0001 

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.

B002

bib_level_code

char

false

Bibliographic level code

B003

material_code

char

false

Identifies the material type code found in the bib record

B004

publish_year

int

false

Specifies the year of publication from the bib record

B005

is_available_at_library

boolean

false

Indicates whether the item is available.

B006

course_record_id

bigint

false

Foreign key to course_record

B007

is_suppressed

boolean

false

Indicates whether the record is suppressed from public display

B008

allocation_rule_code

char

false

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

B009

is_right_result_exact

boolean

false

Controls bib display position in the catalog search results

B010

best_title_norm

varchar

false

Normalized version of the most authoritative available version of the title

B011

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.

B012

best_author_norm

varchar

false

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

Field Number

Field Label

Description

Code is

Data in Field Entered by

Limits

024

LANG

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

Alphanumeric

The system uses MARC language codes, which you can augment.

Maximum of 800 language codes.

Maximum code length: 3 characters

025

SKIP

The number of characters should be skipped before sorting on the TITLE field (including the space).

If specified in the default template, SKIP may be prompted when new orders are entered. This enables a title to be entered with the first article in place while ensuring that the article will be ignored during indexing.

For records transmitted from a bibliographic utility, the system uses the value in the second indicator position in the 245 field.

Numeric

The system automatically supplies the SKIP. code for English language articles (a, an, the).

You must supply the SKIP code for foreign language articles.

See Initial Articles: Coordinating Cataloging Practices with User Searches for more information.

a Maximum code length of 1 character

026

LOCATION

Shelving location or branch.

For multiple locations, see the variable-length field LOCATIONS.

The same set of codes is used for the LOCATION field recorded in the bibliographic, item, order, and check-in records.

NOTE: If you are using the system for cataloging, the use of LOCATION codes is determined by the MLN1 cataloging policy.

Your organization defines the codes, which are stored in one file for use in bibliographic, order, item, check-in, patron, and course records. (In patron records, the codes are used in the HOME LIBR field.)

Lowercase alphabetic or numeric

Marmot,

The Maximum number of codes is 10,000

The maximum code length is 5 characters

The Maximum length of code definitions is 25 characters

Maximum 100 LOCATION fields in one order record.

028

CAT DATE

Cataloging date

Month-day-year (mm-dd-yy or mm-dd-yyyy) or day-month-year (dd-mm-yy or dd-mm-yyyy)

Marmot

A single entry in valid date format

029

BIB LVL

Bibliographic level, based on MARC 21 Leader/07 values or UNIMARC Leader/07 values.

Alphanumeric

Marmot

The maximum code length: 1 character

The maximum number of codes: 32 for each field

The maximum length of code definitions: 25 characters

030

FORMAT

Material type, such as a book, serial, map, etc., based on MARC 21 Leader/06 values or UNIMARC Leader/07 values.

Alphanumeric

Marmot

Maximum code length:

3 characters 

The maximum number of codes: 500

The maximum length of code definitions: 25 characters

031

BCODE3

Your organization determines the name and purpose of this field, its codes, and the codes' definitions, except the code 'c,' which is used by the system to suppress the display of the order record in the classic catalog.

BCODE3 can also be used to mark items for later deletion.

Order record information is automatically suppressed when BCODE3 is set to 'n', '1', '2', or '3'.

Alphanumeric

Marmot

• How the BCODE3 Use field affects record display in the catalog 

The maximum code length is 1 character

The maximum number of codes is 32 for each field

The maximum length of code definitions is 25 characters

089

COUNTRY

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

Lowercase alphabetic or numeric

The system uses MARC country codes, which you can augment.

For example 

Fr - France

Cau - U.S. (California)

The maximum of 500 country codes.

The maximum code length is 3 characters

081

RECORD #

The record number associated with the bibliography record.

Alphanumeric

The system generates the record number automatically when the record is created.

N/A

083

CREATED

Date the record was created.

Date

The system generates the created date when the record is created.

N/A

084

UPDATED

Date of the last update to the record. The system updates this field whenever the record is edited or involved in a transaction.

Date

The system

N/A

085

REVISIONS

The number of revisions to the record.

Numeric

The system

N/A