Fee override

Hi Marty, you can try the following query. Please, notice that there are multiple entries for each order. You can group them on order_no for total fee overridden.

SELECT      a.order_no,

            b.order_dt,

            b.customer_no,

            fee_overridden=CASE WHEN a.fee_override_ind='Y' THEN 'Yes' ELSE 'No' END,

            a.fee_override_amt,

            overridden_by=a.created_by,

            fee_predefined=CASE WHEN a.fee_no IS NULL THEN 'No' ELSE 'Yes' END,

            predefined_fee_amt=c.fee_amt,

            predefined_fee_description=c.description

      FROM t_sli_fee a

            INNER JOIN t_order b ON a.order_no=b.order_no

            LEFT OUTER JOIN t_fee c ON a.fee_no=c.fee_no

      WHERE a.fee_override_ind='Y'

      ORDER by a.order_no

Hope this helps,

Has anybody written a query or report to report on overridden fees and who overrode them? Or at least where to start getting the information.

Thanks,

Marty

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums.

Hi Marty, you can try the following query. Please, notice that there are multiple entries for each order. You can group them on order_no for total fee overridden.

SELECT      a.order_no,

            b.order_dt,

            b.customer_no,

            fee_overridden=CASE WHEN a.fee_override_ind='Y' THEN 'Yes' ELSE 'No' END,

            a.fee_override_amt,

            overridden_by=a.created_by,

            fee_predefined=CASE WHEN a.fee_no IS NULL THEN 'No' ELSE 'Yes' END,

            predefined_fee_amt=c.fee_amt,

            predefined_fee_description=c.description

      FROM t_sli_fee a

            INNER JOIN t_order b ON a.order_no=b.order_no

            LEFT OUTER JOIN t_fee c ON a.fee_no=c.fee_no

      WHERE a.fee_override_ind='Y'

      ORDER by a.order_no

Hope this helps,

Has anybody written a query or report to report on overridden fees and who overrode them? Or at least where to start getting the information.

Thanks,

Marty

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums.

Thanks Mo, But if I am correct the created by is who created the order or added the fee but not necessary who overrode the fee?

Hi Marty, you can try the following query. Please, notice that there are multiple entries for each order. You can group them on order_no for total fee overridden.

SELECT      a.order_no,

            b.order_dt,

            b.customer_no,

            fee_overridden=CASE WHEN a.fee_override_ind='Y' THEN 'Yes' ELSE 'No' END,

            a.fee_override_amt,

            overridden_by=a.created_by,

            fee_predefined=CASE WHEN a.fee_no IS NULL THEN 'No' ELSE 'Yes' END,

            predefined_fee_amt=c.fee_amt,

            predefined_fee_description=c.description

      FROM t_sli_fee a

            INNER JOIN t_order b ON a.order_no=b.order_no

            LEFT OUTER JOIN t_fee c ON a.fee_no=c.fee_no

      WHERE a.fee_override_ind='Y'

      ORDER by a.order_no

Hope this helps,

Has anybody written a query or report to report on overridden fees and who overrode them? Or at least where to start getting the information.

Thanks,

Marty

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums.

Marty, here’s the quick response:

Check T_ORDER_SEAT_HIST, join to T_FEE on fee_no = fee_no, and look for the “Fee Changed” event in the event_code (=15 from TR_EVENT_CODE).

You can then restrict the output to fees that have fee_override_ind = ‘Y’.

That should give you who overrode the fee down to the userid, date, and batch_no, upon which user embarrassment, discipline, or praise can commence.

J