CST_DB_QUAR_TABLES

This table has the seed data which is used to quarantine the transactions that cause unexpected errors. This way the next run of the cost processor can process the unaffected transactions.

Details

• Schema: FUSION

• Object owner: CST

• Object type: TABLE

• Tablespace: REFERENCE

Primary Key

Name	Columns
CST_DB_QUAR_TABLES_PK	TABLE_NAME, ERROR_COLUMN_NAME, UPD_STATUS_COL_NAME

Columns

Name	Datatype	Length	Precision	Not-null	Comments
TABLE_NAME	VARCHAR2	50		Yes	Name of the table that can be quarantined for any errors logged into cst_db_errors table.
ERROR_COLUMN_NAME	VARCHAR2	50		Yes	Indicates the column_name in the table which will be used to quarantine a row. cst_db_errors table must have a value in this column for the rows in this table to be quarantined. In no values exists in the cst_db_errors table, then that error is considered to be irrelevant for this table.
UPD_STATUS_COL_NAME	VARCHAR2	50		Yes	The column in the quarantined table that maintains the status of the row. Updating this column with a quarantine status will make sure that those rows will not get processed any further in the processors and hence effectively quarantining them.
UPD_STATUS_VALUE	VARCHAR2	500			Indicates the value that will prepended to the existing status value. e.g. a status 'N' will become 'QN' upon quarantining.
WHERE_STATUS_COL_NAME	VARCHAR2	50			Indicates the status column in the quarantined table. In most of the cases, it same as the upd_status_col_name value. In certain cases , it can be different if a SQL expression must be used to identify the appropriate statuses to quarantine.
WHERE_STATUS_VALUE	VARCHAR2	500			Indicates the status values that should be quarantined. e.g. a transaction may have posted flag of Y, N, X, W etc., but only N may be quarantined. A list of values can be specified for this column.
WHERE_OBJ_COL_NAME	VARCHAR2	50			Indicate the column name that will indentify the rows to be quarantined. In most cases, it is the same value as error_column_name. I can be different in some cases, where table may have a different name but refers to the same object. e.g. error may record a transaction_id, but the table may refer to it as dest_transaction_id.
WHERE_OBJ_COL_VALUE	VARCHAR2	500			The value of the column indicated by where_obj_col_name, that should quarantined. In most cases, this column is NULL and the quarantining logic determines the values from the cst_db_errors table. In certain complex case, a subquery can be specified to select correct rows to quarantine.
QUARANTINE_ENABLED	VARCHAR2	5			Indicates whether the table is enabled for quaranting or not
ROWS_QUARANTINED	NUMBER		18		States the number of rows currently quarantined in this table.
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.
SEED_DATA_SOURCE	VARCHAR2	512			Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file.
ORA_SEED_SET1	VARCHAR2	1		Yes	Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET1. Context values are Y or N.
ORA_SEED_SET2	VARCHAR2	1		Yes	Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET2. Context values are Y or N.

Indexes

Index	Uniqueness	Tablespace	Columns
CST_DB_QUAR_TABLES_U1	Unique	Default	TABLE_NAME, ERROR_COLUMN_NAME, UPD_STATUS_COL_NAME, ORA_SEED_SET1
CST_DB_QUAR_TABLES_U11	Unique	Default	TABLE_NAME, ERROR_COLUMN_NAME, UPD_STATUS_COL_NAME, ORA_SEED_SET2