Missing Authorizations widget
The Missing Authorizations widget displays all active clients where a guarantor requires an authorization and no authorization exists. This is set up in the Guarantors/Payors form, on the Authorization Information section, by checking off at least one value for for the Verify Services and Appointments Against Available Authorizations option. This will include clients who have financial eligibility information entered through Financial Eligibility or Cross Episode Financial Eligibility.
The following fields should be displayed in the widget:
- Client (Last, First, MR#)
- Guarantor
- Episode #
If you click on the Client link in the list, the Managed Care Authorizations form displays for the client.
Widget SQL Statement
Because this widget was modified to include all the different financial eligibility types, it was handled in cache code and therefore no SQL code is available. However, if you want to use the queries to create separate individual widgets (Standard FE, Cross Episode FE, Family FE) you could use the following SQL statements to create your own widget to meet your organization's needs.
Episodic
Select: "billing_guar_order_current"."PATID", "billing_guar_order_current"."guarantor_name", "billing_guar_order_current"."EPISODE_NUMBER", "billing_guar_order_current"."GUARANTOR_ID" FROM (("SYSTEM"."billing_guar_order_current" "billing_guar_order_current" INNER JOIN "SYSTEM"."billing_guar_table" "billing_guar_table" ON ("billing_guar_order_current"."GUARANTOR_ID" = "billing_guar_table"."GUARANTOR_ID" AND "billing_guar_order_current"."FACILITY" = "billing_guar_table"."FACILITY" AND "billing_guar_table"."verify_svcapp_auth_code" IS NOT NULL)) LEFT OUTER JOIN "SYSTEM"."history_managed_care_auths" "history_managed_care_auths" ON (("billing_guar_order_current"."PATID"="history_managed_care_auths"."PATID") AND ("billing_guar_order_current"."GUARANTOR_ID"="history_managed_care_auths"."GUARANTOR_ID")) AND (("billing_guar_order_current"."EPISODE_NUMBER"="history_managed_care_auths"."EPISODE_NUMBER") OR "history_managed_care_auths"."EPISODE_NUMBER" IS NULL)) WHERE "history_managed_care_auths"."GUARANTOR_ID" IS NULL AND "billing_guar_order_current"."FACILITY"=?FACILITY
Non-Episodic / Cross Episode
Select: "billing_guar_order_no_ep"."PATID", "billing_guar_order_no_ep"."guarantor_name", "billing_guar_order_no_ep"."GUARANTOR_ID" FROM (("SYSTEM"."billing_guar_order_no_ep" "billing_guar_order_no_ep" INNER JOIN "SYSTEM"."billing_guar_table" "billing_guar_table" ON ("billing_guar_order_no_ep"."GUARANTOR_ID" = "billing_guar_table"."GUARANTOR_ID" AND "billing_guar_order_no_ep"."FACILITY" = "billing_guar_table"."FACILITY" AND "billing_guar_table"."verify_svcapp_auth_code" IS NOT NULL)) LEFT OUTER JOIN "SYSTEM"."history_managed_care_auths" "history_managed_care_auths" ON (("billing_guar_order_no_ep"."PATID"="history_managed_care_auths"."PATID") AND ("billing_guar_order_no_ep"."GUARANTOR_ID"="history_managed_care_auths"."GUARANTOR_ID")) AND ("history_managed_care_auths"."EPISODE_NUMBER"IS NULL)) WHERE "history_managed_care_auths"."GUARANTOR_ID" IS NULL AND "billing_guar_order_no_ep"."FACILITY"=?FACILITY
For more information, see the Billing Widget Consoles training guide.