Data Dictionary
>
FPSAPP Tables
> FPSAPP.FR_W_MNT_SESSION_COMMENTS
Table FPSAPP.FR_W_MNT_SESSION_COMMENTS"
Stores comments related to a maintenance event session which are inputted by a user, primarily for cancellation of maintenance events, but may be used for other purposes as well
-
Schema: FPSAPP
-
Tablespace: FPSDATA
-
Primary key: MNT_SESSION_ID, INST_UTC
-
Foreign keys: FR_W_MNT_SES_COMMENTS_FK_SID: MNT_SESSION_ID REFERENCES FPSAPP.FR_W_MNT_SESSIONS (ID)
|
Column |
Type |
Nullable |
Comment |
|---|---|---|---|
|
MNT_SESSION_ID |
NUMBER(16) |
N |
|
|
INST_UTC |
DATE |
N |
|
|
FR_USER_LOGIN |
VARCHAR2(200) |
||
|
INST |
DATE |
Time when the event occurred. (* from FPSINPUT.WIP_EVENT_HIST) |
|
|
TRANSACTION_CMT_TYPE |
VARCHAR2(50) |
||
|
TRANSACTION_COMMENT |
VARCHAR2(2000) |
||
|
TRANSACTION_REASON |
VARCHAR2(200) |