Data Dictionary
>
FPSBASE Tables
> FPSBASE.FR_W_WORKFLOW_TASK
Table FPSBASE.FR_W_WORKFLOW_TASK"
LogicNets stores all instances of tasks from all workflows in this table and provides each instance of a task a unique identifier. The system stores this id in the workflow_instance column of this table. With this ID you can retrieve all tasks associated with a particular workflow.
-
Schema: FPSBASE
-
Tablespace: FPSDATA
-
Primary key: ID
-
Foreign keys: FR_W_WORKFLOW_TASK_FK_WF_ID: WORKFLOW_INSTANCE REFERENCES FPSAPP.FR_W_WORKFLOW (ID)
-
Referenced by: FPSAPP.FR_W_WORKFLOW_TASK_TAGS (ID)
|
Column |
Type |
Nullable |
Comment |
|---|---|---|---|
|
ID |
NUMBER(16) |
N |
|
|
ACTIONS |
CLOB |
||
|
ACTUAL_END_STAMP |
NUMBER(14,6) |
||
|
ACTUAL_START_STAMP |
NUMBER(14,6) |
||
|
ASSIGNMENTID |
VARCHAR2(255) |
||
|
BUDDY_USER_ID |
VARCHAR2(200) |
||
|
CMT |
VARCHAR2(200) |
||
|
CREATED |
NUMBER(14,6) |
||
|
CREATED_BY |
VARCHAR2(200) |
||
|
DISPLAY |
VARCHAR2(25) |
This is the short description to show on the scheduler web ui (* from FPSAPP.SCH_C_TMP_SCHED_GROUPS) |
|
|
EXPIRATION_DATE |
NUMBER(14,6) |
||
|
FR_USER_LOGIN |
VARCHAR2(200) |
||
|
LAST_UPDATED |
NUMBER(14,6) |
||
|
LOAD_NET |
VARCHAR2(100) |
||
|
LOCKED |
VARCHAR2(25) |
||
|
OBJECT_ID |
NUMBER(16) |
||
|
OBJECT_NAME |
VARCHAR2(30) |
This could be an object name (we will disable loading of that object in the scheduled jobs), a load job (we will disable loading of all objects in that scheduled job), an FPSAPP prefix (we will disable loading of all objects with that prefix), a constraint (we can explain why it is permanently disabled), or a trigger (technically an object so we can get away with omitting this from the column name and also to explain why it is permanently disabled). (* from FPSADMIN.CFG_DISABLED) |
|
|
OBJECT_TYPE |
VARCHAR2(19) |
||
|
OPTIONS |
CLOB |
||
|
PARAMETERS |
CLOB |
||
|
PLANNED_END_STAMP |
NUMBER(14,6) |
||
|
PLANNED_START_STAMP |
NUMBER(14,6) |
||
|
POST_PROCESS_NET |
VARCHAR2(100) |
||
|
PREVIOUS_SELECTED_OPTION |
VARCHAR2(50) |
||
|
PRE_PROCESS_NET |
VARCHAR2(100) |
||
|
PRIORITY |
VARCHAR2(7) |
This is the priority value as it is stored in the MES for each lot. It might be a number or a letter or word depending on the MES and the facility. (* from FPSINPUT.WIP_PRIORITIES) |
|
|
ROLE |
VARCHAR2(50) |
||
|
SAVE_NET |
VARCHAR2(100) |
||
|
SELECTED_OPTION |
VARCHAR2(50) |
||
|
SES |
VARCHAR2(100) |
||
|
STAGE |
NUMBER(3) |
||
|
STATUS |
VARCHAR2(13) |
||
|
SUBJECT_LINE |
VARCHAR2(100) |
||
|
TASK |
VARCHAR2(100) |
||
|
TASK_NET |
VARCHAR2(100) |
||
|
TRACK |
VARCHAR2(25) |
||
|
TYPE |
VARCHAR2(50) |
||
|
USER_GROUP |
VARCHAR2(100) |
||
|
WF_NET |
VARCHAR2(100) |
||
|
WF_NODE_ID |
NUMBER(16) |
||
|
WF_NODE_STATUS |
VARCHAR2(255) |
||
|
WORKFLOW_INSTANCE |
NUMBER(16) |