Default Fields on Borrower Records

Field Label

Column Name

Description

Default

Borrower No.

borrower#

Unique identifier, system-assigned

 

Location

location

Location code

X

BTYPE

btype

Borrower type code

X

Exp. Date

expiration_date

Date the borrower’s library privileges expire

X

Pin#

pin#

User-supplied unique identifier (for Telephone Messaging)

X

Language

language

Language (for Telephone Messaging)

X

Name

name

Person’s name

X

ID

second_id

User-supplied unique identifier (for example, social security number)

X

Birth Date

birth_date

Date of birth

 

Note

borrower_note

Message to/about borrower

 

Phone

phone_no

Phone number

X

Type

phone_type

Phone number usage code, such as work or home

X

Addr. Type

address_type

Type of address: permanent, temporary, or mailing.

X

Begin

valid_from_date

Start date at address (for temporary or street address)

X

End

valid_to_date

End date at address (for temporary or street address)

X

Line 1

address1

First line in address

X

Line 2

address2

Second line in address

X

Line 3

address3

Third line in address

X

Barcode

bbarcode

Unique library-assigned barcode

X

Date Lost

lost_date

Date borrower lost barcode (if applicable)

 

Barcode

bbarcode

Barcode assigned for proxy of a certain borrower

 

Date Lost

lost_date

Date borrower lost proxy barcode (if applicable)

 

Proxy Borrower

proxy_borrower#

Borrower number of person being proxied

 

Name

name

Name of the borrower being proxied

 

Date Expire

proxy_expiration_date

Date proxy borrower barcode expires

 

Stat Class

bstat

Person’s borrower statistical class (BSTAT) category

 

Security Group

security_group

Person’s security group (determines system privileges)

 

PAC Access Type

pac_access_ type

Person’s type of access to PAC (determines privileges on a flavor by flavor basis)

 

Route

route

Unique Home Service identifier, user assigned

 

Stop Number

stop_number

Stop number on this Home Service route

X

Last Visit Date

last_visit

Date of next anticipated visit

X

Next Visit Date

next_visit

Date of most recent Home Service visit by library staff

X

Visit Freq.

visit_frequency

A 1-digit to 10-digit number indicating the frequency of Home Service visits to this borrower

 

Visit Comments

visit_ comments

Comments from most recent or for next Home Service visit

 

Equipment

equipment

Type of equipment used by the Home Service borrower

 

Reader’s profile

profile

Notes about the preferences of this Home Service reader

 

Certified by

certified_by

Certified as Home Service user by this source

 

 


© 1998-2017 Sirsi Corporation