GET_LOG_2017

<DEFAULT SERVER>   >   <DEFAULT DATABASE>   >   <DEFAULT SCHEMA>   >   GET_LOG_2017

Name
ACTION
EMP_FNAME
EMP_LNAME
EMPLOYEE_ID
LOG_DATE
MESSAGE
STATUS
TITLE

CREATE VIEW Get_Log_2017 (Log_date, Action, Title, Message, Employee_Id,EMP_FNAME,EMP_LNAME,STATUS)
	AS SELECT 
			 Log_date,
      Action, 
      Title,
      Message,
      Employee_Id,
      EMP_FNAME,
      EMP_LNAME,
      STATUS
		FROM
			Get_Log_2017_Q1
    UNION
    SELECT 
			 Log_date,
      Action, 
      Title,
      Message,
      Employee_Id,
      EMP_FNAME,
      EMP_LNAME,
      STATUS
		FROM
			Get_Log_2017_Q2
      UNION
    SELECT 
			 Log_date,
      Action, 
      Title,
      Message,
      Employee_Id,
      EMP_FNAME,
      EMP_LNAME,
      STATUS
		FROM
			Get_Log_2017_Q3
      UNION
    SELECT 
			 Log_date,
      Action, 
      Title,
      Message,
      Employee_Id,
      EMP_FNAME,
      EMP_LNAME,
      STATUS
		FROM
			Get_Log_2017_Q4

Name	Types	Description
<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_Q1.ACTION	Column	View column
<DEFAULT SCHEMA>.GET_LOG_2017_Q1.EMP_FNAME	Column	View column
<DEFAULT SCHEMA>.GET_LOG_2017_Q1.EMP_LNAME	Column	View column
<DEFAULT SCHEMA>.GET_LOG_2017_Q1.EMPLOYEE_ID	Column	View column
<DEFAULT SCHEMA>.GET_LOG_2017_Q1.LOG_DATE	Column	View column
<DEFAULT SCHEMA>.GET_LOG_2017_Q1.MESSAGE	Column	View column
<DEFAULT SCHEMA>.GET_LOG_2017_Q1.STATUS	Column	View column
<DEFAULT SCHEMA>.GET_LOG_2017_Q1.TITLE	Column	View column

Name	Types	Description
<DEFAULT SCHEMA>.GET_LOG_2017_BY_MANAGERS	View	View
<DEFAULT SCHEMA>.GET_LOG_2017_BY_MANAGERS.Select	Select Statement	SELECT Log_date, Action, Title, Message, Employee_Id, EMP_FNAM