Do you spend tons of time setting up Funding Sources and Fee Schedules across a lot of similar providers. Here’s a script to quickly update them. I can help you tweak and run the scripts if needed. Just give me a call.
Update All from Funding_Source 202.
UPDATE _funding_source_rate AS dest,
(SELECT Rate, Allowable, Extra_codes FROM _funding_source_rate WHERE Funding_Source = 202 LIMIT 1) AS src
SET
dest.Rate = src.Rate,
dest.Allowable = src.Allowable,
dest.Extra_codes = src.Extra_codes
WHERE
dest.Funding_Source <> 202;
Update Specific Funding Sources
UPDATE _funding_source_rate AS dest,
(SELECT Rate, Allowable, Extra_codes FROM _funding_source_rate WHERE Funding_Source = 202 LIMIT 1) AS src
SET
dest.Rate = src.Rate,
dest.Allowable = src.Allowable,
dest.Extra_codes = src.Extra_codes
WHERE
dest.Funding_Source IN (203, 204, 206);
**Funding Source Names can be found here.
select * from `_funding_source` fs