Loading...
HomeMy WebLinkAbout02/2010**** TOWN OF SOUTHOLD EMPLOYEE HEALTH CARE PLAN ISLAND GROUP 3/ 3/10 CLAIM LAG REPORT - AMOUNT GILLED PLAN YEAR 3/ 1/09 - 2/28/10 CLAIMS ALL Units MONTH OF ................................................................... MONTN OF SERVICE ................................................................... PAYMENT MAR 09 APR 09 MAY 09 JUN 09 JUL 09 AUG 09 SEP 09 OCT 09 NOV 09 DEC 09 JAN 10 FEB 10 MAR 0~- 948~4.79 0.00 0.00 0.00 0.00 0.00 -0.00 0.00 0.00 0.00 '0.00 0.0~ MAY 09 JUN 09 JUL 09 AUG 09 SEP 09 OCT 09 NOV 09 DEC 09 JAN 10 FEB 10 TOTAL 13.1) APR 09 303764.47 41.8) 270916.79 37.3) 35023.60 4.8) 10909.76 1.5) 3479.50 0.5) 2852.08 0.4) 2549.00 0.4) 1588.12 0.2) 425.00 0.1) 475.99 0.1) 0.00 726849.10 79174.20 16.9) 135338.93 28.9) 153741.01 32.8) 3677.?8 0.8) 6213.55 1.3) 14216.15 3.0) 70855.22 15.1) 852.12 0.2) 991.60 0.2) 763.48 0.2) 2436.51 0.5) 468258.55 0.00 79233.67 12.9) 292387.59 47.5) 170329.01 27.7) 14320.16 2.3) 2752.07 0.5) 39284.70 6,4) 6980.12 1.1) 5112.40 0.8) 1240.03 0.2) 3201.63 0.5) 614841.38 0.00 0.00 119688.98 (24.0) 259194.41 (52.0) 94224.13 (18.9) 5959.92 ( 1.2) 6808.61 (, 1.4) 5725.00 ( 1,1) 3515.00 C 0.7) 2778.93 ( 0.6) 660.00 ( 0.1) 498554.98 0.00 0.00 0.00 64452.98 18.2) 233392.68 66.1) 16351.83 4.6) 8876.83 2.5) 20930.02 5.9) 945.32 0.3) 7413.24 2.1) 914.27 0.3) 353277.17 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 87108.17 0.00 15.3) 230401.75 85673.22 40.5) 22.1) 126202.29 199768.39 22.2) 51.5) 785?.78 65820,17 1.4) 16,9) 1697.79 3764.76 0.3) 1.0) 113311.99 18418.22 19.9) 4.7) 1942.47 14804,33 0.3) 3.8) 568522.24 388249.09 0.00 0.00 0.00 0.00 0.00 0,00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 86592.21 0.00 0.00 0.00 (22.0) 220232.31 106180.69 0.00 0.00 (56.0) (17.7) 35375.10 221101.44 52997.66 0.00 ( 9.0) ( 36.9) ( 14.4) 44051.15 198186.59 182757.55 28422.18 (11.2) (33.1) (49.7) (12.2) 7343.21 73263.68 132166.51 205295.93 ( 1.9) (12.2) (35.9) (87.8) 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 25035.32 (100.0) 393593.98 598732.40 367921.72 233718.11 25035.32 TOTAL 94864.79 1.8) 382938.67 7.3) 485489.39 9.3) 600841.18 11.5) 508563.94 9.7) 438~38.19 8,4) 358207.02 6.8) 540935.25 10.3) 436166.33 8.3) 325926.07 6.2) 597819.35 11.4) 467063.86 8.9) 5237554.04 MONTH OF PAYMENT MAR 09 APR 09 MAY 09 JUN 09 JUL 09 AUG 09 SEP 09 OCT 09 NOV 09 DEC 09 JAN 10 FEB 10 TOTAL **** TOWN OF SOUTHOLD **** EMPLOYEE HEALTH CARE PLAN ISLAND GROUP 3/ 3/10 CLAIM LAG REPORT - AMOUNT PAID PLAN YEAR 3/ 1/09 - 2/28/10 CLAIMS Ali Units ............................................... ~ ................... MONTH OF SERVICE ................................................................... MAR 09 APR 09 MAY 09 JUN 09 JUL 09 AUG 09 SEP 09 OCT 09 NOV 09 DEC 09 JAN 10 FEB 10 TOTAL 65678.48 22.2) 159219.08 53.8) 44528.74 15.1) 21719.35 7,3) 2187.31 0.7) 422.40 0.1) 486.06 0.2) 1242.57 0.4) 348.23 0.1) 66.62 0.0) 26.35 O.O) 0.00 295925.19 0.00 0.00 52117.51 0.00 (27.1) 80107.09 58778.13 (41.7) 19.2) 45016.47 131721.08 (23.4) 42.9) 1020.00 100314.33 0.5) 32.7) 1703.73 2498.60 0.9) 0.8) 9991.13 818.02 5.2) 0.3) 1321.16 9979.18 0.7) 3.3) 169.72 1258.87 0.1) 0.4) 303.13 1021.02 0.2) 0.3) 52.99 106.35 0.0) 0.0) 306.34 279.22 0.2) ( 0.1) 192109.27 306774.80 0.00 0.00 0.00 0.00 0.00 0.00 82125.62 0.00 29.5) 158794.89 44824.30 57.1) 21,0) 31165.52 153388.56 58558.54 11.2) 71.9) 28.4) 1588.97 5911.65 103493.76 0.6) 2.8) 50.3) 2167.67 3779.66 30477.42 0.8) 1.8) 14.8) 1678.72 2986.53 2877.67 0,6) 1.4) 1.4) 419.72 357.83 686.91 0.2) 0.2) 0.3) 216.57 1390.84 9358.03 0.1) 0.7) 4.5) 2.03 618.29 344.36 0.3) 0.2) 278159,71 213257.66 205796,69 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 55707.21 0.00 31.9) 79672.65 59294.36 45.6) (36.9) 17770.59 84166.86 10.2) (52.3) 1249,75 6178.66 0.7) ( 3.8) 12372.90 6937.58 7.1) ( 4.3) 7761,56 4266.84 4.5) ( 2.6) 174534.66 160844.30 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0,00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 70603.29 0.00 0.00 0.00 (38.7) 80974.28 26918.34 0.00 0.00 (44,4) (12.1) 15875.05 128230.82 12765.35 0.00 ( 8.7) (57,6) ( 9.4) 14798.66 67639.57 122682.19 14384.96 (8,1) (30.4) (90C6) (100.0) 182251.28 222788.73 135447.54 14384.96 65678.48 2.8) 211336.59 8.9) 183413.96 7.7) 280582.52 11.8) 307140,83 12.9) 247737.35 10.4) 177996.80 7.5) 187934.6? 7.9) 181860.48 7.6) 118176.26 5.0) 187332.83 7.9) 233084.02 9.8) .2382274.79 TOWN OF SOUTHOLD PROCEDURE FREQUENCY REPORT EMPLOYEE NEALTN BENEFIT PLANS ISLAND GROUP PROCESS DATES: 2/ 1/10 - 2/28/10 Ctient Totals PAGE 1 DATE 3/ 3/10 PROC CATEGORY DESCRIPTION NUM SVCS TOT.BILLED AVE.BILLED TOT.PAID AVE.PAID 6001 HOSPITAL RO0 HOSPITAL ROOM AND BOARD 1 4170.64 4170.64 525.00 525.00 6030 SURGERY SURGERY 5 2278.72 455.74 125.17 25.03 6050 ANESTHESIA ANESTHESIA 1 251.25 251.25 13.34 13.34 6060 OFFICE VISIT PHYSICIAN OFFICE VISIT 17 2363.89 139.05 82.91 4.88 6070 DOCTOR SERVi PHYSiCiAN iN-HOSPiTAL ViSiT/S 4 476.67 119.17 62.00 15.50 6999 EMERGENCY RO EMERGENCY TREATMENT MEDICAL EMERGENCY 2 3456:39 1728.20 1553.51 776.76 7001 EMERGENCY RO PRYS TREATMENT MED EMERG I 290.00 290.00 275.00 275.00 7040 XRAY X-RAY OUT-PATIENT 3 15260.26 5086.75 4182.43 1394.14 7051XRAY RADIOLOGY/PATHOLOGY 1 100.00 100.00 0.00 0.00 7054 DIAGNOSTIC MEDICAL TESTING 9 1402.00 155.78 314.69 34.97 7055 XRAY XRAY INTERP 7 1997.00 285.29 309.33 44.19 7060 LABORATORY S LABORATORY OUT-PATIENT 2 369.00 184.50 101.00 50.50 7062 LABORATORY S LAB 80% 10 561.00 56.10 7.22 0.72 7144 MEDICAL SUPP INJECTIONS 1 23.66 23.66 0.00 0.00 7145 MEDICAL SUPP IMMUNIZATION 1 25.00 25.00 0.00 0.00 7221 THERAPY PRYSIOTNERAPY 3 3113.18 1037.73 250.59 83.53 7249 OTNER AMBULANCE 2 2438.80 1219.40 325.19 162.60 9000 OFFICE VISIT PP OFFICE VISIT 122 16956.08 138.98 8498.00 69.66 9001 EMERGENCY RO PP ER VISIT 9 5136.00 570.67 1395.00 155.00 9002 AUDIT/CONSUL PP COB 206 81165.07 394.01 7175.06 34.83 9005 PREVENTATIVE IMMUNIZATIONS 8 285.27 35.66 211.00 26.38 9006 PREVENTATIVE PP INJECTIONS 17 1094.00 64.35 384.20 22.60 9007 MENTAL OR NE PP M/N 52 6250.00 120.19 3066.00 50.96 9009 OFFICE VISIT PP WELL CARE 14 3590.00 256.43 1216,00 86.86 9010 DOCTOR SERVI PP HOSPITAL VISIT 4 1305.00 326.25 445.00 111.25 9011 NOSPITAL RO0 PP NOSPITAL ROOM AND BOARD 3 72177.12 24059.04 52462.61 17407.54 9012 SURGERY PP AMBULATORY OUT PATIENT SURGERY 3 25900.61 8633.54 20615.49 6871.83 9013 EMERGENCY RO PP EMERGENCY TREATMENT MEDICAL EMERGENCY 4 14128.36 3532.09 10044.33 2511.08 9014 MEDICAL SUPP PP DURABLE MED EQUIP 13 1432.96 110.23 1410.35 108.49 9015 XRAY PP X-RAY OUT PATIENT 10 14195.59 1419.56 11152.36 1115.24 9019 LABORATORY S PP LABORATORY OUT PATIENT 12 4607.18 38~.93 3325.24 277.10 9020 SURGERY PP SURGERY 33 39880.00 1208.73 11893.50 360.41 9021 SURGERY PP ASST SURGEON 2 2808.00 1404.00 340.00 170.00 9025 DIAGNOSTIC P P TESTING 47 10940.00 232.77 4746.00 100.98 9026 OFFICE VISIT PP ALLERGY 9 415.00 46.11 270.00 30.00 9040 OTBER PP CHIROPRACTIC 26 1404.00 57,08 330.00 12.69 9045 THERAPY PP PNYSICAL THERAPY 5 482.15 96.43 200.00 40.00 9050 AUDIT/CONSUL PP CONSULTATION 18 6069.78 337.21 3074.00 170.78 9055 PRESCRIPTION RX PHARMACARE 2 49868.53 24934.27 49868.53 24934,27 9070 DIAGNOSTIC PP MAMMOGRAPHY 4 925.00 231.25 360.00 90.00 9080 XRAY PP RADIOLOGY 17 3565.39 209.73 1788.39 105.20 9081XRAY PP XRAY INTERP 25 4369.00 174.76 1304.00 52.16 9085 DIAGNOSTIC PP EKG 10 830.00 83.00 300.00 30.00 9090 ANESTHESIA PP ANESTNESIA 6 9340.00 1556.67 4005.00 667.50 9095 LABORATORY S PP LAB 295 27922.35 94.65 10336.86 35.04 9099 MISCELLANEOU PP MISCELLANEOUS 2 600.00 300.00 500.00 250.00 9105 MISCELLANEOU PSI HOSP DISCOUNT FEE 11 3562.08 323.83 3562.08 323.83 9108 AUDIT/CONSUL NYS SURCHARGE 1 4065.00 4065.00 4065.00 4065.00 9109 MISCELLANEOU NYS GME~S 1 2110.00 2110.00 2110.00 2110.00 9207 THERAPY PP MRI 1 -1200.00 -1200.00 -697°00 -697.00 TOWN OF SOUTHOLD PROCEDURE FREQUENCY REPORT EMPLOYEE HEALTH BENEFIT PLANS ISLAND GROUP PROCESS DATES: 2/ 1/10 ~ 2/28/10 Client Totals PAGE 2 DATE 3/ 3/10 PROC CATEGORY DESCRIPTION NUM SVCS TOT.BILLED AVE.BILLED TOT.PAID AVE.PAID 9209 XRAY PP CT SCAN 12 5829.50 485.79 2157.00 179.75 ................................................................................... r ...................... CLIENT TOTALS 1074 460674.48 428.93 230041.38 214.19