1. Tables and Views for Financials
  2. FUN_PARALLEL_UNCHUNKED_DATA

FUN_PARALLEL_UNCHUNKED_DATA

This table contains the candidate data for processing. This data has not yet been chunked for processing.

Details

  • Schema: FUSION

  • Object owner: FUN

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

FUN_PARALLEL_UNCHUNKED_DATA_PK

PARALLEL_RUN_ID, DATA_KEY

Columns

Name Datatype Length Precision Not-null Comments
PARALLEL_RUN_ID NUMBER 18 Yes Parallel run to which this data belongs.
DATA_KEY VARCHAR2 100 Yes Unique value that represents a specific piece of data. It can also be a concatenated series of values.
PHASE_CODE VARCHAR2 30 Yes Phase to which this data belongs.
PRIORITY NUMBER 18 Priority of the candidate data.
DATA_COST NUMBER Estimated relative cost of processing a piece of data compared to other pieces of data.
SPLIT_VALUE VARCHAR2 100 Split value of the candidate data.
SIMPLE_GROUP_CODE VARCHAR2 101 Simple grouping value applied when the data is chunked.
ADVANCED_GROUP_CODE1 VARCHAR2 100 First advanced grouping value applied when the data is chunked.
ADVANCED_GROUP_CODE2 VARCHAR2 100 Second advanced grouping value applied when the data is chunked.
ADVANCED_GROUP_CODE3 VARCHAR2 100 Third advanced grouping value applied when the data is chunked.
ADVANCED_GROUP_CODE4 VARCHAR2 100 Fourth advanced grouping value applied when the data is chunked.
ADVANCED_GROUP_CODE5 VARCHAR2 100 Fifth advanced grouping value applied when the data is chunked.
ADVANCED_GROUP_CODE6 VARCHAR2 100 Sixth advanced grouping value applied when the data is chunked.
ADVANCED_GROUP_CODE7 VARCHAR2 100 Seventh advanced grouping value applied when the data is chunked.
ADVANCED_GROUP_CODE8 VARCHAR2 100 Eighth advanced grouping value applied when the data is chunked.
ADVANCED_GROUP_CODE9 VARCHAR2 100 Ninth advanced grouping value applied when the data is chunked.
DATA_CHAR1 VARCHAR2 100 First set of supplemental character data to help identify or join to the row of a chunk.
DATA_CHAR2 VARCHAR2 100 Second set of supplemental character data to help identify or join to the row of a chunk.
DATA_CHAR3 VARCHAR2 100 Third set of supplemental character data to help identify or join to the row of a chunk.
DATA_CHAR4 VARCHAR2 100 Fourth set of supplemental character data to help identify or join to the row of a chunk.
DATA_CHAR5 VARCHAR2 100 Fifth set of supplemental character data to help identify or join to the row of a chunk.
DATA_NUMBER1 NUMBER First set of supplemental numeric data to help identify or join to the row of a chunk.
DATA_NUMBER2 NUMBER Second set of supplemental numeric data to help identify or join to the row of a chunk.
DATA_NUMBER3 NUMBER Third set of supplemental numeric data to help identify or join to the row of a chunk.
DATA_NUMBER4 NUMBER Fourth set of supplemental numeric data to help identify or join to the row of a chunk.
DATA_NUMBER5 NUMBER Fifth set of supplemental numeric data to help identify or join to the row of a chunk.
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_PARALLEL_UNCHUNKED_DATA_N1 Non Unique FUSION_TS_TX_DATA PARALLEL_RUN_ID, PHASE_CODE, SIMPLE_GROUP_CODE
FUN_PARALLEL_UNCHUNKED_DATA_U1 Unique FUSION_TS_TX_DATA PARALLEL_RUN_ID, DATA_KEY