Patron Fields by Field Number

From v7Docs
Jump to: navigation, search
- We've Moved -
Librarian Support Center.png

Visit our new Alexandria Support Center

Barcode

1000

Community ID Code

1001

Government ID Code

1002

Password - Plain Text

1003

This option is used when importing a plain text password

Location

1004

2nd Location

1005

Last Name

1006

First Name

1007

Middle Initial / Middle Name

1008

Level

1010

Address

1011

City

1012

State

1013

Postal Code

1014

Country

1016

Phone Number

1017

Fax

1018

Email

1019

Contact Notes

1020

General Notes

1021

Alert Notes

1022

Categories

1025

Separate category terms with \

Status

1026

1=Active, 2=Card Lost, 3=Usage Blocked, 4=Transferred, 5=Inactive, 6=Other

Policy

1028

Uses policy short code

Previous Policy

1029

Uses policy short code

Total Fines

1030

  • Export Only

Total Payments

1031

  • Export Only

Sex (Gender)

1032

Unknown=0 or U, Male=1 or M, Female=2 or F

Life-to-Date Usage Count

1033

  • Export Only

Number of items currently checked out

1034

  • Export Only

Life-to-Date Overdue Count

1035

  • Export Only

Number of items currently overdue

1036

  • Export Only

Number of items currently on hold

1037

  • Export Only

Current Reservations Count

1038

  • Export Only

In Stock Holds Count

1039

  • Export Only

Reserves Count

1040

  • Export Only

Keep Patron History

1041

Yes or No

Last Use Date

1042

  • Export Only

Last Validation Date

1043

  • Export Only

Next Validation Date

1044

  • Export Only

Birthdate

1045

Patron Accession Date

1046

Card Expiration Date

1047

Optional Date

1048

Additional Contact (Parent/Guardian)

1049

Patron Site

1050

Lexile Number

1051

User Name

1052

Lexile Table

1060

All grades contained in single string, rows separated by // and cells by ||
(e.g. Patron ID<tab>//grade||score||source||date ...repeat as necessary)

Credits

1061

  • Export Only

Unaccepted Credits

1062

  • Export Only

Password - Encrypted

1063

This option is used when importing a password that is already encrypted MD5

Patron RSN

1099

  • Export Only

In Transit Hold Count

1100

  • Export Only

Patron SIF Info

1200

  • Export Only

Patron SIF Info 2

1201

  • Export Only

Patron Barcode

3000

  • Fine Information

Patron Name

3001

  • Fine Information

Type

3002

  • Fine Information

Description

3003

  • Fine Information

Total

3004

  • Fine Information

Balance

3005

  • Fine Information



Related “Field Mapping” and “Import” Topics

Import Window
Field Mapping