Loading...
HomeMy WebLinkAbout05/2010MONTH OF PAYMENT MAY 09 JUN 09 JUL 09 AUG 09 SEP 09 OCT 09 NOV 09 DEC 09 JAN 10 FEB 10 MAR 10 APR 10 TOTAL **** TOWN OF SOUTHOLD **** EMPLOYEE HEALTH CARE PLAN ISLAND GROUP 5/ 6/10 CLAIM LAG REPORT - AMOUNT BILLED PLAN YEAR 5/ 1/09 - 4/30/10 CLAIMS All Units ................................................................... MONTH OF SERVICE ................................................................... MAY 09 JUN 09 JUL 09 AUG 09 SEP 09 OCT 09 NOV 09 DEC 09 JAN 10 FEB 10 MAR 10 APR 10 TOTAL 79233.6? 0.00 12.9) 292387.59 119688.98 47.5) 24.0) 170329.01 259194.41 27.7) 52.0) 14320.16 94224.13 2.3) 18.9) 2752.07 5959.92 0.5) 1.2) 39284.70 6808.61 6.4) 1.4) 6980.12 5725.00 1.1) 1.1) 5112.40 3515.00 0.8) 0.7) 1240.03 2778.93 0.2) 0.6) 3201.63 660.00 0.5) 0.1) 299.80 0.00 0.1) 240.00 0.00 0.0) 615381.18 498554,98 0.00 0.00 0.00 0.00 64452.98 0.00 (18.1) 233592.68 87108.17 ( 65.6) ( 15.3) 16351.85 230401.75 (4.6) (40.4) 8876.83 126202.29 ( 2.5) ,(22.1) 20930.02 7857.78 ( 5.9) ( 1.4) 945,32 1697.79 (0.3) (0.3) 7413.24 113311.99 ( 2.1) (19.9) 914,27 1948.47 (0.3) (0.3) 547.00 1426.83 ( 0.2) ( 0.3) 1776.97 0.00 (0.5) 355601.14 569949.07 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 85673.22 0.00 0.00 21.4) 199768.39 86592.21 0.00 49.8) 21.7) 65820.17 220232.31 106180.69 16.4) 55.2) 17.4) 3764.76 35375.10 221101,44 0.9) 8.9) 36.2) 18418.22 44051.15 198186.59 4.6) 11.0) 32.5) 14804.33 7343.21 73263.68 3.7) 1.8) 12.0) 11647.90 2443.10 8594.25 2.9) 0.6) 1.4) 1405.66 3096.07 3388.52 0.4) 0.8) 0.6) 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 0.00 0.00 0.00 52997,66 0.00 0.00 0.00 0.00 (10,6) 182757.55 28422.18 0.00 0.00 0.00 (36.6) ( 4.3) 131760.91 205295.93 25035.32 0.00 0.00 (26.4) (50.8) ( 7.5) 102313,53 409310.66 261581.52 99307.41 0.00 ( 20.5) ( 61.5) ( 78.7) ( 38.4) 28870.36 22766.22 45687.84 159542.58 78945.12 ( 5.8) ( 3.4) ( 13.8) ( 61.6) (100.0) 401302,65 399133.15 610715.17 498700.01 665794.99 332104.68 258849.99 78945,12 79233.67 1.5) 412076.57 7.8) 493976.40 9.3) 429045.14 8.1) 341138.79 6.5) 467533.03 8.8) 433726.09 8.2) 324509.47 6.1) 596579.88 11.3) 464221.75 8.8) 897272.00 17,0> 345719.34 6.5) 5285032.13 RECEiVeD JUN 8 2010 Souihot~ Tovm Cle~i~. MONTH OF PAYMENT MAY 09 JUN 09 JUL 09 AUG 09 SEP 09 OCT 09 NOV 09 DEC 09 JAN 10 FEB 10 MAR 10 APR 10 **** TOWN OF SOUTHOLD EMPLOYEE HEALTH CARE PLAN ISLAND~ GROUP 5/ 6/10 CLAIM LAG REPORT - AMOUNT PAID PLAN YEAR 5/ 1/09 - 4/30/10 CLAIMS All Units ................................................................... MONTH OF SERVICE ................................................................... MAY 09 JUN 09 JUL 09 AUG 09 SEP 09 OCT 09 NOV 09 DEC 09 JAN 10 FEB 10 MAR 10 APR 10 TOTAL 58778.13 19.1) 131721.08 42.9) 100314.33 32.7) 2498.60 0.8) 818.02 0.3) 9979.18 3.3) 1258.87 0.4) 1021.02 0.3) 106.35 0.0) 279.22 0.1) 29.76 O.O) 94.00 0.00 0.00 82125.62 0.00 29.5) 158794.89 44824.30 57.1) (21.0) 31165.52 153388.56 11.2) (71.9) 1588.97 5911.65 0.6) ( 2.8) 2167.67 3779.66 0.8) ( 1.8) 1678.72 2986.53 0.6) ( 1.4) 419.72 357.83 0.2) ( 0.2) 216.57 1390.84 0.1) ( 0.7) 2.03 618.29 ( 0.3) 0.00 187.40 ( 0.1) 0.00 0.00 0.00 0.00 0.00 58558.54 28.4) 103493.76 50.3) 30477.42 14.8) 2877.67 1.4) 686.91 0.3) 9358.03 4.5) 344.36 0.2) 141.46 0.1) 0.00 0.00 0.00 0.00 0.00 55707.21 31.2) 79672,65 44.6) 17770.59 9.9) 1249.75 0.7) 12372.90 6.9) 7761.56 4,3) 3024.31 1,7) 1031.52 0.00 0.00 0.00 0.00 0.00 59294.36 36.7) 84166.86 52.1) 6178.66 3.8) 6937.58 4,3) 4266.84 2.6) 658.91 0.4) 52,51 0.00 0.00 0.00 0.00 0.00 0.00 70603.29 37.9) 80974.28 43.5) 15875.05 8.5) 14798.66 7.9) 3673.36 2.0) 418.37 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 26918.34 0.00 (11.3) 128230.82 12765.35 (53.7) ( 5.0) 67639.57 122682.19 (28.3) (48.1) 13261.63 113050,72 ( 5.5) (44.3) 2687,81 6500.95 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 14384.96 0.00 0.00 ( 9.3) 135034.24 64160.00 0.00 (87.0) (42.6) 5800.81 86260.02 52819.69 0.0) 0.6) 0.0) 0.2) ( 1.1) ( 2.5) ( 3.7) ( 57.4) (100.0) TOTAL 306898.56 278159.71 213445.06 205938.15 178590.49 161555,72 186343.01 238738.17 254999.21 155220.01 150420.02 52819.69 58778.13 2.5) 213846.70 9.0) ,303933.52 12.8) 245611.22 10.3) 167519.61 7.0) 185370.94 7,8) 181342,53 7.6) 117806.51 4,9) 187253.49 7.9) 232777.68 9.8) 333221.79 14.0) 155665.68 6.5) 2383127.80 TOWN OF SOUTHOLD PROCEDURE FREQUENCY REPORT EMPLOYEE HEALTH BENEFIT PLANS ISLAND GROUP PROCESS DATES: 4/ 1/10 - 4/30/10 Client Totals PAGE 1 DATE 5/ 6/10 PROC CATEGORY DESCRIPTION NUM SVCS 6030 SURGERY SURGERY 15 6050 ANESTHESIA ANESTHESIA 1 6060 OFFICE VISIT PHYSICIAN OFFICE VISIT 15 6061 OFFICE VISIT CONSULTATION 1 6070 DOCTOR SERVI PHYSICIAN IN-HOSPITAL VISIT/S 17 6999 EMERGENCY RO EMERGENCY TREATMENT MEDICAL EMERGENCY 1 7051XRAY RADIOLOGY/PATHOLOGY 2 7054 DIAGNOSTIC MEDICAL TESTING 3 7055 XRAY XRAY INTERP 1 7060 LABORATORY S LABORATORY OUT-PATIENT 1 7062 LABORATORY S LAB 80% 5 7249 OTHER AMHULANCE 2 9000 OFFICE VISIT PP OFFICE VISIT 163 9001 EMERGENCY RO PP ER VISIT 8 9002 AUDIT/CONSUL PP COB 335 9005 PREVENTATIVE IMMUNIZATIONS 6 9006 PREVENTATIVE PP INJECTIONS 18 9007 MENTAL OR NE PP M/N 25 9009 OFFICE VISIT PP WELL CARE 14 9011 HOSPITAL RO0 PP HOSPITAL ROOM AND BOARD 2 9013 EMERGENCY RO PP EMERGENCY TREATMENT MEDICAL EMERGENCY 4 9014 MEDICAL SUPP PP DURABLE MED EQUIP 1 9015 XRAY PP X-RAY OUT PATIENT 7 9019 LABORATORY S PP LABORATORY OUT PATIENT 11 9020 SURGERY PP SURGERY 20 9025 DIAGNOSTIC P P TESTING 42 9026 OFFICE VISIT PP ALLERGY 5 9040 OTHER PP CHIROPRACTIC 34 9041 OFFICE VISIT PP NUTRITIONAL COUNSELING 3 9045 THERAPY PP PHYSICAL THERAPY 12 9050 AUDIT/CONSUL PP CONSULTATION 10 9055 PRESCRIPTION EX PHARMACARE 2 9070 DIAGNOSTIC PP MAMMOGRAPHY 8 9080 XRAY PP RADIOLOGY 24 9081XRAY PP XRAY INTERP 18 9085 DIAGNOSTIC PP EKG 25 9090 ANESTHESIA PP ANESTHESIA 6 9095 LABORATORY S PP LAB 288 9099 MISCELLANEOU PP MISCELLANEOUS 5 9105 MISCELLANEOU PSI ROSP DISCOUNT FEE 8 9108 AUDIT/CONSUL NYS SURCHARGE 1 9109 MISCELLANEOU NYS GME~S 1 9201 THERAPY PP ACUPUNCTURE 1 9204 THERAPY PP EPIDURALS 2 9207 THERAPY PP MRI 3 9209 XRAY PP CT SCAN 6 TOT.HILLED AVE.BILLED TOT.PAID AVE.PAID 9366.00 624.40 265.08 17.67 1540.00 1540.00 325.60 325.60 1784.70 118.98 108.46 7.23 651.00 651.00 85.02 85.02 2403.00 141.35 215.99 12.71 692.73 692.73 494.18 494.18 107.04 53.52 0.00 0.00 337.00 112.33 4.82 1.61 82.95 82.95 0.00 0.00 483.00 483.00 408.00 408.00 1662.88 332.58 0.00 0.00 576.70 288.35 82.52 41.26 27030.89 165,83 13394.75 82.18 3665.48 458.19 1845.00 230.63 79586.99 237.57 5992.29 17.89 322.01 53.67 235.00 39.17 927.50 51.53 128.67 7.15 3325.00 133.00 1723.D0 68.92 3465.00 247.50 1354.00 96.71 25241.14 12620.57 3084.37 1542.19 5330.02 1332.51 3373.96 843.49 116.00 116.00 0.00 0.00 3939.58 562.80 2906.26 415.18 7071.19 642.84 5341.95 485.63 10535.00 526.75 3775.00 188.75 11980.12 285.24 6096.00 145.14 210.00 42.00 151.00 30.20 1977.00 58.15 440.00 12.94 750.00 250.00 315.00 105.00 1412.28 117.69 400.00 33.33 2848.79 284.88 1909.00 190.90 56646.74 28323.37 56646.74 28323.37 1605.00 200.63 720.00 90.00 4919.75 204.99 2339.50 97.48 2424.00 134.67 854.20 47.46 2041.00 81.64 740.00 29.60 10160.00 1693.33 4196.00 699.33 26238.92 91.11 8472.34 29.42 490.99 98.20 299.03 59.81 7636.95 954.62 7636.95 954.62 11501.00 11501.00 11501.00 11501.00 2074.00 2074.00 2074.00 2074.00 133.00 133.00 113.00 113.00 2090.00 1045.00 948.00 474.00 3632.00 1210.67 2085.00 695.00 5025.00 837.50 2585.00 430.83 CLIENT TOTALS 1182 346039.34 292.76 155665.68 131.70