The job of managing the progress of production batches and materials is complex and detailed. Constant communication between the Library and several vendors is crucial in order to keep accurate records of batches, rework, invoicing and payment. This system will take the form of a mutually accessible, networked database and will be designed to permit access by as many as ten (10) Library staff members as well as members of the contractor staff. These staff members will be identified by the Library and the vendor. Each individual will be provided password or other access by the Library. The vendor will enter such Library-generated data as is appropriate for the management system.

The Library system will be DOS or Windows compatible and will be accessible via Internet.

The Library anticipates the ability to batch load data into tables of the database. For example, a DOS directory list will contain a list of items that are to be inserted into the ITEM table.

The following list is not meant to be exhaustive, but to be illustrative of the kinds of data to be entered and which party has responsibility for its entry. Additional data elements may be added by the Library or requested by the vendor during the startup and testing activity.

NOTES:

* Primary Key
+ Foreign Key
Date format should be mmddyyyy.
VEN Indicates that vendor must enter data
LC Indicates that LC must enter data
LC/VENDOR Indicates that eith vendor or LC will enter data

Next... ..Previous.....Return to Section J Table of Contents.. ...Return to the Table of Contents