B-FED-MTCH-CD 7747 281089 Add columns to fedcms64 table 10/1/2008 Update FEDCMS64 Data Warehouse Table With 7746 281089 New Fields - Pass SYSID, COE and FED-MTCH-CD 9/30/2008 to DW fedcms64 table CMS 64 Report and the 2009 ICD-9 Update - 7800 281200 UPDATE 2009 DIAGNOSIS CODES by changing 9/30/2008 upper range from 669.99 to 679.14 Modify the CMS64 to look at DRG code 767 instead of 374 for Family Planning; DRG for family planning 7708 N/A 7/24/2008 changed from 374 to 767 for effective dates after 10/01/2007 Remove code that checks for FED CMS 64 Reporting - Reverse PE System Logic of 7716 280895 7/2/2008 CODE = '3' when assigning 28-0500 CMS64 Report ID and Column ID For FFY/Quarter = 2008/3 DW change - PE supp report • developed initially in MS Access. MF reran qtr ended Jun08 with changes. Records sent down to DW for the table Reverse 280500 changes for PE reporting and add 7716 280895 7/1/2008 update. (Need added columns in adhoc report of PE expenditures fedcms64 table to add this report to supplemental Cognos reports.) Mainframe Change - modified to not • include COE 071/3 on the SCHIPS report Add adj reason code 082. Manual 7658 280847 CMS Perm Recovery Project - PDCS 6/1/2008 change to vvadjrsn table made for 082 Added all code that assigns CMS64 Report ID's and Column ID's for BASE, FMPL and SCHP reports COGNOS CMS64 Report Changes (PE 7551 280500 4/18/2008 Modified for the SCHIPs PE • expenditures) COE 071/3 to be included on The SCHIPS report Also excluded rev code '001 'as total • line PL7548
B-FED-MTCH-CD 7747 281089 Add columns to fedcms64 table 10/1/2008 7746 281089 Update FEDCMS64 Data Warehouse Table With New Fields - Pass SYSID, COE and FED-MTCH-CD to DW fedcms64 table 9/30/2008 7800 281200 CMS 64 Report and the 2009 ICD-9 Update - UPDATE 2009 DIAGNOSIS CODES by changing upper range from 669.99 to 679.14 9/30/2008 7708 N/A Modify the CMS64 to look at DRG code 767 instead of 374 for Family Planning; DRG for family planning changed from 374 to 767 for effective dates after 10/01/2007 7/24/2008 7716 280895 CMS 64 Reporting - Reverse PE System Logic of 28-0500 7/2/2008 Remove code that checks for FED CODE = '3' when assigning CMS64 Report ID and Column ID 7716 280895 Reverse 280500 changes for PE reporting and add adhoc report of PE expenditures 7/1/2008 For FFY/Quarter = 2008/3 • DW change - PE supp report developed initially in MS Access. MF reran qtr ended Jun08 with changes. Records sent down to DW for the table update. (Need added columns in fedcms64 table to add this report to supplemental Cognos reports.) • Mainframe Change - modified to not include COE 071/3 on the SCHIPS report 7658 280847 CMS Perm Recovery Project - PDCS 6/1/2008 Add adj reason code 082. Manual change to vvadjrsn table made for 082 7551 280500 COGNOS CMS64 Report Changes (PE expenditures) 4/18/2008 Added all code that assigns CMS64 Report ID's and Column ID's for BASE, FMPL and SCHP reports • Modified for the SCHIPs PE COE 071/3 to be included on The SCHIPS report • Also excluded rev code '001 'as total line PL7548
XEROX%20CMS-64%20Reporting%2024D-5exhb-B.docx