Loading...
HomeMy WebLinkAbout06/2010MONTH OF PAYMENT JUL 09 AUG 09 SEP 09 OCT 09 NOV 09 DEC 09 JAN 10 FEB 10 MAR 10 APR 10 MAY 10 JUN 10 TOTAL **** TOWN OF SOUTHOLD **** EMPLOYEE HEALTH CARE PLAN ISLAND GROUP 7/ 7/10 CLAIM LAG REPORT - AMOUNT BILLED PLAN YEAR 7/ 1/09 - 6/30/10 CLAIMS AIl units ................................................................... MONTH OF SERVICE ................................................................... JUL 09 AUG 09 SEP 09 OCT 09 NOV 09 DEC 09 JAN 10 FEB 10 MAR 10 APR 10 MAY 10 JUN 10 TOTAL 64452.98 18.1) 233392.68 65.6) 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) 1776.97 0.5) 86.80 0.0) 0.00 355687.94 0.00 87108.17 13.6) 230401.75 36.0) 126202.29 19.7) 7857.78 1.2) 1697.79 0.3) 113311.99 17.7) 1942,47 0.3) 1426.83 0.2) 0.00 70682,24 (11.0) 100.00 ( 0.0) 640731.31 0.00 0.00 0.00 0.00 0.00 0.00 85673.22 0.00 0.00 21.3) 199768.39 86592.21 0.00 49.8) 21.3) 65820.17 220232.31 106180.69 16.4) 54.2) 17.3) 3764.76 35375.10 221101.44 0,9) 8.7) 36.0) 18418.22 44051.15 198186.59 4.6) 10.8) 32.3) 14804.33 7343.21 73263.68 3.7) 1.8) 11.9) 11647,90 2443.10 8594.25 2.9) 0.6) 1.4) 1405~66 3096.07 3388.52 0.4) 0.8) 0.6) 65.00 1295.65 2313.72 0.0) 0.3) 0.4) 86.80 5636.20 391.00 0.0) 1.4) 0.1) 401454.45 406065.00 613419.89 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 52997.66 0.00 10.5) 182757.55 28422.18 36.3) 4.2) 131760.91 205295.93 26.2) 30.3) 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 25035.32 0.00 0.00 0.00 0.00 ( 6.6) 0.00 0.00 0.00 78945.12 0.00 0.00 (12.7) 145929.90 250999,89 143126.26 0.00 ( 34.8) ( 40.5) ( 35.9) 14690.34 289872.40 256095.88 87418,55 ( 3.5) ( 46.8) ( 64.2) (100.0) 102221.53 20.3) 28870.36 5.7) 3526.58 0.7) 1046.00 0.2) 503180.59 409310.66 261381.52 99307.41 60.3) (69.2) (23.7) 22016.22 45387.84 159542.58 3.2) (12.0) (38.0) 8879.05 21456.16 1.3) ( 5.7) 4816.15 24259.92 0.7) ( 6.4) 678740.19 377520.76 419470.23 619817.41 399222.14 87418.55 64452.98 1.2) 320500.85 5.8) 332426.80 6.0) 421439.72 7.7) 421020.97 7.7) 315882.07 5.7) 592560.92 10.8) 460360.12 8.4) 896880.20 16.3) 344429.34 6.3) 648361.25 11.8) 684413.24 12.4) 5502728.46 **** TOWN OF SOUTHOLD **** EMPLOYEE HEALTH CARE PLAN ISLAND GROUP 71 7/10 CLAIM LAG REPORT - AMOUNT PAID PLAN YEAR 7/ 1/09 - 6/30/10 CLAIMS AlE Units MONTH OF PAYMENT JUL 09 AUG 09 SEP 09 OCT 09 NOV 09 DEC 09 JAN 10 FEB 10 MAR 10 APR 10 MAY 10 JUN 10 JOL ;;" 4482Z o '-o.o; o.oo o.oo o.oo o.oo o.oo o.oo o]oo ' o.oo ' o.oo" ................................................................... MONTH OF SERVICE ................................................................... 58558.54 28.4) 103493.76 50.2) 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 SEP 09 OCT 09 NOV 09 DEC 09 JAN 10 FEB 10 MAR 10 APR 10 MAY 10 0,00 0.00 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.6) 17.00 0.0) 14.21 21.0) AUG 09 153388.56 71.9) 5911,65 2.8) 3779.66 1.8) 2986.53 1.4) 357.83 0.2) 1390,84 0.7) 618.29 0.3) 187.40 0.1) 0.00 0.00 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.0) 31.29 0.0) 0.00 0.00 0.00 0,00 0,00 70603.29 ]7.7) 80974.28 43.3) 15875.05 8.5) 14798.66 7.9) 3673.36 2.0) 418.37 0.2) 871.98 0.5) 0.00 0.00 0.00 0.00 26918.34 0.00 (11.3) 128230.82 12765.35 (53.6) 5.0) 67639.57 122682.19 (28.3) 47.6) 13257.27 113050.72 ( 5.5) 43.9) 2687.81 6475.95 ( 1.1) 2.5) 417.00 2025.90 ( 0.2) 0.8) 0.00 0.00 0.00 0.00 14384.96 O.O0 (8.8) 135034,24 64160,00 (83.0) (29,6) 5755.23 86260.02 ( 3.5) (39.7) 5505.66 61781.23 ( 3.4) (28.5) 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 52819.69 0.00 0.00 (19,4) 104487.10 101119,30 0.00 ( 38.3) ( 43.3) 14.21 126.00 ( 0.0) ( 0.1) JUN 10 0.00 12.13 17.98 0.00 56,69 582.55 1984.57 4916.77 115214.10 132311.68 60303.65 ( 0.0) 0,0) 0.0) ( 0.0) 0.2) ( 1.2) ( 2.3) ( 42.3) ( 56.7) (100.0) TOTAL 213459.27 206076.28 178621.70 161604.99 187214.99 239207.50 257582.66 162664,66 217118.02 272520.89 233430.98 60303.65 TOTAL 44824.30 1.9) 211947.10 8.9) 165112.62 6.9) 173224.09 7.3) 178404.94 7.5) 116365.77 4.9) 186930.57 7.8) 232496.43 9.7) 333187.67 13.9) 155501.10 ( 6.5) 276396.67 (11.6) 315414.33 (13.2) 2389805.59 TOtJN OF SOUTHOLD PROCEDURE FREQUENCY REPORT EMPLOYEE HEALTH SENEFIT PLANS ISLAND GROUP PROCESS DATES: 6/ 1/10 - 6/30/10 Client Totals PAGE 1 DATE 7/ 7/10 PROC CATEGORY DESCRIPTION MUM SVCS TOT.BILLED AVE.BILLED TOT.PAID AVE.PAID 6030 SURGERY SURGERY 6050 ANESTRESIA ANESTHESIA 6060 OFFICE VISIT PHYSICIAN OFFICE VISIT 6070 DOCTOR SERVI PHYSICIAN IN-HOSPITAL VISIT/S 7001 EMERGENCY RO PHYS TREATMENT MHD EMERG 7040 XRAY X-RAY OUT-PATIENT 7054 DIAGNOSTIC MEDICAL TESTING 7055 XRAY XRAY INTERP 7062 LABORATORY S LAB 80% 7144 MEDICAL SUPP INJECTIONS 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 RE PP M/N 9009 OFFICE VISIT PP WELL CARE 9010 DOCTOR SERVI PP HOSPITAL VISIT 9011 HOSPITAL RO0 PP NOSPITAL 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 9040 OTHER PP CHIROPRACTIC 9041 OFFICE VISIT PP NUTRITIONAL COUNSELING 9045 THERAPY PP PHYSICAL THERAPY 9050 AUDIT/CONSUL PP CONSULTATION 9055 PRESCRIPTION RX PNARMACARE 9070 DIAGNOSTIC PP MAMMOQRAPHY 9080 XRAY PP RADIOLOGY 9081XRAY PP XRAY INTERP 9085 DIAGNOSTIC PP EKG 9090 ANESTHESIA PP ANESTRESIA 9095 LABORATORY S PP LAB 9099 MISCELLANEOU PP MISCELLANEOUS 9105 MISCELLANEOU PSI HOSP DISCOUNT FEE 9108 AUDIT/CONSUL NYS SURCHARGE 9109 MISCELLANEOU NYS GME~S 9203 THERAPY PP HEARING AIDS 9207 THERAPY PP MRI 9211 DENTAL NERVE BLOCK 12 2344.00 195.33 81.94 6.83 2 7996.00 3998.00 6756.60 3578.30 41 4577.00 111.63 734.85 17.92 7 1702.00 243.14 177.78 25.40 1 293.00 293.00 23.23 23.23 4 17875.20 4468.80 13030.02 3257.51 4 2059.00 514.75 1461.18 365.30 5 267.61 53.52 37.13 7.43 9 1791.70 199.08 762.94 84.77 1 80.00 80.00 0.00 0.00 159 21823.74 137.26 11108.97 69.87 8 5744.44 468.06 1625.00 203.13 294 198285.01 674.44 7267.89 24.72 29 1329.36 45.84 1004.78 34.65 5 360.00 72.00 164.00 32.80 12 563.00 46.92 118.14 9.85 25 3520.00 140.80 1825.00 7~.00 19 4590.00 231.05 1846.00 97.16 3 940.00 313.33 480.00 160.00 3 144740.44 48246.81 94545.77 31515,26 3 18060.77 6020.26 14340.61 4780.20 6 16626.24 2771.04 11862.11 1977.02 16 1392.13 87.01 1392.13 87.01 16 22691.95 1418.25 14752.06 922,00 19 12723.90 669.68 9584.12 504.43 27 35185.10 1303.15 14806,00 548.37 1 5260.00 5260.00 0.00 0.00 46 13229.50 287.60 5839.61 126.95 16 1029.00 64.31 775.00 48.44 42 3415.00 81.31 665.00 15.83 2 400.00 200.00 0.00 0.00 29 6~79.12 233.76 4297.84 148.20 15 4970.73 331.38 2495.00 166.33 2 57753.01 28876.51 57753.01 28876.51 8 1635.00 204.38 686.00 85.75 27 6312.00 233.78 2230.00 82.59 24 2543.00 105.96 618.00 25.75 20 1925.08 96.25 580.08 29.00 2 4770.00 2585.00 644.00 322.00 263 22595.88 85.92 6828.54 25.96 3 1124.00 374.67 0.00 0.00 13 9594.83 730.06 9594.83 738.06 1 7015.00 7015.00 7015.00 7015.00 I 2079.00 2079.00 2079.00 2079.00 1 3500.00 3300.00 1500.00 1500.00 3 3964.00 1321.33 2075.00 691.67 4 800.00 200.00 540.00 135.00 CLIENT TOTALS 1253 685855.74 547.37 316004,16 252.20