PPM_FM_COST_SNAP_SHOT

This table traces changes to cost factors, cost rule, and cost rates. It stores IDs of snapshots on changes that are used for the cost rate audit table to distinguish cost rate calculation.

Foreign Keys

This table does not have any foreign keys.

Column Descriptions

Column Name

Null?

Data Type

Description

FM_COST_SNAP_SHOT_ID

NOT NULL

NUMBER

System-generated identifier

LAST_UPDATE_DATE

NOT NULL

DATE

The system current date when performing INSERT

Indexes

This table has no indexes.

Sequences

Sequence Name

Sequence Type

PPM_FM_COST_SNAP_SHOT_S

FM_COST_SNAP_SHOT_ID