Item

bib_record_item_record_link

Each row of bib_record_item_record_link identifies a linked bibliographic and item record pair.

Column

Data Type

Not NULL?

Comment

id

bigint

false

System-generated sequential ID.

bib_record_id

bigint

false

Foreign key to bib_record.

item_record_id

bigint

false

Foreign key to item_record.

items_display_order

int

false

Integer to manage the display order of an items list.

bibs_display_order

int

false

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

course_record_item_record_link

Each row of course_record_item_record_link identifies a linked course and item 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.

item_record_id

bigint

false

Foreign key to item_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:

CODE     

DEFINITION

a

active

i

inactive

 

items_display_order

int

false

Integer to manage the display order of an item 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.

holding_record_item_record_link

Each row of holding_record_item_record_link identifies a linked holdings and item record pair.

NOTE: This view is populated only if the site has acquired the Monographic Holdings product.

Column

Data Type

Not NULL?

Comment

id

bigint

false

System-generated sequential ID.

holding_record_id

bigint

false

Foreign key to holding_record.

item_record_id

bigint

false

Foreign key to item_record.

items_display_order

int

false

Integer to manage the display order of an item list.

item_record

Each row of item_record contains data fields for a specific item record.

Column

Data Type

Not NULL?

Comment

id

bigint

false

System-generated sequential ID.

record_id

bigint

false

Foreign key to record.

icode1

int

false

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

icode2

char

false

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

itype_code_num

int2

false

The type of item. (The library defines item types and codes.)

location_code

varchar

false

The branch location code for the item.

agency_code_num

int2

false

The agency (library or other library-defined entity) that owns the item. (Distinguishes virtual from non-virtual records.)

item_status_code

char

false

Status of the item.

STD CODE

DEFINITION

-

AVAILABLE

m

MISSING

z

CL RETURNED

o

LIB USE ONLY

n

BILLED NOTPAID

$

BILLED PAID

t

IN TRANSIT

!

ON HOLDSHELF

l

LOST

At INN-Reach sites, the following additional codes and definitions are standard:

STD CODE

DEFINITION

@

OFF SITE

#

RECEIVED

%

RETURNED

&

REQUEST

_

REREQUEST

(

PAGED

)

CANCELLED

1

LOAN REQUESTED

 

is_inherit_loc

boolean

false

Specifies whether the record inherits its location from the parent record, if no location is specified for the record.

price

numeric

false

The price of the item.

last_checkin_gmt

timestamp

false

The last check-in date and time for the item.

checkout_total

int

false

A number incremented by the system each time the item is checked out.

renewal_total

int

false

Total number of times the item has been renewed.

last_year_to_date_checkout_total

int

false

Total checkouts for the item previous year-to-date.

year_to_date_checkout_total

int

false

Total checkouts for the item current year-to-date.

is_bib_hold

boolean

false

No longer in use.

copy_num

int

false

Indicates which copy of the title corresponds to the item record.

checkout_statistic_group_code_num

int

false

The statistics group number of the terminal where the item was checked out or renewed.

NOTE:The terminal number for a terminal that logs in over a network can change each time the terminal logs in. If the login's statistical group is set to *, the system will use the actual (changing) terminal number as the terminal number on which to track circulation activity for the purpose of statistics. Alternately, the login's statistical group can be set to a fixed number (for example, 100) and that number will be used as the terminal number, regardless of when or where the login is used.

last_patron_record_metadata_id

bigint

false

Foreign key to record_metadata (for the last patron record).

inventory_gmt

timestamp

false

The date the item was inventoried and found on the shelf.

checkin_statistics_group_code_num

int

false

The statistics group number of the terminal where the item was checked in. This field is updated when a check in unlinks the item record from the patron record. If the item's STATUS is set to t (IN TRANSIT), a check in at the destination location does not update the IN LOC field.

NOTE: The terminal number for a terminal that logs in over a network can change each time the terminal logs in. If the login's statistical group is set to *, the system will use the actual (changing) terminal number as the terminal number on which to track circulation activity for the purpose of statistics. Alternately, the login's statistical group can be set to a fixed number (for example, 100) and that number will be used as the terminal number, regardless of when or where the login is used.

use3_count

int

false

Library-defined field for tracking internal use of items.

last_checkout_gmt

timestamp

false

The last check-out date and time for the item.

internal_use_count

int

false

The number of times the item has been used inside the library.

copy_use_count

int

