FPSAPP.APP_G_LABEL_TRANSLATIONS

>

> FPSAPP.APP_G_LABEL_TRANSLATIONS

Table FPSAPP.APP_G_LABEL_TRANSLATIONS"

Many clients have their own names that they use to label certain fields in the DWH. For example, they refer to facility_segment as Quartile or they refer to route_group as Technology. This table allows us to display the client accepted display name on our applications, particularly in Options and Filters. The wafer_size column merits special mention because at most clients we use the wafer_size field to represent something other than wafer size. This is because wafer_size is part of the default filters for all web applications and because it is the only default filtering field on Dashboard which filters both processes and tools. In a perfect world, we might rename this field in the DWH to something more generic but in the real world the best solution is to be able to configure the display name used when labeling this field which we can do in this table.

• Schema: FPSAPP

• Tablespace: FPSDATA

• Primary key: LABEL_NAME