Changing Captions for Custom Fields

<< Click to Display Table of Contents >>

Navigation:  Professional > Database >

Changing Captions for Custom Fields

While changing the name of any field in the core EQuIS Database structure is not permitted, the caption of a field can be changed to further customize it. Doing so allows you to see the customized caption for a field in the table view of EQuIS Professional.


Warning: The field captions will be changed for all users of the database!


Edit Captions in EQuIS Professional


1.Open EDP from Professional, click Format. Navigate to the DataDictionary format file in the EQuIS installation directory, ..\EarthSoft\EQuIS\Formats\EarthSoft\

2.Right-click Caption and select Load Data File to load a previously created Excel template or add new values by right-clicking in the table and selecting Add New Row. A row can be deleted by selecting it and using the Delete key on the keyboard.

3.Fill in the appropriate fields as follows.

a.Use the drop-down menu to select the appropriate LANGUAGE_CODE.

b.TABLE_NAME is the table where the custom caption is located.

c.The TABLE_CAPTION column changes the caption of the referenced table.

d.COLUMN_NAME is the column where the custom caption will be placed.

e.The COLUMN_CAPTION column changes the caption of the referenced column.

f.The remark column adds any extra remarks to the remark column in the RT_REMAP_DETAIL.



To change the captions on both the table and one of its constituent fields, separate rows must be used in the EDD. In other words, populate TABLE_NAME and TABLE_CAPTION in one row to change the table caption. Add other rows with the TABLE_NAME, COLUMN_NAME, and COLUMN_CAPTION fields populated to change captions on fields within that table.

In order to create rows in RT_REMAP_DETAIL, the format expects a row to either be a table row or a column row.  

In order to create a table in RT_REMAP_DETAIL_MAPPING, table_caption must be populated and column_name must NOT be populated.

In order to create a column RT_REMAP_DETAIL_MAPPING, column_caption and column_name must be populated.

The names do not get in the updates in interfaces such as Groups, and in Forms in Professional, and other products such as SPM.


4.Load this data as if it were an EDD. The Insert & Merge commit type is recommended.

5.Refresh the affected table(s) in EQuIS Professional to confirm that field captions have been updated. Refresh the database connection (e.g. log in again) to confirm that table captions have been applied.