T-Sensor user tables

In cooperation with S. Kovar a data model has been defined. The corresponding tables are located in the online Condition DB managed by A. Formica. A real time replica is provided to make this tables available to the offline world. If you want to use this tables, please contact me for access information. NEW: The design of the T-Sensor tables has been updated. The new design incorporates easy to use alarm configuration.

Further details on the T-Sensor user tables can be found in this document.

This tables are maintained by myself. If you find any error or do have any corrections please feel free to contact me.

History table of the standardized flag system

Following the definition of the standardized flags, a history table for the standardized flag system was needed. The data model of this tables has been defined in cooperation with S. Kovar and P. Fleischmann. The history tables are located in the online Condition DB managed by A. Formica. A real time replica is provided to make this tables available to the offline world. If you want to use this tables, please contact me for access information.

Further details on the history tables can be found in this document.

Bad Sensor Report on the web

There is now a bad sensor report available on the web. The page displays the last report as default and list of all reports with links at the bottom of the page. So you can easily browse through all reports. It is beeing generated automatically from the table MDT_SENSOR_STAT. The table is accessible through the account ATLAS_MDT_DCS_W of the ATONR database. If you need the PWD, please contact S. Kovar or H. Fuchs.

Structure of the table is (DESC MDT_SENSOR_STAT):

There is an automatic trigger, which creates and fills a sequence number and a created_on column. Furthermore, there exists a procedure which inserts a report into the table:

MDT_SENSOR_INSERT.p_ins_Mdt_Sensor_Stat(report,user); 

For example:

Exec MDT_SENSOR_INSERT.p_ins_Mdt_Sensor_Stat
('This is the first report. Test Report.','Stepan');

The size of an report is limited up to 4k.

If you have any comments, wishes or complains, please, do not hesitate to come. I hope this small apps will be helpful for many of us. Klick here to see the bad sensor report web