Data Dictionary
>
FPSBASE Tables
> FPSBASE.FR_W_MNT_SESSION_TASK_DATA
Table FPSBASE.FR_W_MNT_SESSION_TASK_DATA"
Stores each form input from a maintenance task
-
Schema: FPSBASE
-
Tablespace: FPSDATA
-
Primary key: MNT_SESSION_TASK_ID, VARIABLE_NAME
|
Column |
Type |
Nullable |
Comment |
|---|---|---|---|
|
MNT_SESSION_TASK_ID |
NUMBER(16) |
N |
|
|
VARIABLE_NAME |
VARCHAR2(400) |
N |
|
|
INST |
DATE |
Time when the event occurred. (* from FPSINPUT.WIP_EVENT_HIST) |
|
|
INST_UTC |
DATE |
||
|
REPORT_VARIABLE |
CHAR(1) |
||
|
SELECTED_OPTION |
VARCHAR2(50) |
||
|
USER_NAME_DISPLAY |
VARCHAR2(200) |
||
|
VARIABLE_DATATYPE |
VARCHAR2(20) |
||
|
VARIABLE_LABEL |
VARCHAR2(400) |