Data Dictionary
>
FPSINPUT Tables
> FPSINPUT.FR_W_MNT_SESSIONS
Table FPSINPUT.FR_W_MNT_SESSIONS"
Stores unique maintenance event sessions and session details for a given instance of a maintenance event
-
Schema: FPSINPUT
-
Tablespace: FPSDATA
-
Primary key: ID
-
Referenced by: FPSAPP.FR_W_MNT_SESSION_COMMENTS (ID) FPSAPP.FR_W_MNT_SESSION_REPORTS (ID) FPSAPP.FR_W_MNT_SESSION_SAFETY_ACKS (ID) FPSAPP.FR_W_MNT_SESSION_TASKS (ID)
|
Column |
Type |
Nullable |
Comment |
|---|---|---|---|
|
ID |
NUMBER(16) |
N |
|
|
COMPLETE_INST |
DATE |
||
|
COMPLETE_UTC_INST |
DATE |
||
|
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) |
|
|
ENVIRONMENT |
VARCHAR2(50) |
||
|
FACILITY_NAME |
VARCHAR2(200) |
||
|
FAMILY_NAME |
VARCHAR2(200) |
||
|
FR_EQP_TYPE_ID |
NUMBER(16) |
||
|
FR_EQP_TYPE_NAME |
VARCHAR2(200) |
||
|
GRANDPARENT_WORKFLOW_ID_ORIGIN |
NUMBER(16) |
||
|
GREATGRANDPARENT_WORKFLOW_ID |
NUMBER(16) |
||
|
IDENTIFIER |
VARCHAR2(200) |
||
|
MNT_CATEGORY |
VARCHAR2(50) |
||
|
MNT_EVENT_NAME_DISPLAY |
VARCHAR2(200) |
||
|
MNT_EVENT_VERSION_NUMBER |
NUMBER(16) |
||
|
MNT_SYSTEM_NAME_SESSION |
VARCHAR2(200) |
||
|
MODULE_NAME |
VARCHAR2(200) |
||
|
REVIEW_REQUIRED |
CHAR(1) |
||
|
REVIEW_ROLE |
VARCHAR2(50) |
||
|
START_INST |
DATE |
Time when the lot started. (* from FPSINPUT.WIP_STARTS) |
|
|
START_UTC_INST |
DATE |
||
|
STATUS |
VARCHAR2(13) |
||
|
TOOL_DESCRIPTION |
VARCHAR2(200) |