Loading...
HomeMy WebLinkAbout08/2010**** TOWN OF SOUTHOLD **** EMPLOYEE HEALTH CARE PLAN ISLAND GROUP 9/ 7/10 CLAIM LAG REPORT - AMOUNT BILLED PLAN YEAR 9/ 1/09 - 8/31/10 CLAIMS All Units MONTH OF PAYMENT SEP 09 OCT 09 NOV 09 DEC 09 JAN 10 FEB 10 MAR 10 APR 10 MAY 10 JUN 10 JUL 10 AUG 10 OCT 09 NOV 09 DED 09 JAN 10 FEB 10 MAR 10 APR 10 MAY 10 JUN 10 JUL 10 AUG 10 TOTAL ................................................................... MONTH OF SERVICE ................................................................... 0.00 86592.21 21.2) 220232.31 53.8) 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) 765.00 ( 0.2) 409193.19 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 106180.69 (17.0) 221101.44 (35.4) 198186.59 (31.8) 73263,68 (11.7) 8594.25 ( 1.4) 3388.52 ( 0.5) 2313.72 ( 0.4) 391.00 ( 0.1) 4956.32 ( 0.8) 5914.10 ( 1.0) 0.00 0.00 0.00 0,00 0.00 52997.66 9.9) 182757.55 34.2) 131760.91 24.6) 102221.53 19.1) 28870.36 5.4) 3526.58 0.7) 046.00 0.2) 2801.09 ( 0.5) 28880.09 ( 5,4) 0.00 0.00 0.00 0.00 28422.18 3.9) 205295.93 28.2) 388659.75 53.4) 22016.22 3.0> 8879.05 1.2) 4816.15 0.7) 39797.49 5.5) 29603.78 4.1) 0.00 0.00 0.00 25035.32 0.00 0.00 6.2) 261381.52 99307.41 0.00 64.4) 21,6) 45387.84 158057.58 78945.12 11.2) 34.3) (11.9) 21396.16 145929.90 250537.02 5.3) 31.7) (37.9) 24259.92 14690.34 289392.40 6.0) 3.2) (43.8) 5791.84 6899,67 14580.28 1.4) 1.5) ( 2.2) 22387.20 36023.58 27720.03 5.5) 7.8) ( 4.2) 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 143126.26 0.00 0.00 0.00 (26.8) 256095.88 87033.45 0.00 0.00 ( 47.9) ( 20.4) T5825.10 185669.85 7047'5.50 0.00 (14.2) (43.4) (18.5) 60045,81 154960.57 311211.08 102562.23 (11,2) (36.2) (81,5) (100.0) 624290.31 534861,77 727490.55 405639.80 460908.48 661174.85 535093.05 427663.87 381684.58 102562.23 SEP 09 85673.22 21.2) 199768.39 49.4) 65820.17 16.3) 3764.76 0.9) 18418.22 4.5) 14804.33 3.7) 11647.90 2.9) 1405.66 0.4) 65.00 0.0) 86.80 0.0) 1000.00 0.3) 2074.00 0.5) 404528.45 TOTAL 85673.22 1.5) 286360.60 5.0) 392233.17 6.9) 313238.96 5.5) 471835.69 8.3) 457~03.38 8.1) 874255.46 15.4) 841167.37 6.0) 577069.34 (10.2) 683448.14 (12.0) 410158.33 ( 7.2) 782147.47 (13.8) 5675091.13 RECEIVED 8EP 3 0 2010 **** TOWN OF SOUTNOLD EMPLOYEE NEALTH CARE PLAN ISLAND GROUP 9/ 7/10 CLAIM LAO REPORT - AMOUNT PAID PLAN YEAR 9/ 1/09 - 8/31/10 CLAIMS AIl Units MONTH OF PAYMENT GEP 09 OCT 09 NOV 09 DEC 09 JAN 10 FEB 10 MAR 10 APR 10 MAY 10 JUN 10 JUL 10 AUG 10 OCT 09 NOV 09 DEC 09 JAN 10 FEB 10 MAR 10 APR 10 MAY 10 JUN 10 JUL 10 AUG 10 TOTAL ................................................................... MONTH OF SERVICE .................................................................... 0.00 59294.36 (36.6) 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) 125.03 0.1) 74.35 0.1) 161804.37 0.00 0.00 0,00 0,00 70603.29 0.00 (37.6) 80974.28 26918.34 (43.2) 11,2) 158~5.05 128230.82 (8,5) 53.4) 14798.66 67639,57 (7.9) 28.2) 3673.36 13257.27 ( 2.0) 5,5) 418.37 2687.81 ( 0.2) 1.1) 871.98 417.00 ( 0.5) 0.2) 0.00 56.69 0.0) 233.36 449.45 (0.1) 0.2) 126.74 281.40 ( 0.1) 0.1) 187575.09 239938.35 0.00 0.00 0.00 0.00 12765.35 5.0) 122682.19 48.4) 104061,78 41.0) 6475.95 2.5) 2025.90 0.8) 582.55 0.2) 4724.58 1.9) 441.31 0.2) 253759.61 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 14384.96 0.00 8.8) 135034.24 64160.00 82.5) 29,2) 5755.23 85699.02 3.5> 39.0) 5467.47 61781.23 3.3) 28.1) 1984.57 4916.77 1.2) 2.2) 965.16 1235.08 0.6) 0.6) 187.00 1862.81 0.1) 0,9) 163778,63 219654.91 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 (18.2) 104367.10 101119.30 (36.0) (38.6) 114894.10 132311.68 (39.6) (50.5) 6533.43 21015.84 (2.3) (8.0) 11518.81 7471.68 ( 4.0) ( 2.9) 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 O.OO 0.00 0.00 60085.65 0.00 0.00 (24.9) 112054.70 49217.54 0.00 (46,5) (34.0) 68768.37 95387.45 62874.52 (28.6) (66.0) (100.0) 290133.13 261918.50 240908,72 144604.99 62874.52 SEP 09 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 0.0) 61.85 0.0) 14.22 0.0) 178697.77 TOTAL 55707.21 138967,01 5.8) 172540.74 7.2) 115321.03 4.8) 176181.70 7.3) 231533,78 9.6) 323869.87 13,5) 154940.10 6.4) 276098.27 11.5) 314864.20 13.1) 196616.02 8.2) 249008.66 I0.3) 2405648.59 TOWN OF SOUTNOLD PROCEDURE FREQUENCY REPORT EMPLOYEE NEALTN BENEFIT PLANS ISLAND GROUP PROCESS DATES: 8/ 1/10 - 8/31/10 Client Totals PAGE 1 DATE 9/ 7/10 PROC CATEGORY DESCRIPTION NUM SVCS TOT.BILLED AVE~BILLED TOT.PAID AVE.PAID 6001 ROSPITAL RO0 HOSPITAL ROOM AND BOARD 6 150651.80 25108.63 30828.04 5138.01 6020 SURGERY AMBULATORY OUT PATIENT SURGERY I 2066.00 2066.00 1859.40 1859.40 6030 SURGERY SURGERY 13 16131,00 1240.85 12050.80 926.98 6050 ANESTNESIA ANESTNESIA 1 1750.00 1750.00 325.60 325.60 =nzn ..................................... 2996 27 .............. 6061 OFFICE VISIT CONSULTATION 2 700.00 350.00 42.27 21.14 6070 DOCTOR SHRVI PNYBICIAN IN-HOSPITAL VISIT/S 6 1920.00 320.00 1343.81 223.97 6999 EMERGENCY RO EMERGENCY TREATMENT MEDICAL EMERGENCY 2 11705.64 5852.82 9829.79 4914.90 7001 EMERGENCY RO PNYS TREATMENT MED EMERG 2 922.00 461.00 34.30 17.15 7003 WELLNESS WELLNESS BENEFITS 1 175.OO 175.00 0.00 0.00 7040 XRAY X-RAY OUT-PATIENT 3 2009.23 669.74 110.87 36.96 7051 XRAY RADIOLOGY/PATHOLOGY 4 610.94 152,74 73,27 18.32 7054 DIAGNOSTIC MEDICAL TESTING 6 2437.63 406.27 370.18 61.70 7055 XRAY XRAY INTERP 4 134.55 33.64 23.64 5.91 7060 LABORATORY B LABORATORY OUT-PATIENT 1 266.00 266.80 191.00 191.00 7062 LABORATORY S LAB 80% 29 4899.70 168.96 596.65 20.57 7144 MEDICAL SUPP INJECTIONS 1 80.00 80.00 0.00 O.O0 7151 OTHER DURABLE MED EQUIP 4 453.53 113.38 0.00 0.00 7'500 OFFICE VISIT WELL CARE 1 170.00 170.00 0.00 0.00 9000 OFFICE VISIT PP OFFICE VISIT 160 26044.90 162.78 10894.00 68.09 9001 EMERGENCY RO PP ER VISIT 11 5187.00 471.55 1555.00 141.36 9002 AUDIT/CONSUL PP COB 656 286395.66 436.58 15899.80 24.24 9004 AUDIT/CONSUL PP DIABETIC SUPPLIES 20 4176.69 208.83 2969.05 148.48 9005 PREVENTATIVE IMMUNIZATIONS 8 1165.00 145.63 622.00 77.75 9006 PREVENTATIVE PP INJECTIONS 10 488.00 48.80 105.73 10.57 9007 MENTAL OR ME PP M/N 47 11022,00 234.51 6182.50 131.54 9009 OFFICE VISIT PP WELL CARE 14 3120.00 222.86 1078.00 77.00 9010 DOCTOR SERVI PP HOSPITAL VISIT 11 1839.00 167.18 857.00, 77.91 9011 HOSPITAL RO0 PP HOSPITAL ROOM AND BOARD 2 5553,51 2776.76 -1897.86 -948.93 9012 SURGERY PP AMBULATORY OUT PATIENT SURGERY 1 6592.22 6592.22 5238.78 5238.78 9013 EMERGENCY RO PP EMERGENCY TREATMENT MEDICAL EMERGENCY 10 19828.48 1982.85 12770.09 1277.01 9014 MEDICAL SUPP PP DURABLE MED EQUIP 11 2644.86 240.44 1656,83 150,62 9015 XRAY PP X-RAY OUT PATIENT 6 9296.40 1549.40 5875.16 979.19 9019 LABORATORY B PP LABORATORY OUT PATIENT 30 20673.10 689.10 15368.12 512.27 9020 SURGERY PP SURGERY 31 13817.00 445.71 4740.00 152.90 9025 DIAGNOSTIC P P TESTING 24 7398.00 308.25 2907.00 121.13 9026 OFFICE VISIT PP ALLERGY 12 513.00 42.75 337.00 28.08 9040 OTHER PP CHIROPRACTIC 18 1401.00 77.83 295.00 16.39 9042 THERAPY PP THERAPY 2 60.00 30.00 30.00 15.00 9045 THERAPY PP PNYSICAL THERAPY 32 8549.23 267.16 5208.92 162.78 9050 AUDIT/CONSUL PP CONSULTATION 16 6291.60 393.23 2973.04 185.82 9055 PRESCRIPTION RX PBARMACARE 2 58871.18 29435.59 58871.18 29435.59 9070 DIAGNOSTIC PP MAMMOGRAPHY 8 1875.00 234.38 730.00 91.25 9080 XRAY PP RADIOLOGY 27 8432.00 312.30 2572.60 95.28 9081 XRAY PP XRAY INTERP 11 1300.00 118.18 119.00 10.82 9085 DIAGNOSTIC PP EKG 11 882.00 80.18 330.00 30.00 9090 ANESTHESIA PP ANESTBESIA 4 2890.00 722.50 1122.00 280.50 9095 LABORATORY S PP LAB 266 23619.14 88.79 8174.01 30.7'5 9099 MISCELLANEOU PP MISCELLANEOUS 12 1560.33 130.03 86.40 7.20 9105 MISCELLANEOU PSI ROSP DISCOUNT FEE 10 2660.33 266.03 2660.33 266.03 TOWN OF SOUTNOLD PROCEDURE FREQUENCY REPORT EHPLOYEE HEALTH BENEFIT PLANS ISLAND GROUP PROCESS DATES: 8/ 1/10 - '8/31/10 CLient TotaLs PAGE 2 DATE 9/ 7/10 PROC CATEGORY DESCRIPTION NUN SVCS TOT.SILLED AVE.BILLED TOT.PAID AVE.PAID 9108 AUDIT/CONSUL NYS SURCHARGE 1 4009.00 4009.00 4009.00 4009.00 9109 NISCELLANEOU NYS GME~S I 2074.00 2074.00 2074.00 2074.00 9201 THERAPY PP ACUPUNCTURE 3 399.0D 133.00 339.00 113.00 9203 THERAPY PP HEARING AIDS 1 5030.00 5030.00 3000.00 3000.00 9205 THERAPY PP NERVE CONDUCTION 2 1676.00 838.00 580.00 290.00 9206 THERAPY PP EMG 1 304.00 304.00 130.00 130.00 9209 XRAY PP CT SCAN 2 1450.00 725.00 O.O0 0.00 CLIENT TOTALS 1601 760417.92 474.96 238889.33 149.21