CN_SRP_IMPORT_RULES_ALL
This table contains the rules that define the participant import selection criterias
Details
-
Schema: FUSION
-
Object owner: CN
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
CN_SRP_IMPORT_RULES_ALL_PK |
SRP_IMPORT_RULE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| SRP_IMPORT_RULE_ID | NUMBER | Yes | The unique identifier for the rule record. | ||
| SRP_IMPORT_RULE_SET_ID | NUMBER | Yes | The unique identifier for the rule set to which this rule belongs. | ||
| ORG_ID | NUMBER | 18 | Yes | Indicates the identifier of the business unit associated to the row. | |
| RULE_CODE | VARCHAR2 | 30 | Yes | The user-entered code that identifies the selection criteria rule. (unique within the rule set -does not need to be unique across rule sets) | |
| CRITERIA_OPERATOR | VARCHAR2 | 30 | Yes | The lookup code that represents whether the criteria included in the rule have an AND or OR conditional relationship. (for the rule to be true, do all criteria need to be met or any of the criteria) | |
| 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_RULES_ALL | cn_srp_import_rule_sets_all_b | SRP_IMPORT_RULE_SET_ID |
| cn_srp_rule_conditions_all | cn_srp_import_rules_all | SRP_IMPORT_RULE_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CN_SRP_IMPORT_RULES_ALL_N1 | Non Unique | Default | SRP_IMPORT_RULE_SET_ID |
| CN_SRP_IMPORT_RULES_ALL_U1 | Unique | Default | SRP_IMPORT_RULE_ID |