How helpful was this page?
Related Blog Posts
Blog Posts
-
Notes for student aides–System Patron notes
created by
Oct 10, 2023
-
Restricted items–using patron alert notes
created by
Sep 27, 2023
-
Passwords: protect your data
created by
Sep 07, 2023
-
Four features in Patrons you might not be using
created by
Apr 05, 2023
-
Say cheese! All about patron pictures
created by
Aug 10, 2022
-
End-of-year tips: Managing patrons
created by
May 03, 2022
-
Assigning policies–the complete guide
created by
Mar 23, 2022
-
Setting rules–Patron Policy Preferences
created by
Mar 08, 2022
-
Search smarter!—Combine search results
created by
Oct 13, 2021
-
Introducing... FAQs!
created by
Jul 07, 2021
This page has been moved over to https://support.goalexandria.com/patrons/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 |
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 |
Username | 1052 | Import/Export | Limit 100 characters |
Lexile Table | 1060 | Import/Export | Limit 300 characters |
Password - Encrypted | 1063 | Import/Export | Limit 30 characters |
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 |
*terminology