Version Implementation

ICD10 Process:

STEP 1 : To know the Version updates for ICD10 - CM codes from CMS website Just follow the below URL
URL: https://www.cms.gov/medicare/coding/icd10

STEP 2 : After entering into the website we can see the all versions like 2018, 2019, 2021,2022 then we can select latest update version 2022 ICD_10_CM, here we can see the following Zip files 1. 2022 POA Exempt Codes (ZIP) 2. 2022 Conversion Table - Updated 08/27/2021 (ZIP) 3. 2022 Code Descriptions in Tabular Order (ZIP) 4. 2022 Addendum (ZIP) 5. 2022 Code Tables, Tabular and Index (ZIP)

STEP 3 : Download the 2022 Code Descriptions in Tabular Order (ZIP) Zip file .

STEP 4 : Open the downloaded file there we can see the icd10cm_codes_addenda_2022.txt

STEP 5 : Open icd10cm_codes_addenda_2022.txt file and Separate the codes like Additions , Deletions and Revised codes in Editplus or Excel.

STEP 6 : a . Import the Additions data from excel to Temporary table ICD_2022 in TestDB
b. Import the Revised data from excel to Temporary table ICD_2022_Revised in TestDB.

STEP 7 : Clear the left side spaces and right side spaces for all fields in tables ICD_2022 ,ICD_2022_Revised

Queries to trim the spaces :

 Update set   ICD_2022= Ltrim(Rtrim(ICDCode)), ICD10Code= Ltrim(Rtri(ICD10Code)),ShortDesc= Ltrim(Rtrim(ShortDesc)),LongDesc= Ltrim(Rtrim(LongDesc)) 

Update set   ICD_2022_Reviesed= Ltrim(Rtrim(ICDCode)),  ICD10Code= Ltrim(Rtri(ICD10Code)),
ShortDesc= Ltrim(Rtrim(ShortDesc)),LongDesc= Ltrim(Rtrim(LongDesc))   

STEP 8 : Change ICD10Code format by placing dot(.) after three characters
Query :

Update ICD_2022 set  ICD10Code= left(ICDCode,3)+'.'+substring(ICD10Code,4,len(ICDCode))  from  ICD_2022 
where len(ICD10Code)>3 and ICD10Code not like '%.%'

STEP 9 : Add Addition data to KpaiMater.dbo.CMS_DxcodeDesc table with EffectiveFrom Oct 1,2021 and EffectiveTo Sep 30,2022.

STEP 10 : Update EffectiveYearTo field for all codes

 Update KpaiMater.dbo.CMS_DxcodeDesc   set   EffectiveYearTo ='2022-09-30 23:59:59.000'     
 where EffectiveYearTo='2021-09-30 23:59:59.000' 

STEP 11 : Update EffectiveYear From and To fields for Newly Added Codes

update CMS_DXCodeDesc  set  EffectiveYearFrom='2020-10-01 00:00:00.000' , 
EffectiveYearTo='2021-09-30 23:59:59.000'  where EffectiveYearFrom is null

STEP 12 : Update IcdLevel Field based on code length

  update CMS_DXCodeDesc set IcdLevel=1  from CMS_DXCodeDesc   
   where EffectiveYearFrom='2021-10-01 00:00:00.000' and LEN(ICDCode)=3

   update CMS_DXCodeDesc set IcdLevel=2  from CMS_DXCodeDesc   
   where EffectiveYearFrom='2021-10-01 00:00:00.000' and LEN(ICDCode)=4

   update CMS_DXCodeDesc set IcdLevel=3  from CMS_DXCodeDesc   
   where EffectiveYearFrom='2021-10-01 00:00:00.000' and LEN(ICDCode)=5

  update CMS_DXCodeDesc set IcdLevel=4  from CMS_DXCodeDesc   
  where EffectiveYearFrom='2021-10-01 00:00:00.000' and LEN(ICDCode)=6

  update CMS_DXCodeDesc set IcdLevel=5  from CMS_DXCodeDesc   
  where EffectiveYearFrom='2021-10-01 00:00:00.000' and LEN(ICDCode)=7

STEP 13 : Update GrouperId field We can consider GrouperId value is ICD10Code

 Update CMS_DXCodeDesc  set GrouperId=ICD10Code 
 where EffectiveYearFrom='2021-10-01 00:00:00.000'

ICD10 Deletion process :

In the process of deletion we can update the EffectiveYeatTo field with '2020-09-30 23:59:59.000'

Query :

 update KPAIMaster.dbo.CMS_DXCodeDesc set EffectiveYearTo='2021-09-30 23:59:59.000' 
 where ICDCode in (DeletionCodes)

