QP_ALGORITHM_TESTCASES

Set Transformation Service table that stores the testcases executed for the algorithm

Details

• Schema: FUSION

• Object owner: QP

• Object type: TABLE

• Tablespace: FUSION_TS_SEED

Primary Key

Name	Columns
QP_ALGORITHM_TESTCASES_PK	TEST_CASE_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
TEST_CASE_ID	NUMBER		18	Yes	Algorithm test case identifier of this table
TEST_CASE_NAME	VARCHAR2	200		Yes	Algorithm version test case name of this table
ALGORITHM_VERSION_ID	NUMBER		18	Yes	Test Algorithm Version Identifier
CONFLICT_ID	NUMBER		18	Yes	Disconnected Mobile: this value is used to guarantee the uniqueness of the row when duplicates are created in different databases (i.e. mobile databases or the server).
DESCRIPTION	VARCHAR2	500			Description of the test case. Usually this should capture the intention
EXECUTION_STATUS	VARCHAR2	50			Status of the execution. Valid values are SUCCESS and FAILURE
EXECUTION_DATE	TIMESTAMP				Indicatest the date and time of the testcase execution
USER_LAST_UPDATE_DATE	TIMESTAMP				Disconnected Mobile: indicates the date and time of the last update of the row. This value is different from LAST_UPDATE_DATE if the update originally happened in a different database (i.e. a different mobile database or the server).
EXCEPTION_MSG	CLOB				Exception Message if any due to test case execution
EXCEPTION_DETAIL	CLOB				Exception stack trace due to testcase execution
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.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created 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.

Foreign Keys

Table	Foreign Table	Foreign Key Column
QP_ALGORITHM_TESTCASES	qp_algorithm_versions	ALGORITHM_VERSION_ID
qp_algorithm_testcase_ios	qp_algorithm_testcases	TEST_CASE_ID

Indexes

Index	Uniqueness	Tablespace	Columns	Status
QP_ALGORITHM_TESTCASES_PK	Unique	Default	TEST_CASE_ID
QP_ALGORITHM_TESTCASES_U1	Unique	FUSION_TS_TX_IDX	ALGORITHM_VERSION_ID, TEST_CASE_NAME, CONFLICT_ID	Active