DEPARTMENT

Item Location

<DEFAULT SERVER>   >   <DEFAULT DATABASE>   >   <DEFAULT SCHEMA>   >   DEPARTMENT

Columns

Name	Datatype	Precision	Allow Null	Identity	Description
DEPT_HEAD_ID	number		NOT NULL		Column
DEPT_ID	number		NOT NULL		Column
DEPT_NAME	NVARCHAR2		NULL		Column
MANAGER_ID	number		NULL		Column
SITE_ID	number		NULL		Column

Indexes

No Data

Check Constraints

No Data

Triggers

No Data

References
     The items listed in the matrix below are called / used by the Table “DEPARTMENT”

Name	Types	Description
<DEFAULT SCHEMA>.EMPLOYEE	Table	Table
<DEFAULT SCHEMA>.SITE	Table	Table
NUMBER	PL/SQL System type	PL/SQL System Object
NVARCHAR2	PL/SQL System type	PL/SQL System Object
<DEFAULT SCHEMA>.EMPLOYEE.EMP_ID	Primary Key	Column
<DEFAULT SCHEMA>.SITE.ID	Primary Key	Column

Impact Analysis
     The items listed in the matrix below are using / calling the Table “DEPARTMENT”

Name	Types	Description
<DEFAULT SCHEMA>.EMPLOYEE	Table	Table
<DEFAULT SCHEMA>.ALL_DEPARTMENTS	View	View
<DEFAULT SCHEMA>.ALL_DEPARTMENTS.Select	Select Statement	SELECT DEPT_ID, DEPT_HEAD_ID, DEPT_NAME, SITE_ID, Manager_Id FROM depart
d_tab_department.department_dept_id	Datawindow Column UI
d_tab_department.department_dept_name	Datawindow Column UI
d_tab_employee.department_dept_name	Datawindow Column UI
d_tab_employee.department_dept_name	Datawindow Column UI
d_tab_department.Retrieve SQL	Datawindow DataSource
d_tab_employee.Retrieve SQL	Datawindow DataSource
d_tab_employee.Retrieve SQL	Datawindow DataSource