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