--------------------------------------------------------------------------- NEW CLAIM20042016 14:08:35|7034288|Rambo INCORRECT LOGIN --------------------------------------------------------------------------- NEW CLAIM20042016 14:08:47|7034289|TEST INCORRECT LOGIN --------------------------------------------------------------------------- NEW CLAIM20042016 14:09:40|7034288|TEST QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', 'F', '0', '7034288','0188336', '0001797100', '000179710', 0, 'NULL', 'DISC01', 4, 'A', 'ADEL', 'JOHNSON', 'L11122', 1, '11-MAR-2015', '11001', '1', 'CONSULT 1', '200.00', '2.00', '1.00', '3.00', '5.00', '4.00', '6.00', 'J45') RESULT:355||M|0.00 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', '', '355', '7034288','0188336', '0001797100', '000179710', 0, 'NULL', 'DISC01', 4, 'A', 'ADEL', 'JOHNSON', 'L11122', 2, '11-MAR-2015', '11001', '1', 'CONSULT 2', '200.00', '2.00', '1.00', '3.00', '5.00', '4.00', '6.00', 'J45') RESULT:355||M|0.00 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', 'L', '355', '7034288','0188336', '0001797100', '000179710', 0, 'NULL', 'DISC01', 4, 'A', 'ADEL', 'JOHNSON', 'L11122', 3, '11-MAR-2015', '11001', '1', 'CONSULT 3', '300.00', '2.00', '1.00', '3.00', '5.00', '4.00', '6.00', 'J45') RESULT:|603858|M|0.00 --------------------------------------------------------------------------- NEW CLAIM21042016 15:34:24|7034288|TEST QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', 'F', '0', '7034288','0188336', '0001797100', '000179710', 0, 'NULL', 'DISC01', 4, 'A', 'ADEL', 'JOHNSON', 'L11122', 1, '10-MAR-2015', '11001', '1', 'CONSULT 1', '100.00', '2.00', '1.00', '3.00', '5.00', '4.00', '6.00', 'J45') RESULT:356||M|0.00 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', '', '356', '7034288','0188336', '0001797100', '000179710', 0, 'NULL', 'DISC01', 4, 'A', 'ADEL', 'JOHNSON', 'L11122', 2, '10-MAR-2015', '11001', '1', 'CONSULT 2', '200.00', '2.00', '1.00', '3.00', '5.00', '4.00', '6.00', 'J45') RESULT:356||M|0.00 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', 'L', '356', '7034288','0188336', '0001797100', '000179710', 0, 'NULL', 'DISC01', 4, 'A', 'ADEL', 'JOHNSON', 'L11122', 3, '10-MAR-2015', '11001', '1', 'CONSULT 3', '300.00', '2.00', '1.00', '3.00', '5.00', '4.00', '6.00', 'J45') RESULT:|603859|M|0.00 --------------------------------------------------------------------------- NEW CLAIM22042016 16:52:48|7034288|TEST QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', 'F', '0', '7034288','0188336', '0001797100', '000179710', 0, 'NULL', 'DISC01', 4, 'A', 'ADEL', 'JOHNSON', 'L11122', 1, '10-MAR-2015', '11001', '1', 'CONSULT 1', '100.00', '2.00', '1.00', '3.00', '5.00', '4.00', '6.00', 'J45') RESULT:357||M|0.00 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', '', '357', '7034288','0188336', '0001797100', '000179710', 0, 'NULL', 'DISC01', 4, 'A', 'ADEL', 'JOHNSON', 'L11122', 2, '10-MAR-2015', '11001', '1', 'CONSULT 2', '200.00', '2.00', '1.00', '3.00', '5.00', '4.00', '6.00', 'J45') RESULT:357||M|0.00 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', 'L', '357', '7034288','0188336', '0001797100', '000179710', 0, 'NULL', 'DISC01', 4, 'A', 'ADEL', 'JOHNSON', 'L11122', 3, '10-MAR-2015', '11001', '1', 'CONSULT 3', '300.00', '2.00', '1.00', '3.00', '5.00', '4.00', '6.00', 'J45') RESULT:|603860|M|0.00 --------------------------------------------------------------------------- NEW CLAIM26042016 12:36:47|7034288|TEST QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', 'F', '0', '7034288','0188336', '0001797100', '000179710', 0, 'NULL', 'DISC01', 4, 'A', 'ADEL', 'JOHNSON', 'L11122', 1, '10-MAR-2015', '11001', '1', 'CONSULT 1', '100.00', '2.00', '1.00', '3.00', '5.00', '4.00', '6.00', 'J45') RESULT:358||M|0.00 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', '', '358', '7034288','0188336', '0001797100', '000179710', 0, 'NULL', 'DISC01', 4, 'A', 'ADEL', 'JOHNSON', 'L11122', 2, '10-MAR-2015', '11001', '1', 'CONSULT 2', '200.00', '2.00', '1.00', '3.00', '5.00', '4.00', '6.00', 'J45') RESULT:358||M|0.00 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', 'L', '358', '7034288','0188336', '0001797100', '000179710', 0, 'NULL', 'DISC01', 4, 'A', 'ADEL', 'JOHNSON', 'L11122', 3, '10-MAR-2015', '11001', '1', 'CONSULT 3', '300.00', '2.00', '1.00', '3.00', '5.00', '4.00', '6.00', 'J45') RESULT:|603861|M|0.00 --------------------------------------------------------------------------- NEW CLAIM26042016 12:52:27|7034288|TEST|146.232.211.251 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', 'F', '0', '7034288','0188336', '0001797100', '000179710', 0, 'NULL', 'DISC01', 4, 'A', 'ADEL', 'JOHNSON', 'L11122', 1, '10-MAR-2015', '11001', '1', 'CONSULT 1', '100.00', '2.00', '1.00', '3.00', '5.00', '4.00', '6.00', 'J45') RESULT:359||M|0.00 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', '', '359', '7034288','0188336', '0001797100', '000179710', 0, 'NULL', 'DISC01', 4, 'A', 'ADEL', 'JOHNSON', 'L11122', 2, '10-MAR-2015', '11001', '1', 'CONSULT 2', '200.00', '2.00', '1.00', '3.00', '5.00', '4.00', '6.00', 'J45') RESULT:359||M|0.00 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', 'L', '359', '7034288','0188336', '0001797100', '000179710', 0, 'NULL', 'DISC01', 4, 'A', 'ADEL', 'JOHNSON', 'L11122', 3, '10-MAR-2015', '11001', '1', 'CONSULT 3', '300.00', '2.00', '1.00', '3.00', '5.00', '4.00', '6.00', 'J45') RESULT:|603862|M|0.00 --------------------------------------------------------------------------- NEW CLAIM26042016 12:54:24|7034288|TEST|146.232.211.251 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', 'F', '0', '7034288','0188336', '0001797100', '000179710', 0, 'NULL', 'DISC01', 4, 'A', 'ADEL', 'JOHNSON', 'L11122', 1, '10-MAR-2015', '11001', '1', 'CONSULT 1', '100.00', '2.00', '1.00', '3.00', '5.00', '4.00', '6.00', 'J45') RESULT:360||M|0.00 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', '', '360', '7034288','0188336', '0001797100', '000179710', 0, 'NULL', 'DISC01', 4, 'A', 'ADEL', 'JOHNSON', 'L11122', 2, '10-MAR-2015', '11001', '1', 'CONSULT 2', '200.00', '2.00', '1.00', '3.00', '5.00', '4.00', '6.00', 'J45') RESULT:360||M|0.00 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', 'L', '360', '7034288','0188336', '0001797100', '000179710', 0, 'NULL', 'DISC01', 4, 'A', 'ADEL', 'JOHNSON', 'L11122', 3, '10-MAR-2015', '11001', '1', 'CONSULT 3', '300.00', '2.00', '1.00', '3.00', '5.00', '4.00', '6.00', 'J45') RESULT:|603863|M|0.00 CLA|0|Claim Received|600.00|0.00|M|H12345|603863 ITM|1|11001|100.00|0.00|M|MANUAL INTERVENTION REQUIRED|006 ITM|2|11001|200.00|0.00|M|MANUAL INTERVENTION REQUIRED|006 ITM|3|11001|300.00|0.00|M|MANUAL INTERVENTION REQUIRED|006--------------------------------------------------------------------------- NEW CLAIM26042016 13:22:09|7034288|TEST|196.33.235.59 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', 'F', '0', '7034288','0188336', '0001797100', '000179710', 0, 'NULL', 'DISC01', 4, 'A', 'ADEL', 'JOHNSON', 'L11122', 1, '10-MAR-2015', '11001', '1', 'CONSULT 1', '100.00', '2.00', '1.00', '3.00', '5.00', '4.00', '6.00', 'J45') RESULT:361||M|0.00 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', '', '361', '7034288','0188336', '0001797100', '000179710', 0, 'NULL', 'DISC01', 4, 'A', 'ADEL', 'JOHNSON', 'L11122', 2, '10-MAR-2015', '11001', '1', 'CONSULT 2', '200.00', '2.00', '1.00', '3.00', '5.00', '4.00', '6.00', 'J45') RESULT:361||M|0.00 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', 'L', '361', '7034288','0188336', '0001797100', '000179710', 0, 'NULL', 'DISC01', 4, 'A', 'ADEL', 'JOHNSON', 'L11122', 3, '10-MAR-2015', '11001', '1', 'CONSULT 3', '300.00', '2.00', '1.00', '3.00', '5.00', '4.00', '6.00', 'J45') RESULT:|603864|M|0.00 CLA|0|Claim Received|600.00|0.00|M|H12345|603864 ITM|1|11001|100.00|0.00|M|MANUAL INTERVENTION REQUIRED|006 ITM|2|11001|200.00|0.00|M|MANUAL INTERVENTION REQUIRED|006 ITM|3|11001|300.00|0.00|M|MANUAL INTERVENTION REQUIRED|006--------------------------------------------------------------------------- NEW CLAIM26042016 14:10:16|7034288 |TEST |196.33.235.59 CLA|14|Healthbridge Switch ID not populated|0|0|E|99999 --------------------------------------------------------------------------- NEW CLAIM26042016 14:43:45|7034288 |TEST |196.33.235.59 CLA|16|PROVIDER IN DISPUTE OR NOT CONTRACTED|0|0|E|160426134346080wvo9d5y--------------------------------------------------------------------------- NEW CLAIM26042016 14:45:54|7034288 |TEST |196.33.235.59 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', 'F', '0', '7034288 ','0188336', '0398963900', '039896390', 0, '', 'DISC01', 4, 'S', 'SOLOMON', 'MOLATLHEGI', '', 1, '25-APR-2016', '11001', '1.00', 'Discovery Health, Optometric E', '456.00', '', '', '', '', '', '', '') RESULT:362||M|0.00 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', '', '362', '7034288 ','0188336', '0398963900', '039896390', 0, '', 'DISC01', 4, 'S', 'SOLOMON', 'MOLATLHEGI', '', 2, '25-APR-2016', '80011', '1.00', 'Discovery Health, Single Visio', '255.00', '-1.50', '-0.25', '58', '', '', '', '') RESULT:362||M|0.00 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', '', '362', '7034288 ','0188336', '0398963900', '039896390', 0, '', 'DISC01', 4, 'S', 'SOLOMON', 'MOLATLHEGI', '', 3, '25-APR-2016', '80011', '1.00', 'Discovery Health, Single Visio', '255.00', '', '', '', '-1.75', '-0.00', '0', '') RESULT:362||M|0.00 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', '', '362', '7034288 ','0188336', '0398963900', '039896390', 0, '', 'DISC01', 4, 'S', 'SOLOMON', 'MOLATLHEGI', '', 4, '25-APR-2016', '80598', '1.00', 'KF SV PROTECTYOUREYES 1.53 ARC', '871.00', '-1.50', '-0.25', '58', '', '', '', '') RESULT:362||M|0.00 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', '', '362', '7034288 ','0188336', '0398963900', '039896390', 0, '', 'DISC01', 4, 'S', 'SOLOMON', 'MOLATLHEGI', '', 5, '25-APR-2016', '80598', '1.00', 'KF SV PROTECTYOUREYES 1.53 ARC', '871.00', '', '', '', '-1.75', '-0.00', '0', '') RESULT:362||M|0.00 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', '', '362', '7034288 ','0188336', '0398963900', '039896390', 0, '', 'DISC01', 4, 'S', 'SOLOMON', 'MOLATLHEGI', '', 6, '25-APR-2016', '46016', '1.00', 'Discovery Health, Fitting Nylo', '299.00', '-1.50', '-0.25', '58', '', '', '', '') RESULT:362||M|0.00 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', 'L', '362', '7034288 ','0188336', '0398963900', '039896390', 0, '', 'DISC01', 4, 'S', 'SOLOMON', 'MOLATLHEGI', '', 7, '25-APR-2016', '46016', '1.00', 'Discovery Health, Fitting Nylo', '299.00', '', '', '', '-1.75', '-0.00', '0', '') RESULT:|603865|M|0.00 CLA|0|Claim Received|330600|0.00|M|160426134556973lizxv54|603865 ITM|1|11001|456.00|0.00|M|MANUAL INTERVENTION REQUIRED|006 ITM|2|80011|255.00|0.00|M|MANUAL INTERVENTION REQUIRED|006 ITM|3|80011|255.00|0.00|M|MANUAL INTERVENTION REQUIRED|006 ITM|4|80598|871.00|0.00|M|MANUAL INTERVENTION REQUIRED|006 ITM|5|80598|871.00|0.00|M|MANUAL INTERVENTION REQUIRED|006 ITM|6|46016|299.00|0.00|M|MANUAL INTERVENTION REQUIRED|006 ITM|7|46016|299.00|0.00|M|MANUAL INTERVENTION REQUIRED|006--------------------------------------------------------------------------- NEW CLAIM16052016 15:58:33|7034288 |TEST |196.33.235.59 INCORRECT LOGIN --------------------------------------------------------------------------- NEW CLAIM16052016 16:01:09|7034288|TEST|196.33.235.59 INCORRECT LOGIN --------------------------------------------------------------------------- NEW CLAIM16052016 16:15:21|7034288|TEST|196.33.235.59 INCORRECT LOGIN --------------------------------------------------------------------------- NEW CLAIM16052016 16:29:16|7034288|TEST|146.232.211.251 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', 'F', '0', '7034288','0188336', '0001797100', '000179710', 0, 'NULL', 'DISC01', 4, 'A', 'ADEL', 'JOHNSON', 'L11122', 1, '10-MAR-2015', '11001', '1', 'CONSULT 1', '100.00', '2.00', '1.00', '3.00', '5.00', '4.00', '6.00', 'J45') RESULT:363||M|0.00 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', '', '363', '7034288','0188336', '0001797100', '000179710', 0, 'NULL', 'DISC01', 4, 'A', 'ADEL', 'JOHNSON', 'L11122', 2, '10-MAR-2015', '11001', '1', 'CONSULT 2', '200.00', '2.00', '1.00', '3.00', '5.00', '4.00', '6.00', 'J45') RESULT:363||M|0.00 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', 'L', '363', '7034288','0188336', '0001797100', '000179710', 0, 'NULL', 'DISC01', 4, 'A', 'ADEL', 'JOHNSON', 'L11122', 3, '10-MAR-2015', '11001', '1', 'CONSULT 3', '300.00', '2.00', '1.00', '3.00', '5.00', '4.00', '6.00', 'J45') RESULT:|603866|M|0.00 CLA|0|Claim Received|600.00|0.00|M|H12345|603866 ITM|1|11001|100.00|0.00|M|MANUAL INTERVENTION REQUIRED|006 ITM|2|11001|200.00|0.00|M|MANUAL INTERVENTION REQUIRED|006 ITM|3|11001|300.00|0.00|M|MANUAL INTERVENTION REQUIRED|006 --------------------------------------------------------------------------- NEW CLAIM16052016 16:33:27|7034288|TEST|196.33.235.59 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', 'F', '0', '7034288','0188336', '0001797100', '000179710', 0, 'NULL', 'DISC01', 4, 'A', 'ADEL', 'JOHNSON', 'L11122', 1, '10-MAR-2015', '11001', '1', 'CONSULT 1', '100.00', '2.00', '1.00', '3.00', '5.00', '4.00', '6.00', 'J45') RESULT:364||M|0.00 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', '', '364', '7034288','0188336', '0001797100', '000179710', 0, 'NULL', 'DISC01', 4, 'A', 'ADEL', 'JOHNSON', 'L11122', 2, '10-MAR-2015', '11001', '1', 'CONSULT 2', '200.00', '2.00', '1.00', '3.00', '5.00', '4.00', '6.00', 'J45') RESULT:364||M|0.00 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', 'L', '364', '7034288','0188336', '0001797100', '000179710', 0, 'NULL', 'DISC01', 4, 'A', 'ADEL', 'JOHNSON', 'L11122', 3, '10-MAR-2015', '11001', '1', 'CONSULT 3', '300.00', '2.00', '1.00', '3.00', '5.00', '4.00', '6.00', 'J45') RESULT:|603867|M|0.00 CLA|0|Claim Received|600.00|0.00|M|H12345|603867 ITM|1|11001|100.00|0.00|M|MANUAL INTERVENTION REQUIRED|006 ITM|2|11001|200.00|0.00|M|MANUAL INTERVENTION REQUIRED|006 ITM|3|11001|300.00|0.00|M|MANUAL INTERVENTION REQUIRED|006 --------------------------------------------------------------------------- NEW CLAIM16052016 16:44:09|7034288|TEST|196.33.235.59 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', 'F', '0', '7034288','0188336', '0001797100', '000179710', 0, 'NULL', 'DISC01', 4, 'A', 'ADEL', 'JOHNSON', 'L11122', 1, '10-MAR-2015', '11001', '1', 'CONSULT 1', '100.00', '2.00', '1.00', '3.00', '5.00', '4.00', '6.00', 'J45') RESULT:365||M|0.00 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', '', '365', '7034288','0188336', '0001797100', '000179710', 0, 'NULL', 'DISC01', 4, 'A', 'ADEL', 'JOHNSON', 'L11122', 2, '10-MAR-2015', '11001', '1', 'CONSULT 2', '200.00', '2.00', '1.00', '3.00', '5.00', '4.00', '6.00', 'J45') RESULT:365||M|0.00 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', 'L', '365', '7034288','0188336', '0001797100', '000179710', 0, 'NULL', 'DISC01', 4, 'A', 'ADEL', 'JOHNSON', 'L11122', 3, '10-MAR-2015', '11001', '1', 'CONSULT 3', '300.00', '2.00', '1.00', '3.00', '5.00', '4.00', '6.00', 'J45') RESULT:|603868|M|0.00 CLA|0|Claim Received|600.00|0.00|M|H12345|603868 ITM|1|11001|100.00|0.00|M|MANUAL INTERVENTION REQUIRED|006 ITM|2|11001|200.00|0.00|M|MANUAL INTERVENTION REQUIRED|006 ITM|3|11001|300.00|0.00|M|MANUAL INTERVENTION REQUIRED|006 --------------------------------------------------------------------------- NEW CLAIM16052016 17:15:28|7034288|TEST|196.33.235.59 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', 'F', '0', '7034288','0188336', '0001797100', '000179710', 0, 'NULL', 'DISC01', 4, 'A', 'ADEL', 'JOHNSON', 'L11122', 1, '10-MAR-2015', '11001', '1', 'CONSULT 1', '100.00', '2.00', '1.00', '3.00', '5.00', '4.00', '6.00', 'J45') RESULT:366||M|0.00 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', '', '366', '7034288','0188336', '0001797100', '000179710', 0, 'NULL', 'DISC01', 4, 'A', 'ADEL', 'JOHNSON', 'L11122', 2, '10-MAR-2015', '11001', '1', 'CONSULT 2', '200.00', '2.00', '1.00', '3.00', '5.00', '4.00', '6.00', 'J45') RESULT:366||M|0.00 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', 'L', '366', '7034288','0188336', '0001797100', '000179710', 0, 'NULL', 'DISC01', 4, 'A', 'ADEL', 'JOHNSON', 'L11122', 3, '10-MAR-2015', '11001', '1', 'CONSULT 3', '300.00', '2.00', '1.00', '3.00', '5.00', '4.00', '6.00', 'J45') RESULT:|603869|M|0.00 CLA|0|Claim Received|600.00|0.00|M|H12345|603869 ITM|1|11001|100.00|0.00|M|MANUAL INTERVENTION REQUIRED|006 ITM|2|11001|200.00|0.00|M|MANUAL INTERVENTION REQUIRED|006 ITM|3|11001|300.00|0.00|M|MANUAL INTERVENTION REQUIRED|006 --------------------------------------------------------------------------- NEW CLAIM16052016 17:19:36|7034288 |TEST |196.33.235.59 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', 'F', '0', '7034288 ','0188336', '0398963900', '039896390', 0, '', 'DISC01', 4, 'S', 'SOLOMON', 'MOLATLHEGI', '', 1, '16-MAY-2016', '11001', '1.00', 'Optometric Examination', '256.00', '', '', '', '', '', '', '') RESULT:367||M|0.00 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', '', '367', '7034288 ','0188336', '0398963900', '039896390', 0, '', 'DISC01', 4, 'S', 'SOLOMON', 'MOLATLHEGI', '', 2, '16-MAY-2016', '00099', '1.00', '124 012563', '0.00', '-1.50', '-0.25', '58', '', '', '', '') RESULT:367||M|0.00 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', '', '367', '7034288 ','0188336', '0398963900', '039896390', 0, '', 'DISC01', 4, 'S', 'SOLOMON', 'MOLATLHEGI', '', 3, '16-MAY-2016', '00098', '1.00', '12', '0.00', '-1.50', '-0.25', '58', '', '', '', '') RESULT:367||M|0.00 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', '', '367', '7034288 ','0188336', '0398963900', '039896390', 0, '', 'DISC01', 4, 'S', 'SOLOMON', 'MOLATLHEGI', '', 4, '16-MAY-2016', '00099', '1.00', '632 000562', '0.00', '', '', '', '-1.75', '-0.00', '0', '') RESULT:367||M|0.00 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', '', '367', '7034288 ','0188336', '0398963900', '039896390', 0, '', 'DISC01', 4, 'S', 'SOLOMON', 'MOLATLHEGI', '', 5, '16-MAY-2016', '00098', '1.00', '80', '0.00', '', '', '', '-1.75', '-0.00', '0', '') RESULT:367||M|0.00 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', 'L', '367', '7034288 ','0188336', '0398963900', '039896390', 0, '', 'DISC01', 4, 'S', 'SOLOMON', 'MOLATLHEGI', '', 6, '16-MAY-2016', '00100', '1.00', 'VAR22L10,IOPR15L0,VFRFullLFull', '0.00', '-1.50', '-0.25', '58', '-1.75', '-0.00', '0', '') RESULT:|603870|M|0.00 CLA|0|Claim Received|25600|0.00|M|160516161937497bft8qk3|603870 ITM|1|11001|256.00|0.00|M|MANUAL INTERVENTION REQUIRED|006 ITM|2|00099|0.00|0.00|M|MANUAL INTERVENTION REQUIRED|006 ITM|3|00098|0.00|0.00|M|MANUAL INTERVENTION REQUIRED|006 ITM|4|00099|0.00|0.00|M|MANUAL INTERVENTION REQUIRED|006 ITM|5|00098|0.00|0.00|M|MANUAL INTERVENTION REQUIRED|006 ITM|6|00100|0.00|0.00|M|MANUAL INTERVENTION REQUIRED|006 --------------------------------------------------------------------------- NEW CLAIM17052016 11:18:49|7034288|TEST|196.33.235.59 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', 'F', '0', '7034288','0188336', '0001797100', '000179710', 0, 'NULL', 'DISC01', 4, 'A', 'ADEL', 'JOHNSON', 'L11122', 1, '10-MAR-2015', '11001', '1', 'CONSULT 1', '100.00', '2.00', '1.00', '3.00', '5.00', '4.00', '6.00', 'J45') RESULT:368||M|0.00 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', '', '368', '7034288','0188336', '0001797100', '000179710', 0, 'NULL', 'DISC01', 4, 'A', 'ADEL', 'JOHNSON', 'L11122', 2, '10-MAR-2015', '11001', '1', 'CONSULT 2', '200.00', '2.00', '1.00', '3.00', '5.00', '4.00', '6.00', 'J45') RESULT:368||M|0.00 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', 'L', '368', '7034288','0188336', '0001797100', '000179710', 0, 'NULL', 'DISC01', 4, 'A', 'ADEL', 'JOHNSON', 'L11122', 3, '10-MAR-2015', '11001', '1', 'CONSULT 3', '300.00', '2.00', '1.00', '3.00', '5.00', '4.00', '6.00', 'J45') RESULT:|603871|M|0.00 CLA|0|Claim Received|600.00|0.00|M|H12345|603871 ITM|1|11001|100.00|0.00|M|MANUAL INTERVENTION REQUIRED|006 ITM|2|11001|200.00|0.00|M|MANUAL INTERVENTION REQUIRED|006 ITM|3|11001|300.00|0.00|M|MANUAL INTERVENTION REQUIRED|006 --------------------------------------------------------------------------- NEW CLAIM17052016 11:19:42|7034288 |TEST |196.33.235.59 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', 'F', '0', '7034288 ','0188336', '0398963900', '039896390', 0, '', 'DISC01', 4, 'S', 'SOLOMON', 'MOLATLHEGI', '', 1, '16-MAY-2016', '11001', '1.00', 'Optometric Examination', '256.00', '', '', '', '', '', '', '') RESULT:369||M|0.00 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', '', '369', '7034288 ','0188336', '0398963900', '039896390', 0, '', 'DISC01', 4, 'S', 'SOLOMON', 'MOLATLHEGI', '', 2, '16-MAY-2016', '00099', '1.00', '124 012563', '0.00', '-1.50', '-0.25', '58', '', '', '', '') RESULT:369||M|0.00 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', '', '369', '7034288 ','0188336', '0398963900', '039896390', 0, '', 'DISC01', 4, 'S', 'SOLOMON', 'MOLATLHEGI', '', 3, '16-MAY-2016', '00098', '1.00', '12', '0.00', '-1.50', '-0.25', '58', '', '', '', '') RESULT:369||M|0.00 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', '', '369', '7034288 ','0188336', '0398963900', '039896390', 0, '', 'DISC01', 4, 'S', 'SOLOMON', 'MOLATLHEGI', '', 4, '16-MAY-2016', '00099', '1.00', '632 000562', '0.00', '', '', '', '-1.75', '-0.00', '0', '') RESULT:369||M|0.00 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', '', '369', '7034288 ','0188336', '0398963900', '039896390', 0, '', 'DISC01', 4, 'S', 'SOLOMON', 'MOLATLHEGI', '', 5, '16-MAY-2016', '00098', '1.00', '80', '0.00', '', '', '', '-1.75', '-0.00', '0', '') RESULT:369||M|0.00 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', 'L', '369', '7034288 ','0188336', '0398963900', '039896390', 0, '', 'DISC01', 4, 'S', 'SOLOMON', 'MOLATLHEGI', '', 6, '16-MAY-2016', '00100', '1.00', 'VAR22L10,IOPR15L0,VFRFullLFull', '0.00', '-1.50', '-0.25', '58', '-1.75', '-0.00', '0', '') RESULT:|603872|M|0.00 CLA|0|Claim Received|25600|0.00|M|160517101943213v9ykka1|603872 ITM|1|11001|256.00|0.00|M|MANUAL INTERVENTION REQUIRED|006 ITM|2|00099|0.00|0.00|M|MANUAL INTERVENTION REQUIRED|006 ITM|3|00098|0.00|0.00|M|MANUAL INTERVENTION REQUIRED|006 ITM|4|00099|0.00|0.00|M|MANUAL INTERVENTION REQUIRED|006 ITM|5|00098|0.00|0.00|M|MANUAL INTERVENTION REQUIRED|006 ITM|6|00100|0.00|0.00|M|MANUAL INTERVENTION REQUIRED|006 --------------------------------------------------------------------------- NEW CLAIM17052016 11:21:16|7034288 |TEST |196.33.235.59 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', 'F', '0', '7034288 ','0188336', '0398963900', '039896390', 0, '', 'DISC01', 4, 'S', 'SOLOMON', 'MOLATLHEGI', '', 1, '16-MAY-2016', '11001', '1.00', 'Optometric Examination', '256.00', '', '', '', '', '', '', '') RESULT:370||M|0.00 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', '', '370', '7034288 ','0188336', '0398963900', '039896390', 0, '', 'DISC01', 4, 'S', 'SOLOMON', 'MOLATLHEGI', '', 2, '16-MAY-2016', '00099', '1.00', '124 012563', '0.00', '-1.50', '-0.25', '58', '', '', '', '') RESULT:370||M|0.00 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', '', '370', '7034288 ','0188336', '0398963900', '039896390', 0, '', 'DISC01', 4, 'S', 'SOLOMON', 'MOLATLHEGI', '', 3, '16-MAY-2016', '00098', '1.00', '12', '0.00', '-1.50', '-0.25', '58', '', '', '', '') RESULT:370||M|0.00 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', '', '370', '7034288 ','0188336', '0398963900', '039896390', 0, '', 'DISC01', 4, 'S', 'SOLOMON', 'MOLATLHEGI', '', 4, '16-MAY-2016', '00099', '1.00', '632 000562', '0.00', '', '', '', '-1.75', '-0.00', '0', '') RESULT:370||M|0.00 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', '', '370', '7034288 ','0188336', '0398963900', '039896390', 0, '', 'DISC01', 4, 'S', 'SOLOMON', 'MOLATLHEGI', '', 5, '16-MAY-2016', '00098', '1.00', '80', '0.00', '', '', '', '-1.75', '-0.00', '0', '') RESULT:370||M|0.00 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', 'L', '370', '7034288 ','0188336', '0398963900', '039896390', 0, '', 'DISC01', 4, 'S', 'SOLOMON', 'MOLATLHEGI', '', 6, '16-MAY-2016', '00100', '1.00', 'VAR22L10,IOPR15L0,VFRFullLFull', '0.00', '-1.50', '-0.25', '58', '-1.75', '-0.00', '0', '') RESULT:|603873|M|0.00 CLA|0|Claim Received|25600|0.00|M|1605171021191365hp92u4|603873 ITM|1|11001|256.00|0.00|M|MANUAL INTERVENTION REQUIRED|006 ITM|2|00099|0.00|0.00|M|MANUAL INTERVENTION REQUIRED|006 ITM|3|00098|0.00|0.00|M|MANUAL INTERVENTION REQUIRED|006 ITM|4|00099|0.00|0.00|M|MANUAL INTERVENTION REQUIRED|006 ITM|5|00098|0.00|0.00|M|MANUAL INTERVENTION REQUIRED|006 ITM|6|00100|0.00|0.00|M|MANUAL INTERVENTION REQUIRED|006 --------------------------------------------------------------------------- NEW CLAIM17052016 11:52:16|7034288 |TEST |196.33.235.59 CLA|2|Provider Not Found|0|0|E|160517105215352e7q5z1u --------------------------------------------------------------------------- NEW CLAIM17052016 11:56:43|7034288 |TEST |196.33.235.59 CLA|2|Provider Not Found|0|0|E|1605171056454039yxaxi0 --------------------------------------------------------------------------- NEW CLAIM17052016 12:15:38|7034288 |TEST |196.33.235.59 CLA|2|Provider Not Found|0|0|E|160517111538750fs2645c --------------------------------------------------------------------------- NEW CLAIM17052016 12:54:24|7034288 |TEST |196.33.235.59 CLA|2|Provider Not Found|0|0|E|16051711542533281gyk8p --------------------------------------------------------------------------- NEW CLAIM17052016 13:59:32|7034288 |TEST |196.33.235.59 CLA|2|Provider Not Found|0|0|E|160517125932689e7y8viw --------------------------------------------------------------------------- NEW CLAIM17052016 13:59:58|7034288 |TEST |196.33.235.59 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', 'F', '0', '7034288 ','0188336', '0398963900', '039896390', 0, '', 'DISC01', 4, 'S', 'SOLOMON', 'MOLATLHEGI', '', 1, '25-APR-2016', '11001', '1.00', 'Discovery Health, Optometric E', '456.00', '', '', '', '', '', '', '') RESULT:371||M|0.00 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', '', '371', '7034288 ','0188336', '0398963900', '039896390', 0, '', 'DISC01', 4, 'S', 'SOLOMON', 'MOLATLHEGI', '', 2, '25-APR-2016', '80011', '1.00', 'Discovery Health, Single Visio', '255.00', '-1.50', '-0.25', '58', '', '', '', '') RESULT:371||M|0.00 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', '', '371', '7034288 ','0188336', '0398963900', '039896390', 0, '', 'DISC01', 4, 'S', 'SOLOMON', 'MOLATLHEGI', '', 3, '25-APR-2016', '80011', '1.00', 'Discovery Health, Single Visio', '255.00', '', '', '', '-1.75', '-0.00', '0', '') RESULT:371||M|0.00 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', '', '371', '7034288 ','0188336', '0398963900', '039896390', 0, '', 'DISC01', 4, 'S', 'SOLOMON', 'MOLATLHEGI', '', 4, '25-APR-2016', '80598', '1.00', 'KF SV PROTECTYOUREYES 1.53 ARC', '871.00', '-1.50', '-0.25', '58', '', '', '', '') RESULT:371||M|0.00 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', '', '371', '7034288 ','0188336', '0398963900', '039896390', 0, '', 'DISC01', 4, 'S', 'SOLOMON', 'MOLATLHEGI', '', 5, '25-APR-2016', '80598', '1.00', 'KF SV PROTECTYOUREYES 1.53 ARC', '871.00', '', '', '', '-1.75', '-0.00', '0', '') RESULT:371||M|0.00 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', '', '371', '7034288 ','0188336', '0398963900', '039896390', 0, '', 'DISC01', 4, 'S', 'SOLOMON', 'MOLATLHEGI', '', 6, '25-APR-2016', '46016', '1.00', 'Discovery Health, Fitting Nylo', '299.00', '-1.50', '-0.25', '58', '', '', '', '') RESULT:371||M|0.00 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', 'L', '371', '7034288 ','0188336', '0398963900', '039896390', 0, '', 'DISC01', 4, 'S', 'SOLOMON', 'MOLATLHEGI', '', 7, '25-APR-2016', '46016', '1.00', 'Discovery Health, Fitting Nylo', '299.00', '', '', '', '-1.75', '-0.00', '0', '') RESULT:|603874|M|0.00 CLA|0|Claim Received|330600|0.00|M|16051713000098639tryht|603874 ITM|1|11001|456.00|0.00|M|MANUAL INTERVENTION REQUIRED|006 ITM|2|80011|255.00|0.00|M|MANUAL INTERVENTION REQUIRED|006 ITM|3|80011|255.00|0.00|M|MANUAL INTERVENTION REQUIRED|006 ITM|4|80598|871.00|0.00|M|MANUAL INTERVENTION REQUIRED|006 ITM|5|80598|871.00|0.00|M|MANUAL INTERVENTION REQUIRED|006 ITM|6|46016|299.00|0.00|M|MANUAL INTERVENTION REQUIRED|006 ITM|7|46016|299.00|0.00|M|MANUAL INTERVENTION REQUIRED|006 --------------------------------------------------------------------------- NEW CLAIM17052016 14:57:15|7034288 |TEST |196.33.235.59 CLA|2|Provider Not Found|0|0|E|160517135717258ey7hjcl --------------------------------------------------------------------------- NEW CLAIM17052016 16:03:28|7034288 |TEST |196.33.235.59 CLA|2|Provider Not Found|0|0|E|1605171503297415zuiosx --------------------------------------------------------------------------- NEW CLAIM17052016 16:39:18|7034288 |TEST |196.33.235.59 CLA|2|Provider Not Found|0|0|E|160517153919179fv4ke6u --------------------------------------------------------------------------- NEW CLAIM17052016 16:44:19|7034288 |TEST |196.33.235.59 CLA|2|Provider Not Found|0|0|E|160517154422965n7qh0a9 --------------------------------------------------------------------------- NEW CLAIM17052016 16:57:19|7034288 |TEST |196.33.235.59 CLA|2|Provider Not Found|0|0|E|16051715572107059n88km --------------------------------------------------------------------------- NEW CLAIM17052016 17:01:35|7034288 |TEST |196.33.235.59 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', 'F', '0', '7034288 ','0188336', '0398963900', '039896390', 0, '', 'DISC01', 4, 'S', 'SOLOMON', 'MOLATLHEGI', '', 1, '25-APR-2016', '11001', '1.00', 'Discovery Health, Optometric E', '456.00', '', '', '', '', '', '', '') RESULT:372||M|0.00 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', '', '372', '7034288 ','0188336', '0398963900', '039896390', 0, '', 'DISC01', 4, 'S', 'SOLOMON', 'MOLATLHEGI', '', 2, '25-APR-2016', '80011', '1.00', 'Discovery Health, Single Visio', '255.00', '-1.50', '-0.25', '58', '', '', '', '') RESULT:372||M|0.00 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', '', '372', '7034288 ','0188336', '0398963900', '039896390', 0, '', 'DISC01', 4, 'S', 'SOLOMON', 'MOLATLHEGI', '', 3, '25-APR-2016', '80011', '1.00', 'Discovery Health, Single Visio', '255.00', '', '', '', '-1.75', '-0.00', '0', '') RESULT:372||M|0.00 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', '', '372', '7034288 ','0188336', '0398963900', '039896390', 0, '', 'DISC01', 4, 'S', 'SOLOMON', 'MOLATLHEGI', '', 4, '25-APR-2016', '80598', '1.00', 'KF SV PROTECTYOUREYES 1.53 ARC', '871.00', '-1.50', '-0.25', '58', '', '', '', '') RESULT:372||M|0.00 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', '', '372', '7034288 ','0188336', '0398963900', '039896390', 0, '', 'DISC01', 4, 'S', 'SOLOMON', 'MOLATLHEGI', '', 5, '25-APR-2016', '80598', '1.00', 'KF SV PROTECTYOUREYES 1.53 ARC', '871.00', '', '', '', '-1.75', '-0.00', '0', '') RESULT:372||M|0.00 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', '', '372', '7034288 ','0188336', '0398963900', '039896390', 0, '', 'DISC01', 4, 'S', 'SOLOMON', 'MOLATLHEGI', '', 6, '25-APR-2016', '46016', '1.00', 'Discovery Health, Fitting Nylo', '299.00', '-1.50', '-0.25', '58', '', '', '', '') RESULT:372||M|0.00 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', 'L', '372', '7034288 ','0188336', '0398963900', '039896390', 0, '', 'DISC01', 4, 'S', 'SOLOMON', 'MOLATLHEGI', '', 7, '25-APR-2016', '46016', '1.00', 'Discovery Health, Fitting Nylo', '299.00', '', '', '', '-1.75', '-0.00', '0', '') RESULT:|603875|M|0.00 CLA|0|Claim Received|330600|0.00|M|160517160138856gq1wcno|603875 ITM|1|11001|456.00|0.00|M|MANUAL INTERVENTION REQUIRED|006 ITM|2|80011|255.00|0.00|M|MANUAL INTERVENTION REQUIRED|006 ITM|3|80011|255.00|0.00|M|MANUAL INTERVENTION REQUIRED|006 ITM|4|80598|871.00|0.00|M|MANUAL INTERVENTION REQUIRED|006 ITM|5|80598|871.00|0.00|M|MANUAL INTERVENTION REQUIRED|006 ITM|6|46016|299.00|0.00|M|MANUAL INTERVENTION REQUIRED|006 ITM|7|46016|299.00|0.00|M|MANUAL INTERVENTION REQUIRED|006 --------------------------------------------------------------------------- NEW CLAIM17052016 17:12:10|7034288 |TEST |196.33.235.59 CLA|2|Provider Not Found|0|0|E|160517161211553cunywl5 --------------------------------------------------------------------------- NEW CLAIM17052016 17:17:48|7034288 |TEST |196.33.235.59 CLA|2|Provider Not Found|0|0|E|160517161751308e5ouks9 --------------------------------------------------------------------------- NEW CLAIM17052016 17:42:41|7034288 |TEST |196.33.235.59 CLA|2|Provider Not Found|0|0|E|160517164242018zrkql3g --------------------------------------------------------------------------- NEW CLAIM17052016 17:49:53|7034288 |TEST |196.33.235.59 CLA|2|Provider Not Found|0|0|E|16051716495613403bnlmt --------------------------------------------------------------------------- NEW CLAIM17052016 17:51:02|7034288 |TEST |196.33.235.59 CLA|2|Provider Not Found|0|0|E|160517165106213xr47lvs --------------------------------------------------------------------------- NEW CLAIM17052016 17:56:19|7034288 |TEST |196.33.235.59 CLA|2|Provider Not Found|0|0|E|160517165620906cmtp303 --------------------------------------------------------------------------- NEW CLAIM17052016 17:59:40|7034288 |TEST |196.33.235.59 CLA|2|Provider Not Found|0|0|E|1605171659441741117bc1 --------------------------------------------------------------------------- NEW CLAIM17052016 18:07:10|7034288 |TEST |196.33.235.59 CLA|2|Provider Not Found|0|0|E|160517170712056k4mou3j --------------------------------------------------------------------------- NEW CLAIM18052016 14:40:11|7034288|TEST|146.232.211.251 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', 'F', '0', '7034288','0188336', '0001797100', '000179710', 0, 'NULL', 'DISC01', 4, 'A', 'ADEL', 'JOHNSON', 'L11122', 1, '10-MAR-2015', '11001', '1', 'CONSULT 1', '100.00', '2.00', '1.00', '3.00', '5.00', '4.00', '6.00', 'J45') RESULT:373||M|0.00 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', '', '373', '7034288','0188336', '0001797100', '000179710', 0, 'NULL', 'DISC01', 4, 'A', 'ADEL', 'JOHNSON', 'L11122', 2, '10-MAR-2015', '11001', '1', 'CONSULT 2', '200.00', '2.00', '1.00', '3.00', '5.00', '4.00', '6.00', 'J45') RESULT:373||M|0.00 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', 'L', '373', '7034288','0188336', '0001797100', '000179710', 0, 'NULL', 'DISC01', 4, 'A', 'ADEL', 'JOHNSON', 'L11122', 3, '10-MAR-2015', '11001', '1', 'CONSULT 3', '300.00', '2.00', '1.00', '3.00', '5.00', '4.00', '6.00', 'J45') RESULT:|603876|M|0.00 CLA|0|Claim Received|600.00|0.00|M|H12345|603876 ITM|1|11001|100.00|0.00|M|MANUAL INTERVENTION REQUIRED|006 ITM|2|11001|200.00|0.00|M|MANUAL INTERVENTION REQUIRED|006 ITM|3|11001|300.00|0.00|M|MANUAL INTERVENTION REQUIRED|006 --------------------------------------------------------------------------- NEW CLAIM18052016 14:48:27|7034288|TEST|146.232.211.251 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', 'F', '0', '7034288','0188336', '0399949700', '039994970', 0, 'NULL', 'DISC01', 4, 'DA', 'DIRK ADRIAAN', 'FLETCHER', 'L11122', 1, '10-MAR-2015', '11001', '1', 'CONSULT 1', '100.00', '2.00', '1.00', '3.00', '5.00', '4.00', '6.00', 'J45') RESULT:374||M|0.00 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', '', '374', '7034288','0188336', '0399949700', '039994970', 0, 'NULL', 'DISC01', 4, 'DA', 'DIRK ADRIAAN', 'FLETCHER', 'L11122', 2, '10-MAR-2015', '11001', '1', 'CONSULT 2', '200.00', '2.00', '1.00', '3.00', '5.00', '4.00', '6.00', 'J45') RESULT:374||M|0.00 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', 'L', '374', '7034288','0188336', '0399949700', '039994970', 0, 'NULL', 'DISC01', 4, 'DA', 'DIRK ADRIAAN', 'FLETCHER', 'L11122', 3, '10-MAR-2015', '11001', '1', 'CONSULT 3', '300.00', '2.00', '1.00', '3.00', '5.00', '4.00', '6.00', 'J45') RESULT:|603877|M|0.00 CLA|0|Claim Received|600.00|0.00|M|H12345|603877 ITM|1|11001|100.00|0.00|M|MANUAL INTERVENTION REQUIRED|006 ITM|2|11001|200.00|0.00|M|MANUAL INTERVENTION REQUIRED|006 ITM|3|11001|300.00|0.00|M|MANUAL INTERVENTION REQUIRED|006 --------------------------------------------------------------------------- NEW CLAIM18052016 14:54:58|7034288|TEST|146.232.211.251 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', 'F', '0', '7034288','0188336', '1258148400', '125814840', 0, 'NULL', 'DISC01', 4, 'SB', 'SUGRA BIBI', 'GOOLAM-HUSSAIN', 'L11122', 1, '10-MAR-2015', '11001', '1', 'CONSULT 1', '100.00', '2.00', '1.00', '3.00', '5.00', '4.00', '6.00', 'J45') RESULT:375||M|0.00 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', '', '375', '7034288','0188336', '1258148400', '125814840', 0, 'NULL', 'DISC01', 4, 'SB', 'SUGRA BIBI', 'GOOLAM-HUSSAIN', 'L11122', 2, '10-MAR-2015', '11001', '1', 'CONSULT 2', '200.00', '2.00', '1.00', '3.00', '5.00', '4.00', '6.00', 'J45') RESULT:375||M|0.00 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', 'L', '375', '7034288','0188336', '1258148400', '125814840', 0, 'NULL', 'DISC01', 4, 'SB', 'SUGRA BIBI', 'GOOLAM-HUSSAIN', 'L11122', 3, '10-MAR-2015', '11001', '1', 'CONSULT 3', '300.00', '2.00', '1.00', '3.00', '5.00', '4.00', '6.00', 'J45') RESULT:|603878|M|0.00 CLA|0|Claim Received|600.00|0.00|M|H12345|603878 ITM|1|11001|100.00|0.00|M|MANUAL INTERVENTION REQUIRED|006 ITM|2|11001|200.00|0.00|M|MANUAL INTERVENTION REQUIRED|006 ITM|3|11001|300.00|0.00|M|MANUAL INTERVENTION REQUIRED|006 --------------------------------------------------------------------------- NEW CLAIM18052016 14:56:09|7034288|TEST|146.232.211.251 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', 'F', '0', '7034288','0188336', '1258148400', '125814840', 0, 'NULL', 'DISC01', 4, 'SB', 'SUGRA BIBI', 'GOOLAM-HUSSAIN', 'L11122', 1, '10-MAR-2015', '11001', '1', 'CONSULT 1', '100.00', '2.00', '1.00', '3.00', '5.00', '4.00', '6.00', 'J45') RESULT:376||M|0.00 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', '', '376', '7034288','0188336', '1258148400', '125814840', 0, 'NULL', 'DISC01', 4, 'SB', 'SUGRA BIBI', 'GOOLAM-HUSSAIN', 'L11122', 2, '10-MAR-2015', '11001', '1', 'CONSULT 2', '200.00', '2.00', '1.00', '3.00', '5.00', '4.00', '6.00', 'J45') RESULT:376||M|0.00 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', 'L', '376', '7034288','0188336', '1258148400', '125814840', 0, 'NULL', 'DISC01', 4, 'SB', 'SUGRA BIBI', 'GOOLAM-HUSSAIN', 'L11122', 3, '10-MAR-2015', '11001', '1', 'CONSULT 3', '300.00', '2.00', '1.00', '3.00', '5.00', '4.00', '6.00', 'J45') RESULT:|603879|M|0.00 CLA|0|Claim Received|600.00|0.00|M|H12345|603879 ITM|1|11001|100.00|0.00|M|MANUAL INTERVENTION REQUIRED|006 ITM|2|11001|200.00|0.00|M|MANUAL INTERVENTION REQUIRED|006 ITM|3|11001|300.00|0.00|M|MANUAL INTERVENTION REQUIRED|006 --------------------------------------------------------------------------- NEW CLAIM18052016 15:04:18|7034288|TEST|146.232.211.251 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', 'F', '0', '7034288','0188336', '1258148400', '125814840', 0, 'NULL', 'DISC01', 4, 'SB', 'SUGRA BIBI', 'GOOLAM-HUSSAIN', 'L11122', 1, '10-MAR-2015', '11001', '1', 'CONSULT 1', '100.00', '2.00', '1.00', '3.00', '5.00', '4.00', '6.00', 'J45') RESULT:377||M|0.00 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', '', '377', '7034288','0188336', '1258148400', '125814840', 0, 'NULL', 'DISC01', 4, 'SB', 'SUGRA BIBI', 'GOOLAM-HUSSAIN', 'L11122', 2, '10-MAR-2015', '11001', '1', 'CONSULT 2', '200.00', '2.00', '1.00', '3.00', '5.00', '4.00', '6.00', 'J45') RESULT:377||M|0.00 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', 'L', '377', '7034288','0188336', '1258148400', '125814840', 0, 'NULL', 'DISC01', 4, 'SB', 'SUGRA BIBI', 'GOOLAM-HUSSAIN', 'L11122', 3, '10-MAR-2015', '11001', '1', 'CONSULT 3', '300.00', '2.00', '1.00', '3.00', '5.00', '4.00', '6.00', 'J45') RESULT:|603880|M|0.00 CLA|0|Claim Received|600.00|0.00|M|H12345|603880 ITM|1|11001|100.00|0.00|M|MANUAL INTERVENTION REQUIRED|006 ITM|2|11001|200.00|0.00|M|MANUAL INTERVENTION REQUIRED|006 ITM|3|11001|300.00|0.00|M|MANUAL INTERVENTION REQUIRED|006 --------------------------------------------------------------------------- NEW CLAIM18052016 15:06:06|7034288|TEST|146.232.211.251 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', 'F', '0', '7034288','0188336', '1258148400', '125814840', 0, 'NULL', 'DISC01', 4, 'SB', 'SUGRA BIBI', 'GOOLAM-HUSSAIN', 'L11122', 1, '10-MAR-2015', '11001', '1', 'CONSULT 1', '100.00', '2.00', '1.00', '3.00', '5.00', '4.00', '6.00', 'J45') RESULT:378||R|0.00 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', '', '378', '7034288','0188336', '1258148400', '125814840', 0, 'NULL', 'DISC01', 4, 'SB', 'SUGRA BIBI', 'GOOLAM-HUSSAIN', 'L11122', 2, '10-MAR-2015', '11001', '1', 'CONSULT 2', '200.00', '2.00', '1.00', '3.00', '5.00', '4.00', '6.00', 'J45') RESULT:378||R|0.00 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', 'L', '378', '7034288','0188336', '1258148400', '125814840', 0, 'NULL', 'DISC01', 4, 'SB', 'SUGRA BIBI', 'GOOLAM-HUSSAIN', 'L11122', 3, '10-MAR-2015', '11001', '1', 'CONSULT 3', '300.00', '2.00', '1.00', '3.00', '5.00', '4.00', '6.00', 'J45') RESULT:|603881|R|0.00 CLA|0|Claim Received|600.00|0.00|R|H12345|603881 ITM|1|11001|100.00|0.00|R|PROVIDER IN DISPUTE OR NOT CONTRACTED|002 ITM|2|11001|200.00|0.00|R|PROVIDER IN DISPUTE OR NOT CONTRACTED|002 ITM|3|11001|300.00|0.00|R|PROVIDER IN DISPUTE OR NOT CONTRACTED|002 --------------------------------------------------------------------------- NEW CLAIM18052016 15:08:17|7034288|TEST|146.232.211.251 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', 'F', '0', '7034288','0188336', '1258148400', '125814840', 0, 'NULL', 'DISC01', 4, 'SB', 'SUGRA BIBI', 'GOOLAM-HUSSAIN', 'L11122', 1, '10-MAR-2015', '11001', '1', 'CONSULT 1', '100.00', '2.00', '1.00', '3.00', '5.00', '4.00', '6.00', 'J45') RESULT:379||R|0.00 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', '', '379', '7034288','0188336', '1258148400', '125814840', 0, 'NULL', 'DISC01', 4, 'SB', 'SUGRA BIBI', 'GOOLAM-HUSSAIN', 'L11122', 2, '10-MAR-2015', '11001', '1', 'CONSULT 2', '200.00', '2.00', '1.00', '3.00', '5.00', '4.00', '6.00', 'J45') RESULT:379||R|0.00 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', 'L', '379', '7034288','0188336', '1258148400', '125814840', 0, 'NULL', 'DISC01', 4, 'SB', 'SUGRA BIBI', 'GOOLAM-HUSSAIN', 'L11122', 3, '10-MAR-2015', '11001', '1', 'CONSULT 3', '300.00', '2.00', '1.00', '3.00', '5.00', '4.00', '6.00', 'J45') RESULT:|603882|R|0.00 CLA|0|Claim Received|600.00|0.00|R|H12345|603882 ITM|1|11001|100.00|0.00|R||022 ITM|2|11001|200.00|0.00|R||022 ITM|3|11001|300.00|0.00|R||022 --------------------------------------------------------------------------- NEW CLAIM18052016 15:53:09|7034288|TEST|146.232.211.251 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', 'F', '0', '7034288','0188336', '1258148400', '125814840', 0, 'NULL', 'DISC01', 4, 'SB', 'SUGRA BIBI', 'GOOLAM-HUSSAIN', 'L11122', 1, '10-MAR-2015', '11001', '1', 'CONSULT 1', '100.00', '2.00', '1.00', '3.00', '5.00', '4.00', '6.00', 'J45') RESULT:380||R|0.00 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', '', '380', '7034288','0188336', '1258148400', '125814840', 0, 'NULL', 'DISC01', 4, 'SB', 'SUGRA BIBI', 'GOOLAM-HUSSAIN', 'L11122', 2, '10-MAR-2015', '11001', '1', 'CONSULT 2', '200.00', '2.00', '1.00', '3.00', '5.00', '4.00', '6.00', 'J45') RESULT:380||R|0.00 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', 'L', '380', '7034288','0188336', '1258148400', '125814840', 0, 'NULL', 'DISC01', 4, 'SB', 'SUGRA BIBI', 'GOOLAM-HUSSAIN', 'L11122', 3, '10-MAR-2015', '11001', '1', 'CONSULT 3', '300.00', '2.00', '1.00', '3.00', '5.00', '4.00', '6.00', 'J45') RESULT:|603883|R|0.00 CLA|0|Claim Received|600.00|0.00|R|H12345|603883 ITM|1|11001|100.00|0.00|R|STALE CLAIM|017 ITM|2|11001|200.00|0.00|R|STALE CLAIM|017 ITM|3|11001|300.00|0.00|R|STALE CLAIM|017 --------------------------------------------------------------------------- NEW CLAIM18052016 15:57:46|7034288|TEST|146.232.211.251 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', 'F', '0', '7034288','0188336', '1258148400', '125814840', 0, 'NULL', 'DISC01', 4, 'SB', 'SUGRA BIBI', 'GOOLAM-HUSSAIN', 'L11122', 1, '10-MAR-2016', '11001', '1', 'CONSULT 1', '500.00', '2.00', '1.00', '3.00', '5.00', '4.00', '6.00', 'J45') RESULT:381||P|360.00 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', '', '381', '7034288','0188336', '1258148400', '125814840', 0, 'NULL', 'DISC01', 4, 'SB', 'SUGRA BIBI', 'GOOLAM-HUSSAIN', 'L11122', 2, '10-MAR-2016', '40501', '1', 'CONSULT 2', '200.00', '2.00', '1.00', '3.00', '5.00', '4.00', '6.00', 'J45') RESULT:381||P|150.00 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', 'L', '381', '7034288','0188336', '1258148400', '125814840', 0, 'NULL', 'DISC01', 4, 'SB', 'SUGRA BIBI', 'GOOLAM-HUSSAIN', 'L11122', 3, '10-MAR-2016', '70011', '1', 'CONSULT 3', '300.00', '2.00', '1.00', '3.00', '5.00', '4.00', '6.00', 'J45') RESULT:|603884|P|100.00 CLA|0|Claim Received|600.00|610.00|F|H12345|603884 ITM|1|11001|500.00|360.00|P|PART PAID|019 ITM|2|40501|200.00|150.00|P|PART PAID|019 ITM|3|70011|300.00|100.00|P|PART PAID|019 --------------------------------------------------------------------------- NEW CLAIM19052016 11:00:39|7034288|TEST|146.232.211.251 INCORRECT LOGIN --------------------------------------------------------------------------- NEW CLAIM19052016 11:08:00|7034288|TEST|146.232.211.251 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', 'F', '0', '7034288','0188336', '0200010010401', '02000100104', 1, 'NULL', 'BONI01', 9, 'G', 'GLADYS MPOLAI', 'MOEKOA', 'L11122', 1, '10-MAR-2015', '11001', '1', 'CONSULT 1', '100.00', '2.00', '1.00', '3.00', '5.00', '4.00', '6.00', 'J45') RESULT:231||F|100.00 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', '', '231', '7034288','0188336', '0200010010401', '02000100104', 1, 'NULL', 'BONI01', 9, 'G', 'GLADYS MPOLAI', 'MOEKOA', 'L11122', 2, '10-MAR-2015', '11001', '1', 'CONSULT 2', '200.00', '2.00', '1.00', '3.00', '5.00', '4.00', '6.00', 'J45') RESULT:231||F|200.00 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', 'L', '231', '7034288','0188336', '0200010010401', '02000100104', 1, 'NULL', 'BONI01', 9, 'G', 'GLADYS MPOLAI', 'MOEKOA', 'L11122', 3, '10-MAR-2015', '11001', '1', 'CONSULT 3', '300.00', '2.00', '1.00', '3.00', '5.00', '4.00', '6.00', 'J45') RESULT:|975860|F|300.00 CLA|0|Claim Received|600.00|600.00|F|H12345|975860 ITM|1|11001|100.00|100.00|F|PAID IN FULL|001 ITM|2|11001|200.00|200.00|F|PAID IN FULL|001 ITM|3|11001|300.00|300.00|F|PAID IN FULL|001 --------------------------------------------------------------------------- NEW CLAIM19052016 11:31:05|7034288|TEST|146.232.211.251 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', 'F', '0', '7034288','0188336', '0200010010401', '02000100104', 1, 'NULL', 'BONI01', 9, 'G', 'GLADYS MPOLAI', 'MOEKOA', 'L11122', 1, '10-MAR-2015', '11001', '1', 'CONSULT 1', '100.00', '2.00', '1.00', '3.00', '5.00', '4.00', '6.00', 'J45') RESULT:232||R|0.00 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', '', '232', '7034288','0188336', '0200010010401', '02000100104', 1, 'NULL', 'BONI01', 9, 'G', 'GLADYS MPOLAI', 'MOEKOA', 'L11122', 2, '10-MAR-2015', '11001', '1', 'CONSULT 2', '200.00', '2.00', '1.00', '3.00', '5.00', '4.00', '6.00', 'J45') RESULT:232||R|0.00 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', 'L', '232', '7034288','0188336', '0200010010401', '02000100104', 1, 'NULL', 'BONI01', 9, 'G', 'GLADYS MPOLAI', 'MOEKOA', 'L11122', 3, '10-MAR-2015', '11001', '1', 'CONSULT 3', '300.00', '2.00', '1.00', '3.00', '5.00', '4.00', '6.00', 'J45') RESULT:|975861|R|0.00 CLA|0|Claim Received|600.00|0.00|R|H12345|975861 ITM|1|11001|100.00|0.00|R|STALE CLAIM|017 ITM|2|11001|200.00|0.00|R|STALE CLAIM|017 ITM|3|11001|300.00|0.00|R|STALE CLAIM|017 --------------------------------------------------------------------------- NEW CLAIM19052016 11:31:58|7034288|TEST|146.232.211.251 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', 'F', '0', '7034288','0188336', '0200010010401', '02000100104', 1, 'NULL', 'BONI01', 9, 'G', 'GLADYS MPOLAI', 'MOEKOA', 'L11122', 1, '10-MAR-2016', '11001', '1', 'CONSULT 1', '100.00', '2.00', '1.00', '3.00', '5.00', '4.00', '6.00', 'J45') RESULT:233||F|100.00 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', '', '233', '7034288','0188336', '0200010010401', '02000100104', 1, 'NULL', 'BONI01', 9, 'G', 'GLADYS MPOLAI', 'MOEKOA', 'L11122', 2, '10-MAR-2016', '11001', '1', 'CONSULT 2', '200.00', '2.00', '1.00', '3.00', '5.00', '4.00', '6.00', 'J45') RESULT:233||F|200.00 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', 'L', '233', '7034288','0188336', '0200010010401', '02000100104', 1, 'NULL', 'BONI01', 9, 'G', 'GLADYS MPOLAI', 'MOEKOA', 'L11122', 3, '10-MAR-2016', '11001', '1', 'CONSULT 3', '300.00', '2.00', '1.00', '3.00', '5.00', '4.00', '6.00', 'J45') RESULT:|975862|F|300.00 CLA|0|Claim Received|600.00|600.00|F|H12345|975862 ITM|1|11001|100.00|100.00|F|PAID IN FULL|001 ITM|2|11001|200.00|200.00|F|PAID IN FULL|001 ITM|3|11001|300.00|300.00|F|PAID IN FULL|001 --------------------------------------------------------------------------- NEW CLAIM19052016 12:45:44|7034288|TEST|146.232.211.251 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', 'F', '0', '7034288','0188336', '0200010028300', '02000100283', 0, 'NULL', 'BONI01', 9, 'PA', 'PAUL ANTHONY', 'MUSO', 'L11122', 1, '10-MAR-2016', '11001', '1', 'CONSULT 1', '500.00', '2.00', '1.00', '3.00', '5.00', '4.00', '6.00', 'J45') RESULT:234||P|490.00 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', '', '234', '7034288','0188336', '0200010028300', '02000100283', 0, 'NULL', 'BONI01', 9, 'PA', 'PAUL ANTHONY', 'MUSO', 'L11122', 2, '10-MAR-2016', '40501', '1', 'CONSULT 2', '200.00', '2.00', '1.00', '3.00', '5.00', '4.00', '6.00', 'J45') RESULT:234||F|200.00 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', 'L', '234', '7034288','0188336', '0200010028300', '02000100283', 0, 'NULL', 'BONI01', 9, 'PA', 'PAUL ANTHONY', 'MUSO', 'L11122', 3, '10-MAR-2016', '70011', '1', 'CONSULT 3', '300.00', '2.00', '1.00', '3.00', '5.00', '4.00', '6.00', 'J45') RESULT:|975863|P|160.00 CLA|0|Claim Received|600.00|850.00|F|H12345|975863 ITM|1|11001|500.00|490.00|P|PART PAID|019 ITM|2|40501|200.00|200.00|F|PAID IN FULL|001 ITM|3|70011|300.00|160.00|P|PART PAID|019 --------------------------------------------------------------------------- NEW CLAIM19052016 12:47:01|7034288|TEST|146.232.211.251 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', 'F', '0', '7034288','0188336', '0200010028300', '02000100283', 0, 'NULL', 'BONI01', 9, 'PA', 'PAUL ANTHONY', 'MUSO', 'L11122', 1, '10-MAR-2016', '11001', '1', 'CONSULT 1', '500.00', '2.00', '1.00', '3.00', '5.00', '4.00', '6.00', 'J45') RESULT:235||P|490.00 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', '', '235', '7034288','0188336', '0200010028300', '02000100283', 0, 'NULL', 'BONI01', 9, 'PA', 'PAUL ANTHONY', 'MUSO', 'L11122', 2, '10-MAR-2016', '70011', '1', 'CONSULT 2', '200.00', '2.00', '1.00', '3.00', '5.00', '4.00', '6.00', 'J45') RESULT:235||P|160.00 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', 'L', '235', '7034288','0188336', '0200010028300', '02000100283', 0, 'NULL', 'BONI01', 9, 'PA', 'PAUL ANTHONY', 'MUSO', 'L11122', 3, '10-MAR-2016', '93800', '1', 'CONSULT 3', '300.00', '2.00', '1.00', '3.00', '5.00', '4.00', '6.00', 'J45') RESULT:|975864|R|0.00 CLA|0|Claim Received|600.00|650.00|R|H12345|975864 ITM|1|11001|500.00|490.00|P|PART PAID|019 ITM|2|70011|200.00|160.00|P|PART PAID|019 ITM|3|93800|300.00|0.00|R|TARIFF 93800 OR 03PEP FOR BONITAS 01 05 07 08|009 --------------------------------------------------------------------------- NEW CLAIM19052016 12:50:08|7034288|TEST|146.232.211.251 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', 'F', '0', '7034288','0188336', '0200010028300', '02000100283', 0, 'NULL', 'BONI01', 9, 'PA', 'PAUL ANTHONY', 'MUSO', 'L11122', 1, '10-MAR-2016', '11001', '1', 'CONSULT 1', '500.00', '2.00', '1.00', '3.00', '5.00', '4.00', '6.00', 'J45') RESULT:236||P|490.00 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', '', '236', '7034288','0188336', '0200010028300', '02000100283', 0, 'NULL', 'BONI01', 9, 'PA', 'PAUL ANTHONY', 'MUSO', 'L11122', 2, '10-MAR-2016', '70011', '1', 'CONSULT 2', '200.00', '2.00', '1.00', '3.00', '5.00', '4.00', '6.00', 'J45') RESULT:236||P|160.00 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', 'L', '236', '7034288','0188336', '0200010028300', '02000100283', 0, 'NULL', 'BONI01', 9, 'PA', 'PAUL ANTHONY', 'MUSO', 'L11122', 3, '10-MAR-2016', '93800', '1', 'CONSULT 3', '300.00', '2.00', '1.00', '3.00', '5.00', '4.00', '6.00', 'J45') RESULT:|975865|R|0.00 CLA|0|Claim Received|600.00|650.00|R|H12345|975865 ITM|1|11001|500.00|490.00|P|PART PAID|019 ITM|2|70011|200.00|160.00|P|PART PAID|019 ITM|3|93800|300.00|0.00|R|TARIFF 93800 OR 03PEP FOR BONITAS 01 05 07 08|009 --------------------------------------------------------------------------- NEW CLAIM19052016 13:56:21|7034288|TEST|146.232.211.251 CLA|99|CLAIM HEADER TOTAL ITEM TOTAL MISMATCH|0|0|E|H12345 --------------------------------------------------------------------------- NEW CLAIM19052016 13:57:40|7034288|TEST|146.232.211.251 CLA|99|CLAIM HEADER TOTAL ITEM TOTAL MISMATCH|0|0|E|H12345HEAD600.00ITEM0100.00200.00300.00 --------------------------------------------------------------------------- NEW CLAIM19052016 13:58:44|7034288|TEST|146.232.211.251 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', 'F', '0', '7034288','0188336', '0200010010401', '02000100104', 1, 'NULL', 'BONI01', 9, 'G', 'GLADYS MPOLAI', 'MOEKOA', 'L11122', 1, '10-MAR-2016', '11001', '1', 'CONSULT 1', '100.00', '2.00', '1.00', '3.00', '5.00', '4.00', '6.00', 'J45') RESULT:237||F|100.00 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', '', '237', '7034288','0188336', '0200010010401', '02000100104', 1, 'NULL', 'BONI01', 9, 'G', 'GLADYS MPOLAI', 'MOEKOA', 'L11122', 2, '10-MAR-2016', '11001', '1', 'CONSULT 2', '200.00', '2.00', '1.00', '3.00', '5.00', '4.00', '6.00', 'J45') RESULT:237||F|200.00 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', 'L', '237', '7034288','0188336', '0200010010401', '02000100104', 1, 'NULL', 'BONI01', 9, 'G', 'GLADYS MPOLAI', 'MOEKOA', 'L11122', 3, '10-MAR-2016', '11001', '1', 'CONSULT 3', '300.00', '2.00', '1.00', '3.00', '5.00', '4.00', '6.00', 'J45') RESULT:|975866|F|300.00 CLA|0|Claim Received|600.00|600.00|F|H12345|975866 ITM|1|11001|100.00|100.00|F|PAID IN FULL|001 ITM|2|11001|200.00|200.00|F|PAID IN FULL|001 ITM|3|11001|300.00|300.00|F|PAID IN FULL|001 --------------------------------------------------------------------------- NEW CLAIM19052016 13:59:02|7034288|TEST|146.232.211.251 CLA|99|CLAIM HEADER TOTAL ITEM TOTAL MISMATCH|0|0|E|H12345HEAD500.00ITEM600 --------------------------------------------------------------------------- NEW CLAIM19052016 14:05:48|7034288|TEST|146.232.211.251 CLA|99|CLAIM HEADER TOTAL ITEM TOTAL MISMATCH|0|0|E|H12345HEAD500.00ITEM600 --------------------------------------------------------------------------- NEW CLAIM19052016 14:05:56|7034288|TEST|146.232.211.251 CLA|99|CLAIM HEADER LINES ITEM LINES MISMATCH|0|0|E|H12345HEAD4ITEM3 --------------------------------------------------------------------------- NEW CLAIM19052016 14:06:10|7034288|TEST|146.232.211.251 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', 'F', '0', '7034288','0188336', '0200010010401', '02000100104', 1, 'NULL', 'BONI01', 9, 'G', 'GLADYS MPOLAI', 'MOEKOA', 'L11122', 1, '10-MAR-2016', '11001', '1', 'CONSULT 1', '100.00', '2.00', '1.00', '3.00', '5.00', '4.00', '6.00', 'J45') RESULT:238||F|100.00 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', '', '238', '7034288','0188336', '0200010010401', '02000100104', 1, 'NULL', 'BONI01', 9, 'G', 'GLADYS MPOLAI', 'MOEKOA', 'L11122', 2, '10-MAR-2016', '11001', '1', 'CONSULT 2', '200.00', '2.00', '1.00', '3.00', '5.00', '4.00', '6.00', 'J45') RESULT:238||F|200.00 QUERY:SELECT RET_UPDATESEQNO, RET_CLAIMNO, RET_REJECT, RET_PAID, RET_REJECTCODE FROM SP_POSTWEBPATIENTX('I', 'L', '238', '7034288','0188336', '0200010010401', '02000100104', 1, 'NULL', 'BONI01', 9, 'G', 'GLADYS MPOLAI', 'MOEKOA', 'L11122', 3, '10-MAR-2016', '11001', '1', 'CONSULT 3', '300.00', '2.00', '1.00', '3.00', '5.00', '4.00', '6.00', 'J45') RESULT:|975867|F|300.00 CLA|0|Claim Received|600.00|600.00|F|H12345|975867 ITM|1|11001|100.00|100.00|F|PAID IN FULL|001 ITM|2|11001|200.00|200.00|F|PAID IN FULL|001 ITM|3|11001|300.00|300.00|F|PAID IN FULL|001