Understanding Supplemental Data

This chapter provides overviews of supplemental data, supplemental data type formats, and an example of supplemental data for a construction company.

Click to jump to parent topicSupplemental Data

You use supplemental data to track and store information that is not included in the standard master tables in JD Edwards EnterpriseOne software.

Using supplemental data, you define categories and further define information that you want to track for each category. Assume that you want to track the delivery methods for your customers. Delivery method is not a field in any of the master tables. Using supplemental data, you could define a category called Delivery Methods and then define the different delivery methods that you use.

JD Edwards EnterpriseOne software provides one supplemental database for each of these systems:

You can set up databases in addition to those provided by JD Edwards EnterpriseOne software. For each supplemental database, you can create one or more data types to organize your information. After you set up your database and data types, you can enter and use supplemental data.

Information for supplemental database codes is stored in these tables:

Click to jump to parent topicSupplemental Data Type Formats

The type of information that you want to track determines the format in which you display supplemental data. These formats are available:

Format

Usage

Narrative

Use the narrative format to enter free-form text, such as:

  • General remarks

  • Notes

  • Memos

  • Descriptions

  • Employee performance appraisals

  • Applicant interview notes

  • Job descriptions

  • Legal descriptions

The system stores narrative text as generic text attachments.

Message

Use the message format to enter narrative information about the data type. This format is similar to the narrative format.

Code

Use the code format to customize the form on which you enter supplemental data. For each data type that uses the code format, you can customize column headings that appear on the data entry form. For example, you can use the code format to customize column headings for:

  • Language skills

  • Training completed

  • Employee appraisal details

  • Description of incident

  • Cost of damage

You can attach a UDC table to each supplemental data type that uses the code format. You can use existing UDC tables or create new ones. When you create new tables, you must use system codes ranging from 55 to 59, inclusive, to protect the table from being overwritten during the reinstall process.

To enter text, you can add an attachment to data types that use the code format.

Program

The program format enables you to access a specific program and version number from the Supplemental Data program (P00092). Instead of customizing menus, you can set up supplemental data types that use program formats to access the forms that you use most often. You can then access the forms from a single menu selection, which saves time and streamlines data entry tasks.

Click to jump to parent topicExample: Supplemental Data for a Construction Company

Assume that you work for a construction company and the company wants to use supplemental data to track the progress of each job (or business unit). Specifically, your company wants to track this information for each job:

This example illustrates the information that you want to track for business unit 5001:

Supplemental data for business unit 5001

Click to jump to top of pageClick to jump to parent topicData Types

You must set up data types for the legal description, general remarks, ground conditions, and so on.

Data Types with a Narrative Format

You set up data types for:

The data types for legal description and general remarks contain free-form text and, therefore, use the narrative format.

Data Types with a Code Format

You also set up data types for:

These data types use the code format, which enables you to customize the entry form on which you enter data. With the code format, you can track additional information such as categories, dates, and amounts.

To track detailed information for ground conditions for a job, you set up these categories: