EMPLOYEE

Item Location

<DEFAULT SERVER>   >   <DEFAULT DATABASE>   >   <DEFAULT SCHEMA>   >   EMPLOYEE

Columns

Name	Datatype	Precision	Allow Null	Identity	Description
BENE_DAY_CARE			NULL
BENE_HEALTH_INS			NULL
BENE_LIFE_INS			NULL
BIRTH_DATE			NULL
CITY			NULL
DEPT_ID	number		NULL		Column
EMP_FNAME	NVARCHAR2		NULL		Column
EMP_ID	number		NOT NULL		Column
EMP_LNAME	NVARCHAR2		NULL		Column
MANAGER_ID			NULL
PHONE			NULL		Virtual column
SALARY	FLOAT		NULL		Column
SEX			NULL
SS_NUMBER			NULL
START_DATE			NULL
STATE			NULL
STATUS			NULL		Virtual column
STREET			NULL
TERMINATION_DATE			NULL
ZIP_CODE			NULL

Indexes

No Data

Check Constraints

No Data

Triggers

Name	ANSI Nulls On	Quoted Identifier On	On	Description
EMPLOYEE_DELETING				after ; delete
LOG_SALARY_INCREASE				after ; update

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

Name	Types	Description
<DEFAULT SCHEMA>.DEPARTMENT	Table	Table
FLOAT	PL/SQL System type	PL/SQL System Object
NUMBER	PL/SQL System type	PL/SQL System Object
NVARCHAR2	PL/SQL System type	PL/SQL System Object
<DEFAULT SCHEMA>.DEPARTMENT.DEPT_ID	Primary Key	Column

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

