CMR_TXN_CHUNKS_GT

This global temporary table is used to temporarily hold the rows picked up for processing.

Details

  • Schema: FUSION

  • Object owner: CMR

  • Object type: TABLE

  • Tablespace: Default

Columns

Name Datatype Length Precision Comments
ID_NUM_1 NUMBER 18 Surrogate numeric identifier of the transaction.
ID_NUM_2 NUMBER 18 Surrogate numeric identifier of the transaction.
ID_CHAR_1 VARCHAR2 100 Surrogate character identifier of the transaction.
ID_CHAR_2 VARCHAR2 100 Surrogate character identifier of the transaction.
ID_DATE_1 DATE Surrogate date identifier of the transaction.
ID_DATE_2 DATE Surrogate date identifier of the transaction.
ID_TIMESTAMP_1 TIMESTAMP Surrogate timestamp identifier of the transaction.
ID_TIMESTAMP_2 TIMESTAMP Surrogate timestamp identifier of the transaction.