USMAI Consortium of Libraries
University System of Maryland and Affiliated Institutions

General tables List
for the LIVE MAI database

Acquisitions and Serials tables
Catalog and Database Maintenance tables
Circulation tables
PAC tables
Miscellaneous tables
Z39.50 tables

Circulation tables

Shared user definitions
Shared user definitions
Self-check definitions for SIP2
Self-check field alert definitions
Self-check field definitions
Defines time and rate for fine method "F" (tab16)
Defining hold request forms for use in the Web OPAC
List of event types for statistics (Z35)
Return to top Return to top or Continue to scroll down and look at Circulation tables

Definition of days and their codes (used for short loans)
Parameters for blocking loans
translates sublibrary to a department code, for cash_09 report purposes
Fields for fast cataloging in the Circulation module
Error messages linked to circ tables
table for converting borrower types into PLIF borrower records
Display of fields in the Item history screen
Authorization for report printing
Switch settings
IP-based sublibrary relationships with regard to loan/retuurn, cash and reading room management
return to top Return to top or Continue to scroll down and look at Circulation tables

List of libraries and their sublibraries
Minimum password levels for each check circ procedure
Address type for Acquisition, ILL & Circulation forms
Definition of GUI drop-down menus
Sublibrary-sensitive field values for the GUI pull-down menus
Parameters for fast Circulation
Item Reshelving Time
Defines the Item Statuses and various parameters connected to these statuses
Due dates, fines & limits on borrowing
return to top Return to top or Continue to scroll down and look at Circulation tables

Library open hours
Cash transaction types
Delivery Time slots From Depository
Item Material types
Hold Requests Send Method Configuration
Patron statuses defaults
Overdue letter intervals
Lost material costs
Hold Requests Pick-up List Configuration
Holds Request filter table
return to top Return to top or Continue to scroll down and look at Circulation tables

Preferred suppplier list for hold requests
Photocopy requests configuration
Hold request's daemon configuration
Collection codes and names
Automatic update of the Processing Status field in the item record
Reserved Items Schedule
Definition of the period for which requested items will be kept on the hold shelf
transaction types for ILL request log
Material type & Copyright agreement for an ILL supplier
Chronological periods for patron address types
return to top Return to top or Continue to scroll down and look at Circulation tables

Management of System-wide user IDs
Checks for loan/return/renew in Circulation
Delinquency codes and blocking of permissions
Checks for hold requests
Parameters for charging patrons for ILL requests
Checks for photo requests
return to top Return to top, End of Circulation tables or Continue to scroll down and look at Catalog and Database Maintenance tables

Catalog and Database Maintenance tables

Allowed and denied tags for different users
OCLC server configuration table
Character conversion tables
Character conversion tables
Character conversion tables
Character conversion tables
Character conversion tables
Character conversion tables
Character conversion tables
return to top Return to top or Continue to scroll down and look at Catalog and Database Maintenance tables

Character conversion tables
Character conversion tables
Retrieval definitions for selection of records to be exported by p-export-01
List of expand programs merging linked records (from the same and different libraries) for display and indexing
Union catalog de-duplication parameters
Weighting table for determining which of two matching records is the preferred record
Pre-defined text options for subfields
Default fields for a new record
Conversion of fields between formats
Definitions for expand_doc_external, that splits external fields
return to top Return to top or Continue to scroll down and look at Catalog and Database Maintenance tables

Definitions for expand_doc_duplicate_field, which duplicates a field
Language codes used in MARC fixed fields
Fields that should be ignored while checking for unique Headings (ACC) index entries
counters for z30-call-no/z30-call-no-2 and z30-inventory-number
Default values for items created using the OCLC server and RLIN loader
Weight factors for determining candidate records
Default tag values when creating new records
Settings for importing RLIN records
Defines settings for preferred records when merging document records
Definition of fields for fix_doc_add_pinyin_check_sub9 and fix_doc_add_pinyin_insert_sub9
return to top Return to top or Continue to scroll down and look at Catalog and Database Maintenance tables

Cataloging OWN permissions and filter
List of programs for moving records
Fields to retain when overlaying (merging) catalog records
Advanced routines for the merging of document records
List of merge routines
Match specifications for checking input file against the database
Fields to check against the headings (ACC)index
Match specifications for importing files
Definition of Mapping values when creating records with p-manage-500
Mapping values when creating records with the RLIN Loader (UTIL E/3)
return to top Return to top or Continue to scroll down and look at Catalog and Database Maintenance tables

