CST_HOURLY_RATES - Projects database

Projects database documentation

- Projects database

Documentation	Projects database
Name	CST_HOURLY_RATES
Module	Costs

Dictionary holding current hourly cost rates that are used to calculate cost of work performed by employees. Each department and employee has assigned one rate from the dictionary.

Columns

		Name	Data type	Attributes
	1	COST_RATE_CODE	VARCHAR2(10 CHAR)
	2	COST_RATE	NUMBER
	3	CREATED_DATE	DATE	Default: SYSDATE
Default: SYSDATE
	4	CREATED_BY	NUMBER
	5	MODIFIED_DATE	DATE	Default: sysdate
Default: sysdate
	6	MODIFIED_BY	NUMBER

Relations

Foreign table		Primary table	Join	Title / Name / Description
DEPARTMENTS		CST_HOURLY_RATES	DEPARTMENTS.DEFAULT_COST_RATE = CST_HOURLY_RATES.COST_RATE_CODE	fk_CST_HOURLY_RATES_DEPARTMENTS
DEPARTMENTS.DEFAULT_COST_RATE = CST_HOURLY_RATES.COST_RATE_CODE Name: fk_CST_HOURLY_RATES_DEPARTMENTS

Unique keys

	Key name	Columns	Description
	PK_CST_HOURLY_RATES	COST_RATE_CODE

Used by

Name
CST_HOURLY_RATES
DEPARTMENTS

Exported: 2019-02-04 22:52, Last imported: 2019-02-03 01:50