Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
all code maps
Language:
Ada
Assembly
Bash
C#
C++ (gcc)
C++ (clang)
C++ (vc++)
C (gcc)
C (clang)
C (vc)
Client Side
Clojure
Common Lisp
D
Elixir
Erlang
F#
Fortran
Go
Haskell
Java
Javascript
Kotlin
Lua
MySql
Node.js
Ocaml
Octave
Objective-C
Oracle
Pascal
Perl
Php
PostgreSQL
Prolog
Python
Python 3
R
Rust
Ruby
Scala
Scheme
Sql Server
Swift
Tcl
Visual Basic
Layout:
Vertical
Horizontal
#MySQL 5.7.12 #please drop objects you've created at the end of the script #or check for their existance before creating #'\\' is a delimiter -- phpMyAdmin SQL Dump -- version 4.6.6deb5 -- https://www.phpmyadmin.net/ -- -- Host: localhost -- Generation Time: Nov 20, 2018 at 10:53 PM -- Server version: 5.6.30-1-log -- PHP Version: 7.3.0RC4 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `hop-test` -- -- -------------------------------------------------------- -- -- Table structure for table `code_map` -- DROP TABLE IF EXISTS `code_map`; CREATE TABLE `code_map` ( `id` int(5) NOT NULL COMMENT 'row_id', `client_id` int(5) NOT NULL, `site_id` int(10) NOT NULL, `service_category` varchar(30) NOT NULL COMMENT 'service category', `service_code` varchar(30) NOT NULL COMMENT 'service_code' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `code_map` -- INSERT INTO `code_map` (`id`, `client_id`, `site_id`, `service_category`, `service_code`) VALUES (807, 1, 6, 'NPMC', 'NMCEx'), (809, 1, 6, 'NPPP', 'NCExx'), (810, 1, 6, 'NPPP', 'NAEXX'), (811, 1, 6, 'CHProphy', 'PrNMC'), (812, 1, 6, 'PerLT', 'D4342'), (813, 1, 6, 'Fluoride', 'D1203'), (814, 1, 6, 'Fluoride', 'D1204'), (815, 1, 6, 'AdProphy', 'PrAxx'), (816, 1, 6, 'AdProphy', 'PrDxx'), (817, 1, 6, 'AdProphy', 'PrNax'), (818, 1, 6, 'AdProphy', 'PrNMA'), (819, 1, 6, 'AdProphy', 'D1110'), (820, 1, 6, 'OCS', 'D0431'), (821, 1, 6, 'PerMA', 'D4910'), (822, 1, 6, 'PerGN', 'D4341'), (823, 1, 6, 'Oracare', 'ORACR'), (824, 1, 6, 'Fluoride', 'D1206'), (825, 1, 6, 'CHProphy', 'PrNCx'), (826, 1, 6, 'CHProphy', 'PrCxx'), (827, 1, 6, 'AdProphy', 'PrNAd'), (828, 1, 6, 'Fluoride', 'FLU21'), (829, 1, 6, 'Fluoride', 'FL21O'), (832, 1, 6, 'Fluoride', 'HOMFL'), (833, 1, 6, 'Fluoride', 'RXFLL'), (834, 1, 6, 'Sealant', 'D1351'), (835, 1, 6, 'Sealant', 'SpSMx'), (836, 1, 6, 'Sealant', 'SpSPx'), (837, 1, 6, 'RXFluoride', 'RXFLL'), (838, 1, 6, 'SA', 'SAINS'), (839, 1, 6, 'DHP', 'DHPAC'), (840, 1, 6, 'MCOrthoCase', '8070M'), (841, 1, 6, 'MCOrthoCase', '8080M'), (842, 1, 6, 'MCOrthoCase', '8090M'), (843, 1, 6, 'PPOrthoCase', 'D8090'), (844, 1, 6, 'PPOrthoCase', 'D8080'), (845, 1, 6, 'PPOrthoCase', 'D8070'), (846, 1, 6, 'PPOrthoCase', '8070Q'), (847, 1, 6, 'PPOrthoCase', '8070R'), (848, 1, 6, 'PPOrthoCase', '8070X'), (849, 1, 6, 'PPOrthoCase', '8080I'), (850, 1, 6, 'PPOrthoCase', '8080Q'), (851, 1, 6, 'PPOrthoCase', '8080X'), (852, 1, 6, 'PPOrthoCase', '808IR'), (853, 1, 6, 'PPOrthoCase', '8090I'), (854, 1, 6, 'PPOrthoCase', '809IR'), (855, 1, 6, 'PPOrthoCase', '8090Q'), (856, 1, 6, 'PPOrthoCase', '8090R'), (857, 1, 6, 'PPOrthoCase', '8090X'), (858, 1, 6, 'OrthoConMC', 'ORMCn'), (859, 1, 6, 'OrthoConPP', 'D8660'), (861, 1, 6, 'PerMA', 'PerMD'), (862, 1, 6, 'SAScreen', '99202'), (863, 1, 6, 'SAAccept', 'SAAHT'), (864, 1, 6, 'SADecline', 'SADHT'), (865, 1, 6, 'SANonCand', 'SAPNC'), (866, 1, 6, 'SAAM', 'SAAMR'), (867, 1, 6, 'NPPP', 'D0180'), (868, 1, 6, 'NPPP', 'NEAdo'), (1315, 1, 6, 'CHProphy', 'PrC'), (1316, 1, 6, 'CHProphy', 'PrNC'), (1317, 1, 6, 'NPMC', 'NMCE'), (1318, 1, 6, 'NPPP', 'NAE'), (1319, 1, 6, 'NPPP', 'NCE'), (1321, 1, 6, 'AdProphy', 'PRA'), (1322, 1, 6, 'AdProphy', 'PRD'), (1323, 1, 6, 'AdProphy', 'PRNA'), (1324, 1, 6, 'Sealant', 'SPSM'), (1325, 1, 6, 'Sealant', 'SPSP'), (1326, 1, 6, 'Oracare', 'ORGLX'), (1327, 1, 6, 'Oracare', 'ORHWX'), (1329, 1, 6, 'Oracare', 'ORTDx'), (1330, 1, 6, 'Oracare', 'ORAF2'), (1331, 1, 6, 'Oracare', 'ORAHx'), (1333, 1, 6, 'Oracare', 'ORCJ1'), (1334, 1, 6, 'Oracare', 'ORCTX'), (1335, 1, 6, 'Oracare', 'ORECx'), (1336, 1, 6, 'Oracare', 'ORJCX'), (1337, 1, 6, 'Oracare', 'ORJIx'), (1338, 1, 6, 'Oracare', 'ORJJx'), (1339, 1, 6, 'Oracare', 'ORJLx'), (1340, 1, 6, 'Oracare', 'ORJRx'), (1341, 1, 6, 'Oracare', 'ORJWx'), (1342, 1, 6, 'Oracare', 'ORKBx'), (1343, 1, 6, 'Oracare', 'ORLAx'), (1344, 1, 6, 'Oracare', 'ORLCX'), (1345, 1, 6, 'Oracare', 'ORMAx'), (1346, 1, 6, 'Oracare', 'ORMRx'), (1347, 1, 6, 'Oracare', 'ORRRx'), (1348, 1, 6, 'Oracare', 'ORRSx'), (1349, 1, 6, 'Oracare', 'ORSIx'), (1350, 1, 6, 'Oracare', 'ORTBx'), (1351, 1, 6, 'Oracare', 'ORTMx'), (1352, 1, 6, 'Oracare', 'ORCBX'), (1353, 1, 6, 'Oracare', 'ORCB1'), (1439, 1, 6, 'Oracare', 'ORCEx'), (1440, 1, 6, 'Oracare', 'ORAOx'), (1441, 1, 6, 'Oracare', 'ORASx'), (1448, 1, 6, 'NPAMC', 'AMCNP'), (2122, 1, 6, 'Fluoride', 'D1208'), (2148, 1, 6, 'Fluoride', '9910P'), (2149, 1, 6, 'PerEV', 'PerRe'), (2164, 1, 6, 'Oracare', 'ORAH1'), (2168, 1, 6, 'Sealant', '1351A'), (2175, 1, 6, 'AdSeal', '1351A'), (2309, 1, 6, 'Oracare', 'ORBK1'), (2310, 1, 6, 'NPTOT', 'NPAMC'), (2311, 1, 6, 'NPTOT', 'NMCE'), (2312, 1, 6, 'NPTOT', 'NMCEx'), (2313, 1, 6, 'NPTOT', 'D0180'), (2314, 1, 6, 'NPTOT', 'NAE'), (2315, 1, 6, 'NPTOT', 'NAExx'), (2316, 1, 6, 'NPTOT', 'NCE'), (2317, 1, 6, 'NPTOT', 'NCExx'), (2318, 1, 6, 'NPTOT', 'NEAdo'), (2319, 1, 6, 'NPTOT', 'NTAE'), (2320, 1, 6, 'NPTOT', 'NTAEx'), (2365, 1, 6, 'ReCare', 'D0120'), (2411, 1, 6, 'ReCare', 'D4910'), (2424, 1, 6, 'ORTHInv', '8080I'), (2425, 1, 6, 'ORTHInv', '8090I'), (2441, 1, 6, 'Nitrous', 'D9230'), (2453, 1, 6, 'Endo', 'D3310'), (2454, 1, 6, 'Endo', 'D3320'), (2455, 1, 6, 'Endo', 'D3330'), (2456, 1, 6, 'EndoMolar', 'D3330'), (2481, 1, 6, 'ExtSimp', 'D7140'), (2488, 1, 6, 'ExtSurg', 'D7220'), (2495, 1, 6, 'ExtSurg', 'D7210'), (2496, 1, 6, 'ExtSurg', 'D7230'), (2497, 1, 6, 'ExtSurg', 'D7241'), (2516, 1, 6, 'Emerg', 'D0140'), (2517, 1, 6, 'Emerg', 'TxM'), (2518, 1, 6, 'Emerg', 'TX'), (2519, 1, 6, 'Emerg', 'TxMxx'), (2520, 1, 6, 'Emerg', 'TXxxx'), (2521, 1, 6, 'ResinAnt', 'D2330'), (2522, 1, 6, 'ResinAnt', 'D2331'), (2523, 1, 6, 'ResinAnt', 'D2332'), (2524, 1, 6, 'ResinAnt', 'D2335'), (2525, 1, 6, 'ResinPost', 'D2391'), (2526, 1, 6, 'ResinPost', 'D2392'), (2527, 1, 6, 'ResinPost', 'D2393'), (2528, 1, 6, 'ResinPost', 'D2394'), (2529, 1, 6, 'ResinPost', 'Mic1X'), (2530, 1, 6, 'ResinPost', 'Mic1'), (2531, 1, 6, 'ResinPost', 'Ptr1x'), (2532, 1, 6, 'ResinPost', 'Ptr1'), (2533, 1, 6, 'ResinPost', 'Mic2x'), (2534, 1, 6, 'ResinPost', 'Mic2'), (2535, 1, 6, 'ResinPost', 'Ptr2m'), (2536, 1, 6, 'ResinPost', 'PtR3x'), (2537, 1, 6, 'ResinPost', 'PtR3'), (2538, 1, 6, 'ResinPost', 'SpSMx'), (2539, 1, 6, 'ResinPost', 'SpSM'), (2540, 1, 6, 'DentureComp', 'D5110'), (2541, 1, 6, 'DentureComp', 'D5120'), (2542, 1, 6, 'DentureComp', 'D5130'), (2543, 1, 6, 'DentureComp', 'D5140'), (2544, 1, 6, 'DentureComp', '5110T'), (2545, 1, 6, 'DentureComp', '5110S'), (2546, 1, 6, 'DentureComp', '5120T'), (2547, 1, 6, 'DentureComp', '5120S'), (2548, 1, 6, 'DentureComp', '5130T'), (2549, 1, 6, 'DentureComp', '5130S'), (2550, 1, 6, 'DentureComp', '5140T'), (2551, 1, 6, 'DentureComp', '5140S'), (2552, 1, 6, 'DenturePart', 'D5211'), (2553, 1, 6, 'DenturePart', 'D5212'), (2554, 1, 6, 'DenturePart', 'D5213'), (2556, 1, 6, 'DenturePart', 'D5225'), (2557, 1, 6, 'DenturePart', 'D5226'), (2558, 1, 6, 'DenturePart', 'D5214'), (2559, 1, 6, 'Implant', 'D6010'), (2560, 1, 6, 'Implant', '6010x'), (2561, 1, 6, 'Crown', 'D2720'), (2562, 1, 6, 'Crown', 'D2740'), (2563, 1, 6, 'Crown', 'D2750'), (2564, 1, 6, 'Crown', 'D2751'), (2565, 1, 6, 'Crown', 'D2752'), (2566, 1, 6, 'Crown', 'D2780'), (2567, 1, 6, 'Crown', 'D2790'), (2568, 1, 6, 'Crown', 'EMAXX'), (2569, 1, 6, 'Crown', 'CosHN'), (2570, 1, 6, 'Crown', 'CosBM'), (2571, 1, 6, 'Crown', 'CosNM'), (2572, 1, 6, 'Veneer', 'D2962'), (2573, 1, 6, 'Bridge', 'D6210'), (2574, 1, 6, 'Bridge', '6210G'), (2575, 1, 6, 'Bridge', 'D6212'), (2576, 1, 6, 'Bridge', 'D6240'), (2577, 1, 6, 'Bridge', 'D6241'), (2578, 1, 6, 'Bridge', 'D6242'), (2579, 1, 6, 'Bridge', 'D6245'), (2580, 1, 6, 'Bridge', 'D6250'), (2581, 1, 6, 'Bridge', 'D6740'), (2582, 1, 6, 'Bridge', 'D6750'), (2583, 1, 6, 'Bridge', 'D6751'), (2584, 1, 6, 'Bridge', 'D6752'), (2585, 1, 6, 'Bridge', 'D6790'), (2586, 1, 6, 'Bridge', 'EMAXP'), (2587, 1, 6, 'Bridge', 'EMAPB'), (2588, 1, 6, 'Bridge', 'EMAXR'), (2589, 1, 6, 'Bridge', 'EMARB'), (2590, 1, 6, 'CrownImp', 'D6058'), (2591, 1, 6, 'CrownImp', 'D6059'), (2592, 1, 6, 'CrownImp', 'D6060'), (2593, 1, 6, 'CrownImp', 'D6061'), (2594, 1, 6, 'CrownImp', 'D6066'), (2595, 1, 6, 'OccGuard', 'D9940'), (2596, 1, 6, 'OccGuard', 'NTI'), (2597, 1, 6, 'OccGuard', 'NTIxx'), (2598, 1, 6, 'White', 'D9972'), (2599, 1, 6, 'White', 'WHIH'), (2600, 1, 6, 'White', 'WHIHx'), (2601, 1, 6, 'White', 'WHILP'), (2602, 1, 6, 'White', 'WHIL'), (2603, 1, 6, 'White', 'WHILx'), (2604, 1, 6, 'White', 'WHIP'), (2605, 1, 6, 'White', 'WHIPx'), (2606, 1, 6, 'White', 'WHIUP'), (2607, 1, 6, 'CrownSS', 'D2930'), (2608, 1, 6, 'CrownSS', 'D2931'), (2609, 1, 6, 'CrownBuild', 'D2950'), (2610, 1, 6, 'CrownBuild', 'D2952'), (2611, 1, 6, 'CrownBuild', 'D2954'), (2612, 1, 6, 'DentureReline', 'D5730'), (2613, 1, 6, 'DentureReline', 'D5731'), (2614, 1, 6, 'DentureReline', 'D5750'), (2615, 1, 6, 'DentureReline', '5751X'), (2616, 1, 6, 'DentureReline', 'D5751'), (2617, 1, 6, 'DentureReline', 'D5760'), (2618, 1, 6, 'DentureReline', 'D5761'), (2681, 1, 6, 'Bridge', 'D6251'), (2682, 1, 6, 'Bridge', 'D6545'), (3187, 1, 6, 'ResinPost', 'Ptr2'), (3189, 1, 6, 'ResinPost', 'PTR2x'), (3190, 1, 6, 'PerioAR', 'D4381'), (3197, 1, 6, 'PPOrthoCase', '8090P'), (3204, 1, 6, 'CrownCos', 'D2740'), (3205, 1, 6, 'CrownCos', 'CosHN'), (3206, 1, 6, 'CrownCos', 'CosBM'), (3207, 1, 6, 'CrownCos', 'CosNM'), (3208, 1, 6, 'CrownCos', 'D2790'), (3209, 1, 6, 'CrownCos', 'COSup'), (3328, 1, 6, 'Amalgam', 'D2140'), (3329, 1, 6, 'Amalgam', 'D2150'), (3330, 1, 6, 'Amalgam', 'D2160'), (3331, 1, 6, 'Amalgam', 'D2161'), (3578, 1, 6, 'Oracare', 'ORMKx'), (3591, 1, 6, 'Cosmetic', 'D2740'), (3592, 1, 6, 'Cosmetic', 'D2790'), (3593, 1, 6, 'Cosmetic', 'D2962'), (3594, 1, 6, 'Cosmetic', '6210G'), (3595, 1, 6, 'Cosmetic', 'D6245'), (3596, 1, 6, 'Cosmetic', 'D6740'), (3597, 1, 6, 'Cosmetic', 'D6790'), (3598, 1, 6, 'Cosmetic', 'D6058'), (3599, 1, 6, 'Cosmetic', '5110S'), (3600, 1, 6, 'Cosmetic', '5120S'), (3601, 1, 6, 'Cosmetic', '5130S'), (3602, 1, 6, 'Cosmetic', '5140S'), (3603, 1, 6, 'Cosmetic', 'D9972'), (3604, 1, 6, 'Cosmetic', 'WHIHx'), (3605, 1, 6, 'Cosmetic', 'WHILP'), (3606, 1, 6, 'Cosmetic', 'WHILx'), (3607, 1, 6, 'Cosmetic', 'WHIPx'), (3608, 1, 6, 'Cosmetic', 'WHIUP'), (3614, 1, 6, 'Cosmetic', 'CosHN'), (3615, 1, 6, 'Cosmetic', 'CosBM'), (3616, 1, 6, 'Cosmetic', 'CosNM'), (3950, 1, 6, 'SealantRedo', '1351R'), (3951, 1, 6, 'ResinRedo', '2330R'), (3952, 1, 6, 'ResinRedo', '2331R'), (3953, 1, 6, 'ResinRedo', '2332R'), (3954, 1, 6, 'ResinRedo', '2335R'), (3955, 1, 6, 'ResinRedo', '2391R'), (3956, 1, 6, 'ResinRedo', '2392R'), (3957, 1, 6, 'ResinRedo', '2393R'), (3958, 1, 6, 'ResinRedo', '2394R'), (3959, 1, 6, 'DentureRedo', '5110R'), (3960, 1, 6, 'DentureRedo', '5120R'), (3961, 1, 6, 'DentureRedo', '5211R'), (3962, 1, 6, 'DentureRedo', '5212R'), (3963, 1, 6, 'DentureRedo', '5213R'), (3964, 1, 6, 'DentureRedo', '5214R'), (3965, 1, 6, 'CrownRedo', '2740R'), (3966, 1, 6, 'CrownRedo', '2750R'), (3967, 1, 6, 'CrownRedo', '2751R'), (3968, 1, 6, 'CrownRedo', '2752R'), (4101, 1, 6, 'Oracare', 'ORNMx'), (4107, 1, 6, 'Oracare', 'D4921'), (4114, 1, 6, 'Oracare', 'ORDSx'), (4626, 1, 6, 'Oracare', 'ORRMx'), (4631, 1, 6, 'Oracare', 'ORJMx'), (4634, 1, 6, 'Oracare', 'ORCL1'), (4635, 1, 6, 'cosmetic', 'WHIH'), (4636, 1, 6, 'cosmetic', 'WHIP'), (4637, 1, 6, 'cosmetic', 'WHIL'), (4654, 1, 6, 'cosmetic', 'cosup'), (4655, 1, 6, 'DHP', 'DHPRE'), (4669, 1, 6, 'Oracare', 'ORLT1'), (4675, 1, 6, 'ProToothBrush', 'OralB'), (4688, 1, 6, 'Oracare', 'ORSS1'), (4692, 1, 6, 'Oracare', 'ORMGx'), (4700, 1, 6, 'WFL', 'NPWFL'), (4701, 1, 6, 'WFL', 'EPWFL'), (4714, 1, 6, 'RCWFL', 'RCWFL'), (4733, 1, 6, 'NPEMR', 'NTAEX'), (4734, 1, 6, 'NPEMR', 'NTAE'), (4750, 1, 6, 'Oracare', 'ORMDx'), (4764, 1, 6, 'Arestin', 'D4381'), (4778, 1, 6, 'Oracare', 'ORKW1'), (4792, 1, 6, 'Oracare', 'ORCR1'), (4793, 1, 6, 'Oracare', 'ORAA1'), (4800, 1, 6, 'Oracare', 'ORAH2'), (4855, 1, 6, 'OCS', 'NPOCS'), (4955, 1, 6, 'Oracare', 'ORMCC'), (5095, 1, 6, 'Implant', 'D6013'), (5105, 1, 6, 'Implant', 'BNZMX'), (5115, 1, 6, 'Implant', 'BNZMD'), (5125, 1, 6, 'Implant', 'SLVMD'), (5135, 1, 6, 'Implant', 'SLVMX'), (5145, 1, 6, 'Implant', 'GLDMD'), (5155, 1, 6, 'Implant', 'GLDMX'), (5165, 1, 6, 'Implant', 'PLTMD'), (5175, 1, 6, 'Implant', 'PLTMX'), (5725, 1, 6, 'Conscious Sedation', 'D9248'), (6035, 1, 6, 'Oracare3', 'OR3PK'), (6105, 1, 6, 'AllExams', 'D0120'), (6115, 1, 6, 'AllExams', '00120'), (6125, 1, 6, 'AllExams', 'AMCNP'), (6135, 1, 6, 'AllExams', 'AMCLX'), (6145, 1, 6, 'AllExams', 'TxM'), (6155, 1, 6, 'AllExams', 'TxMxx'), (6165, 1, 6, 'AllExams', 'NEADo'), (6175, 1, 6, 'AllExams', 'NAEXX'), (6185, 1, 6, 'AllExams', 'NAE'), (6195, 1, 6, 'AllExams', 'NCE'), (6205, 1, 6, 'AllExams', 'NCExx'), (6215, 1, 6, 'AllExams', 'NMCE'), (6225, 1, 6, 'AllExams', 'NMCEX'), (6235, 1, 6, 'AllExams', 'D0180'), (6245, 1, 6, 'AllExams', '00180'), (6255, 1, 6, 'AllExams', 'TX'), (6265, 1, 6, 'AllExams', 'TXXXX'), (6275, 1, 6, 'AllExams', 'D0150'), (6285, 1, 6, 'AllExams', '00150'), (6295, 1, 6, 'AllExams', 'D0140'), (6305, 1, 6, 'AllExams', '00140'), (8415, 1, 6, 'DHP', 'DHPCC'), (8665, 1, 6, 'DHPNew', 'DHPAC'), (8675, 1, 6, 'DHPNew', 'DHPCC'), (8785, 1, 6, 'test', 'test'); -- -- Indexes for dumped tables -- -- -- Indexes for table `code_map` -- ALTER TABLE `code_map` ADD PRIMARY KEY (`id`), ADD KEY `service_category` (`service_category`), ADD KEY `service_code` (`service_code`), ADD KEY `site_id` (`site_id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `code_map` -- ALTER TABLE `code_map` MODIFY `id` int(5) NOT NULL AUTO_INCREMENT COMMENT 'row_id', AUTO_INCREMENT=8786; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; -- phpMyAdmin SQL Dump -- version 4.6.6deb5 -- https://www.phpmyadmin.net/ -- -- Host: localhost -- Generation Time: Nov 20, 2018 at 11:16 PM -- Server version: 5.6.30-1-log -- PHP Version: 7.3.0RC4 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `hop-test` -- -- -------------------------------------------------------- -- -- Table structure for table `transaction_data` -- DROP TABLE IF EXISTS `transaction_data`; CREATE TABLE `transaction_data` ( `site_id` int(5) NOT NULL COMMENT 'site id number', `status` varchar(30) NOT NULL, `fee` decimal(8,2) NOT NULL, `amount` decimal(8,2) NOT NULL COMMENT 'dollar amount of transaction', `service_code` varchar(20) NOT NULL COMMENT 'service code from ppm', `tran_date` datetime NOT NULL, `impacts` varchar(30) NOT NULL, `type` varchar(30) NOT NULL, `provider` varchar(100) NOT NULL, `provider_position` varchar(50) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 PARTITION BY HASH (site_id) PARTITIONS 20; -- -- Dumping data for table `transaction_data` -- INSERT INTO `transaction_data` (`site_id`, `status`, `fee`, `amount`, `service_code`, `tran_date`, `impacts`, `type`, `provider`, `provider_position`) VALUES (6, 'A', '313.97', '-25.00', 'null', '2018-11-01 00:00:00', 'C', 'P', 'Provider 3', 'Hygienist'), (6, 'A', '313.97', '-55.00', 'null', '2018-11-01 00:00:00', 'C', 'P', 'Provider 3', 'Hygienist'), (6, 'A', '313.97', '-37.00', 'null', '2018-11-01 00:00:00', 'C', 'P', 'Provider 3', 'Hygienist'), (6, 'A', '313.97', '-28.97', 'null', '2018-11-01 00:00:00', 'C', 'P', 'Provider 3', 'Hygienist'), (6, 'A', '313.97', '-15.00', 'null', '2018-11-01 00:00:00', 'C', 'P', 'Provider 3', 'Hygienist'), (6, 'A', '313.97', '-10.00', 'null', '2018-11-01 00:00:00', 'C', 'P', 'Provider 3', 'Hygienist'), (6, 'A', '313.97', '-20.00', 'null', '2018-11-01 00:00:00', 'C', 'P', 'Provider 3', 'Hygienist'), (6, 'A', '181.00', '-46.00', 'null', '2018-11-01 00:00:00', 'C', 'P', 'Provider 1', 'Hygienist'), (6, 'A', '181.00', '-48.00', 'null', '2018-11-01 00:00:00', 'C', 'P', 'Provider 1', 'Hygienist'), (6, 'A', '181.00', '-87.00', 'null', '2018-11-01 00:00:00', 'C', 'P', 'Provider 1', 'Hygienist'), (6, 'A', '151.00', '151.00', 'D7140', '2018-11-01 00:00:00', 'P', 'S', 'Provider 2', 'Dentist'), (6, 'A', '30.00', '30.00', 'D0220', '2018-11-01 00:00:00', 'P', 'S', 'Provider 2', 'Dentist'), (6, 'A', '83.00', '83.00', 'TX', '2018-11-01 00:00:00', 'P', 'S', 'Provider 2', 'Dentist'), (6, 'A', '0.00', '0.00', 'IOEPX', '2018-11-01 00:00:00', 'P', 'S', 'Provider 2', 'Dentist'), (6, 'A', '28.00', '28.00', 'D0120', '2018-11-01 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'D1330', '2018-11-01 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '48.00', '48.00', 'D0431', '2018-11-01 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '52.00', '52.00', 'PRA', '2018-11-01 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '24.00', '24.00', 'FL21O', '2018-11-01 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'IOEPX', '2018-11-01 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'PROBE', '2018-11-01 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '-113.00', 'null', '2018-11-01 00:00:00', 'C', 'A', 'Provider 2', 'Dentist'), (6, 'A', '0.00', '-24.00', 'null', '2018-11-01 00:00:00', 'C', 'A', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '-24.00', 'null', '2018-11-01 00:00:00', 'C', 'A', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '-24.00', 'null', '2018-11-01 00:00:00', 'C', 'A', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '-29.57', 'null', '2018-11-01 00:00:00', 'C', 'A', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '-15.60', 'null', '2018-11-01 00:00:00', 'C', 'A', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '-64.83', 'null', '2018-11-01 00:00:00', 'C', 'A', 'Provider 2', 'Dentist'), (6, 'A', '0.00', '0.00', 'ORACR', '2018-11-02 00:00:00', 'P', 'S', 'Provider 2', 'Dentist'), (6, 'A', '0.00', '511.84', 'null', '2018-11-02 00:00:00', 'D', 'D', 'Provider 2', 'Dentist'), (6, 'A', '92.00', '92.00', 'MIC1', '2018-11-02 00:00:00', 'P', 'S', 'Provider 2', 'Dentist'), (6, 'A', '92.00', '92.00', 'MIC1', '2018-11-02 00:00:00', 'P', 'S', 'Provider 2', 'Dentist'), (6, 'A', '0.00', '33.16', 'null', '2018-11-02 00:00:00', 'D', 'D', 'Provider 2', 'Dentist'), (6, 'A', '0.00', '0.00', 'ADJUS', '2018-11-02 00:00:00', 'P', 'S', 'Provider 2', 'Dentist'), (6, 'A', '46.00', '46.00', 'D0120', '2018-11-02 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'D1330', '2018-11-02 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '87.00', '87.00', 'PRA', '2018-11-02 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '36.00', '36.00', 'FL21O', '2018-11-02 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'IOEPX', '2018-11-02 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '48.00', '48.00', 'D0431', '2018-11-02 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '-46.00', 'null', '2018-11-02 00:00:00', 'C', 'A', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '-87.00', 'null', '2018-11-02 00:00:00', 'C', 'A', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '-36.00', 'null', '2018-11-02 00:00:00', 'C', 'A', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '-41.49', 'null', '2018-11-02 00:00:00', 'C', 'A', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '-6.51', 'null', '2018-11-02 00:00:00', 'A', 'C', 'Provider 3', 'Hygienist'), (6, 'A', '28.00', '28.00', 'D0120', '2018-11-02 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '52.00', '52.00', 'PRA', '2018-11-02 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '24.00', '24.00', 'FLU21', '2018-11-02 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'IOEPX', '2018-11-02 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'NSERT', '2018-11-02 00:00:00', 'P', 'S', 'Provider 2', 'Dentist'), (6, 'A', '0.00', '0.00', 'CMENT', '2018-11-02 00:00:00', 'P', 'S', 'Provider 2', 'Dentist'), (6, 'A', '0.00', '0.00', 'POBWX', '2018-11-02 00:00:00', 'P', 'S', 'Provider 2', 'Dentist'), (6, 'A', '0.00', '-55.20', 'null', '2018-11-02 00:00:00', 'C', 'A', 'Provider 2', 'Dentist'), (6, 'A', '0.00', '-55.20', 'null', '2018-11-02 00:00:00', 'C', 'A', 'Provider 2', 'Dentist'), (6, 'A', '0.00', '-55.20', 'null', '2018-11-02 00:00:00', 'C', 'A', 'Provider 2', 'Dentist'), (6, 'D', '46.00', '46.00', 'D0120', '2018-11-02 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'D1330', '2018-11-02 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'D', '87.00', '87.00', 'PRA', '2018-11-02 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'D', '36.00', '36.00', 'FL21O', '2018-11-02 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'IOEPX', '2018-11-02 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'V', '0.00', '-36.00', 'FL21O', '2018-11-02 00:00:00', 'P', 'C', 'Provider 3', 'Hygienist'), (6, 'A', '24.00', '24.00', 'FL21O', '2018-11-02 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'V', '0.00', '-87.00', 'PRA', '2018-11-02 00:00:00', 'P', 'C', 'Provider 3', 'Hygienist'), (6, 'A', '52.00', '52.00', 'PRA', '2018-11-02 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'V', '0.00', '-46.00', 'D0120', '2018-11-02 00:00:00', 'P', 'C', 'Provider 3', 'Hygienist'), (6, 'A', '28.00', '28.00', 'D0120', '2018-11-02 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '-24.00', 'null', '2018-11-02 00:00:00', 'C', 'A', 'Provider 2', 'Dentist'), (6, 'A', '92.00', '92.00', 'PTR1', '2018-11-02 00:00:00', 'P', 'S', 'Provider 2', 'Dentist'), (6, 'A', '92.00', '92.00', 'PTR1', '2018-11-02 00:00:00', 'P', 'S', 'Provider 2', 'Dentist'), (6, 'A', '92.00', '92.00', 'PTR1', '2018-11-02 00:00:00', 'P', 'S', 'Provider 2', 'Dentist'), (6, 'A', '259.00', '259.00', 'D4341', '2018-11-02 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '259.00', '259.00', 'D4341', '2018-11-02 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'POBWX', '2018-11-02 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'null', '2018-11-02 00:00:00', 'C', 'P', 'Provider 2', 'Dentist'), (6, 'A', '62.37', '-62.37', 'null', '2018-11-02 00:00:00', 'C', 'I', 'Provider 2', 'Dentist'), (6, 'A', '314.00', '-83.00', 'null', '2018-11-02 00:00:00', 'C', 'P', 'Provider 1', 'Hygienist'), (6, 'A', '314.00', '-146.00', 'null', '2018-11-02 00:00:00', 'C', 'P', 'Provider 1', 'Hygienist'), (6, 'A', '314.00', '-85.00', 'null', '2018-11-02 00:00:00', 'C', 'P', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '0.00', 'BITEX', '2018-11-02 00:00:00', 'P', 'S', 'Provider 2', 'Dentist'), (6, 'A', '354.00', '-83.00', 'null', '2018-11-02 00:00:00', 'C', 'P', 'Provider 1', 'Hygienist'), (6, 'A', '354.00', '-148.00', 'null', '2018-11-02 00:00:00', 'C', 'P', 'Provider 1', 'Hygienist'), (6, 'A', '354.00', '-87.00', 'null', '2018-11-02 00:00:00', 'C', 'P', 'Provider 1', 'Hygienist'), (6, 'A', '354.00', '-36.00', 'null', '2018-11-02 00:00:00', 'C', 'P', 'Provider 1', 'Hygienist'), (6, 'A', '354.00', '-83.00', 'null', '2018-11-02 00:00:00', 'C', 'P', 'Provider 1', 'Hygienist'), (6, 'A', '354.00', '-148.00', 'null', '2018-11-02 00:00:00', 'C', 'P', 'Provider 1', 'Hygienist'), (6, 'A', '354.00', '-87.00', 'null', '2018-11-02 00:00:00', 'C', 'P', 'Provider 1', 'Hygienist'), (6, 'A', '354.00', '-36.00', 'null', '2018-11-02 00:00:00', 'C', 'P', 'Provider 1', 'Hygienist'), (6, 'A', '64.00', '-22.40', 'null', '2018-11-02 00:00:00', 'C', 'P', 'Provider 3', 'Hygienist'), (6, 'A', '64.00', '-41.60', 'null', '2018-11-02 00:00:00', 'C', 'P', 'Provider 3', 'Hygienist'), (6, 'A', '64.00', '-22.40', 'null', '2018-11-02 00:00:00', 'C', 'P', 'Provider 1', 'Hygienist'), (6, 'A', '64.00', '-41.60', 'null', '2018-11-02 00:00:00', 'C', 'P', 'Provider 1', 'Hygienist'), (6, 'A', '608.30', '-608.30', 'null', '2018-11-02 00:00:00', 'C', 'P', 'Provider 2', 'Dentist'), (6, 'A', '192.00', '-48.00', 'null', '2018-11-02 00:00:00', 'C', 'P', 'Provider 1', 'Hygienist'), (6, 'A', '192.00', '-92.00', 'null', '2018-11-02 00:00:00', 'C', 'P', 'Provider 1', 'Hygienist'), (6, 'A', '192.00', '-52.00', 'null', '2018-11-02 00:00:00', 'C', 'P', 'Provider 1', 'Hygienist'), (6, 'A', '785.00', '785.00', 'EMAXX', '2018-11-02 00:00:00', 'P', 'S', 'Provider 2', 'Dentist'), (6, 'A', '0.00', '-83.00', 'null', '2018-11-02 00:00:00', 'C', 'A', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '-2.00', 'null', '2018-11-02 00:00:00', 'C', 'A', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'D0145', '2018-11-02 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'D0274', '2018-11-02 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', '9910P', '2018-11-02 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'D0220', '2018-11-02 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'D0230', '2018-11-02 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'D0120', '2018-11-02 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'IOEPX', '2018-11-02 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'D1330', '2018-11-02 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'PERMD', '2018-11-02 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'ADJUS', '2018-11-02 00:00:00', 'P', 'S', 'Provider 2', 'Dentist'), (6, 'A', '42.00', '42.00', 'ORACR', '2018-11-02 00:00:00', 'P', 'S', 'Provider 2', 'Dentist'), (6, 'A', '0.00', '-42.00', 'null', '2018-11-02 00:00:00', 'C', 'A', 'Provider 2', 'Dentist'), (6, 'A', '0.00', '-9.30', 'null', '2018-11-02 00:00:00', 'C', 'A', 'Provider 2', 'Dentist'), (6, 'A', '0.00', '-27.60', 'null', '2018-11-02 00:00:00', 'C', 'A', 'Provider 2', 'Dentist'), (6, 'A', '0.00', '-33.00', 'null', '2018-11-02 00:00:00', 'C', 'A', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '-118.00', 'null', '2018-11-02 00:00:00', 'C', 'A', 'Provider 2', 'Dentist'), (6, 'A', '0.00', '-10.92', 'null', '2018-11-02 00:00:00', 'C', 'A', 'Provider 2', 'Dentist'), (6, 'A', '0.00', '-7.08', 'null', '2018-11-02 00:00:00', 'A', 'C', 'Provider 2', 'Dentist'), (6, 'A', '0.00', '0.00', 'NTAE', '2018-11-05 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'D0220', '2018-11-05 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'TATER', '2018-11-05 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '83.00', '83.00', 'NTAE', '2018-11-05 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '104.00', '104.00', 'D0330', '2018-11-05 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'PAEME', '2018-11-05 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '43.00', '43.00', 'D0272', '2018-11-05 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'PROBE', '2018-11-05 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'NPOCS', '2018-11-05 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '158.00', '158.00', 'PTR1', '2018-11-05 00:00:00', 'P', 'S', 'Provider 2', 'Dentist'), (6, 'A', '969.00', '969.00', 'EMAXX', '2018-11-05 00:00:00', 'P', 'S', 'Provider 2', 'Dentist'), (6, 'A', '209.00', '209.00', 'PTR2', '2018-11-05 00:00:00', 'P', 'S', 'Provider 2', 'Dentist'), (6, 'A', '0.00', '-83.00', 'null', '2018-11-05 00:00:00', 'C', 'A', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '-104.00', 'null', '2018-11-05 00:00:00', 'C', 'A', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '-43.00', 'null', '2018-11-05 00:00:00', 'C', 'A', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '-14.73', 'null', '2018-11-05 00:00:00', 'A', 'C', 'Provider 2', 'Dentist'), (6, 'A', '28.00', '28.00', 'D0120', '2018-11-05 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '38.00', '38.00', 'D0274', '2018-11-05 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '0.00', 'D1330', '2018-11-05 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '52.00', '52.00', 'PRA', '2018-11-05 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '15.00', '15.00', 'D0220', '2018-11-05 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '14.00', '14.00', 'D0230', '2018-11-05 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '0.00', 'PROBE', '2018-11-05 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '24.00', '24.00', 'FL21O', '2018-11-05 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '0.00', 'IOEPX', '2018-11-05 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '0.00', 'RCWFL', '2018-11-05 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '-28.00', 'null', '2018-11-05 00:00:00', 'C', 'A', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '-5.00', 'null', '2018-11-05 00:00:00', 'C', 'A', 'Provider 1', 'Hygienist'), (6, 'A', '261.00', '261.00', 'D2335', '2018-11-05 00:00:00', 'P', 'S', 'Provider 2', 'Dentist'), (6, 'A', '30.00', '30.00', 'D0220', '2018-11-05 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '0.00', 'IOEPX', '2018-11-05 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '83.00', '83.00', 'NCE', '2018-11-05 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '36.00', '36.00', 'FL21O', '2018-11-05 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'PROBE', '2018-11-05 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '87.00', '87.00', 'PRA', '2018-11-05 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '48.00', '48.00', 'D0431', '2018-11-05 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'D1330', '2018-11-05 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '46.00', '46.00', 'D0120', '2018-11-05 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'IOEPX', '2018-11-05 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '148.00', '148.00', 'D0210', '2018-11-05 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '-18.75', 'null', '2018-11-05 00:00:00', 'A', 'C', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '-17.25', 'null', '2018-11-05 00:00:00', 'C', 'A', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '-87.00', 'null', '2018-11-05 00:00:00', 'C', 'A', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '-48.00', 'null', '2018-11-05 00:00:00', 'C', 'A', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '-46.00', 'null', '2018-11-05 00:00:00', 'C', 'A', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '-148.00', 'null', '2018-11-05 00:00:00', 'C', 'A', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '-30.00', 'null', '2018-11-05 00:00:00', 'C', 'A', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '-83.00', 'null', '2018-11-05 00:00:00', 'C', 'A', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '0.00', 'TACHR', '2018-11-05 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '83.00', '83.00', 'NTAE', '2018-11-05 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '104.00', '104.00', 'D0330', '2018-11-05 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '0.00', 'PAEME', '2018-11-05 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '43.00', '43.00', 'D0272', '2018-11-05 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '0.00', 'BLOPR', '2018-11-05 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '-50.00', 'null', '2018-11-05 00:00:00', 'C', 'A', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '0.00', 'NPCHR', '2018-11-05 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'NPOCS', '2018-11-05 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'IONPX', '2018-11-05 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '83.00', '83.00', 'NAE', '2018-11-05 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '148.00', '148.00', 'D0210', '2018-11-05 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '-6.93', 'null', '2018-11-05 00:00:00', 'A', 'C', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '-76.07', 'null', '2018-11-05 00:00:00', 'C', 'A', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '-148.00', 'null', '2018-11-05 00:00:00', 'C', 'A', 'Provider 3', 'Hygienist'), (6, 'A', '46.00', '46.00', 'D0120', '2018-11-05 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '0.00', 'D1330', '2018-11-05 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '87.00', '87.00', 'PRA', '2018-11-05 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '0.00', 'PROBE', '2018-11-05 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '0.00', 'IOEPX', '2018-11-05 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '-46.00', 'null', '2018-11-05 00:00:00', 'C', 'A', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '-87.00', 'null', '2018-11-05 00:00:00', 'C', 'A', 'Provider 1', 'Hygienist'), (6, 'D', '46.00', '46.00', 'D0120', '2018-11-05 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'D', '0.00', '0.00', 'D1330', '2018-11-05 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'D', '87.00', '87.00', 'PRA', '2018-11-05 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'D', '0.00', '0.00', 'PROBE', '2018-11-05 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'D', '0.00', '0.00', 'IOEPX', '2018-11-05 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '690.20', '690.20', 'D3320', '2018-11-05 00:00:00', 'P', 'S', 'Provider 2', 'Dentist'), (6, 'A', '823.65', '823.65', 'EMAXX', '2018-11-05 00:00:00', 'P', 'S', 'Provider 2', 'Dentist'), (6, 'A', '211.65', '211.65', 'D2950', '2018-11-05 00:00:00', 'P', 'S', 'Provider 2', 'Dentist'), (6, 'A', '85.00', '85.00', 'D2330', '2018-11-05 00:00:00', 'P', 'S', 'Provider 2', 'Dentist'), (6, 'A', '40.00', '40.00', 'D9230', '2018-11-05 00:00:00', 'P', 'S', 'Provider 2', 'Dentist'), (6, 'A', '0.00', '0.00', 'NPCHR', '2018-11-05 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '-105.80', 'null', '2018-11-05 00:00:00', 'C', 'A', 'Provider 2', 'Dentist'), (6, 'A', '46.00', '46.00', 'D0120', '2018-11-05 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'D1330', '2018-11-05 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '87.00', '87.00', 'PRA', '2018-11-05 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '36.00', '36.00', 'FL21O', '2018-11-05 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'IOEPX', '2018-11-05 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'PROBE', '2018-11-05 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'RCWFL', '2018-11-05 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '46.00', '46.00', 'D0120', '2018-11-05 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '87.00', '87.00', 'PRA', '2018-11-05 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '36.00', '36.00', 'FLU21', '2018-11-05 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '0.00', 'IOEPX', '2018-11-05 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '116.00', '116.00', 'PTR1', '2018-11-05 00:00:00', 'P', 'S', 'Provider 2', 'Dentist'), (6, 'A', '47.00', '47.00', '1351A', '2018-11-05 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '47.00', '47.00', '1351A', '2018-11-05 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '47.00', '47.00', '1351A', '2018-11-05 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '47.00', '47.00', '1351A', '2018-11-05 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '-46.00', 'null', '2018-11-05 00:00:00', 'C', 'A', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '-87.00', 'null', '2018-11-05 00:00:00', 'C', 'A', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '-36.00', 'null', '2018-11-05 00:00:00', 'C', 'A', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'TASTE', '2018-11-05 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '83.00', '83.00', 'NTAE', '2018-11-05 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '104.00', '104.00', 'D0330', '2018-11-05 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'PAEME', '2018-11-05 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '43.00', '43.00', 'D0272', '2018-11-05 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '-128.00', 'null', '2018-11-05 00:00:00', 'C', 'A', 'Provider 2', 'Dentist'), (6, 'A', '0.00', '-1477.00', 'null', '2018-11-05 00:00:00', 'C', 'A', 'Provider 2', 'Dentist'), (6, 'A', '0.00', '-63.33', 'null', '2018-11-05 00:00:00', 'A', 'C', 'Provider 2', 'Dentist'), (6, 'A', '0.00', '-83.00', 'null', '2018-11-05 00:00:00', 'C', 'A', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '-104.00', 'null', '2018-11-05 00:00:00', 'C', 'A', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '-36.10', 'null', '2018-11-05 00:00:00', 'C', 'A', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '-6.90', 'null', '2018-11-05 00:00:00', 'A', 'C', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'CNFRE', '2018-11-05 00:00:00', 'P', 'S', 'Provider 2', 'Dentist'), (6, 'A', '52.00', '52.00', 'PRD', '2018-11-05 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '28.00', '28.00', 'D0120', '2018-11-05 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '48.00', '48.00', 'D0431', '2018-11-05 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '0.00', 'PROBE', '2018-11-05 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '0.00', 'D1330', '2018-11-05 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '24.00', '24.00', 'FL21O', '2018-11-05 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '0.00', 'IOEPX', '2018-11-05 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '15.00', '15.00', 'D0220', '2018-11-05 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '350.00', '-83.00', 'null', '2018-11-05 00:00:00', 'C', 'P', 'Provider 3', 'Hygienist'), (6, 'A', '350.00', '-146.00', 'null', '2018-11-05 00:00:00', 'C', 'P', 'Provider 3', 'Hygienist'), (6, 'A', '350.00', '-85.00', 'null', '2018-11-05 00:00:00', 'C', 'P', 'Provider 3', 'Hygienist'), (6, 'A', '350.00', '-36.00', 'null', '2018-11-05 00:00:00', 'C', 'P', 'Provider 3', 'Hygienist'), (6, 'A', '113.60', '-2.40', 'null', '2018-11-05 00:00:00', 'C', 'P', 'Provider 1', 'Hygienist'), (6, 'A', '113.60', '-32.80', 'null', '2018-11-05 00:00:00', 'C', 'P', 'Provider 1', 'Hygienist'), (6, 'A', '113.60', '-19.20', 'null', '2018-11-05 00:00:00', 'C', 'P', 'Provider 1', 'Hygienist'), (6, 'A', '113.60', '-59.20', 'null', '2018-11-05 00:00:00', 'C', 'P', 'Provider 1', 'Hygienist'), (6, 'A', '249.00', '-46.00', 'null', '2018-11-05 00:00:00', 'C', 'P', 'Provider 3', 'Hygienist'), (6, 'A', '249.00', '-60.00', 'null', '2018-11-05 00:00:00', 'C', 'P', 'Provider 3', 'Hygienist'), (6, 'A', '249.00', '-87.00', 'null', '2018-11-05 00:00:00', 'C', 'P', 'Provider 3', 'Hygienist'), (6, 'A', '249.00', '-30.00', 'null', '2018-11-05 00:00:00', 'C', 'P', 'Provider 3', 'Hygienist'), (6, 'A', '249.00', '-26.00', 'null', '2018-11-05 00:00:00', 'C', 'P', 'Provider 3', 'Hygienist'), (6, 'A', '193.00', '-25.00', 'null', '2018-11-05 00:00:00', 'C', 'P', 'Provider 1', 'Hygienist'), (6, 'A', '193.00', '-25.00', 'null', '2018-11-05 00:00:00', 'C', 'P', 'Provider 1', 'Hygienist'), (6, 'A', '193.00', '-40.00', 'null', '2018-11-05 00:00:00', 'C', 'P', 'Provider 1', 'Hygienist'), (6, 'A', '193.00', '-15.00', 'null', '2018-11-05 00:00:00', 'C', 'P', 'Provider 1', 'Hygienist'), (6, 'A', '193.00', '-10.00', 'null', '2018-11-05 00:00:00', 'C', 'P', 'Provider 1', 'Hygienist'), (6, 'A', '193.00', '-20.00', 'null', '2018-11-05 00:00:00', 'C', 'P', 'Provider 1', 'Hygienist'), (6, 'A', '576.00', '-93.00', 'null', '2018-11-05 00:00:00', 'C', 'P', 'Provider 2', 'Dentist'), (6, 'A', '576.00', '-80.00', 'null', '2018-11-05 00:00:00', 'C', 'P', 'Provider 2', 'Dentist'), (6, 'A', '576.00', '-80.00', 'null', '2018-11-05 00:00:00', 'C', 'P', 'Provider 2', 'Dentist'), (6, 'A', '576.00', '-80.00', 'null', '2018-11-05 00:00:00', 'C', 'P', 'Provider 2', 'Dentist'), (6, 'A', '576.00', '-80.00', 'null', '2018-11-05 00:00:00', 'C', 'P', 'Provider 2', 'Dentist'), (6, 'A', '576.00', '-40.00', 'null', '2018-11-05 00:00:00', 'C', 'P', 'Provider 2', 'Dentist'), (6, 'A', '230.00', '-83.00', 'null', '2018-11-05 00:00:00', 'C', 'P', 'Provider 1', 'Hygienist'), (6, 'A', '230.00', '-104.00', 'null', '2018-11-05 00:00:00', 'C', 'P', 'Provider 1', 'Hygienist'), (6, 'A', '230.00', '-43.00', 'null', '2018-11-05 00:00:00', 'C', 'P', 'Provider 1', 'Hygienist'), (6, 'A', '318.00', '-83.00', 'null', '2018-11-05 00:00:00', 'C', 'P', 'Provider 1', 'Hygienist'), (6, 'A', '318.00', '-148.00', 'null', '2018-11-05 00:00:00', 'C', 'P', 'Provider 1', 'Hygienist'), (6, 'A', '318.00', '-87.00', 'null', '2018-11-05 00:00:00', 'C', 'P', 'Provider 1', 'Hygienist'), (6, 'A', '80.00', '-28.00', 'null', '2018-11-05 00:00:00', 'C', 'P', 'Provider 1', 'Hygienist'), (6, 'A', '80.00', '-52.00', 'null', '2018-11-05 00:00:00', 'C', 'P', 'Provider 1', 'Hygienist'), (6, 'A', '52.00', '52.00', 'PRNA', '2018-11-05 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '0.00', 'D1330', '2018-11-05 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '24.00', '24.00', 'FL21O', '2018-11-05 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '0.00', 'IOEPX', '2018-11-05 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '0.00', 'FMXNF', '2018-11-05 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '0.00', 'NPOCS', '2018-11-05 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '0.00', 'NPWFL', '2018-11-05 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '192.00', '-48.00', 'null', '2018-11-05 00:00:00', 'C', 'P', 'Provider 1', 'Hygienist'), (6, 'A', '192.00', '-92.00', 'null', '2018-11-05 00:00:00', 'C', 'P', 'Provider 1', 'Hygienist'), (6, 'A', '192.00', '-52.00', 'null', '2018-11-05 00:00:00', 'C', 'P', 'Provider 1', 'Hygienist'), (6, 'A', '80.00', '-28.00', 'null', '2018-11-05 00:00:00', 'C', 'P', 'Provider 3', 'Hygienist'), (6, 'A', '80.00', '-52.00', 'null', '2018-11-05 00:00:00', 'C', 'P', 'Provider 3', 'Hygienist'), (6, 'A', '80.00', '-28.00', 'null', '2018-11-05 00:00:00', 'C', 'P', 'Provider 1', 'Hygienist'), (6, 'A', '80.00', '-52.00', 'null', '2018-11-05 00:00:00', 'C', 'P', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '-229.62', 'null', '2018-11-05 00:00:00', 'C', 'A', 'Provider 2', 'Dentist'), (6, 'A', '0.00', '-155.00', 'null', '2018-11-05 00:00:00', 'C', 'A', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '-472.88', 'null', '2018-11-05 00:00:00', 'C', 'A', 'Provider 2', 'Dentist'), (6, 'A', '171.00', '-28.00', 'null', '2018-11-05 00:00:00', 'C', 'P', 'Provider 3', 'Hygienist'), (6, 'A', '171.00', '-38.00', 'null', '2018-11-05 00:00:00', 'C', 'P', 'Provider 3', 'Hygienist'), (6, 'A', '171.00', '-52.00', 'null', '2018-11-05 00:00:00', 'C', 'P', 'Provider 3', 'Hygienist'), (6, 'A', '171.00', '-15.00', 'null', '2018-11-05 00:00:00', 'C', 'P', 'Provider 3', 'Hygienist'), (6, 'A', '171.00', '-14.00', 'null', '2018-11-05 00:00:00', 'C', 'P', 'Provider 3', 'Hygienist'), (6, 'A', '171.00', '-24.00', 'null', '2018-11-05 00:00:00', 'C', 'P', 'Provider 3', 'Hygienist'), (6, 'A', '192.00', '-52.00', 'null', '2018-11-05 00:00:00', 'C', 'P', 'Provider 3', 'Hygienist'), (6, 'A', '192.00', '-92.00', 'null', '2018-11-05 00:00:00', 'C', 'P', 'Provider 3', 'Hygienist'), (6, 'A', '192.00', '-48.00', 'null', '2018-11-05 00:00:00', 'C', 'P', 'Provider 3', 'Hygienist'), (6, 'A', '137.60', '-64.00', 'null', '2018-11-05 00:00:00', 'C', 'P', 'Provider 2', 'Dentist'), (6, 'A', '137.60', '-73.60', 'null', '2018-11-05 00:00:00', 'C', 'P', 'Provider 2', 'Dentist'), (6, 'A', '343.00', '-46.00', 'null', '2018-11-05 00:00:00', 'C', 'P', 'Provider 3', 'Hygienist'), (6, 'A', '343.00', '-43.00', 'null', '2018-11-05 00:00:00', 'C', 'P', 'Provider 3', 'Hygienist'), (6, 'A', '343.00', '-58.00', 'null', '2018-11-05 00:00:00', 'C', 'P', 'Provider 3', 'Hygienist'), (6, 'A', '343.00', '-30.00', 'null', '2018-11-05 00:00:00', 'C', 'P', 'Provider 3', 'Hygienist'), (6, 'A', '343.00', '-26.00', 'null', '2018-11-05 00:00:00', 'C', 'P', 'Provider 3', 'Hygienist'), (6, 'A', '343.00', '-36.00', 'null', '2018-11-05 00:00:00', 'C', 'P', 'Provider 3', 'Hygienist'), (6, 'A', '343.00', '-104.00', 'null', '2018-11-05 00:00:00', 'C', 'P', 'Provider 3', 'Hygienist'), (6, 'A', '133.00', '-28.00', 'null', '2018-11-05 00:00:00', 'C', 'P', 'Provider 3', 'Hygienist'), (6, 'A', '133.00', '-52.00', 'null', '2018-11-05 00:00:00', 'C', 'P', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'null', '2018-11-05 00:00:00', 'C', 'P', 'Provider 2', 'Dentist'), (6, 'A', '609.00', '-484.50', 'null', '2018-11-05 00:00:00', 'C', 'P', 'Provider 2', 'Dentist'), (6, 'A', '609.00', '-124.50', 'null', '2018-11-05 00:00:00', 'C', 'P', 'Provider 2', 'Dentist'), (6, 'A', '0.00', '0.00', 'NPSS', '2018-11-05 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'D', '48.00', '48.00', 'NEADO', '2018-11-05 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'D', '92.00', '92.00', 'D0210', '2018-11-05 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'D', '0.00', '0.00', 'D1320', '2018-11-05 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'D', '24.00', '24.00', 'FLU21', '2018-11-05 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'D', '0.00', '0.00', 'IONPX', '2018-11-05 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'D', '0.00', '0.00', 'D1330', '2018-11-05 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '172.00', '-92.00', 'null', '2018-11-05 00:00:00', 'C', 'P', 'Provider 2', 'Dentist'), (6, 'A', '172.00', '-80.00', 'null', '2018-11-05 00:00:00', 'C', 'P', 'Provider 2', 'Dentist'), (6, 'A', '0.00', '-38.40', 'null', '2018-11-05 00:00:00', 'C', 'A', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '38.40', 'null', '2018-11-05 00:00:00', 'C', 'A', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '-38.40', 'null', '2018-11-05 00:00:00', 'C', 'A', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'null', '2018-11-05 00:00:00', 'C', 'P', 'Provider 2', 'Dentist'), (6, 'A', '128.00', '128.00', 'FLIPR', '2018-11-05 00:00:00', 'P', 'S', 'Provider 2', 'Dentist'), (6, 'A', '1477.00', '1477.00', 'D5213', '2018-11-05 00:00:00', 'P', 'S', 'Provider 2', 'Dentist'), (6, 'A', '147.00', '-28.00', 'null', '2018-11-05 00:00:00', 'C', 'P', 'Provider 3', 'Hygienist'), (6, 'A', '147.00', '-25.00', 'null', '2018-11-05 00:00:00', 'C', 'P', 'Provider 3', 'Hygienist'), (6, 'A', '147.00', '-41.00', 'null', '2018-11-05 00:00:00', 'C', 'P', 'Provider 3', 'Hygienist'), (6, 'A', '147.00', '-15.00', 'null', '2018-11-05 00:00:00', 'C', 'P', 'Provider 3', 'Hygienist'), (6, 'A', '147.00', '-14.00', 'null', '2018-11-05 00:00:00', 'C', 'P', 'Provider 3', 'Hygienist'), (6, 'A', '147.00', '-24.00', 'null', '2018-11-05 00:00:00', 'C', 'P', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'NPSS', '2018-11-05 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'null', '2018-11-05 00:00:00', 'C', 'P', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '-7.59', 'null', '2018-11-05 00:00:00', 'A', 'C', 'Provider 2', 'Dentist'), (6, 'A', '0.00', '0.00', 'CNFRE', '2018-11-05 00:00:00', 'P', 'S', 'Provider 2', 'Dentist'), (6, 'A', '0.00', '0.00', 'null', '2018-11-05 00:00:00', 'C', 'P', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '-83.00', 'null', '2018-11-05 00:00:00', 'C', 'A', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '-148.00', 'null', '2018-11-05 00:00:00', 'C', 'A', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '-8.11', 'null', '2018-11-05 00:00:00', 'C', 'A', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '83.00', 'null', '2018-11-05 00:00:00', 'C', 'A', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '-35.00', 'null', '2018-11-05 00:00:00', 'C', 'A', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '-48.00', 'null', '2018-11-05 00:00:00', 'C', 'A', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '148.00', 'null', '2018-11-05 00:00:00', 'C', 'A', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '-68.00', 'null', '2018-11-05 00:00:00', 'C', 'A', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '-80.00', 'null', '2018-11-05 00:00:00', 'C', 'A', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '-7.40', 'null', '2018-11-05 00:00:00', 'A', 'C', 'Provider 3', 'Hygienist'), (6, 'V', '0.00', '-48.00', 'NEADO', '2018-11-05 00:00:00', 'P', 'C', 'Provider 3', 'Hygienist'), (6, 'V', '0.00', '-92.00', 'D0210', '2018-11-05 00:00:00', 'P', 'C', 'Provider 3', 'Hygienist'), (6, 'V', '0.00', '0.00', 'D1320', '2018-11-05 00:00:00', 'P', 'C', 'Provider 3', 'Hygienist'), (6, 'V', '0.00', '-24.00', 'FLU21', '2018-11-05 00:00:00', 'P', 'C', 'Provider 3', 'Hygienist'), (6, 'V', '0.00', '0.00', 'IONPX', '2018-11-05 00:00:00', 'P', 'C', 'Provider 3', 'Hygienist'), (6, 'V', '0.00', '0.00', 'D1330', '2018-11-05 00:00:00', 'P', 'C', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'PROBE', '2018-11-05 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'NPOCS', '2018-11-05 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'D1330', '2018-11-05 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'IONPX', '2018-11-05 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '48.00', '48.00', 'NAE', '2018-11-05 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'NPWFL', '2018-11-05 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '92.00', '92.00', 'D0210', '2018-11-05 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '52.00', '52.00', 'PRNA', '2018-11-05 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '24.00', '24.00', 'FL21O', '2018-11-05 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '28.00', '28.00', 'D0120', '2018-11-05 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '38.00', '38.00', 'D0274', '2018-11-05 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '0.00', 'D1330', '2018-11-05 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '52.00', '52.00', 'PRA', '2018-11-05 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '15.00', '15.00', 'D0220', '2018-11-05 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '14.00', '14.00', 'D0230', '2018-11-05 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '0.00', 'PROBE', '2018-11-05 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '0.00', 'IOEPX', '2018-11-05 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '0.00', 'RCWFL', '2018-11-05 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '155.00', '155.00', 'D4910', '2018-11-05 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'PROBE', '2018-11-05 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', '9910P', '2018-11-05 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '46.00', '46.00', 'D0120', '2018-11-05 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'IOEPX', '2018-11-05 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'D1330', '2018-11-05 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'RCWFL', '2018-11-05 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '-23.25', 'null', '2018-11-05 00:00:00', 'C', 'A', 'Provider 3', 'Hygienist'), (6, 'V', '0.00', '-46.00', 'D0120', '2018-11-05 00:00:00', 'P', 'C', 'Provider 1', 'Hygienist'), (6, 'V', '0.00', '0.00', 'D1330', '2018-11-05 00:00:00', 'P', 'C', 'Provider 1', 'Hygienist'), (6, 'V', '0.00', '-87.00', 'PRA', '2018-11-05 00:00:00', 'P', 'C', 'Provider 1', 'Hygienist'), (6, 'V', '0.00', '0.00', 'PROBE', '2018-11-05 00:00:00', 'P', 'C', 'Provider 1', 'Hygienist'), (6, 'V', '0.00', '0.00', 'IOEPX', '2018-11-05 00:00:00', 'P', 'C', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '0.00', 'IOEPX', '2018-11-05 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '0.00', 'FLU21', '2018-11-05 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '0.00', 'D0230', '2018-11-05 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '0.00', 'D0220', '2018-11-05 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '0.00', 'D1320', '2018-11-05 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '0.00', 'PRC', '2018-11-05 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '0.00', 'D1330', '2018-11-05 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '0.00', 'D0272', '2018-11-05 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '0.00', 'D0120', '2018-11-05 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '0.00', 'NCE', '2018-11-05 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'PRNC', '2018-11-05 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'D1330', '2018-11-05 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'FLU21', '2018-11-05 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'IONPX', '2018-11-05 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'CMENT', '2018-11-06 00:00:00', 'P', 'S', 'Provider 2', 'Dentist'), (6, 'A', '0.00', '0.00', 'POBWX', '2018-11-06 00:00:00', 'P', 'S', 'Provider 2', 'Dentist'), (6, 'A', '46.00', '46.00', 'D0120', '2018-11-06 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'D1330', '2018-11-06 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '87.00', '87.00', 'PRA', '2018-11-06 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '36.00', '36.00', 'FL21O', '2018-11-06 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'IOEPX', '2018-11-06 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'RCWFL', '2018-11-06 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '-36.00', 'null', '2018-11-06 00:00:00', 'C', 'A', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'CNFRE', '2018-11-06 00:00:00', 'P', 'S', 'Provider 2', 'Dentist'), (6, 'A', '42.00', '42.00', 'ORACR', '2018-11-06 00:00:00', 'P', 'S', 'Provider 2', 'Dentist'), (6, 'A', '0.00', '-42.00', 'null', '2018-11-06 00:00:00', 'C', 'A', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'CMENT', '2018-11-06 00:00:00', 'P', 'S', 'Provider 2', 'Dentist'), (6, 'A', '0.00', '0.00', 'POBWX', '2018-11-06 00:00:00', 'P', 'S', 'Provider 2', 'Dentist'), (6, 'A', '42.00', '42.00', 'ORACR', '2018-11-06 00:00:00', 'P', 'S', 'Provider 2', 'Dentist'), (6, 'A', '0.00', '-36.60', 'null', '2018-11-06 00:00:00', 'C', 'A', 'Provider 2', 'Dentist'), (6, 'A', '0.00', '-5.40', 'null', '2018-11-06 00:00:00', 'C', 'A', 'Provider 2', 'Dentist'), (6, 'A', '0.00', '-42.00', 'null', '2018-11-06 00:00:00', 'C', 'A', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '-52.00', 'null', '2018-11-06 00:00:00', 'C', 'A', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '-15.00', 'null', '2018-11-06 00:00:00', 'C', 'A', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '-14.00', 'null', '2018-11-06 00:00:00', 'C', 'A', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '-24.00', 'null', '2018-11-06 00:00:00', 'C', 'A', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '0.00', 'NPTER', '2018-11-06 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '0.00', 'PROBE', '2018-11-06 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '0.00', 'NPOCS', '2018-11-06 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '0.00', 'D1330', '2018-11-06 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '0.00', 'BLOPR', '2018-11-06 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '0.00', 'IONPX', '2018-11-06 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '83.00', '83.00', 'NAE', '2018-11-06 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '0.00', 'NPWFL', '2018-11-06 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '148.00', '148.00', 'D0210', '2018-11-06 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '87.00', '87.00', 'PRNA', '2018-11-06 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '36.00', '36.00', 'FL21O', '2018-11-06 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '-36.20', 'null', '2018-11-06 00:00:00', 'C', 'A', 'Provider 1', 'Hygienist'), (6, 'A', '46.00', '46.00', 'D0120', '2018-11-06 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '0.00', 'D1330', '2018-11-06 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '36.00', '36.00', 'FLU21', '2018-11-06 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '58.00', '58.00', 'PRC', '2018-11-06 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '0.00', 'IOEPX', '2018-11-06 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '0.00', 'D0210', '2018-11-06 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '0.00', 'D0120', '2018-11-06 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '0.00', 'D1330', '2018-11-06 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '0.00', 'PRA', '2018-11-06 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '0.00', 'FL21O', '2018-11-06 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '0.00', 'IOEPX', '2018-11-06 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '0.00', 'RCWFL', '2018-11-06 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '-7.83', 'null', '2018-11-06 00:00:00', 'A', 'C', 'Provider 2', 'Dentist'), (6, 'A', '0.00', '0.00', 'PROBE', '2018-11-06 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'NPOCS', '2018-11-06 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'D1330', '2018-11-06 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'IONPX', '2018-11-06 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '83.00', '83.00', 'NAE', '2018-11-06 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'NPWFL', '2018-11-06 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '148.00', '148.00', 'D0210', '2018-11-06 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '87.00', '87.00', 'PRNA', '2018-11-06 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '36.00', '36.00', 'FL21O', '2018-11-06 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '261.00', '261.00', 'D2335', '2018-11-06 00:00:00', 'P', 'S', 'Provider 2', 'Dentist'), (6, 'A', '46.00', '46.00', 'D0120', '2018-11-06 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'D1330', '2018-11-06 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '87.00', '87.00', 'PRA', '2018-11-06 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '36.00', '36.00', 'FL21O', '2018-11-06 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'IOEPX', '2018-11-06 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'CMENT', '2018-11-06 00:00:00', 'P', 'S', 'Provider 2', 'Dentist'), (6, 'A', '0.00', '0.00', 'CMENT', '2018-11-06 00:00:00', 'P', 'S', 'Provider 2', 'Dentist'), (6, 'A', '0.00', '0.00', 'POBWX', '2018-11-06 00:00:00', 'P', 'S', 'Provider 2', 'Dentist'), (6, 'A', '641.60', '-46.00', 'null', '2018-11-06 00:00:00', 'C', 'P', 'Provider 3', 'Hygienist'), (6, 'A', '641.60', '-58.00', 'null', '2018-11-06 00:00:00', 'C', 'P', 'Provider 3', 'Hygienist'), (6, 'A', '641.60', '-36.00', 'null', '2018-11-06 00:00:00', 'C', 'P', 'Provider 3', 'Hygienist'), (6, 'A', '641.60', '-48.00', 'null', '2018-11-06 00:00:00', 'C', 'P', 'Provider 3', 'Hygienist'), (6, 'A', '641.60', '-48.00', 'null', '2018-11-06 00:00:00', 'C', 'P', 'Provider 3', 'Hygienist'), (6, 'A', '641.60', '-48.00', 'null', '2018-11-06 00:00:00', 'C', 'P', 'Provider 3', 'Hygienist'), (6, 'A', '641.60', '-48.00', 'null', '2018-11-06 00:00:00', 'C', 'P', 'Provider 3', 'Hygienist'), (6, 'A', '641.60', '-48.00', 'null', '2018-11-06 00:00:00', 'C', 'P', 'Provider 3', 'Hygienist'), (6, 'A', '641.60', '-48.00', 'null', '2018-11-06 00:00:00', 'C', 'P', 'Provider 3', 'Hygienist'), (6, 'A', '268.00', '-46.00', 'null', '2018-11-06 00:00:00', 'C', 'P', 'Provider 1', 'Hygienist'), (6, 'A', '268.00', '-43.00', 'null', '2018-11-06 00:00:00', 'C', 'P', 'Provider 1', 'Hygienist'), (6, 'A', '268.00', '-30.00', 'null', '2018-11-06 00:00:00', 'C', 'P', 'Provider 1', 'Hygienist'), (6, 'A', '268.00', '-26.00', 'null', '2018-11-06 00:00:00', 'C', 'P', 'Provider 1', 'Hygienist'), (6, 'A', '268.00', '-36.00', 'null', '2018-11-06 00:00:00', 'C', 'P', 'Provider 1', 'Hygienist'), (6, 'A', '268.00', '-87.00', 'null', '2018-11-06 00:00:00', 'C', 'P', 'Provider 1', 'Hygienist'), (6, 'A', '133.00', '-87.00', 'null', '2018-11-06 00:00:00', 'C', 'P', 'Provider 1', 'Hygienist'), (6, 'A', '133.00', '-46.00', 'null', '2018-11-06 00:00:00', 'C', 'P', 'Provider 1', 'Hygienist'), (6, 'A', '239.00', '-26.00', 'null', '2018-11-06 00:00:00', 'C', 'P', 'Provider 3', 'Hygienist'), (6, 'A', '239.00', '-30.00', 'null', '2018-11-06 00:00:00', 'C', 'P', 'Provider 3', 'Hygienist'), (6, 'A', '239.00', '-58.00', 'null', '2018-11-06 00:00:00', 'C', 'P', 'Provider 3', 'Hygienist'), (6, 'A', '239.00', '-43.00', 'null', '2018-11-06 00:00:00', 'C', 'P', 'Provider 3', 'Hygienist'), (6, 'A', '239.00', '-46.00', 'null', '2018-11-06 00:00:00', 'C', 'P', 'Provider 3', 'Hygienist'), (6, 'A', '239.00', '-36.00', 'null', '2018-11-06 00:00:00', 'C', 'P', 'Provider 3', 'Hygienist'), (6, 'A', '431.00', '-46.00', 'null', '2018-11-06 00:00:00', 'C', 'P', 'Provider 1', 'Hygienist'), (6, 'A', '431.00', '-43.00', 'null', '2018-11-06 00:00:00', 'C', 'P', 'Provider 1', 'Hygienist'), (6, 'A', '431.00', '-58.00', 'null', '2018-11-06 00:00:00', 'C', 'P', 'Provider 1', 'Hygienist'), (6, 'A', '431.00', '-30.00', 'null', '2018-11-06 00:00:00', 'C', 'P', 'Provider 1', 'Hygienist'), (6, 'A', '431.00', '-26.00', 'null', '2018-11-06 00:00:00', 'C', 'P', 'Provider 1', 'Hygienist'), (6, 'A', '431.00', '-36.00', 'null', '2018-11-06 00:00:00', 'C', 'P', 'Provider 1', 'Hygienist'), (6, 'A', '431.00', '-48.00', 'null', '2018-11-06 00:00:00', 'C', 'P', 'Provider 1', 'Hygienist'), (6, 'A', '431.00', '-48.00', 'null', '2018-11-06 00:00:00', 'C', 'P', 'Provider 1', 'Hygienist'), (6, 'A', '431.00', '-48.00', 'null', '2018-11-06 00:00:00', 'C', 'P', 'Provider 1', 'Hygienist'), (6, 'A', '431.00', '-48.00', 'null', '2018-11-06 00:00:00', 'C', 'P', 'Provider 1', 'Hygienist'), (6, 'A', '534.70', '-267.35', 'null', '2018-11-06 00:00:00', 'C', 'P', 'Provider 2', 'Dentist'), (6, 'A', '534.70', '-267.35', 'null', '2018-11-06 00:00:00', 'C', 'P', 'Provider 2', 'Dentist'), (6, 'A', '100.00', '-48.00', 'null', '2018-11-06 00:00:00', 'C', 'P', 'Provider 1', 'Hygienist'), (6, 'A', '100.00', '-52.00', 'null', '2018-11-06 00:00:00', 'C', 'P', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '-1344.91', 'null', '2018-11-06 00:00:00', 'C', 'A', 'Provider 2', 'Dentist'), (6, 'A', '150.00', '-35.00', 'null', '2018-11-06 00:00:00', 'C', 'P', 'Provider 3', 'Hygienist'), (6, 'A', '150.00', '-68.00', 'null', '2018-11-06 00:00:00', 'C', 'P', 'Provider 3', 'Hygienist'), (6, 'A', '150.00', '-47.00', 'null', '2018-11-06 00:00:00', 'C', 'P', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '-41.60', 'null', '2018-11-06 00:00:00', 'A', 'C', 'Provider 2', 'Dentist'), (6, 'A', '458.50', '-458.50', 'null', '2018-11-06 00:00:00', 'C', 'P', 'Provider 2', 'Dentist'), (6, 'A', '753.60', '-649.60', 'null', '2018-11-06 00:00:00', 'C', 'P', 'Provider 2', 'Dentist'), (6, 'A', '753.60', '-104.00', 'null', '2018-11-06 00:00:00', 'C', 'P', 'Provider 2', 'Dentist'), (6, 'A', '904.76', '-249.00', 'null', '2018-11-06 00:00:00', 'C', 'P', 'Provider 2', 'Dentist'), (6, 'A', '904.76', '-655.76', 'null', '2018-11-06 00:00:00', 'C', 'P', 'Provider 2', 'Dentist'), (6, 'A', '162.40', '-162.40', 'null', '2018-11-06 00:00:00', 'C', 'P', 'Provider 2', 'Dentist'), (6, 'A', '158.00', '-45.00', 'null', '2018-11-06 00:00:00', 'C', 'P', 'Provider 3', 'Hygienist'), (6, 'A', '158.00', '-81.00', 'null', '2018-11-06 00:00:00', 'C', 'P', 'Provider 3', 'Hygienist'), (6, 'A', '158.00', '-32.00', 'null', '2018-11-06 00:00:00', 'C', 'P', 'Provider 3', 'Hygienist'), (6, 'A', '28.00', '28.00', 'D0120', '2018-11-06 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '38.00', '38.00', 'D0274', '2018-11-06 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'D1330', '2018-11-06 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '48.00', '48.00', 'D0431', '2018-11-06 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '52.00', '52.00', 'PRA', '2018-11-06 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '15.00', '15.00', 'D0220', '2018-11-06 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '14.00', '14.00', 'D0230', '2018-11-06 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'PROBE', '2018-11-06 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '24.00', '24.00', 'FL21O', '2018-11-06 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'IOEPX', '2018-11-06 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '-28.00', 'null', '2018-11-06 00:00:00', 'C', 'A', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '-38.00', 'null', '2018-11-06 00:00:00', 'C', 'A', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '-6.00', 'null', '2018-11-06 00:00:00', 'C', 'A', 'Provider 3', 'Hygienist'), (6, 'A', '28.00', '28.00', 'D0120', '2018-11-06 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '52.00', '52.00', 'PRA', '2018-11-06 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'); INSERT INTO `transaction_data` (`site_id`, `status`, `fee`, `amount`, `service_code`, `tran_date`, `impacts`, `type`, `provider`, `provider_position`) VALUES (6, 'A', '24.00', '24.00', 'FLU21', '2018-11-06 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '0.00', 'IOEPX', '2018-11-06 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '0.00', 'NPCHR', '2018-11-06 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '83.00', '83.00', 'NTAE', '2018-11-06 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '104.00', '104.00', 'D0330', '2018-11-06 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '0.00', 'PAEME', '2018-11-06 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '43.00', '43.00', 'D0272', '2018-11-06 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '0.00', 'BLOPR', '2018-11-06 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '-30.00', 'null', '2018-11-06 00:00:00', 'C', 'A', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '-8.24', 'null', '2018-11-06 00:00:00', 'A', 'C', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '-61.86', 'null', '2018-11-06 00:00:00', 'C', 'A', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '-43.00', 'null', '2018-11-06 00:00:00', 'C', 'A', 'Provider 3', 'Hygienist'), (6, 'A', '46.00', '46.00', 'D0120', '2018-11-06 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '60.00', '60.00', 'D0274', '2018-11-06 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '0.00', 'D1330', '2018-11-06 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '48.00', '48.00', 'D0431', '2018-11-06 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '87.00', '87.00', 'PRA', '2018-11-06 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '30.00', '30.00', 'D0220', '2018-11-06 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '26.00', '26.00', 'D0230', '2018-11-06 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '0.00', 'PROBE', '2018-11-06 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '36.00', '36.00', 'FL21O', '2018-11-06 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '0.00', 'BLOPR', '2018-11-06 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '0.00', 'IOEPX', '2018-11-06 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '-46.00', 'null', '2018-11-06 00:00:00', 'C', 'A', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '-46.40', 'null', '2018-11-06 00:00:00', 'C', 'A', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '0.00', 'D0120', '2018-11-06 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'D0274', '2018-11-06 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'D1330', '2018-11-06 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'D0431', '2018-11-06 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'PRA', '2018-11-06 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'D0220', '2018-11-06 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'D0230', '2018-11-06 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'PROBE', '2018-11-06 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'FL21O', '2018-11-06 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'IOEPX', '2018-11-06 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '969.00', '969.00', 'EMAXX', '2018-11-06 00:00:00', 'P', 'S', 'Provider 2', 'Dentist'), (6, 'A', '969.00', '969.00', 'EMAXX', '2018-11-06 00:00:00', 'P', 'S', 'Provider 2', 'Dentist'), (6, 'A', '0.00', '0.00', 'D0120', '2018-11-06 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '0.00', 'D1330', '2018-11-06 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '0.00', 'PRA', '2018-11-06 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '0.00', 'FL21O', '2018-11-06 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '0.00', 'IOEPX', '2018-11-06 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '46.00', '46.00', 'D0120', '2018-11-06 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '87.00', '87.00', 'PRA', '2018-11-06 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '36.00', '36.00', 'FLU21', '2018-11-06 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'IOEPX', '2018-11-06 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'RCWFL', '2018-11-06 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '181.05', '181.05', 'D2332', '2018-11-06 00:00:00', 'P', 'S', 'Provider 2', 'Dentist'), (6, 'A', '0.00', '-14.45', 'null', '2018-11-06 00:00:00', 'C', 'A', 'Provider 2', 'Dentist'), (6, 'A', '0.00', '-74.00', 'null', '2018-11-06 00:00:00', 'C', 'A', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '-4.60', 'null', '2018-11-06 00:00:00', 'C', 'A', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '-8.70', 'null', '2018-11-06 00:00:00', 'C', 'A', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '-3.60', 'null', '2018-11-06 00:00:00', 'C', 'A', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '-48.00', 'null', '2018-11-06 00:00:00', 'C', 'A', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '0.00', '2391R', '2018-11-06 00:00:00', 'P', 'S', 'Provider 2', 'Dentist'), (6, 'A', '0.00', '0.00', '1351R', '2018-11-06 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '0.00', '1351R', '2018-11-06 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '0.00', '1351R', '2018-11-06 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '48.00', '48.00', 'D1351', '2018-11-06 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '48.00', '48.00', 'D1351', '2018-11-06 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '28.00', '28.00', 'D0120', '2018-11-06 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '0.00', 'D1330', '2018-11-06 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '41.00', '41.00', 'PRC', '2018-11-06 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '24.00', '24.00', 'FLU21', '2018-11-06 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '0.00', 'IOEPX', '2018-11-06 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '74.00', '74.00', 'D0330', '2018-11-06 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '30.00', '30.00', 'D1351', '2018-11-07 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '30.00', '30.00', 'D1351', '2018-11-07 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '30.00', '30.00', 'D1351', '2018-11-07 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '46.00', '46.00', 'D0120', '2018-11-07 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '0.00', 'D1330', '2018-11-07 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '87.00', '87.00', 'PRA', '2018-11-07 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '0.00', 'IOEPX', '2018-11-07 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '-46.00', 'null', '2018-11-07 00:00:00', 'C', 'A', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '-87.00', 'null', '2018-11-07 00:00:00', 'C', 'A', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '0.00', 'NPSS', '2018-11-07 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'PROBE', '2018-11-07 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'NPOCS', '2018-11-07 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'D1330', '2018-11-07 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'BLOPR', '2018-11-07 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'IONPX', '2018-11-07 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '48.00', '48.00', 'NAE', '2018-11-07 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'NPWFL', '2018-11-07 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '92.00', '92.00', 'D0210', '2018-11-07 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '52.00', '52.00', 'PRNA', '2018-11-07 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '24.00', '24.00', 'FL21O', '2018-11-07 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'NPTER', '2018-11-07 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '67.00', '67.00', 'D0330', '2018-11-07 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '15.00', '15.00', 'D0220', '2018-11-07 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '10.00', '10.00', 'D0230', '2018-11-07 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '10.00', '10.00', 'D0230', '2018-11-07 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '10.00', '10.00', 'D0230', '2018-11-07 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '10.00', '10.00', 'D0230', '2018-11-07 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '10.00', '10.00', 'D0230', '2018-11-07 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '10.00', '10.00', 'D0230', '2018-11-07 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '10.00', '10.00', 'D0230', '2018-11-07 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '10.00', '10.00', 'D0230', '2018-11-07 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '0.00', 'BLOPR', '2018-11-07 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '35.00', '35.00', 'AMCNP', '2018-11-07 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '0.00', 'PROBE', '2018-11-07 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '0.00', 'IONPX', '2018-11-07 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '-50.00', 'null', '2018-11-07 00:00:00', 'C', 'A', 'Provider 2', 'Dentist'), (6, 'A', '0.00', '0.00', 'NPSS', '2018-11-07 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'D0145', '2018-11-07 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'NPSS', '2018-11-07 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '83.00', '83.00', 'NCE', '2018-11-07 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '58.00', '58.00', 'PRNC', '2018-11-07 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'D1330', '2018-11-07 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '36.00', '36.00', 'FLU21', '2018-11-07 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'IONPX', '2018-11-07 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '969.00', '969.00', 'EMAXX', '2018-11-07 00:00:00', 'P', 'S', 'Provider 2', 'Dentist'), (6, 'A', '87.00', '87.00', 'PRNA', '2018-11-07 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'D1330', '2018-11-07 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '36.00', '36.00', 'FL21O', '2018-11-07 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'IOEPX', '2018-11-07 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'FMXNF', '2018-11-07 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'NPOCS', '2018-11-07 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '43.00', '43.00', 'D0272', '2018-11-07 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'NPWFL', '2018-11-07 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '-24.00', 'null', '2018-11-07 00:00:00', 'C', 'A', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'CMENT', '2018-11-07 00:00:00', 'P', 'S', 'Provider 2', 'Dentist'), (6, 'A', '0.00', '0.00', 'POBWX', '2018-11-07 00:00:00', 'P', 'S', 'Provider 2', 'Dentist'), (6, 'A', '30.00', '30.00', 'D0220', '2018-11-07 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '83.00', '83.00', 'TX', '2018-11-07 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '0.00', 'BLOPR', '2018-11-07 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '0.00', 'IOEPX', '2018-11-07 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '0.00', 'NPCHR', '2018-11-07 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '67.00', '67.00', 'D0330', '2018-11-07 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '15.00', '15.00', 'D0220', '2018-11-07 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '10.00', '10.00', 'D0230', '2018-11-07 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '10.00', '10.00', 'D0230', '2018-11-07 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '10.00', '10.00', 'D0230', '2018-11-07 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '10.00', '10.00', 'D0230', '2018-11-07 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '10.00', '10.00', 'D0230', '2018-11-07 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '10.00', '10.00', 'D0230', '2018-11-07 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '10.00', '10.00', 'D0230', '2018-11-07 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '10.00', '10.00', 'D0230', '2018-11-07 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '0.00', 'BLOPR', '2018-11-07 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '35.00', '35.00', 'AMCNP', '2018-11-07 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '0.00', 'PROBE', '2018-11-07 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '0.00', 'IONPX', '2018-11-07 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '147.00', '-28.00', 'null', '2018-11-07 00:00:00', 'C', 'P', 'Provider 1', 'Hygienist'), (6, 'A', '147.00', '-38.00', 'null', '2018-11-07 00:00:00', 'C', 'P', 'Provider 1', 'Hygienist'), (6, 'A', '147.00', '-52.00', 'null', '2018-11-07 00:00:00', 'C', 'P', 'Provider 1', 'Hygienist'), (6, 'A', '147.00', '-15.00', 'null', '2018-11-07 00:00:00', 'C', 'P', 'Provider 1', 'Hygienist'), (6, 'A', '147.00', '-14.00', 'null', '2018-11-07 00:00:00', 'C', 'P', 'Provider 1', 'Hygienist'), (6, 'A', '193.00', '-46.00', 'null', '2018-11-07 00:00:00', 'C', 'P', 'Provider 1', 'Hygienist'), (6, 'A', '193.00', '-60.00', 'null', '2018-11-07 00:00:00', 'C', 'P', 'Provider 1', 'Hygienist'), (6, 'A', '193.00', '-87.00', 'null', '2018-11-07 00:00:00', 'C', 'P', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '-30.00', 'null', '2018-11-07 00:00:00', 'C', 'A', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '-83.00', 'null', '2018-11-07 00:00:00', 'C', 'A', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '-630.60', 'null', '2018-11-07 00:00:00', 'C', 'A', 'Provider 2', 'Dentist'), (6, 'A', '0.00', '-268.65', 'null', '2018-11-07 00:00:00', 'C', 'A', 'Provider 2', 'Dentist'), (6, 'A', '0.00', '-38.75', 'null', '2018-11-07 00:00:00', 'A', 'C', 'Provider 2', 'Dentist'), (6, 'A', '0.00', '38.75', 'null', '2018-11-07 00:00:00', 'A', 'C', 'Provider 2', 'Dentist'), (6, 'A', '0.00', '-38.75', 'null', '2018-11-07 00:00:00', 'A', 'C', 'Provider 2', 'Dentist'), (6, 'A', '219.35', '-46.00', 'null', '2018-11-07 00:00:00', 'C', 'P', 'Provider 1', 'Hygienist'), (6, 'A', '219.35', '-60.00', 'null', '2018-11-07 00:00:00', 'C', 'P', 'Provider 1', 'Hygienist'), (6, 'A', '219.35', '-87.00', 'null', '2018-11-07 00:00:00', 'C', 'P', 'Provider 1', 'Hygienist'), (6, 'A', '219.35', '-4.25', 'null', '2018-11-07 00:00:00', 'C', 'P', 'Provider 1', 'Hygienist'), (6, 'A', '219.35', '-22.10', 'null', '2018-11-07 00:00:00', 'C', 'P', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '0.00', 'null', '2018-11-07 00:00:00', 'C', 'P', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'NPCHR', '2018-11-07 00:00:00', 'P', 'S', 'Provider 2', 'Dentist'), (6, 'A', '0.00', '0.00', 'DENCS', '2018-11-07 00:00:00', 'P', 'S', 'Provider 2', 'Dentist'), (6, 'A', '197.00', '-67.00', 'null', '2018-11-07 00:00:00', 'C', 'P', 'Provider 3', 'Hygienist'), (6, 'A', '197.00', '-15.00', 'null', '2018-11-07 00:00:00', 'C', 'P', 'Provider 3', 'Hygienist'), (6, 'A', '197.00', '-10.00', 'null', '2018-11-07 00:00:00', 'C', 'P', 'Provider 3', 'Hygienist'), (6, 'A', '197.00', '-10.00', 'null', '2018-11-07 00:00:00', 'C', 'P', 'Provider 3', 'Hygienist'), (6, 'A', '197.00', '-10.00', 'null', '2018-11-07 00:00:00', 'C', 'P', 'Provider 3', 'Hygienist'), (6, 'A', '197.00', '-10.00', 'null', '2018-11-07 00:00:00', 'C', 'P', 'Provider 3', 'Hygienist'), (6, 'A', '197.00', '-10.00', 'null', '2018-11-07 00:00:00', 'C', 'P', 'Provider 3', 'Hygienist'), (6, 'A', '197.00', '-10.00', 'null', '2018-11-07 00:00:00', 'C', 'P', 'Provider 3', 'Hygienist'), (6, 'A', '197.00', '-10.00', 'null', '2018-11-07 00:00:00', 'C', 'P', 'Provider 3', 'Hygienist'), (6, 'A', '197.00', '-10.00', 'null', '2018-11-07 00:00:00', 'C', 'P', 'Provider 3', 'Hygienist'), (6, 'A', '197.00', '-35.00', 'null', '2018-11-07 00:00:00', 'C', 'P', 'Provider 3', 'Hygienist'), (6, 'A', '55.00', '-55.00', 'null', '2018-11-07 00:00:00', 'C', 'P', 'Provider 3', 'Hygienist'), (6, 'A', '130.00', '-10.00', 'null', '2018-11-07 00:00:00', 'C', 'P', 'Provider 3', 'Hygienist'), (6, 'A', '130.00', '-10.00', 'null', '2018-11-07 00:00:00', 'C', 'P', 'Provider 3', 'Hygienist'), (6, 'A', '130.00', '-10.00', 'null', '2018-11-07 00:00:00', 'C', 'P', 'Provider 3', 'Hygienist'), (6, 'A', '130.00', '-10.00', 'null', '2018-11-07 00:00:00', 'C', 'P', 'Provider 3', 'Hygienist'), (6, 'A', '130.00', '-10.00', 'null', '2018-11-07 00:00:00', 'C', 'P', 'Provider 3', 'Hygienist'), (6, 'A', '130.00', '-10.00', 'null', '2018-11-07 00:00:00', 'C', 'P', 'Provider 3', 'Hygienist'), (6, 'A', '130.00', '-10.00', 'null', '2018-11-07 00:00:00', 'C', 'P', 'Provider 3', 'Hygienist'), (6, 'A', '130.00', '-10.00', 'null', '2018-11-07 00:00:00', 'C', 'P', 'Provider 3', 'Hygienist'), (6, 'A', '130.00', '-15.00', 'null', '2018-11-07 00:00:00', 'C', 'P', 'Provider 3', 'Hygienist'), (6, 'A', '130.00', '-35.00', 'null', '2018-11-07 00:00:00', 'C', 'P', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '-222.24', 'null', '2018-11-07 00:00:00', 'C', 'A', 'Provider 2', 'Dentist'), (6, 'A', '0.00', '-209.00', 'null', '2018-11-07 00:00:00', 'C', 'A', 'Provider 2', 'Dentist'), (6, 'A', '0.00', '-156.92', 'null', '2018-11-07 00:00:00', 'A', 'C', 'Provider 2', 'Dentist'), (6, 'A', '0.00', '-29.43', 'null', '2018-11-07 00:00:00', 'C', 'A', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '-0.57', 'null', '2018-11-07 00:00:00', 'A', 'C', 'Provider 1', 'Hygienist'), (6, 'A', '46.00', '46.00', 'D0120', '2018-11-07 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '43.00', '43.00', 'D0272', '2018-11-07 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '0.00', 'D1330', '2018-11-07 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '58.00', '58.00', 'PRC', '2018-11-07 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '30.00', '30.00', 'D0220', '2018-11-07 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '26.00', '26.00', 'D0230', '2018-11-07 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '36.00', '36.00', 'FLU21', '2018-11-07 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '0.00', 'IOEPX', '2018-11-07 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '104.00', '104.00', 'D0330', '2018-11-07 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '0.00', 'NPSS', '2018-11-07 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'PROBE', '2018-11-07 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'NPOCS', '2018-11-07 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'D1330', '2018-11-07 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'BLOPR', '2018-11-07 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'IONPX', '2018-11-07 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'NAE', '2018-11-07 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'NPWFL', '2018-11-07 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'D0210', '2018-11-07 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'PRNA', '2018-11-07 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'FL21O', '2018-11-07 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'CMENT', '2018-11-07 00:00:00', 'P', 'S', 'Provider 2', 'Dentist'), (6, 'A', '0.00', '0.00', 'POBWX', '2018-11-07 00:00:00', 'P', 'S', 'Provider 2', 'Dentist'), (6, 'A', '969.00', '969.00', 'EMAXX', '2018-11-07 00:00:00', 'P', 'S', 'Provider 2', 'Dentist'), (6, 'A', '969.00', '969.00', 'EMAXX', '2018-11-07 00:00:00', 'P', 'S', 'Provider 2', 'Dentist'), (6, 'A', '67.00', '67.00', 'PRD', '2018-11-07 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '46.00', '46.00', 'D0120', '2018-11-07 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '0.00', 'D1330', '2018-11-07 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '36.00', '36.00', 'FL21O', '2018-11-07 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '0.00', 'IOEPX', '2018-11-07 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '30.00', '30.00', 'D0220', '2018-11-07 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '26.00', '26.00', 'D0230', '2018-11-07 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '26.00', '26.00', 'D0230', '2018-11-07 00:00:00', 'P', 'S', 'Provider 1', 'Hygienist'), (6, 'A', '0.00', '0.00', 'NPCHR', '2018-11-07 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'PROBE', '2018-11-07 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'NPOCS', '2018-11-07 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'D1330', '2018-11-07 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'BLOPR', '2018-11-07 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'IONPX', '2018-11-07 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '83.00', '83.00', 'NAE', '2018-11-07 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'NPWFL', '2018-11-07 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '148.00', '148.00', 'D0210', '2018-11-07 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '87.00', '87.00', 'PRNA', '2018-11-07 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '36.00', '36.00', 'FL21O', '2018-11-07 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'IOEPX', '2018-11-07 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '24.00', '24.00', 'FLU21', '2018-11-07 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '14.00', '14.00', 'D0230', '2018-11-07 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '15.00', '15.00', 'D0220', '2018-11-07 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'D1320', '2018-11-07 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '41.00', '41.00', 'PRC', '2018-11-07 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '0.00', '0.00', 'D1330', '2018-11-07 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '25.00', '25.00', 'D0272', '2018-11-07 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '28.00', '28.00', 'D0120', '2018-11-07 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '34.00', '34.00', 'D1351', '2018-11-07 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'A', '34.00', '34.00', 'D1351', '2018-11-07 00:00:00', 'P', 'S', 'Provider 3', 'Hygienist'), (6, 'D', '0.00', '-44.70', 'null', '2018-11-07 00:00:00', 'C', 'A', 'Provider 3', 'Hygienist'), (6, 'V', '0.00', '44.70', 'null', '2018-11-07 00:00:00', 'C', 'D', 'Provider 3', 'Hygienist'); -- -- Indexes for dumped tables -- -- -- Indexes for table `transaction_data` -- ALTER TABLE `transaction_data` ADD KEY `service_code` (`service_code`), ADD KEY `site_id` (`site_id`), ADD KEY `tran_date` (`tran_date`), ADD KEY `tran_data_multi` (`site_id`,`tran_date`), ADD KEY `tran_provider_index` (`site_id`,`provider_position`), ADD KEY `provider` (`provider`), ADD KEY `impacts` (`impacts`), ADD KEY `type` (`type`), ADD KEY `status` (`status`); /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /* SELECT provider , service_code , COUNT(*) AS `trans_ttl` , SUM( IF(tran_date BETWEEN '2018-01-01' AND '2018-01-31', 1, 0)) AS `interval1` , SUM( IF(tran_date BETWEEN '2018-02-01' AND '2018-02-28', 1, 0)) AS `interval2` , SUM( IF(tran_date BETWEEN '2018-03-01' AND '2018-03-31', 1, 0)) AS `interval3` , SUM( IF(tran_date BETWEEN '2018-04-01' AND '2018-04-30', 1, 0)) AS `interval4` , SUM( IF(tran_date BETWEEN '2018-05-01' AND '2018-05-31', 1, 0)) AS `interval5` , SUM( IF(tran_date BETWEEN '2018-06-01' AND '2018-06-30', 1, 0)) AS `interval6` , SUM( IF(tran_date BETWEEN '2018-07-01' AND '2018-07-31', 1, 0)) AS `interval7` , SUM( IF(tran_date BETWEEN '2018-08-01' AND '2018-08-31', 1, 0)) AS `interval8` , SUM( IF(tran_date BETWEEN '2018-09-01' AND '2018-09-30', 1, 0)) AS `interval9` , SUM( IF(tran_date BETWEEN '2018-10-01' AND '2018-10-31', 1, 0)) AS `interval10` , SUM( IF(tran_date BETWEEN '2018-11-01' AND '2018-11-30', 1, 0)) AS `interval11` , SUM( IF(tran_date BETWEEN '2018-12-01' AND '2018-12-31', 1, 0)) AS `interval12` FROM transaction_data WHERE site_id = 6 AND tran_date BETWEEN '2018-01-01' AND '2018-12-31' AND impacts = 'P' AND type = 'S' AND status = 'A' GROUP BY provider , service_code ; */ SELECT id , client_id , site_id , service_category , b.service_code , coalesce(trans_ttl,0) trans_ttl , coalesce(interval1,0) interval1 , coalesce(interval2,0) interval2 , coalesce(interval3,0) interval3 , coalesce(interval4,0) interval4 , coalesce(interval5,0) interval5 , coalesce(interval6,0) interval6 , coalesce(interval7,0) interval7 , coalesce(interval8,0) interval8 , coalesce(interval9,0) interval9 , coalesce(interval10,0) interval10 , coalesce(interval11,0) interval11 , coalesce(interval12,0) interval12 FROM code_map b LEFT JOIN ( SELECT COUNT(*) AS `trans_ttl`, service_code , SUM( IF(tran_date BETWEEN '2018-01-01' AND '2018-01-31', 1, 0)) AS `interval1` , SUM( IF(tran_date BETWEEN '2018-02-01' AND '2018-02-28', 1, 0)) AS `interval2` , SUM( IF(tran_date BETWEEN '2018-03-01' AND '2018-03-31', 1, 0)) AS `interval3` , SUM( IF(tran_date BETWEEN '2018-04-01' AND '2018-04-30', 1, 0)) AS `interval4` , SUM( IF(tran_date BETWEEN '2018-05-01' AND '2018-05-31', 1, 0)) AS `interval5` , SUM( IF(tran_date BETWEEN '2018-06-01' AND '2018-06-30', 1, 0)) AS `interval6` , SUM( IF(tran_date BETWEEN '2018-07-01' AND '2018-07-31', 1, 0)) AS `interval7` , SUM( IF(tran_date BETWEEN '2018-08-01' AND '2018-08-31', 1, 0)) AS `interval8` , SUM( IF(tran_date BETWEEN '2018-09-01' AND '2018-09-30', 1, 0)) AS `interval9` , SUM( IF(tran_date BETWEEN '2018-10-01' AND '2018-10-31', 1, 0)) AS `interval10` , SUM( IF(tran_date BETWEEN '2018-11-01' AND '2018-11-30', 1, 0)) AS `interval11` , SUM( IF(tran_date BETWEEN '2018-12-01' AND '2018-12-31', 1, 0)) AS `interval12` FROM transaction_data WHERE site_id = 6 AND tran_date BETWEEN '2018-01-01' AND '2018-12-31' AND impacts = 'P' AND type = 'S' AND status = 'A' GROUP BY service_code ) a ON b.service_code=a.service_code WHERE b.site_id = 6 GROUP BY site_id, service_category ORDER BY site_id, service_category
absolute service time: 1,51 sec
fork mode
|
history
id
client_id
site_id
service_category
service_code
trans_ttl
interval1
interval2
interval3
interval4
interval5
interval6
interval7
interval8
interval9
interval10
interval11
interval12
1
815
1
6
AdProphy
PrAxx
0
0
0
0
0
0
0
0
0
0
0
0
0
2
2175
1
6
AdSeal
1351A
4
0
0
0
0
0
0
0
0
0
0
4
0
3
6105
1
6
AllExams
D0120
29
0
0
0
0
0
0
0
0
0
0
29
0
4
3328
1
6
Amalgam
D2140
0
0
0
0
0
0
0
0
0
0
0
0
0
5
4764
1
6
Arestin
D4381
0
0
0
0
0
0
0
0
0
0
0
0
0
6
2573
1
6
Bridge
D6210
0
0
0
0
0
0
0
0
0
0
0
0
0
7
811
1
6
CHProphy
PrNMC
0
0
0
0
0
0
0
0
0
0
0
0
0
8
5725
1
6
Conscious Sedation
D9248
0
0
0
0
0
0
0
0
0
0
0
0
0
9
3591
1
6
Cosmetic
D2740
0
0
0
0
0
0
0
0
0
0
0
0
0
10
2561
1
6
Crown
D2720
0
0
0
0
0
0
0
0
0
0
0
0
0
11
2609
1
6
CrownBuild
D2950
1
0
0
0
0
0
0
0
0
0
0
1
0
12
3204
1
6
CrownCos
D2740
0
0
0
0
0
0
0
0
0
0
0
0
0
13
2590
1
6
CrownImp
D6058
0
0
0
0
0
0
0
0
0
0
0
0
0
14
3965
1
6
CrownRedo
2740R
0
0
0
0
0
0
0
0
0
0
0
0
0
15
2607
1
6
CrownSS
D2930
0
0
0
0
0
0
0
0
0
0
0
0
0
16
2540
1
6
DentureComp
D5110
0
0
0
0
0
0
0
0
0
0
0
0
0
17
2552
1
6
DenturePart
D5211
0
0
0
0
0
0
0
0
0
0
0
0
0
18
3959
1
6
DentureRedo
5110R
0
0
0
0
0
0
0
0
0
0
0
0
0
19
2612
1
6
DentureReline
D5730
0
0
0
0
0
0
0
0
0
0
0
0
0
20
839
1
6
DHP
DHPAC
0
0
0
0
0
0
0
0
0
0
0
0
0
21
8665
1
6
DHPNew
DHPAC
0
0
0
0
0
0
0
0
0
0
0
0
0
22
2516
1
6
Emerg
D0140
0
0
0
0
0
0
0
0
0
0
0
0
0
23
2453
1
6
Endo
D3310
0
0
0
0
0
0
0
0
0
0
0
0
0
24
2456
1
6
EndoMolar
D3330
0
0
0
0
0
0
0
0
0
0
0
0
0
25
2481
1
6
ExtSimp
D7140
1
0
0
0
0
0
0
0
0
0
0
1
0
26
2488
1
6
ExtSurg
D7220
0
0
0
0
0
0
0
0
0
0
0
0
0
27
813
1
6
Fluoride
D1203
0
0
0
0
0
0
0
0
0
0
0
0
0
28
2559
1
6
Implant
D6010
0
0
0
0
0
0
0
0
0
0
0
0
0
29
840
1
6
MCOrthoCase
8070M
0
0
0
0
0
0
0
0
0
0
0
0
0
30
2441
1
6
Nitrous
D9230
1
0
0
0
0
0
0
0
0
0
0
1
0
31
1448
1
6
NPAMC
AMCNP
2
0
0
0
0
0
0
0
0
0
0
2
0
32
4733
1
6
NPEMR
NTAEX
0
0
0
0
0
0
0
0
0
0
0
0
0
33
807
1
6
NPMC
NMCEx
0
0
0
0
0
0
0
0
0
0
0
0
0
34
809
1
6
NPPP
NCExx
0
0
0
0
0
0
0
0
0
0
0
0
0
35
2310
1
6
NPTOT
NPAMC
0
0
0
0
0
0
0
0
0
0
0
0
0
36
2595
1
6
OccGuard
D9940
0
0
0
0
0
0
0
0
0
0
0
0
0
37
820
1
6
OCS
D0431
7
0
0
0
0
0
0
0
0
0
0
7
0
38
823
1
6
Oracare
ORACR
4
0
0
0
0
0
0
0
0
0
0
4
0
39
6035
1
6
Oracare3
OR3PK
0
0
0
0
0
0
0
0
0
0
0
0
0
40
2424
1
6
ORTHInv
8080I
0
0
0
0
0
0
0
0
0
0
0
0
0
41
858
1
6
OrthoConMC
ORMCn
0
0
0
0
0
0
0
0
0
0
0
0
0
42
859
1
6
OrthoConPP
D8660
0
0
0
0
0
0
0
0
0
0
0
0
0
43
2149
1
6
PerEV
PerRe
0
0
0
0
0
0
0
0
0
0
0
0
0
44
822
1
6
PerGN
D4341
2
0
0
0
0
0
0
0
0
0
0
2
0
45
3190
1
6
PerioAR
D4381
0
0
0
0
0
0
0
0
0
0
0
0
0
46
812
1
6
PerLT
D4342
0
0
0
0
0
0
0
0
0
0
0
0
0
47
821
1
6
PerMA
D4910
1
0
0
0
0
0
0
0
0
0
0
1
0
48
843
1
6
PPOrthoCase
D8090
0
0
0
0
0
0
0
0
0
0
0
0
0
49
4675
1
6
ProToothBrush
OralB
0
0
0
0
0
0
0
0
0
0
0
0
0
50
4714
1
6
RCWFL
RCWFL
7
0
0
0
0
0
0
0
0
0
0
7
0
51
2365
1
6
ReCare
D0120
29
0
0
0
0
0
0
0
0
0
0
29
0
52
2521
1
6
ResinAnt
D2330
1
0
0
0
0
0
0
0
0
0
0
1
0
53
2525
1
6
ResinPost
D2391
0
0
0
0
0
0
0
0
0
0
0
0
0
54
3951
1
6
ResinRedo
2330R
0
0
0
0
0
0
0
0
0
0
0
0
0
55
837
1
6
RXFluoride
RXFLL
0
0
0
0
0
0
0
0
0
0
0
0
0
56
838
1
6
SA
SAINS
0
0
0
0
0
0
0
0
0
0
0
0
0
57
863
1
6
SAAccept
SAAHT
0
0
0
0
0
0
0
0
0
0
0
0
0
58
866
1
6
SAAM
SAAMR
0
0
0
0
0
0
0
0
0
0
0
0
0
59
864
1
6
SADecline
SADHT
0
0
0
0
0
0
0
0
0
0
0
0
0
60
865
1
6
SANonCand
SAPNC
0
0
0
0
0
0
0
0
0
0
0
0
0
61
862
1
6
SAScreen
99202
0
0
0
0
0
0
0
0
0
0
0
0
0
62
834
1
6
Sealant
D1351
7
0
0
0
0
0
0
0
0
0
0
7
0
63
3950
1
6
SealantRedo
1351R
3
0
0
0
0
0
0
0
0
0
0
3
0
64
8785
1
6
test
test
0
0
0
0
0
0
0
0
0
0
0
0
0
65
2572
1
6
Veneer
D2962
0
0
0
0
0
0
0
0
0
0
0
0
0
66
4700
1
6
WFL
NPWFL
8
0
0
0
0
0
0
0
0
0
0
8
0
67
2598
1
6
White
D9972
0
0
0
0
0
0
0
0
0
0
0
0
0