FUN_WF_TRANSACTION_ATTRS

This table contains the transaction attribute names required for each workflow to be shown as a summary in the report.

Details

  • Schema: FUSION

  • Object owner: FUN

  • Object type: TABLE

  • Tablespace: FUN_WF_TRANSACTION_ATTRS

Primary Key

Name Columns

FUN_WF_TRANSACTION_ATTRS_PK

WORKFLOW_CODE

Columns

Name Datatype Length Precision Not-null Comments
PRODUCT_FAMILY_NAME VARCHAR2 30 Yes Product family to which the workflow belongs to. Possible values are Financials, Procurement, Human Capital Management, and so on.
PRODUCT_NAME VARCHAR2 30 Yes Product to which the workflow belongs to. Possible values are Payables, General Ledger, and so on.
WORKFLOW_CODE VARCHAR2 30 Yes Unique identifier for the workflow.
WORKFLOW_NAME VARCHAR2 64 Yes Name of the workflow for which the transaction attributes are listed in the summary report.
ATTRIBUTE1_DISPLAY_NAME VARCHAR2 64 The display name for the transaction attribute1.
ATTRIBUTE2_DISPLAY_NAME VARCHAR2 64 The display name for the transaction attribute2.
ATTRIBUTE3_DISPLAY_NAME VARCHAR2 64 The display name for the transaction attribute3.
ATTRIBUTE4_DISPLAY_NAME VARCHAR2 64 The display name for the transaction attribute4.
ATTRIBUTE5_DISPLAY_NAME VARCHAR2 64 The display name for the transaction attribute5.
ATTRIBUTE6_DISPLAY_NAME VARCHAR2 64 The display name for the transaction attribute6.
ATTRIBUTE7_DISPLAY_NAME VARCHAR2 64 The display name for the transaction attribute7.
ATTRIBUTE8_DISPLAY_NAME VARCHAR2 64 The display name for the transaction attribute8.
ATTRIBUTE9_DISPLAY_NAME VARCHAR2 64 The display name for the transaction attribute9.
ATTRIBUTE10_DISPLAY_NAME VARCHAR2 64 The display name for the transaction attribute10.
CONCATENATED_ATTRIBUTE_NAMES VARCHAR2 500 Concatenated display names for additional transaction attributes.
TRANSACTION_DATA_SQL VARCHAR2 4000 SQL query used to fetch the transaction data.
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.
OBJECT_VERSION_NUMBER NUMBER 9 Yes 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.

Indexes

Index Uniqueness Tablespace Columns
FUN_WF_TRANSACTION_ATTRS_PK Unique fun_wf_transaction_attrs_INDE WORKFLOW_CODE