Data Dictionary
>
FPSBASE Views
> FPSBASE.WIP_WAFER_HIST_LOOP
View FPSAPP.DASH_P_DB_CONSTANTS
Gets all data that is constant for the database and does not need to be refreshed with the data update.
|
Column |
Comment |
|---|---|
|
DB_NAME |
|
|
DB_VERSION |
|
|
DWH_VERSION |
|
|
CLIENT_NAME |
Short company name of the client. See site_name comment for client/site/facility example. (* inherited from FPSINPUT.GEN_SITE) |
|
CLIENT_NAME_DISPLAY |
Longer display friendly client name. (* inherited from FPSINPUT.GEN_SITE) |
|
SITE_NAME |
Short name of the site. Each DWH instance must be for a single site but we can have one or more sites for a given client and we can have one or more facilities at a given site. To use a famous company who we will never work for as an example, the client_name would be GM, client_name_display General Motors, site_name GMDET, site_name_display GM Detroit Truck Fab, and two facilities on the site F150 and F250. (* inherited from FPSINPUT.GEN_SITE) |
|
SITE_NAME_DISPLAY |
Longer display friendly site name. (* inherited from FPSINPUT.GEN_SITE) |
|
DEFAULT_FACILITY |
For sites with multiple facilities, applications will default to this facility upon opening. Also create/update scripts might use this. (* inherited from FPSINPUT.GEN_SITE) |
|
USE_ETP_FOR_WEB |
Flag to display FPS ETP states on dashboard instead of client standard EQP states. (* inherited from FPSINPUT.GEN_SITE) |
|
TIME_ZONE_OF_MES_DATA |
This column should be null as long as the data from the MES is in the same time zone as the facility in which the people are using the applications. But if the MES data is loaded from a different time zone (ex: UTC for daylight savings time support) then this value should be set to the time zone of the MES data and the TIME_ZONE_OF_WEB_VIEWER should be set to the time zone of the facility where the users are viewing the data. It is important to note that both time zone fields must either be null (which will then apply the dbtimezone of the database server) or all must be not null and specified based on the appropriate time zone for each field. Time zones are listed at https://docs.oracle.com/cd/E84527_01/wcs/tag-ref/MISC/TimeZones.html. (* inherited from FPSINPUT.GEN_SITE) |
|
TIME_ZONE_OF_WEB_VIEWER |
See column comment on TIME_ZONE_FOR_MES_DATA for details. (* inherited from FPSINPUT.GEN_SITE) |