Share this page

# PPM_FM_COST_AUDIT_RATE

This table stores change history of cost rates that are used to calculate actual cost of tasks. It works along with PPM_FM_COST_SNAP_SHO and PPM_FM_COST_AUDIT tables to keep track of cost factors and cost rates.

## Foreign Keys

This table does not have any foreign keys.

## Column Descriptions

Column Name | Null? | Data Type | Description
--- | --- | --- | ---
FM_COST_AUDIT_RATE_ID | NOT NULL | NUMBER | System-generated identifier
FM_COST_AUDIT_ID | NOT NULL | NUMBER | Refer to FM_COST_AUDIT_ID in PPM_FM_COST_AUDIT_RATE table
COST_RATE_ID | NOT NULL | NUMBER | Refer to COST_RATE_ID in FM_COST_RATES table
START_DATE | NOT NULL | DATE | The date of this cost rate begins to take effect
END_DATE | NOT NULL | DATE | The date of this cost rate ceases to be effective
COST_RATE | NOT NULL | NUMBER | The cost rate value
CURRENCY_CODE | NOT NULL | VARCHAR2 | The cost rate currency code

## Indexes

Index Name | Index Type | Sequence | Column Name
--- | --- | --- | ---
SYS_C00130450 | UNIQUE | 1 | FM_COST_AUDIT_RATE_ID

## Sequences

Sequence Name | Sequence Type
--- | ---
PPM_FM_COST_AUDIT_RATE _S | FM_COST_AUDIT_RATE_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: