CN_RS_ATTR_FACTORS

This table uses to store attribute factors for transaction processing

Details

• Schema: FUSION

• Object owner: CN

• Object type: TABLE

• Tablespace: INTERFACE

Primary Key

Name	Columns
CN_RS_ATTR_FACTORS_PK	ATTR_FACTOR_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
ATTR_FACTOR_ID	NUMBER			Yes	Primary key
ORG_ID	NUMBER		18	Yes	Indicates the identifier of the business unit associated to the row.
ATTR_USAGE_ID	NUMBER			Yes	FK to the table cn_rs_attr_usages_all
RELATION_FACTOR	NUMBER			Yes	Relation factor
RULE_ANALYZE_ID	NUMBER				Rule analyze id
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.
INDEXED_COL_NAME	VARCHAR2	30			Index column name
USE_TAE_COL_IN_INDEX_FLAG	VARCHAR2	3			Use rule assignment engine column in index flag
UPDATE_SELECTIVITY_FLAG	VARCHAR2	3			Update selectivity flag
INPUT_SELECTIVITY	NUMBER				Input selectivity
INPUT_ORDINAL_SELECTIVITY	NUMBER				Input ordinal selectivity
INPUT_DEVIATION	NUMBER				Input deviation

Foreign Keys

Table	Foreign Table	Foreign Key Column
CN_RS_ATTR_FACTORS	cn_rs_attr_usages_all	ATTR_USAGE_ID, ORG_ID
cn_rs_attr_prod_factors	cn_rs_attr_factors	ATTR_FACTOR_ID

Indexes

Index	Uniqueness	Tablespace	Columns
CN_RS_ATTR_FACTORS_U1	Unique	Default	ATTR_FACTOR_ID