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