APPLOG

Item Location

<DEFAULT SERVER>   >   <DEFAULT DATABASE>   >   <DEFAULT SCHEMA>   >   APPLOG

Columns

Name	Datatype	Precision	Allow Null	Identity	Description
ACTION	NVARCHAR2		NULL		Column
EMPLOYEE_ID	int		NULL		Column
LOG_DATE	TIMESTAMP WITH TIME ZONE		NULL		Column
MESSAGE	NVARCHAR2		NULL		Column
TITLE	NVARCHAR2		NULL		Column

Indexes

No Data

Check Constraints

No Data

Triggers

Name	ANSI Nulls On	Quoted Identifier On	On	Description
CHECKAPPLOG				after ; insert

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

Name	Types	Description
INT	PL/SQL System type	PL/SQL System Object
NVARCHAR2	PL/SQL System type	PL/SQL System Object
TIMESTAMP WITH TIME ZONE	PL/SQL System type	PL/SQL System Object

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

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>.CHECKAPPLOG	Trigger	Simple Trigger of AFTER "insert ON AppLog"
<DEFAULT SCHEMA>.CHECKAPPLOG.NEW	PseudoRecord	APPLOG
<DEFAULT SCHEMA>.CHECKAPPLOG.OLD	PseudoRecord	APPLOG
<DEFAULT SCHEMA>.INSERTPRODUCT.Insert	Insert Statement	INSERT INTO AppLog (Log_date, Action, Title,Message) VALUES (SYSDATE,AppLogPk.GetActionId('INS PRODU
<DEFAULT SCHEMA>.APPLOGPK.LogDeletingSalesOrderItem.Insert	Insert Statement	INSERT INTO AppLog (Log_date, Action, Title,Message,Employee_Id) VALUES (SYSDATE,GetActionId('DEL SO
<DEFAULT SCHEMA>.EMPLOYEES.LogDeletingEmployee.Insert	Insert Statement	INSERT INTO AppLog (Log_date, Action, Title,Message,Employee_Id) VALUES (SYSDATE,APPLOGPK.GetActionI
<DEFAULT SCHEMA>.APPLOGPK.ChangedSalary.Insert	Insert Statement	INSERT INTO AppLog (Log_date, Action, Title,Message,Employee_Id) VALUES (SYSDATE,GetActionId('NEW SA
<DEFAULT SCHEMA>.APPLOGPK.LogCleaner.Delete	Delete Statement	Delete AppLog where Log_date < SYSDATE
<DEFAULT SCHEMA>.GET_LOG_2017_Q2.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_Q1.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