The $100 million that we are off is in relation to revenues and expenditures. We have recorded in the General Ledger in SHARE more the CMS64 for the draws and the SHARE totals from expenditures (SHARE Activity File) the SHARE Activity File for the expenditures. than revenue (CMS64 weekly draw). REQUIRES Implementing a new SHARE file in the data warehouse – ESTIMATED 8 WEEKS TO ACHIEVE Add Optum Health provider number 8140 290329 Transition from VO to OptumHealth 4/23/2009 and logic to include Optum health as new provider. CMS 64 reject record not being CMS64 REJECT record contains bad data from initialized after every write of the reject 8122 N/A 4/23/2009 previous record; file. Causes bad data to be written to the reject file. Clients with COE 036 were switched to the SCHIPS meg effective 4/1/09 but N/A Salud IHS capitations not reported on CMS64 4/1/2009 the switch to move their IHS caps did not occur. PIB has corrected their SALUD programs Add Two Financial Reason Codes: 017 - Upper Limit 7979 281747 3/8/2009 Payment, 101 - SCI Payment For FFY/Quarter = 2009/1 7790 281178 Add PE supplemental report 1/1/2009 PE report added to Cognos - replaces Access version (280895) Change CMS64 Report Criteria To Correct DSH 7370 271442 10/10/2008 Payment Placement 6913 270269 Add Financial Reason Codes 10/10/2008 Increase upper range of diagnosis 7800 281200 CMS 64 Report and the 2009 ICD-9 Update 10/3/2008 codes from 669.99 to 679.14 to reflect new 2009 diagnosis codes. Update CMS 64 download file to pass three new fields to data warehouse for all record types Update FEDCMS64 Data Warehouse Table With (medical '60', institutional '61' 7746 281089 10/3/2008 New Fields Pharmacy '62' and financial '66') They are: B-SYS-ID B-COE-CD
the CMS64 for the draws and the SHARE totals from the SHARE Activity File for the expenditures. The $100 million that we are off is in relation to revenues and expenditures. We have recorded in the General Ledger in SHARE more expenditures (SHARE Activity File) than revenue (CMS64 weekly draw). REQUIRES Implementing a new SHARE file in the data warehouse – ESTIMATED 8 WEEKS TO ACHIEVE 8140 290329 Transition from VO to OptumHealth 4/23/2009 Add Optum Health provider number and logic to include Optum health as new provider. 8122 N/A CMS64 REJECT record contains bad data from previous record; 4/23/2009 CMS 64 reject record not being initialized after every write of the reject file. Causes bad data to be written to the reject file. N/A Salud IHS capitations not reported on CMS64 4/1/2009 Clients with COE 036 were switched to the SCHIPS meg effective 4/1/09 but the switch to move their IHS caps did not occur. PIB has corrected their SALUD programs 7979 281747 Add Two Financial Reason Codes: 017 - Upper Limit Payment, 101 - SCI Payment 3/8/2009 7790 281178 Add PE supplemental report 1/1/2009 For FFY/Quarter = 2009/1 PE report added to Cognos - replaces Access version (280895) 7370 271442 Change CMS64 Report Criteria To Correct DSH Payment Placement 10/10/2008 6913 270269 Add Financial Reason Codes 10/10/2008 7800 281200 CMS 64 Report and the 2009 ICD-9 Update 10/3/2008 Increase upper range of diagnosis codes from 669.99 to 679.14 to reflect new 2009 diagnosis codes. 7746 281089 Update FEDCMS64 Data Warehouse Table With New Fields 10/3/2008 Update CMS 64 download file to pass three new fields to data warehouse for all record types (medical '60', institutional '61' Pharmacy '62' and financial '66') They are: B-SYS-ID B-COE-CD