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 |