For each TABLE_NAME in T_SLALOM_OUTPUTS, a view named V_SO_<tablename> is created (where <tablename> is the name of the table for which the view is created).
For the different values of the TABLE_NAME field from the T_SLALOM _OUTPUTS table, in the table T_SO_FIELD_ NAMES definition for the data structure in the VAL_X fields is given.
Similar to V_RD_<eventtype>, every view defined for the specific TABLE_NAME value exposes different fields. The views have all the fields that are in the V_SLALOM_OUTPUTS view, except that the VAL_X fields are replaced with custom named fields that depend on the field definitions for the table name in the T_SO_TABLE_NAMES table.
In case the Table name and/or the Field names contain non-ASCII characters, they are replaced by '_', or removed from the name, the same as for V_RD_<eventtype>.
Names longer than 30 characters are truncated. In case the truncation returns a name that already exists, the name is changed to end with a sequence number, the same as for V_RD_<eventtype>.
It is possible that in the T_SLALOM_OUTPUT table there exist TABLE_NAMEs for which there is no information for the data structure in the T_SO_FIELD_NAMES table. In such a case the View is still created, but instead of custom field names, the field names follow the VAL_X naming convention.
|
Copyright © 2013 CA.
All rights reserved.
|
|