The URL can be used to link to this page

Home My WebLink About05/2012**** TOWN OF SOUTHOLD **** EMPLOYEE NEALTH CARE PLAN ISLAND GROUP 61 5/12 CLAIM LAG REPORT - AMOUNT BILLED PLAN YEAR 6/ 1/11 - 5/31/12 CLAIMS ALL Unfts MONTH OF PAYMENT JUN 11 JUL I1 AUG 11 SEP 11 OCT I1 NOV 11 DEC 11 JAN 12 FEB 12 MAR 12 APR 12 MAY 12 JUL 11 AUG 11 SEP 11 OCT 11 NOV 11 DEC 11 JAN 12 FEB 12 MAR 12 APR 12 MAY 12 TOTAL ................................................................... MONTH OF SERVICE ................................................................... 0,00 0.00 105042.47 12.73 372345.88 45.0) 263419,46 31.93 54258.46 6.6) 4202.50 0.5) 19629.03 2.4) 26~3.43 0.3) 1783.78 0.2) 2283.00 0.3) 1561,70 0.2) 827139.71 0.00 O.OO 0.00 77408.51 10.7) 390659.01 54.13 101015.19 14.03 32032.~ 4.4) 75109.53 10.43 17160.36 2.4) 4189.15 0.6) 15956.91 2.2) 8393.00 1.23 722004.65 0.00 0.00 0;00 0.00 0.00 0.00 0.00 0.00 94155.15 0.00 16.23 247656.30 99601.27 42.7) 13.03 123751.99 282202.92 21.43 37.0) 100359.89 325468.10 17.33 42.6) 5364.54 23343.72 0.93 3.13 1875.10 12007.00 0.3) 1.63 4089.75 10689.05 0.7) 1.43 2385.00 10525.27 0.4) 1.43 579617,72 763837.33 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 72534,55 0.00 0.00 11.13 439403,22 96167.02 0.00 67.3) ( 10.93 107699,19 499012.98 132901.23 16.53 (56.6) (20.7) 16017.25 241252.32 361041.95 2.5) (27.4) (56.3) 0,00 0.00 0.00 O.OO O.OO 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 86614.42 0.00 0.00 ( 10.83 O.O0 13876.01 24498.49 125538.75 5696K0~- 131759.88 2.13 ( 2.8) ( 19.63 (70.8) ( 21.93 3489.46 21025.65 21643.25 148252,52 468785.43 144748.68 0.5) ( 2.4) ( 3.4) ( 18,43 ( 78.13 (100.03 653019.68 881956.46 641125.18 804497.27 600545.31 144748.68 JUN 11 161571.64 0.00 17.23 281579.41 35448.18 30.0) 6.0) 352863.40 354657.80 37.6) 59.7) 7881.56 85459.38 0.8) 14.43 37503.53 65540.63 4.0) 11.03 2879.26 4585.63 0.3) 0,8) 7202.90 12235.24 0.8) 2.13 71051.68 23400.86 7.6) 3.93 5127.72 8637.18 0.6) 1.53 9~.22 367.55 1.03 0.13 1297.00 2623.33 0.13 0.43 525.11 757.14 0.13 0.13 938969.43 593712.92 TOTAL 161571.64 2.0) 317027.59 3.9) 812563.67 10.03 543095.33 6.7) 8510~.78 10.43 509996.11 6.3) 534143.09 6.5) 1150669.33 14.13 801860.35 9.8) 9.0) 902242.50 11.13 8~2092.21 10.23 8151174.34 **** TOWN OF SOUTNOLD **** EMPLOYEE HEALTH CARE PLAN ISLAND GROUP 6/ 5/12 CLAIM LAG REPORT - AMOUNT PAID PLAN YEAR 6/ 1/11 - 5/31/12 CLAIMS MONTH OF PAYMENT 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 ................................................................... MONTH OF SERVIgE ................................................................... JUN 11 JUL 11 AUG 11 SEP 11 OCT 11 NOV 11 DEC 11 JAR 12 FEB 12 MAR 12 APR 12 MAY 12 TOTAL 12616%71 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 71040.28 (22.0) 122849.25 (38.0) 113856.62 (35.2) 5149.44 1.6) ~80.64 0.2) 7236.35 2.2) 227.46 0.1) 849.76 0.3) 1153.00 0.4) 359.53 0.1) JUL 11 AUG 11 OCT 11 NOV 11 DEC 11 JAN 12 FEB 12 MAR 12 APR 12 MAY 12 JUN 11 126161.71 4t.1) 9977~. 92 32.5) 35688.23 11.6) 1878,45 0.6) 10264.98 3.4) 1175.15 0.4) 654.60 0.2) 30472.44 9.9) 375.93 0.1) 86.75 O.O) 82. O0 0.0) 13.54 15175.10 5.5) 203192.49 73.7) 36976.26 13.4) 7813.98 2.8) 1569.34 0.6) 640.42 0.2) 5821.60 2.1) 3558.28 1.3) 171.20 0.1) 539.20 0.2) 338.69 0.1) 0.00 0.00 55467,84 18.1) 187498.01 61.2) 34083.23 11.1) 9948.56 3.3) 6335.54 2.1) 391.53 0.1) 208.77 0,1) 9542.19 3.1) 2976.82 1.0) 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 58681.13 0.00 25.0) 138150.63 69159.01 58.8) 25.8) 32191.98 153172.52 13.7) 57.0) 1946.95 30148,80 0.8) 11.2) 2647.26 7050.65 1.1) 2.6) 118.56 3298.49 0.1) 1.2) 246.44 5167.38 0.1) 1.9) 1090.40 628.08 0.5) 0.2) 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 54046.85 0.00 0.00 18.6) 199542.41 59814.05 0.00 68.7) (14.8) 29064.58 266905.71 89878.73 10.0) (66.2) (29.1) 6435.27 57025.39 180203.70 2.2) (14.2) (58.2) 1234.87 0.4) 160.70 0.1) 0.00 0.00 0.00 0.00 0.00 0,00 61568.04 0.00 (13.6) 4583.86 34861.08 316346.43 71332.81 ( 1.1) (11.3) (69.7) (20.2) 14621.83 4502;11 76041.39 281041.94 ( 3.6) ( 1.5) (16.8) (79.8) 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 89554.25 (100.0) TOTAL 306625.70 275796.56 323502.33 306452.49 235073.35 268624.93 290484.68 402950.84 309445.62 453955.86 352374.75 89554.25 3.5) 114949.02 3.2) 309921.00 8.6) 217171.80 6.0) 378114.72 10.5) 249284.80 6.9) 251435.57 7.0) 341318.14 9.4) 400100.13 11.1) 309965.93 8.6) 445089.26 12.3) 471329;28- 13.0) 3614841.36 TONN OF SOUTHOLD PROCEDURE FREQUENCY REPORT EMPLOYEE HEALTH BENEFIT PLANS ISLAND GROUP PROCESS DATES: 5/ 1/12 - 5/31/12 Client Totals PAGE 1 DATE 6/ 5/12 PROC CATEGORY DESCRIPTION NUM SVCS TOT.BILLED AVE.BILLED TOT.PAID AVE.PAID 6001 HOSPITAL RO0 HOSPITAL 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 7001 EMERGENCY RO PHYS TREATMENT MED EMERG 7040 XRAY X-RAY OUT-PATIENT 7051XRAY RADIOLOGY/PATHOLOGY 7054 DIAGNOSTIC MEDICAL TESTING 7055 XRAY XRAY INTERP 7062 LABORATORY S LAB 80% 7144 MEDICAL SUPP INJECTIONS 7145 MEDICAL SUPP IMMUNIZATION 7151 OTHER DURABLE MED EQUIP 7189 MENTAL OR NE M/N OFFICE VISIT 7249 OTHER AMBULANCE 7279 OFFICE VISIT CHIROPRACTIC ADJUSTMENT 9000 OFFICE VISIT 9001 EMERGENCY RO 9002 AUDIT/CONSUL 9004 AUDIT/CONSUL 9005 PREVENTATIVE 9006 PREVENTATIVE 9007 MENTAL OR NE 9009 OFFICE VISIT 9010 DOCTOR SERVI 9011 HOSPITAL RO0 9012 SURGERY 9013 EMERGENCY RO 9014 MEDICAL SUPP 9015 XRAY 9019 LABORATORY B 9020 SURGERY 9021SURSERY 9025 DIAGNOSTIC 9026 OFFICE VISIT 9029 DOCTOR SERVI 9040 OTHER 9042 THERAPY 9045 THERAPY 9046 OTHER 9050 AUDIT/CONSUL 9055 PRESCRIPTION 9060 OTHER 9070 DIAGNOSTIC 9075 OTHER 9080 XRAY 9081XRAY 9085 DIAGNOSTIC PP OFFICE VISIT PP ER VISIT PP COB PP DIABETIC SUPPLIES IMMUNIZATIONS PP INJECTIONS PP M/N PP WELL CARE PP HOSPITAL VISIT PP HOSPITAL ROOM AND BOARD PP AMBULATORY OUT PATIENT SURGERY PP EMERGENCY TREATMENT MEDICAL EMERGENCY PP DURABLE MED EQUIP PP X-RAY OUT PATIENT PP LABORATORY OUT PATIENT PP SURGERY PP ASST SURGEON P P TESTING PP ALLERGY PP NENBORN CARE PP CHIROPRACTIC PP THERAPY PP PHYSICAL THERAPY PP NURSING PP CONSULTATION RX PHARMACARE PP HOME INFUSION THERAPY PP MAMMOGRAPHY PP AMBULANCE PP RADIOLOGY PP XRAY INTERP PP EKG 5 119610.06 23922,01 48270.00 9654.00 3 1918.00 639.33 1075.98 358.66 1 225.00 225.00 11.97 11.97 10 2998.14 299.81 52.59 5.26 8 1705.00 213.13 280.00 35.00 1 2040.11 2040.11 1970.11 1970.11 1 251.00 251.00 251.00 251.00 I 14553.84 14553.84 254.92 254.92 4 235.61 58.90 0.00 0.00 3 908.00 302,67 333.03 111.01 3 ~ 541.00 180.33 91.20 30.40 16 878.35 54.90 0.00 0.00 1 25.00 25.00 0.00 0.00 I 25.00 25.00 O.OO 0.00 3 570.00 190.00 30.32 10.11 3 550.00 183.33 229.60 76.53 2 984.00 492.00 949.00 474.50 12 1600.00 133.33 0.00 0.00 132 24283.74 183.97 11527.86 87.33 11 6895.00 626.82 2710.00 246.36 234 83960.80 358.81 5740.04 24.53 4 945.92 236.48 663.12 165.78 3 212.00 70.67 58.00 19.33 6 322.00 53.67 58.27 9.71 59 6994.00 118.54 3596.00 60.95 14 3485.00 248.93 1434.00 102.43 14 3740.00 267.14 1753.75 125.27 5 163983.84 32796.77 127640.25 25528.05 4 22635.94 5658.99 18663.44 4665.86 8 25165,18 2895.65 17982.14 2247.77 1 902.00 902.00 902.00 902.00 14 25329.90 1809.28 19992.84 1428.06 13 11519.29 886.10 8909.38 685.34 32 65664.00 2052.00 16132.00 504.13 1 4800.00 4800.00 960.00 960.00 21 5814.37 276.87 1689.96 80.47 40 2035.50 50.89 1439.50 35.99 3 500.00 166.67 155.00 51.67 8 428.00 53,50 140.00 17.50 1 35.00 35,00 15.00 15.00 41 5064.52 123.52 1864.00 45.46 1 190.00 190.00 120.00 120.00 16 5384.02 336.50 2450.00 153.13 2 91811.15 45905.58 91811.15 45905.58 2 1435,00 717.50 1435,00 717.50 8 1725.00 215.63 783.00 97.88 2 1400.00 700,00 1015.00 507.50 26 6802.98 261.65 2376.80 91.42 36 7154.00 198.72 1894.86 52.64 5 279.00 55.80 120.00 24.00 TOWN OF SOUTHOLD PROCEDURE FREQUENCY REPORT EMPLOYEE HEALTH BENEFIT PLANS ISLAND GROUP PROCESS DATES: 5/ 1/12 - 5/31/12 Client Totals PAGE 2 DATE 6/ 5/12 PROC CATEGORY DESCRIPTION NUM SVCS TOT.BILLED AVE.BILLED TOT.PAID AVE.PAID 9090 ANESTHESIA PP ANESTHESIA 10 14936.00 1493.60 6049.20 604.92 9095 LABORATORY S PP LAB 278 27897.59 100.35 9433.06 33.93 9099 MISCELLANEOU PP MISCELLANEOUS 5 590.00 118.00 250.00 50.00 9100 OTHER MULTIPLAN DISCOUNT FEE 31 2993.75 96.57 2993.75 96.57 9105 MISCELLANEOU PSI HOSP DISCOUNT FEE 23 28864.88 1254.99 28864.88 1254.99 9108 AUDIT/CONSUL NYS SURCHARGE I 17991.00 17991,00 17991.00 17991.00 9109 MISCELLANEOU NYS GME~S 1 2088.00 2088.00 2088.00 2088.00 9180 MISCELLANEOU PP IVF RADIOLOGY 3 690.00 230.00 438.15 146.05 9195 MISCELLANEOU PP IVF LAB 10 665.00 66.50 127.17 12.72 9201 THERAPY PP ACUPUNCTURE 7 1066.00 152.29 791.00 113.00 9204 THERAPY PP EPIDURALS 1 1250.00 1250.00 355.00 355.00 9207 THERAPY PP MRI 2 2700.00 1350.00 1347.00 673.50 9209 XRAY PP CT SCAN 3 3500.00 1166.67 848.00 282.67 CLIENT TOTALS 1220 833747.48 683.40 471408.29 386.40