Data Dictionary
>
FPSBASE Tables
> FPSBASE.FR_W_MNT_SESSION_TASKS
Table FPSBASE.FR_W_MNT_SESSION_TASKS"
Stores the tasks which are part of a maintenance session
-
Schema: FPSBASE
-
Tablespace: FPSDATA
-
Primary key: ID
-
Foreign keys: FR_W_MNT_SESSION_TASKS_FK_MID: MNT_SESSION_ID REFERENCES FPSAPP.FR_W_MNT_SESSIONS (ID)
-
Referenced by: FPSAPP.FR_W_MNT_SESSION_TASK_FILES (ID) FPSAPP.FR_W_MNT_SESSION_TASK_STORAGE (ID) FPSAPP.FR_W_MNT_SESSION_TASK_USERS (ID)
|
Column |
Type |
Nullable |
Comment |
|---|---|---|---|
|
ID |
NUMBER(16) |
N |
|
|
CHILD_WORKFLOW_ID |
NUMBER(16) |
||
|
CURRENT_TASK_USER_NAME_DISPLAY |
VARCHAR2(200) |
||
|
DURATION_SEC |
NUMBER(9) |
Duration in seconds of the period to be used to run the APF report. Used only for CLR, CLRA, and QE. (* from FPSADMIN.CFG_TABLES) |
|
|
ENTITY_DESC |
VARCHAR2(200) |
||
|
ENTITY_NAME |
VARCHAR2(200) |
||
|
GRANDPARENT_WORKFLOW_ID |
NUMBER(16) |
||
|
GROUP_NUMBER |
NUMBER(16) |
||
|
IDENTIFIER |
VARCHAR2(200) |
||
|
INPROGRESS_START_INST |
DATE |
||
|
INPROGRESS_START_INST_UTC |
DATE |
||
|
LAST_MOD_FR_USER_LOGIN |
VARCHAR2(200) |
||
|
LAST_MOD_INST |
DATE |
||
|
LAST_MOD_INST_UTC |
DATE |
||
|
LAST_MOD_USER_NAME_DISPLAY |
VARCHAR2(200) |
||
|
MNT_CATEGORY |
VARCHAR2(50) |
||
|
MNT_EVENT_VERSION_ID |
NUMBER(16) |
||
|
MNT_EVENT_VERSION_PRCD_ID |
NUMBER(16) |
||
|
MNT_SESSION_ID |
NUMBER(16) |
||
|
MNT_TASK_ID |
NUMBER(16) |
||
|
MNT_TYPE_NAME |
VARCHAR2(200) |
||
|
PARENT_WORKFLOW_ID |
NUMBER(16) |
||
|
STAGED_INST_UTC |
DATE |
||
|
STATUS |
VARCHAR2(13) |
||
|
TASK_CATEGORY |
VARCHAR2(200) |
||
|
TASK_NAME_DISPLAY |
VARCHAR2(200) |
||
|
TASK_ORDER_END |
NUMBER(16) |
||
|
TASK_ORDER_START |
NUMBER(16) |