Loading...
HomeMy WebLinkAbout03/2010MONTH OF PAYMENT APB 09 MAY 09 JUN 09 JUL 09 AUG 09 SEP 09 OCT 09 NOV 09 DEC 09 JAN 10 FEB 10 MAR 10 TOTAL **** TOWN OF SOUTHOLD **** EMPLOYEE HEALTH CARE PLAN ISLAND GROUP 4/14/10 CLAIM LAG REPORT - AMOUNT BILLED PLAN YEAR 4/ 1/09 - 3/31/10 CLAIMS ALL Units ................................................................... MONTH OF SERVICE ................................................ = .................. APR 09 MAY 09 JUN 09 ......... JUL 09 AUG 09 SEP 09 OCT 09 NOV 09 DEC 09 JAN 10 FEB 10 MAR 10 0.00 ......... 79174.20 14.8) 135338.93 25.2) 153741.01 28.7) 3677.78 0.7) 6213.55 1.2) 14216.15 2.6) 70853.22 13.2) 852.12 0.2) 991,60 0.2) 763.48 0.1) 2436.51 0.5) 67900.67 12.7) 536159.22 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) 299.80 0.1) 615141,18 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 0.7) 2778.93 0.6) 660.00 0.1) 0.00 498554.98 0.00 0.00 0.00 64452.98 18.2) 233392.68 66.0) 16351.83 4.6) 8876.83 2.5) 20930.02 5.9) 945.32 0.3) 7413.24 2.1) 914.27 0.3) 547.00 0.2) 353824.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.4) 21.4) 126202.29 199768.39 22,1) 50.0) 7857.78 65820.17 1.4) 16.5) 1697.79 3764.76 0.3) 0.9) 113311.99 18418.22 19.9) 4.6) 1942.47 14804.33 0.3) 1426.83 11647.90 0.3) 2.9) 569949.07 399896.99 396037.08 607326,65 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 21.9) 220232,31 106180,69 55.6) (17.5) 35375.10 221101.44 8.9) (36.4) 44051.15 198186.59 11.1) (32.6) 7343.21 73263.68 1.9) (12.1) 2443.10 8594.25 0.6) (1.4) 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 (11.3) 182757.55 28422.18 0.00 0.00 (38.9) ( 4.4) 131760,91 205295,93 25035.32 0.00 (28.0) (31,9) ( 8,7) 102313.53 409310.66 261381.52 99307.41 ( 21.8) ( 63.6) ( 91.3) (100.0) 469829.65 643028.77 286416.84 99307.41 TOTAL 79174.20 1.5) 214572.60 3.9) 565817.58 10.3) 497654.18 9.1) 435258.69 8JO) 355354.94 6.5) 538306.25 9.8) 434578.21 7.9) 325501.07 5.9) 597343.36 10.9) 466658.26 8.5) 965172.67 17.6) 5475472.01 RECEIVED MAY 1 2 2010 MONTH OF PAYMENT APR 09 MAY 09 JUN 09 JUL 09 AUG 09 SEP 09 OCT 09 NOV 09 DEC 09 JAN 10 FEB 10 MAR 10 TOTAL **** TOWN OF SOUTHOLD **** EMPLOYEE HEALTH CARE PLAN ISLAND GROUP 4/14/10 CLAIM LAG REPORT - AMOUNT PAID PLAN YEAR 4/ 1/09 - 3/31/10 CLAIMS All Un~t$ ................................................................... MONTH OF SERVICE ................................................................... APR 09 MAY 09 JUN 09JUL 09 AUG 09 SEP 09 OCT 09 NOV 09DEC 09 JAM 10 FEB 10 MAR 10 52117.51 o.oo o.oo- Loo ' .oo 0.00 :oo o:oo ' 0.00 o. o o.oo ' o.oo ......... 24.1) 80107,09 37.0) 45016.47 20.8) 1020.00 0.5) 1703.73 0.8) 9991.13 4.6) 1321.16 0.6) 169.72 0.1) 303.13 0.1) 52.99 0.0) 306.34 0.1) 24172.91 11.2) 216282.18 58778.13 19.2) 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 0.0) 306804.56 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) 278159.71 213445.06 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) 205938.15 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 0.00 31.4) 79672.65 59294.36 0.00 44.9) 36.7) 17770,59 84166.86 70603.29 10.0) 52.1) (38.0) 1249.75 6178.66 80974.28 0.7) 3.8) (43.5) 12372.90 6937.58 15875.05 7.0) 4.3) ( 8.5) 7761.56 4266.84 14798.66 4.4) 2.6) ( 8.0) 3024.31 658,91 3673.36 1.7) 0.4) ( 2.0) 177558.97 161503.21 185924.64 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 26918.34 0.00 0,00 0.00 (11.4) 128230.82 12765.35 0.00 0.00 (54.3) ( 5.1) 67639.57 122682.19 14384.96 0.00 (28.6) (49.4) ( 9.6) 13261.63 113050.72 135034.24 64160.00 ( 5.6) (45.5) (90.4) (100.0) 236050,36 248498.26 149419.20 64160.00 TOTAL 52117.51 2.1) 138885.22 5.7) 258863.17 10.6) 304953.52 12.5) 247314.95 10.1) 177510.74 7.3) 186692,10 7.6) 181512.25 7.4) 118109.64 4.8) 18T306.48 7.7) 233084.02 9.5) 357394.70 14.6) 2443744.30 TOWN OF SOUTHOLD PROCEDURE FREQUERCY REPORT EMPLOYEE HEALTH BENEFIT PLANS ISLAND GROUP PROCESS DATES: 3/ 1/10 - 3/31/10 Client Totals PAGE 1 DATE 4/13/10 PROC CATEGORY DESCRIPTION NUN SVCS TOT.BILLED AVE.HILLED TOT.PAID AVE.PAID 6001 HOSPITAL RO0 ROSPITAL ROOM AND BOARD 6030 SURGERY SURGERY 6050 ANESTHESIA ANESTHESIA 6060 OFFICE VISIT PHYSICIAN OFFICE VISIT 6070 DOCTOR SERVI PHYSICIAN IN-HOSPITAL VISIT/S 6999 EMERGENCY RO EMERGENCY TREATMENT 'MEDICAL EMERGENCY 7040 XRAY X-RAY OUT-PATIENT ~051 XRAY RADIOLOGY/PATHOLOGY 7054 DIAGNOSTIC MEDICAL TESTING 7055 XRAY XRAY INTERP 7060 LABORATORY S LABORATORY OUT-PATIENT 7062 LABORATORY S LAB 80% 7249 OTHER AMBULANCE 9000 OFFICE VISIT PP OFFICE VISIT 9001 EMERGENCY RO PP ER VISIT 9002 AUDIT/CONSUL PP COB 9004 AUDIT/CONSUL PP DIABETIC SUPPLIES 9005 PREVENTATIVE IMMUNIZATIONS 9006 PREVENTATIVE PP INJECTIONS 9007 MENTAL OR NE PP M/N 9009 OFFICE VISIT PP WELL CARE 9010 DOCTOR SERVI PP HOSPITAL VISIT 9011 HOSPITAL RO0 PP HOSPITAL ROOM AND BOARD 9012 SURGERY PP AMBULATORY OUT PATIENT SURGERY 9013 EMERGENCY RO PP EMERGENCY TREATMENT MEDICAL EMERGENCY 9014 MEDICAL SUPP PP DURABLE MED EQUIP 9015 XRAY PP X-RAY OUT PATIENT 9019 LABORATORY S PP LABORATORY OUT PATIENT 9020 SURGERY PP SURGERY 9021 SURGERY PP ASST SURGEON 9025 DIAGNOSTIC P P TESTING 9026 OFFICE VISIT PP ALLERGY 9027 MISCELLANEOU PP ORTHOTICS/PROSTHETICS 9029 DOCTOR SERVI PP NEWBORN CARE 9040 OTHER PP CHIROPRACTIC 9045 THERAPY PP PHYSICAL THERAPY 9050 AUDIT/CONSUL PP CONSULTATION 9055 PRESCRIPTION RX PHARMACARE 9070 DIAGNOSTIC PP MAMMOGRAPHY 9080 XRAY PP RADIOLOGY 9081XRAY PP XRAY INTERP 9085 DIAGNOSTIC PP EKG 9090 ANESTHESIA PP ANESTHESIA 9095 LABORATORY S PP LAB 9099 MISCELLANEOU PP MISCELLANEOUS 9105 MIHCELLANEOU PSI HOSP DISCOUNT FEE 9108 AUDIT/CONSUL NYS SURCHARGE 9109 MISCELLANEOU NYS GME~S 9201 THERAPY PP ACUPUNCTURE 2 56794.02 28397.01 1980.00 990.00 4 1472.00 368.00 119.02 29.76 I 1680.00 1680.00 0.00 0.00 35 3449.33 98.55 293.90 8.40 6 1262.00 210.33 104.21 17.37 1 2573.49 2573.49 2256.14 2256.14 6 14314.06 2385.68 2233.57 372.26 8 1521.00 190.13 14.27 1.78 10 6t23.40 612.34 242.27 24.23 8 570.00 71.25 0.00 0.00 2 275.00 137.50 125.00 62.50 8 -279.40 -34.93 -46.63 -5.83 1 1876.20 1876.20 174.81 174.81 193 33121.96 171.62 15232.00 78.92 10 6041.00 604.10 2100.00 210.00 403 239603.10 594.55 14667.27 36.40 7 1857.10 262.44 1062.39 151.77 5 390.98 78.20 176.00 35.20 21 721.94 34.38 124.87 5.95 56 6620.00 118.21 3414.00 60.96 14 3137.00 224.07 1287.00 91.93 12 4088.63 340.72 1834.00 152.83 7 193313.14 27616.16 92808.79 13258.40 7 27530.41 3932.92 20777.53 2968.22 10 26428.11 2642.81 18893.57 1889.36 10 1274.92 127.49 1269.74 126.97 14 18490.70 1320.76 14302.56 1021.61 15 7~04.22 486.95 5002.04 333.47 61 96799.69 1586.88 21017.50 344.55 5 27734.00 5546.80 1600.60 320.12 41 7782.48 189.82 3633.00 88.61 13 869.00 66,85 351.00 27.00 I 900.00 900.00 325.00 325.00 3 325,00 108.33 0.00 0.00 24 1418.88 59.12 360.00 15.00 5 578.35 115.67 200.00 40.00 12 2902.34 241.86 1753.00 146.08 3 81808.55 27269,52 81808.55 27269.52 4 900.00 225.00 350.00 87.50 21 5279.10 251.39 2978.44 141.85 40 10379.00 259.48 2282.00 57.05 15 1833.35 122.22 450.00 30.00 6 10425.00 1737.50 4900.00 816.67 284 23583.32 83.04 7538.31 26.54 7 1327.00 189.57 686.80 98,11 12 14969.42 1247.45 14969.42 1247.45 1 7920.00 7920.00 7920.00 7920.00 I 2104.00 2104.00 2104.00 2104.00 1 133.00 133.00 113.00 113.00 TOWN OF SOUTNOLD PROCEDURE FREQUENCY REPORT EMPLOYEE HEALTN BENEFIT PLANS ISLAND GROUP PROCESS DATES: 3/ 1/10 - 3/31/10 Client Totals PAGE 2 DATE 4/13/10 PROC CATEGORY DESCRIPTION NUH SVCS TOT.BILLED AVE.BILLED TOT.PAID AVE.PAID 9207 THERAPY PP MRI 1 -1200.00 -1200.00 -657.00 -657.00 9209 XRAY PP CT SCAN 4 2900.00 725.00 644.00 161.00 CLIENT TOTALS 1442 964906.79 669.14 357101.74 247.64