Loading...
HomeMy WebLinkAbout07/2010MONTH OF PAYMENT AUG 09 SEP 09 OCT 09 NOV 09 DEC 09 JAN 10 FEB 10 MAR 10 APR 10 MAY 10 JUN 10 JUL 10 TOTAL **** TOWN OF SOUTHOLD **** EMPLOYEE HEALTH CARE PLAN ISLAND GROUP 8/ 2/10 CLAIM LAG REPORT - AMOUNT BILLED PLAN YEAR 8/ 1/09 - 7/31/10 CLAIMS All Units ................................................................... MONTH OF SERVICE AUG 09 SEP 09 OCT 09 NOV 09 DEC 09 JAN 10 FEB 10 MAR 10 APR 10 MAY 10 JUN 10 JUL 10 TOTAL 87108.17 0.00 13.6) 230401.75 8567~.22 35.8) 21.3) 126202.29 199768.39 19.6) 49.6) 7857.78 65820.17 1.2) 16.4) 1697.79 3764.76 0.3) 0.9) 113311.99 18418.22 17.6) 4.6) 1942.47 14804.35 0.3) 3.7) 1426.83 11647.90 0.2) 2.9) 0.00 1405.66 0.4) 70682.24 65.00 (11.0) 0.0) 100.00 86.80 ( 0.0) 0.0) 2065.00 1000.00 ( 0.3) 0.3) 642796.31 402454.45 0.00 0.00 86592.21 21.2) 220232.31 53.9) 35375.10 8.7) 44051.15 10,8) 7343.21 1.8) 2443.10 0.6) 3096.07 0.8) 1295.65 0.3) 5636.20 1.4) 2363.19 0~6) 408428.19 0.00 0.00 0.00 106180.69 17,2) 221101.44 35.8) 198186.59 32.0) 7-3263.68 11.8) 8594.25 1.4) 3388.52 0.6) 2313.72 0.4) 391.00 0.1) 4956.32 0.8) 618376.21 0.00 0.00 0.00 0.00 0.00 0.00 0,00 0.00 O,OO 0.00 0.00 0.00 O.OO 0.00 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 52997.66 0.00 0.00 0.00 0.00 0.00 0.00 0.00 10.5) 182757.55 28422.18 0.00 0.00 0.00 0.00 0.00 0.00 36.1) 4.1) 131760.91 205295.93 25035.32 0.00 0.00 0.00 0.00 0.00 26.0) 29.4) 6.5) 102221.53 388659,75 261381.52 20,2) 55.7) 68.2) 28870.36 22016.22 45387.84 5.7) 3.1) 11.8) 3526.58 8879.05 21396.16 0.7) 1.3) 5.6) 1046,00 ' 4816.15 24259.92 0.2) 0.7) 6.3) 2801.09 39797.49 5791.84 0.6) 5.7) 1.5) 505981.68 99307.41 0.00 0.00 0.00 0.00 (23,4) 158057.58 78945.12 0.00 0.00 0.00 (37.2) (12.5) 145929.90 250537.02 143126.26 0.00 0.00 (34.4) (59.5) (30.1) 14690.34 289392.40 256095.88 87033.45 0.00 ( 3.5) ( 45.7) ( 53.9) ( 31.9) 6899.67 14580.28 75825.10 185669.85 70473.50 ( 1,6) ( 2.3) ( 16.0) ( 68,1) (100.0) 697886.77 383252,60 424884.90 633454,82 475047.24 272705.30 70473.50 87108.17 1.6) 316074.97 5.7) 412562.89 7.5) 400090.95 7.2) 314936.75 5.7) 585147.68 I0.6) 459445.85 8.3) 875682.29 15.8) 341167.37 6.2) 647751.58 11.7) 683548.14 (12.3) 412223.33 ( 7.5> 5535739.97 RECEIVED AUG 2 0 \--\ **** TOWN OF SOUTNOLD EHPLOYEE HEALTH CARE PLAR ISLAND GROUP 8/ 2/10 CLAIM LAG REPORT - AMOUNT PAID PLAN YEAR 8/ 1/09 - 7/31/10 CLAIMS All Units -- .................................................................. ................ ~u rmm iu MAR lu APR 10 MAY 10 JUN 10 JUL 10 TOTAL o9 585}:Ii ' ;]oo 'o.0o' "0.;o SEP 09 OCT 09 ROV 09 DEC 09 JAN 10 FEB 10 MAR 10 APR 10 MAY 10 JUN 10 103493.76 50.0) 30477.42 14.7) 2877.67 1.4) 685.91 0.3) 9358.03 4.5) 344.36 0.2) 141.46 0.1) O,O0 126.00 ( 0.1) 12.13 ( 0.0) 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) I7.00 0.0) 14.21 0.0) 0.00 0.00 59294.36 36.7) 84166.86 52.0) 6178.66 3,8) 6937,58 4.3) 4266.84 2.6) 658.91 0.4) 52.51 0.0) 31.29 0.0) 17.98 0.0) 0.00 70603.29 37.7) 80974.28 43.2) 15875.05 8.5) 14798.66 7.9) 5673.36 2.0) 418.37 0.2) 871.98 0.5) 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 11.2> 128230.82 12765.35 0.00 · 53.5) 5.0) 67639.57 122682.19 14~84.96 28.2) 48.4) 8.8) 13257.27 104061.78 135034.24 5.5) 41.1) 82.5) 2687.81 6475.95 5755.23 1.1) 2.6) 3.5) 417.00 2025.90 5467.47 0.2) 0.8) 3.3) 56.69 582.55 1984.57 0.0) 0.2) 1.2) JUL 10 719.00 61.85 125.03 233.36 449.45 4724.58 965.16 ( 0.4) 0.0) 0.1) ( 0.1) 0.2) 1.9) 0.6) TOTAL 206795.28 178683.55 161730.02 187448.35 239656.95 253318.50 163591.63 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 64160.00 0.00 0.00 0.00 0.00 (29.5) 85699.02 52819.69 0.00 0.00 0.00 (39.4) (19.0) 61781.23 104367.10 101119.30 0.00 0.00 (28.4) (37.5) (39.7) 4916.77 114894.10 132311.(~ 60085.65 0.00 ( 2.3) (41.2) (52.0) (34.9) 1235.08 6535.43 21015.84 112054.70 49217.54 ( 0,6) ( 2.3) ( 8.3) (65.1) (100.0) 217792.10 278614.32 254446.82 172140.35 49217.54 2.5) 159200.97 6.7) 169444.43 7.2) 175418.41 7.4) 116007.94 4.9) 185539.73 7.8) 231878.14 9.8) 324011.33 13.7) 154940.10 6.6) 276224.27 11.7) 314876.33 13.3) 197335.02 8.3) 2363435.21 TOWN OF SOUTHOLD PROCEDURE FREQUENCY REPORT EMPLOYEE HEALTH BENEFIT PLANS ISLAND GROUP PROCESS DATES: 7/ 1/10 - 7/31/10 Client Totals PACE I DATE 8/ 3/10 PROC CATEGORY DESCRIPTION NUM SVCS TOT.BILLED AVE.BILLED TOT.PAID AVE.PAID 6030 SURGERY SURGERY 7 4438.00 634.00 171.52 24.50 6050 ANESTHESIA ANESTHESIA 2 2860.00 1430.00 27,59 13.80 6060 OFFICE VISIT PHYSICIAN OFFICE VISIT 11 1987.00 180.64 727.42 66.13 6070 DOCTOR SERVI PHYSICIAN IN-HOSPITAL VISIT/S 8 1207.00 150.88 364.59 45.57 7001 EMERGENCY RO PHYS TREATMENT MHD EMERG 1 410.00 410.00 35.14 35.14 7003 WELLNESS WELLNESS BENEFITS 1 300.00 300.00 196.10 196.10 7040 XRAY X-RAY OUT-PATIENT 4 25320.86 6330.22 2314.39 578.60 7051XRAY RADIOLOGY/PATHOLOGY 3 1665.00 555.00 0.00 0.00 7054 DIAGNOSTIC MEDICAL TESTING 10 $913.00 391.30 1516.24 151.62 7055 XRAY XRAY INTERP 2 71.00 35.50 1.84 0.92 7060 LABORATORY S LABORATORY OUT-PATIENT 2 528.00 264.00 378.00 189.00 7062 LABORATORY S LAB 80% 8 3220.00 402.50 783.21 97.90 7249 OTHER AMBULANCE 4 3848,00 962.00 761.04 190.26 9000 OFFICE VISIT PP OFFICE'VISIT 120 19514.37 162.62 9506.00 79.22 9001 EMERGENCY RD PP ER VISIT 6 3435.00 572.50 1262.50 210.42 9002 AUDIT/CONSUL PP COB 248 60388.76 243.50 4786.70 19.30 9004 AUDIT/CONSUL PP DIABETIC SUPPLIES 9 844.94 93.88 516.02 57.34 9005 PREVENTATIVE IMMUNIZATIONS 14 1517.00 108,36 1041.00 74.36 9006 PREVENTATIVE PP INJECTIONS 18 642.00 35.67 178.04 9.89 9007 MENTAL OR HE PP M/N 45 5498.00 122.18 2995.00 66.56 9009 OFFICE VISIT PP WELL CARE 24 5580.00 232.50 2183.00 90.96 9010 DOCTOR SERVI PP HOSPITAL VISIT 3 846.00 282.00 428.75 142.92 90tl HOSPITAL NO0 PP HOSPITAL ROOM AND BOARD 2 48232.00 24116.00 11557.45 5778.73 9012 SURGERY PP AMBULATORY OUT PATIENT SURGERY 2 5774.96 2887,48 4549.97 2274.99 9013 EMERGENCY RO PP EMERGENCY TREATMENT MEDICAL EMERGENCY 7 15765.34 2252.19 10864.08 1552.01 9014 MEDICAL SUPP PP DURABLE MHD EQUIP 3 2417.22 805.74 2402.31 800.77 9015 XRAY PP X-RAY OUT PATIENT 6 11917.95 1986.33 9132.96 1522.16 9016 AMBULATORY S PP AMBULATORY FACILITY FEE I 4460,00 4460.00 3515.00 3315.00 90~9 LABORATORY S PP LABOPJ~TORY OUT PATIENT 14 10654.38 761.03 8033.50 573.82 9020 SURGERY PP SURGERY 22 15561.00 707,32 5214.00 237.00 9025 DIAGNOSTIC P P TESTING 50 10922.00 218.44 4959.00 99.18 9026 OFFICE VISIT PP ALLERGY 17 1518,00 89.29 1146.00 67.41 9040 OTHER PP CHIROPRACTIC 19 1681.00 88,47 305.00 16.05 9041 OFFICE VISIT PP NUTRITIONAL COUNSELING 4 790.00 197.50 351.00 87.75 9045 THERAPY PP PHYSICAL THERAPY 7 846.54 120.93 280.00 40.00 9050 AUDIT/CONSUL PP CONSULTATION 14 4025.95 287.57 2499.00 178.50 9055 PRESCRIPTION RX PHARMACARE 2 56984.25 28492.13 56984.25 28492.13 9070 DIAGNOSTIC PP MAMMOGRAPHY 2 450.00 225.00 175.00 87.50 9075 OTHER PP AMBULANCE 1 3012.00 3012.00 2374.68 2374.68 9080 XRAY PP RADIOLOGY 12 7346.00 612.17 3850.00 320.83 9081 XRAY PP XRAY INTERP 25 2117.00 84.60 556.00 22.24 9085 DIAGNOSTIC PP EKG 7 505.00 72.14 210.00 30.00 9090 ANESTHESIA PP ANESTHESIA I 756.00 756.00 55.00 55.00 9095 LABORATORY S PP LAB 238 17652.13 74.17 6671.82 28.03 9099 MISCELLANEOU PP MISCELLANEOUS 4 235.00 58.75 0.00 0.00 9105 MISCELLANEOU PSI HOSP DISCOUNT FEE 9 9947.58 1105.29 9947.58 1105.29 9108 AUDIT/CONSUL NYS SURCHARGE 1 11497.00 11497.00 11497.00 11497.00 9109 MISCELLANEOU NYS GME'S 1 2075.00 2073.00 2073.00 2073.00 9201 THERAPY PP ACUPUNCTURE 2 266.00 133.00 226.00 113.00 9203 THERAPY PP MEARING AIDS 2 6600.00 3300.00 3000.00 1500.00 TOWN OF SOUTHOLD PROCEDURE FREQUENCY REPORT EMPLOYEE HEALTH BENEFIT PLANS ISLAND GROUP PROCESS DATES: 7/ 1/10 - 7/31/10 Client Totals PAGE 2 DATE 8/ 3/10 PROC CATEGORY DESCRIPTION NUM SVCS TOT.SILLED AVE.SILLED TOT.PAID AVE.PAID 9205 THERAPY PP NERVE CONDUCTION 2 1400.00 700.00 444.00 222.00 9206 THERAPY PP EMG 1 400.00 400.00 155.00 155.00 9207 THERAPY PP MRI 2 3600.00 1800.00 1605.00 802.50 9209 XRAY PP ET SCAN 7 5300.00 757.14 2598~00 371.14 CLIENT TOTALS 1037 412741.23 398.01 197205.69 190.17