Share this page

# FM_COST_RATE_RULE_UPDATES

This table stores changes made to cost rules or cost factors and the range of time that is potentially affected by the changes. The start and end dates of the time range may be null, which means the change is not limited to any time range. The Cost Rate Rule Update service reads these CostRuleUpdates and uses them to recalculate the costs of affected entities.

## Foreign Keys

Primary Key Table | Primary Key Column | Foreign Key Column
--- | --- | ---
KNTA_USERS | USER_ID | LAST_UPDATED_BY
FM_COST_RULES | RULE_NUMBER | RULE_NUMBER
KNTA_USERS | USER_ID | CREATED_BY

## Column Descriptions

Column Name | Null? | Data Type | Description
--- | --- | --- | ---
COST_RATE_RULE_UPDATE_ID | NOT NULL | NUMBER | System-generated identifier
CONDITIONS | NULLABLE | NUMBER | Default value is 0. If the value is 1, only forecast cost will be calculated. If the value is 0, cost will be calculated as before version 930.
EFFECTIVE_END_DATE | NULLABLE | DATE | End of the range of time that is potentially affected by the change. May be null, which means the change is not limited to any time range in the future.
EFFECTIVE_START_DATE | NULLABLE | DATE | Start of the range of time that is potentially affected by the change. May be null, which means the change is not limited to any time range.
REASON | NULLABLE | VARCHAR2(255) | Reason for the entry. Possible values are ruleChanged, rateChanged, ruleDeleted, ruleCreated, costFactorsChanged
RULE_NUMBER | NULLABLE | NUMBER | Rule number of the cost rule (from FM_COST_RULES) which was affected (this not the same as cost rule id)
CREATED_BY | NOT NULL | NUMBER | Identifier for the user who created the record
CREATION_DATE | NOT NULL | DATE | Date record was created
LAST_UPDATED_BY | NOT NULL | NUMBER | Identifier for the user who last updated the record
LAST_UPDATE_DATE | NOT NULL | DATE | Date record was last updated
STATUS | NULLABLE | NUMBER | Internal use for the Cost Rate Rule Update Service The value is either 1 (that means being processed) or null (that means not processed).
RESOURCE_ID | NULLABLE | NUMBER | Identifier of the resource that is specified by the cost rule
TEAM_ID | NULLABLE | NUMBER | Identifier of the team that is specified by the cost rule

## Indexes

Index Name | Index Type | Sequence | Column Name
--- | --- | --- | ---
SYS_C005201519 | UNIQUE | 1 | COST_RATE_RULE_UPDATE_ID

## Sequences

Sequence Name | Sequence Type
--- | ---
FM_COST_RATE_RULE_UPDATES_S | COST_RATE_RULE_UPDATE_ID

https://admhelp.microfocus.com PPM 8942
Tips to improve your search results... OpenText™ Project and Portfolio Management Help Center PPM Help 26.2-26.3 All View Local Help Center View Online Help Center Version: