State Form Table Aliasing

Easily modify the Table Alias column for an existing table within a state form.

Modifying the Table Alias column directly in State Form Definition form requires updating every other column that references the table. However, changing the table alias using State Form Table Aliasing form only requires one modification; all other columns will be updated automatically.

1. In the State Form field, select a state form.
2. In the Record field, select the record that contains the table to be aliased. If there is only one record for the selected state form, it will be defaulted.
3. For the Table field, select the table to which the alias will be applied. If there is only one table for the selected record, it will be defaulted.
4. For the Alias field, enter the desired alias. If updating an existing alias, replace the value in the Alias field with the desired alias.
   • Notes:
     • A table alias should be short, but also descriptive so that it's easily identifiable. For example, 'SYSTEM.patient_current_demographics' could be replaced by the alias DEM.
     • Please do not include any underscores in the table alias as this will cause issues when the state form is compiled.
5. Submit. 
6. Every instance of the associated table and state form in State Form Definition will be replaced with the newly entered alias.