Bibliographic Record Fixed Length Field Definitions (Sierra)
The following information describes the fixed-length fields found in bibliographic records.
Bibliographic Record Fields for MLN1 Libraries
When choosing the Field for Create Lists, numbers are associated with the Fixed-Length Fields.
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
| 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 |
Note: Pink is an alert color for “invalid” fields. In a template it indicates a default value is missing. Fixed-length fields should always have a default value (e.g. ‘-‘ ) and should not be left blank. White mean that the fields are editable and have a valid content.
Sierra DNA for Record Properties (MLN1 & MLN2)
The following fixed-length fields are found using Sierra DNA. Each row of bib_record_property contains primary descriptive data from a specific bib record.
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:
|
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:
|
B012 best_author_norm
| varchar | false | The normalized version of the most authoritative available representation of the author's name |
Bibliographic Record Fields for MLN2 Libraries
When choosing the Field for Create Lists, numbers are associated with the Fixed Fields. For fixed-length fields B001 - B012, see Sierra DNA for Record Properties (MLN1 & MLN2).
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
| 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 |
Related Documentation
-
Delete a Patron Record (Sierra) (Marmot Knowledge Base)
-
Editing a Patron Record (Check Out (Circulation Desk)) (Sierra) (Marmot Knowledge Base)
-
Save and Load Change Commands (Global Update) (Marmot Knowledge Base)
-
Remove Records from a Review File (Global Update) (Marmot Knowledge Base)
-
Patron Record Fixed Length Field Definitions (Sierra) (Marmot Knowledge Base)
-
Clearing Count Use Numbers from Item Records (Global Update) (Marmot Knowledge Base)
-
Merging Duplicate Patron Records (Sierra) (Marmot Knowledge Base)
-
Delete Records Function (Sierra) (Marmot Knowledge Base)
-
Change Patron Expiration Date (Global Update) (Marmot Knowledge Base)
-
Adding a Message to Item Records (Global Update) (Marmot Knowledge Base)
-
View Review File Information (Global Update) (Marmot Knowledge Base)
-
Command Type Fields (Global Update) (Marmot Knowledge Base)
-
Change Item Status (Global Update) (Marmot Knowledge Base)
-
Service/Topic and Roles Label Key (Marmot Knowledge Base)
-
Patron Record Variable-length Fields (Sierra) (Marmot Knowledge Base)