false

The number of times the item has been used for photocopying.

item_message_code

char

false

A code corresponding to a library-defined item message. A code entered in this field causes the system to display the code's definition (i.e., the message) during checkout or checkin of the item.

If the code is a space or hyphen, no message appears.

opac_message_code

char

false

Library-defined code for a message that appears in the OPAC.

EXCEPTION - If OPACMSG is 'r' (rental), the system bills the patron for the item based on the length of time the item has been checked out (i.e., rented). Do not use 'r' for non-rental items. The definition of 'r' cannot be changed. Changing the definition does not change the software's action.

virtual_type_code

char

false

The item type for a virtual item record.

virtual_item_central_code_num

int

false

System-assigned code identifying the relative position of the INN-Reach Central Server when a virtual item record is created.

holdings_code

char

false

Determines which MARC field from the item record is displayed in a linked holdings (checkin) record.

STD CODE

DEFINITION

-

No MARC field displayed.

6

876 field displayed.

7

877 field displayed.

8

878 field displayed.

 

save_itype_code_num

int2

false

The original itype value prior to the item being placed on course reserve as an active reserve item; this value can be restored when the item is no longer on course reserve.

save_location_code

varchar

false

The original location value prior to the item being placed on course reserve as an active reserve item; this value can be restored when the item is no longer on course reserve.

save_checkout_total

int

false

The original total checkout value prior to the item being placed on course reserve as an active reserve item; this value can be restored when the item is no longer on course reserve.

old_location_code

varchar

false

The LOCATION code of the branch that originally owned the item.

distance_learning_status

int2

false

Integer indicating the status of an INN-Reach Pickup Anywhere request.

CODE

DEFINITION

0

The site has converted the hold from INN-Reach to regular circ, but has not yet received a 901 transaction from the central database acknowledging this conversion.

1

The central database has acknowledged the conversion by returning the 901 transaction with a subfield 'Q' containing the transaction ID of the MySQL field in the DL_TRANS table.

2

The item has been received at the DL site.

3

The item has been checked out to the patron by the DL site.

4

The item has been returned by the patron to the DL site.

 

is_suppressed

boolean

false

Specifies whether the record is suppressed from public view.
last_status_update timestamptz false (Sierra 6.0 and later) The date and time when the item status last changed.

item_record_property

Each row of item_record_property contains call number and barcode data for a specific item record.

Column

Data Type

Not NULL?

Comment

id

bigint

false

System-generated sequential ID.

item_record_id

bigint

false

Foreign key to item_record.

call_number

varchar

false

The call number found in the item record.

call_number_norm

varchar

false

The normalized form of the call number found in the item record.

barcode

varchar

false

The barcode found in the item record.

item_status_property

Each row of item_status_property identifies an item status code.

Column

Data Type

Not NULL?

Comment

id

bigint

false

System-generated sequential ID.

code

char

false

Item status code.

display_order

int

false

Integer to manage the display order of a list.

item_status_property_myuser

Each row of item_status_property_myuser identifies an item status, with the name presented in the language associated with the user's login account. Standard (English) item statuses include:

STD CODE

DEFINITION

-

AVAILABLE

m

MISSING

z

CL RETURNED

o

LIB USE ONLY

n

BILLED NOTPAID

$

BILLED PAID

t

IN TRANSIT

!

ON HOLDSHELF

l

LOST

At INN-Reach sites, the following additional codes and definitions are standard:

STD CODE

DEFINITION

@

OFF SITE

#

RECEIVED

%

RETURNED

&

REQUEST

_

REREQUEST

(

PAGED

)

CANCELLED

1

LOAN REQUESTED

 

Column

Data Type

Not NULL?

Comment

code

char

false

Item status code.

display_order

int

false

Integer to manage the display order of a list.

name

varchar

false

Item status name.

item_status_property_name

Each row of item_status_property_name identifies an item status name.

Column

Data Type

Not NULL?

Comment

item_status_property_id

bigint

false

Foreign key to item_status_property.

iii_language_id

int

false

Foreign key to iii_language.

name

varchar

false

Item status name.

item_view

Each row of item_view includes metadata and data for one item record. The contents include identification and circulation 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., 'i'.

record_num

int

false

Record number.

barcode

varchar

false

The item's barcode.

icode1

int

false

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

icode2

char

false

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

itype_code_num

int2

false

The type of item. (The library defines item types.)

location_code

varchar

false

