Produced by Araxis Merge on 6/20/2018 10:27:47 AM 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 | CCRS.zip\CCRS\Reports-Sprint_5.zip\Reports-Sprint_5-aa03f94869cda45ee08ca75641e61a7376f2c2a5 | Build 2 Sprint 2 Test Cases.xlsx | Fri Mar 30 15:47:12 2018 UTC |
2 | CCRS.zip\CCRS\Reports-Sprint_5.zip\Reports-Sprint_5-aa03f94869cda45ee08ca75641e61a7376f2c2a5 | Build 2 Sprint 2 Test Cases.xlsx | Fri Jun 15 15:05:00 2018 UTC |
Description | Between Files 1 and 2 |
|
---|---|---|
Text Blocks | Lines | |
Unchanged | 7 | 1616 |
Changed | 5 | 10 |
Inserted | 0 | 0 |
Removed | 1 | 1 |
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: Sum mary | ||
2 | WI Story,W ork Item S tory Descr iption,Tes t Case ID, Test Case Creation,T otal Test Scripts,Pa ssed,Not C ompleted,N o Run,Fail ed,Defect ,DefectSta tus ,Comme nts, | ||
3 | 651942,S6- CS027-As a CCRS Deve loper, I n eed to des ign and cr eate the I PPS Invoic e itemized report mo del. ,1763 06,Validat ion of Gen eration of IPPS Invo ice itemiz ed report. ,14,1, | ||
4 | Acceptance Criteria: IPPS Invoi ce itemize d report m odel is cr eated., | ||
5 | 651843,S6- CS027-As a CCRS Deve loper, I n eed to ena ble the IP PS Invoice to displa y line lev el detail when a IPP S Invoice is generat ed.,176307 ,Validatio n of IPPS Invoice t o display line level detail wh en a IPPS Invoice is generated .,9,9, | ||
6 | Acceptance Criteria: Stored pr ocedures p roduce rec ord set th at display line leve l detail w hen a repo rt is gene rated., | ||
7 | 651842,S6- CS027-As a CCRS Deve loper, I n eed the IP PS report to automat ically gen erate a fi le name fo r each inv oice produ ced when t he thresho ld overage applies., 176308,Val idation of auto gene ration of a file nam e for each invoice p roduced wh en the thr eshold ove rage appli es.,3, | ||
8 | Acceptance Criteria: File name is applie d to all i nvoices ge nerated wh en the thr eshold ove rage appli es., | ||
9 | 651836,S6- CS027-As a CCRS Deve loper, I n eed the IP PS Invoice report an d detail p ages to au to-generat e on a sch edule and and be pla ced into t he IPPS In voice secu red outbou nd drop zo ne.,176309 ,Validatio n of IPPS Invoice re port and d etail page s to auto- generate o n a schedu le and tra nsported t o the IPPS Invoice s ecured out bound drop zone,2, | ||
10 | Acceptance Criteria: Full IPPS Invoice r eport auto -generates on a sche dule and p laced into the IPPS Invoice se cured outb ound drop zone, | ||
11 | Regression Testing,2 8, | ||
12 | Total ,56, 10, | ||
13 | |||
14 | |||
15 | |||
16 | |||
17 | |||
18 | |||
19 | |||
20 | |||
21 | |||
22 | |||
23 | |||
24 | |||
25 | |||
26 | |||
27 | |||
28 | |||
29 | |||
30 | |||
31 | |||
32 | |||
33 | |||
34 | |||
35 | |||
36 | |||
37 | |||
38 | |||
39 | |||
40 | |||
41 | |||
42 | |||
43 | |||
44 | |||
45 | |||
46 | |||
47 | |||
48 | |||
49 | |||
50 | |||
51 | |||
52 | |||
53 | |||
54 | |||
55 | |||
56 | |||
57 | |||
58 | |||
59 | |||
60 | |||
61 | |||
62 | |||
63 | |||
64 | |||
65 | |||
66 | |||
67 | |||
68 | |||
69 | |||
70 | |||
71 | |||
72 | |||
73 | |||
74 | |||
75 | |||
76 | |||
77 | SHEET: WI6 51942 | ||
78 | TC6- CS027 ,Validatio n of Gener ation of I PPS Invoic e itemized report. , | ||
79 | |||
80 | Test objec tive:,To v alidate IP PS Invoice report is generate d at line level deta ils, | ||
81 | Test setup /Precondit ions:,Syst em has alr eady proce ssed the c laim and C laims are approved. 1. Access to CCRS Da tabase usi ng Report Builder 2. Access to CCRS data base using SQL Serve r Manageme nt Studio , , | ||
82 | Work Item Story:, | ||
83 | Acceptance criteria, IPPS Invoi ce itemize d report m odel is cr eated., | ||
84 | QM Test ID , | ||
85 | Assumption s:,All moc k date is created, | ||
86 | |||
87 | |||
88 | TS1- CS- R QM Script # : 166748 ,Validatio n of Desig n of Invoi ce Itemize d Report,P ass, | ||
89 | Step numbe r,Descript ion,Expect ed Results ,Actual Re sults,Y/N, | ||
90 | 1,Design I nvoice Ite mized Repo rt,Invoice Itemized Report ,In voice Item ized Repor t ,Y, | ||
91 | 2,Validate the Desig n displays Date Rece ived, Refe rral Numbe r, Invoice Number, A mount.,Des ign displa ys Date Re ceived, Re ferral Num ber, Invoi ce Number, Amount.,D esign disp lays Date Received, Referral N umber, Inv oice Numbe r, Amount. ,Y, | ||
92 | 3,Get the approval f rom the Bu siness,Des ign is app roved.,Des ign is app roved.,Y, | ||
93 | |||
94 | |||
95 | |||
96 | TS1- CS- R QM Script # :,Valida tion of Ge neration o f CCRS Inv oice, | ||
97 | Step numbe r,Descript ion,Expect ed Results ,Actual Re sults, | ||
98 | 1,Connect to CCRS DB using Rep ort Builde r,Connecti on to Repo rt Builder is Succes sful, | ||
99 | 2,Run a Re port,Repor t Opens, | ||
100 | 3,Export t he data in PDF Form at ,PDF Fo rmat is ge nerated , | ||
101 | 4,Verify C CRS Invoic e is gener ated ,CCRS Invoice is generated , | ||
102 | |||
103 | |||
104 | |||
105 | TS1- CS- R QM Script # :,Valida tion of Ge neration o f Invoice Itemized R eport, | ||
106 | Step numbe r,Descript ion,Expect ed Results ,Actual Re sults, | ||
107 | 1,Connect to CCRS DB using Rep ort Builde r,Connecti on to Repo rt Builder is Succes sful, | ||
108 | 2,Run a Re port,Repor t Opens, | ||
109 | 3,Export t he data in PDF Form at ,PDF Fo rmat is ge nerated , | ||
110 | 4,Verify Invoice It emized Rep ort is gen erated , In voice Item ized Repor t is gener ated , | ||
111 | |||
112 | |||
113 | TS1- CS- R QM Script # :,Valida tion of In voice Amou nt against the Total amount on Itemized Invoice Re port, | ||
114 | Step numbe r,Descript ion,Expect ed Results ,Actual Re sults, | ||
115 | 1,Connect to CCRS DB using Rep ort Builde r,Connecti on to Repo rt Builder is Succes sful, | ||
116 | 2,Run a Re port,Repor t Opens, | ||
117 | 3,Export t he data in PDF Form at ,PDF Fo rmat is ge nerated , | ||
118 | 4,Verify I nvoice Amo unt matche s the Tota l amount o n Itemized Invoice R eport Invoice A mount matc hes the To tal amount on Itemiz ed Invoice Report , Invoic e Itemized Report is generated , | ||
119 | |||
120 | |||
121 | TS1- CS- R QM Script # :,Valida tion of di splay of I nvoice Num ber on the Line Leve l Report, | ||
122 | Step numbe r,Descript ion,Expect ed Results ,Actual Re sults, | ||
123 | 1,Connect to CCRS DB using Rep ort Builde r,Connecti on to Repo rt Builder is Succes sful, | ||
124 | 2,Run a Re port,Repor t Opens, | ||
125 | 3,Export t he data in PDF Form at ,PDF Fo rmat is ge nerated , | ||
126 | 4,Verify I nvoice Num ber on the Line Leve l Report d isplays ,I nvoice Num ber on the Line Leve l Report d isplays , | ||
127 | |||
128 | |||
129 | TS1- CS- R QM Script # :,Valida tion of In voice Numb er on the Line Level Detail re port again st Invoice Number on the pdf I nvoice, | ||
130 | Step numbe r,Descript ion,Expect ed Results ,Actual Re sults, | ||
131 | 1,Connect to CCRS DB using Rep ort Builde r,Connecti on to Repo rt Builder is Succes sful, | ||
132 | 2,Run a Re port,Repor t Opens, | ||
133 | 3,Export t he data in PDF Form at ,PDF Fo rmat is ge nerated , | ||
134 | 4,Verify I nvoice Num ber on the Line Leve l Detail r eport matc hes the In voice Numb er on the pdf Invoic e, Invoice Number on the Line Level Deta il report matches th e Invoice Number on the pdf In voice, | ||
135 | |||
136 | |||
137 | TS1- CS- R QM Script # :,Valida tion of di splay of P O Number o n the Line Level Rep ort, | ||
138 | Step numbe r,Descript ion,Expect ed Results ,Actual Re sults, | ||
139 | 1,Connect to CCRS DB using Rep ort Builde r,Connecti on to Repo rt Builder is Succes sful, | ||
140 | 2,Run a Re port,Repor t Opens, | ||
141 | 3,Export t he data in PDF Form at ,PDF Fo rmat is ge nerated , | ||
142 | 4,Verify P O Number d isplays on the Line Level Repo rt , PO Numb er display s on the L ine Level Report , | ||
143 | |||
144 | |||
145 | TS1- CS- R QM Script # :,Valida tion of PO Number on the Line Level Deta il report against th e PO Numbe r on pdf I nvoice, | ||
146 | Step numbe r,Descript ion,Expect ed Results ,Actual Re sults, | ||
147 | 1,Connect to CCRS DB using Rep ort Builde r,Connecti on to Repo rt Builder is Succes sful, | ||
148 | 2,Run a Re port,Repor t Opens, | ||
149 | 3,Export t he data in PDF Form at ,PDF Fo rmat is ge nerated , | ||
150 | 4,Verify I nvoice Num ber on the Line Leve l Detail r eport matc hes the In voice Numb er on the pdf Invoic e, Invoice Number on the Line Level Deta il report matches th e Invoice Number on the pdf In voice, | ||
151 | |||
152 | |||
153 | TS1- CS- R QM Script # :,Valida tion of di splay of I nvoice Dat e on the L ine Level Report, | ||
154 | Step numbe r,Descript ion,Expect ed Results ,Actual Re sults, | ||
155 | 1,Connect to CCRS DB using Rep ort Builde r,Connecti on to Repo rt Builder is Succes sful, | ||
156 | 2,Run a Re port,Repor t Opens, | ||
157 | 3,Export t he data in PDF Form at ,PDF Fo rmat is ge nerated , | ||
158 | 4,Verify I nvoice Dat e displays on the Li ne Level R eport ,Invoi ce Date di splays on the Line L evel Repor t , | ||
159 | |||
160 | |||
161 | TS1- CS- R QM Script # :,Valida tion of In voice Date on the Li ne Level D etail repo rt against the Invoi ce Date on pdf Invoi ce, | ||
162 | Step numbe r,Descript ion,Expect ed Results ,Actual Re sults, | ||
163 | 1,Connect to CCRS DB using Rep ort Builde r,Connecti on to Repo rt Builder is Succes sful, | ||
164 | 2,Run a Re port,Repor t Opens, | ||
165 | 3,Export t he data in PDF Form at ,PDF Fo rmat is ge nerated , | ||
166 | 4,Verify I nvoice Dat e on the L ine Level Detail rep ort matche s the Invo ice Date o n the pdf Invoice,In voice Date on the Li ne Level D etail repo rt matches the Invoi ce Date on the pdf I nvoice, | ||
167 | |||
168 | |||
169 | TS1- CS- R QM Script # :,Valida tion of di splay of C CN Tax ID on the Lin e Level Re port, | ||
170 | Step numbe r,Descript ion,Expect ed Results ,Actual Re sults, | ||
171 | 1,Connect to CCRS DB using Rep ort Builde r,Connecti on to Repo rt Builder is Succes sful, | ||
172 | 2,Run a Re port,Repor t Opens, | ||
173 | 3,Export t he data in PDF Form at ,PDF Fo rmat is ge nerated , | ||
174 | 4,Verify C CN Tax ID displays o n the Line Level Rep ort ,CCN Tax ID displa ys on the Line Level Report , | ||
175 | |||
176 | |||
177 | TS1- CS- R QM Script # :,Valida tion of CC N Tax ID o n the Line Level Det ail report against t he CCN Tax ID on pdf Invoice, | ||
178 | Step numbe r,Descript ion,Expect ed Results ,Actual Re sults, | ||
179 | 1,Connect to CCRS DB using Rep ort Builde r,Connecti on to Repo rt Builder is Succes sful, | ||
180 | 2,Run a Re port,Repor t Opens, | ||
181 | 3,Export t he data in PDF Form at ,PDF Fo rmat is ge nerated , | ||
182 | 4,Verify C CN Tax ID on the Lin e Level De tail repor t matches the CCN Ta x ID on th e pdf Invo ice,CCN Ta x ID on th e Line Lev el Detail report mat ches the C CN Tax ID on the pdf Invoice, | ||
183 | |||
184 | |||
185 | TS1- CS- R QM Script # :,Valida tion of Di splay of a ll the col umns in th e IPPS Ite mized Repo rt, | ||
186 | Step numbe r,Descript ion,Expect ed Results ,Actual Re sults, | ||
187 | 1,Connect to CCRS DB using Rep ort Builde r,Connecti on to Repo rt Builder is Succes sful, | ||
188 | 2,Run a Re port,Repor t Opens, | ||
189 | 3,Export t he data in PDF Form at ,PDF Fo rmat is ge nerated , | ||
190 | 4,Verify I PPS Itemiz ed Report is generat ed,IPPS It emized Rep ort is gen erated, | ||
191 | 5,Verify t he followi ng attribu tes Displa ys- 1. Dat e Received , 2. Refer ral ID, 3. Invoice N umber, 4. Amount,The following attribute s Displays - 1. Date Received, 2. Referra l ID, 3. I nvoice Num ber, 4. Am ount, | ||
192 | |||
193 | TS1- CS- R QM Script # :,Valida te Referra l ID is Un ique for t he Line Le vel Detail ed Report, | ||
194 | Step numbe r,Descript ion,Expect ed Results ,Actual Re sults, | ||
195 | 1,Connect to CCRS DB using Rep ort Builde r,Connecti on to Repo rt Builder is Succes sful, | ||
196 | 2,Run a Re port,Repor t Opens, | ||
197 | 3,Export t he data in PDF Form at ,PDF Fo rmat is ge nerated , | ||
198 | 4,Verify I PPS Itemiz ed Report is generat ed,IPPS It emized Rep ort is gen erated, | ||
199 | 5,Verify R eferral ID is Unique for the L ine Level Detailed R eport,Refe rral ID is Unique fo r the Line Level Det ailed Repo rt, | ||
200 | |||
201 | |||
202 | SHEET: WI6 51843 | ||
203 | TC1- CS,Va lidation o f IPPS In voice to d isplay lin e level de tail when a IPPS Inv oice is ge nerated., | ||
204 | |||
205 | Test objec tive:,To V alidate St ored Proce dure is ab le to prod uce set th at display Line leve l Detailed Report, | ||
206 | Test setup /Precondit ions:,Syst em has alr eady proce ssed the c laim and C laims are approved. 1. Access to CCRS Da tabase usi ng Report Builder 2. Access to CCRS data base using SQL Serve r Manageme nt Studio , , | ||
207 | Work Item Story:, | ||
208 | Acceptance criteria, Stored pro cedures pr oduce reco rd set tha t display line level detail wh en a repor t is gener ated., | ||
209 | QM Test ID , | ||
210 | Assumption s:,All moc k date is created, | ||
211 | |||
212 | |||
213 | |||
214 | TS1- CS- R QM Script # :,Valida tion of St ored Proce dure to be able to p roduce Lin e level De tailed Rep ort,Pass Y /N, | ||
215 | Step numbe r,Descript ion,Expect ed Results ,Actual Re sults, | ||
216 | 1,Connect to CCRS DB using SQL Managemen t Studio , Connection to SQL is successfu l ,Connect ion to SQL is succes sful ,Y, | ||
217 | 2,Execute a Stored P rocedure , Stored Pro cedure is executed,S tored Proc edure is e xecuted,Y, | ||
218 | 3,Validate Stored Pr ocedure di splays Lin e Level De tailed Rep ort.,Store d Procedur e displays Line Leve l Detailed Report.,S tored Proc edure disp lays Line Level Deta iled Repor t.,Y, | ||
219 | |||
220 | TS1- CS- R QM Script # :,Valida te Stored Procedure is able to produce I nvoice Num ber for Li ne Level D etailed Re port,Pass Y/N, | ||
221 | Step numbe r,Descript ion,Expect ed Results ,Actual Re sults, | ||
222 | 1,Connect to CCRS DB using SQL Managemen t Studio , Connection to SQL is successfu l ,Connect ion to SQL is succes sful ,Y, | ||
223 | 2,Execute a Stored P rocedure , Stored Pro cedure is executed,S tored Proc edure is e xecuted,Y, | ||
224 | 3,Validate Stored Pr ocedure di splays Inv oice Numbe r,Stored P rocedure d isplays In voice Numb er..,Store d Procedur e displays Invoice N umber..,Y, | ||
225 | |||
226 | TS1- CS- R QM Script # :,Valida te Stored Procedure is able to produce P O Number f or Line Le vel Detail ed Report, Pass Y/N, | ||
227 | Step numbe r,Descript ion,Expect ed Results ,Actual Re sults, | ||
228 | 1,Connect to CCRS DB using SQL Managemen t Studio , Connection to SQL is successfu l ,Connect ion to SQL is succes sful ,Y, | ||
229 | 2,Execute a Stored P rocedure , Stored Pro cedure is executed,S tored Proc edure is e xecuted,Y, | ||
230 | 3,Validate Stored Pr ocedure di splays PO Number.,St ored Proce dure displ ays PO Num ber.,Store d Procedur e displays PO Number which is obligation Number,Y, | ||
231 | |||
232 | TS1- CS- R QM Script # :,Valida te Stored Procedure is able to produce C CN Tax ID for Line L evel Detai led Report ,Pass Y/N, | ||
233 | Step numbe r,Descript ion,Expect ed Results ,Actual Re sults, | ||
234 | 1,Connect to CCRS DB using SQL Managemen t Studio , Connection to SQL is successfu l ,Connect ion to SQL is succes sful ,Y, | ||
235 | 2,Execute a Stored P rocedure , Stored Pro cedure is executed,S tored Proc edure is e xecuted,Y, | ||
236 | 3,Validate Stored Pr ocedure di splays CCN Tax ID.,S tored Proc edure disp lays CCN T ax ID.,Sto red Proced ure displa ys CCN Tax ID.,Y, | ||
237 | |||
238 | TS1- CS- R QM Script # :,Valida te Stored Procedure is able to produce a ll the Col umns for L ine Level Detailed R eport,Pass Y/N, | ||
239 | Step numbe r,Descript ion,Expect ed Results ,Actual Re sults, | ||
240 | 1,Connect to CCRS DB using SQL Managemen t Studio , Connection to SQL is successfu l ,Connect ion to SQL is succes sful ,Y, | ||
241 | 2,Execute a Stored P rocedure , Stored Pro cedure is executed,S tored Proc edure is e xecuted,Y, | ||
242 | 3,Validate Stored Pr ocedure di splays the following attribute s - 1. Dat e Received , 2. Refer ral ID, 3. Invoice N umber, 4. Amount,Sto red Proced ure displa ys the fol lowing att ributes - 1. Date Re ceived, 2. Referral ID, 3. Inv oice Numbe r, 4. Amou nt,Stored Procedure displays t he followi ng attribu tes - 1. D ate Receiv ed, 2. Ref erral ID, 3. Invoice Number, 4 . Amount,Y , | ||
243 | |||
244 | TS1- CS- R QM Script # :,Valida te Stored Procedure is able to produce A mount for Line Level Detailed Report,Pas s Y/N, | ||
245 | Step numbe r,Descript ion,Expect ed Results ,Actual Re sults, | ||
246 | 1,Connect to CCRS DB using SQL Managemen t Studio , Connection to SQL is successfu l ,Connect ion to SQL is succes sful ,Y, | ||
247 | 2,Execute a Stored P rocedure , Stored Pro cedure is executed,S tored Proc edure is e xecuted,Y, | ||
248 | 3,Validate Stored Pr ocedure di splays Am ount for L ine Level Detailed R eport,Stor ed Procedu re display s Amount f or Line Le vel Detail ed Report, Stored Pro cedure dis plays Amou nt for Lin e Level De tailed Rep ort,Y, | ||
249 | |||
250 | TS1- CS- R QM Script # :,Valida te Stored Procedure is able to produce U nique Refe rral ID f or Line Le vel Detail ed Report, Pass Y/N, | ||
251 | Step numbe r,Descript ion,Expect ed Results ,Actual Re sults, | ||
252 | 1,Connect to CCRS DB using SQL Managemen t Studio , Connection to SQL is successfu l ,Connect ion to SQL is succes sful ,Y, | ||
253 | 2,Execute a Stored P rocedure , Stored Pro cedure is executed,S tored Proc edure is e xecuted,Y, | ||
254 | 3,Validate Stored Pr ocedure di splays Uni que Referr al ID,Stor ed Procedu re display s Unique R eferral ID ,Stored Pr ocedure di splays Uni que Referr al ID,Y, | ||
255 | |||
256 | TS1- CS- R QM Script # :,Valida te Stored Procedure is able to produce D ate Receiv ed from St art_Date,P ass Y/N, | ||
257 | Step numbe r,Descript ion,Expect ed Results ,Actual Re sults, | ||
258 | 1,Connect to CCRS DB using SQL Managemen t Studio , Connection to SQL is successfu l ,Connect ion to SQL is succes sful ,Y, | ||
259 | 2,Execute a Stored P rocedure , Stored Pro cedure is executed,S tored Proc edure is e xecuted,Y, | ||
260 | 3,Validate Stored Pr ocedure is able to p roduce Dat e Received from Star t_Date,Sto red Proced ure is abl e to produ ce Date Re ceived fro m Start_Da te,Stored Procedure is able to produce D ate Receiv ed from St art_Date,Y , | ||
261 | |||
262 | TS1- CS- R QM Script # :,Valida te Stored Procedure is able to produce Referral I D from Ref erral Numb er ,Pass Y/N, | ||
263 | Step numbe r,Descript ion,Expect ed Results ,Actual Re sults, | ||
264 | 1,Connect to CCRS DB using SQL Managemen t Studio , Connection to SQL is successfu l ,Connect ion to SQL is succes sful ,Y, | ||
265 | 2,Execute a Stored P rocedure , Stored Pro cedure is executed,S tored Proc edure is e xecuted,Y, | ||
266 | 3,Validate Stored Pr ocedure is able to p roduce Ref erral ID f rom Refere nce Number ,Stored Pr ocedure is able to p roduce Ref erral ID f rom Refere nce Number ,Stored Pr ocedure is able to p roduce Ref erral ID f rom Refere nce Number ,Y, | ||
267 | |||
268 | |||
269 | SHEET: WI6 51842 | ||
270 | TC1- CS,Va lidation o f auto gen eration of a file na me for eac h invoice produced w hen the th reshold ov erage appl ies., | ||
271 | |||
272 | Test objec tive:,To V alidate fi le name is auto-gene rated for each invoi ce when th e threshol d overage applies., | ||
273 | Test setup /Precondit ions:,Syst em has alr eady proce ssed the c laim and C laims are approved. 1. Access to CCRS Da tabase usi ng Report Manager 2. Access to CCRS data base using SQL Serve r Manageme nt Studio , , | ||
274 | Work Item Story:, | ||
275 | Acceptance criteria, File name is applied to all in voices gen erated whe n the thre shold over age applie s., | ||
276 | QM Test ID , | ||
277 | Assumption s:,All moc k date is created, | ||
278 | |||
279 | |||
280 | |||
281 | TS1- CS- R QM Script # :,Valida tion of G eneration of a File Name for I nvoice, | ||
282 | Step numbe r,Descript ion,Expect ed Results ,Actual Re sults, | ||
283 | 1,Connect to Report Manager,Co nnection i s successf ul., | ||
284 | 2,Note the name of t he RDL Fil e Name on the Home P age,RDL Fi le Name is noted, | ||
285 | 3,Compare File Name from SQL T able To Na me on RDL File.,File Name from SQL Table To Name o n RDL File matches., | ||
286 | |||
287 | TS1- CS- R QM Script # :,Valida tion of A uto Genera tion of a File Name for Invoic e when the amount ex ceeds the Threshhold , | ||
288 | Step numbe r,Descript ion,Expect ed Results ,Actual Re sults, | ||
289 | 1,Connect to Report Manager,Co nnection i s successf ul., | ||
290 | 2,Note the name of t he RDL Fil e Name on the Home P age,RDL Fi le Name is noted, | ||
291 | 3,Compare File Name from SQL T able To Na me on RDL File.,File Name from SQL Table To Name o n RDL File matches., | ||
292 | 4,Validate File Name is auto g enerated f or Invoice when the amount exc eeds the T hreshold., File Name is auto ge nerated fo r Invoice when the a mount exce eds the Th reshold., | ||
293 | |||
294 | |||
295 | |||
296 | |||
297 | TS1- CS- R QM Script # :,Valida tion of F ile Name f or each In voice prod uced is un ique, | ||
298 | Step numbe r,Descript ion,Expect ed Results ,Actual Re sults, | ||
299 | 1,Connect to CCRS DB using SQL Managemen t Studio , Connection to SQL is successfu l , | ||
300 | 2,Navigate to the Rp t.IPPS_Inv oice Table and Selec t Top 200 Rows ,Trp. IPPS_Invoi ce table o pens, | ||
301 | 3,Validate File Name for each invoice pr oduced is unique., F ile Name f or each in voice prod uced is un ique., | ||
302 | |||
303 | |||
304 | |||
305 | |||
306 | |||
307 | |||
308 | |||
309 | |||
310 | |||
311 | |||
312 | |||
313 | |||
314 | |||
315 | |||
316 | |||
317 | SHEET: WI6 51836 | ||
318 | TC1- CS,Va lidation o f IPPS Inv oice repor t and deta il pages t o auto-gen erate on a schedule and transp orted to t he IPPS In voice secu red outbou nd drop zo ne, | ||
319 | IPPS Invo ice report and detai l pages to auto-gene rate on a schedule a nd transpo rted to th e IPPS Inv oice secur ed outboun d drop zon e in the V A SQA envi ronment., | ||
320 | Test objec tive:,To v alidate In voice is a uto-genera ted on a s chedule an d placed i nto the IP PS Invoice secured d ropzone, | ||
321 | Test setup /Precondit ions:,Syst em has alr eady proce ssed the c laim and C laims are approved. 1. Access to CCRS Da tabase usi ng Report Builder 2. Access to CCRS data base using SQL Serve r Manageme nt Studio , | ||
322 | Work Item Story:, | ||
323 | Acceptance criteria, Full IPPS Invoice re port auto- generates on a sched ule and pl aced into the IPPS I nvoice sec ured outbo und drop z one , | ||
324 | QM Test ID , | ||
325 | Assumption s:,All moc k date is created, | ||
326 | |||
327 | |||
328 | |||
329 | TS1- CS- R QM Script # :,Valida tion of Au to - Gener ation of I PPS report and Detai l Pages, | ||
330 | Step numbe r,Descript ion,Expect ed Results ,Actual Re sults, | ||
331 | 1,Connect to Report Server,Con nection is successfu l., | ||
332 | 2,Select S ubscribe f rom the Re port Menu, Subscribe is select ed from t he Report Menu, | ||
333 | 3,Select D elivered b y as Windo w File Sha re in Deli very Optio n ,Deliver ed by as W indow File Share in Delivery O ption is s elected, | ||
334 | 4,Enter - 1.File Nam e ,2. Path , 3.Select PDF from the drop d own, 4. Enter User Name and : P ORT ,All field s entered/ Selected. , | ||
335 | 5,Select S cheduled d ay and Tim e,Schedule d Day and Time selec ted., | ||
336 | 6,Select O K,Home Pag e Displays ., | ||
337 | 7,Select M y Subscrip tions and validate t he schedul e displays on the pa ge,The sch edule disp lays on th e page, | ||
338 | 8,Navigate to the te mp Folder and Valida te the pdf format of report di splays,Pdf format of report di splays, | ||
339 | |||
340 | TS1- CS027 - RQM Scr ipt # ,Val idation of secured o utbound dr op zone in the VA en vironment accessible to IPPS | CAR., | ||
341 | Step numbe r,Descript ion,Expect ed results ,Actual Re sult, | ||
342 | 1,Navigate to the VA Environme nt( FTC/FT P),Navigat ion is Suc cessful., | ||
343 | 2,Login wi th Valid :PORT Password, Login Succ essful, | ||
344 | 3,Validate the repor t is dropp ed to the Secured dr op zone.,T he report is dropped to the Se cured drop zone., | ||
345 | |||
346 | |||
347 | SHEET: Reg ression Sc ripts | ||
348 | |||
349 | TC1- CS027 ,Validatio n of Versi on 2.0 of IPPS Invoi ce Report, | ||
350 | |||
351 | Test objec tive:,To V alidate CC RS Invoice Version 2 .0 is gene rated , | ||
352 | Roles impa cted:, | ||
353 | Test setup /Precondit ions:,Syst em has alr eady proce ssed the c laim and C laims are approved. 1. Access to CCRS Da tabase usi ng Report Builder 2. Access to CCRS data base using SQL Serve r Manageme nt Studio , , | ||
354 | Work Item Story:,669 602, | ||
355 | Acceptance criteria, IPPS Invoi ce report version 2. 0 includes ( purchas e order nu mber, date of servic e ), | ||
356 | QM Test ID , | ||
357 | Assumption s:,All Req uired Tabl es Schema have been created/ D esigned, | ||
358 | a, | ||
359 | |||
360 | TS1- CS027 - RQM Scr ipt # :,Va lidation o f Display of Purchas e Order Nu mber for I PPS Invoic e, | ||
361 | Step numbe r,Descript ion,Expect ed results ,Actual Re sult, | ||
362 | 1,Connect to CCRS DB using Rep ort Builde r,Connecti on to Repo rt Builder is Succes sful,Conne ction to R eport Buil der is Suc cessful, | ||
363 | 2, Run a R eport,Repo rt Opens,R eport Open s, | ||
364 | 3,Export t he report in PDF Fo rmat ,PDF Format is generated ,PDF Forma t is gener ated , | ||
365 | 4,Verify C CRS Invoic e is gener ated and P urchase Or der Number Displays ,CCRS Inv oice is ge nerated an d Purchase Order Num ber Displa ys ,CCRS Invoice i s generate d and Purc hase Order Number Di splays , | ||
366 | 5,Execute Stored Pro cedure in database ( SSMS) to validate t he display of data v alue again st mapping document, Data displ ays correc tly agains t mapping document,D ata displa ys correct ly against mapping d ocument, | ||
367 | |||
368 | TS7- CS027 - RQM Scr ipt # :,Va lidation o f Display of Date of Service f or IPPS In voice, | ||
369 | Step numbe r,Descript ion,Expect ed results ,Actual Re sult, | ||
370 | 1,Connect to CCRS DB using Rep ort Builde r,Connecti on to Repo rt Builder is Succes sful,Conne ction to R eport Buil der is Suc cessful, | ||
371 | 2, Run a R eport,Repo rt Opens,R eport Open s, | ||
372 | 3,Export t he report in PDF Fo rmat ,PDF Format is generated ,PDF Forma t is gener ated , | ||
373 | 4,Verify C CRS Invoic e is gener ated and D ate of Ser vice is di splays acc urately wh ich is the date the service wa s performe d. , CCRS Invoi ce is gene rated and Date of Se rvice is d isplays ac curately w hich is th e date the service w as perform ed.,CCRS I nvoice is generated and Date o f Service is display s accurate ly which i s the date the servi ce was per formed., | ||
374 | 5,Execute Stored Pro cedure in database ( SSMS) to validate t he display of data v alue again st mapping document, Data displ ays correc tly agains t mapping document,D ata displa ys correct ly against mapping d ocument, | ||
375 | |||
376 | TS3- CS027 - RQM Scr ipt # :,Va lidation o f Obligati on Number Sequence f or IPPS In voice, | ||
377 | Step numbe r,Descript ion,Expect ed results ,Actual Re sult, | ||
378 | 1,Connect to CCRS DB using Rep ort Builde r,Connecti on to Repo rt Builder is Succes sful,Conne ction to R eport Buil der is Suc cessful, | ||
379 | 2, Run a R eport,Repo rt Opens,R eport Open s, | ||
380 | 3,Export t he report in PDF Fo rmat ,PDF Format is generated ,PDF Forma t is gener ated , | ||
381 | 4,Verify C CRS Invoic e is gener ated and O bligation Number con sist of on e letter f ollowed by 5 numbers . ,CCRS Inv oice is ge nerated an d Obligati on Number consist of one lette r followed by 5 numb ers. ,CCRS Invo ice is gen erated and Obligatio n Number c onsist of one letter followed by 5 numbe rs. , | ||
382 | 5,Execute Stored Pro cedure in database ( SSMS) to validate t he display of data v alue again st mapping document, Data displ ays correc tly agains t mapping document,D ata displa ys correct ly against mapping d ocument, | ||
383 | |||
384 | TS4- CS027 - RQM Scr ipt # :,Va lidate Obl igation Nu mber is un ique per C CN, | ||
385 | Step numbe r,Descript ion,Expect ed results ,Actual Re sult,Pleas e Note,For Obligatio n Number - No real d ata is ava ilable. Da ta is all mock data. So for no w, Obligat ion Number will be s ame for al l the CCN Numbers. , | ||
386 | 1,Connect to CCRS DB using Rep ort Builde r,Connecti on to Repo rt Builder is Succes sful,So pa ssing this test unti l further notice, | ||
387 | 2, Run a R eport,Repo rt Opens, | ||
388 | 3,Export t he report in PDF Fo rmat ,PDF Format is generated , | ||
389 | 4,Verify C CRS Invoic e is gener ated and O bligation Number is unique per CCN , CCRS Invoice is generated and Oblig ation Numb er is uniq ue per CCN , | ||
390 | 5,Execute Stored Pro cedure in database ( SSMS) to validate t he display of data v alue again st mapping document, Data displ ays correc tly agains t mapping document, | ||
391 | |||
392 | TS5- CS027 - RQM Scr ipt # :,Va lidation o f Purchase Order Num ber Sequen ce for IPP S Invoice, | ||
393 | Step numbe r,Descript ion,Expect ed results ,Actual Re sult, | ||
394 | 1,Connect to CCRS DB using Rep ort Builde r,Connecti on to Repo rt Builder is Succes sful,Conne ction to R eport Buil der is Suc cessful, | ||
395 | 2, Run a R eport,Repo rt Opens,R eport Open s, | ||
396 | 3,Export t he report in PDF Fo rmat ,PDF Format is generated ,PDF Forma t is gener ated , | ||
397 | 4,Verify C CRS Invoic e is gener ated and P urchase Or der Number displays as 741 fol lowed by O bligation Number ,CCRS Invo ice is gen erated and Purchase Order Numb er display s as 741 f ollowed by Obligatio n Number , CCRS Invoi ce is gene rated and Purchase O rder Numbe r displays as 741 fo llowed by Obligation Number , | ||
398 | 5,Execute Stored Pro cedure in database ( SSMS) to validate the displa y of data value agai nst mappin g document ,Data disp lays corre ctly again st mapping document, Data displ ays correc tly agains t mapping document, | ||
399 | |||
400 | TS6- CS027 - RQM Scr ipt # :,Va lidation o f Purchase Order Num ber limit for IPPS I nvoice, | ||
401 | Step numbe r,Descript ion,Expect ed results ,Actual Re sult, | ||
402 | 1,Connect to CCRS DB using Rep ort Builde r,Connecti on to Repo rt Builder is Succes sful,Conne ction to R eport Buil der is Suc cessful, | ||
403 | 2, Run a R eport,Repo rt Opens,R eport Open s, | ||
404 | 3,Export t he report in PDF Fo rmat ,PDF Format is generated ,PDF Forma t is gener ated , | ||
405 | 4,Verify C CRS Invoic e is gener ated and P urchase Or der Number should be in 9 alph a numeric sequence ( Example : 104C7000 1) , CCRS Invoi ce is gene rated and Purchase O rder Numbe r should b e in 9 alp ha numeric sequence ( Example : 104C700 01,CCRS In voice is g enerated a nd Purchas e Order Nu mber shoul d be in 9 alpha nume ric seque nce ( Exam ple : 104C 70001, | ||
406 | 5,Execute Stored Pro cedure in database ( SSMS) to validate t he display of data v alue again st mapping document, Data displ ays correc tly agains t mapping document,D ata displa ys correct ly against mapping d ocument, | ||
407 | |||
408 | |||
409 | TC1- CS027 ,Validatio n of Autom atic Gener ation of a Unique Fi le Name fo r each inv oice Produ ced, | ||
410 | |||
411 | Test objec tive:,To V alidate th e IPPS rep ort is gen erated aut omatically with a un ique file name for e ach invoic e produced ., | ||
412 | Roles impa cted:, | ||
413 | Test setup /Precondit ions:,Syst em has alr eady proce ssed the c laim and C laims are approved. 1.Configur ation to R eport Mana ger 2. Acc ess to CCR S database using SQL Server Ma nagement S tudio ,3. Access to CCRS Datab ase using Report Bui lder, | ||
414 | Work Item Story:,669 606, | ||
415 | Acceptance criteria, File name includes a n invoice number and a unique report ide ntifier. U nique file name is a pplied eac h time the PDF IPPS Invoice is generated ., | ||
416 | QM Test ID ,174223, | ||
417 | Assumption s:, | ||
418 | |||
419 | |||
420 | |||
421 | TS1- CS027 - RQM Scr ipt # :164 786,Valida tion of a File Name for each invoice , | ||
422 | Step numbe r,Descript ion,Expect ed results ,Actual Re sult, | ||
423 | 1,Connect to CCRS DB using SQL Managemen t Studio , Connection to SQL is successfu l. ,Connec tion to SQ L is succe ssful. , | ||
424 | 2,Execute a querry,Q uerry is e xecuted su ccessfully .,Querry i s executed successfu lly., | ||
425 | 3,Validate File Name for each invoice di splays.,Fi le Name fo r each inv oice displ ays.,File Name for e ach invoic e does not display., | ||
426 | |||
427 | |||
428 | TS3- CS027 - RQM Scr ipt # :164 790,Valida tion of a Unique Fi le Name fo r each inv oice , | ||
429 | Step numbe r,Descript ion,Expect ed results ,Actual Re sult, | ||
430 | 1,Connect to CCRS DB using SQL Managemen t Studio , Connection to SQL is successfu l. , | ||
431 | 2,Execute a querry,Q uerry is e xecuted su ccessfully ., | ||
432 | 3,Validate File Name is unique for each invoice di splays.,Un ique File Name for e ach invoic e displays ., | ||
433 | |||
434 | TS6- CS027 - RQM Scr ipt # :164 796,Valida tion of A utomatice Generation of a uniq ue File Na me , | ||
435 | Step numbe r,Descript ion,Expect ed results ,Actual Re sult, | ||
436 | 1,Connect to CCRS DB using SQL Managemen t Studio , Connection to SQL is successfu l. , | ||
437 | 2,Execute a querry,Q uerry is e xecuted su ccessfully ., | ||
438 | 3,Validate Unique Fi le Name is Auto Gene rated.,Uni que File N ame is Aut o Generate d., | ||
439 | |||
440 | TC1- CS027 ,Validatio n of Auto - Generati on of IPPS report on a schedul e., | ||
441 | |||
442 | Test objec tive:,To V alidate th e IPPS rep ort is gen erated aut omatically on a sche dule., | ||
443 | Roles impa cted:, | ||
444 | Test setup /Precondit ions:,Syst em has alr eady proce ssed the c laim and C laims are approved. 1. Access to Report Manager, | ||
445 | Work Item Story:,669 609, | ||
446 | Acceptance criteria, IPPS is au to-generat ed on a sc hedule., | ||
447 | QM Test ID ,174225, | ||
448 | Assumption s:,All moc k tables h ave been c reated., | ||
449 | |||
450 | |||
451 | |||
452 | TS1- CS027 - RQM Scr ipt # :164 812,Valida tion of Au to - Gener ation of I PPS report , | ||
453 | Step numbe r,Descript ion,Expect ed results ,Actual Re sult, | ||
454 | 1,Connect to Report Server,Con nection is successfu l.,Connect ion is suc cessful., | ||
455 | 2,Select S ubscribe f rom the Re port Menu, Subscribe is select ed from t he Report Menu, Subs cribe is s elected f rom the Re port Menu, | ||
456 | 3,Select D elivered b y as Windo w File Sha re in Deli very Optio n ,Deliver ed by as W indow File Share in Delivery O ption is s elected,De livered by as Window File Shar e in Deliv ery Option is select ed, | ||
457 | 4,Enter - 1.File Nam e ,2. Path , 3.Select PDF from the drop d own, 4. Enter User Name and : P ORT ,All field s entered/ Selected. ,All field s entered/ Selected. , | ||
458 | 5,Select S cheduled d ay and Tim e,Schedule d Day and Time selec ted.,Sched uled Day a nd Time se lected., | ||
459 | 6,Select O K,Home Pag e Displays .,Home Pag e Displays ., | ||
460 | 7,Select M y Subscrip tions and validate t he schedul e displays on the pa ge,The sch edule disp lays on th e page,The schedule displays o n the page , | ||
461 | 8,Navigate to the te mp Folder and Valida te the pdf format of report di splays,Pdf format of report di splays,Pdf format of report di splays, | ||
462 | |||
463 | |||
464 | |||
465 | TC1- CS027 ,Validatio n of secur ed outboun d drop zon e in the V A environm ent access ible to IP PS | CAR., | ||
466 | |||
467 | Test objec tive:,To V alidate th e secured outbound d rop zone i n the VA e nvironment accessibl e to IPPS | CAR., | ||
468 | Roles impa cted:, | ||
469 | Test setup /Precondit ions:,Syst em has alr eady proce ssed the c laim and C laims are approved. 1. Access to VA Envi ronment 2. : P ORT :PO R T , | ||
470 | Work Item Story:,669 610, | ||
471 | Acceptance criteria, Secured ou tbound dro p zone is establishe d in the V A environm ent for IP PS and CAR to access IPPS Invo ice., | ||
472 | QM Test ID ,174227, | ||
473 | Assumption s:,All moc k tables h ave been c reated., | ||
474 | |||
475 | |||
476 | |||
477 | TS1- CS027 - RQM Scr ipt # :164 815,Valida tion of se cured outb ound drop zone in th e VA envir onment acc essible to IPPS | CA R., | ||
478 | Step numbe r,Descript ion,Expect ed results ,Actual Re sult, | ||
479 | ,Navigate to the VA Environme nt( FTC/FT P),Navigat ion is Suc cessful., | ||
480 | 2,Login wi th Valid :PORT Password, Login Succ essful, | ||
481 | 3,Validate the repor t is dropp ed to the Secured dr op zone.,T he report is dropped to the Se cured drop zone., | ||
482 | |||
483 | TC1- CS027 ,Validatio n of table s in the C CRS databa se to trac k historic al payment of invoic es., | ||
484 | |||
485 | Test objec tive:,To V alidate th e tables i n the CCRS database to track h istorical payment of invoices. , | ||
486 | Roles impa cted:, | ||
487 | Test setup /Precondit ions:,Syst em has alr eady proce ssed the c laim and C laims are approved. 1. Access to CCRS Da tabase usi ng Report Builder 2. Access to CCRS data base using SQL Serve r Manageme nt Studio , , | ||
488 | Work Item Story:,669 616, | ||
489 | Acceptance criteria, Historical IPPS rela ted tables are desig ned, creat ed and dev eloped in the CCRS d atabase. , | ||
490 | QM Test ID ,174231, | ||
491 | Assumption s:,All moc k tables h ave been c reated., | ||
492 | |||
493 | |||
494 | |||
495 | TS1- CS027 - RQM Scr ipt # :164 816,Valida tion of cr eation of tables SQL Server Ma nagement S tudio, | ||
496 | Step numbe r,Descript ion,Expect ed results ,Actual Re sult, | ||
497 | 1,Connect to CCRS DB using SQL Managemen t Studio , Connection to SQL is successfu l. ,Connec tion to SQ L is succe ssful. , | ||
498 | 2,Navigate to the Ta bles field ,Navigatio n is succe ssful.,Nav igation is successfu l., | ||
499 | 3,Validate Historica l tables h ave been c reated to track the historical payment o f invoices .,Historic al tables have been created to track the historica l payment of invoice s.,Histori cal tables have been created t o track th e historic al payment of invoic es., | ||
500 | |||
501 | |||
502 | |||
503 | TS2- CS027 - RQM Scr ipt # :164 818,Valida tion of S QL Script to enable data to tr ack key fi elds, | ||
504 | Step numbe r,Descript ion,Expect ed results ,Actual Re sult, | ||
505 | 1,Connect to CCRS DB using SQL Managemen t Studio , Connection to SQL is successfu l. ,Connec tion to SQ L is succe ssful. , | ||
506 | 2,Right Cl ick and Se lect the r ows ,Rows are select ed ,Rows a re selecte d , | ||
507 | 3,Validate the key f ields are populated successful ly., key f ields are populated successful ly., key f ields are populated successful ly., | ||
508 | |||
509 | TC 1 - 027 ,Validatio n of IPPS Report out put shell to be desi gned and d eveloped t o receive data from the CCRS D atabase, | ||
510 | |||
511 | Test objec tive:,To V alidate IP PS Invoice is genera ted , | ||
512 | Roles impa cted:, | ||
513 | Test setup /Precondit ions:,Syst em has alr eady proce ssed the c laim and C laims are approved. 1. Access to CCRS Da tabase usi ng Report Builder 2. Access to CCRS data base using SQL Serve r Manageme nt Studio , , | ||
514 | Work Item Story:,651 950, | ||
515 | Acceptance criteria, IPPS Invoi ce is gene rated , | ||
516 | QM Test ID , | ||
517 | Assumption s:,All moc k tables h ave been c reated., | ||
518 | |||
519 | |||
520 | |||
521 | |||
522 | TS1- CS027 - RQM Scr ipt # :,Va lidation o f IPPS Rep ort in pdf Format , | ||
523 | Step numbe r,Descript ion,Expect ed results ,Actual Re sult, | ||
524 | 1,Connect to CCRS DB using Rep ort Builde r,Connecti on to Repo rt Builder is Succes sful,Conne ction to R eport Buil der is Suc cessful, | ||
525 | 2, Run a R eport,Repo rt Opens,R eport Open s, | ||
526 | 3,Export t he report in PDF Fo rmat ,PDF Format is generated ,PDF Forma t is gener ated , | ||
527 | 4,Query St ored Proce dure in da tabase ( S SMS) to va lidate the display o f data val ue against mapping d ocument,Da ta display s correctl y against mapping do cument,Dat a displays correctly against m apping doc ument, | ||
528 | |||
529 | TC 1 - 027 ,Validatio n of Repos itory Tabl e to inclu de fields to support the IPPS Report Fie lds , | ||
530 | |||
531 | Test objec tive:,To V alidate IP PS Invoice is genera ted and al l the attr ibutes are populated on the In voice, | ||
532 | Roles impa cted:, | ||
533 | Test setup /Precondit ions:,Syst em has alr eady proce ssed the c laim and C laims are approved. 1. Access to CCRS Da tabase usi ng Report Builder 2. Access to CCRS data base using SQL Serve r Manageme nt Studio , , | ||
534 | Work Item Story:,664 428, | ||
535 | Acceptance criteria, CCRS Invoi ce is gene rated and all the at tributes a re populat ed with da ta, | ||
536 | QM Test ID , | ||
537 | Assumption s:,All moc k tables h ave been c reated., | ||
538 | |||
539 | |||
540 | |||
541 | |||
542 | |||
543 | |||
544 | TS1- CS027 - RQM Scr ipt # :,Va lidation R epository Table to i nclude fie lds to sup port the I PPS Report Fields, | ||
545 | Step numbe r,Descript ion,Expect ed results ,Actual Re sult, | ||
546 | 1,Connect to CCRS DB using Rep ort Builde r,Connecti on to Repo rt Builder is Succes sful,Conne ction to R eport Buil der is Suc cessful, | ||
547 | 2, Run a R eport,Repo rt Opens,R eport Open s, | ||
548 | 3,Export t he report in PDF Fo rmat ,PDF Format is generated ,PDF Forma t is gener ated , | ||
549 | 4,Verify C CRS Invoic e is gener ated with all the fo llowing at tributes- 1. Report Gen eration Da te 2. Inv oice Numbe r(CCRS) 3 .Invoice A mount 4 . CCN Tax ID, CCRS I nvoice is generated with all t he followi ng attribu tes- 1. Report Generatio n Date 2. Invoice N umber(CCRS ) 3.Invo ice Amount 4. CCN Tax ID, CCRS Invoice is generated with all the follow ing attrib utes- 1. Repor t Generati on Date 2 . Invoice Number(CCR S) 3.Inv oice Amoun t 4. CCN Ta x ID, | ||
550 | 5,Query St ored Proce dure in da tabase ( S SMS) to va lidate the display o f data val ue against mapping d ocument,Da ta display s correctl y against mapping do cument,Dat a displays correctly against m apping doc ument, | ||
551 | |||
552 | TC1- CS027 ,Validatio n of Repor t Generati on Date fo r IPPS Inv oice, | ||
553 | |||
554 | Test objec tive:,To V alidate CC RS Invoice is genera ted and Ge neration D ate is Cur rent, | ||
555 | Roles impa cted:, | ||
556 | Test setup /Precondit ions:,Syst em has alr eady proce ssed the c laim and C laims are approved. 1. Access to CCRS Da tabase usi ng Report Builder 2. Access to CCRS data base using SQL Serve r Manageme nt Studio , , | ||
557 | Work Item Story:,651 856, | ||
558 | Acceptance criteria, CCRS Invoi ce is gene rated and Generation Date is C urrent., | ||
559 | QM Test ID , | ||
560 | Assumption s:,All moc k tables h ave been c reated., | ||
561 | |||
562 | |||
563 | |||
564 | TS1- CS027 - RQM Scr ipt # :,Va lidation o f Report G eneration Date for I PPS Invoic e, | ||
565 | Step numbe r,Descript ion,Expect ed results ,Actual Re sult, | ||
566 | 1,Connect to CCRS DB using Rep ort Builde r,Connecti on to Repo rt Builder is Succes sful,Conne ction to R eport Buil der is Suc cessful, | ||
567 | 2, Run a R eport,Repo rt Opens,R eport Open s, | ||
568 | 3,Export t he report in PDF Fo rmat ,PDF Format is generated ,PDF Forma t is gener ated , | ||
569 | 4,Verify C CRS Invoic e is gener ated and t he Report Generation Date is c urrent. ,CCRS Invo ice is gen erated and the Repor t Generati on Date is current. ,CCRS In voice is g enerated a nd the Rep ort Genera tion Date is current . , | ||
570 | 5,Query St ored Proce dure datab ase ( SSMS ) to valid ate the di splay of d ata value against ma pping docu ment,Data displays c orrectly a gainst map ping docum ent,Data d isplays co rrectly ag ainst mapp ing docume nt, | ||
571 | |||
572 | TC2 - CS02 7,Validati on of Gen eration Da te on IPP S Invoice Number, | ||
573 | |||
574 | Test objec tive:,To V alidate CC RS Invoice is genera ted and In voice Numb er changes with the Generation Date , | ||
575 | Roles impa cted:, | ||
576 | Test setup /Precondit ions:,Syst em has alr eady proce ssed the c laim and C laims are approved. 1. Access to CCRS Da tabase usi ng Report Builder, 2 . Access t o CCRS dat abase usin g SQL Serv er Managem ent Studio , , | ||
577 | Work Item Story:,651 856, | ||
578 | Acceptance criteria, Multiple C CRS Invoic es are gen erated and Invoice A mount disp lays accur ately on t he invoice s, | ||
579 | QM Test ID , | ||
580 | Assumption s:,All moc k tables h ave been c reated., | ||
581 | |||
582 | |||
583 | |||
584 | TS2- CS027 - RQM Scri pt # :,Val idation of IPPS Invo ice Number for Gener ation Date , | ||
585 | Step numbe r,Descript ion,Expect ed results ,Actual Re sults, | ||
586 | 1,Connect to CCRS DB using Rep ort Builde r,Connecti on to Repo rt Builder is Succes sful,Conne ction to R eport Buil der is Suc cessful, | ||
587 | 2, Run a R eport,Repo rt Opens,R eport Open s, | ||
588 | 3,Export t he report in PDF Fo rmat,PDF F ormat is g enerated., PDF Format is genera ted., | ||
589 | 4,CCRS Inv oice is ge nerated an d Invoice Number cha nges.Note: Invoice N umber is 1 9 characte rs where w here N=Net work; 1=Re gion; 1811 30=2018 No v 30( will change) ; ; 01=Invoi ce number ; C12345= Obligation Number , CCRS Invoi ces are ge nerated an d Invoice Number Net work Regio n sequence changes. Invoice Nu mber is 19 character s where wh ere N=Netw ork; 1=Reg ion; 18113 0=2018 Nov 30( will change); 0 1=Invoice number; C1 2345=Oblig ation Numb er , CC RS Invoice s are gene rated and Invoice Nu mber Netwo rk Region sequence c hanges. In voice Numb er is 19 c haracters where wher e N=Networ k; 1=Regio n; 181130= 2018 Nov 3 0( will ch ange); 01= Invoice nu mber; C123 45=Obligat ion Number , | ||
590 | 5,Query St ored Proce dure datab ase ( SSMS ) to valid ate the di splay of d ata value against ma pping docu ment,Data displays c orrectly a gainst map ping docum ent,Data d isplays co rrectly ag ainst mapp ing docume nt, | ||
591 | |||
592 | TC1 - CS02 7,Validati on of Chan ging Statu s from app roved to B ill Sent o nce the re port is ge nrated, | ||
593 | |||
594 | Test objec tive:,To V alidate CC RS Invoice is genera ted and st atus chang ed from Ap proved to Bill Sent, | ||
595 | Roles impa cted:, | ||
596 | Test setup /Precondit ions:,Syst em has alr eady proce ssed the c laim and C laims are approved. 1. Access to CCRS Da tabase usi ng Report Builder 2. Access to CCRS data base using SQL Serve r Manageme nt Studio , , | ||
597 | Work Item Story:,651 835, | ||
598 | Acceptance criteria, CCRS Invoi ce is gene rated and status cha nged from Approved t o Bill Sen t, | ||
599 | QM Test ID , | ||
600 | Assumption s:,All moc k tables h ave been c reated., | ||
601 | |||
602 | |||
603 | |||
604 | TS1- CS027 - RQM Scr ipt # :,Va lidation o f Changing Status fr om approve d to Bill Sent once the report is genrat ed, | ||
605 | Step numbe r,Descript ion,Expect ed results ,Actual Re sult, | ||
606 | 1,Connect to CCRS DB using Rep ort Builde r,Connecti on to Repo rt Builder is Succes sful, | ||
607 | 2, Run a R eport, Rep ort Opens, | ||
608 | 3,Export t he report in PDF Fo rmat ,PDF Format is generated , | ||
609 | 4,Verify C CRS Invoic e is gener ated ,CCRS Invoice is generated , | ||
610 | 5,Query da tabase ( S SMS) to va lidate the status ch anged to B ill Sent, Status cha nged to Bi ll Sent., | ||
611 | |||
612 | TC1 - CS02 7,Validati on of Invo ice Number for IPPS Invoice, | ||
613 | |||
614 | Test objec tive:,To V alidate IP PS Invoice is genera ted and In voice Numb er is 19 C haracters - ( Exampl e-N1-18113 0-01-C1234 5 , where N=Network; 1=Region; 181130=20 18 Nov 30; 01=Invoic e number; C12345=Obl igation Nu mber) , | ||
615 | Roles impa cted:, | ||
616 | Test setup /Precondit ions:,Syst em has alr eady proce ssed the c laim and C laims are approved. 1. Access to CCRS Da tabase usi ng Report Builder 2. Access to CCRS data base using SQL Serve r Manageme nt Studio , , | ||
617 | Work Item Story:,664 425, | ||
618 | Acceptance Criteria, CCRS Invoi ce is gene rated and Invoice Nu mber is 19 Character s, | ||
619 | QM Test ID , | ||
620 | Assumption s:,All moc k tables h ave been c reated., | ||
621 | |||
622 | |||
623 | |||
624 | TS1- CS006 - RQM Scr ipt # :,Va lidation o f Invoice Number for IPPS Invo ice, | ||
625 | Step numbe r,Descript ion,Expect ed results ,Actual Re sult, | ||
626 | 1,Connect to CCRS DB using Rep ort Builde r,Connecti on to Repo rt Builder is Succes sful,Conne ction to R eport Buil der is Suc cessful, | ||
627 | 2,Run a Re port,Repor t Opens,Re port Opens , | ||
628 | 3,Export t he report in PDF Fo rmat ,PDF Format is generated ,PDF Forma t is gener ated , | ||
629 | 4,Verify C CRS Invoic e is gener ated and t he Invoice Number is 19 charac ters where where N=N etwork; 1= Region; 18 1130=2018 Nov 30; 01 =Invoice n umber; C12 345=Obliga tion Numbe r ,CCRS Inv oice is ge nerated an d the Invo ice Number is 19 cha racters wh ere where N=Network; 1=Region; 181130=20 18 Nov 30; 01=Invoic e number; C12345=Obl igation Nu mber , CCRS Invoi ce is gene rated and the Invoic e Number i s 19 chara cters wher e where N= Network; 1 =Region; 1 81130=2018 Nov 30; 0 1=Invoice number; C1 2345=Oblig ation Numb er , | ||
630 | 5,Run Stor ed Prodece dure in da tabase ( S SMS) to va lidate the display o f data val ue against mapping d ocument,Da ta display s correctl y against mapping do cument,Dat a displays correctly against m apping doc ument, | ||
631 | |||
632 | |||
633 | TC2- CS027 ,Validatio n of Mult iple IPPS Invoice Nu mbers when amount is more than $9,999,99 9.99, | ||
634 | |||
635 | Test objec tive:,To V alidate Mu ltiple( Mo re than 1) CCRS Invo ices are g enerated a nd Invoice Number se quence cha nges, | ||
636 | Roles impa cted:, | ||
637 | Test setup /Precondit ions:,Syst em has alr eady proce ssed the c laim and C laims are approved. 1. Access to CCRS Da tabase usi ng Report Builder, 2 . Access t o CCRS dat abase usin g SQL Serv er Managem ent Studio , , | ||
638 | Work Item Story:,664 425, | ||
639 | Acceptance criteria, Multiple C CRS Invoic es are gen erated and Invoice A mount disp lays accur ately on t he invoice s, | ||
640 | QM Test ID , | ||
641 | Assumption s:,All moc k tables h ave been c reated., | ||
642 | |||
643 | |||
644 | |||
645 | TS2- CS027 - RQM Scri pt # :,Val idation of IPPS Invo ice Number when amou nt is more than $9,9 99,999.99, | ||
646 | Step numbe r,Descript ion,Expect ed results ,Actual Re sult, | ||
647 | 1,Connect to CCRS DB using Rep ort Builde r,Connecti on to Repo rt Builder is Succes sful,Conne ction to R eport Buil der is Suc cessful, | ||
648 | 2, Run a R eport,Repo rt Opens,R eport Open s, | ||
649 | 3,Export t he report in PDF For mat,PDF Fo rmat is ge nerated.,P DF Format is generat ed., | ||
650 | 4,Verify M ultiple( M ore than 1 ) CCRS Inv oices are generated and Invoic e Number s equence ch anges. No te: Invoic e Number i s 19 chara cters wher e where N= Network; 1 =Region; 1 81130=2018 Nov 30; 0 1=Invoice number( Se quence of invoice nu mber will change); C 12345=Obli gation Num ber ,Multi ple( More than 1) CC RS Invoice s are gene rated and Invoice Nu mber seque nce change s. Invoice Number is 19 charac ters where where N=N etwork; 1= Region; 18 1130=2018 Nov 30; 01 =Invoice n umber( Seq uence of i nvoice num ber will c hange); C1 2345=Oblig ation Numb er ,Mul tiple( Mor e than 1) CCRS Invoi ces are ge nerated an d Invoice Number seq uence chan ges. Invoi ce Number is 19 char acters whe re where N =Network; 1=Region; 181130=201 8 Nov 30; 01=Invoice number( S equence of invoice n umber will change); C12345=Obl igation Nu mber , | ||
651 | 5,Run Stor ed procedu re in data base ( SSM S) to vali date the d isplay of data value against m apping doc ument,Data displays correctly against ma pping docu ment,Data displays c orrectly a gainst map ping docum ent, | ||
652 | |||
653 | TC3 - CS02 7,Validati on of IPPS Invoice N umber for more than one Region , | ||
654 | |||
655 | Test objec tive:,To V alidate CC RS Invoice s are gene rated and Invoice Nu mber seque nce change s, | ||
656 | Roles impa cted:, | ||
657 | Test setup /Precondit ions:,Syst em has alr eady proce ssed the c laim and C laims are approved. 1. Access to CCRS Da tabase usi ng Report Builder, 2 . Access t o CCRS dat abase usin g SQL Serv er Managem ent Studio , , | ||
658 | Work Item Story:,664 425, | ||
659 | Acceptance criteria, Multiple C CRS Invoic es are gen erated and Invoice A mount disp lays accur ately on t he invoice s, | ||
660 | QM Test ID , | ||
661 | Assumption s:,All moc k tables h ave been c reated., | ||
662 | |||
663 | |||
664 | |||
665 | TS3- CS027 - RQM Scri pt # :,Val idation of IPPS Invo ice Number for more than one R egion, | ||
666 | Step numbe r,Descript ion,Expect ed results ,Actual Re sult, | ||
667 | 1,Connect to CCRS DB using Rep ort Builde r,Connecti on to Repo rt Builder is Succes sful,Conne ction to R eport Buil der is Suc cessful, | ||
668 | 2, Run a R eport,Repo rt Opens,R eport Open s, | ||
669 | 3,Export t he report in PDF Fo rmat,PDF F ormat is g enerated., PDF Format is genera ted., | ||
670 | 4,CCRS Inv oices are generated and Invoic e Number N etwork Reg ion sequen ce changes . Please N ote: Invoi ce Number is 19 char acters whe re where N =Network; 1=Region( Region Seq uence Numb er Changes in this c ase); 1811 30=2018 No v 30; 01=I nvoice num ber; C1234 5=Obligati on Number , CCRS Inv oices are generated and Invoic e Number N etwork Reg ion sequen ce changes . Invoice Number is 19 charact ers where where N=Ne twork; 1=R egion( Reg ion Sequen ce Number Changes in this case ); 181130= 2018 Nov 3 0; 01=Invo ice number ; C12345=O bligation Number , CCRS Inv oices are generated and Invoic e Number N etwork Reg ion sequen ce changes . Invoice Number is 19 charact ers where where N=Ne twork; 1=R egion( Reg ion Sequen ce Number Changes in this case ); 181130= 2018 Nov 3 0; 01=Invo ice number ; C12345=O bligation Number , | ||
671 | 5,Query da tabase ( S SMS) to va lidate the display o f data val ue against mapping d ocument,Da ta display s correctl y against mapping do cument,Dat a displays correctly against m apping doc ument, | ||
672 | |||
673 | TC6 - CS02 7,Validati on of Tax Id for all the regio ns, | ||
674 | |||
675 | Test objec tive:,To V alidate Ta x Id is un ique for d ifferent r egions, | ||
676 | Roles impa cted:, | ||
677 | Test setup /Precondit ions:,Syst em has alr eady proce ssed the c laim and C laims are approved. 1. Access to CCRS Da tabase usi ng Report Builder 2. Access to CCRS data base using SQL Serve r Manageme nt Studio , , | ||
678 | Work Item Story:,664 425, | ||
679 | Acceptance Criteria, Tax ID is unique for all the r egions, | ||
680 | QM Test ID , | ||
681 | Assumption s:,All moc k tables h ave been c reated., | ||
682 | |||
683 | |||
684 | |||
685 | TS6- CS006 - RQM Scr ipt # :,Va lidation o f Tax Id f or all the regions, | ||
686 | Step numbe r,Descript ion,Expect ed results ,Actual Re sult, | ||
687 | 1,Connect to CCRS DB using Rep ort Builde r,Connecti on to Repo rt Builder is Succes sful,Conne ction to R eport Buil der is Suc cessful, | ||
688 | 2,Run a Re port,Repor t Opens,Re port Opens , | ||
689 | 3,Export t he report in PDF Fo rmat ,PDF Format is generated ,PDF Forma t is gener ated , | ||
690 | 4,Verify s ystem is a ble to pop ulate uniq ue Tax ID for each r egion.,Ver ify system is able t o populate unique Ta x ID for e ach region .,Verify s ystem is a ble to pop ulate uniq ue Tax ID for each r egion., | ||
691 | 5,Run Stor ed procedu re in data base ( SSM S) to vali date the d isplay of data value against m apping doc ument,Data displays correctly against ma pping docu ment,Data displays c orrectly a gainst map ping docum ent, | ||
692 | |||
693 | TC1 - CS02 7,Validati on of IPPS report sh ell fields to map to the CCRS Database t o show lum psum invoi ce amount for all th e approved claims, | ||
694 | |||
695 | Test objec tive:,To V alidate CC RS Invoice is genera ted and In voice Amou nt display s as $9,99 9,999.99, | ||
696 | Roles impa cted:, | ||
697 | Test setup /Precondit ions:,Syst em has alr eady proce ssed the c laim and C laims are approved. 1. Access to CCRS Da tabase usi ng Report Builder 2. Access to CCRS data base using SQL Serve r Manageme nt Studio , , | ||
698 | Work Item Story:,651 845, | ||
699 | Acceptance criteria, CCRS Invoi ce is gene rated and Invoice Am ount displ ays as $9, 999,999.99 , | ||
700 | QM Test ID , | ||
701 | Assumption s:,All moc k tables h ave been c reated., | ||
702 | |||
703 | |||
704 | |||
705 | TS1- CS027 - RQM Scr ipt # :,Va lidation o f CCRS In voice when Invoice a mount is $9,999,999 .99 , | ||
706 | Step numbe r,Descript ion,Expect ed results ,Actual Re sult, | ||
707 | 1,Connect to CCRS DB using Rep ort Builde r,Connecti on to Repo rt Builder is Succes sful,Conne ction to R eport Buil der is Suc cessful, | ||
708 | 2, Run a R eport,Repo rt Opens,R eport Open s, | ||
709 | 3,Export t he data in PDF Form at ,PDF Fo rmat is ge nerated,PD F Format i s generate d, | ||
710 | 4,Verify C CRS Invoic e is gener ated and I nvoice Amo unt is $9, 999,999.99 ,CC RS Invoice is genera ted and In voice Amou nt is $9,9 99,999.99 ,CCR S Invoice is generat ed and Inv oice Amoun t is $9,99 9,999.99 . ,Since we don’t have enough da ta to test we set th e lumpsum to be $14, 999.99, | ||
711 | 5,Query da tabase ( S SMS) to va lidate the display o f data val ue against mapping d ocument,Da ta display s correctl y against mapping do cument,Dat a displays correctly against m apping doc ument, | ||
712 | |||
713 | TC3 - CS02 7,Validati on of IPPS Invoice i n pdf when Invoice A mount is l ess than $ 9,999,999. 99, | ||
714 | |||
715 | Test objec tive:,To V alidate CC RS Invoice is genera ted and In voice Amou nt display s accurate ly, | ||
716 | Roles impa cted:, | ||
717 | Test setup /Precondit ions:,Syst em has alr eady proce ssed the c laim and C laims are approved. 1. Access to CCRS Da tabase usi ng Report Builder 2. Access to CCRS data base using SQL Serve r Manageme nt Studio , , | ||
718 | Work Item Story:,651 845, | ||
719 | Acceptance criteria, CCRS Invoi ce is gene rated and Invoice Am ount displ ays accura tely, | ||
720 | QM Test ID , | ||
721 | Assumption s:,All moc k tables h ave been c reated., | ||
722 | |||
723 | TS3- CS027 - RQM Scr ipt # :,Va lidation o f IPPS Inv oice in pd f when Inv oice Amoun t is less than $9,99 9,999.99, | ||
724 | Step numbe r,Descript ion,Expect ed results ,Actual Re sult, | ||
725 | 1,Connect to CCRS DB using Rep ort Builde r.,Connect ion to Rep ort Builde r is succe ssful,Conn ection to Report Bui lder is su ccessful, | ||
726 | 2,Run a Re port.,Repo rt Opens., Report Ope ns., | ||
727 | 3,Export t he report in PDF Fo rmat.,PDF Format is generated. ,PDF Forma t is gener ated., | ||
728 | 4,Verify C CRS Invoic e is gener ated and t he Invoice amount is generated accuratel y. ,CCRS Invoice i s generate d and the Invoice am ount is ge nerated ac curately. ,CCRS Invo ice is gen erated and the Invoi ce amount is generat ed accurat ely. , | ||
729 | 5,Query da tabase ( S SMS) to va lidate the display o f data val ue against mapping d ocument,Da ta display s correctl y against mapping do cument,Dat a displays correctly against m apping doc ument, | ||
730 | |||
731 | TC4 - CS02 7,Validati on of IPPS in pdf wh en amount is more th an $9,999, 999.99, | ||
732 | |||
733 | Test objec tive:,To V alidate Mu ltiple( Mo re than 1) CCRS Invo ices are g enerated a nd Invoice Amount di splays acc urately on all the i nvoices, | ||
734 | Roles impa cted:, | ||
735 | Test setup /Precondit ions:,Syst em has alr eady proce ssed the c laim and C laims are approved. 1. Access to CCRS Da tabase usi ng Report Builder, 2 . Access t o CCRS dat abase usin g SQL Serv er Managem ent Studio , , | ||
736 | Work Item Story:,651 845, | ||
737 | Acceptance criteria, Multiple C CRS Invoic es are gen erated and Invoice A mount disp lays accur ately on t he invoice s, | ||
738 | QM Test ID , | ||
739 | Assumption s:,All moc k tables h ave been c reated., | ||
740 | |||
741 | TS4- CS027 - RQM Scri pt # :,Val idation of IPPS in p df when am ount is mo re than $9 ,999,999.9 9, | ||
742 | Step numbe r,Descript ion,Expect ed results ,Actual Re sult, | ||
743 | 1,Connect to CCRS DB using Rep ort Builde r,Connecti on to Repo rt Builder is Succes sful,Conne ction to R eport Buil der is Suc cessful, | ||
744 | 2, Run a R eport,Repo rt Opens,R eport Open s, | ||
745 | 3,Export t he report in PDF Fo rmat,PDF F ormat is g enerated., PDF Format is genera ted., | ||
746 | 4,Verify Multiple( More than 1) CCRS In voices are generated and Invoi ce Amount displays a ccurately on all the invoices ,M ultiple( M ore than 1 ) CCRS Inv oices are generated and Invoic e Amount d isplays ac curately o n all the invoices,M ultiple( M ore than 1 ) CCRS Inv oices are generated and Invoic e Amount d isplays ac curately o n all the invoices, | ||
747 | 5,Run a St ored Proce dure datab ase ( SSMS ) to valid ate the di splay of d ata value against ma pping docu ment,Data displays c orrectly a gainst map ping docum ent,Data d isplays co rrectly ag ainst mapp ing docume nt, | ||
748 | |||
749 | TC5 - CS02 7,Validati on of CCRS Invoice when Invoi ce amount is $0, | ||
750 | |||
751 | Test objec tive:,To V alidate IP PS Invoice is not ge nerated wh en Invoice Amount is Null, | ||
752 | Roles impa cted:, | ||
753 | Test setup /Precondit ions:,No C laims are approved. 1. Access to CCRS D atabase us ing Report Builder 2 . Access t o CCRS dat abase usin g SQL Serv er Managem ent Studio , , | ||
754 | Work Item Story:,651 845, | ||
755 | Acceptance criteria, CCRS Invoi ce is not generated , | ||
756 | QM Test ID , | ||
757 | Assumption s:,Mock ta bles have been creat ed., | ||
758 | |||
759 | TS5- CS027 - RQM Scr ipt # :,Va lidation o f CCRS In voice when Invoice a mount is $0, | ||
760 | Step numbe r,Descript ion,Expect ed results ,Actual Re sult, | ||
761 | 1,Query da tabase ( S SMS) to va lidate inv oice amoun t is $0,Da ta display s correctl y and the invoice am ount is $0 ,Data disp lays corre ctly and t he invoice amount is $0, | ||
762 | 2, Run a R eport in R eport Buil der, Repor t Runs, Re port Runs, | ||
763 | 3,Verify C CRS Invoic e is not generated ,CCR S Invoice is not ge nerated , CCRS Invoi ce is not generated , | ||
764 | |||
765 | TC6 - CS02 7,Validati on of IPPS Invoice i n pdf when Invoice A mount is l ess than $ 9,999,999. 99, | ||
766 | |||
767 | Test objec tive:,To V alidate CC RS Invoice is genera ted and In voice Amou nt display s accurate ly, | ||
768 | Roles impa cted:, | ||
769 | Test setup /Precondit ions:,Syst em has alr eady proce ssed the c laim and C laims are approved. 1. Access to CCRS Da tabase usi ng Report Builder 2. Access to CCRS data base using SQL Serve r Manageme nt Studio , , | ||
770 | Work Item Story:,651 845, | ||
771 | Acceptance criteria, CCRS Invoi ce is gene rated and Invoice Am ount displ ays accura tely, | ||
772 | QM Test ID , | ||
773 | Assumption s:,All moc k tables h ave been c reated., | ||
774 | |||
775 | TS6- CS027 - RQM Scr ipt # :,Va lidation o f IPPS Inv oice in pd f when Inv oice Amoun t is less than $9,99 9,999.99, | ||
776 | Step numbe r,Descript ion,Expect ed results ,Actual Re sult, | ||
777 | 1,Connect to CCRS DB using Rep ort Builde r.,Connect ion to Rep ort Builde r is succe ssful,Conn ection to Report Bui lder is su ccessful, | ||
778 | 2,Run a Re port.,Repo rt Opens., Report Ope ns., | ||
779 | 3,Export t he report in PDF Fo rmat.,PDF Format is generated. ,PDF Forma t is gener ated., | ||
780 | 4,Verify C CRS Invoic e is gener ated and t he Invoice amount is generated accuratel y. ,CCRS Invoice i s generate d and the Invoice am ount is ge nerated ac curately. ,CCRS Invo ice is gen erated and the Invoi ce amount is generat ed accurat ely. , | ||
781 | 5,Run a St ored Proce dure in da tabase ( S SMS) to va lidate the display o f data val ue against mapping d ocument,Da ta display s correctl y against mapping do cument,Dat a displays correctly against m apping doc ument, | ||
782 | |||
783 | TC7 - CS02 7,Validati on of the Lumpsum am ount inclu des all th e 4 types of care wh ich is – D ental, pha rmacy, Ins titutional , Professi onal, | ||
784 | |||
785 | Test objec tive:,Clai m_Key tell s you what kind of c laim. Clai m_Key_Deta ils will t ell you wh ich F Tabl e (Types o f Care I nstitution al – I; Pr ofessional – P; Dent al – D; NC PDP – Phar macy (I., P., D., NC PDP) | ||
786 | Look at. c laim_detai l_key link s to claim _key from one table to another (tying cl aim to a t ype of car e and if d ecision) | ||
787 | |||
788 | Find the A pproved ch arge amoun t on the F Tables. T he charge amount on the DIM_V A_Claim ta ble has th e amount s ubmitted t o be reimb ursed but not necess arily all of them ar e Approved , | ||
789 | Roles impa cted:, | ||
790 | Test setup /Precondit ions:,All Claims are approved. 1. Acces s to CCRS Database u sing Repor t Builder 2. Access to CCRS da tabase usi ng SQL Ser ver Manage ment Studi o , , | ||
791 | Work Item Story:,651 845, | ||
792 | Acceptance criteria, Lumpsum am ount is in cludes all the 4 typ es of care which is – Dental, pharmacy, Institutio nal, Profe ssional?, | ||
793 | QM Test ID , | ||
794 | Assumption s:,Mock ta bles have been creat ed., | ||
795 | |||
796 | TS7- CS027 - RQM Scr ipt # :,Va lidation o f the Lump sum amount from all the 4 type s of care which is – Dental, p harmacy, I nstitution al, Profes sional per Tax ID, | ||
797 | Step numbe r,Descript ion,Expect ed results ,Actual Re sult, | ||
798 | 1,Connect to CCRS DB using Rep ort Builde r,Connecti on to Repo rt Builder is Succes sful,Conne ction to R eport Buil der is Suc cessful, | ||
799 | 2, Run a R eport,Repo rt Opens,R eport Open s, | ||
800 | 3,Export t he report in PDF Fo rmat,PDF F ormat is g enerated., PDF Format is genera ted., | ||
801 | 4,Validate Stored Pr ocedure in cludes all 4 cares , Stored P rocedure i ncludes al l 4 cares , Stored Procedure includes a ll 4 care s , | ||
802 | |||
803 | |||
804 | SHEET: Inv oice | ||
805 | 1st Report , | ||
806 | Version 2. 0 Report, | ||
807 | Line Level Itemized IPPS Repor t, | ||
808 | Approved D esign, | ||
809 | |||
810 | |||
811 | SHEET: She et1 | ||
812 | Select *, | ||
813 | From ccra .Referral where Refe rralNumber IN ( 'VA0 000000122' ,'varef000 4','VAREF0 006','VARE F0002','VA REF0028'), |
Araxis Merge (but not the data content of this report) is Copyright © 1993-2016 Araxis Ltd (www.araxis.com). All rights reserved.