Resource

resource_record

Each row of resource_record contains data fields for a specific resource record.

Column

Data Type

Not NULL?

Comment

id

bigint

false

System-generated sequential ID.

record_id

bigint

false

Foreign key to record.

is_right_result_exact

boolean

false

Controls resource display position in the catalog search results.

rights_code

char

false

Indicates the type of license rights for the resource. For example:

CODE

DEFINITION

-

not evaluated

l

licensed

p

public domain

c

copyright

d

deed - yes

e

deed - no

a

archival terms

u

unknown

 

suppress_code

char

false

Controls the display of the resource in the WebPAC. For example:

CODE

DEFINITION

-

display normal

n

suppress in WebPAC

r

default resource record (suppressed in WebPAC)

d

marked for deletion (suppressed in WebPAC)

 

ecode1

char

false

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

ecode2

char

false

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

ecode3

char

false

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

ecode4

char

false

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

resource_status_code

char

false

Indicates the licensed status of the resource. For example:

CODE 

DEFINITION

-

active

p

pending

o

on order

i

inactive

t

trial

r

rejected

u

temporarily unavailable

 

package_code

char

false

Package type for the electronic resource. For example:

CODE

DEFINITION

l

LIAISON REVIEW

c

COMPLETE

p

PARTIAL/SELECT

s

SPECCOLL

u

UNEVALUATED

 

trial_begin_gmt

timestamptz

false

Date when trial use of the resource begins.

trial_end_gmt

timestamptz

false

Date when trial use of the resource ends.

renewal_gmt

timestamptz

false

Date when resource should be renewed.

registration_gmt

timestamptz

false

Date when the library registered for use of the resource.

activation_gmt

timestamptz

false

Date when the access to the resource was activated for the library.

edate5_gmt

timestamptz

false

Use varies; usually termination date, but sometimes follow-up date.

edate6_gmt

timestamptz

false

Use varies; termination date or follow-up date.

language_code

varchar

false

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

country_code

varchar

false

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

access_provider_code

varchar

false

Code identifying the organization that provides access to the electronic publication.

location_code

varchar

false

Code identifying the member library maintaining the resource.

publisher_code

varchar

false

Code identifying the publisher for the resource.

licensor_code

varchar

false

Code identifying the resource representative who granted the license.

copyright_holder_code

varchar

false

Code identifying the copyright holder for the resource.

data_provider_code

varchar

false

Code identifying the firm or service that provides coverage information for batch loading.

consortium_code

varchar

false

Code identifying the consortium through which the resource was purchased.

is_suppressed

boolean

false

Specifies whether the record is suppressed from public display.

resource_view

Each row of resource_view includes metadata and data for one resource record. The contents include identification and descriptive 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., 'e'.

record_num

int

false

Record number.

is_right_result_exact

boolean

false

Controls resource display position in the catalog search results.

rights_code

char

false

Indicates the type of license rights for the resource. For example:

CODE

DEFINITION

-

not evaluated

l

licensed

p

public domain

c

copyright

d

deed - yes

e

deed - no

a

archival terms

u

unknown

 

suppress_code

char

false

Controls the display of the resource in the WebPAC. For example:

CODE 

DEFINITION

-

display normal

n

suppress in WebPAC

r

default resource record (suppressed in WebPAC)

d

marked for deletion (suppressed in WebPAC)

 

ecode1

char

false

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

ecode2

char

false

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

ecode3

char

false

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

ecode4

char

false

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

resource_status_code

char

false

Indicates the licensed status of the resource. For example:

CODE

DEFINITION

-

active

p

pending

o

on order

i

inactive

t

trial

r

rejected

u

temporarily unavailable

 

package_code

char

false

Package type for the electronic resource. For example:

CODE

DEFINITION

l

LIAISON REVIEW

c

COMPLETE

p

PARTIAL/SELECT

s

SPECCOLL

u

UNEVALUATED

 

trial_begin_gmt

timestamptz

false

Date when trial use of the resource begins.

trial_end_gmt

timestamptz

false

Date when trial use of the resource ends.

renewal_gmt

timestamptz

false

Date when resource should be renewed.

registration_gmt

timestamptz

false

Date when the library registered for use of the resource.

activation_gmt

timestamptz

false

Date when the access to the resource was activated for the library.

edate5_gmt

timestamptz

false

Use varies; usually termination date, but sometimes follow-up date.

edate6_gmt

timestamptz

false

Use varies; termination date or follow-up date.

language_code

varchar

false

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

country_code

varchar

false

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

access_provider_code

varchar

false

Code identifying the organization that provides access to the electronic publication.

location_code

varchar

false

Code identifying the member library maintaining the resource.

publisher_code

varchar

false

Code identifying the publisher for the resource.

licensor_code

varchar

false

Code identifying the resource representative who granted the license.

copyright_holder_code

varchar

false

Code identifying the copyright holder for the resource.

data_provider_code

varchar

false

Code identifying the firm or service that provides coverage information for batch loading.

consortium_code

varchar

false

Code identifying the consortium through which the resource was purchased.

is_suppressed

boolean

false

Specifies whether the record is suppressed from public display.

record_creation_date_gmt

timestamptz

false

Record creation date.

user_defined_ecode1_myuser

Each row of user_defined_ecode1_myuser identifies a user-defined fixed-length field for resource 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_ecode2_myuser

Each row of user_defined_ecode2_myuser identifies a user-defined fixed-length field for resource 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_ecode3_myuser

Each row of user_defined_ecode3_myuser identifies a user-defined fixed-length field for resource 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_ecode4_myuser

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