Choosing Borrower Information

To import borrower records, you must first decide what information you want to include in your borrower records. The following table shows some of the columns that you can use with Borrower Import. (For a complete list of columns in the borrower tables, see the Table Structures e-Guide.

Table Name

Columns

Borrower (bt)

borrower#
location
btype
second_id

name
birth_date
approved_status

Borrower_barcode (bb)

borrower#
bbarcode

lost_date
proxy_borrowers

Borrower_phone (bp)

borrower#
ord

phone_no
phone_type

Borrower_bstat (bs)

borrower#

bstat

Borrower_address (ba)

borrower#
ord
address_type
mail_sort_type
address1
address2
address3

address4
postal_code
city_st
email_name
email_address
valid_from_date
valid_to_date

borrower_911 (b9)

borrower#
security_group

timestamp

borrower_pac_access_type (b4

borrower#
pac_access_type

timestamp

borrower_image (bi)

borrower#

bimage

Note: For more information on importing borrower photos, see Importing borrower photos.

creation_date

timestamp

For example, you can import the date that a borrower record was originally created by including the creation_date column from the borrower table in the header when you import borrower records. If there is no creation date specified in the incoming data, or if you do not add the creation_date column to your header, Borrower Import sets the creation date to the date of import.

 


© 1998-2017 Sirsi Corporation