DEPARTMENTS - Projects database

Projects database documentation

- Projects database

Documentation	Projects database
Name	DEPARTMENTS
Module	Organization and HR

Departments table holds organizational hierariarchy - divisions, business units, departments and teams.

Columns

		Name	Data type	Attributes	References
	1	DEPARTMENT_ID	NUMBER
	2	SYMBOL	VARCHAR2(50 BYTE)
	3	NAME	VARCHAR2(100 BYTE)
	4	COST_CENTER_CODE	VARCHAR2(50 BYTE)
	5	PARENT_DEPARTMENT_ID	NUMBER		DEPARTMENTS
References: DEPARTMENTS
	6	MANAGER_ID	NUMBER		PEOPLE
References: PEOPLE
	7	DEFAULT_COST_RATE	VARCHAR2(10 CHAR)		CST_HOURLY_RATES
References: CST_HOURLY_RATES
	8	CREATED_DATE	DATE	Default: SYSDATE
Default: SYSDATE
	9	CREATED_BY	NUMBER
	10	MODIFIED_DATE	DATE	Default: SYSDATE
Default: SYSDATE
	11	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
DEPARTMENTS	DEPARTMENTS	DEPARTMENTS.PARENT_DEPARTMENT_ID = DEPARTMENTS.DEPARTMENT_ID	FK_DEPARTMENTS_PARENT
DEPARTMENTS.PARENT_DEPARTMENT_ID = DEPARTMENTS.DEPARTMENT_ID Name: FK_DEPARTMENTS_PARENT
DEPARTMENTS	PEOPLE	DEPARTMENTS.MANAGER_ID = PEOPLE.PERSON_ID	FK_DEPARTMENTS_MANAGER
DEPARTMENTS.MANAGER_ID = PEOPLE.PERSON_ID Name: FK_DEPARTMENTS_MANAGER
DEPARTMENTS	DEPARTMENTS	DEPARTMENTS.PARENT_DEPARTMENT_ID = DEPARTMENTS.DEPARTMENT_ID	FK_DEPARTMENTS_PARENT
DEPARTMENTS.PARENT_DEPARTMENT_ID = DEPARTMENTS.DEPARTMENT_ID Name: FK_DEPARTMENTS_PARENT
ACTIVITIES	DEPARTMENTS	ACTIVITIES.ASSIGNED_TO_DEPARTMENT_ID = DEPARTMENTS.DEPARTMENT_ID	FK_ACTIVITIES_DEPARTMENT
ACTIVITIES.ASSIGNED_TO_DEPARTMENT_ID = DEPARTMENTS.DEPARTMENT_ID Name: FK_ACTIVITIES_DEPARTMENT
CST_PROJECT_COSTS	DEPARTMENTS	CST_PROJECT_COSTS.DEPARTMENT_ID = DEPARTMENTS.DEPARTMENT_ID	FK_CST_PROJECT_COSTS_DEPT
CST_PROJECT_COSTS.DEPARTMENT_ID = DEPARTMENTS.DEPARTMENT_ID Name: FK_CST_PROJECT_COSTS_DEPT
CST_PROJECT_TIME_LOG	DEPARTMENTS	CST_PROJECT_TIME_LOG.DEPARTMENT_ID = DEPARTMENTS.DEPARTMENT_ID	FK_CST_PROJECT_TIME_DEPT
CST_PROJECT_TIME_LOG.DEPARTMENT_ID = DEPARTMENTS.DEPARTMENT_ID Name: FK_CST_PROJECT_TIME_DEPT
PEOPLE	DEPARTMENTS	PEOPLE.DEPARTMENT_ID = DEPARTMENTS.DEPARTMENT_ID	FK_PEOPLE_DEPARTMENT
PEOPLE.DEPARTMENT_ID = DEPARTMENTS.DEPARTMENT_ID Name: FK_PEOPLE_DEPARTMENT
PROGRAMS	DEPARTMENTS	PROGRAMS.DEPARTMENT_ID = DEPARTMENTS.DEPARTMENT_ID	FK_PROGRAMS_DEPARTMENT
PROGRAMS.DEPARTMENT_ID = DEPARTMENTS.DEPARTMENT_ID Name: FK_PROGRAMS_DEPARTMENT
PROJECTS	DEPARTMENTS	PROJECTS.ORG_ID = DEPARTMENTS.DEPARTMENT_ID	FK_PROJECTS_ORG
PROJECTS.ORG_ID = DEPARTMENTS.DEPARTMENT_ID Name: FK_PROJECTS_ORG

Unique keys

	Key name	Columns	Description
	DEPARTMENTS_PK	DEPARTMENT_ID

Uses

Name
DEPARTMENTS
CST_HOURLY_RATES
DEPARTMENTS
PEOPLE

Used by

Name
DEPARTMENTS
V_PEOPLE_ROLES
ACTIVITIES
CST_PROJECT_COSTS
CST_PROJECT_TIME_LOG
DEPARTMENTS
PEOPLE
PROGRAMS
PROJECTS

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