How To Deal with RAPS Submission Problems

There are many different data issues that must be be dealt when preparing your data for submission to the Risk Adjustment Processing System (RAPS). To reduce the risk of your submission file being rejected, its best to address a lot of the possible errors that could occur in your script. Below is the lay out that for RAPS submissions.

RAPS Data requires:

• HIC Number
• Diagnosis Codes
• From Date of Service
• Through Date of Service
• Provider Type

The most common errors that we want to look out for are incorrect date formats, spaces before and after the data, nulls, and periods in the diagnoisis codes.  Use the below script to handle these common errors.

SET NOCOUNT ON;SELECT DISTINCT
 ,ltrim(rtrim([HIC Number])) as [HIC Number]
,ltrim(rtrim([First Name])) as [First Name]
,ltrim(rtrim([Last Name])) as [Last Name],CONVERT (varchar (10),[DosFrom], 101) as [From Date]

,CONVERT (varchar (10),[DosTo], 101) as [To Date]
,[PT1] as [Provider Type 1]
,[Diag 1]= CASE WHEN [diag 1] Is NULL THEN ''
ELSE [Diag 1] END
,[Provider Type 2] = CASE WHEN [Diag 2] Is NULL THEN ''
ELSE '20' END
,[Diag 2]= CASE WHEN [diag 2] Is NULL THEN ''
ELSE [Diag 2] END
,[Provider Type 3] = CASE WHEN [Diag 3] Is NULL THEN ''
ELSE '20' END
,[Diag 3]= CASE WHEN [diag 3] Is NULL THEN ''
ELSE [Diag 3] END
,[Provider Type 4] = CASE WHEN [Diag 4] Is NULL THEN ''
ELSE '20' END
,[Diag 4]= CASE WHEN [diag 4] Is NULL THEN ''
ELSE [Diag 4] END
,[Provider Type 5] = CASE WHEN [Diag 5] Is NULL THEN ''
ELSE '20' END
,[Diag 5]= CASE WHEN [diag 5] Is NULL THEN ''
ELSE [Diag 5] END
,[Provider Type 6]= CASE WHEN [Diag 6] Is NULL THEN ''
ELSE '20' END
,[Diag 6]= CASE WHEN [diag 6] Is NULL THEN ''
ELSE [Diag 6] END
,[Provider Type 7] = CASE WHEN [Diag 7] Is NULL THEN ''
ELSE '20' END
,[Diag 7]= CASE WHEN [diag 7] Is NULL THEN ''
ELSE [Diag 7] END
,[Provider Type 8]= CASE WHEN [Diag 8] Is NULL THEN ''
ELSE '20' END
,[Diag 8]= CASE WHEN [diag 8] Is NULL THEN ''
ELSE [Diag 8] END
,[Provider Type 9] = CASE WHEN [Diag 9] Is NULL THEN ''
ELSE '20' END
,[Diag 9]= CASE WHEN [diag 9] Is NULL THEN ''
ELSE [Diag 9] END

This is just a general example for you to use as a guide. However, this format does work with most coding vendors extracts.