The branch location code for the item.

agency_code_num

int2

false

Code representing the agency (library or other library-defined entity) that owns the item. (Distinguishes virtual from non-virtual records.)

item_status_code

char

false

Status of the item.

STD CODE

DEFINITION

-

AVAILABLE

m

MISSING

z

CL RETURNED

o

LIB USE ONLY

n

BILLED NOTPAID

$

BILLED PAID

t

IN TRANSIT

!

ON HOLDSHELF

l

LOST

At INN-Reach sites, the following additional codes and definitions are standard:

STD CODE

DEFINITION

@

OFF SITE

#

RECEIVED

%

RETURNED

&

REQUEST

_

REREQUEST

(

PAGED

)

CANCELLED

1

LOAN REQUESTED

 

is_inherit_loc

boolean

false

Specifies whether the record inherits its location from the parent record, if no location is specified for the record.

price

numeric

false

The price of the item.

last_checkin_gmt

timestamp

false

The last check-in date and time for the item.

checkout_total

int

false

A number incremented by the system each time the item is checked out.

renewal_total

int

false

Total number of times the item has been renewed.

last_year_to_date_checkout_total

int

false

Total checkouts for the item previous year-to-date.

year_to_date_checkout_total

int

false

Total checkouts for the item current year-to-date.

is_bib_hold

boolean

false

No longer in use.

copy_num

int

false

Indicates which copy of the title corresponds to the item record.

checkout_statistic_group_code_num

int

false

The statistics group number of the terminal where the item was checked out or renewed.

NOTE: The terminal number for a terminal that logs in over a network can change each time the terminal logs in. If the login's statistical group is set to *, the system will use the actual (changing) terminal number as the terminal number on which to track circulation activity for the purpose of statistics. Alternately, the login's statistical group can be set to a fixed number (for example, 100) and that number will be used as the terminal number, regardless of when or where the login is used.

last_patron_record_metadata_id

bigint

false

Foreign key to record_metadata (for the last patron record).

inventory_gmt

timestamp

false

The date the item was inventoried and found on the shelf.

checkin_statistics_group_code_num

int

false

The statistics group number of the terminal where the item was checked in. This field is updated when a check in unlinks the item record from the patron record. If the item's STATUS is set to t (IN TRANSIT), a check in at the destination location does not update the IN LOC field.

NOTE: The terminal number for a terminal that logs in over a network can change each time the terminal logs in. If the login's statistical group is set to *, the system will use the actual (changing) terminal number as the terminal number on which to track circulation activity for the purpose of statistics. Alternately, the login's statistical group can be set to a fixed number (for example, 100) and that number will be used as the terminal number, regardless of when or where the login is used.

use3_count

int

false

Library-defined field for tracking internal use of items.

last_checkout_gmt

timestamp

false

The last check-out date and time for the item.

internal_use_count

int

false

Library-defined field for tracking internal use of items.

copy_use_count

int

false

The number of times the item has been used for photocopying.

item_message_code

char

false

A code corresponding to a library-defined item message. A code entered in this field causes the system to display the code's definition (i.e., the message) during checkout or checkin of the item.

If the code is a space or hyphen, no message appears.

opac_message_code

char

false

Library-defined code for a message that appears in the OPAC.

EXCEPTION - If OPACMSG is 'r' (rental), the system bills the patron for the item based on the length of time the item has been checked out (i.e., rented). Do not use 'r' for non-rental items. The definition of 'r' cannot be changed. Changing the definition does not change the software's action.

virtual_type_code

char

false

The item type for a virtual item record.

virtual_item_central_code_num

int

false

System-assigned code identifying the relative position of the INN-Reach Central Server when a virtual item record is created.

holdings_code

char

false

Determines which MARC field from the item record is displayed in a linked holdings (checkin) record.

STD CODE

DEFINITION

-

No MARC field displayed.

6

876 field displayed.

7

877 field displayed.

8

878 field displayed.

 

save_itype_code_num

int2

false

The original itype value prior to the item being placed on course reserve as an active reserve item; this value can be restored when the item is no longer on course reserve.

save_location_code

varchar

false

The original location value prior to the item being placed on course reserve as an active reserve item; this value can be restored when the item is no longer on course reserve.

save_checkout_total

int

false

The original total checkout value prior to the item being placed on course reserve as an active reserve item; this value can be restored when the item is no longer on course reserve.

old_location_code

varchar

false

