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