40 Set Up Data Types

This chapter contains these topics:

• Section 40.1, "Setting up Data Types"

• Section 40.2, "Defining Data Type Formats for Job Cost"

• Section 40.3, "Setting Up Data Type Security for Job Cost"

40.1 Setting up Data Types

You must set up data types for the supplemental information you want to store and track for a job. You can define the format of the supplemental information. For example, you can enter supplemental information in a columnar format or as free-form text. You can also define security for the data types to limit the users who have access to the supplemental information.

Complete the following tasks:

• Defining Data Type Formats for Job Cost

• Setting Up Data Type Security for Job Cost

40.2 Defining Data Type Formats for Job Cost

Navigation

From Job Cost (G51), enter 29

From Job Cost System Setup (G5141), choose Define Data Types

You define the format of the supplemental information you can add to your jobs. You can choose between two formats, described below.

Format	Description
Columnar format	Use this format for supplemental information, such as dates, amounts, and additional information related to your user defined codes. You can specify the names of the columns. You can also specify whether the system verifies the codes against established user defined codes.
Narrative format	Use this format for supplemental information that must be entered as free-form text.

Complete the following tasks:

• Define columnar formats

• Define narrative formats

40.2.1 Before You Begin

• Set up the appropriate user defined codes if you want the system to verify columnar information against them.

Figure 40-1 Define Data Types screen

Description of ''Figure 40-1 Define Data Types screen''

40.2.2 What You Should Know About

Topic

Description

Verifying columnar information against user defined codes

You can verify your columnar data against user defined codes. The data is verified in the following ways: The system uses the description for a code from the user defined codes table as the description on supplemental data forms and reports. The user defined codes must be set up before you can set up the data type. To assign the code type table, specify the install system and code type in the Edit on System and Record Type fields. If the data type does not relate to an existing user defined code, you can set up a new code type table that relates only to the supplemental data. You should define the code type for system 55, 56, 57, 58, or 59. This protects that code type table during a reinstall process.

See Also:

• Section 52.1, "Understanding User Defined Codes for Job Cost"

To define columnar formats

On Define Data Types

1. Complete the following fields for each data type:

   • Type Data

   • Description

   • Display Mode

   • Code Title

   • Amount Title

2. Access More Details.

   Figure 40-2 Define Data Types (Details) screen

   
   Description of ''Figure 40-2 Define Data Types (Details) screen''
   
   

3. Complete the following fields for each columnar format:

   • Remark 1 Title

   • Remark 2 Title

To define narrative formats

On Define Data Types

1. Complete the following fields:

• Type Data

• Description

• Display Mode

40.3 Setting Up Data Type Security for Job Cost

Navigation

From Job Cost (G51), enter 29

From Job Cost System Setup (G5141), choose Supplemental Data Security

You can set up security for data types to limit the users who can access supplemental information. Unless security is set up, all users can access all supplemental data.

The security information is stored in the Supplemental Data Type Security table (F0080).

To set up data type security

On Supplemental Data Security

Figure 40-3 Supplemental Data Security screen

Description of ''Figure 40-3 Supplemental Data Security screen''

Complete the following fields:

• User ID

• Type of Data

• Allow

Field	Explanation
User ID	The IBM-defined user profile. Form-specific information The Skip To User ID field in the upper part of the screen lets you specify the user ID you want displayed at the top of the list. If the list includes many pages of information, this field eliminates the need to scroll through the list when searching for a specific user. If you use *PUBLIC in the User ID field, you can secure a data type for all users that are not specified individually.
Type of Data	Identifies a data type, which is used to group similar information.
Allow	A code that indicates whether a user is allowed access to the function key or selection. Valid codes are: Y – Yes, allow access N – No, prevent access blank – Yes, allow access (default).