ICD CODE Revised process :

In revised process we should update the ShortDesc,LongDesc of KPAIMaster.dbo.CMS_DXCodeDesc with Description in ICD_2022_Revised table for only matched codes of two tables.

 Update a1 Set ShortDesc=a2.Description,LongDesc=a2.Description from
 KPAIMaster.dbo.CMS_DXCodeDesc a1
 inner join ICD_2022_Revised a2 on a1.ICDCode=a2.Code
 where a2.Code is not null

PCS Process :

STEP 1 : To know the Version updates for ICD10 - CM codes from CMS website Just follow the below URL
URL: https://www.cms.gov/medicare/coding/icd10

STEP 2 : After entering into the website we can see the all versions like 2018, 2019, 2021,2022 then we can select latest update version 2022 ICD_10 PCS, here we can see the following Zip files 1. 2022 ICD-10-PCS Order File (Long and Abbreviated Titles) (ZIP) 2. 2022 Official ICD-10-PCS Coding Guidelines (PDF) 3. 2022 Version Update Summary (ZIP) 4. 2022 ICD-10-PCS Codes File (ZIP) 5. 2022 ICD-10-PCS Conversion Table (ZIP) 6. 2022 ICD-10-PCS Code Tables and Index (ZIP) 7. 2022 ICD-10-PCS Addendum (ZIP)

STEP 3 : Download the 2022 ICD-10-PCS Codes File (ZIP) Zip file .

STEP 4 : Open the downloaded file there we can see the codes_addenda_2022.txt

STEP 5 : Open codes_addenda_2022.txt file and Separate the codes like Additions , Deletions and Revised codes in Editplus or Excel.

STEP 6 : a . Import the Additions data from excel to Temporary table PCS_2022 in TestDB
b. Import the Revised data from excel to Temporary table PCS_2022_Revised in TestDB.

STEP 7 : Clear the left side spaces and right side spaces for all fields in tables PCS_2022 ,PCS_2022_Revised

Queries to trim the spaces :

 Update PCS_2022 set CPTCode=LTRIM(RTRIM(CPTCode)),ShortDesc=LTRIM(RTRIM(ShortDesc)),
 LongDesc=LTRIM(RTRIM(LongDesc))

Update PCS_2022_Revised set PcsCode=LTRIM(RTRIM(PcsCode)),Description=LTRIM(RTRIM(Description)) 
where PcsCode is not null

Add Addition data to KPAIMaster.dbo.CMS_PCSCodeDesc table with EffectiveFrom Oct 1,2021 and
EffectiveTo Sep 30,2022.

STEP 8 : Update EffectiveYearTo field for all codes

 Update KpaiMater.dbo.CMS_PCSCodeDesc   set   EffectiveYearTo ='2022-09-30 23:59:59.000'     
 where EffectiveYearTo='2021-09-30 23:59:59.000' 

STEP 9 : Update EffectiveYear From and To fields for Newly Added Codes

update CMS_PCSCodeDesc  set  EffectiveYearFrom='2020-10-01 00:00:00.000' , 
EffectiveYearTo='2021-09-30 23:59:59.000'  where EffectiveYearFrom is null

PCS CODE Deletion process :

In the process of deletion we can update the EffectiveYeatTo field with '2020-09-30 23:59:59.000' Query : ```

update KPAIMaster.dbo.CMS_PCSCodeDesc set EffectiveYearTo='2021-09-30 23:59:59.000' where ICDCode in (DeletionCodes) ```

PCS CODE Revised process :

In revised process we should update the ShortDesc,LongDesc of KPAIMaster.dbo.CMS_PCSCodeDesc with Description in PCS_2022_Revised table for only matched codes of two tables.

Update a1 Set ShortDesc=a2.Description,LongDesc=a2.Description from
KPAIMaster.dbo.CMS_PCSCodeDesc a1
inner join PCS_2022_Revised a2 on a1.CPTCode=a2.PcsCode
where a2.PcsCode is not null

MSDrg Process :

STEP 1 : To download the MSDrg file ,first we should enter into the CMS website through the following URL URL : https://www.cms.gov/medicare/acute-inpatient-pps/fy-2022-ipps-final-rule-home-page

Note:If you want to Download Previous Year just you need to replace the year 2021 instead of 2022 in the URL.

On the left side we can see the 'FY 2022 IPPS Final Rule Home Page' Just click on that link, then we can see the 'FY 2022 Final Rule Tables'.

STEP 2 : In 'FY 2022 Final Rule Tables' we should download the Table 5 (ZIP) file. there we can see the 'CMS-1752-F Table 5.txt' text file then edit that file in excel.

