This page (revision-20) was last changed on 26-Nov-2021 10:22 by jescott

This page was created on 26-Nov-2021 10:22 by JMyers

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
20 26-Nov-2021 10:22 3 KB jescott to previous
19 26-Nov-2021 10:22 3 KB jescott to previous | to last
18 26-Nov-2021 10:22 3 KB JMyers to previous | to last
17 26-Nov-2021 10:22 3 KB JEscott to previous | to last
16 26-Nov-2021 10:22 3 KB JEscott to previous | to last
15 26-Nov-2021 10:22 3 KB JEscott to previous | to last
14 26-Nov-2021 10:22 3 KB JEscott to previous | to last
13 26-Nov-2021 10:22 3 KB JEscott to previous | to last
12 26-Nov-2021 10:22 2 KB RForbes to previous | to last
11 26-Nov-2021 10:22 2 KB RForbes to previous | to last
10 26-Nov-2021 10:22 2 KB RForbes to previous | to last
9 26-Nov-2021 10:22 2 KB JMyers to previous | to last
8 26-Nov-2021 10:22 2 KB JMyers to previous | to last
7 26-Nov-2021 10:22 2 KB JMyers to previous | to last
6 26-Nov-2021 10:22 2 KB JMyers to previous | to last
5 26-Nov-2021 10:22 2 KB JMyers to previous | to last
4 26-Nov-2021 10:22 2 KB JMyers to previous | to last
3 26-Nov-2021 10:22 2 KB JMyers to previous | to last
2 26-Nov-2021 10:22 2 KB JMyers to previous | to last
1 26-Nov-2021 10:22 2 KB JMyers to last

Page References

Incoming links Outgoing links
IMCD
IMCD

Version management

Difference between version and

At line 1 changed one line
!!!MAINTAIN COLUMN DETAILS
MAINTAIN COLUMN DETAILS
At line 3 changed one line
The Maintain Column Details (IMCD) screen allows you to view information about the columns in individual screens. The IMCD has a very deep significance in the application as it controls how the fields are displayed and behave (through the domain) and must be tied correctly to the definitions that are also held in the EAR. These columns must NOT be changed.
The Maintain Column Details (IMCD) screen allows you to view information about the columns in individual screens.
You may access this feature through the Screens/Forms menu:
Application Administration > System Structures > Maintain Column Details
‘Maintain Column Details’ Usage and Examples
Seq #
This field indicates the sequential order of the column within the form.
Column Name
This field holds the official name of the column.
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.
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)’.)
Prompt
This field shows the name that will appear on form for the item.
This name will default in from P2KHHRM, however you may change it.
At line 5 changed 29 lines
The definition data for the Maintain Column Details screen is stored in the [P2K_AM_TABLE_DETAILS] and [P2K_AM_COLUMN_DETAILS] tables.
;[Seq #|COLUMN_SEQUENCE]:This field indicates the sequential order of the column within the form.
;[Prompt|FIELD_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|COLUMN_NAME]:This field holds the official name of the column.
;[Prompt (FRE)|FIELD_PROMPT_TRANSLATE]: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|COLUMN_USAGE]:This field identifies if the column was pre-loaded with the application or if the column was added by the client as user defined.
;[Data Type|DATA_TYPE]:This field identifies if the format of data in the column. For example is numerical, alphanumeric or date.
;[Domain Name|DOMAIN_NAME]:This field identifies if the name of the column's domain i.e. ID, TOGGLE
;[Lexicon Name|LEXICON_NAME]: If the column is associated to a lexicon, the name of the lexicon is indicated here.
;[Description|DESCRIPTION]:This field provides a short description of the purpose of the column.
;[Length|VALUE_LENGTH]:This field indicates how many characters are allowed in the column in the database.
;[Format|VALUE_FORMAT]:This field indicates if the column has a specific format defined, i.e. 999,999.9999
;[Table Reference ID|REFERENCE_ID]:This field displays a foreign key link from the originating table back to the ID found on a related table. Typically, another field on the same record will identify which table the "related table" is.
;[Code Sequencing Allowed|CODE_SEQUENCE_ALLOWED]: This toggle determines if code sequencing is allowed for the column.
;[No View Allowed|NO_VIEW_ALLOWED]: This toggle indicates if the column is enabled to be viewed by an end user.
;[No Update Allowed|NO_UPDATE_ALLOWED]:If this toggle is on, the user will not be allowed to edit the data in the column
;[Translation Allowed|TRANSLATION_ALLOWED]: This toggle determines if column may be translated to a different language.
;[Mandatory|MANDATORY]:If this toggle is on, the user will be required to complete this column before saving the form.
;[Logging Not Allowed|LOGGING_NOT_ALLOWED]: This field, set by the system, indicates if logging is even permitted on this field/table. Some tables do not make sense to log, due to their volatility or transactional nature.
;[Disabled Logging|DISABLE_LOGGING]: When checked, the field or table that it pertains to will no longer be logged for audit purposes.
;[Must Date Split|MUST_DATE_SPLIT]: This field has be deprecated, and is no longer used.
----
![Notes|Edit:Internal.IMCD]
[{InsertPage page='Internal.IMCD' default='Click to create a new notes page'}]
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 Refrence 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
This page (revision-20) was last changed on 26-Nov-2021 10:22 by jescottTop