Incentive Rules

The rules view object contains information regarding the incentive compensation rules including credit rules, assignment rules, and classification rules.

Data Store Key : CrmAnalyticsAM.CnExtractAM.SetupCreditRulesExtractAM.RuleExtractPVO

Primary Keys : RuleId

Initial Extract Date : CreationDate

Incremental Extract Date : LastUpdateDate

Attributes

This table provides the list of exposed attributes and their descriptions.

Name Description
Attribute1 Descriptive Flexfield: segment of the user descriptive flexfield.
Attribute10 Descriptive Flexfield: segment of the user descriptive flexfield.
Attribute11 Descriptive Flexfield: segment of the user descriptive flexfield.
Attribute12 Descriptive Flexfield: segment of the user descriptive flexfield.
Attribute13 Descriptive Flexfield: segment of the user descriptive flexfield.
Attribute14 Descriptive Flexfield: segment of the user descriptive flexfield.
Attribute15 Descriptive Flexfield: segment of the user descriptive flexfield.
Attribute2 Descriptive Flexfield: segment of the user descriptive flexfield.
Attribute3 Descriptive Flexfield: segment of the user descriptive flexfield.
Attribute4 Descriptive Flexfield: segment of the user descriptive flexfield.
Attribute5 Descriptive Flexfield: segment of the user descriptive flexfield.
Attribute6 Descriptive Flexfield: segment of the user descriptive flexfield.
Attribute7 Descriptive Flexfield: segment of the user descriptive flexfield.
Attribute8 Descriptive Flexfield: segment of the user descriptive flexfield.
Attribute9 Descriptive Flexfield: segment of the user descriptive flexfield.
AttributeCategory Descriptive Flexfield: structure definition of the user descriptive flexfield.
CreatedBy The user that created the rule.
CreationDate The date that the rule was created.
EnabledFlag Indicates whether this rule and all its children are active or not.
EndDate The end date of the rule.
Language Indicates the code of the language.
LastUpdateDate The date and time when the row was last updated.
LastUpdateLogin The login of the user who last updated the row.
LastUpdatedBy The user who last updated the row.
NumWinners The number of winners.
OrgId Indicates the identifier of the business unit associated to the row.
ParentRuleId Points to the parent rule Foreign key to cn_rs_rules_all_b.rule_id
Rank The rank of the rule.
RuleId Unique Identifier
RuleNumber The public unique identifier.
RuleTranslationDescription The translated description of the rule.
RuleTranslationLangage Indicates the code of the language into which the contents of the translatable columns are translated.
RuleTranslationName Translated name of the rule.
RuleTranslationRuleId The unique identifier.
RuleTranslationSourceLang
StartDate The start date of the rule.
UsageId The identifier for the rule usage.