Data Dictionary
>
FPSINPUT Tables
> FPSINPUT.SMMS_W_MNT_EVENT_CHG_HIST
Table FPSINPUT.SMMS_W_MNT_EVENT_CHG_HIST"
Stores the change log of changes made to maintenance event definitions
-
Schema: FPSINPUT
-
Tablespace: FPSDATAHIST
-
Primary key: ID
|
Column |
Type |
Nullable |
Comment |
|---|---|---|---|
|
ID |
NUMBER(16) |
N |
|
|
INST |
DATE |
Time when the event occurred. (* from FPSINPUT.WIP_EVENT_HIST) |
|
|
MNT_EVENT |
VARCHAR2(200) |
||
|
MNT_EVENT_DISPLAY |
VARCHAR2(200) |
||
|
MNT_EVENT_EXTERNAL |
VARCHAR2(200) |
||
|
MNT_EVENT_TRANSACTION |
VARCHAR2(50) |
||
|
REQUIRED_HOURS |
NUMBER(5,2) |
||
|
TRANSACTION_COMMENT |
VARCHAR2(2000) |