Splitting call number and item description when generating item labels
Prefixes for spine label printouts
Definition of mapping values when creating records with p-manage-500
Definition of Mapping values when creating records with p-manage-500
Mapping bibliographic values into the relevant holdings and/or items values
Defines where in the bibliographic recorditem and holdings data elements are to be found for the creation of items and holdings by p-manage-50
Used for filtering HOLDINGS and ITEMS information in the Web OPAC
Item and HOL filtering
Defines the order of HOL records to be expanded into the BIB record
Definition of filing routines for items (based on the LC call nos.)
return to top Return to top or Continue to scroll down and look at Catalog and Database Maintenance tables

List of fix_doc programs in Cataloging
configuration for smart barcode export routine
blocks specific fields from being displayed in Cataloging
List of AUT libraries for use in matching BIB library headings
List of remote catalogs for Z39.50 Update Service
Conversion program + parameters for converting imported records in the Cataloging Client
Subfields to be included in the open form in cataloging
Fields that should be ignored while checking for unique Headings (ACC) index and Authorities entries
Checks of pre-defined texts for subfields (from pc_tab/catalog/tag_text)
Fields that should be ignored while checking for unique Direct (IND) index entries
return to top Return to top or Continue to scroll down and look at Catalog and Database Maintenance tables

Editable field codes and aliases
Expanding abbreviations to full text
Default values for records/items created by p-file-99 (Marcive loader)
Default values for p-file-98 (BNA loader)
Headings indexes to be searched (on the field or subfield level) during cataloging
List of chec_doc programs for Cataloging
System-driven validation messages for check_doc programs
table-driven validation messages for check_doc programs
Checks of field occurrence, and of dependency between fields, in Cataloging
return to top Return to top or Continue to scroll down and look at Catalog and Database Maintenance tables

fix_doc routines included in the Catalog/Menu/Edit/Fix record drop-down menu
List of formats for Cataloging
Country codes used in MARC
Checks for tag 008 (MARC21)
Checks for the LDR tag (MARC21)
Checks of logical structure/connections within a single occurrence of a field
Checks contents within a single occurrence of a field
Checks of forbidden (or acceptable-with-a-trigger type) errors
return to top Return to top, End of Catalog and Database Maintenance tables, or Continue to scroll down and look at Acquisitions and Serials tables

Acquisitions and Serials tables

EDI outgoing messages special attributes
Item Statuses
Fields for short doc format
ADM Fields Navigation Window
BIB Fields Navigation Window
Acquisitions Location numbers
Acquisitions Defaults
Acquisitions Change in item status
Order transaction types
Definition of cash(z31) sort types in various ALEPH functions
return to top Return to top or Continue to scroll down and look at Acquisitions and Serials tables

Matching fields for p-serial-52(import 85XX records)
Switch settings
Fields for scan screen in GUI "mini=scan"
Fields for search screen in GUI "mini=find"
Definition of GUI drop-down menus
Definition of GUI drop-down menus (Sublibrary sensitive)
Display of bibliographic fields in the order index
Prefixes for budget code, vendor code and ILL supplier code
Codes for VAT percentages (for ACQ invoices)
Sublibrary specific and generic vendor fields
Default values the YBP loader (p-file-96)
return to top Return to top or Continue to scroll down and look at Acquisitions and Serials tables

Acquisitions fast cataloging template
Chronographic terms used by the 853 field for Serials holdings
Numbering terms used by the 853 field for Serials holdings
Sublibrary Codes
Definition of item (z30)sort types
return to top Return to top, End of Acquisitions and Serials tables or Continue to scroll down and look at PAC tables

PAC tables

Custom brief display for Web OPAC
Messages to the patron in the Course Reading Module
Brief display of records in Web OPAC
X Server function definitions
Sort types for display in the Web OPAC
Functional codes linked to HTML action commands
Captions for links between records
Search words not to be highlighted in the full view of a record on the Web OPAC (for example, "the")
Definitions for the Web service search engine
return to top Return to top or Continue to scroll down and look at PAC tables

Standard punctuation to be added to subfields for Web OPAC display
table for defining services in the Web OPAC
Defines under which conditions the SFX button will appear in the Web OPAC
Fields for sorting in Web OPAC and GUI Search
Extension definitions for use in save-function in the Web OPAC
Procedures for locating a record in other libraries in Web OPAC, Cataloging, Search, ILL
Items display order in the Web OPAC and Search function according to sublibraries of each base
HOLDINGS summary statement building
Virtual Library Owners' notes
subfields arranged in non-alphabetical order for sorting by the expand_doc_sort routine
return to top Return to top or Continue to scroll down and look at PAC tables

