In some cases, the system requires additional data from you for a dictionary item listed on the Report Writer/Mass Load Design screen to produce accurate information. For example, if a dictionary item is multi-valued, you need to indicate the value to use for the report or to update by the mass load. If an I-Descriptor dictionary item determines a report field value, you may need to enter additional information, such as start and end dates, to evaluate the I-Descriptor formula.
An asterisk displayed next to a column number on the Report Writer/Mass Load Design screen indicates that the field requires column data. When you position the cursor on a field that requires column data, the Column Data hot key highlights.
Use the Column Data screen for entering additional data required for a report or mass load field.
To enter column data for a report or mass load:
Log into the character-based system. This feature is not available in a Solar Eclipse interface.
On a Report Writer/Mass Load Design screen that is set up for a report or a mass load, position the cursor on a field that requires column data and use the Col Data hot key to display the Column Data screen.
You can also display this screen using the Column Data hot key on the Report Driver or Mass Load Driver screens.
This screen displays the column number, first line of the column heading, and dictionary item prompt for each field that requires additional data from you.
Note: To edit a prompt, use the Edit Prompts hot key on the Report Writer/Mass Load Selection screen.
Use the Expand hot key, as needed, to display the complete column heading for an item.
The display screen is the width of the column heading. You can change the text of the heading in this screen. If the column heading is longer than the column width, the text wraps. You can use up to three lines for the heading. If the text wraps, an asterisk (*) precedes the text in the Column Heading field. Mass Load only uses the first line of the heading.
In the Data field for each listed item, enter the data described in the Prompt field. The program uses this data to calculate the value to print in the designated column of the report or display in the designated column of the mass load update screen.
Note: If the prompt is for a multi-valued position, enter 0 to indicate all values, 1 to indicate the first value, 2 to indicate the second value, and so forth.
You can use the Delete Data hot key to clear all data from the Data column. Eclipse prompts you to confirm the deletion.
Press Esc to save the column data and return to the previous screen.
See Also: