|
|
University System of Maryland and Affiliated Institutions
|
USMAI Patron Loader File Format
updated July 2008
The fields in bold below are required.
RECORD LENGTH = 1769
FIELD LENGTH POSITION NOTES ALEPH FIELD
USER-TITLE CHAR 10 0-9 MR,MRS,MS, etc. Z303-TITLE
USER-NAME CHAR 200 10-209 LAST, FIRST MI Z303-REC-NAME
USER-BIRTH-DATE NUM 8 210-217 YYYYMMDD Z303-BIRTH-DATE
USER-ID-1 CHAR 20 218-237 BARCODE Z308-KEY-DATA (TYPE 01)
USER-ID-2 CHAR 20 238-257 SSN Z308-KEY-DATA (TYPE 02)
USER-TYPE CHAR 6 258-263 BORROWER TYPE (CPFAC, CPUGRD, etc.) Z305-BOR-STATUS
USER-LOCAL-INFO CHAR 2 264-265 MAJOR, CLASS, DEPT, etc. Z305-BOR-TYPE
USER-DELINQ NUM 2 266-267 00 AS DEFAULT OR RELEVENT BLOCK CODE Z303-DELINQ-# (Any code other than 00 will block the user)
USER-DELINQ-N CHAR 200 268-467 BLOCK NOTE Z303-DELINQ-N-#
ADDR1-TYPE NUM 2 468-469 01=PERMANENT, 02=MAILING, 06=OTHER Z304-ADDRESS-TYPE
ADDR1-START-DATE NUM 8 470-477 WHEN THIS ADDRESS BECOMES ACTIVE Z304-DATE-FROM (leave blank if no date is available)
ADDR1-END-DATE NUM 8 478-485 WHEN THIS ADDRESS WILL EXPIRE Z304-DATE-TO (leave blank if no date is available)
ADDR1-1 CHAR 50 486-535 NAME (as appears on printed materials) Z304-ADDRESS
ADDR1-2 CHAR 50 536-585 1ST LINE OF ADDRESS Z304-ADDRESS
ADDR1-3 CHAR 50 586-635 2ND LINE OF ADDRESS Z304-ADDRESS
ADDR1-4 CHAR 50 636-685 3RD LINE OF ADDRESS Z304-ADDRESS
ADDR1-5 CHAR 50 686-735 4TH LINE OF ADDRESS Z304-ADDRESS
ADDR1-ZIP CHAR 9 736-744 For statistical/reporting Z304-ZIP
purposes only. ZIP must also be
included in the last line of address.
ADDR1-PHONE-1 CHAR 30 745-774 Z304-TELEPHONE
ADDR1-PHONE-2 CHAR 30 775-804 Cell Z304-TELEPHONE-2
ADDR1-PHONE-3 CHAR 30 805-834 Fax Z304-TELEPHONE-3
ADDR1-EMAIL CHAR 60 835-894 repeat in all address fields if used Z304-EMAIL-ADDRESS
ADDR2-TYPE NUM 2 895-896 01=PERMANENT, 02=MAILING, 06=OTHER Z304-ADDRESS-TYPE
ADDR2-START-DATE NUM 8 897-904 WHEN THIS ADDRESS BECOMES ACTIVE Z304-DATE-FROM (leave blank if no date is available)
ADDR2-END-DATE NUM 8 905-912 WHEN THIS ADDRESS WILL EXPIRE Z304-DATE-TO (leave blank if no date is available)
ADDR2-1 CHAR 50 913-962 NAME (as appears on printed materials) Z304-ADDRESS
ADDR2-2 CHAR 50 963-1012 1ST LINE OF ADDRESS Z304-ADDRESS
ADDR2-3 CHAR 50 1013-1062 2ND LINE OF ADDRESS Z304-ADDRESS
ADDR2-4 CHAR 50 1063-1112 3RD LINE OF ADDRESS Z304-ADDRESS
ADDR2-5 CHAR 50 1113-1162 4TH LINE OF ADDRESS Z304-ADDRESS
ADDR2-ZIP CHAR 9 1163-1171 For statistical/reporting Z304-ZIP
purposes only. ZIP must also be
included in the last line of address.
ADDR2-PHONE-1 CHAR 30 1172-1201 Z304-TELEPHONE
ADDR2-PHONE-2 CHAR 30 1202-1231 Cell Z304-TELEPHONE-2
ADDR2-PHONE-3 CHAR 30 1232-2161 Fax Z304-TELEPHONE-3
ADDR2-EMAIL CHAR 60 1262-1321 from ADDR1-EMAIL Z304-EMAIL-ADDRESS
ADDR3-TYPE NUM 2 1322-1323 01=PERMANENT, 02=MAILING, 06=OTHER Z304-ADDRESS-TYPE
ADDR3-START-DATE NUM 8 1324-1331 WHEN THIS ADDRESS BECOMES ACTIVE Z304-DATE-FROM (leave blank if no date is available)
ADDR3-END-DATE NUM 8 1332-1339 WHEN THIS ADDRESS WILL EXPIRE Z304-DATE-TO (leave blank if no date is available)
ADDR3-1 CHAR 50 1340-1389 NAME (as appears on printed materials) Z304-ADDRESS
ADDR3-2 CHAR 50 1390-1439 1ST LINE OF ADDRESS Z304-ADDRESS
ADDR3-3 CHAR 50 1440-1489 2ND LINE OF ADDRESS Z304-ADDRESS
ADDR3-4 CHAR 50 1400-1539 3RD LINE OF ADDRESS Z304-ADDRESS
ADDR3-5 CHAR 50 1540-1589 4TH LINE OF ADDRESS Z304-ADDRESS
ADDR2-ZIP CHAR 9 1590-1598 For statistical/reporting Z304-ZIP
purposes only. ZIP must also be
included in the last line of address.
ADDR3-PHONE-1 CHAR 30 1599-1628 Z304-TELEPHONE
ADDR3-PHONE-2 CHAR 30 1629-1658 Cell Z304-TELEPHONE-2
ADDR3-PHONE-3 CHAR 30 1659-1688 Fax Z304-TELEPHONE-3
ADDR3-EMAIL CHAR 60 1689-1748 from ADDR1-EMAIL Z304-EMAIL-ADDRESS
USER-ID-3 CHAR 20 1749-1768 LOCAL ID Z308-KEY-DATA
Top of Page
|
| © 2005 University System of Maryland and Affiliated Institutions. Privacy policy |