This is version 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 . It is not the current version, and thus it cannot be edited.

Back to current versionRestore this version

MAINTAIN COLUMN DETAILS#

The Maintain Column Details (IMCD) screen allows you to view information about the columns in individual screens.

The definition data for the Maintain Column Details screen is stored in the P2K_AM_TABLE_DETAILS and P2K_AM_COLUMN_DETAILS tables.

Seq #

This field indicates the sequential order of the column within the form.

Prompt

This field displays how the column will be identified on the column.

If a prompt is not specified in IMFD, the 'Field Prompt' from the Column Detail field on IMCD will be displayed as the name of the group item on the form.

There are screens where a displayed prompt is not necessary or desired. In this case, you will enter two quotation marks (" ") in the prompt field to get a blank title.

Column Name

This field holds the official name of the column.

Prompt (FRE)

If the form is to be displayed in a second language, this field allows you to provide an alternate language name for the group item. (On the example screen, the second language is identified as French, ‘Prompt (FRE)’.)

Column Usage

Data Type

This field identifies if the format of data in the column. For example is numerical, alphanumeric or date.

Domain Name

Lexicon Name

Description

This field provides a short description of the purpose of the column.

Length

This field indicates how many characters are allowed in the column.

Formal

Error Code

Reference

Code Sequencing Allowed

No View Allowed

No Update Allowed

If this toggle is on, the user will not be allowed to edit the data in the column

User Label Allowed

Translation Allowed

Mandatory

If this toggle is on, the user will be required to complete this column before saving the form.

Logging Not Allowed

Disabled Logging

Need clarification - One of the few columns on the form that can be updated by clients is the Disable Logging toggle which if the Logging Allowed is Y will stop the column from being logged.

Must Date Split

Default Trigger Field

Validation Clause

Defaulted From

LOV Query