Patron Field Mapping
Patron Fields by Field Number
Patron field numbers are necessary when creating a transaction script or an import document. Use the following table below to determine which field numbers you need for your import.
| Field | Header | Type | Notes |
|---|---|---|---|
| Barcode | 1000 | Import/Export | Limit 15 characters |
| First Name | 1007 | Import/Export | Limit 25 characters |
| Last Name | 1006 | Import/Export | Limit 25 characters If a patron has multiple last names and you only want to import one, you will need to modify the import file to reflect that. |
| Middle Name | 1008 | Import/Export | Limit 25 characters |
| Nickname | 1070 | Import/Export | Limit 25 characters |
| Policy | 1028 | Import/Export | Limit 4 characters Uses policy short code as specified in Preferences. |
| Status | 1026 | Import/Export | Integer indicating Status: 1=Active, 2=Card Lost, 3=Suspended, 4=Transferred, 5=Inactive, 6=Other |
| Government ID * | 1002 | Import/Export | Terminology field, often named SSN |
| Location * | 1004 | Import/Export | Terminology field, often named Homeroom |
| Sublocation * | 1005 | Import/Export | Terminology field, often named 2nd Location |
| Level * (Grade) | 1010 | Import/Export | Terminology field, often named Grade |
| Community ID * | 1001 | Import/Export | Terminology field, often named Student # |
| Site | 1050 | Import/Export | Site code as specified in Site Management |
| Optional Date * | 1048 | Import/Export | Limit 12 characters Terminology field, often named Graduation Date |
| Address | 1011 | Import/Export | Limit 100 characters |
| Address 2 | 88 | Import/Export | |
| City | 1012 | Import/Export | Limit 100 characters |
| State | 1013 | Import/Export | Limit 100 characters |
| Postal Code | 1014 | Import/Export | Limit 100 characters |
| Country | 1016 | Import/Export | Limit 100 characters |
| Telephone | 1017 | Import/Export | Limit 25 characters |
| Date of Birth | 1045 | Import/Export | Limit 12 characters |
| Sex | 1032 | Import/Export | Integer indicating sex or gender: Unspecified=0 or U, Male=1 or M, Female=2 or F |
| Contact Notes | 1020 | Import/Export | Limit 1000 characters |
| General Notes | 1021 | Import/Export | Limit 2000 characters |
| 2nd Phone Number * | 1018 | Import/Export | Limit 25 characters Terminology field, often named Mobile or Fax |
| Primary Email | 1019 | Import/Export | Limit 100 characters |
| Other Emails | 1054 | Import/Export | Limit 100 characters |
| Categories | 1025 | Import/Export | Limit 1000 characters Separate category terms with \ |
| Patron Accession Date | 1046 | Import/Export | Limit 12 characters |
| Additional Contact * | 1049 | Import/Export | Limit 100 characters Terminology field, often named Parent/Guardian |
| Username | 1052 | Import/Export | Limit 100 characters |
| Lexile Table | 1060 | Import/Export | Limit 300 characters All grades contained in single string, rows separated by // and cells by II (e.g. Patron ID<tab>//gradeIIscoreIIsourcelldate …repeated as necessary) |
| Password – Encrypted | 1063 | Import/Export | Limit 30 characters This option is used when importing a password that is already encrypted MD5 |
| Password – Plain Text | Import | ||
| Card Exp. Date | 1047 | Import/Export | Limit 12 characters |
| Lexile | 1051 | Import/Export | Limit 4 characters |
| Reading Level * | 1053 | Import/Export | Terminology preference field |
| Patron GUID | 1200 | Import/Export | Limit 100 characters |
| Alert Notes | 1022 | Export | |
| Pending Holds Count | 1037 | Export | |
| In Stock Hold Count | 1039 | Export | |
| Reservations Count | 1038 | Export | |
| Reserves Count | 1040 | Export | |
| Balance (Library) | 1030 | Export | |
| Total Payments | 1031 | Export | |
| Credits | 1061 | Export | |
| Last Use Date | 1042 | Export | Limit 12 characters |
| Life to Date Usage | 1033 | Export | |
| Total Currently Out | 1034 | Export | |
| Life to Date Overdue | 1035 | Export | |
| Currently Overdue | 1036 | Export | |
| Patron Barcode | 3000 | Export | Export Patrons Fines report, only |
| Patron Name | 3001 | Export | Export Patrons Fines report, only |
| Type | 3002 | Export | Export Patrons Fines report, only |
| Description | 3003 | Export | Export Patrons Fines report, only |
| Total | 3004 | Export | Export Patrons Fines report, only |
| Charge Balance | 3005 | Export | Export Patrons Fines report, only |