License

license_record

Each row of license_record contains data fields for a specific license record.

Column

Data Type

Not NULL?

Comment

id

bigint

false

System-generated sequential ID.

record_id

bigint

false

Foreign key to record.

accounting_unit_code_num

int

false

Accounting unit code number.

confidential_code

char

false

Defines how much, if any, of the license information is confidential. For example:

CODE

DEFINITION

p

price only

c

all confidential

n

no

u

unknown

 

auto_renew_code

char

false

Indicates whether or not the license is automatically renewed upon expiration. For example:

CODE

DEFINITION

-

no

y

yes

 

status_code

char

false

Indicates the status of the license. For example:

CODE

DEFINITION

v

valid

n

negotiation

e

expired

u

unknown

 

type_code

char

false

Indicates the type of the license. For example:

CODE

DEFINITION

s

site license

c

consortium

x

clickthru

y

shrinkwrap

u

unknown

 

change_to_code

char

false

Specifies whether changes to the contract are allowed during the subscription period. For example:

CODE

DEFINITION

-

none

y

yes

 

breach_procedure_code

char

false

Indicates whether there is a procedure to follow in the event of a breach to the license contract. For example:

CODE 

DEFINITION

-

none

y

yes

 

termination_procedure_code

char

false

Indicates whether there is a procedure to follow in order to terminate the license contract. For example:

CODE

DEFINITION

-

none

y

yes

 

perpetual_access_code

char

false

Indicates if the license grants perpetual access, with no future licensing requirements.

archival_provisions_code

char

false

Indicates whether the licensing organization provides archival information about a resource. For example:

CODE

DEFINITION

-

none

y

yes

 

warranty_code

char

false

Indicates the type of warranty provided by the licensing organization. For example:

CODE

DEFINITION

d

to distribute

f

full

u

unknown

 

disability_compliance_code

char

false

Indicates whether the license guarantees access for disabled individuals to electronic resources.

performance_requirement_code

char

false

Performance requirement code is not activated at this time.

liability_code

char

false

Liability code is not activated at this time.

idemnification_code

char

false

Specifies who is held responsible for any legal issues that arise from use of the electronic resource. For example:

CODE

DEFINITION

p

by provider

w

by university

m

mutual

u

unknown

 

law_and_venue_code

char

false

Identifies the preferred source for legal code to be cited in any legal action. For example:

CODE

DEFINITION

l

library

n

U.S.

s

silent

u

unknown

 

user_confidentiality_code

char

false

Indicates whether or not the provider guarantees user confidentiality. For example:

CODE

DEFINITION

-

none

y

yes

 

suppress_code

char

false

Controls the display of the license in the Web OPAC. For example:

CODE

DEFINITION

-

normal display

n

suppress

 

lcode1

char

false

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

lcode2

char

false

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

lcode3

char

false

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

concurrent_users_count

int

false

The number of concurrent users allowed access to an electronic resource.

license_sign_gmt

timestamptz

false

Date when licensee signed the contract on behalf of the library.

licensor_sign_gmt

timestamptz

false

Date when the licensor signed and completed the contract.

contract_start_gmt

timestamptz

false

Date when license contract begins.

contract_end_gmt

timestamptz

false

Date when license contract ends.

breach_cure

int

false

Number of days the provider allows following their notification that a breach has occurred.

cancellation_notice

int

false

Requirements for notifying resource provider of a change in terms.

is_suppressed

boolean

false

Specifies whether the license record is suppressed.

ldate4

timestamptz

false

A custom-use date field. Not used at all sites.

language_code

varchar

false

The language code applicable to the licensed resource. (Standard MARC or library-specified custom code.)

country_code

varchar

false

The code representing the country applicable to the resource, based on the MARC 21 Code List of Countries, or ISO 3166/MA standard for UNIMARC systems.

llang2

varchar

false

An alternative language code. Not used at all sites.

license_view

Each row of license_view includes metadata and data for one license record. The contents include identification and descriptive information about an electronic resource license, 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., 'l'.

