Need to stop one action from causing trigger to write to Audit table

I have a trigger that I am using to Audit a table in SQL 2000.  It is an Update, Delete trigger and it works fine recording the deleted or updated rows.  Here is the problem:  the table I am auditing is for expenses that are approved by 2 other staff.  This approval is already tracked.  When an Expense is approved it triggers the Update (as the record is updated) but I do not want it written to the Audit table.  What I am looking for is changes made to data but not the approval/review of the expense.

In other words if I changed an account code on my expense from what I originally submitted I would want to know that in the Audit but wouldn't want to know in the Audit that my boss approved the original expense.

There are lots of columns being monitored.  

Here is the Trigger:

/****** Object:  Trigger dbo.Update_for_Reject_Audit_tr    Script Date: 9/5/2007 8:24:42 AM ******/

CREATE TRIGGER [Update_for_Reject_Audit_tr]
ON pawsxexp FOR DELETE, UPDATE
AS
if Update (last_edit_date)
--!TR_VERSION:V1.00;;
 
    BEGIN
-- Audit OLD record.
      INSERT INTO cbf_audit_pawsxexp_deletes
      (resource_code,period_end_date,tran_date,trx_detail_id ,
      client_code,project_code, subproject_code, expense_code,
      natural_cost_taxinc_rate,qty,reimbursement_cost_taxinc_amt,
      mop_code,reimb_flag,nocharge_flag,receipt_flag,details,
      posted_state,approved_state,
      data_source,approved_by_staff_code,
      approved_date,batch_ctrl_num,manual_entry_flag,
      clients_reference,project_id,approved_rule,
      created_date,created_user,last_edit_date,
      reviewed_state,reviewed_by_staff_code,reviewed_date,
      reviewed_rule,natural_cost_tax_amt,nocharge_code,
      nocharge_notes,location_code,reference_code,natural_cost_amt,
      natural_sell_amt,markup_pct,last_edit_user,tax_code,post_ctrl_num,
      rejection_desc,rejection_advised_flag,
      activity_code,analysis_code,activity_type_code, Change_User, change_date)
 
         SELECT resource_code,period_end_date,tran_date,trx_detail_id ,
      client_code,project_code, subproject_code, expense_code,
      natural_cost_taxinc_rate,qty,reimbursement_cost_taxinc_amt,
      mop_code,reimb_flag,nocharge_flag,receipt_flag,details,
      posted_state,approved_state,
      data_source,approved_by_staff_code,
      approved_date,batch_ctrl_num,manual_entry_flag,
      clients_reference,project_id,approved_rule,
      created_date,created_user,last_edit_date,
      reviewed_state,reviewed_by_staff_code,reviewed_date,
      reviewed_rule,natural_cost_tax_amt,nocharge_code,
      nocharge_notes,location_code,reference_code,natural_cost_amt,
      natural_sell_amt,markup_pct,last_edit_user,
      tax_code,post_ctrl_num,rejection_desc,rejection_advised_flag,
      activity_code,analysis_code,activity_type_code, last_edit_user, getdate()
        FROM deleted

-- Audit NEW record.
      INSERT INTO cbf_audit_pawsxexp_deletes
      (resource_code,period_end_date,tran_date,trx_detail_id ,
      client_code,project_code, subproject_code, expense_code,
      natural_cost_taxinc_rate,qty,reimbursement_cost_taxinc_amt,
      mop_code,reimb_flag,nocharge_flag,receipt_flag,details,
      posted_state,approved_state,
      data_source,approved_by_staff_code,
      approved_date,batch_ctrl_num,manual_entry_flag,
      clients_reference,project_id,approved_rule,
      created_date,created_user,last_edit_date,
      reviewed_state,reviewed_by_staff_code,reviewed_date,
      reviewed_rule,natural_cost_tax_amt,nocharge_code,
      nocharge_notes,location_code,reference_code,natural_cost_amt,
      natural_sell_amt,markup_pct,last_edit_user,
      tax_code,post_ctrl_num,rejection_desc,rejection_advised_flag,
      activity_code,analysis_code,activity_type_code, Change_User,change_date)

      SELECT resource_code,period_end_date,tran_date,trx_detail_id ,
      client_code,project_code, subproject_code, expense_code,
      natural_cost_taxinc_rate,qty,reimbursement_cost_taxinc_amt,
      mop_code,reimb_flag,nocharge_flag,receipt_flag,details,
      posted_state,approved_state,
      data_source,approved_by_staff_code,
      approved_date,batch_ctrl_num,manual_entry_flag,
      clients_reference,project_id,approved_rule,
      created_date,created_user,last_edit_date,
      reviewed_state,reviewed_by_staff_code,reviewed_date,
      reviewed_rule,natural_cost_tax_amt,nocharge_code,
      nocharge_notes,location_code,reference_code,natural_cost_amt,
      natural_sell_amt,markup_pct,last_edit_user,
      tax_code,post_ctrl_num,rejection_desc,rejection_advised_flag,
      activity_code,analysis_code,activity_type_code,last_edit_user, getdate()
        FROM inserted
   END
Start Free Trial