Changing Captions for Custom Fields
Copyright © 2020 EarthSoft, Inc • Modified: 24 Feb 2020
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!
1.Open EDP from Professional, click Format. Navigate to the DataDictionary format file in the EQuIS installation directory, ..\EarthSoft\EQuIS\Formats\EarthSoft\DataDictionary.xsd
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.
Note: 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.
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.