SBS_WF_CUSTOM_SEARCH_ATTR
Stores custom workflow search attributes for workflow runs across typed search columns
Details
-
Schema: FUSION
-
Object owner: FND
-
Object type: TABLE
-
Tablespace: default
Primary Key
| Name | Columns |
|---|---|
|
SBS_WF_CUSTOM_SEARCH_ATTR_PK |
NAMESPACE_ID, RUN_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| NAMESPACE_ID | VARCHAR2 | 64 | Yes | Column stored the identifier value for a given namespace under which Workflow instance is getting executed | |
| RUN_ID | VARCHAR2 | 64 | Yes | Column stores the identifier value for a given workflow instance run | |
| SEARCH_ATTRIBUTES | CLOB | Column stores the search attributes in CLOB format | |||
| BOOL01 | VARCHAR2 | 1 | Column stores the custom Boolean type first attribute | ||
| BOOL02 | VARCHAR2 | 1 | Column stores the custom Boolean type second attribute | ||
| BOOL03 | VARCHAR2 | 1 | Column stores the custom Boolean type third attribute | ||
| DATETIME01 | TIMESTAMP | Column stores the custom Date time type first attribute | |||
| DATETIME02 | TIMESTAMP | Column stores the custom Date time type second attribute | |||
| DATETIME03 | TIMESTAMP | Column stores the custom Date time type third attribute | |||
| DOUBLE01 | NUMBER | 20 | Column stores the custom Double type first attribute | ||
| DOUBLE02 | NUMBER | 20 | Column stores the custom Double type second attribute | ||
| DOUBLE03 | NUMBER | 20 | Column stores the custom Double type third attribute | ||
| INT01 | NUMBER | 19 | Column stores the custom Integer type first attribute | ||
| INT02 | NUMBER | 19 | Column stores the custom Integer type Second attribute | ||
| INT03 | NUMBER | 19 | Column stores the custom Integer type third attribute | ||
| KEYWORD01 | VARCHAR2 | 255 | Column stores the custom Keyword type first attribute | ||
| KEYWORD02 | VARCHAR2 | 255 | Column stores the custom Keyword type second attribute | ||
| KEYWORD03 | VARCHAR2 | 255 | Column stores the custom Keyword type third attribute | ||
| KEYWORD04 | VARCHAR2 | 255 | Column stores the custom Keyword type fourth attribute | ||
| KEYWORD05 | VARCHAR2 | 255 | Column stores the custom Keyword type fifth attribute | ||
| KEYWORD06 | VARCHAR2 | 255 | Column stores the custom Keyword type sixth attribute | ||
| KEYWORD07 | VARCHAR2 | 255 | Column stores the custom Keyword type seventh attribute | ||
| KEYWORD08 | VARCHAR2 | 255 | Column stores the custom Keyword type eighth attribute | ||
| KEYWORD09 | VARCHAR2 | 255 | Column stores the custom Keyword type ninth attribute | ||
| KEYWORD10 | VARCHAR2 | 255 | Column stores the custom Keyword type tenth attribute | ||
| TEXT01 | VARCHAR2 | 1000 | Column stores the custom Text type first attribute | ||
| TEXT02 | VARCHAR2 | 1000 | Column stores the custom Text type second attribute | ||
| TEXT03 | VARCHAR2 | 1000 | Column stores the custom Text type third attribute | ||
| KEYWORDLIST01 | CLOB | Column stores the custom Keyword list type first attribute | |||
| KEYWORDLIST02 | CLOB | Column stores the custom Keyword list type second attribute | |||
| KEYWORDLIST03 | CLOB | Column stores the custom Keyword list type third attribute | |||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | 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. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| SBS_WF_CUSTOM_SEARCH_ATTR_U1 | Unique | DEFAULT | NAMESPACE_ID, RUN_ID |