Produced by Araxis Merge on 4/23/2019 12:14:52 PM Central Daylight Time. See www.araxis.com for information about Merge. This report uses XHTML and CSS2, and is best viewed with a modern standards-compliant browser. For optimum results when printing this report, use landscape orientation and enable printing of background images and colours in your browser.
| # | Location | File | Last Modified |
|---|---|---|---|
| 1 | C:\AraxisMergeCompare\Pri_un\CCRS\CCRS-BUSRULES-v6.3\CCRS-BUSRULES-v6.3\testing\Test Cases | Team 4 Tester files Sprint 4 12062017.xlsx | Wed Mar 27 19:38:08 2019 UTC |
| 2 | C:\AraxisMergeCompare\Pri_re\CCRS\CCRS-BUSRULES-v6.3\CCRS-BUSRULES-v6.3\testing\Test Cases | Team 4 Tester files Sprint 4 12062017.xlsx | Wed Apr 17 02:59:12 2019 UTC |
| Description | Between Files 1 and 2 |
|
|---|---|---|
| Text Blocks | Lines | |
| Unchanged | 12 | 2520 |
| Changed | 11 | 24 |
| Inserted | 0 | 0 |
| Removed | 0 | 0 |
| Whitespace | |
|---|---|
| Character case | Differences in character case are significant |
| Line endings | Differences in line endings (CR and LF characters) are ignored |
| CR/LF characters | Not shown in the comparison detail |
No regular expressions were active.
| 1 | SHEET: Tim ely Filing Rule 180 Days | |
| 2 | TC4- CS010 - refact oring busi ness Rules for Timel y Filing , | |
| 3 | Update eac h type dat es, | |
| 4 | Test objec tive:,Veri fy the inv oice claim is receiv ed within the timely filing pe riod, so t hat the cl aim is APP ROVED if the date o f service is within the pre-de fined peri od of time and other wise denie d, | |
| 5 | Roles impa cted:, | |
| 6 | Test setup /Precondit ions:,Time ly Filing business r ules are c ompleted. 180 days c laims are identified in the da tabase and setup to used for t his test, | |
| 7 | Requiremen t or Chang e, | |
| 8 | APPROVEDan ce Criteri a,All rule s are impl emented - All types of claims are impact ed, | |
| 9 | ||
| 10 | Assumption s:, | |
| 11 | Test Case #,164407, | |
| 12 | TS4- CS010 - 593878 - Mature a nd Refacto ring busin ess Rules for Timely Filing - Profession al Claim l ine, | |
| 13 | Step numbe r,Descript ion,Expect ed results , | |
| 14 | 1,Query fo r a claim with Start Date of m ore than 1 80 days ov er the Cla im Service _Date_from by using a query of a specifi c batch,Cl aim line w ith First Date of Se rvice of more than 180 days o ver the Cl aim Servic e_Date_fro m is avail able,Start Date of t he claim / Service_d ate_from, | |
| 15 | 2,Select f ew of the claims and update th eir Receiv ed_date to be a NULL value,Cai ms with NU LL Service _Date_from are avail able, | |
| 16 | 3,Run batc h rule pro cessing jo b using th e same bat ch ID as p revious st ep,Batch p rocessing job is com pleted, | |
| 17 | 4,Query th e RULE_OUT COME table ,Query re sults are displayed, | |
| 18 | 5,Verify t hat claim with no S ervice_Dat e_from hav e "Service _Date_from is blank, unable to validate timely fil ing" messa ge display ed,Message is displa yed, | |
| 19 | 6,Verify t hat the cl aims with NULL Servi ce_Date_fr om are DEN IED,Claims are DENIE D, | |
| 20 | 7,Verify t hat for th e claims t hat have m ore than 1 80 days ra nge betwee n Claim Se rvice_Date _from and Date of Se rvice have "Claim Se rvice_Date _from %s i s greater than allow ed range f rom Date o f Service %s",Messag e is displ ayed, | |
| 21 | 8,Verify t hat the cl aims of mo re than 18 0 days ran ge has a s tatus of D enied ,Cla ims have DENIED sta tus, | |
| 22 | 9,Verify t hat the cl aims are a nnotated w ith the CA RC/RARC ap propriate reason num ber,Claims are annot ated with the CARC/R ARC approp riate reas on, | |
| 23 | 10,Using a query loc ate claims with Date of Servic e is 180 d ays on or before the Claim Ser vice_Date_ from,Invoi ces with First Date of Servic e of less than 180 d ays from t he Claim S ervice_Dat e_from are available , | |
| 24 | 11,Verify that claim s that are 180 days on or befo re the Cla im Service _Date_from have APP ROVED stat us,Claim i s in APPRO VED status , | |
| 25 | ||
| 26 | Test Case# ,Test Ca se # T est Script s# 1545 24 Stor y CS010 Require ment, | |
| 27 | ||
| 28 | ||
| 29 | ||
| 30 | TS4- CS010 - 593878 - Mature a nd Refacto ring busin ess Rules for Timely Filing - - Institu tional Cla ims , | |
| 31 | Step numbe r,Descript ion,Expect ed results , | |
| 32 | 1,Query fo r a claim with Start Date of m ore than 1 80 days ov er the Cla im Admissi on_date by using a q uery of a specific b atch,Claim line with Start Dat e of more than 180 d ays over t he Claim A dmission_d ate is ava ilable,Sta rt_date /a dmission_d ate, | |
| 33 | 2,Select f ew of the claims and update th eir Receiv ed_date to be a NULL value,Cai ms with NU LL Admissi on_date ar e availabl e, | |
| 34 | 3,Run batc h rule pro cessing jo b using th e same bat ch ID as p revious st ep,Batch p rocessing job is com pleted, | |
| 35 | 4,Query th e RULE_OUT COME table ,Query re sults are displayed, | |
| 36 | 5,Verify t hat claim with no A dmission_d ate have " Admission_ date is bl ank, unabl e to valid ate timely filing" m essage dis played,Mes sage is di splayed, | |
| 37 | 6,Verify t hat the cl aims with NULL Admis sion_date are DENIED ,Claims ar e DENIED, | |
| 38 | 7,Verify t hat for th e claims t hat have m ore than 1 80 days ra nge betwee n Claim Ad mission_da te and Sta rt Date ha ve "Claim Admission_ date %s is greater t han allowe d range fr om Date of Service % s",Message is displa yed, | |
| 39 | 8,Verify t hat the cl aims of mo re than 18 0 days ran ge has a s tatus of D enied ,Cla ims have DENIED sta tus, | |
| 40 | 9,Verify t hat the cl aims are a nnotated w ith the CA RC/RARC ap propriate reason num ber,Claims are annot ated with the CARC/R ARC approp riate reas on, | |
| 41 | 10,Using a query loc ate claims with Star t Date is 180 days o n or befor e the Clai m Admissio n_date,Inv oices wit h First Da te of Serv ice of les s than 180 days from the Claim Admission _date are available, | |
| 42 | 11,Verify that claim s that are 180 days on or befo re the Cla im Admissi on_date ha ve APPROV ED status, Claim is i n APPROVED status, | |
| 43 | ||
| 44 | Test Case# ,Test Ca se # T est Script s# 154525 Sto ry CS010 Requir ement, | |
| 45 | ||
| 46 | TS4- CS010 - 593878 - Mature a nd Refacto ring busin ess Rules for Timely Filing - Pharmacy Claims,Pas s 12/11/20 17, | |
| 47 | Step numbe r,Descript ion,Expect ed results , | |
| 48 | 1,Query fo r a claim with Start Date of m ore than 1 80 days ov er the Cla im Date_of _Service b y using a query of a specific batch,Clai m line wit h Start Da te of more than 180 days over the Claim Date_of_Se rvice is a vailable,S tart Date /date_of_s ervice, | |
| 49 | 2,Select f ew of the claims and update th eir Servi ce date to be a NULL value,Cai ms with NU LL Date_of _Service a re availab le, | |
| 50 | 3,Run batc h rule pro cessing jo b using th e same bat ch ID as p revious st ep,Batch p rocessing job is com pleted, | |
| 51 | 4,Query th e RULE_OUT COME table ,Query re sults are displayed, | |
| 52 | 5,Verify t hat claim with no D ate_of_Ser vice have "Date_of_S ervice is blank, una ble to val idate time ly filing" message d isplayed,M essage is displayed, | |
| 53 | 6,Verify t hat the cl aims with NULL Date_ of_Service are DENIE D,Claims a re DENIED, | |
| 54 | 7,Verify t hat for th e claims t hat have m ore than 1 80 days ra nge betwee n Claim Da te_of_Serv ice and St art Date h ave "Claim Date_of_S ervice %s is greater than allo wed range from Date of Service %s",Messa ge is disp layed, | |
| 55 | 8,Verify t hat the cl aims of mo re than 18 0 days ran ge has a s tatus of D enied ,Cla ims have DENIED sta tus, | |
| 56 | 9,Verify t hat the cl aims are a nnotated w ith the CA RC/RARC ap propriate reason num ber,Claims are annot ated with the CARC/R ARC approp riate reas on, | |
| 57 | 10,Using a query loc ate claims with Star t Date is 180 days o n or befor e the Clai m Date_of_ Service,In voices wi th First D ate of Ser vice of le ss than 18 0 days fro m the Clai m Date_of_ Service ar e availabl e, | |
| 58 | 11,Verify that claim s that are 180 days on or befo re the Cla im Date_of _Service h ave APPRO VED status ,Claim is in APPROVE D status, | |
| 59 | TimelyFili ng:, | |
| 60 | Test Case# ,Test Ca se # T est Script s# 1545 26 Stor y CS010 Require ment, | |
| 61 | ||
| 62 | I’ll have to rework TimelyFili ng to chan ge Date of Service: , | |
| 63 | TS4- CS010 - 593878 - Mature a nd Refacto ring busin ess Rules for Timely Filing - Dental Cla ims,Instit utional – From Claim level DI M_INSTITUT IONAL_CLAI M.admissio n_date, | |
| 64 | Step numbe r,Descript ion,Expect ed results ,Professio nal – From Claim Lin e level F_ PROFESSION AL_MEDICAL _CLAIM_DET AILS.servi ce_date_fr om, | |
| 65 | 1,Query fo r a claim with Start Date of m ore than 1 80 days ov er the Cla im service _date by u sing a que ry of a sp ecific bat ch,Claim l ine with S tart Date of more th an 180 day s over the Claim ser vice_date is availab le,Start_d ate / serv ice_Date,D ental – Fr om Claim L ine level F_DENTAL_C LAIM_DETAI LS.service _date, | |
| 66 | 2,Select f ew of the claims and update th eir Servic e date to be a NULL value,Caim s with NUL L service_ date are a vailable,P harmacy – From Claim Line Leve l F_PHARMA CY_CLAIM_D ETAILS.dat e_of_servi ce, | |
| 67 | 3,Run batc h rule pro cessing jo b using th e same bat ch ID as p revious st ep,Batch p rocessing job is com pleted,Pro vider Paid field wil l be added back in. Team 1 not ed this ma y not be p opulated b y 837, so a discussi on is need ed to iden tify where this date will come from (per haps inter faces), | |
| 68 | 4,Query th e RULE_OUT COME table ,Query re sults are displayed, Claim Type can be de termined f rom DIM_VA _CLAIM.sou rce_entity , | |
| 69 | 5,Verify t hat claim with no s ervice_dat e have "se rvice_date is blank, unable to validate timely fil ing" messa ge display ed,Message is displa yed, | |
| 70 | 6,Verify t hat the cl aims with NULL servi ce_date ar e DENIED,C laims are DENIED,Add itional di scussion i s needed t o validate these fie ld changes with the VA (e.g.: is admissi on_date th e right fi eld for de termining timely fil ing for In situtition al?, | |
| 71 | 7,Verify t hat for th e claims t hat have m ore than 1 80 days ra nge betwee n Claim se rvice_date and Start Date have "Claim se rvice_date %s is gre ater than allowed ra nge from D ate of Ser vice %s",M essage is displayed, | |
| 72 | 8,Verify t hat the cl aims of mo re than 18 0 days ran ge has a s tatus of D enied ,Cla ims have DENIED sta tus, | |
| 73 | 9,Verify t hat the cl aims are a nnotated w ith the CA RC/RARC ap propriate reason num ber,Claims are annot ated with the CARC/R ARC approp riate reas on, | |
| 74 | 10,Using a query loc ate claims with Star t Date is 180 days o n or befor e the Clai m service_ date,Invoi ces with First Date of Servic e of less than 180 d ays from t he Claim s ervice_dat e are avai lable, | |
| 75 | 11,Verify that claim s that are 180 days on or befo re the Cla im service _date have APPROVED status,Cl aim is in APPROVED s tatus, | |
| 76 | ||
| 77 | Test Case# ,Test Ca se # T est Script s#154973 Stor y CS010 Require ment, | |
| 78 | ||
| 79 | ||
| 80 | SHEET: Tim ely Filing 30 days | |
| 81 | TC4- CS010 - 593878 Refactorin g business Rules for Timely Fi ling - 30 days / Cla im Line, | |
| 82 | ||
| 83 | Test objec tive:,Veri fy The CCN s must sen d the clai m to CCRS within 30 days after they have paid the provider,T o be Updat ed , | |
| 84 | Roles impa cted:,batc hIds,CCN1_ 837P_20121 107 , | |
| 85 | Test setup /Precondit ions:,Time ly Filing business r ule is com pleted. 30 days rang e claims are identi fied in th e database and setup to used f or this te st,Provide Paid Date / Start_ Date,CCN2_ 837P_20121 107, | |
| 86 | Requiremen t or Chang e,AA_20171 028_B, | |
| 87 | Acceptance criteria, Rule is im plemented - All type s of claim s are impa cted,CCN1_ NCPDP_2012 0912, | |
| 88 | CCN1_837D_ 20120914, | |
| 89 | Assumption s:, | |
| 90 | Test Case #,164814, | |
| 91 | TC4- CS010 - Verifi cation of Code busin ess Rules for Timely Filing - 30 days P rofessiona l Claim li ne, | |
| 92 | Step numbe r,Descript ion,Expect ed results ,select cl aim_id, d. claim_key, received_ date, d.da te_paid, d .etl_batch _id | |
| 93 | from DIM_V A_CLAIM c JOIN F_DEN TAL_CLAIM_ DETAILS d | |
| 94 | ON c. claim_key = d.claim_ key | |
| 95 | where d. date_paid is not NUL L, | |
| 96 | 1,Query fo r claims a nd claim l ines lines that are over the 3 0 days ran ge (Provid er has bee n paid mor e than 30 days befor e claim St art_Date). List cl aims & cla im lines., Claim line s with ran ge of more than 30 d ays are av ailable an d listed. Ran ge > 30 da ys,Out of range,F _p rofessiona l,query be fore run,s elect clai m_id, d.cl aim_key, e tl_batch_i d ,date_of _service,d ecision,ru le_name, o .message,o .rule_name ,o.rule_ou tcome_key, o.validati on_name | |
| 97 | from dim_v a_claim c | |
| 98 | join DECIS ION d on c .claim_key =d.claim_k ey | |
| 99 | join RULE_ OUTCOME o on d.decis ion_key=o. decision_k ey | |
| 100 | --where d. claim_key in (73,142 ,408,413,2 9,31,32,11 3), | |
| 101 | 2,Query fo r claims a nd claim l ines lines that on t he range o f 30 days range (Pro vider has been paid 30 days be fore claim Start_Dat e). List claims & claim line s.,Claim l ines with range equa l to 30 da ys are ava ilable and listed. Range = 3 0 days,on range, | |
| 102 | 3,Query fo r claims a nd claim l ines lines that have less than 30 days r ange (Prov ider has b een paid l ess than 3 0 days bef ore claim Start_Date ). List claims & c laim lines .,Claim li nes with r ange of le ss than 30 days are available and listed . Rang e < 30 day s,within r ange, | |
| 103 | 4,Query fo r claims a nd claim l ines lines that have 0 days ra nge (Provi der has be en paid sa me day as claims Sta rt_Date). List cla ims & clai m lines.,C laim lines with rang e is 0 day are avail able and l isted. Range = 0 day, 0 range, | |
| 104 | 5,Run batc h rule pro cessing jo b using th e same bat ch ID as p revious st ep,Batch p rocessing job is com pleted, | |
| 105 | 6,Query th e DECISION table ,Qu ery result s are disp layed, | |
| 106 | 7,Verify t hat claim lines with Range > 3 0 days hav e a messag e displaye d that cit es % of da ys are mor e than 30 days,Messa ge is disp layed, | |
| 107 | 8,Verify t hat the cl aim lines that have a range > 30 days ar e REJECTED ,Claim lin es are REJ ECTED, | |
| 108 | 9,Verify t hat the RE JECTED cla im lines a re annotat ed with th e CARC/RAR C appropri ate reason number (2 9),Claims are annota ted with t he CARC/RA RC appropr iate reaso n, | |
| 109 | 10,Verify that claim lines wit h Range = 30 days ha ve a messa ge display ed that ci tes % of d ays are mo re than 30 days,Mess age is dis played, | |
| 110 | 11,Verify that claim lines wit h Range = 30 days ar e ACCEPTED ,Claim lin es are ACC EPTED, | |
| 111 | 12,Verify that claim lines wit h Range < 30 days ar e ACCEPTED ,Claim lin es are ACC EPTED, | |
| 112 | 13,Verify that claim lines wit h Range 0 days are A CCEPTED,Cl aim lines are ACCEPT ED, | |
| 113 | 14,Verify that the c laim lines with NULL Start_Dat e have a m essage tha t cites RE CEIVED Da te is NULL ,Claims ar e DENIED o r REJECTED , | |
| 114 | 15,Verify that the c laim lines with NULL Paid Date have a me ssage that cites Pai d Date is NULL,Claim s are DENI ED or REJE CTED, | |
| 115 | ||
| 116 | Test Case# ,Test Ca se # T est Script s# 15485 0 Story CS 010 R equirement , | |
| 117 | ||
| 118 | TC4- CS010 -Verifi cation of Code busin ess Rules for Timely Filing - 30 days - Institutio nal Claim lines, | |
| 119 | Step numbe r,Descript ion,Expect ed results , | |
| 120 | 1,Query fo r claims a nd claim l ines lines that are over the 3 0 days ran ge (Provid er has bee n paid mor e than 30 days befor e claim St art_Date). List cl aims & cla im lines., Claim line s with ran ge of more than 30 d ays are av ailable an d listed. Ran ge > 30 da ys,Out of range,f_in titu, | |
| 121 | 2,Query fo r claims a nd claim l ines lines that on t he range o f 30 days range (Pro vider has been paid 30 days be fore claim Start_Dat e). List claims & claim line s.,Claim l ines with range equa l to 30 da ys are ava ilable and listed. Range = 3 0 days,on range, | |
| 122 | 3,Query fo r claims a nd claim l ines lines that have less than 30 days r ange (Prov ider has b een paid l ess than 3 0 days bef ore claim Start_Date ). List claims & c laim lines .,Claim li nes with r ange of le ss than 30 days are available and listed . Rang e < 30 day s,within r ange, | |
| 123 | 4,Query fo r claims a nd claim l ines lines that have 0 days ra nge (Provi der has be en paid sa me day as claims Sta rt_Date). List cla ims & clai m lines.,C laim lines with rang e is 0 day are avail able and l isted. Range = 0 day, 0 range, | |
| 124 | 5,Run batc h rule pro cessing jo b using th e same bat ch ID as p revious st ep,Batch p rocessing job is com pleted, | |
| 125 | 6,Query th e DECISION table ,Qu ery result s are disp layed, | |
| 126 | 7,Verify t hat claim lines with Range > 3 0 days hav e a messag e displaye d that cit es % of da ys are mor e than 30 days,Messa ge is disp layed, | |
| 127 | 8,Verify t hat the cl aim lines that have a range > 30 days ar e REJECTED ,Claim lin es are REJ ECTED, | |
| 128 | 9,Verify t hat the RE JECTED cla im lines a re annotat ed with th e CARC/RAR C appropri ate reason number (2 9),Claims are annota ted with t he CARC/RA RC appropr iate reaso n, | |
| 129 | 10,Verify that claim lines wit h Range = 30 days ha ve a messa ge display ed that ci tes % of d ays are mo re than 30 days,Mess age is dis played, | |
| 130 | 11,Verify that claim lines wit h Range = 30 days ar e ACCEPTED ,Claim lin es are ACC EPTED, | |
| 131 | 12,Verify that claim lines wit h Range < 30 days ar e ACCEPTED ,Claim lin es are ACC EPTED, | |
| 132 | 13,Verify that claim lines wit h Range 0 days are A CCEPTED,Cl aim lines are ACCEPT ED, | |
| 133 | 14,Verify that the c laim lines with NULL Start_Dat e have a m essage tha t cites RE CEIVED Da te is NULL ,Claims ar e DENIED o r REJECTED , | |
| 134 | 15,Verify that the c laim lines with NULL Paid Date have a me ssage that cites Pai d Date is NULL,Claim s are DENI ED or REJE CTED, | |
| 135 | ||
| 136 | Test Case# ,Test Ca se # T est Script s# 15486 0 Sto ry CS010 Requir ement, | |
| 137 | ||
| 138 | TC4- CS010 - Verific ation of C ode busine ss Rules f or Timely Filing - 3 0 days -Ph armacy Cla ims, | |
| 139 | Step numbe r,Descript ion,Expect ed results , | |
| 140 | 1,Query fo r claims a nd claim l ines lines that are over the 3 0 days ran ge (Provid er has bee n paid mor e than 30 days befor e claim St art_Date). List cl aims & cla im lines., Claim line s with ran ge of more than 30 d ays are av ailable an d listed. Ran ge > 30 da ys,Out of range,F_ph arma, | |
| 141 | 2,Query fo r claims a nd claim l ines lines that on t he range o f 30 days range (Pro vider has been paid 30 days be fore claim Start_Dat e). List claims & claim line s.,Claim l ines with range equa l to 30 da ys are ava ilable and listed. Range = 3 0 days,on range, | |
| 142 | 3,Query fo r claims a nd claim l ines lines that have less than 30 days r ange (Prov ider has b een paid l ess than 3 0 days bef ore claim Start_Date ). List claims & c laim lines .,Claim li nes with r ange of le ss than 30 days are available and listed . Rang e < 30 day s,within r ange, | |
| 143 | 4,Query fo r claims a nd claim l ines lines that have 0 days ra nge (Provi der has be en paid sa me day as claims Sta rt_Date). List cla ims & clai m lines.,C laim lines with rang e is 0 day are avail able and l isted. Range = 0 day, 0 range, | |
| 144 | 5,Run batc h rule pro cessing jo b using th e same bat ch ID as p revious st ep,Batch p rocessing job is com pleted, | |
| 145 | 6,Query th e DECISION table ,Qu ery result s are disp layed, | |
| 146 | 7,Verify t hat claim lines with Range > 3 0 days hav e a messag e displaye d that cit es % of da ys are mor e than 30 days,Messa ge is disp layed, | |
| 147 | 8,Verify t hat the cl aim lines that have a range > 30 days ar e REJECTED ,Claim lin es are REJ ECTED, | |
| 148 | 9,Verify t hat the RE JECTED cla im lines a re annotat ed with th e CARC/RAR C appropri ate reason number (2 9),Claims are annota ted with t he CARC/RA RC appropr iate reaso n, | |
| 149 | 10,Verify that claim lines wit h Range = 30 days ha ve a messa ge display ed that ci tes % of d ays are mo re than 30 days,Mess age is dis played, | |
| 150 | 11,Verify that claim lines wit h Range = 30 days ar e ACCEPTED ,Claim lin es are ACC EPTED, | |
| 151 | 12,Verify that claim lines wit h Range < 30 days ar e ACCEPTED ,Claim lin es are ACC EPTED, | |
| 152 | 13,Verify that claim lines wit h Range 0 days are A CCEPTED,Cl aim lines are ACCEPT ED, | |
| 153 | 14,Verify that the c laim lines with NULL Start_Dat e have a m essage tha t cites RE CEIVED Da te is NULL ,Claims ar e DENIED o r REJECTED , | |
| 154 | 15,Verify that the c laim lines with NULL Paid Date have a me ssage that cites Pai d Date is NULL,Claim s are DENI ED or REJE CTED, | |
| 155 | ||
| 156 | ||
| 157 | Test Case# ,Test Ca se # T est Script s# 15487 7 Stor y CS010 Require ment, | |
| 158 | ||
| 159 | TC4- CS010 - Verific ation of C ode busine ss Rules f or Timely Filing - 3 0 days -De ntal Claim s, | |
| 160 | Step numbe r,Descript ion,Expect ed results , | |
| 161 | 1,Query fo r claims a nd claim l ines lines that are over the 3 0 days ran ge (Provid er has bee n paid mor e than 30 days befor e claim St art_Date). List cl aims & cla im lines., Claim line s with ran ge of more than 30 d ays are av ailable an d listed. Ran ge > 30 da ys,Out of range,F_de ntal, | |
| 162 | 2,Query fo r claims a nd claim l ines lines that on t he range o f 30 days range (Pro vider has been paid 30 days be fore claim Start_Dat e). List claims & claim line s.,Claim l ines with range equa l to 30 da ys are ava ilable and listed. Range = 3 0 days,on range, | |
| 163 | 3,Query fo r claims a nd claim l ines lines that have less than 30 days r ange (Prov ider has b een paid l ess than 3 0 days bef ore claim Start_Date ). List claims & c laim lines .,Claim li nes with r ange of le ss than 30 days are available and listed . Rang e < 30 day s,within r ange, | |
| 164 | 4,Query fo r claims a nd claim l ines lines that have 0 days ra nge (Provi der has be en paid sa me day as claims Sta rt_Date). List cla ims & clai m lines.,C laim lines with rang e is 0 day are avail able and l isted. Range = 0 day, 0 range, | |
| 165 | 5,Run batc h rule pro cessing jo b using th e same bat ch ID as p revious st ep,Batch p rocessing job is com pleted, | |
| 166 | 6,Query th e DECISION table ,Qu ery result s are disp layed, | |
| 167 | 7,Verify t hat claim lines with Range > 3 0 days hav e a messag e displaye d that cit es % of da ys are mor e than 30 days,Messa ge is disp layed, | |
| 168 | 8,Verify t hat the cl aim lines that have a range > 30 days ar e REJECTED ,Claim lin es are REJ ECTED, | |
| 169 | 9,Verify t hat the RE JECTED cla im lines a re annotat ed with th e CARC/RAR C appropri ate reason number (2 9),Claims are annota ted with t he CARC/RA RC appropr iate reaso n, | |
| 170 | 10,Verify that claim lines wit h Range = 30 days ha ve a messa ge display ed that ci tes % of d ays are mo re than 30 days,Mess age is dis played, | |
| 171 | 11,Verify that claim lines wit h Range = 30 days ar e ACCEPTED ,Claim lin es are ACC EPTED, | |
| 172 | 12,Verify that claim lines wit h Range < 30 days ar e ACCEPTED ,Claim lin es are ACC EPTED, | |
| 173 | 13,Verify that claim lines wit h Range 0 days are A CCEPTED,Cl aim lines are ACCEPT ED, | |
| 174 | 14,Verify that the c laim lines with NULL Start_Dat e have a m essage tha t cites RE CEIVED Da te is NULL ,Claims ar e DENIED o r REJECTED , | |
| 175 | 15,Verify that the c laim lines with NULL Paid Date have a me ssage that cites Pai d Date is NULL,Claim s are DENI ED or REJE CTED, | |
| 176 | ||
| 177 | Test Case# ,Test Ca se # T est Script s# 1548 78 Stor y CS010 Require ment, | |
| 178 | ||
| 179 | ||
| 180 | SHEET: She et6 | |
| 181 | Profession al:, | |
| 182 | timely fil ing,thrsho ld,referra l,flushot, duplicates ,select d. claim_key, f.claim_d etail_key, d.etl_bat ch_id, d.r eferral_nu mber, f.ch arge_amoun t, f.date_ paid, f.se rvice_date _from, f.s tart_date , | |
| 183 | from F_PRO FESSIONAL_ MEDICAL_CL AIM_DETAIL S F, | |
| 184 | claim_key, claim_deta il_key,etl _batch_id, referral_n umber,char ge_amount, date_paid, service_da te_from,st art_date, join DIM_V A_CLAIM d, | |
| 185 | 1202,891,D L_837P_201 71126_6,re f14,94,11/ 30/17,1/1/ 10,2017-11 -26, on f. claim_key = d.claim_ key, | |
| 186 | 1203,894,D L_837P_201 71126_6,re f14,28,11/ 30/17,5/30 /17,2017-1 1-26, wher e d.referr al_number like 'ref% %', | |
| 187 | 1204,892,D L_837P_201 71126_6,re f14,10,11/ 30/17,1/3/ 12,2017-11 -26, and d .etl_batch _id = 'DL _837P_2017 1126_6', | |
| 188 | 1204,893,D L_837P_201 71126_6,re f14,110,11 /30/17,9/3 0/17,2017- 11-26, | |
| 189 | 1206,895,D L_837P_201 71126_6,re f14,27,11/ 30/17,9/30 /17,2017-1 1-26, | |
| 190 | 1207,898,D L_837P_201 71126_6,re f14,94,11/ 30/17,8/8/ 12,2017-11 -26, | |
| 191 | 1208,903,D L_837P_201 71126_6,re f14,94,11/ 30/17,1/8/ 12,2017-11 -26, | |
| 192 | 1209,899,D L_837P_201 71126_6,re f14,94,10/ 27/17,7/7/ 10,2017-11 -26, | |
| 193 | 1209,900,D L_837P_201 71126_6,re f14,94,10/ 27/17,1/1/ 11,2017-11 -26, | |
| 194 | 1209,901,D L_837P_201 71126_6,re f14,94,9/2 7/17,1/2/1 2,2017-11- 26, | |
| 195 | 1209,902,D L_837P_201 71126_6,re f14,94,9/2 7/17,1/3/1 3,2017-11- 26, | |
| 196 | 1210,904,D L_837P_201 71126_6,re f14,10,11/ 30/17,1/9/ 12,2017-11 -26, | |
| 197 | 1211,911,D L_837P_201 71126_6,re f14,0,11/3 0/17,12/12 /12,2017-1 1-26, | |
| 198 | 1211,912,D L_837P_201 71126_6,re f14,29000, 11/30/17,1 /1/13,2017 -11-26, | |
| 199 | 1211,913,D L_837P_201 71126_6,re f14,30000, 11/30/17,1 /5/14,2017 -11-26, | |
| 200 | 1211,914,D L_837P_201 71126_6,re f14,94,11/ 30/17,1/5/ 15,2017-11 -26, | |
| 201 | 1213,915,D L_837P_201 71126_6,re f13,30001, 11/30/17,1 /5/13,2017 -11-26, | |
| 202 | 1214,910,D L_837P_201 71126_6,re f14,28,11/ 30/17,1/11 /12,2017-1 1-26, | |
| 203 | 1215,916,D L_837P_201 71126_6,re f15,94,11/ 30/17,4/14 /12,2017-1 1-26, | |
| 204 | 1215,917,D L_837P_201 71126_6,re f15,29999, 11/30/17,1 /14/12,201 7-11-26, | |
| 205 | 1215,918,D L_837P_201 71126_6,re f15,30002, 11/30/17,1 /5/13,2017 -11-26, | |
| 206 | 1215,919,D L_837P_201 71126_6,re f15,35002, 11/30/17,1 /5/14,2017 -11-26, | |
| 207 | 1215,920,D L_837P_201 71126_6,re f15,94,11/ 30/17,1/5/ 11,2017-11 -26, | |
| 208 | 1215,921,D L_837P_201 71126_6,re f15,94,11/ 30/17,1/5/ 13,2017-11 -26, | |
| 209 | 1217,923,D L_837P_201 71126_6,re f14,100002 ,11/30/17, 6/16/16,20 17-11-26, | |
| 210 | 1218,929,D L_837P_201 71126_6,re f14,28,11/ 30/17,2/3/ 12,2017-11 -26, | |
| 211 | 1219,924,D L_837P_201 71126_6,re f14,94,11/ 30/17,2/2/ 12,2017-11 -26, | |
| 212 | 1220,931,D L_837P_201 71126_6,re f14,94,11/ 30/17,3/1/ 13,2017-11 -26, | |
| 213 | 1221,925,D L_837P_201 71126_6,re f14,94,11/ 30/17,3/1/ 13,2017-11 -26, | |
| 214 | 1222,934,D L_837P_201 71126_6,re f14,10,10/ 27/17,1/12 /08,2017-1 1-26, | |
| 215 | 1222,935,D L_837P_201 71126_6,re f14,110,10 /27/17,3/4 /08,2017-1 1-26, | |
| 216 | 1223,926,D L_837P_201 71126_6,re f14,10,11/ 30/17,3/1/ 13,2017-11 -26, | |
| 217 | 1223,927,D L_837P_201 71126_6,re f14,110,11 /30/17,2/3 /12,2017-1 1-26, | |
| 218 | 1224,936,D L_837P_201 71126_6,re f13,94,10/ 27/17,3/5/ 15,2017-11 -26, | |
| 219 | 1225,928,D L_837P_201 71126_6,re f16,28,11/ 30/17,2/3/ 12,2017-11 -26, | |
| 220 | 1226,943,D L_837P_201 71126_6,RE Fbad,94,9/ 27/17,1/1/ 10,2017-11 -26, | |
| 221 | 1227,930,D L_837P_201 71126_6,re f12,0,11/3 0/17,2/2/1 2,2017-11- 26, | |
| 222 | 1228,944,D L_837P_201 71126_6,re f14,94,9/2 7/17,10/1/ 10,2017-11 -26, | |
| 223 | 1229,932,D L_837P_201 71126_6,re f12,94,11/ 30/17,3/2/ 11,2017-11 -26, | |
| 224 | 1230,933,D L_837P_201 71126_6,re f17,94,11/ 30/17,3/1/ 13,2017-11 -26, | |
| 225 | 1231,937,D L_837P_201 71126_6,re fbad,28,10 /27/17,3/6 /11,2017-1 1-26, | |
| 226 | 1231,938,D L_837P_201 71126_6,re fbad,94,10 /27/17,1/1 /12,2017-1 1-26, | |
| 227 | 1231,939,D L_837P_201 71126_6,re fbad,94,10 /27/17,1/5 /13,2017-1 1-26,Start _date (eff ective) da te of the record, | |
| 228 | 1231,940,D L_837P_201 71126_6,re fbad,94,10 /27/17,4/5 /14,2017-1 1-26, | |
| 229 | 1231,941,D L_837P_201 71126_6,re fbad,94,10 /27/17,5/1 /15,2017-1 1-26,Servi ce_date_fr om Start d ate of ser vices rend ered, | |
| 230 | 1231,942,D L_837P_201 71126_6,re fbad,94,9/ 27/17,2016 -06-05,11/ 26/17, | |
| 231 | 471,2017-1 1-07,2017- 10-21 < 18 0, | |
| 232 | 180 days,4 73,2017-11 -07,2017-0 4-11 >180, | |
| 233 | DL_837P_20 171030_1,4 74,NULL,9/ 29/17, | |
| 234 | ||
| 235 | ||
| 236 | Prof.,Clai m Key,Clai m ID,End d ate,Paid D ate, | |
| 237 | 472,8/17/1 7,2017-09- 10, | |
| 238 | 30 days,47 5,8/17/17, 2017-11-01 , | |
| 239 | 476,8/17/1 7,2017-09- 16, | |
| 240 | Ins,Claim Key,Claim ID,Admissi on date,en d date, | |
| 241 | 1310,9/29/ 17,NULL, | |
| 242 | 1311,2017- 05-11 =180 ,2017-11-0 7, | |
| 243 | 1312,2017- 10-21 < 18 0,2017-11- 07, | |
| 244 | 180 days,1 313,2017-0 4-11 >180, 2017-11-07 , | |
| 245 | Select dis tinct d.cl aim_key, d .claim_det ail_key , d.etl_batc h_id, v.is _passed,v. rule_name, v.validati on_name,v. message, v .last_upda ted_Date_t ime, | |
| 246 | from DECIS ION D, | |
| 247 | Claim Key, Claim ID,A dmission d ate,Date p aid,inner join valid ation_fail ure V, | |
| 248 | Ins,on v.d ecision_ke y = d.deci sion_key, | |
| 249 | 1314,8/17/ 17,2017-09 -10,--wher e v.is_pas sed ='1', | |
| 250 | 1315,8/17/ 17,2017-11 -01,and d. etl_batch_ id = 'DL_8 37P_201711 26_6', | |
| 251 | 30 days,13 16,8/17/17 ,2017-09-1 6,--and cl aim_detail _key = '94 6', | |
| 252 | order by c laim_detai l_key, | |
| 253 | Claim Key, | |
| 254 | Claim ID,E nd date,Se rvice date , | |
| 255 | 9/29/17,NU LL, | |
| 256 | 2017-05-11 =180,2017 -11-07, | |
| 257 | Dent,2017- 10-21 < 18 0,2017-11- 07, | |
| 258 | 2017-09-21 < 180,201 7-11-07, | |
| 259 | 2017-04-11 >180,2017 -11-07, | |
| 260 | 2016-05-11 > 180,201 7-11-07, | |
| 261 | Claim Key, | |
| 262 | Claim ID,E nd date,Da te of serv ice, | |
| 263 | 9/29/17,NU LL, | |
| 264 | 2017-05-11 =180,2017 -11-07, | |
| 265 | Dental,201 7-10-21 < 180,2017-1 1-07, | |
| 266 | 2017-09-21 < 180,201 7-11-07, | |
| 267 | 2017-04-11 >180,2017 -11-07, | |
| 268 | 30 days,20 16-05-11 > 180,2017- 11-07, | |
| 269 | Pharma, | |
| 270 | Pharma, | |
| 271 | 30 days, | |
| 272 | ||
| 273 | ||
| 274 | SHEET: She et2 | |
| 275 | Institutio nal,edi_38 7I_2017120 1, | |
| 276 | claim_key, claim_deta il_key,etl _batch_id, date_paid, charge_amo unt,servic e_date,adm ission_dat e,start_da te, | |
| 277 | 490,221,CC N1_837I_20 171031,NUL L,73.42,1/ 3/16,10/10 /17,10/31/ 17,< 180,s ervice dat e,may 4 20 17, | |
| 278 | 490,231,CC N1_837I_20 171031,NUL L,76.54,1/ 8/16,9/10/ 17,10/31/1 7,<180, | |
| 279 | 491,218,CC N1_837I_20 171031,NUL L,73.42,1/ 3/16,5/4/1 7,10/31/17 ,equal 180 ,service d ate, | |
| 280 | 491,224,CC N1_837I_20 171031,NUL L,76.54,1/ 8/16,3/4/1 7,10/31/17 ,NULL, | |
| 281 | 492,223,CC N1_837I_20 171031,NUL L,73.42,1/ 3/17,NULL, 10/31/17, | |
| 282 | 492,233,CC N1_837I_20 171031,9/1 /17,76.54, 1/1/17,9/1 /17,10/31/ 17,>30,pai d date,Oct ober 1, 20 17., | |
| 283 | 493,232,CC N1_837I_20 171031,9/1 5/17,76.54 ,NULL,9/15 /17,10/31/ 17,<30, | |
| 284 | 493,222,CC N1_837I_20 171031,10/ 1/17,73.42 ,1/6/16,10 /1/17,10/3 1/17,equal 30, | |
| 285 | 494,225,CC N1_837I_20 171031,3/4 /17,178.9, 1/1/11,3/4 /17,10/31/ 17,Null pa id date, | |
| 286 | 495,226,CC N1_837I_20 171031, NULL,1 78.9,1/1/1 0,3/4/17,1 0/31/17, | |
| 287 | 496,219,CC N1_837I_20 171031,NUL L,178.9,1/ 1/12,3/4/1 7,10/31/17 ,ref, | |
| 288 | 497,227,CC N1_837I_20 171031,NUL L,178.9,1/ 1/12,3/4/1 7,10/31/17 , | |
| 289 | 498,228,CC N1_837I_20 171031,NUL L,178.9,1/ 1/11,3/4/1 7,10/31/17 ,flushts, | |
| 290 | 499,229,CC N1_837I_20 171031,NUL L,555.55,1 /1/16,3/4/ 17,10/31/1 7, | |
| 291 | 500,230,CC N1_837I_20 171031,NUL L,662.22,1 /2/16,5/4/ 17,10/31/1 7,rejected 30 days a go, | |
| 292 | 500,220,CC N1_837I_20 171031,NUL L,661.66,1 /2/16,5/4/ 17,10/31/1 7, | |
| 293 | dups, | |
| 294 | ||
| 295 | ||
| 296 | SHEET: Tim ely filing notes | |
| 297 | ||
| 298 | ØBLANK_REC EIVED_DATE à , | |
| 299 | "Received date is bl ank, unabl e to valid ate timely filing“ , | |
| 300 | à Claim is DENIED, | |
| 301 | ØTIMELY_DA TE (Date o f service or End dat e) (Condit ion #1) à >= 180 days, | |
| 302 | "Claim Rec eived Date %s is gre ater than allowed ra nge from D ate of Ser vice %s“ , | |
| 303 | à Claim is D ENIED, | |
| 304 | ØCLAIMS (g ood not NU LL dates) < 180 da ys à A PPROVED, | |
| 305 | 4 scenario s - Profess ional clai ms Using End date and claim received d ate,receiv ed date ch anged to s ervicedate from, | |
| 306 | Using Date of Servic e & blank Received d ate | |
| 307 | 2) Receive d date Mi nus End d ate = 180 days | |
| 308 | 3) Receive d date --- En d Date < 180 days | |
| 309 | 4) Receive d date --- En d date > 180 day, | |
| 310 | Timely Fil ing 180,$$ threshol d,Referral /Date of service, | |
| 311 | •Run rule batch job, 11/27/2017 test ,end date re ceived dat e,service date from, | |
| 312 | http:// IP : PORT /brengine/ processBat ch?batch_i d=CCN4_837 P_20121107 ,professio nal, | |
| 313 | http:// IP : PORT /logs/ccrs -brengine. log, | |
| 314 | DL_837P_20 171030_1, | |
| 315 | 470,471,41 7, | |
| 316 | ||
| 317 | Select dis tinct d.cl aim_key, d .claim_det ail_key , d.etl_batc h_id, v.is _passed,v. rule_name, v.validati on_name,v. message, v .last_upda ted_Date_t ime, | |
| 318 | from DECIS ION D, | |
| 319 | inner join validatio n_failure V,institut ional, | |
| 320 | on v.decis ion_key = d.decision _key,CCN1_ 837I_20171 031, | |
| 321 | --where v. is_passed ='1', | |
| 322 | and d.etl_ batch_id = 'DL_837P_ 20171126_6 ',Dental, | |
| 323 | --and clai m_detail_k ey = '946' ,DL_837D_2 0171102_2, | |
| 324 | order by c laim_detai l_key, | |
| 325 | Select * f rom valida tion_failu re, | |
| 326 | order by l ast_update d_date_tim e desc , | |
| 327 | timely fil ing 30 day s, | |
| 328 | Select * f rom decisi on, | |
| 329 | order by l ast_update d_date_tim e desc, | |
| 330 | CCN4_837P_ 20121107, | |
| 331 | Select * f rom decisi on, | |
| 332 | order by c laim_key , | |
| 333 | service da te, | |
| 334 | ||
| 335 | ||
| 336 | SHEET: $$ Threshold | |
| 337 | TC4 - CS01 0 - 628 449 - Ma ture dolla r threshol d business rule sets for all I nvoice typ es, | |
| 338 | ||
| 339 | Test objec tive:,Vali date that Claim line s that exc eed $30,00 0 are flag ged for au dit (PENDI NG_REVIEW) , | |
| 340 | Roles impa cted:, | |
| 341 | Test setup /Precondit ions:,Data is availa ble for te sting. D atabase wi th all tab les and co lumns, | |
| 342 | Requiremen t or Chang e,S4-CS010 , | |
| 343 | Acceptance criteria, Claim line s that exc eed $30,00 0 are flag ged for au dit (PENDI NG_REVIEW) , | |
| 344 | ||
| 345 | Assumption s:,This ru le will be ran with other rule s to check the valid ity of all incoming claims, | |
| 346 | Test Case# ,166900, | |
| 347 | ||
| 348 | TS4 - CS01 0 - 628 449 - Ma ture dolla r threshol d business rule sets for all I nvoice typ es - Profe ssional, | |
| 349 | Action Ite ms:,Descri ption,Expe cted Resul ts,Notes, | |
| 350 | 1,Using S QL query s elect clai ms that ar e more tha n $30.000 | |
| 351 | List the c laims and their Batc h ID,$30,0 00 Claims areselecte d,select e tl_batch_i d, claim_k ey, etl_ba tch_id , s tart_date, end_date, Total_Cha rges | |
| 352 | from DIM_ PROFESSION AL_CLAIM w here etl_b atch_id = 'CCN1_837P _20121107' | |
| 353 | and Total _Charges > = '30,000' | |
| 354 | , | |
| 355 | 2,Query th e decision table and make sure that the selected c laims are not listed in the ta ble,Claims are not l isted,Add Claim line s, | |
| 356 | 3,Run the rule engin e batch jo b using th e SQA link provided for the te st,Rule is ran and c ompleted, | |
| 357 | 4,Verify t hat the cl aims above (> $30,00 0) are fla gged as "P ending For Review",C laims are flagged as "Pending For Review ", | |
| 358 | 5,Verify t hat claims will be h eld for 48 hours,Cla ims are he ld for 48 hrs, | |
| 359 | 6,Verify t hat after the 48 hrs the claim s are eith er back in to workflo w or Rejec ted,Claims are eithe r back int o workflow or Reject ed, | |
| 360 | ||
| 361 | Test Case# ,Test Ca se # T est Script s# 1564 89 S tory CS010 Requi rement, | |
| 362 | ||
| 363 | ||
| 364 | TS4 - CS01 0 - 628 449 - Ma ture dolla r threshol d business rule sets for all I nvoice typ es - Insti tutional, | |
| 365 | Action Ite ms:,Descri ption,Expe cted Resul ts,Notes, | |
| 366 | 1,Using S QL query s elect clai ms that ar e more tha n $30.000 | |
| 367 | List the c laims and their Batc h ID,$30,0 00 Claims areselecte d, | |
| 368 | 2,Query th e decision table and make sure that the selected c laims are not listed in the ta ble,Claims are not l isted, | |
| 369 | 3,Run the rule engin e batch jo b using th e SQA link provided for the te st,Rule is ran and c ompleted, | |
| 370 | 4,Verify t hat the cl aims above (> $30,00 0) are fla gged as "P ending For Review",C laims are flagged as "Pending For Review ", | |
| 371 | 5,Verify t hat claims will be h eld for 48 hours,Cla ims are he ld for 48 hrs, | |
| 372 | 6,Verify t hat after the 48 hrs the claim s are eith er back in to workflo w or Rejec ted,Claims are eithe r back int o workflow or Reject ed, | |
| 373 | ||
| 374 | Test Case# ,Test Ca se # T est Script s# 15649 1 S tory CS010 Requi rement, | |
| 375 | ||
| 376 | ||
| 377 | TS4 - CS01 0 - 628 449 - Ma ture dolla r threshol d business rule sets for all I nvoice typ es - Denta l, | |
| 378 | Action Ite ms:,Descri ption,Expe cted Resul ts,Notes, | |
| 379 | 1,Using S QL query s elect clai ms that ar e more tha n $30.000 | |
| 380 | List the c laims and their Batc h ID,$30,0 00 Claims areselecte d, | |
| 381 | 2,Query th e decision table and make sure that the selected c laims are not listed in the ta ble,Claims are not l isted, | |
| 382 | 3,Run the rule engin e batch jo b using th e SQA link provided for the te st,Rule is ran and c ompleted, | |
| 383 | 4,Verify t hat the cl aims above (> $30,00 0) are fla gged as "P ending For Review",C laims are flagged as "Pending For Review ", | |
| 384 | 5,Verify t hat claims will be h eld for 48 hours,Cla ims are he ld for 48 hrs, | |
| 385 | 6,Verify t hat after the 48 hrs the claim s are eith er back in to workflo w or Rejec ted,Claims are eithe r back int o workflow or Reject ed, | |
| 386 | ||
| 387 | Test Case# ,Test Ca se # T est Script s# 156 492 S tory CS010 Requi rement, | |
| 388 | ||
| 389 | ||
| 390 | TS4 - CS01 0 - 628 449 - Ma ture dolla r threshol d business rule sets for all I nvoice typ es - Pharm acy, | |
| 391 | Action Ite ms:,Descri ption,Expe cted Resul ts,Notes, | |
| 392 | 1,Using S QL query s elect clai ms that ar e more tha n $30.000 | |
| 393 | List the c laims and their Batc h ID,$30,0 00 Claims areselecte d, | |
| 394 | 2,Query th e decision table and make sure that the selected c laims are not listed in the ta ble,Claims are not l isted, | |
| 395 | 3,Run the rule engin e batch jo b using th e SQA link provided for the te st,Rule is ran and c ompleted, | |
| 396 | 4,Verify t hat the cl aims above (> $30,00 0) are fla gged as "P ending For Review",C laims are flagged as "Pending For Review ", | |
| 397 | 5,Verify t hat claims will be h eld for 48 hours,Cla ims are he ld for 48 hrs, | |
| 398 | 6,Verify t hat after the 48 hrs the claim s are eith er back in to workflo w or Rejec ted,Claims are eithe r back int o workflow or Reject ed, | |
| 399 | ||
| 400 | Test Case# ,Test Ca se # T est Script s# 15 6493 S tory CS010 Requi rement, | |
| 401 | ||
| 402 | ||
| 403 | SHEET: $$ data | |
| 404 | ||
| 405 | 63,30185,C CN1_837P_2 0121107,cl aim_detail _key,claim _key,servi ce_date,ch arge_amt,e tl_batch_i d,is_curre nt,start_d ate, | |
| 406 | 65,30194,C CN1_837P_2 0121107,1, 42,1/3/17, 30178.9,CC N1_837I_20 121002,Y,9 /28/17, | |
| 407 | 69,30004,C CN1_837P_2 0121107,$$ treshold P rofessiona l,5,58,3/3 /17,30049. 92,CCN1_83 7I_2012100 2,Y,9/28/1 7, | |
| 408 | 72,30120,C CN1_837P_2 0121107,7, 58,9/3/17, 30210,CCN1 _837I_2012 1002,Y,9/2 8/17, | |
| 409 | 75,30094,C CN1_837P_2 0121107,10 ,53,9/16/1 7,30206.8, CCN1_837I_ 20121002,Y ,9/28/17, | |
| 410 | 83,32000,C CN1_837P_2 0121107,13 ,57,10/30/ 17,30960.5 ,CCN1_837I _20121002, Y,9/28/17, | |
| 411 | 15,57,10/3 0/17,55435 ,CCN1_837I _20121002, Y,9/28/17, | |
| 412 | claim_key, etl_batch_ id,patient _discharge _status,ad mission_da te,Total_C harges,18, 57,11/1/17 ,31685,CCN 1_837I_201 21002,Y,9/ 28/17, | |
| 413 | 39,CCN1_83 7I_2012100 2,1,NULL,3 2000,20,57 ,9/30/17,3 3324,CCN1_ 837I_20121 002,Y,9/28 /17, | |
| 414 | 42,CCN1_83 7I_2012100 2,1,NULL,3 0001,$$thr es. Insti ,Instituti onal for $ $thresh, | |
| 415 | 43,CCN1_83 7I_2012100 2,1,NULL,3 0000.501,i npatient, | |
| 416 | 44,CCN1_83 7I_2012100 2,1,NULL,6 5000, | |
| 417 | 45,CCN1_83 7I_2012100 2,1,NULL,1 10000, | |
| 418 | 47,CCN1_83 7I_2012100 2,1,NULL,6 5000, | |
| 419 | 49,CCN1_83 7I_2012100 2,1,NULL,5 5000,Selec t distinct d.claim_k ey, d.clai m_detail_k ey , d.etl _batch_id, v.is_pass ed,v.rule_ name,v.val idation_na me,v.messa ge, v.last _updated_D ate_time, | |
| 420 | 51,CCN1_83 7I_2012100 2,1,NULL,5 5555,from DECISION D , | |
| 421 | 53,CCN1_83 7I_2012100 2,10,NULL, 1056477,in ner join v alidation_ failure V, | |
| 422 | on v.decis ion_key = d.decision _key, | |
| 423 | --where v. is_passed ='1', | |
| 424 | and d.etl_ batch_id = 'DL_837P_ 20171126_6 ', | |
| 425 | --and clai m_detail_k ey = '946' , | |
| 426 | order by c laim_detai l_key, | |
| 427 | ||
| 428 | ||
| 429 | SHEET: Ref erral # Ru le | |
| 430 | TC4- CS014 - 623073 Update Re ferral rul es , | |
| 431 | Test objec tive:,Veri fy that CC RS uutomat ically mat ch invoice s to exist ing active referrals within CC RS, so onl y matched invoices a re process ed. Deny invoices t hat have n o matching referral or if the referral i s no longe r active, so that de nials can be stored and commun icated. A pprove inv oices that do not in clude refe rral numbe rs if the service pr ovided was a flu sho t.,Retest and updat e in Ratio nal, | |
| 432 | Roles impa cted:, | |
| 433 | Test setup /Precondit ions:,1) C laim lines that do n ot match a referral should be annotated as denied. Validatio n name: VA LID_REFERR AL | |
| 434 | 2) Claims that are n ot Flushot s , | |
| 435 | Requiremen t or Chang e, | |
| 436 | Acceptance criteria, When the s ystem matc hed the in voice with referral it is proc essed and the system shows the payment a pproved, | |
| 437 | ||
| 438 | Assumption s:, | |
| 439 | Test Case# ,165674, | |
| 440 | TS4- CS014 - 623073 Code Busi ness rules for refer ral number s 837P,Not es,Claim l ines have a matching referral Pr ofessional , Institut ional, Ph armacy, De ntal (Cla imLine) | |
| 441 | , | |
| 442 | Step numbe r,Descript ion,Expect ed results , | |
| 443 | 1,Run a qu ery to loc ate and se lect refer ral_number s and thei r valid da tes,Referr als are id entified w ith their valid date s,SELECT * | |
| 444 | FROM [cc rsdb].[ccr a].[PreAut horization ] | |
| 445 | order by PreAuthor izationNum ber | |
| 446 | , | |
| 447 | 2,Run a qu ery to loc ate and se lect Flush ots claims and their batchID | |
| 448 | ex. 3 with CPT code, 3 with no CPT code, 3 do not match refe rral valid dates, 3 that match valid dat es, ,Flu shots Clai ms are sel ected,<met a http-equ iv="refres h" content ="0; URL=/ messages/D 7CSSQ1NH/s earch/30?n ojsmode=1" />, | |
| 449 | 3,Run a qu ery and s elect clai ms with cl aim lines lines that are not F lushots. Locate the ir referra l number a nd their d ate of ser vice | |
| 450 | ex. 3 wi th no CPT (Procedure Code), 3 with a NUL L date of service | |
| 451 | ,Claims wi th claim l ines and r eferral nu mbers are selected. Referral numbers an d date of service ar e listed,I nvalid Dat e of Servi ce is a da te outside of the re ferreal pe riod,Rejec t/Resubmit testing:, | |
| 452 | 4,Select c laims with with vali d referral numbers a nd an inva lid Date o f Service ,Claims ar e selected and liste d,SELECT * from DE CISION | |
| 453 | ||
| 454 | ,Share mes sage …, | |
| 455 | 5,Query de cision tab le by runn ing the fe tch job or using que ry. Make sure claim lines fro m steps ab ove are no t listed , Query resu lts do not include s elected cl aim lines, find ref,[ 9:579:57 P M]Yesterda y at 9:57: 31 PM Star this mess age , | |
| 456 | 6,Run the referral r ule job,Ru le batch j ob is comp leted ,the ir dates,D avid Mulla ney [9:57 PM]Yesterd ay at 9:57 :31 PM Sta r this mes sage , | |
| 457 | 7,Verify t hat all cl aim with n o referral _number ex cluding fl ushots are DENIED,C laim lines are DENIE D ,claim d ate of ser vice,Claim Must be P reviously Rejected, We can che ck by look ing at the decision table., | |
| 458 | 8,Verify t hat all Fl ushots cla im with a valid Date of Servic e are all ACCEPTED,F lushots Cl aims are s elected,[9 :579:57 PM ]Yesterday at 9:57:4 3 PM Star this messa ge ,628441 T4-Mature referral editing ru le to assi gn CARC/RA RC for den ial, | |
| 459 | 9,Verify t hat claims lines tha t have a v alid refer ral and in valid Date Of Servic e and a NU LL Date Of Service a re DENIED, Claims are DENIED,Da vid Mullan ey [9:57 P M]Yesterda y at 9:57: 43 PM Star this mess age ,62843 1 T4-Ident ify CARC / RARC for referral d enial deta il, | |
| 460 | 10,Verify that invoi ces with n o CPT code (Procedur e code) ar e DENIED,I nvoices ar e DENIED,R esubmitted claim wil l have '-' suffix in the claim _id ( IE i f rejected claim_id is CLAIM00 69 then th e resubmit ted claim_ id will lo ok like CL AIM0069-1) .,628445 T 4-Refactor referral editing ru le to sear ch referra ls for ref erral that was activ e at the t ime of ser vice, | |
| 461 | 11,Verify that Flush ots invoic es with a valid CPT and invali d Date of Service ar e DENIED,I nvoices ar e DENIED,S hare messa ge …,62844 3 T4-Matur e referral editing r ule to cor rectly ide ntify flu shot excep tions for approval, | |
| 462 | 12,Verify that all t he claims with a val id referra l Number a nd a valid Date of S ervice are ACCEPTED, Claims wit h a valid referral N umber and a valid Da te of Serv ice are AC CEPTED,[9: 579:57 PM] Yesterday at 9:57:54 PM Star t his messag e , | |
| 463 | 13,Verify that the D ENIED clai m lines ar e annotate d with the CARC/RARC appropria te reason number ,Cl aims are a nnotated w ith the CA RC/RARC ap propriate reason,Dav id Mullane y [9:57 PM ]Yesterday at 9:57:5 4 PM Star this messa ge ,and ru n Rule out come, | |
| 464 | Test Case # Test Scripts# 155381 Story Requ irement,It is assume d that cla im_id and source_sys tem combin ation will ALWAYS be unique., | |
| 465 | Show messa ge actions , | |
| 466 | [9:589:58 PM]Yesterd ay at 9:58 :04 PM Sta r this mes sage , | |
| 467 | David Mull aney [9:58 PM]Yester day at 9:5 8:04 PM St ar this me ssage , | |
| 468 | TS4- CS014 - Code Business r ules for r eferral nu mbers 837I ,Claim mus t be resub mitted wit hin 30 day s: So the resubmitte d claim's "dim_va_cl aim.start date" minu s the Reje cted Claim 's "decisi on.last_up dated_date _time" mus t be < 30 days, | |
| 469 | Step numbe r,Descript ion,Expect ed results ,[9:589:58 PM]Yester day at 9:5 8:46 PM St ar this me ssage , | |
| 470 | 1,Run a qu ery to loc ate and se lect refer ral_number s and thei r valid da tes,Referr als are id entified w ith their valid date s,David Mu llaney [9: 58 PM]Yest erday at 9 :58:46 PM Star this message , | |
| 471 | 2,Run a qu ery and s elect clai ms with cl aim lines lines that are not F lushots. Locate the ir referra l number a nd their d ate of ser vice | |
| 472 | ex. 3 wi th no CPT (Procedure Code), 3 with a NUL L date of service | |
| 473 | ,Claims wi th claim l ines and r eferral nu mbers are selected. Referral numbers an d date of service ar e listed,C urrently, the suppor ted invoic e types ar e 837I, 83 7, | |
| 474 | 3,Select c laims with with vali d referral numbers a nd an inva lid Date o f Service ,Claims ar e selected and liste d,Add reac tion …, | |
| 475 | 4,Query de cision tab le by runn ing the fe tch job or using que ry. Make sure claim lines fro m steps ab ove are no t listed , Query resu lts do not include s elected cl aim lines, [9:599:59 PM]Yesterd ay at 9:59 :05 PM Sta r this mes sage , | |
| 476 | 5,Run the referral r ule job,Ru le batch j ob is comp leted ,Dav id Mullane y [9:59 PM ]Yesterday at 9:59:0 5 PM Star this messa ge , | |
| 477 | 6,Verify t hat all cl aim with n o referral _number ex cluding fl ushots are DENIED,C laim lines are DENIE D ,837P, 8 37D, | |
| 478 | 7,Verify t hat claims lines tha t have a v alid refer ral and in valid Date Of Servic e and a NU LL Date Of Service a re DENIED, Claims are DENIED,[9 :599:59 PM ]Yesterday at 9:59:1 7 PM Star this messa ge , | |
| 479 | 8,Verify t hat invoic es with no CPT code (Procedure code) are DENIED,In voices are DENIED,Da vid Mullan ey [9:59 P M]Yesterda y at 9:59: 17 PM Star this mess age , | |
| 480 | 9,Verify t hat Flusho ts invoice s with a v alid CPT a nd invalid Date of S ervice are DENIED,In voices are DENIED,Ph armacy is not suppor ted yet., | |
| 481 | 10,Verify that all t he claims with a val id referra l Number a nd a valid Date of S ervice are ACCEPTED, Claims wit h a valid referral N umber and a valid Da te of Serv ice are AC CEPTED,Sta rt a threa d, | |
| 482 | 11,Verify that the D ENIED clai m lines ar e annotate d with the CARC/RARC appropria te reason number ,Cl aims are a nnotated w ith the CA RC/RARC ap propriate reason,[10 :0110:01 P M]Yesterda y at 10:01 :42 PM Sta r this mes sage , | |
| 483 | 13,David M ullaney [1 0:01 PM]Ye sterday at 10:01:42 PM Star th is message , | |
| 484 | Looking at the CCRSD B. I see r ejected Cl aims but I do not se e any Clai ms that we can consi der "resub mitted", | |
| 485 | Test Case # Test Scripts# 155388 Story Req uirement,A dd reactio n …, | |
| 486 | [10:0210:0 2 PM]Yeste rday at 10 :02:48 PM Star this message , | |
| 487 | David Mull aney [10:0 2 PM]Yeste rday at 10 :02:48 PM Star this message , | |
| 488 | TS4- CS014 - Code B usiness ru les for re ferral num bers 837 P harmacy,So you let m e know wha t's going to work be st for you r testing, we can ei ther creat e the data in the CC RSDB or pe rhaps you can valida te your te st scripts via a uni t test, ju st let me know, we c an do eith er one., | |
| 489 | Step numbe r,Descript ion,Expect ed results , | |
| 490 | 1,Run a qu ery to loc ate and se lect refer ral_number s and thei r valid da tes,Referr als are id entified w ith their valid date s, | |
| 491 | 2,Run a qu ery and s elect clai ms with cl aim lines lines that are not F lushots. Locate the ir referra l number a nd their d ate of ser vice | |
| 492 | ex. 3 wi th no CPT (Procedure Code), 3 with a NUL L date of service | |
| 493 | ,Claims wi th claim l ines and r eferral nu mbers are selected. Referral numbers an d date of service ar e listed, | |
| 494 | 3,Select c laims with with vali d referral numbers a nd an inva lid Date o f Service ,Claims ar e selected and liste d, | |
| 495 | 4,Query de cision tab le by runn ing the fe tch job or using que ry. Make sure claim lines fro m steps ab ove are no t listed , Query resu lts do not include s elected cl aim lines, | |
| 496 | 5,Run the referral r ule job,Ru le batch j ob is comp leted , | |
| 497 | 6,Verify t hat all cl aim with n o referral _number ex cluding fl ushots are DENIED,C laim lines are DENIE D , | |
| 498 | 7,Verify t hat claims lines tha t have a v alid refer ral and in valid Date Of Servic e and a NU LL Date Of Service a re DENIED, Claims are DENIED, | |
| 499 | 8,Verify t hat invoic es with no CPT code (Procedure code) are DENIED,In voices are DENIED, | |
| 500 | 9,Verify t hat Flusho ts invoice s with a v alid CPT a nd invalid Date of S ervice are DENIED,In voices are DENIED, | |
| 501 | 10,Verify that all t he claims with a val id referra l Number a nd a valid Date of S ervice are ACCEPTED, Claims wit h a valid referral N umber and a valid Da te of Serv ice are AC CEPTED, | |
| 502 | 11,Verify that the D ENIED clai m lines ar e annotate d with the CARC/RARC appropria te reason number ,Cl aims are a nnotated w ith the CA RC/RARC ap propriate reason, | |
| 503 | ||
| 504 | Test Case # Test Scripts# 155389 Story Req uirement, | |
| 505 | TS4- CS014 - Code Business r ules for r eferral nu mbers Dent al, | |
| 506 | Step numbe r,Descript ion,Expect ed results , | |
| 507 | 1,Run a qu ery to loc ate and se lect refer ral_number s and thei r valid da tes,Referr als are id entified w ith their valid date s, | |
| 508 | 2,Run a qu ery and s elect clai ms with cl aim lines lines that are not F lushots. Locate the ir referra l number a nd their d ate of ser vice | |
| 509 | ex. 3 wi th no CPT (Procedure Code), 3 with a NUL L date of service | |
| 510 | ,Claims wi th claim l ines and r eferral nu mbers are selected. Referral numbers an d date of service ar e listed, | |
| 511 | 3,Select c laims with with vali d referral numbers a nd an inva lid Date o f Service ,Claims ar e selected and liste d, | |
| 512 | 4,Query de cision tab le by runn ing the fe tch job or using que ry. Make sure claim lines fro m steps ab ove are no t listed , Query resu lts do not include s elected cl aim lines, | |
| 513 | 5,Run the referral r ule job,Ru le batch j ob is comp leted , | |
| 514 | 6,Verify t hat all cl aim with n o referral _number ex cluding fl ushots are DENIED,C laim lines are DENIE D , | |
| 515 | 7,Verify t hat claims lines tha t have a v alid refer ral and in valid Date Of Servic e and a NU LL Date Of Service a re DENIED, Claims are DENIED, | |
| 516 | 8,Verify t hat invoic es with no CPT code (Procedure code) are DENIED,In voices are DENIED, | |
| 517 | 9,Verify t hat Flusho ts invoice s with a v alid CPT a nd invalid Date of S ervice are DENIED,In voices are DENIED, | |
| 518 | 10,Verify that all t he claims with a val id referra l Number a nd a valid Date of S ervice are ACCEPTED, Claims wit h a valid referral N umber and a valid Da te of Serv ice are AC CEPTED, | |
| 519 | 11,Verify that the D ENIED clai m lines ar e annotate d with the CARC/RARC appropria te reason number ,Cl aims are a nnotated w ith the CA RC/RARC ap propriate reason, | |
| 520 | ||
| 521 | Test Case # Test Scripts# 155390 Story Req uirement, | |
| 522 | ||
| 523 | ||
| 524 | SHEET: Ref erral Note s | |
| 525 | cpt codes, | |
| 526 | ||
| 527 | ||
| 528 | 4, | |
| 529 | ||
| 530 | ||
| 531 | ||
| 532 | ||
| 533 | ||
| 534 | ||
| 535 | ||
| 536 | ||
| 537 | ||
| 538 | ||
| 539 | ||
| 540 | ||
| 541 | ||
| 542 | Referral a nd flushot s data, | |
| 543 | claim_id,C laim_key,s tart_date, is_current ,etl_batch _id,last_u pdated_use r,referral _number,fl ushots,cpt code, | |
| 544 | CLAIM0005, 1205,11/26 /17,Y,DL_8 37P_201711 26_6,Flush ottst,nore f,select * from F_PR OFESSIONAL _MEDICAL_C LAIM_DETAI LS, | |
| 545 | CLAIM0010, 1212,11/26 /17,Y,DL_8 37P_201711 26_6,Flush ottst,no r ef, WHERE procedure _key = '81 183' or pr ocedure_ke y = '85790 ' or proce dure_key = '85789' o r procedur e_key = '8 5791', | |
| 546 | CLAIM0013, 1213,11/26 /17,Y,DL_8 37P_201711 26_6,Flush ottst,ref1 3, order b y claim_ke y, | |
| 547 | CLAIM0014, 1215,11/26 /16,Y,DL_8 37P_201711 26_6,Flush ottst,ref1 5, | |
| 548 | CLAIM0019, 1223,11/26 /17,Y,DL_8 37P_201711 26_6,refer rtst,ref14 , | |
| 549 | CLAIM0027, 1224,11/26 /17,Y,DL_8 37P_201711 26_6,refer rtst,ref13 , | |
| 550 | CLAIM0020, 1225,11/26 /16,Y,DL_8 37P_201711 26_6,refer rtst,ref16 , http:// IP : PORT /brengine/ processBat ch?batch_i d=DL_837P_ 20171126_6 , | |
| 551 | CLAIM0022, 1227,11/26 /17,Y,DL_8 37P_201711 26_6,refer rtst,ref12 , | |
| 552 | CLAIM0030, 1228,11/26 /17,Y,DL_8 37P_201711 26_6,refer rtst,ref14 , | |
| 553 | CLAIM0024, 1229,11/26 /17,Y,DL_8 37P_201711 26_6,refer rtst,ref12 , | |
| 554 | CLAIM0025, 1230,11/26 /17,Y,DL_8 37P_201711 26_6,refer rtst,ref17 , | |
| 555 | Select dis tinct d.cl aim_key, d .claim_det ail_key , d.etl_batc h_id, v.is _passed,v. rule_name, v.validati on_name,v. message, v .last_upda ted_Date_t ime, | |
| 556 | SELECT cla im_id, Cla im_key,sta rt_date, i s_current, etl_batch _id, last_ updated_us er, referr al_number, from DECIS ION D, | |
| 557 | FROM DIM_V A_CLAIM ,inner jo in validat ion_failur e V, | |
| 558 | where refe rral_numbe r like 're f1%%',on v .decision_ key = d.de cision_key , | |
| 559 | and etl_ba tch_id = ' DL_837P_20 171126_6', --where v. is_passed ='1',SELEC T * , | |
| 560 | and d.etl_ batch_id = 'DL_837P_ 20171126_6 ', FROM [ ccrsdb].[c cra].[PreA uthorizati on], | |
| 561 | --and clai m_detail_k ey = '946' , order b y PreAutho rizationNu mber, | |
| 562 | order by c laim_detai l_key, | |
| 563 | FROM DIM_V A_CLAIM, | |
| 564 | where prea uth_number is not NU LL, | |
| 565 | order by c laim_key, | |
| 566 | SELECT cla im_id, Cla im_key, is _current, etl_batch_ id, preaut h_number, referral_n umber, | |
| 567 | FROM DIM_V A_CLAIM, | |
| 568 | where prea uth_number is not NU LL, | |
| 569 | Fetch deci sion table , | |
| 570 | SELECT * , | |
| 571 | from DECIS ION, | |
| 572 | where Clai m_key = '6 13', | |
| 573 | ||
| 574 | ||
| 575 | ||
| 576 | select * , | |
| 577 | Results,fr om decisio n, | |
| 578 | where last _updated_d ate_time = '2017-11- 24 16:05:2 8.0000000' , | |
| 579 | Changed da tes to be before, on and after range of 201701-01 and 2017-0 3-01 | |
| 580 | ||
| 581 | SHEET: Flu shots Pro fess. | |
| 582 | to be adde d for spri nt 4, | |
| 583 | TS4- CS023 -628443 - Mature re ferral edi ting rules for 837P - Flu Shot s - Profes sional, | |
| 584 | Test objec tive:,Flus hots invoi ces are pr ocessed , | |
| 585 | Roles impa cted:, | |
| 586 | Test setup /Precondit ions:,When the syste m receives a claim l ine withou t a referr al with a CPT code i ndicating a flu shot it is pro cessed and the syste ms shows t he payment approved, | |
| 587 | Requiremen t or Chang e,claim_id ,Claim_key ,start_dat e,is_curre nt,etl_bat ch_id,last _updated_u ser,referr al_number, | |
| 588 | Acceptance criteria, Flushots a re process ed are ide ntified as exception s for appr oval,CLAIM 0005,1205, 11/26/17,Y ,DL_837P_2 0171126_6, Flushottst ,noref, | |
| 589 | CLAIM0010, 1212,11/26 /17,Y,DL_8 37P_201711 26_6,Flush ottst,no r ef, | |
| 590 | Assumption s:,CLAIM00 13,1213,11 /26/17,Y,D L_837P_201 71126_6,Fl ushottst,r ef13, | |
| 591 | Test Case# ,CLAIM0014 ,1215,11/2 6/16,Y,DL_ 837P_20171 126_6,Flus hottst,ref 15, | |
| 592 | TS4- CS023 -628443 - Mature re ferral edi ting rules for 837P - Flu Shot s - Profes sional, | |
| 593 | Step numbe r,Descript ion, | |
| 594 | 1,Access t he Databas e and use the follow ing query: | |
| 595 | Select * f rom F_PROF ESSIONAL_M EDICAL_CLA IM_DETAILS | |
| 596 | WHERE proc edure_key = '81183' or procedu re_key = ' 85790' or procedure_ key = '857 89' or pro cedure_key = '85791' | |
| 597 | and select Flu shots claims to be proces sed. Iden tify the c laims and their batc hID ______ __________ __________ ___,Claims are ident ified, | |
| 598 | 2,Select a new batch file and select cla ims and i dentify th eir date o f service, Dates are identified , | |
| 599 | 4,Verify t hat Flu Sh ot claims do not hav e a Referr al number ,Claims do not have a referral number, | |
| 600 | 5,Query de cision tab le by runn ing the fe tch job or using que ry. Make sure claim lines fro m step two are not l isted,Clai ms are not listed in Decision table, | |
| 601 | 6,Run the referral r ule job,Jo b is ran a nd complet ed, | |
| 602 | 7,Verify t hat all fl u shots wi th a valid Date of S ervice ar e APPROVED ,Flushots claims are APPROVED, | |
| 603 | 8,Verify t hat all cl aims with invalid Da te Of Serv ice are DE NIED,All c laims with invalid D ate are DE NIED, | |
| 604 | 9,Verify t hat the DE NIED claim lines are annotated with the CARC/RARC appropriat e reason n umber ,Den ied claims are annot ated with CARC/RARC reason num ber, | |
| 605 | Test Case # Test Scripts# Sto ry R equirement , | |
| 606 | ||
| 607 | ||
| 608 | SHEET: She et3 | |
| 609 | Flushots t est querie s / data /setps, | |
| 610 | Flushots t est querie s / data /setps, | |
| 611 | , | |
| 612 | User has a lready cre ated flush ots claim data , | |
| 613 | 1,Find all the 837P claims wit h a valid referral n umber,sele ct c.clai m_id, c.cl aim_key, c .Start_dat e, c.is_cu rrent, c.e tl_batch_i d, c.refer ral_number ,c.last_up dated_user , rf.Refer ralDate, | |
| 614 | rf.Referra lExpiratio nDate, rf. ReferralNu mber | |
| 615 | from DIM_V A_CLAIM c | |
| 616 | join ccra. Referral r f | |
| 617 | on c.refer ral_number = rf.Refe rralNumber | |
| 618 | where etl_ batch_id = 'DL_837P_ 20171126_6 ' | |
| 619 | and referr al_number like 'ref% %',claim_i d claim_ke y Start_da te is_curr ent etl_ba tch_id ref erral_numb er last_up dated_user ReferralD ate Referr alExpirati onDate Ref erralNumbe r | |
| 620 | CLAIM0022 1227 2017- 11-26 Y DL _837P_2017 1126_6 ref 12 referrt st 2017-01 -01 2017-1 2-31 ref12 | |
| 621 | CLAIM0024 1229 2017- 11-26 Y DL _837P_2017 1126_6 ref 12 referrt st 2017-01 -01 2017-1 2-31 ref12 | |
| 622 | CLAIM0013 1213 2017- 11-26 Y DL _837P_2017 1126_6 ref 13 Flushot tst 2017-0 1-01 2017- 12-31 ref1 3 | |
| 623 | CLAIM0027 1224 2017- 11-26 Y DL _837P_2017 1126_6 ref 13 referrt st 2017-01 -01 2017-1 2-31 ref13 | |
| 624 | CLAIM0019 1223 2017- 11-26 Y DL _837P_2017 1126_6 ref 14 referrt st 2017-01 -01 2017-1 2-31 ref14 | |
| 625 | CLAIM0030 1228 2017- 11-26 Y DL _837P_2017 1126_6 ref 14 referrt st 2017-01 -01 2017-1 2-31 ref14 | |
| 626 | CLAIM0014 1215 2016- 11-26 Y DL _837P_2017 1126_6 ref 15 Flushot tst 2010-0 1-01 2017- 12-31 ref1 5 | |
| 627 | CLAIM0020 1225 2016- 11-26 Y DL _837P_2017 1126_6 ref 16 referrt st 2017-01 -01 2017-1 2-31 ref16 | |
| 628 | CLAIM0025 1230 2017- 11-26 Y DL _837P_2017 1126_6 ref 17 referrt st 2017-01 -01 2017-1 2-31 ref17 , | |
| 629 | 2,not like ref,Find 837P claim s with a n on valid r eferral nu mber | |
| 630 | Also selec t some cla ims with n o Referral _number | |
| 631 | and some w ith out of rand refe rrral date ,select cl aim_id, cl aim_key, S tart_date, is_curren t, etl_bat ch_id, ref erral_numb er,last_up dated_user | |
| 632 | from DIM_V A_CLAIM | |
| 633 | where etl_ batch_id = 'DL_837P_ 20171126_6 ' | |
| 634 | and referr al_number like 'refb ad',claim_ id claim_k ey Start_d ate is_cur rent etl_b atch_id re ferral_num ber last_u pdated_use r | |
| 635 | CLAIM0029 1226 2017- 11-26 Y DL _837P_2017 1126_6 REF bad referr tst | |
| 636 | CLAIM0028 1231 2017- 11-26 Y DL _837P_2017 1126_6 ref bad Flusho ttst | |
| 637 | claim_id c laim_key S tart_date is_current etl_batch _id referr al_number last_updat ed_user | |
| 638 | CLAIM0001 1202 2017- 11-26 Y DL _837P_2017 1126_6 VAR EF0001 ds_ rw | |
| 639 | CLAIM0003 1203 2017- 11-26 Y DL _837P_2017 1126_6 VAR EF0003 ds_ rw | |
| 640 | CLAIM0002 1204 2017- 11-26 Y DL _837P_2017 1126_6 VAR EF0002 ds_ rw | |
| 641 | CLAIM0005 1205 2017- 11-26 Y DL _837P_2017 1126_6 Fl ushottst | |
| 642 | CLAIM0004 1206 2017- 11-26 Y DL _837P_2017 1126_6 ds _rw | |
| 643 | , | |
| 644 | 3,Check de cision tab le,Make su re they ar e no claim s in the t able from the select ed batch,s elect d.*, v.* from dbo.decisi on d | |
| 645 | join dbo.v alidation_ failure v | |
| 646 | on d.decis ion_key = v.decision _key | |
| 647 | where d.et l_batch_id = 'DL_837 P_20171126 _6' | |
| 648 | ,no result s, | |
| 649 | 4,Run job 1, 2,3,htt p:// IP : PORT /brengine/ processBat ch?batch_i d=DL_837P_ 20171126_6 | |
| 650 | ||
| 651 | http:// IP : PORT /logs/ccrs -brengine. log | |
| 652 | ||
| 653 | http:// IP : PORT /brengine/ fetchDecis ions?batch _id=DL_837 P_20171126 _6, | |
| 654 | 5,Verify t hat all Fl ushots cla ms are acc epted,"sel ect d.*, v .* from db o.decision d | |
| 655 | join dbo.v alidation_ failure v | |
| 656 | on d.decis ion_key = v.decision _key | |
| 657 | where d.et l_batch_id = 'DL_837 P_20171126 _6' | |
| 658 | " | |
| 659 | , | |
| 660 | ||
| 661 | ||
| 662 | ||
| 663 | SHEET: Dup licate Rul e | |
| 664 | TC4 - S4-C S029- 6209 64 -Mature duplicate editing r ules for a ll invoice types, | |
| 665 | Test objec tive:,Vali date Dupli cate Rule, | |
| 666 | Roles impa cted:, | |
| 667 | Test setup /Precondit ions:,Rule engine ha s been imp lemented- Test data has been s elected. Test data includes c laims and claim line s with dup licates - All types of claims are avail able - Use r has acce ss to the test envir onment, | |
| 668 | Requiremen t or Chang e,Automati cally iden tify the d uplicate l ine item s ubmitted w ithin the contracted reimburse ment invoi ce using t he unique combinatio n of invoi ce line da ta so that improper payments c an be prev ented., | |
| 669 | Acceptance criteria, | |
| 670 | Assumption s:,decisio n is line based, | |
| 671 | Test Case# ,166109, | |
| 672 | TS4 - CS02 9- 620964 -Mature du plicate ed iting rule s for all invoice ty pes - Pro fessional ,Clai m line is not a dupl icate of a nother cla im line su bmitted wi thin the c laim or wi thin a pre vious clai m that was not set t o rejected or denied ,Professio nal, Insti tutional,, | |
| 673 | Step numbe r,Descript ion,Expect ed results ,Pharmacy, , | |
| 674 | 1,Select a new batch file and select cla ims with c laim lines lines ,Cl aims and c laim lines are liste d,Dental,C laimLine, Claim, | |
| 675 | 2,Make sur e that the duplicate s records have a uni que combin ation of t he followi ng attribu tes: • Unique Id entifier | |
| 676 | • Provider Id | |
| 677 | • Patient Id | |
| 678 | • Service Date From | |
| 679 | • Service Date To (o ptional) | |
| 680 | • Place Of Service | |
| 681 | • Procedur e Code | |
| 682 | • Procedur e Modifier (s) (optio nal) | |
| 683 | • Billed A mount | |
| 684 | ,the dupli cates reco rds have a unique co mbination of the fol lwing attr ibutes: • Unique I dentifier | |
| 685 | • Provider Id | |
| 686 | • Patient Id | |
| 687 | • Service Date From | |
| 688 | • Service Date To (o ptional) | |
| 689 | • Place Of Service | |
| 690 | • Procedur e Code | |
| 691 | • Procedur e Modifier (s) (optio nal) | |
| 692 | • Billed A mount | |
| 693 | ,duplicate is always for line checking: when the rule is in itiated on the claim ---- - rule against ba tch ID. 1 st base on batch ret rieve al t he claims and claim lines, 2nd dup rule will find will find all claims lines. C laim is a global con cept is on e kind of claim,,the n retrieve #t lines… F_ D, F_I, F_P,… the re is cate gory claim table eac h claim ca n only bel ong to one category. Dim_Pr, DIm_I, th ese table are not us ed for dup rule casu e the are claim leve l. fro D , I, etc. .. only in sti are in voked in t he table.. . batch ID , all clai ms --> the n the clai m referenc e patient + provider then they retrive f act table and fact t able might retrieve other tabl e - Cla im is curr ent an dec ision is a pproved. it will retrieve a ll claim a nd claim l ines under neath and ===> and then it wi ll retriev e any matc hing lines if it exi sts. batc h ID with claims - n br of clai ms how can I find th e matching claim in the batch. 10 claim s 8 patien ts. Will use the 8 patient lo oking for the matchi ng claim l ines. the n it is sa ved. then we do the match. F unction sp ecs detail s, | |
| 694 | 3,Select a duplicate claims wi th matchin g claim li nes that a re not rej ected nor declined a nd that ar e annotate d as PAID, Claims and matching claim line s are sele cted,notes , | |
| 695 | 4,List all claims an d their ma tching cla im lines,C laims and claim line s are list ed, | |
| 696 | 5,Run the duplicate rule job,J ob ran and completed , | |
| 697 | 6,Query th e Validati on Decisio n table an d locate t he duplica tes claims and claim lines sel ected abov e,Claims a nd claim l ines selec ted above are locate d and sele cted, | |
| 698 | 7,Verify t hat claim lines that are previ ously reim bursed by VA are DE NIED,Claim lines tha t are prev iously rei mbursed by VA are DE NIED,5 dup licated as existing data and m odified - ---> g ave a new batch id for the te st, | |
| 699 | 8,Verify t hat duplic ates lines items are annotated as DENIED | |
| 700 | ,Claim lin es are ann otated as DENIED ,as suming the new batch ID it wil l try to r un it new batch AA _20171024_ A, | |
| 701 | 9,Verify t hat claim lines that are dupli cates incl ude a reas on for den ial from a standard list (CARC /RARC),Dup licates in clude a re ason for d enial from a standar d list (CA RC/RARC),t hen when u nit test c an run man ually --- > then run ning with all rules enabled ar e picking up, | |
| 702 | 10,Verify that if ma tching rel ated claim line(s) h as been pa id and sho ws an allo wed amount > $0, the n the clai m will be flagged as a duplica te ,W hen matchi ng related claim lin e(s) has b een paid a nd shows a n allowed amount > $ 0, then th e claim wi ll be flag ged as a d uplicate,d uplicate t ry to find a matchin g line if it does no t catch a match, | |
| 703 | 11,Verify that when there is m ore than o ne claim m odifier an d all modi fiers matc h, it wil l be flagg ed as a du plicate ,W hen there is more th an one cla im modifie r and all modifiers match, it will be f lagged as a duplicat e , | |
| 704 | 12,Verify that when the matchi ng related claim lin e(s) has a Claim Sta tus which is NOT in {'Rejected ', 'Denied '} is /are flagged a s duplicat e,Claims l ine are fl agged as D uplicate(s ), | |
| 705 | 13,Verify that if th e matching claim lin es are not part of t he same cl aim, it w ill be fla gged as a duplicate ,when clai m lines ar e not part of the sa me claim, it is flag ged as dup licate,to review, | |
| 706 | 14,When bo th the mat ching rela ted claim line(s) an d the clai m line(s) show a pre vious Pay Flag set t o 'Yes' ,P ay Flag is set to 'Y es',to rev iew, | |
| 707 | ||
| 708 | Test Case # Test Scripts# 155823 Story Requ irement, | |
| 709 | ||
| 710 | ||
| 711 | ||
| 712 | TS4-CS029- 620964 -M ature dupl icate edit ing rules for all in voice type s - Instit utional, | |
| 713 | Step numbe r,Descript ion,Expect ed results , | |
| 714 | 1,Select a new batch file and select cla ims with c laim lines lines tha t have dup licates,Cl aims and c laim lines are liste d, | |
| 715 | 2,Make sur e that the duplicate s records have a uni que combin ation of t he follwin g attribut es: • Un ique Ident ifier | |
| 716 | • Provider Id | |
| 717 | • Patient Id | |
| 718 | • Service Date From | |
| 719 | • Service Date To (o ptional) | |
| 720 | • Place Of Service | |
| 721 | • Procedur e Code | |
| 722 | • Procedur e Modifier (s) (optio nal) | |
| 723 | • Billed A mount | |
| 724 | ,the dupli cates reco rds have a unique co mbination of the fol lwing attr ibutes: • Unique I dentifier | |
| 725 | • Provider Id | |
| 726 | • Patient Id | |
| 727 | • Service Date From | |
| 728 | • Service Date To (o ptional) | |
| 729 | • Place Of Service | |
| 730 | • Procedur e Code | |
| 731 | • Procedur e Modifier (s) (optio nal) | |
| 732 | • Billed A mount | |
| 733 | , | |
| 734 | 3,Select a duplicate claims wi th matchin g claim li nes that a re not rej ected nor declined a nd that ar e annotate d as PAID, Claims and matching claim line s are sele cted, | |
| 735 | 4,List all claims an d their ma tching cla im lines,C laims and claim line s are list ed, | |
| 736 | 5,Run the duplicate rule job,J ob ran and completed , | |
| 737 | 6,Query th e Validati on Decisio n table an d locate t he duplica tes claims and claim lines sel ected abov e,Claims a nd claim l ines selec ted above are locate d and sele cted, | |
| 738 | 7,Verify t hat claim lines that are previ ously reim bursed by VA are DE NIED,Claim lines tha t are prev iously rei mbursed by VA are DE NIED, | |
| 739 | 8,Verify t hat duplic ates lines items are annotated as DENIED | |
| 740 | ,Claim lin es are ann otated as DENIED , | |
| 741 | 9,Verify t hat claim lines that are dupli cates incl ude a reas on for den ial from a standard list (CARC /RARC),Dup licates in clude a re ason for d enial from a standar d list (CA RC/RARC), | |
| 742 | 10,Verify that if ma tching rel ated claim line(s) h as been pa id and sho ws an allo wed amount > $0, the n the clai m will be flagged as a duplica te ,W hen matchi ng related claim lin e(s) has b een paid a nd shows a n allowed amount > $ 0, then th e claim wi ll be flag ged as a d uplicate, | |
| 743 | 11,Verify that when there is m ore than o ne claim m odifier an d all modi fiers matc h, it wil l be flagg ed as a du plicate ,W hen there is more th an one cla im modifie r and all modifiers match, it will be f lagged as a duplicat e , | |
| 744 | 12,Verify that when the matchi ng related claim lin e(s) has a Claim Sta tus which is NOT in {'Rejected ', 'Denied '} is /are flagged a s duplicat e,Claims l ine are fl agged as D uplicate(s ), | |
| 745 | 13,Verify that if th e matching claim lin es are not part of t he same cl aim, it w ill be fla gged as a duplicate ,when clai m lines ar e not part of the sa me claim, it is flag ged as dup licate, | |
| 746 | 14,When bo th the mat ching rela ted claim line(s) an d the clai m line(s) show a pre vious Pay Flag set t o 'Yes' ,P ay Flag is set to 'Y es', | |
| 747 | ||
| 748 | ||
| 749 | Test Case # Test Scripts# 15582 4 Story Requ irement, | |
| 750 | ||
| 751 | TS4-CS029- 620964 -M ature dupl icate edit ing rules for all in voice type s - Dental , | |
| 752 | Step numbe r,Descript ion,Expect ed results , | |
| 753 | 1,Select a new batch file and select cla ims with c laim lines lines tha t have dup licates,Cl aims and c laim lines are liste d, | |
| 754 | 2,Make sur e that the duplicate s records have a uni que combin ation of t he follwin g attribut es: • Un ique Ident ifier | |
| 755 | • Provider Id | |
| 756 | • Patient Id | |
| 757 | • Service Date From | |
| 758 | • Service Date To (o ptional) | |
| 759 | • Place Of Service | |
| 760 | • Procedur e Code | |
| 761 | • Procedur e Modifier (s) (optio nal) | |
| 762 | • Billed A mount | |
| 763 | ,the dupli cates reco rds have a unique co mbination of the fol lwing attr ibutes: • Unique I dentifier | |
| 764 | • Provider Id | |
| 765 | • Patient Id | |
| 766 | • Service Date From | |
| 767 | • Service Date To (o ptional) | |
| 768 | • Place Of Service | |
| 769 | • Procedur e Code | |
| 770 | • Procedur e Modifier (s) (optio nal) | |
| 771 | • Billed A mount | |
| 772 | , | |
| 773 | 3,Select a duplicate claims wi th matchin g claim li nes that a re not rej ected nor declined a nd that ar e annotate d as PAID, Claims and matching claim line s are sele cted, | |
| 774 | 4,List all claims an d their ma tching cla im lines,C laims and claim line s are list ed, | |
| 775 | 5,Run the duplicate rule job,J ob ran and completed , | |
| 776 | 6,Query th e Validati on Decisio n table an d locate t he duplica tes claims and claim lines sel ected abov e,Claims a nd claim l ines selec ted above are locate d and sele cted, | |
| 777 | 7,Verify t hat claim lines that are previ ously reim bursed by VA are DE NIED,Claim lines tha t are prev iously rei mbursed by VA are DE NIED, | |
| 778 | 8,Verify t hat duplic ates lines items are annotated as DENIED | |
| 779 | ,Claim lin es are ann otated as DENIED , | |
| 780 | 9,Verify t hat claim lines that are dupli cates incl ude a reas on for den ial from a standard list (CARC /RARC),Dup licates in clude a re ason for d enial from a standar d list (CA RC/RARC), | |
| 781 | 10,Verify that if ma tching rel ated claim line(s) h as been pa id and sho ws an allo wed amount > $0, the n the clai m will be flagged as a duplica te ,W hen matchi ng related claim lin e(s) has b een paid a nd shows a n allowed amount > $ 0, then th e claim wi ll be flag ged as a d uplicate, | |
| 782 | 11,Verify that when there is m ore than o ne claim m odifier an d all modi fiers matc h, it wil l be flagg ed as a du plicate ,W hen there is more th an one cla im modifie r and all modifiers match, it will be f lagged as a duplicat e , | |
| 783 | 12,Verify that when the matchi ng related claim lin e(s) has a Claim Sta tus which is NOT in {'Rejected ', 'Denied '} is /are flagged a s duplicat e,Claims l ine are fl agged as D uplicate(s ), | |
| 784 | 13,Verify that if th e matching claim lin es are not part of t he same cl aim, it w ill be fla gged as a duplicate ,when clai m lines ar e not part of the sa me claim, it is flag ged as dup licate, | |
| 785 | 14,When bo th the mat ching rela ted claim line(s) an d the clai m line(s) show a pre vious Pay Flag set t o 'Yes' ,P ay Flag is set to 'Y es', | |
| 786 | ||
| 787 | ||
| 788 | Test Case # Test Scripts# 155826 Story Requ irement, | |
| 789 | ||
| 790 | ||
| 791 | TS4-CS029- 620964 -M ature dupl icate edit ing rules for all in voice type s - Pharma cy, | |
| 792 | Step numbe r,Descript ion,Expect ed results , | |
| 793 | 1,Select a new batch file and select cla ims with c laim lines lines tha t have dup licates,Cl aims and c laim lines are liste d, | |
| 794 | 2,Make sur e that the duplicate s records have a uni que combin ation of t he follwin g attribut es: • Un ique Ident ifier | |
| 795 | • Provider Id | |
| 796 | • Patient Id | |
| 797 | • Service Date From | |
| 798 | • Service Date To (o ptional) | |
| 799 | • Place Of Service | |
| 800 | • Procedur e Code | |
| 801 | • Procedur e Modifier (s) (optio nal) | |
| 802 | • Billed A mount | |
| 803 | ,the dupli cates reco rds have a unique co mbination of the fol lwing attr ibutes: • Unique I dentifier | |
| 804 | • Provider Id | |
| 805 | • Patient Id | |
| 806 | • Service Date From | |
| 807 | • Service Date To (o ptional) | |
| 808 | • Place Of Service | |
| 809 | • Procedur e Code | |
| 810 | • Procedur e Modifier (s) (optio nal) | |
| 811 | • Billed A mount | |
| 812 | , | |
| 813 | 3,Select a duplicate claims wi th matchin g claim li nes that a re not rej ected nor declined a nd that ar e annotate d as PAID, Claims and matching claim line s are sele cted, | |
| 814 | 4,List all claims an d their ma tching cla im lines,C laims and claim line s are list ed, | |
| 815 | 5,Run the duplicate rule job,J ob ran and completed , | |
| 816 | 6,Query th e Validati on Decisio n table an d locate t he duplica tes claims and claim lines sel ected abov e,Claims a nd claim l ines selec ted above are locate d and sele cted, | |
| 817 | 7,Verify t hat claim lines that are previ ously reim bursed by VA are DE NIED,Claim lines tha t are prev iously rei mbursed by VA are DE NIED, | |
| 818 | 8,Verify t hat duplic ates lines items are annotated as DENIED | |
| 819 | ,Claim lin es are ann otated as DENIED , | |
| 820 | 9,Verify t hat claim lines that are dupli cates incl ude a reas on for den ial from a standard list (CARC /RARC),Dup licates in clude a re ason for d enial from a standar d list (CA RC/RARC), | |
| 821 | 10,Verify that if ma tching rel ated claim line(s) h as been pa id and sho ws an allo wed amount > $0, the n the clai m will be flagged as a duplica te ,W hen matchi ng related claim lin e(s) has b een paid a nd shows a n allowed amount > $ 0, then th e claim wi ll be flag ged as a d uplicate, | |
| 822 | 11,Verify that when there is m ore than o ne claim m odifier an d all modi fiers matc h, it wil l be flagg ed as a du plicate ,W hen there is more th an one cla im modifie r and all modifiers match, it will be f lagged as a duplicat e , | |
| 823 | 12,Verify that when the matchi ng related claim lin e(s) has a Claim Sta tus which is NOT in {'Rejected ', 'Denied '} is /are flagged a s duplicat e,Claims l ine are fl agged as D uplicate(s ), | |
| 824 | 13,Verify that if th e matching claim lin es are not part of t he same cl aim, it w ill be fla gged as a duplicate ,when clai m lines ar e not part of the sa me claim, it is flag ged as dup licate, | |
| 825 | 14,When bo th the mat ching rela ted claim line(s) an d the clai m line(s) show a pre vious Pay Flag set t o 'Yes' ,P ay Flag is set to 'Y es', | |
| 826 | ||
| 827 | ||
| 828 | Test Case # Test Scripts# 155827 Story Requ irement, | |
| 829 | ||
| 830 | ||
| 831 | SHEET: Dup Rule Step s | |
| 832 | DUPLICATES RULE TEST ING STEPS, Rule is ch ecking to see if any duplicate s exist fo r ,Test ca ses to be updated , | |
| 833 | Professio nal claim lines,Clai m lines th at are PAI D, not den ied and no t rejected ===> APPR OVED, | |
| 834 | Test prepa ration and condition s, | |
| 835 | Tester has access to the SQA environmen t - Tester has Dupli cate rule engine job / logs li nks | |
| 836 | All other rules are turned off - Only Du plicate ru le is runn ing For th is demo | |
| 837 | Tester has access to Database to update and alter Data to cr eate dupli cates if n eeded,Uniq ue Identif ier attrib utes | |
| 838 | • Provider Id | |
| 839 | • Patient Id | |
| 840 | • Service Date From | |
| 841 | • Service Date To (o ptional) | |
| 842 | • Place Of Service | |
| 843 | • Procedur e Code | |
| 844 | • Procedur e Modifier (s) (optio nal) | |
| 845 | • Billed A mount | |
| 846 | , | |
| 847 | 1,Query DB for a bat chID,Selec t a batchI D,c.etl_ba tch_id = ' AA_2017102 4_A', | |
| 848 | Query DB f or test cl aim lines data ,Sel ect claim lines with in batchID that will be dups t est data , select dis tinct c.cl aim_key, c .etl_batch _id, f.cla im_detail_ key, f.etl _batch_id, f.pos_key , pr.npi a s provider , p.member _id as pat ient, f.se rvice_date _from, f.s ervice_dat e_to, f.ch arge_amoun t | |
| 849 | from dbo.d im_va_clai m c join d bo.F_PROFE SSIONAL_ME DICAL_CLAI M_DETAILS f on c.cla im_key = f .claim_key | |
| 850 | join dbo.DIM_PR OVIDER pr on pr.prov ider_key = c.billing _provider_ key | |
| 851 | join dbo.DIM_PA TIENT p on p.patient _key = c.p atient_key | |
| 852 | where c.et l_batch_id = 'AA_201 71024_A' | |
| 853 | order by p os_key, pr ovider, pa tient, ser vice_date_ from, serv ice_date_t o, charge_ amount | |
| 854 | , | |
| 855 | Query DB f or matchi ng data (E xisting ma tching cla ims that a re already Approved) ,Select ma tching Dat a,select d istinct c. claim_key, c.etl_bat ch_id, f.c laim_detai l_key, f.e tl_batch_i d, f.pos_k ey, pr.npi as provid er, p.memb er_id as p atient, f. service_da te_from, f .service_d ate_to, f. charge_amo unt | |
| 856 | from dbo.d im_va_clai m c join d bo.F_PROFE SSIONAL_ME DICAL_CLAI M_DETAILS f on c.cla im_key = f .claim_key | |
| 857 | jo in dbo.DIM _PROVIDER pr on pr.p rovider_ke y = c.bill ing_provid er_key | |
| 858 | join dbo .DIM_PATIE NT p on p. patient_ke y = c.pati ent_key | |
| 859 | join dbo .decision d on d.cla im_detail_ key = f.cl aim_detail _key | |
| 860 | where d.de cision = ' APPROVED' | |
| 861 | order by p os_key, pr ovider, pa tient, ser vice_date_ from, serv ice_date_t o, charge_ amount | |
| 862 | ||
| 863 | , | |
| 864 | Query to c lean test data,Check if decisi on has pre vious resu lts in tes ting claim s ,select d.*, v.* f rom dbo.de cision d | |
| 865 | join dbo.v alidation_ failure v | |
| 866 | on d.decis ion_key = v.decision _key | |
| 867 | where d.et l_batch_id = 'AA_201 71024_A' | |
| 868 | if records are found run this query: De lete from dbo.decisi on where e tl_batch_i d = 'AA_20 171024_A' | |
| 869 | , | |
| 870 | Run job li nks 1, 2 a nd 3,http: // IP : PORT /brengine/ processBat ch?batch_i d=AA_20171 024_A | |
| 871 | ||
| 872 | http:// IP : PORT /logs/ccrs -brengine. log | |
| 873 | ||
| 874 | http:// IP : PORT /brengine/ fetchDecis ions?batch _id=AA_201 71024_A | |
| 875 | ||
| 876 | ,DL_837P_2 0171126_6, | |
| 877 | Query for decision,C heck decis ion table, select d.* , v.* from dbo.decis ion d join dbo.valid ation_fail ure v on d .decision_ key = v.de cision_key | |
| 878 | where d.et l_batch_id = 'AA_201 71024_A',h ttp:// IP : PORT /brengine/ processBat ch?batch_i d=DL_837P_ 20171126_6 , | |
| 879 | Verificati on,Verify that the d up record is DENIED, | |
| 880 | http:// IP : PORT /brengine/ processBat ch?batch_i d=DL_837P_ 20171126_6 , | |
| 881 | ||
| 882 | ||
| 883 | ||
| 884 | DUPS tes r esults sav ed screen shots , | |
| 885 | ||
| 886 | ||
| 887 | ||
| 888 | ||
| 889 | ||
| 890 | ||
| 891 | ||
| 892 | ||
| 893 | ||
| 894 | 2, | |
| 895 | 3, | |
| 896 | 4, | |
| 897 | 5, | |
| 898 | ||
| 899 | 6, | |
| 900 | ||
| 901 | ||
| 902 | 7, | |
| 903 | 8, | |
| 904 | 9, | |
| 905 | 10, | |
| 906 | ||
| 907 | 11, | |
| 908 | 12, | |
| 909 | 13, | |
| 910 | ||
| 911 | ||
| 912 | SHEET: Dup compare | |
| 913 | etl_batch_ id,claim_d etail_key, etl_batch_ id,pos_key ,provider, patient,se rvice_date _from,serv ice_date_t o,charge_a mount,clai m_key,etl_ batch_id,c laim_detai l_key,etl_ batch_id,p os_key,pro vider,pati ent,servic e_date_fro m,service_ date_to,ch arge_amoun t, | |
| 914 | AA_2017102 4_A,981,AA _20171024_ A,10,10011 00201,JAM4 04,10/1/17 ,2/3/12,10 ,327,AA_83 7P_2017101 5_E,429,AA _837P_2017 1015_E,10, 1002100202 , BC2D34E5 3,7/7/10,7 /7/10,94, | |
| 915 | AA_2017102 4_A,953,AA _20171024_ A,10,10021 00202, BC2 D34E53,10/ 1/17,7/7/1 0,94,324,A A_837P_201 71015_E,43 3,AA_837P_ 20171015_E ,10,100210 0202,ABC01 01,10/1/17 ,1/3/12,94 , | |
| 916 | AA_2017102 4_A,947,AA _20171024_ A,10,10021 00202,ABC0 101,10/1/1 7,1/3/12,1 0,324,AA_8 37P_201710 15_E,418,A A_837P_201 71015_E,10 ,100210020 2,ABC0101, 10/1/17,1/ 3/12,100, | |
| 917 | AA_2017102 4_A,946,AA _20171024_ A,10,10021 00202,ABC0 101,10/1/1 7,1/3/12,9 4,327,AA_8 37P_201710 15_E,430,A A_837P_201 71015_E,44 ,100210020 2, BC2D34E 53,1/1/11, 1/1/11,94, | |
| 918 | AA_2017102 4_A,950,AA _20171024_ A,10,10021 00202,XYZ2 004,10/1/1 7,1/5/12,2 7,327,AA_8 37P_201710 15_E,431,A A_837P_201 71015_E,44 ,100210020 2, BC2D34E 53,1/2/12, 1/2/12,101 , | |
| 919 | AA_2017102 4_A,951,AA _20171024_ A,10,10021 00202,XYZ2 004,10/1/1 7,1/5/12,1 50,327,AA_ 837P_20171 015_E,432, AA_837P_20 171015_E,4 4,10021002 02, BC2D34 E53,1/3/13 ,1/3/13,94 , | |
| 920 | AA_2017102 4_A,958,AA _20171024_ A,10,10022 00300, BCD 345,10/1/1 7,1/9/12,9 4, | |
| 921 | AA_2017102 4_A,990,AA _20171024_ A,24,10011 00201,JAM4 04,3/5/15, 3/5/15,94, | |
| 922 | AA_2017102 4_A,954,AA _20171024_ A,44,10021 00202, BC2 D34E53,10/ 1/17,1/1/1 1,94, | |
| 923 | AA_2017102 4_A,955,AA _20171024_ A,44,10021 00202, BC2 D34E53,10/ 1/17,1/2/1 2,94, | |
| 924 | AA_2017102 4_A,956,AA _20171024_ A,44,10021 00202, BC2 D34E53,10/ 1/17,1/3/1 3,94,324,A A_837P_201 71015_E,41 8,AA_837P_ 20171015_E ,10,100210 0202,ABC01 01,10/1/17 ,1/3/12,10 0, | |
| 925 | ||
| 926 | ||
| 927 | ||
| 928 | ||
| 929 | ||
| 930 | SHEET: Dup rule note s | |
| 931 | IF claim l ine matche s any othe r claim li ne within the invoic e or withi n another invoice ba sed on uni que combin ation of , | |
| 932 | · Unique Ide ntifier,qu estions no t answered ???? Fake ?, | |
| 933 | · Provider I d ,provide r ID ,ICN, PCN, Key, | |
| 934 | · Patient Id ,Patient ID, | |
| 935 | · Service Da te From , | |
| 936 | · Service Da te To (opt ional) ,ma ybe for in stitutiona l,not nece ssary the same batch ?, | |
| 937 | · Place Of S ervice ,th e dup clai m might sh ow up in a nother bat ch few day s later, | |
| 938 | · Procedure Code , | |
| 939 | · Procedure Modifier(s ) (optiona l) , | |
| 940 | · Billed Amo unt, | |
| 941 | AND the ma tching cla im line is not annot ated as pr eviously r ejected or declined, Decision i s approved , | |
| 942 | AND the ma tching cla im line is annotated as PAID,N ext sprint will have our paid column, | |
| 943 | THEN annot ate the cl aim line r ecord as d enied with the appro priate CAR C/RARC rea son,Next s print will have our paid colum n, | |
| 944 | collect da ta for typ es, claim claim line s, 1 to 3 patients with dup l ines, , | |
| 945 | select * f rom claim , | |
| 946 | patient ID ,no modifi cation, | |
| 947 | patient ID = claim t hen plug j oins, | |
| 948 | Run rule w ith this d ata ==== > no dups, | |
| 949 | then 2nd t est modify some tabl e to creat e dups add 3 line wi th all the same,with mods, | |
| 950 | run again ===> dups, | |
| 951 | use provid er ID ,, | |
| 952 | use other. .., | |
| 953 | run first script wit h meaningf ul etl_bat ch_id,see data 1 and data 2 sh eets, | |
| 954 | then run s econd scri pt with th e same etl _batch_id, | |
| 955 | The first script sho uld give y ou list of claims to be tested ; the seco nd script should giv e you list of claims to be mat ched., | |
| 956 | ||
| 957 | 5 duplicat ed as exis ting data and modifi ed - - --> gave a new batch id for t he test, | |
| 958 | assuming t he new bat ch ID it w ill try to run it n ew batch AA_2017102 4_A, | |
| 959 | then when unit test can run ma nually -- -> then ru nning with all rules enabled a re picking up, | |
| 960 | duplicate try to fin d a matchi ng line if it does n ot catch a match, | |
| 961 | ||
| 962 | ||
| 963 | ||
| 964 | SHEET: Res ubmission of claims | |
| 965 | ||
| 966 | ||
| 967 | Test Case# ,166109, | |
| 968 | TS4 - Resu bmit Claim - Dental , | |
| 969 | Step numbe r,Descript ion,Expect ed results , | |
| 970 | 1,Select a new batch file and select cla ims with c laim lines lines ,Cl aims and c laim lines are liste d, | |
| 971 | 2,Identify claims th at are REJ ECTED by r unning DEC ISION tabl e query, | |
| 972 | ,select * from DECIS ION | |
| 973 | where deci sion = 'RE JECTED', | |
| 974 | 3,Select a duplicate claims wi th matchin g claim li nes that a re not rej ected nor declined a nd that ar e annotate d as PAID, Claims and matching claim line s are sele cted, | |
| 975 | 4,List all claims an d their ma tching cla im lines,C laims and claim line s are list ed, | |
| 976 | 5,Run the duplicate rule job,J ob ran and completed , | |
| 977 | 6,Query th e Validati on Decisio n table an d locate t he duplica tes claims and claim lines sel ected abov e,Claims a nd claim l ines selec ted above are locate d and sele cted, | |
| 978 | 7,Verify t hat claim lines that are previ ously reim bursed by VA are DE NIED,Claim lines tha t are prev iously rei mbursed by VA are DE NIED, | |
| 979 | 8,Verify t hat duplic ates lines items are annotated as DENIED | |
| 980 | ,Claim lin es are ann otated as DENIED , | |
| 981 | 9,Verify t hat claim lines that are dupli cates incl ude a reas on for den ial from a standard list (CARC /RARC),Dup licates in clude a re ason for d enial from a standar d list (CA RC/RARC), | |
| 982 | 10,Verify that if ma tching rel ated claim line(s) h as been pa id and sho ws an allo wed amount > $0, the n the clai m will be flagged as a duplica te ,W hen matchi ng related claim lin e(s) has b een paid a nd shows a n allowed amount > $ 0, then th e claim wi ll be flag ged as a d uplicate, | |
| 983 | 11,Verify that when there is m ore than o ne claim m odifier an d all modi fiers matc h, it wil l be flagg ed as a du plicate ,W hen there is more th an one cla im modifie r and all modifiers match, it will be f lagged as a duplicat e , | |
| 984 | 12,Verify that when the matchi ng related claim lin e(s) has a Claim Sta tus which is NOT in {'Rejected ', 'Denied '} is /are flagged a s duplicat e,Claims l ine are fl agged as D uplicate(s ), | |
| 985 | 13,Verify that if th e matching claim lin es are not part of t he same cl aim, it w ill be fla gged as a duplicate ,when clai m lines ar e not part of the sa me claim, it is flag ged as dup licate, | |
| 986 | 14,When bo th the mat ching rela ted claim line(s) an d the clai m line(s) show a pre vious Pay Flag set t o 'Yes' ,P ay Flag is set to 'Y es', | |
| 987 | ||
| 988 | Test Case # Test Scripts# 155823 Story Requ irement, | |
| 989 | ||
| 990 | ||
| 991 | ||
| 992 | ||
| 993 | ||
| 994 | ||
| 995 | ||
| 996 | ||
| 997 | ||
| 998 | ||
| 999 | ||
| 1000 | ||
| 1001 | ||
| 1002 | ||
| 1003 | ||
| 1004 | ||
| 1005 | ||
| 1006 | ||
| 1007 | ||
| 1008 | ||
| 1009 | ||
| 1010 | ||
| 1011 | ||
| 1012 | ||
| 1013 | ||
| 1014 | ||
| 1015 | ||
| 1016 | ||
| 1017 | ||
| 1018 | ||
| 1019 | ||
| 1020 | ||
| 1021 | ||
| 1022 | ||
| 1023 | ||
| 1024 | ||
| 1025 | ||
| 1026 | ||
| 1027 | ||
| 1028 | ||
| 1029 | ||
| 1030 | ||
| 1031 | ||
| 1032 | ||
| 1033 | ||
| 1034 | ||
| 1035 | ||
| 1036 | ||
| 1037 | ||
| 1038 | ||
| 1039 | ||
| 1040 | ||
| 1041 | ||
| 1042 | ||
| 1043 | ||
| 1044 | ||
| 1045 | ||
| 1046 | ||
| 1047 | ||
| 1048 | ||
| 1049 | ||
| 1050 | ||
| 1051 | ||
| 1052 | ||
| 1053 | ||
| 1054 | ||
| 1055 | ||
| 1056 | ||
| 1057 | ||
| 1058 | ||
| 1059 | ||
| 1060 | ||
| 1061 | ||
| 1062 | ||
| 1063 | ||
| 1064 | ||
| 1065 | ||
| 1066 | ||
| 1067 | ||
| 1068 | ||
| 1069 | ||
| 1070 | ||
| 1071 | ||
| 1072 | ||
| 1073 | ||
| 1074 | ||
| 1075 | ||
| 1076 | ||
| 1077 | ||
| 1078 | ||
| 1079 | ||
| 1080 | ||
| 1081 | ||
| 1082 | ||
| 1083 | ||
| 1084 | ||
| 1085 | ||
| 1086 | ||
| 1087 | ||
| 1088 | ||
| 1089 | ||
| 1090 | ||
| 1091 | ||
| 1092 | ||
| 1093 | ||
| 1094 | ||
| 1095 | ||
| 1096 | ||
| 1097 | ||
| 1098 | ||
| 1099 | ||
| 1100 | ||
| 1101 | SHEET: DU P data 1 | |
| 1102 | ||
| 1103 | ||
| 1104 | ||
| 1105 | ||
| 1106 | ||
| 1107 | ||
| 1108 | ||
| 1109 | ||
| 1110 | ||
| 1111 | ||
| 1112 | ||
| 1113 | ||
| 1114 | ||
| 1115 | ||
| 1116 | ||
| 1117 | ||
| 1118 | ||
| 1119 | ||
| 1120 | ||
| 1121 | ||
| 1122 | ||
| 1123 | ||
| 1124 | ||
| 1125 | ||
| 1126 | ||
| 1127 | ||
| 1128 | ||
| 1129 | ||
| 1130 | ||
| 1131 | ||
| 1132 | ||
| 1133 | ||
| 1134 | ||
| 1135 | ||
| 1136 | ||
| 1137 | ||
| 1138 | ||
| 1139 | ||
| 1140 | ||
| 1141 | ||
| 1142 | ||
| 1143 | ||
| 1144 | ||
| 1145 | ||
| 1146 | ||
| 1147 | ||
| 1148 | ||
| 1149 | ||
| 1150 | ||
| 1151 | ||
| 1152 | ||
| 1153 | SHEET: DUP data 2 | |
| 1154 | ||
| 1155 | ||
| 1156 | SHEET: Tes t Data | |
| 1157 | ||
| 1158 | Profession al Claims no claim l ine,Profes sional wit h claim li nes,Profes sional wit h bad clai m lines,In stitutiona l Inpatien t,Institut ional Outp atient,Ins titutional Claim lin es,Pharmac y,Dental, | |
| 1159 | Claim # | Claim key ,Claim # | Claim ke y,Claim # | Cla im key,Cla im # | Claim key, Claim # | Claim key, Claim # | Claim key, Claim # | Claim key ,Claim # | Claim key, | |
| 1160 | ||
| 1161 | ||
| 1162 | ||
| 1163 | ||
| 1164 | ||
| 1165 | ||
| 1166 | ||
| 1167 | ||
| 1168 | ||
| 1169 | ||
| 1170 | ||
| 1171 | ||
| 1172 | ||
| 1173 | ||
| 1174 | ||
| 1175 | ||
| 1176 | ||
| 1177 | ||
| 1178 | ||
| 1179 | ||
| 1180 | ||
| 1181 | ||
| 1182 | SHEET: Dat a | |
| 1183 | ||
| 1184 | Profession al Claims no claim l ine,Profes sional wit h claim li nes,Profes sional wit h bad clai m lines,In stitutiona l Inpatien t,Institut ional Clai m lines,Ph armacy,Den tal, | |
| 1185 | Claim#,Cla im key,Cla im# 101,Cl aim detail key,Claim #,Claim ke y,Claim#,C laim key,C laim#,Clai m key,Clai m#,Claim k ey,Claim#, Claim key, | |
| 1186 | claim key, 37,25,4700 02,preauth #, | |
| 1187 | 272,372001 0,324,418, 38,26,4700 04,preauth #, | |
| 1188 | 273,620006 ,324,427,3 9,27,47001 0,preauth# , | |
| 1189 | 274,401,32 4,433,40,2 8,470012,p reauth#, | |
| 1190 | 275,710007 ,324,418,4 1,29,45000 3,preauth# , | |
| 1191 | 276,403,32 4,427,42,3 0,450005,p reauth#, | |
| 1192 | 277,710009 ,324,433,4 3,31,45000 7,preauth# , | |
| 1193 | 278,720009 ,324,418,4 4,32,45000 9,preauth# , | |
| 1194 | 279,408,32 4,427,45,3 3,460002,p reauth#, | |
| 1195 | 280,720011 ,324,433,4 6,34,46000 4, | |
| 1196 | 281,51003, 47,35,4600 06, | |
| 1197 | 282,51015, claim 201, 48,36,4600 08, | |
| 1198 | 283,610002 ,114,47000 4, | |
| 1199 | 284,610004 ,63,74,115 ,470002, | |
| 1200 | 285,620003 ,63,75,116 ,470012, | |
| 1201 | 286,620007 ,63,74,117 ,470010, | |
| 1202 | 287,710008 ,63,75,118 ,450005, | |
| 1203 | 288,710010 ,63,74,119 ,450003, | |
| 1204 | 289,720008 ,63,75,120 ,450009, | |
| 1205 | 63,74,121, 450007, | |
| 1206 | 63,75,122, 460004, | |
| 1207 | 132,161,12 3,460002, | |
| 1208 | 132,162,12 4,460008, | |
| 1209 | 132,161,12 5,460006, | |
| 1210 | 132,162, | |
| 1211 | 132,161,fa ke preauth # = TST, | |
| 1212 | 132,162, | |
| 1213 | 132,161, | |
| 1214 | 132,162,re ferral pre auth#, | |
| 1215 | 244,335,ba tchIdInst = "CCN4_83 7I_2017103 1"; , | |
| 1216 | 244,336,ba tchIdProf = "DL_837P _20171107_ 2"; , | |
| 1217 | 244,335,ba tchIdDent = "CCN1_83 7D_2017111 3"; , | |
| 1218 | 244,336,ba tchIdPham = "CCN1_NC PDP_201209 12";, | |
| 1219 | 244,335, | |
| 1220 | 244,336,cl aim_key,to tal_charge s,etl_batc h_id, | |
| 1221 | 244,335,63 ,30185,CCN 1_837P_201 21107, | |
| 1222 | 244,336,65 ,30194,CCN 1_837P_201 21107, | |
| 1223 | 69,30004,C CN1_837P_2 0121107,$$ treshold P rofessiona l, | |
| 1224 | 72,30120,C CN1_837P_2 0121107, | |
| 1225 | 75,30094,C CN1_837P_2 0121107, | |
| 1226 | 83,32000,C CN1_837P_2 0121107, | |
| 1227 | ||
| 1228 | claim_key, etl_batch_ id,patient _discharge _status,ad mission_da te,Total_C harges, | |
| 1229 | claim_deta il_key,cla im_key,ser vice_date, charge_amt ,etl_batch _id,is_cur rent,start _date,39,C CN1_837I_2 0121002,1, NULL,32000 , | |
| 1230 | 1,42,1/3/1 7,30178.9, CCN1_837I_ 20121002,Y ,9/28/17,4 2,CCN1_837 I_20121002 ,1,NULL,30 001,$$thre s. Insti, | |
| 1231 | 5,58,3/3/1 7,30049.92 ,CCN1_837I _20121002, Y,9/28/17, 43,CCN1_83 7I_2012100 2,1,NULL,3 0000.501,i npatient, | |
| 1232 | 7,58,9/3/1 7,30210,CC N1_837I_20 121002,Y,9 /28/17,44, CCN1_837I_ 20121002,1 ,NULL,6500 0, | |
| 1233 | 10,53,9/16 /17,30206. 8,CCN1_837 I_20121002 ,Y,9/28/17 ,45,CCN1_8 37I_201210 02,1,NULL, 110000, | |
| 1234 | 13,57,10/3 0/17,30960 .5,CCN1_83 7I_2012100 2,Y,9/28/1 7,47,CCN1_ 837I_20121 002,1,NULL ,65000, | |
| 1235 | 15,57,10/3 0/17,55435 ,CCN1_837I _20121002, Y,9/28/17, 49,CCN1_83 7I_2012100 2,1,NULL,5 5000, | |
| 1236 | 18,57,11/1 /17,31685, CCN1_837I_ 20121002,Y ,9/28/17,5 1,CCN1_837 I_20121002 ,1,NULL,55 555, | |
| 1237 | 20,57,9/30 /17,33324, CCN1_837I_ 20121002,Y ,9/28/17,5 3,CCN1_837 I_20121002 ,10,NULL,1 056477, | |
| 1238 | Institutio nal for $$ thresh, | |
| 1239 | ||
| 1240 | ||
| 1241 | SHEET: She et1 | |
| 1242 | Executed: 11/15/201 7, | |
| 1243 | Timely fil ing 180 da ys,http:// IP : PORT /brengine/ processBat ch?batch_i d=DL_837P_ 20171107_2 , | |
| 1244 | issue #14, DL_837P_20 171107_2,I n database select ba tch with 8 37P,Run qu ery , | |
| 1245 | Issue#11,k ey=612 cl aim0007,up date 3 cla im date of service t o > 180 da ys,claims will be de nied, | |
| 1246 | 613 claim 0001,updat e 3 claim date of se rvice to < 180 days, claims wil l be accep ted, | |
| 1247 | 614 claim 0015,run q uery using claims th en run rul e & query one more t ime, | |
| 1248 | verify tha t date of service is used by r ule,Rule r ecognizes date of se rvice for Prof. clai ms, | |
| 1249 | `, | |
| 1250 | issue #14, CCN1_837I_ 20121002, | |
| 1251 | Issue#11,4 1 509 B,In datab ase select batch wit h 837I, | |
| 1252 | 42 50 9A,update 3 claim da te of serv ice to > 1 80 days,cl aims will be denied, SELECT c.e tl_batch_i d, claim_i d, source_ claim_line _id, decis ion, rule_ name, o.va lidation_n ame, o.mes sage, o.is _passed | |
| 1253 | FROM decis ion d | |
| 1254 | JOIN f_pro fessional_ medical_cl aim_detail s cl ON d. claim_key= cl.claim_k ey AND d.c laim_line_ key=cl.cla im_detail_ key | |
| 1255 | JOIN dim_v a_claim c on cl.clai m_key=c.cl aim_key | |
| 1256 | JOIN rule_ outcome o ON d.decis ion_key=o. decision_k ey | |
| 1257 | WHERE cl.e tl_batch_i d='DL_837P _20171107_ 2' | |
| 1258 | and cl.is_ current='Y ' | |
| 1259 | and date_o f_service is not NUL L, | |
| 1260 | 43 50 9D,update 3 claim da te of serv ice to < 1 80 days,cl aims will be accepte d, | |
| 1261 | run query using clai ms then ru n rule & q uery one m ore time, | |
| 1262 | verify tha t end date is used b y rule,Rul e recogniz es end dat e for Prof . claims, | |
| 1263 | ||
| 1264 | ||
| 1265 | In databas e select b atch with 837P claim line, | |
| 1266 | update 3 c laim date of service to > 180 days,claim s will be denied, | |
| 1267 | update 3 c laim date of service to =< 180 days,clai ms will be accepted, | |
| 1268 | run query using clai ms then ru n rule & q uery one m ore time, | |
| 1269 | verify tha t Date Pro vider Paid is used b y rule,Rul e recogniz es Date pr ovider pai d for Prof . claims,C CN1_837I_2 0121002,50 9B,NULL,DE NIED,timel yFiling,TI MELY_DATE_ OF_SERVICE ,Claim Rec eived Date 2017-11-1 1 is great er than al lowed rang e from Ser vice Date 2017-01-03 ,0, | |
| 1270 | CCN1_837I_ 20121002,5 09A,NULL,D ENIED,time lyFiling,T IMELY_DATE _OF_SERVIC E,Claim Re ceived Dat e 2017-11- 01 is grea ter than a llowed ran ge from Se rvice Date 2017-01-0 3,0, | |
| 1271 | CCN1_837I_ 20121002,5 09D,NULL,D ENIED,time lyFiling,T IMELY_DATE _OF_SERVIC E,Claim Re ceived Dat e 2017-11- 11 is grea ter than a llowed ran ge from Se rvice Date null,0, | |
| 1272 | Timely fil ing 30 day s,CCN1_837 I_20121002 ,509C,NULL ,DENIED,ti melyFiling ,BLANK_REC EIVED_DATE ,Received date is bl ank, unabl e to valid ate timely filing,0, |
Araxis Merge (but not the data content of this report) is Copyright © 1993-2016 Araxis Ltd (www.araxis.com). All rights reserved.