Incentive Rules Flat Hierarchies

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

Data Store Key : CrmAnalyticsAM.CnExtractAM.SetupCreditRulesExtractAM.RulesHierarchyCFExtractPVO

Primary Keys : RuleHierarchyCfId

Initial Extract Date : CreationDate

Incremental Extract Date : LastUpdateDate

Attributes

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

Name Description
BaseRuleId Unique identifier of the base rule.
BaseRuleUsageId Unique identifier of the usage for the base rule.
CreatedBy The user who created the row.
CreationDate The date and time when the row was created.
Language Indicates the code of the language into which the contents of the translatable columns are translated.
LastUpdateDate The date and time when the row was last updated.
LastUpdateLogin The login of the user who last updated the record.
LastUpdatedBy The user who last updated the row.
Level01RuleId Unique identifier of the level one rule.
Level02RuleId Unique identifier of the level two rule.
Level03RuleId Unique identifier of the level three rule.
Level04RuleId Unique identifier of the level four rule.
Level05RuleId Unique identifier of the level five rule.
Level06RuleId Unique identifier of the level six rule.
Level07RuleId Unique identifier of the level seven rule.
Level08RuleId Unique identifier of the level eight rule.
Level09RuleId Unique identifier of the level nine rule.
Level10RuleId Unique identifier of the level ten rule.
Level11RuleId Unique identifier of the level eleven rule.
Level12RuleId Unique identifier of the level twelve rule.
Level13RuleId Unique identifier of the level thirteen rule.
Level14RuleId Unique identifier of the level fourteen rule.
Level15RuleId Unique identifier of the level fifteen rule.
OrgId Indicates the identifier of the business unit associated to the row.
RuleHierarchyCfId The unique identifier.
TopRuleId The identifier of the top level rule in the hierarchy.