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