Action is stored{kept} in what table made INSERT, DELETE, UPDATE

Example for MS SQL :

insert into table_name(col1,col2,col3,col4) select col1, col2, 'I',
@RC from inserted

Best regards,
Leo