CN_SRP_IMPORT_RULE_SETS_ALL_B

This table specifies the trading community and HCM person attributes that qualify a person for Incentive compensation participant collection and import

Details

• Schema: FUSION

• Object owner: CN

• Object type: TABLE

• Tablespace: Default

Primary Key

Name	Columns
CN_SRP_IMPORT_RULE_SETS_PK	SRP_IMPORT_RULE_SET_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
SRP_IMPORT_RULE_SET_ID	NUMBER			Yes	The unique identifier for the rule set record.
USAGE_TYPE	VARCHAR2	30		Yes	The usage type for this mapping.
ORG_ID	NUMBER		18	Yes	Indicates the identifier of the business unit associated to the row.
PARTICIPANT_TYPE	VARCHAR2	20		Yes	The lookup code that represents the participant as either an incentive compensation administrator or a participant for incentives.
CRITERIA_OPERATOR	VARCHAR2	30		Yes	The lookup code that represents whether the rules included in the rule set have an AND or OR relationship. (If all rules must be true or if any rule must be true).
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.
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.

Foreign Keys

Table	Foreign Table	Foreign Key Column
cn_srp_import_rule_sets_all_tl	cn_srp_import_rule_sets_all_b	SRP_IMPORT_RULE_SET_ID
cn_srp_import_rules_all	cn_srp_import_rule_sets_all_b	SRP_IMPORT_RULE_SET_ID

Indexes

Index	Uniqueness	Tablespace	Columns
CN_SRP_IMPORT_RULE_SETS_U1	Unique	Default	SRP_IMPORT_RULE_SET_ID