subfields to be indexed or displayed in a different (non-alphabetical)order
Logical bases (record counters) in Web and GUI browse list
List of programs to build buf_z403(used to govern access to electronic resources)
Language definitions of CCL Boolean operators
Defines a list of MAC browsers/versions (user agents) that do not fully support UTF-8.
Defines a list of browsers/versions (user agents) that do not fully support UTF-8.
Check routines for user authorization and payment related to digital rights
GUI/Web OPAC display of the Full format of a record plus links
Formatting of individual fields for the display of bibliographic information
Paragraphs in bibliographic information displays
Document format definition for Web/GUI and printouts
return to top Return to top or Continue to scroll down and look at PAC tables

Record conversion foormat for export to reference manager such as Endnote
Definition of databases
Definition of filing and normalization routines
Specifications of new fields created by expand_doc_type routines
Definition of word-breaking procedures
Brief record(Z0101)structure based on format, index and field of origin
Text codes and definitions for the brief record
Messages to the patron in the Web OPAC
return to top Return to top, End of PAC tables or Continue to scroll down and look at Miscellaneous tables

Miscellaneous tables

Defaults for the Web Server
User authorization definitions and codes.
table name definition for the ALEPHADM module (for BIB library tables)
Paragraph styles for bibliographic display in forms
Defines which fields from the item record (Z30) are expanded into the bibliographic record
Determines the subject line for e-mail printouts
Print method for printouts
Scheduling of regular programs that run on the job daemon
Definition of daily and weekly schedules for the job_list
return to top Return to top or Continue to scroll down and look at Miscellaneous tables

Relation between libraries by library type
Re-direction of directories for sharing between libraries.
Definition of columns in GUI screens
Definition of GUI search options
Display of the "brief format" of a record in the Search function
Messages related to the navigation windows in the online ALEPH modules
Used to set the ALEPH environment needed for running scripts
Fields for printing bibliographic information in columnar form for report p=print-08
Unicode Conversion tables
List of checksum programs
return to top Return to top or Continue to scroll down and look at Miscellaneous tables

Configuration for Advanced Library Statistics
Defines the possible values for the OWN field
Creation of a new virtual field for indexing from an existing MARC subfield
Creation of a new virtual field for indexing by joining two or more MARC fields
Creation of a new virtual field for indexing by joining all occurrences of two MARC fields
Display of bibliographic fields in the ILL incoming requests' index
Display of bibliographic fields in the ILL outgoing requests' index
IP addresses for server-to-server connections
Defines time and rate for fine method "F" (tab16)
Month codes and abbreviations in different languages
return to top Return to top or Continue to scroll down and look at Miscellaneous tables

Definition of sublibraries' list sorting in various ALEPH functions
Defines the "XYZ" index that should be used to strip subject subdivisions
Programs for building links between records
Record update messages to be sent to other libraries)
Fields to retain when replicating z105 messages (ue_11)
Codes and names for indexes: Words, Headings (ACC) and Direct (IND) indexes
Codes and names of cataloging fields
Initial non-filing words/articles for the Headings index
Assignment of cataloging records' fields to Headings indexes
ACC fields used to create hypertext links to FIND and BROWSE from the AUT record
return to top Return to top or Continue to scroll down and look at Miscellaneous tables

Assignment of fields to Direct indexes
Assignment of fields to Word indexes
Used for defining environment variables for the OCLC server.
Defaults for the PC server
Unicode character conversion equivalencies for sorting.
List of Unicode character conversion equivalencies, to be used when creating records in the WORDS file
return to top Return to top, End of Miscellaneous tables or Continue to scroll down to Z39.50 tables

Z39.50 tables

translation of ALEPH codes to Z39.50 codes
List of errors which might be returned by a Z39.50 target
Definition for Z39 gate
Profile of ALEPH Z39.50 server
Defines fields and subfields for each base and element set name
Mapping of ALEPH check_doc errors to Z39.50 update errors.
Definition of external Z39.50 Databases
List of errors which might be returned by our Z39.50 gate
Location names for Z39.50 server
return to top Return to top, End of Aleph 16.02 tables

USMAI | ITD | Metalib/sfx | Aleph