CST_STD_RESOURCE_RATE_DETAILS

This table contains the cost component level breakup of resource rates published to cost accounting from a cost planning scenario.

Details

• Schema: FUSION

• Object owner: CST

• Object type: TABLE

• Tablespace: FUSION_TS_TX_DATA

Primary Key

Name	Columns
CST_STD_RES_RATE_DTLS_PK	STD_RESOURCE_RATE_DETAIL_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
STD_RESOURCE_RATE_DETAIL_ID	NUMBER		18	Yes	Indicates the surrogate identifier for the standard resource rate detail.
OBJECT_VERSION_NUMBER	NUMBER		9	Yes	Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
STD_RESOURCE_RATE_ID	NUMBER		18	Yes	Indicates the reference of the standard resource rate under which the details are published.
COST_ELEMENT_ID	NUMBER		18	Yes	Identifies the cost element of the standard resource rate detail.
EXPENSE_POOL_ID	NUMBER		18	Yes	Identifies the expense pool of the standard resource rate detail.
COST_COMPONENT_ID	NUMBER		18		Identifies the cost component of the standard resource rate detail.
UNIT_RATE	NUMBER			Yes	Indicates the unit rate for the cost component in resource rate currency.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.
REQUEST_ID	NUMBER		18		Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
JOB_DEFINITION_NAME	VARCHAR2	100			Enterprise Service Scheduler: indicates the name of the job that created or last updated the row.
JOB_DEFINITION_PACKAGE	VARCHAR2	900			Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row.
CREATION_SOURCE	VARCHAR2	11			Indicates the source which created the record.
LAST_UPDATE_SOURCE	VARCHAR2	11			Indicates the source which last updated the record.

Foreign Keys

Table	Foreign Table	Foreign Key Column
CST_STD_RESOURCE_RATE_DETAILS	cst_std_resource_rates	STD_RESOURCE_RATE_ID

Indexes

Index	Uniqueness	Tablespace	Columns
CST_STD_RES_RATE_DTLS_PK	Unique	FUSION_TS_TX_DATA	STD_RESOURCE_RATE_DETAIL_ID
CST_STD_RES_RATE_DTLS_U1	Unique	FUSION_TS_TX_DATA	STD_RESOURCE_RATE_ID, COST_ELEMENT_ID, EXPENSE_POOL_ID, COST_COMPONENT_ID