FM_COST_FACTORS

This table stores cost factors that determine selection of most applicable cost rule while assigning costs to various units of work, such as the time spent working on a project task.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KNTA_USERS

USER_ID

CREATED_BY

KNTA_USERS

USER_ID

LAST_UPDATED_BY

Column Descriptions

Column Name

Null?

Data Type

Description

COST_FACTOR_ID

NOT NULL

NUMBER

System-generated identifier

VERSION

NOT NULL

NUMBER

System-generated version for the entity. This column must not be updated manually

COST_FACTOR

NOT NULL

NUMBER

Indicates one of the following cost factors as an integer: REGION=0; PROJECT=1; REQUEST_TYPE=2; PACKAGE_WORKFLOW=3; MISC_WORK_ITEMS=4; RESOURCE_TYPE=5; ROLE=6; DEPARTMENT=7; RESOURCE=8; ORG_UNIT=9

SORT_ORDER

NOT NULL

NUMBER

Determines the significance/weight of each factor while trying to find the applicable rule. 0 is most significant.

CREATED_BY

NOT NULL

NUMBER

Identifier for the user who created the record

CREATION_DATE

NOT NULL

DATE

Date record was 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_C005201516

UNIQUE

1

COST_FACTOR_ID

Sequences

Sequence Name

Sequence Type

FM_COST_FACTORS_S

COST_FACTOR_ID