The location code of the branch that originally owned the item.

distance_learning_status

int2

false

Integer indicating the status of an INN-Reach Pickup Anywhere request.

CODE

DEFINITION

0

The site has converted the hold from INN-Reach to regular circ, but has not yet received a 901 transaction from the central database acknowledging this conversion.

1

The central database has acknowledged the conversion by returning the 901 transaction with a subfield 'Q' containing the transaction ID of the MySQL field in the DL_TRANS table.

2

The item has been received at the DL site.

3

The item has been checked out to the patron by the DL site.

4

The item has been returned by the patron to the DL site.

 

is_suppressed

boolean

false

Specifies whether the record is suppressed from public display.
last_status_update timestamptz false (Sierra 6.0 and later) The date and time when the item status last changed.

record_creation_date_gmt

timestamptz

false

Record creation date.

itype_property_category

Each row of itype_property_category identifies an item type 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 item type category.

itype_property_category_name

Each row of itype_property_category_name identifies an item type category name.

Column

Data Type

Not NULL?

Comment

itype_property_category_id

int

false

Foreign key to itype_property_category.

name

varchar

false

Item type category name.

iii_language_id

int

false

Foreign key to iii_language.

itype_property_myuser

Each row of itype_property_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 names.

Column

Data Type

Not NULL?

Comment

code

int

false

ITYPE 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 name.

itype_property_name

Each row of itype_property_name identifies an item type name.

Column

Data Type

Not NULL?

Comment

itype_property_id

int

false

Foreign key to itype_property.

iii_language_id

int

false

Foreign key to iii_language.

name

varchar

false

Item type name.

statistic_group

Each row of statistic_group identifies a statistics group code.

Column

Data Type

Not NULL?

Comment

id

int

false

System-generated sequential ID.

code_num

int

false

Statistics group code.

location_code

varchar

false

Location code.

statistic_group_myuser

Each row of statistic_group_myuser identifies a statistics group, with the name presented in the language associated with the user's login account. Each library maintains its own statistics group names.

Column

Data Type

Not NULL?

Comment

code

int

false

Statistics group code.

location_code

varchar

false

Location code.

name

varchar

false

Statistics group name.

statistic_group_name

Each row of statistic_group_name identifies a statistics group name.

Column

Data Type

Not NULL?

Comment

statistic_group_id

int

false

Foreign key to statistic_group.

iii_language_id

int

false

Foreign key to iii_language.

name

varchar

false

Statistics group name.

transit_box_record

Each row of transit_box_record contains the barcode and description of a transit box defined in the system.

This view presents data that is part of custom Transit Box development. It is not functional for libraries that do not use this development.

Column

Data Type

Not NULL?

Comment

id

bigint

false

System-generated sequential ID.

record_id

bigint

false

Foreign key to record.

barcode

varchar

false

Barcode of the transit box

description

varchar

false

Description of the transit box.

transit_box_record_item_record

Each row of transit_box_record_item_record contains data for an item currently in a transit box.

This view presents data that is part of custom Transit Box development. It is not functional for libraries that do not use this development.

Column

Data Type

Not NULL?

Comment

id

bigint

false

System-generated sequential ID.

transit_box_record_id

bigint

false

Foreign key to transit_box_record.

item_record_metadata_id

bigint

false

Foreign key to record_metadata (for the item record).

from_location_id

int

false

Foreign key to from_location.

to_location_id

int

false

Foreign key to to_location.

transit_box_status

Each row of transit_box_status identifies the last checked-in date and location of a transit box defined in the system.

This view presents data that is part of custom Transit Box development. It is not functional for libraries that do not use this development.

Column

Data Type

Not NULL?

Comment

id

bigint

false

System-generated sequential ID.

location_id

bigint

false

Foreign key to location.

arrival_timestamp

timestamptz

false

The last checked-in date of the transit box.

transit_box_record_id

bigint

false

Foreign key to transit_box_record.

user_defined_icode1_myuser

Each row of user_defined_icode1_myuser identifies a user-defined fixed-length field for item 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_icode2_myuser

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

volume_record_item_record_link

Each row of volume_record_item_record_link identifies a linked volume and item record.

Column

Data Type

Not NULL?

Comment

id

bigint

false

System-generated sequential ID.

volume_record_id

bigint

false

Foreign key to volume_record.

item_record_id

bigint

false

Foreign key to item_record.

items_display_order

int

false

Integer to manage the display order of an items list.