28 Overview to Supplemental Database

This chapter contains these topics:

28.1 Objectives

  • To enter, review, and report on additional user defined inventory information

  • To classify supplemental data by using codes, free-form text, or links to other programs

28.2 About the Supplemental Database

The Supplemental Database is an optional feature that allows you to store information about an item that you do not include in the standard master tables.

For example, perhaps you need to track detailed information for your engineering change specifications. Using the supplemental database, you could enter information such as the departments and people who are responsible for specific duties.

In another example, you could use the supplemental database to track costs for an advertising campaign. For each end item, you could enter campaign information such as dates, costs, the type of campaign, and so forth.

Supplemental data can include:

  • Quality performance information

  • Legal descriptions

  • Repair and replacement records

  • Government procurement information

  • Hazardous material regulations

28.2.1 What You Should Know About

Topic Description
Updating the supplemental database You might need to run the following programs to update your supplemental database:

  • Profile Data Copy/Move, after you have changed data types and you need to transfer information from one data type to another.

  • Build the Word Search File, to update supplemental data information for online searches.

  • Purge Supplemental Data, to purge information from supplemental data files.

  • CIF (Central Information File) Sequence Revisions, to define security for supplemental database users. You can customize the supplemental database display for each user, user group, and data type.

You can access these programs from Item Supplemental Data/CIF.