DERIVEDTABLE

Item Location

<DEFAULT SERVER>   >   <DEFAULT DATABASE>   >   <DEFAULT SCHEMA>   >   DERIVEDTABLE

Columns

No Data

Indexes

No Data

Check Constraints

No Data

Triggers

No Data

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

No Data

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

Name	Types	Description
<DEFAULT SCHEMA>.ALL_MANAGERS_BY_DEPARTEMENT	View	View
<DEFAULT SCHEMA>.ALL_MANAGERS_BY_SITE	View	View
<DEFAULT SCHEMA>.ALL_SITES	View	View
<DEFAULT SCHEMA>.GET_LOG_2017_BY_MANAGERS	View	View
<DEFAULT SCHEMA>.GET_LOG_2017_Q1	View	View
<DEFAULT SCHEMA>.GET_LOG_2017_Q2	View	View
<DEFAULT SCHEMA>.GET_LOG_2017_Q3	View	View
<DEFAULT SCHEMA>.GET_LOG_2017_Q4	View	View
<DEFAULT SCHEMA>.GET_LOG_2017_Q2.Select	Select Statement	SELECT Log_date, Action, Title, Message, Employee_Id, EMP_FNAM
<DEFAULT SCHEMA>.GET_LOG_2017_Q1.Select	Select Statement	SELECT Log_date, Action, Title, Message, Employee_Id, EMP_FNAM
<DEFAULT SCHEMA>.GET_LOG_2017_Q4.Select	Select Statement	SELECT Log_date, Action, Title, Message, Employee_Id, EMP_FNAM
<DEFAULT SCHEMA>.GET_LOG_2017_Q3.Select	Select Statement	SELECT Log_date, Action, Title, Message, Employee_Id, EMP_FNAM
<DEFAULT SCHEMA>.GET_LOG_2017_BY_MANAGERS.Select	Select Statement	SELECT Log_date, Action, Title, Message, Employee_Id, EMP_FNAM
<DEFAULT SCHEMA>.ALL_MANAGERS_BY_DEPARTEMENT.Select	Select Statement	SELECT employee.emp_id, employee.emp_fname, employee.emp_lname, employee.phone, empl
<DEFAULT SCHEMA>.PRODUCTSBYCUSTOMER.Select	Select Statement	SELECT product.* FROM SALES_ORDER_ITEMS join customer c on customerId = c.id join SALES_
<DEFAULT SCHEMA>.ALL_SITES.Select	Select Statement	SELECT S.ID, S.NAME, S.Manager_Id, E.emp_fname, E.emp_lname F
<DEFAULT SCHEMA>.ALL_MANAGERS_BY_SITE.Select	Select Statement	SELECT employee.emp_id, employee.emp_fname, employee.emp_lname, employee.phone, empl