FUN_DOCIO_FLOW_CONFIGS_
This table contains runtime configuration values for each input and output flow of the document. The run-time values persisted in this table apply to the entire instance and override the default settings. Configuration values can also be specified at the document level and, those values are stored in INPUT_PAYLOAD in FUN_DOCIO_FLOW_EXECUTIONS table.
Details
-
Schema: FUSION
-
Object owner: FUN
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
Name | Columns |
---|---|
FUN_DOCIO_CONFIGS_PK_ |
LAST_UPDATE_DATE, LAST_UPDATED_BY, CONFIG_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
CONFIG_ID | NUMBER | 18 | Yes | Identifies the Document IO flow configuration. | |
CONFIG_OWNER | VARCHAR2 | 64 | Identifies the Document IO flow configuration owner table. | ||
CONFIG_OWNER_ID | NUMBER | 18 | Identifies the owner for the Document IO flow configuration. | ||
CONFIG_NAME | VARCHAR2 | 100 | Document IO flow configuration name. | ||
CONFIG_VALUE | VARCHAR2 | 4000 | Document IO flow configuration value. | ||
CREATED_BY | VARCHAR2 | 64 | Who column: indicates the user who created the row. | ||
CREATION_DATE | TIMESTAMP | Who column: indicates the date and time of the creation of the row. | |||
LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
OBJECT_VERSION_NUMBER | NUMBER | 9 | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | ||
AUDIT_ACTION_TYPE_ | VARCHAR2 | 10 | Action Type - have values like INSERT, UPDATE and DELETE. | ||
AUDIT_CHANGE_BIT_MAP_ | VARCHAR2 | 1000 | Used to store a bit map of 1s and 0s for each column in the table. | ||
AUDIT_IMPERSONATOR_ | VARCHAR2 | 64 | Original Impersonator User. |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
FUN_DOCIO_FLOW_CONFIGS_N1_ | Non Unique | Default | CONFIG_ID |
FUN_DOCIO_FLOW_CONFIGS_U1_ | Unique | Default | LAST_UPDATE_DATE, LAST_UPDATED_BY, CONFIG_ID |