QP_ALGORITHM_VARIABLES

Details

Schema: FUSION
Object owner: QP
Object type: TABLE
Tablespace: REFERENCE

Primary Key

Name	Columns
QP_ALGORITHM_VARIABLES_PK	VAR_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
VAR_ID	NUMBER		18	Yes	Unique identifier of table QP_ALGORITHM_VARIABLES
VAR_NAME	VARCHAR2	100		Yes	Variable name used by this algorithm version
VERSION_ID	NUMBER		18	Yes	Foreign key to algorithm Version table
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).
DATATYPE_CODE	VARCHAR2	30		Yes	Data type of the algorithm variable
REQUIRED_FLAG	VARCHAR2	30		Yes	Indicates if this variable is a required input/output.
IO_TYPE_CODE	VARCHAR2	30		Yes	Input output type: Input/Output/InOut/None
VAR_DESCRIPTION	VARCHAR2	1000			Description of the variable.This should document how this variable will be used
DEFAULT_VALUE	VARCHAR2	1000			Variable default value. This default will be used if the assigned value is null.
SEQ_NUM	NUMBER		9		Sequence number of algorithm variable.
CONTEXT_CONSUMER	VARCHAR2	500			Context.Consumer information for SDO variable. The format is: [Context.consumer1][;][Context.consumer2]
SERVICE_SCHEMA_EXTERNAL	VARCHAR2	500			Input/output SDO variables of an algorithm should associate with an external service schema to identify the service interface.This field is to store this external service schema. It has the same format as CONTEXT_CONSUMER field.
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).
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.
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.

Foreign Keys

Table	Foreign Table	Foreign Key Column
QP_ALGORITHM_VARIABLES	qp_algorithm_versions	VERSION_ID

Indexes

Index	Uniqueness	Tablespace	Columns
QP_ALGORITHM_VARIABLES_PK	Unique	Default	VAR_ID, ORA_SEED_SET1
QP_ALGORITHM_VARIABLES_PK1	Unique	Default	VAR_ID, ORA_SEED_SET2
QP_ALGORITHM_VARIABLES_U1	Unique	Default	VERSION_ID, VAR_NAME, CONFLICT_ID, ORA_SEED_SET1
QP_ALGORITHM_VARIABLES_U11	Unique	Default	VERSION_ID, VAR_NAME, CONFLICT_ID, ORA_SEED_SET2