Data Dictionary
>
FPSAPP Tables
> FPSAPP.FR_W_MNT_SESSION_TASK_USERS
Table FPSAPP.FR_W_MNT_SESSION_TASK_USERS"
Stores the interactions between users and maintenance session tasks
-
Schema: FPSAPP
-
Tablespace: FPSDATA
-
Primary key: MNT_SESSION_TASK_ID, FR_USER_LOGIN, INST_START_UTC
-
Foreign keys: FR_W_MNT_SES_TASK_USERS_FK_TID: MNT_SESSION_TASK_ID REFERENCES FPSAPP.FR_W_MNT_SESSION_TASKS (ID)
|
Column |
Type |
Nullable |
Comment |
|---|---|---|---|
|
MNT_SESSION_TASK_ID |
NUMBER(16) |
N |
|
|
FR_USER_LOGIN |
VARCHAR2(200) |
N |
|
|
INST_START_UTC |
DATE |
N |
|
|
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) |
|
|
INST_END |
DATE |
||
|
INST_END_UTC |
DATE |
||
|
INST_START |
DATE |
||
|
SELECTED_OPTION |
VARCHAR2(50) |