record_num

int

false

Record number.

accounting_unit_code_num

int

false

Accounting unit code number.

confidential_code

char

false

Defines how much, if any, of the license information is confidential. For example:

CODE

DEFINITION

p

price only

c

all confidential

n

no

u

unknown

 

auto_renew_code

char

false

Indicates whether or not the license is automatically renewed upon expiration. For example:

CODE

DEFINITION

-

no

y

yes

 

status_code

char

false

Indicates the status of the license. For example:

CODE

DEFINITION

v

valid

n

negotiation

e

expired

u

unknown

 

type_code

char

false

Indicates the type of the license. For example:

CODE

DEFINITION

s

site license

c

consortium

x

clickthru

y

shrinkwrap

u

unknown

 

change_to_code

char

false

Specifies whether changes to the contract are allowed during the subscription period. For example:

CODE

DEFINITION

-

none

y

yes

 

breach_procedure_code

char

false

Indicates whether there is a procedure to follow in the event of a breach to the license contract. For example:

CODE

DEFINITION

-

none

y

yes

 

termination_procedure_code

char

false

Indicates whether there is a procedure to follow in order to terminate the license contract. For example:

CODE 

DEFINITION

-

none

y

yes

 

perpetual_access_code

char

false

Indicates if the license grants perpetual access, with no future licensing requirements.

archival_provisions_code

char

false

Indicates whether the licensing organization provides archival information about a resource. For example:

CODE

DEFINITION

-

none

y

yes

 

warranty_code

char

false

Indicates the type of warranty provided by the licensing organization. For example:

CODE 

DEFINITION

d

to distribute

f

full

u

unknown

 

disability_compliance_code

char

false

Indicates whether the license guarantees access for disabled individuals to electronic resources.

performance_requirement_code

char

false

Performance requirement code is not activated at this time.

liability_code

char

false

Liability code is not activated at this time.

idemnification_code

char

false

Specifies who is held responsible for any legal issues that arise from use of the electronic resource. For example:

CODE

DEFINITION

p

by provider

w

by university

m

mutual

u

unknown

 

law_and_venue_code

char

false

Identifies the preferred source for legal code to be cited in any legal action. For example:

CODE

DEFINITION

l

library

n

U.S.

s

silent

u

unknown

 

user_confidentiality_code

char

false

Indicates whether or not the provider guarantees user confidentiality. For example:

CODE

DEFINITION

-

none

y

yes

 

suppress_code

char

false

Controls the display of the license in the Web OPAC. For example:

CODE

DEFINITION

-

normal display

n

suppress

 

lcode1

char

false

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

lcode2

char

false

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

lcode3

char

false

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

concurrent_users_count

int

false

The number of concurrent users allowed access to an electronic resource.

license_sign_gmt

timestamptz

false

Date when licensee signed the contract on behalf of the library.

licensor_sign_gmt

timestamptz

false

Date when the licensor signed and completed the contract.

contract_start_gmt

timestamptz

false

Date when license contract begins.

contract_end_gmt

timestamptz

false

Date when license contract ends.

breach_cure

int

false

Number of days the provider allows following their notification that a breach has occurred.

cancellation_notice

int

false

Requirements for notifying resource provider of a change in terms.

record_creation_date_gmt

timestamptz

false

Record creation date.

resource_record_license_record_link

Each row of resource_record_license_record_link identifies a linked resource and license record pair.

Column

Data Type

Not NULL?

Comment

id

bigint

false

System-generated sequential ID.

resource_record_id

bigint

false

Foreign key to resource_record.

license_record_id

bigint

false

Foreign key to license_record.

licenses_display_order

int

false

Integer to manage the display order of a license list.

resources_display_order

int

false

Integer to manage the display order of a resource list.

user_defined_lcode1_myuser

Each row of user_defined_lcode1_myuser identifies a user-defined fixed-length field for license 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_lcode2_myuser

Each row of user_defined_lcode2_myuser identifies a user-defined fixed-length field for license 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_lcode3_myuser

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