Table UserActionLog

DDL

create sequence seqUserActionLog as bigint start with 1;

create table userActionLog (
   uaID bigint not null default next value for seqUserActionLog,
   uaCreatedOn datetime not null default sysdatetime(),
   uaCreatedByFK pointer not null,
   uaChangedOn datetime not null default sysdatetime(),
   uaChangedByFK pointer not NULL,
   uaChangedItem Name not null,
   uaChangedItemType Name not null,
   uaOperation LongName not null,
   uaMenu Name not null,
   CONSTRAINT pkUserActionLog PRIMARY key (uaID)
 );

Mapping

AdmUserOpHistory

Conversion ID: cnvUserActionLogID

New	Old
uaID	ID
uaCreatedOn	SystemDate
uaCreatedByFK	UserName lookup
uaChangedOn
uaChangedByFK
uaChangedItem	ChangedItem
uaChangedItemType	ChangedItemType
uaOperation	Operation
uaMenu	Menu