Creating Dictionary Items

Use the Eclipse Dictionary Maintenance screen to create user-defined dictionary items for attributes, attributes' multi-values, and multi-values' sub-values.

On this screen, you can create:

D-type dictionary items - Define names and formatting characteristics for each field of information stored in data files.
I-type dictionary items - Represent symbolic fields derived from a manipulation of real data.

Users must be assigned the DICT.MAINT authorization key to view, create, and edit dictionary items.

To create a dictionary item:

From the Maintenance > Eclipse Dictionary menu, select Eclipse Dictionary Maintenance to display the Eclipse Dictionary Maintenance screen.

Note: If prompted, log on to the character-based system.

You can also display this screen using the Dict Maint hot key on the File Definition Maintenance screen.

In the File Name field, enter the file containing the attribute for which to create the dictionary item.
In the Dict ID field, enter the ID of the dictionary item.

Note: Within a file, each dictionary ID must be unique. An exclamation point (!) or forward slash (/) cannot be the first character of the ID.

Complete the following fields for this item:

Field	Description
Dict Type	Character representing the dictionary item type. D (Field Definition) - Identifies a physical field of data, such as a name, user ID, number, address, description, or quantity. I (I-Descriptor) - Identifies a symbolic field the system can use for calculating values.
Attr#	Attribute number, which indicates the numerical position of the field within the record for the dictionary ID. This field applies to D-types only. Use the Dictionary Maintenance Summary screen to view the defined dictionary items and corresponding attribute numbers for a file.
Val#	Numerical position of a value in a multi-valued field. For example, in a customer file with six contacts, the third contact would be identified as value 3.
Subval#	Numerical position of a sub-value in a multi-valued field. For example, in a customer file with six contacts, each of which contains a contact name and a phone number, the phone number of the third contact person would be sub-value 2 of value 3.
Description	Description of the dictionary item. Dictionary descriptions cannot contain ampersands (&).
Prompt	Default column heading for the selected data when printed on a report, and the prompt if used in a Report Writer/Mass Load select statement with a variable value. Dictionary prompts cannot contain ampersands (&). The system populates this field with the Dict ID, but you can enter your own heading or prompt in this field.

Complete the following formatting fields for this item:

Field	Description
Justify (L/R)	Indicate whether this data item should align on the right or left side of the report column. Typically, text is left justified and numbers are right justified. Dates should be right justified.
Maximum Width	Enter the default maximum character width for the value.
Multi-Valued (Y/N)	Indicate whether this dictionary item can accommodate more than one entry. For example, in the entity file the ADDRESS dictionary item is multi-valued, allowing two lines of street address. Note: If a dictionary item identifies a single value or sub-value of a multi-valued field, set this field to N.
Sub-Valued (Y/N)	Indicate whether this dictionary item contains sub-values within a multi-valued field. For example, a record in the customer file can have six contacts, which are multi-values. Each contact has a name and phone number, which are sub-values.
Required (Y/N)	Indicate whether an entry for this dictionary item is mandatory when creating a record in the file.
Allow Update (Y/N)	Indicate whether this dictionary item can be updated using mass load or user-defined screens.
Case Mapping	Indicate whether the data stored in this field is set to Upper Case, Lower Case, Title Case (initial uppercase), or Alpha Only (all alpha characters are uppercase). Press F10 to select an option. Changing the case mapping has a from-this-point-forward effect; the system does not change existing data.
SFA Category	If the displayed dictionary item will be used in the Sales Force Automation application, press F10 and select an SFA category with which to associate this item.
Format (Output)	When needed, enter a standard Pick output conversion code that determines the report display format for the data stored in this field.
Update Subroutine	Identify a subroutine to be used to process the data entered from a screen or mass load to update the field.
Date / Year	If this is a date field, enter an asterisk (*). Define the format of the year by entering the number of digits to be displayed. The number of digits can be 0, 2, or 4. Ensure that the Maximum Width is set to allow for the separators, a two-digit month, a two-digit day, and the selected number of digits for the year. If the Maximum Width is not large enough, the date wraps to the next line.
Numeric / Decim / Negs	If this field is numeric, enter an asterisk (*). You must define the number of decimal places, and indicate whether negative numbers are allowed.
Y/N Only	If this field requires a Y or N response, enter an asterisk (*).
'*' Only	If this field must contain an asterisk () to be activated, enter an asterisk (.)
Word Wrap Disp Lines / Max Lines	If the data in this field can wrap from one line to the next, enter an asterisk (*). Disp Lines is the number of lines to display on the screen. Max Lines is the maximum number of lines you can enter for this field.
Eclipse Dictionary	If this dictionary item is part of the core Eclipse system, this option displays an asterisk (*) and you cannot modify it.
Archived	If this dictionary item has been archived, this option displays an asterisk (*). An archived dictionary item is obsolete, but is still being used by various user-defined report writer reports and user-defined screens. If you access a report or screen that uses an archived dictionary item, the system displays a warning. We recommend that you replace it with a current dictionary item, but you can also ignore the warning. An archived dictionary item does not display the first time you press F10 to add items to mass load, report writer, order entry prompts, and user-defined screens. Press F10 again to access archived items.

Use any of the following hot keys as needed:

Hot Key	Function
Copy	Creates a dictionary item for the displayed file or another file, by copying the displayed dictionary item.
Delete	Deletes the displayed dictionary item from the dictionary file. The system prompts you to confirm the deletion. Note: You cannot delete a dictionary item that is open for editing. The system deletes the latest revision, but does not delete the dictionary item.
Valid	Makes the dictionary item a validated field.
I-Desc	Displays the I-Descriptor Program Maintenance screen, where you can enter a formula that determines the value of this dictionary item.
Expand	Displays an expanded view of the Prompt or Description field. The expanded Prompt field contains 3 lines the same width as the value in the Maximum Width field. The expanded Description field contains 3 lines that are 60 characters wide. You can erase the displayed text and type new text for this field. Use this screen to determine whether the text fits on one line or wraps to a new line.
Prompt	Lists the standard prompts that you can use with this dictionary item. When creating a dictionary item, press F10 to display the list of available prompts.
Log	Displays the Maintenance Log Viewing screen for the displayed dictionary item.
Test	Selects a record from the file and displays the output defined by this dictionary item.
Access	Displays the Access Control List screen, where you can designate user IDs or group IDs that can access the data in this record from a laptop or Palm computing device and the level of access for each ID.
Key	Use to identify the names of files for which this dictionary item is the key. For each entry, press F10 and select a file name.

Press Esc to save the updated dictionary item information and exit the Dictionary Maintenance screen.