Share this page

# FM_COST_RATES_HISTORY

This table stores the old values of cost rates.

## Foreign Keys

This table does not have any foreign keys.

## Column Descriptions

Column Name | Null? | Data Type | Description
--- | --- | --- | ---
COST_RATE_ID | NOT NULL | NUMBER | Indicates the cost rate ID from FM_COST_RATES.
EFFECTIVE_START_DATE | NULLABLE | DATE | Effective start date for this rate
EFFECTIVE_END_DATE | NULLABLE | DATE | Effective end date for this rate. Null implies the rate is applicable forever.
CURRENCY_CODE | NOT NULL | VARCHAR2 | Three-letter currency code to which this rate is applied
RATE | NOT NULL | NUMBER | Actual rate multiplied by 100 so that decimals are not used
COST_RULE_ID | NULLABLE | NUMBER | Cost rule ID for which this rate is used
AUDIT_EVENT_ID | NULLABLE | NUMBER | Indicates the audit event ID from ITG_AUDIT_EVENTS
FLAG | NULLABLE | NUMBER | Flag to indicate whether the cost rate is edited or deleted. 0 means the cost rate is edited. 1 means the cost rate is deleted.

## Indexes

This table does not have any indexes.

## Sequences

This table does not have any sequences.

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: