Share this page

# PPM_FM_COST_AUDIT

This table stores cost audit information, including values of all cost factors that are used in the cost rollup service when finding a rate and corresponding rate history. It works along with PPM_FM_COST_SNAP_SHO and PPM_FM_COST_AUDIT_RATE tables to keep track of cost factors and cost rates.

## Foreign Keys

This table does not have any foreign keys.

## Column Descriptions

Colum Name | Null? | Data Type | Description
--- | --- | --- | ---
FM_COST_AUDIT_ID | NOT NULL | NUMBER | System-generated identifier
COST_SNAP_SHOT_ID | NOT NULL | NUMBER | The ID of PPM_FM_COST_SNAP_SHOT table
COST_YEAR | NOT NULL | NUMBER | The year of calculating cost rate
COSTFACTOR_REGION | NOT NULL | NUMBER | The region ID of cost factor
COSTFACTOR_PROJECT | NOT NULL | NUMBER | The project ID of cost factor
COSTFACTOR_REQUEST_TYPE | NOT NULL | NUMBER | The request type ID of cost factor
COSTFACTOR_PACKAGE_WORKFLOW | NOT NULL | NUMBER | The package workflow ID of cost factor
COSTFACTOR_MISC_WORK_ITEMS | NOT NULL | VARCHAR2 | The misc work item name of cost factor
COSTFACTOR_RESOURCE_TYPE | NOT NULL | VARCHAR2 | The resource type name of cost factor
COSTFACTOR_ROLE | NOT NULL | NUMBER | The role ID of cost factor
COSTFACTOR_DEPARTMENT | NOT NULL | VARCHAR2 | The department name of cost factor
COSTFACTOR_RESOURCE | NOT NULL | NUMBER | The resource ID of cost factor
COSTFACTOR_ORG_UNIT | NOT NULL | NUMBER | The organization unit ID of cost factor
CREATED_ BY | NOT NULL | NUMBER | Identifier for the user who created the record
CREATION_ DATE | NOT NULL | DATE | The date of the record created
LAST_ UPDATED_ BY | NOT NULL | NUMBER | Identifier for the user who last updated the record
LAST_UPDATE_ DATE | NOT NULL | DATE | Date record was last updated

## Indexes

Index Name | Index Type | Sequence | Column Name
--- | --- | --- | ---
SYS_C00130442 | UNIQUE | 1 | FM_COST_AUDIT_ID

## Sequences

Sequence Name | Sequence Type
--- | ---
PPM_FM_COST_AUDIT _S | FM_COST_AUDIT_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: