USMAI Consortium of Libraries
University System of Maryland and Affiliated Institutions

Fine Notice Available Data Fields

Here are some Oracle table definitions which might help you interpret this table.

  Z303 - global user information

   Z304 - user address

   Z308 - user id

   Z30 - item

   Z31 - cash

   Z13 - short bib


*Note: Z31-key is a long string of numbers that contains the loan date and hour and return date and hour.
The templates we create will extract the information from this string. Simply indicate loan date/hour or return date/hour if you require this information.

Section-01

form-date05/13/2003
p-date-from  (refers to extract date)20030512
p-date-to  (refers to extract date)20030512
sub-library-address  (will include complete return address as currently defined in MAI) UMCP Architecture Library

Section-04

student-id (SSN)201065011
z303-id000000367604
z303-open-date08/31/2000
z303-update-date02/17/2003
z303-nameCANNON, ARIAL T
z303-title 
z303-delinq-100
z303-delinq-n-1 
z303-delinq-1-update-date00000000
z303-delinq-200
z303-delinq-n-2 
z303-delinq-2-update-date00000000
z303-delinq-300
z303-delinq-n-3 
z303-delinq-3-update-date00000000
z303-budget 
z303-home-libraryUMCP McKeldin Library
z303-dispatch-library 
z304-id000000367604
z304-address-0CANNON, ARIAL T
z304-address-1101 Masin Drive
z304-address-2Ocean City MD 21842
z304-zip21842
z304-email-address 
z304-telephone4102133455
z304-date-from00000000
z304-date-to20991231
z304-address-type02
z304-update-date20030217
z304-cat-name 
z308-key-data  (barcode) 21430009293402
z308-id000000367604
z308-statusAC

Section-05

reference-date20030429
cash-date20030512
cash-hour 
action-codeY
credit-codeD
z31-rec-key000000367604200305121612579
z31-id000000367604
z31-sequence200305121612579
z31-date05/12/2003
z31-statusNot paid
z31-sub-libraryUMCP Architecture Library
z31-alphaL
z31-type3
z31-credit-debitD
z31-sum(6.50)
z31-payment-date 
z31-payment-hour 
z31-payment-cataloger 
z31-payment-targetUMCP Architecture Library
z31-payment-ip 
z31-payment-receipt-number 
z31-key-typeZ36
z31-key*  (This data is used to get loan and return dates and times)2003030420030429200305121340235916120000000
z31-descriptionLate return
z31-transfer-department 
z31-transfer-date00000000
z31-transfer-number 
z31-recall-transfer-status 
z31-recall-transfer-date00000000
z31-recall-transfer-number 
z31-related-z31-key 
z31-related-z31-key-type 
z30-doc-number212711
z30-barcode31430006214433
z30-sub-libraryUMCP Architecture Library
z30-materialBook
z30-item-statusGeneral coll.
z30-date-last-return 
z30-hour-last-return 
z30-no-loans005
z30-collectionStacks
z30-call-noHT123.F69
z30-call-no-2 
z30-description 
z30-note-opac 
z30-note-circulation 
z30-price 
z30-pages 
z30-arrival-date 
z30-item-statistic 
z30-item-process-status 
z30-enumeration-a 
z30-enumeration-b 
z30-enumeration-c 
z30-enumeration-d 
z30-enumeration-e 
z30-enumeration-f 
z30-enumeration-g 
z30-enumeration-h 
z30-chronological-i 
z30-chronological-j 
z30-chronological-k 
z30-chronological-l 
z30-chronological-m 
z13-doc-number212711
z13-year1958
z13-open-date11/24/2002
z13-update-date11/27/2002
z13-call-no-key 
z13-call-no-codePST0
z13-call-noHT123
z13-author-code 
z13-author 
z13-title-code24504
z13-titleThe exploding metropolis.
z13-imprint-code2600
z13-imprintGarden City, N.Y., Doubleday, 1958.
z13-isbn-issn-code 
z13-isbn-issn 
z13-user-defined-1-code 
z13-user-defined-1 
z13-user-defined-2-code 
z13-user-defined-2 
z13-user-defined-3-code 
z13-user-defined-3 
z13-user-defined-4-code 
z13-user-defined-4 
z13-user-defined-5-code 
<z13-user-defined-5></z13-user-defined-5>

Section-11

Section-09

descriptionLate fines
count 1
amount 6.50

Section-09

description--- TOTAL DEBITS ---
count 1
amount 6.50

Section-12

Top of Page
USMAI | ITD | Metalib/sfx | Aleph