Introduction › How Public Interfaces Differ › Derived Property Values

Derived Property Values

Host Public Interface tables contain several columns that represent derived property values. These values cannot be calculated within an SQL statement. For example, in the table Field, the Role column can represent date, foreign key, or denormalized field. In the CSE, the column Role was removed from the view Field, and three new views were added as follows:

• FIELD_DATA_I
• FIELD_DENORM_I
• FIELD_FGN_KEY_I

These new views can be joined with the view Record.

In general, Host views that have columns of derived property values are split into multiple views on the CSE.