The following columns have been changed on existing tables in this release of HxGN EAM.
Table name |
Column name |
New datatype |
Old datatype |
---|---|---|---|
R5ENERGYSTARSETUP |
ESS_ENERGYTYPE |
VARCHAR2(80) |
VARCHAR2(30) |
R5INSPECTEQUIPDATA |
IED_MAOP |
NUMBER(24,6) |
NUMBER |
R5INSPECTEQUIPDATA |
IED_NOMINALOD |
NUMBER(24,6) |
NUMBER |
R5INSPECTEQUIPDATA |
IED_ACTUALOD |
NUMBER(24,6) |
NUMBER |
R5INSPECTEQUIPDATA |
IED_ACTOT |
NUMBER(24,6) |
NUMBER |
R5INSPECTEQUIPDATA |
IED_DESOT |
NUMBER(24,6) |
NUMBER |
R5INSPECTEQUIPDATA |
IED_DESFACTOR |
NUMBER(24,6) |
NUMBER |
R5INSPECTEQUIPDATA |
IED_DESPRESS |
NUMBER(24,6) |
NUMBER |
R5INSPECTEQUIPDATA |
IED_DESCORRATE |
NUMBER(24,6) |
NUMBER |
R5INSPECTEQUIPDATA |
IED_DESMIN |
NUMBER(24,6) |
NUMBER |
R5INSPECTEQUIPDATA |
IED_DESMAX |
NUMBER(24,6) |
NUMBER |
R5INSPECTEQUIPDATA |
IED_HALFAPANGLE |
NUMBER(24,6) |
NUMBER |
R5INSPECTEQUIPDATA |
IED_INSIDESR |
NUMBER(24,6) |
NUMBER |
R5INSPECTEQUIPDATA |
IED_PIGGFREQ |
NUMBER(24,6) |
NUMBER |