Custom Captions for Database Columns

While changing the name of any field in the core EQuIS Database structure is not permitted, administrators can change the caption of a field. This shows the customized caption for a field (rather than the original field name in the database) 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.Contact EarthSoft Support for access to the DataDictionary format.

2.Download the format and unblock the file.

3.Open EDP from Professional and click Format.

4.Navigate to the DataDictionary format file.,

5.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. Delete a row by selecting it and typing Delete.

6.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. Please avoid spaces and special characters when naming database objects, with the exception of the underscore.

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

Notes:

•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.

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

8.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.