STEP 3 : Import that Excel file into temporary table MSDrg_2022 in TestDB.

STEP 4 : Clear the spaces for all fields in table MSDrg_2022

Query to clear spaces :

Update MSDRG_2022 set MSDRG=LTRIM(RTRIM(MSDRG)),MSDRGDesc=LTRIM(RTRIM(MSDRGDesc)),MSDRGWeight=LTRIM(RTRIM(MSDRGWeight)),MSDRGMDC=LTRIM(RTRIM(MSDRGMDC)),MSDRGGLOS=LTRIM(RTRIM(MSDRGGLOS)),
MSDRGALOS=LTRIM(RTRIM(MSDRGALOS)),PostAcuteDRG=LTRIM(RTRIM(PostAcuteDRG)),
SpecialPayDRG=LTRIM(RTRIM(SpecialPayDRG)),MSDRGType=LTRIM(RTRIM(MSDRGType)),
MSDRGVersion=LTRIM(RTRIM(MSDRGVersion))

STEP 5 : Update the CurrentVersion 1 to 0 for all codes in Crmc.dbo.MST_MSDRGInfo table.

STEP 6 : Add Addition data to Crmc.dbo.MST_MSDRGInfo table with EffectiveFrom Oct 1,2021 and
EffectiveTo Sep 30,2022 and CurrentVersion=1.

STEP 7 : update TransferDrg based on (PostAcuteDrg condition or using following query) to Crmc.dbo.MST_MSDRGInfo table.

QUERY :

Update Crmc.dbo.MST_MSDRGInfo Set TransferDrg='T*' where MSDRGVersion=39 and PostAcuteDrg='YES' and CurrentVersion=1

CCMCC Process :

To know the Version updates for CC/MCC codes from CMS website,use the following URL. URL : https://www.cms.gov/medicare/acute-inpatient-pps/fy-2022-ipps-final-rule-home-page

Here we can see the FY 2022 Final Rule Tables ,there we should download the Tables 6A-6J and Tables 6P.1a-6P.3a (ZIP).

STEP 1 : Open the downloaded folder,here we should open the 'CMS-1752-F Table 6A - 6J.2.zip' then we can find the following text files. 1.CMS-1752-F Table 6I.1 - Additions to the MCC List - FY 2022.txt 2.CMS-1752-F Table 6I.2 - Deletions to the MCC List - FY 2022.txt 3.CMS-1752-F Table 6J.1 - Additions to the CC List - FY 2022.txt 4.CMS-1752-F Table 6J.2 - Deletions to the CC List - FY 2022.txt

STEP 2 : Add the additions codes codes the KPAIMaster.dbo.CMS_CCMCCCode Table .

STEP 3 : Update EffectiveYearTo field for all codes

Update KPAIMaster.dbo.CMS_CCMCCCode set EffectiveYearTo='2021-09-30 23:59:59.000'

STEP 4 : Update EffectiveYear From and To fields for Newly Added Codes

update KPAIMaster.dbo.CMS_CCMCCCode  set  EffectiveYearFrom='2020-10-01 00:00:00.000' , 
EffectiveYearTo='2021-09-30 23:59:59.000'  where EffectiveYearFrom is null

CCMCC deletion process :

In the process of deletion we can update the EffectiveYeatTo field with '2021-09-30 23:59:59.000'

Query :

 update KPAIMaster.dbo.CMS_CCMCCCode set EffectiveYearTo='2021-09-30 23:59:59.000' 
 where ICDCode in (DeletionCodes)

## HAC process :

To get the HAC version implemetation codes from CMS website use following URL. URL : https://www.cms.gov/Medicare/Medicare-Fee-for-Service-Payment/HospitalAcqCond/icd10_hacs

STEP 1 : Download the FY 2022 Hospital Acquired Conditions List (ZIP) file.

STEP 2 : Open the downloaded file there we can see the FY_2022_Hospital_Acquired_Conditions_List.xlsx work sheet. Here we we can find the 'HAC Diagnosis Added','HAC Diagnosis Deletion','HAC Procedure Added', 'HAC Procedure Deletion' work sheets.

Step 3 : Add the the HAC implemtation codes to the Kpaimaster.dbo.CMS_HACCodes table with effectivefrom='2021-10-01 00:00:00.000' and effectiveto='2022-09-30 23:59:59.000'

### HAC deletion process : In the process of deletion we can update the EffectiveYeatTo field with '2021-09-30 23:59:59.000'

Query :

 update KPAIMaster.dbo.CMS_CCMCCCode set EffectiveYearTo='2021-09-30 23:59:59.000' 
 where ICDCode in (DeletionCodes)