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 |