• Replies 2 replies
  • Subscribers 414 subscribers
  • Views 19 views
  • Users 0 members are here
Related

Audit for Fees

Alison Lambert
$organization

Hi,

There are lots of areas in the ticketing setup which show an audit log of what changes have been made and when (last updated by and last updated date etc). Does this show anywhere for the Fees setup?

Thanks,
Alison

Parents
  • $organization

    Alison,

    There is no audit for fees.  I too have needed to know who changed a fee so I use the following.  This shows you who last updated and when but unfortunately not what was changed.

    Normal 0 false false false EN-US X-NONE X-NONE

    SELECT *

    FROM T_FEE f

    JOIN T_FEE_RULE r on f.fee_no = r.fee_no

    WHERE f.inactive = 'n'

    ORDER BY last_update_dt DESC

Reply
  • $organization

    Alison,

    There is no audit for fees.  I too have needed to know who changed a fee so I use the following.  This shows you who last updated and when but unfortunately not what was changed.

    Normal 0 false false false EN-US X-NONE X-NONE

    SELECT *

    FROM T_FEE f

    JOIN T_FEE_RULE r on f.fee_no = r.fee_no

    WHERE f.inactive = 'n'

    ORDER BY last_update_dt DESC

Children