The purpose of the duplicate logic is to bypass claims which have already been submitted/processed for manual review to limit the risk of duplicate claims loading to an account. We will be using SOUND EX to account for common variations or misspellings that a provider may have entered when checking against claims already submitted. The SOUND EX function is a SQL function which converts an alphanumeric string into a 4 character code based on how the string sounds when spoken. Here are some examples: VAR1 SOUNDEX1 VAR2 SOUNDEX2 SOUNDEX_MATCH Brenda B653 Brendan B653 MATCH Edward E363 Edwardo E363 MATCH Luis L200 Lois L200 MATCH Philip P410 Phillip P410 MATCH Steve S310 Stephen S315 MISMATCH Steven S315 Stephen S315 MATCH Thomas T520 Tomas T520 MATCH Tod T300 Todd T300 MATCH How does Soundex function Work? Let’s talk through this with Brenda / Brendan to see why this comes back as match Step 1: Generates 4 character code- begins with first letter of word E.g. Brenda B-_ _ _ _ Brandan B-_ _ _ _ Step 2: Removes A E I O U H W Y excluding the first character E.g. Brenda => Brnd Brandon => Brndn Step 3: Use the table to convert letters to numbers until you have. Number Represents the Letters 1 B, F, P, V 2 C, G, J, K, Q, S, X, Z 3 D, T 4 L 5 M, N 6 R E.G. BRND B- R=6 N=5 D=3 Brenda Soundex = B653 BRNDN The N is ignored for Brandon because BRND already provides a 4 character string. Brendan Brendon Brandon and Brenden would all result in the same Soundex value. This Query: WITH selectone as (/*This is just here so we can run the query and return one result*/SELECT PRSN_INTN_ID From PB09754E.PRSN WHERE PRSN_INTN_ID = 476690091) SELECT SOUNDEX('Brendan') AS SOUNDEX1 ,SOUNDEX('Brendon') AS SOUNDEX2 ,SOUNDEX('Brandon') AS SOUNDEX3 ,SOUNDEX('Brenden') AS SOUNDEX4 FROM selectone With Ur Returns: SOUNDEX1 SOUNDEX2 SOUNDEX3 SOUNDEX4 B653 B653 B653 B653 If you don’t have all 4 characters use 0 (zero) E.G. Tod => TD _ _ T-D=3 Blank = 0 Blank = 0 I need the names which are different like above example.. Hope you got it ? Thanks!!
... View more