CN_SRP_RULE_CONDITIONS_ALL
This table contains the rule conditions to be used for selection of HCM persons during Incentive Compensation Participant import
Details
-
Schema: FUSION
-
Object owner: CN
-
Object type: TABLE
-
Tablespace: Default
Primary Key
Name | Columns |
---|---|
CN_SRP_RULE_CONDITIONS_AL_PK |
SRP_RULE_CONDITION_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
SRP_RULE_CONDITION_ID | NUMBER | Yes | he unique identifier for the rule condition record. | ||
SRP_IMPORT_RULE_ID | NUMBER | Yes | The unique identifier for the rule record. | ||
RULE_OBJECT_CODE | VARCHAR2 | 30 | Yes | The code for object which is used to define the rule. | |
RULE_OBJECT_ATTR_CODE | VARCHAR2 | 30 | Yes | The lookup code that represents the object for which a conditional value will be chosen from. For example, a Business Unit attribute object will provide a list of defined business units for the Attribute Value field. | |
RULE_OBJ_ATTR_CODE_DESC | VARCHAR2 | 30 | RULE_OBJ_ATTR_CODE_DESC | ||
RULE_OBJECT_ATTR_VAL | VARCHAR2 | 4000 | Yes | The attribute value which is used to evaluate against the person or party information to determine if the condition is met or not. For example, an attribute value of Vision Operations for the business unit object is used to evaluate the assigned business unit of the HCM employee or contingent worker. Employees associated with Vision Operations have passed the condition. | |
RULE_OBJ_ATTR_VAL_DESC | VARCHAR2 | 4000 | RULE_OBJ_ATTR_VAL_DESC | ||
CONDITION_OPERATOR | VARCHAR2 | 30 | Yes | For future use. (Equals is the only one planned OPERATOR for now) | |
ORG_ID | NUMBER | 18 | Yes | Indicates the identifier of the business unit associated to the row. | |
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_RULE_CONDITIONS_ALL | cn_srp_import_rules_all | SRP_IMPORT_RULE_ID |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
CN_SRP_RULE_CONDITIONS_ALL_N1 | Non Unique | Default | SRP_IMPORT_RULE_ID |
CN_SRP_RULE_CONDITIONS_ALL_U1 | Unique | Default | SRP_RULE_CONDITION_ID |