CompuChem maintains four independent data bases of formulations:


1. Standard formulation database.
This database contains the formulations which will be used in production. Formulations may be exported from this database to the archive database when they are no longer required for current production. Formulations can be restored from the archive database to the standard database at any time.
You may not have multiple formulations with the same code on the standard database.

Whenever you delete a formulation you will be prompted as to whether you wish to store this formulation in the archive database before deleting. When a standard formulation is deleted from the standard formulation database it is no longer available for scheduling and manufacturing new batches.

2. Production records database.
Whenever a formulation is manufactured a copy of the current version of this formulation is stored in the production records. This copy of the formulation is only available for reporting purposes once the actual formulation it is based on has been completed.
It is therefore permissible to delete a standard production formulation from the menu option: files/ formulation even if you have recently manufactured this product and have not yet run production reports which refer to this formulation. All references will be resolved from the production systems own database.

3. Archive database.
The archive data base is a repository for formulations which are no longer in use in the standard production database you can store any number of formulations with the same code in this data base. As you add new formulations the version number is automatically incremented for formulations with the same code. The archive database maintains its own copy of the raw material database so that you can safely delete raw materials which are no longer in use in the the production database. If you restore archived formulations which contain materials which are no longer available in the standard production database, these materials will automatically be restored from the archive database.
See Archiving Formulations

4. Development database.
The development database is used by the laboratory for developing new formulations. In order to work on a formulation in the development database you must import it either from the archive database or the standard production database.

The development database shares the raw the material database with the standard production database therefore raw materials entered for production are automatically available for use in development work.

There is also a 'portable database' that can be used to transmit formulations by disc or email. See Exporting/ Importing Formulations.