Name	Types	Description
<DEFAULT SCHEMA>.DEPARTMENT	Table	Table
<DEFAULT SCHEMA>.PRODUCT	Table	Table
<DEFAULT SCHEMA>.SALES_ORDER	Table	Table
<DEFAULT SCHEMA>.SITE	Table	Table
<DEFAULT SCHEMA>.ALL_EMPLOYEES	View	View
<DEFAULT SCHEMA>.ALL_EMPLOYEES_DETAILS	View	View
<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_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>.EMPLOYEE_DELETING	Trigger	Simple Trigger of AFTER "DELETE ON EMPLOYEE"
<DEFAULT SCHEMA>.LOG_SALARY_INCREASE	Trigger	Simple Trigger of AFTER "UPDATE ON EMPLOYEE"
<DEFAULT SCHEMA>.LOG_SALARY_INCREASE.NEW	PseudoRecord	EMPLOYEE
<DEFAULT SCHEMA>.EMPLOYEE_DELETING.NEW	PseudoRecord	EMPLOYEE
<DEFAULT SCHEMA>.EMPLOYEE_DELETING.OLD	PseudoRecord	EMPLOYEE
<DEFAULT SCHEMA>.LOG_SALARY_INCREASE.OLD	PseudoRecord	EMPLOYEE
<DEFAULT SCHEMA>.EMPLOYEES.InsertEmployee.Insert	Insert Statement	INSERT INTO EMPLOYEE (fname, lname) VALUES (fname,lname)
<DEFAULT SCHEMA>.EMPLOYEES.UpdateEmployeeName.Update	Update Statement	UPDATE EMPLOYEE SET emp_fname=fname, emp_lname=lname WHERE emp_Id = employeeId
<DEFAULT SCHEMA>.EMPLOYEES.DeleteEmployeeById.Delete	Delete Statement	DELETE EMPLOYEE where emp_id = id
<DEFAULT SCHEMA>.EMPLOYEES.OrdersByEmployee2.Select	Select Statement	SELECT sales_order.id Oid, sales_order.order_date Odate, DECODE(sales_order.fi
<DEFAULT SCHEMA>.EMPLOYEE_DELETING.Select	Select Statement	SELECT COUNT(*) INTO n FROM EMPLOYEE
<DEFAULT SCHEMA>.GET_LOG_2017_Q1.Select	Select Statement	SELECT Log_date, Action, Title, Message, Employee_Id, EMP_FNAM
<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_SALES_ORDER_ITEMS_DETAILS.Select	Select Statement	SELECT sales_order.id, sales_order.order_date, sales_order.fin_code_id, sales_
<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_Q2.Select	Select Statement	SELECT Log_date, Action, Title, Message, Employee_Id, EMP_FNAM
<DEFAULT SCHEMA>.ALL_MANAGERS_BY_SITE.Select	Select Statement	SELECT employee.emp_id, employee.emp_fname, employee.emp_lname, employee.phone, empl
<DEFAULT SCHEMA>.ALL_EMPLOYEES.Select	Select Statement	SELECT emp_id, emp_lname, emp_fname, emp_street, city,state,zip_code,phone FROM EMPLOYEE
<DEFAULT SCHEMA>.ALL_EMPLOYEES_DETAILS.Select	Select Statement	SELECT empByDep.emp_id, empByDep.emp_fname, empByDep.emp_lname, empByDep.phone, empB
<DEFAULT SCHEMA>.ALL_MANAGERS_BY_DEPARTEMENT.Select	Select Statement	SELECT employee.emp_id, employee.emp_fname, employee.emp_lname, employee.phone, empl
d_tab_salesperson.emp_fname	Datawindow Column UI
d_tab_salesperson_view.emp_fname	Datawindow Column UI
d_tab_salesperson_view.emp_id	Datawindow Column UI
d_tab_salesperson.emp_id	Datawindow Column UI
d_tab_salesperson.emp_lname	Datawindow Column UI
d_tab_salesperson_view.emp_lname	Datawindow Column UI
d_ff_employee_general.employee_bene_day_care	Datawindow Column UI
d_ff_employee_personal.employee_bene_day_care	Datawindow Column UI
d_ff_employee_professional.employee_bene_day_care	Datawindow Column UI
d_ff_employee_personal.employee_bene_health_ins	Datawindow Column UI
d_ff_employee_general.employee_bene_health_ins	Datawindow Column UI
d_ff_employee_professional.employee_bene_health_ins	Datawindow Column UI
d_ff_employee_professional.employee_bene_life_ins	Datawindow Column UI
d_ff_employee_general.employee_bene_life_ins	Datawindow Column UI
d_ff_employee_personal.employee_bene_life_ins	Datawindow Column UI
d_ff_employee_general.employee_birth_date	Datawindow Column UI
d_ff_employee_professional.employee_birth_date	Datawindow Column UI
d_ff_employee_personal.employee_birth_date	Datawindow Column UI
d_ff_employee_professional.employee_city	Datawindow Column UI
d_ff_employee_general.employee_city	Datawindow Column UI
d_ff_employee_personal.employee_city	Datawindow Column UI
d_ff_employee_professional.employee_dept_id	Datawindow Column UI
d_ff_employee_general.employee_dept_id	Datawindow Column UI
d_ff_employee_personal.employee_dept_id	Datawindow Column UI
d_ff_employee_personal.employee_emp_fname	Datawindow Column UI
d_ff_employee_professional.employee_emp_fname	Datawindow Column UI
d_ff_sales_order.employee_emp_fname	Datawindow Column UI
d_ff_employee_general.employee_emp_fname	Datawindow Column UI
d_tab_employee.employee_emp_fname	Datawindow Column UI
d_tab_employee.employee_emp_fname	Datawindow Column UI
d_tab_employee.employee_emp_id	Datawindow Column UI
d_ff_employee_general.employee_emp_id	Datawindow Column UI
d_tab_employee.employee_emp_id	Datawindow Column UI
d_ff_employee_professional.employee_emp_id	Datawindow Column UI
d_ff_employee_personal.employee_emp_id	Datawindow Column UI
d_tab_employee.employee_emp_lname	Datawindow Column UI
d_ff_employee_personal.employee_emp_lname	Datawindow Column UI
d_tab_employee.employee_emp_lname	Datawindow Column UI
d_ff_sales_order.employee_emp_lname	Datawindow Column UI
d_ff_employee_general.employee_emp_lname	Datawindow Column UI
d_ff_employee_professional.employee_emp_lname	Datawindow Column UI
d_tab_sales_order.employee_emp_lname	Datawindow Column UI
d_ff_employee_general.employee_manager_id	Datawindow Column UI
d_ff_employee_personal.employee_manager_id	Datawindow Column UI
d_ff_employee_professional.employee_manager_id	Datawindow Column UI
d_tab_employee.employee_phone	Datawindow Column UI
d_ff_employee_general.employee_phone	Datawindow Column UI
d_ff_employee_personal.employee_phone	Datawindow Column UI
d_tab_employee.employee_phone	Datawindow Column UI
d_ff_employee_professional.employee_phone	Datawindow Column UI
d_ff_employee_general.employee_salary	Datawindow Column UI
d_ff_employee_personal.employee_salary	Datawindow Column UI
d_ff_employee_professional.employee_salary	Datawindow Column UI
d_ff_employee_general.employee_sex	Datawindow Column UI
d_ff_employee_personal.employee_sex	Datawindow Column UI
d_ff_employee_professional.employee_sex	Datawindow Column UI
d_ff_employee_professional.employee_ss_number	Datawindow Column UI
d_ff_employee_personal.employee_ss_number	Datawindow Column UI
d_ff_employee_general.employee_ss_number	Datawindow Column UI
d_ff_employee_professional.employee_start_date	Datawindow Column UI
d_ff_employee_general.employee_start_date	Datawindow Column UI
d_ff_employee_personal.employee_start_date	Datawindow Column UI
d_ff_employee_personal.employee_state	Datawindow Column UI
d_ff_employee_general.employee_state	Datawindow Column UI
d_ff_employee_professional.employee_state	Datawindow Column UI
d_tab_employee.employee_status	Datawindow Column UI
d_ff_employee_general.employee_status	Datawindow Column UI
d_ff_employee_professional.employee_status	Datawindow Column UI
d_tab_employee.employee_status	Datawindow Column UI
d_ff_employee_personal.employee_status	Datawindow Column UI
d_ff_employee_general.employee_street	Datawindow Column UI
d_ff_employee_professional.employee_street	Datawindow Column UI
d_ff_employee_personal.employee_street	Datawindow Column UI
d_ff_employee_personal.employee_termination_date	Datawindow Column UI
d_ff_employee_general.employee_termination_date	Datawindow Column UI
d_ff_employee_professional.employee_termination_date	Datawindow Column UI
d_ff_employee_personal.employee_zip_code	Datawindow Column UI
d_ff_employee_general.employee_zip_code	Datawindow Column UI
d_ff_employee_professional.employee_zip_code	Datawindow Column UI
d_ff_employee_general.table.update	Datawindow Attribute
d_ff_employee_personal.table.update	Datawindow Attribute
d_tab_employee.table.update	Datawindow Attribute
d_tab_employee.table.update	Datawindow Attribute
d_tab_salesperson.table.update	Datawindow Attribute
d_tab_salesperson_view.table.update	Datawindow Attribute
d_ff_employee_professional.table.update	Datawindow Attribute
d_ff_sales_order.Retrieve SQL	Datawindow DataSource
d_tab_sales_order.Retrieve SQL	Datawindow DataSource
d_ff_employee_general.Retrieve SQL	Datawindow DataSource
d_tab_employee.Retrieve SQL	Datawindow DataSource
d_tab_employee.Retrieve SQL	Datawindow DataSource
d_ff_employee_personal.Retrieve SQL	Datawindow DataSource
d_tab_salesperson.Retrieve SQL	Datawindow DataSource
d_tab_salesperson_view.Retrieve SQL	Datawindow DataSource
d_ff_employee_professional.Retrieve SQL	Datawindow DataSource