Name		Name	Last commit message	Last commit date
100 Percent Reimbursement 6-25-15sql.sql		100 Percent Reimbursement 6-25-15sql.sql
1st Denial Authorization vs First Pass Denials.sql		1st Denial Authorization vs First Pass Denials.sql
2011-2016 RVU's.sql		2011-2016 RVU's.sql
2017 Charges with Matched Detail v2.sql		2017 Charges with Matched Detail v2.sql
2017 Charges with Matched Detail.sql		2017 Charges with Matched Detail.sql
4019 Credit Adjustments for Jennifer Coburn.sql		4019 Credit Adjustments for Jennifer Coburn.sql
ACC PEDS examples.sql		ACC PEDS examples.sql
AFL 310 Monthly Matched Payments.sql		AFL 310 Monthly Matched Payments.sql
AFL 402 Outstanding Balance.sql		AFL 402 Outstanding Balance.sql
AFL 612 Charges by provider.sql		AFL 612 Charges by provider.sql
AFL 612 Payments for Kathryn Davis.sql		AFL 612 Payments for Kathryn Davis.sql
AFL 613 Nephrology Assoc of Toledo Inc Transactions.sql		AFL 613 Nephrology Assoc of Toledo Inc Transactions.sql
AFL 613 charges with procedures.sql		AFL 613 charges with procedures.sql
AMA_Specialty.sql		AMA_Specialty.sql
AR Aging Summary by Year-Month and Region.sql		AR Aging Summary by Year-Month and Region.sql
AR Aging.sql		AR Aging.sql
AR Credits and Debits by Year-Month.sql		AR Credits and Debits by Year-Month.sql
AR Days by Department.sql		AR Days by Department.sql
AR Detail - Mary Rutterer.sql		AR Detail - Mary Rutterer.sql
AR Root Cause Query.sql		AR Root Cause Query.sql
ARPB_FILING_ORDER review.sql		ARPB_FILING_ORDER review.sql
ASAP LOS Charges.sql		ASAP LOS Charges.sql
Adjusted wRVU without exclusions.sql		Adjusted wRVU without exclusions.sql
Adjustment Dollars and Counts.sql		Adjustment Dollars and Counts.sql
Adjustments by Year-Month and Region.sql		Adjustments by Year-Month and Region.sql
Adjustments.sql		Adjustments.sql
Aetna Payors - Detail.sql		Aetna Payors - Detail.sql
Aetna Payors.sql		Aetna Payors.sql
Affilliate List.sql		Affilliate List.sql
Alan Gabbard Claims.sql		Alan Gabbard Claims.sql
Allowed Amounts by CPT Code.sql		Allowed Amounts by CPT Code.sql
Andrea Condon Final Denials.sql		Andrea Condon Final Denials.sql
Andrea Condon add RPT_GRP_ONE.sql		Andrea Condon add RPT_GRP_ONE.sql
Anesthesia Tranaction File.sql		Anesthesia Tranaction File.sql
Anesthesia_Concurrency.sql		Anesthesia_Concurrency.sql
Anesthesia_Modifiers.sql		Anesthesia_Modifiers.sql
Anesthesia_Provider.sql		Anesthesia_Provider.sql
Anesthesia_Times.sql		Anesthesia_Times.sql
Anodyne Scripts 20190301.txt		Anodyne Scripts 20190301.txt
Anthem Risk Adjustment.sql		Anthem Risk Adjustment.sql
Anthem Senior Advantage v.1.sql		Anthem Senior Advantage v.1.sql
Anthem Takebacks.sql		Anthem Takebacks.sql
Bad Debt - Original Collection Amt.sql		Bad Debt - Original Collection Amt.sql
Bad Debt 20171214 .sql		Bad Debt 20171214 .sql
Bad Debt 20171215 .sql		Bad Debt 20171215 .sql
Bad Debt 20171218 .sql		Bad Debt 20171218 .sql
Bad Debt 20171220.sql		Bad Debt 20171220.sql
Bad Debt Correct Amounts.sql		Bad Debt Correct Amounts.sql
Bad Debt Deep Dive.sql		Bad Debt Deep Dive.sql
Bad Debt Final.sql		Bad Debt Final.sql
Bad Debt Recovery on ZBA - Duplicates.sql		Bad Debt Recovery on ZBA - Duplicates.sql
Bad Debt Recovery on ZBA - Tina.sql		Bad Debt Recovery on ZBA - Tina.sql
Bad Debt Recovery on ZBA.sql		Bad Debt Recovery on ZBA.sql
Bad Debt Self-Pay by Collection Date.sql		Bad Debt Self-Pay by Collection Date.sql
Bad Debt Self-Pay.sql		Bad Debt Self-Pay.sql
Bad Debt by Account.sql		Bad Debt by Account.sql
Bad Debt.sql		Bad Debt.sql
Balance Collected vs Expected.sql		Balance Collected vs Expected.sql
Beacon_Charge_Source.sql		Beacon_Charge_Source.sql
Behavioral Health Final Denial Detail.sql		Behavioral Health Final Denial Detail.sql
Brian Brocker Charges and Units.sql		Brian Brocker Charges and Units.sql
Business Recap - ALL.sql		Business Recap - ALL.sql
Business Recap - Custom Views.sql		Business Recap - Custom Views.sql
COPR Open Encounters - Monthly Detail.sql		COPR Open Encounters - Monthly Detail.sql
COPR Open Encounters - Monthly Summary.sql		COPR Open Encounters - Monthly Summary.sql
COPR Open Encounters - Weekly Detail.sql		COPR Open Encounters - Weekly Detail.sql
COPR_Open_Encounters_by_Department_CREATE.sql		COPR_Open_Encounters_by_Department_CREATE.sql
CPT 99444.sql		CPT 99444.sql
CPT Allowed Amounts with Procedure Quantities - Anthem.sql		CPT Allowed Amounts with Procedure Quantities - Anthem.sql
CPT Allowed Amounts with Procedure Quantities.sql		CPT Allowed Amounts with Procedure Quantities.sql
CPT Coders and Modifier Examples.sql		CPT Coders and Modifier Examples.sql
CPT Utilization.sql		CPT Utilization.sql
Cancer Center Self Pay Patients.sql		Cancer Center Self Pay Patients.sql
CareSource 20180103.sql		CareSource 20180103.sql
Cash Reconciliation (Matched).sql		Cash Reconciliation (Matched).sql
Cash Reconciliation - Matched Payments.sql		Cash Reconciliation - Matched Payments.sql
CashCollections.sql		CashCollections.sql
Cash_Collections.sql		Cash_Collections.sql
Chan Audit - Charge Detail.sql		Chan Audit - Charge Detail.sql
Chan Audit Charge Detail.sql		Chan Audit Charge Detail.sql
Chan Audit detail report - charges.matched trans.rvu.sql		Chan Audit detail report - charges.matched trans.rvu.sql
Charge Detail - Lemoine.sql		Charge Detail - Lemoine.sql
Charge Lag by Department and Provider.sql		Charge Lag by Department and Provider.sql
Charge Lag by Department.sql		Charge Lag by Department.sql
Charge Level Information.sql		Charge Level Information.sql
Charge Report - Jessica Lemoine.sql		Charge Report - Jessica Lemoine.sql
Charge Review Days.sql		Charge Review Days.sql
Charge Review TAR Accounts - Filed Without Review.sql		Charge Review TAR Accounts - Filed Without Review.sql
Charge Review TAR Accounts - In Review.sql		Charge Review TAR Accounts - In Review.sql
Charge Review WQ's - Sara Ketterer.sql		Charge Review WQ's - Sara Ketterer.sql
Charge Review WQ.sql		Charge Review WQ.sql
Charge Spikes.sql		Charge Spikes.sql
Charge report - Dryer.sql		Charge report - Dryer.sql
Charge_Source.sql		Charge_Source.sql
Charges - Dryer.sql		Charges - Dryer.sql
Charges by Referring Provider.sql		Charges by Referring Provider.sql
Charges matched to Payments and Adjustments.sql		Charges matched to Payments and Adjustments.sql
Charges updated in Claim Edit.sql		Charges updated in Claim Edit.sql
Claim Level Information.sql		Claim Level Information.sql
Clarity_Crowe_Package.sql		Clarity_Crowe_Package.sql

Repository files navigation

sql-scripts

Repository for all sql-scripts

About

Repository for all sql-scripts.

1 star

0 watching

Report repository

Releases

Packages

Contributors

Languages