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

This table uses no sequences.

Sequence Name

Sequence Type

PPM_FM_COST_AUDIT_RATE _S

FM_COST_AUDIT_RATE_ID