Miniramp table

The table contains two timestamped row. One which will be updated at the start of a miniramp, the other at the end of a miniramp.

A user registered to the associated alert will receive a message after an update on either row with the message: MINIRAMP START or  MINIRAMP STOP as appropriate.

Table (action=START) will be updated just before the timing event is sent to start the miniramp (after a succesful database update and load to the equipment).

Table (action=STOP) will be updated after completion of miniramp.

 If successful status = 0.  Status = 1 in case of problems.  The status bit will be set if:
- the database update or the load to the power converter fails (action = START)
- the miniramp itself fails (due to timing problems or whatever) (action=STOP)

So if status = 1 assume the energy of the machine did not change.

 

 TIMESTAMP             DATE
 ACTION                VARCHAR2(10)
 STATUS                NUMBER(1)
 NOMINAL_ENERGY        NUMBER(6,3)
 ADJUSTED_ENERGY       NUMBER(6,3)
 
 
 
 The update of e-nominal in the f_pp_actset will occur some seconds before the miniramp starts. M_CONSTANTS will also be updated with the adjusted energy but not synchronously with the miniramp.

A history table of events will also be created.