Loading...
HomeMy WebLinkAbout04/2011PAYMENT APR 10 MAY 10 JUN 10 JUL 10 AUG 10 SEP 10 OCT 10 NOV 10 DEC 10 JAH 11 FEB 11 TOTAL EMPLOYEE HEALTH CARE PLAN ISLAND GROUP 4/11/11 CLAIM LAG REPORT - AMOUNT BILLED PLAN YEAR 4/ 1/10 - 3/31/11 CLAIMS All Units ................................................................... MOHTH OF SERVICE ................................................................... APR 10 MAY 10 JUN 10 JUL 10 AUG 10 SEP 10 OCT 10 NOV 10 DEC 10 JAN 11 FEB 11 MAR 11 TOTAL 78945.12 0.00 11.5) 250537.02 141881.26 36.4) 23.8) 289392.40 256095.88 42.1) 43.0) 14580.28 75825.10 2.1) 12.7) 27720.03 60045.81 4.0) 10.1) 11082.10 12081.17 1.6) 2.0) 7160.43 7289.30 1.0) 1.2) 5316.26 32195.38 0.8) 5.4) 0.00 4051,64 0.7) 676.00 250,00 ( 0.1) 0.0) 535.00 3660.00 (0.1) 0.6) 2050.00 2591.00 ( 0.3) 0.4) 607994.64 595966.54 0.00 0.00 0,00 0.00 87033.45 0.00 17.1) 185669.85 70473.50 36.5) (11.0) 154960.57 311211.08 30.4) (48.4) 35226.47 42175.15 6.9) ( 6.6) 23097.89 96367.39 4.5) (15.0) 8676.28 107447.14 1.7) (16.7) 3897.39 10595.65 0.8) ( 1.6) 546.65 821.00 0.1) ( 0.1) 7460.51 2992.01 1,5) ( 0.5) 2441.82 722.15 0.5) (0.1) 509010.88 642805.07 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 100812.23 0.00 0.00 13.0) 236905.95 57993.86 0.00 30.6) 10.2) 363919.65 243359.80 63672.35 47.0) 42,8) 16.8) 19435.63 184545.~7 159616.29 2.5) 32.4) 42.1) 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 94280.18 0.00 0.00 0.00 (10.6) 0.00 0.00 0.00 136403,00 0.00 0.00 (40.9) 126785.29 97257.26 0.00 (38.0) (30.5) 88033.62 (100.0) 88033.62 19445.75 2.5) 22745.66 2.9) 5355.86 0.7) 547'5.60 0,7) 774094.33 10877.60 65625.41 414771.57 1.9) 17.3) (46.7) 58839.60 10.3) 9150.57 1.6) 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 85515.39 (17.9) 52800.24 314765.85 256996.32 13.9) (35.5) (53.9) 25758.31 30960.51 90038.67 6.8) ( 3.5) (18.9) 4286.90 70130.27 221519.06 0.8) ( 21.0) ( 69.5) 569053.90 379496.57 887587.25 476675.91 333318,56 318776.32 12023.97 32809.14 44125.53 3.2) ( 3.7) ( 9.3) 78945.12 1.3) 392418.28 6.3) 632521.73 10.1) 346548.73 5.5) 654749.72 10.4) 395464.70 6.3) 804866.81 12.8) 611512.7-5 9.8) 614780.40 9.8) 844844,32 13,5) 399953,99 6.4) 486207.06 7.8) 6262813.59 MONTH OF PAYMENT APR 10 MAY 10 JUN 10 JUL 10 AUG 10 SEP 10 OCT 10 NOV 10 DEC 10 JAN 11 FEB 11 MAR 11 **** TOWN OF SOUTNOLD EMPLOYEE HEALTH ~ARE PLAN ISLAND GROUP 4/11/11 CLAIM LAG REPORT - AMOUNT PAID PLAN YEAR 4/ 1/10 - 3/31/11 CLAIMS All Un~ts ................................................................... MONTH OF SERVICE ................................................................... APR 10 MAY 10 JUN 10 JUL 10 AUG 10 SEP 10 OCT 10 NOV 10 DEC 10 JAN 11 FEB 11 MAR 11 o.oo o.oo o.oo Loo o. o - o.o - o.oo- o.oo Loo 0.00 52819.69 17.7) 104367.10 35.0) 114894.10 38.6) 6533.43 2.2) 11518.81 3.9) 425.98 0.1) 3863.47 1.3) 3069.28 1.0> 0.~0 57.60 25.11 0.0) 388.00 100114.30 36.8) 132311.68 48.6) 21015.84 7.7> 7471.68 2.7) 1223.54 0.5) 1204.21 0.4) 6188.64 2.3) 1514.94 O.6) 160.15 0.1) 374.67 0.1) 655.00 0.00 0.00 0.00 0.00 0.00 0.00 0,00 60085.65 23.1) 112054.70 43.0) 68768.37 26.4) 5163.03 2.0) 7360.23 2.8) 3474.50 1.3) 1854.80 0.7) 163.67 0.1) 117.64 0.1) 1503.63 0.00 0.00 0.00 0.00 0.00 0.00 49217.54 29.2) 95387.45 56.5) 9036.22 5.3) 5861.70 3.5) 4133.16 2.5) 4353.05 2.6) 403.96 0.2) 153,63 0.1) 235.54 0.00 0.00 0.00 0.00 0.00 62548.92 22.8) 116497.52 42.4) 81784.06 29.8) 2694.68 1.0) 4933.14 1,8) 1025.33 0.4) 1298.36 0.5) 3739.37 0.00 0.00 0.00 0.00 41218.76 (21.9) 108013,67 (57.4) 27867.66 (14,8) 1696.22 ( 0.9) 3116.~9 ( 1.6) 4611.98 ( 2.5) 1831.60 0.00 0.00 0.00 ( 0.1) 0.2) 0.6) 0.1) 1.4) ( 1.0) 1.1) ( 1.0) ( 11.6) TOTAL 297962.S7 272234.65 260546.22 168782.25 274521.38 188356.48 209897.90 335919,15 256514,63 50449.42 0.00 0.00 24.0) 87479.99 71041.~ 0.00 41.7) (21.1) 21284.42 228138.92 59057.27 10.1) (67.9) (23.0) 30518.79 21653.?6 132344.66 14.5) ( 6,5) (51.6) 17872.36 11649.72 35455.15 8.5) ( 3.5) (13.8) 2292.92 3434.87 29657.55 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 104920.07 0,00 0,00 (55.3) 56350.94 60714.12 0.00 (29.7) (40.5) 28644.71 89212.12 61722.77 ( 15.1) ( 59.5) (100.0) 189915.72 149926.24 61722.77 TOTAL 52819.69 (' 2.0) 204481,40 7.7) 307291.43 11.5) 188821.51 7.1) 245695.23 9.2) 173565.05 6.5) 258536.76 9.7) 205949.79 7.7) 322832.76 12.1> 294364.58 11.0) 188623,68 7.1) 223318.08 8.4) 2666299.96 TOWN OF SOUTHOLD PROCEDURE FREQUENCY REPORT EMPLOYEE HEALTH BENEFIT PLANS ISLAND GROUP PROCESS DATES: 3/ 1/11 - 3/31/11 Client Totals PAGE 1 DATE 4/11/11 PROC CATEGORY DESCRIPTION NUM SVCS TOT.BILLED AVE.BILLED TOT.PAID AVE.PAID 6020 SURQERY AMBULATORY OUT PATIENT SURGERY 1 21760,08 21760.08 226.12 226.12 6030 SURGERY SURGERY 5 1815.75 363.15 477.22 95.44 6060 OFFICE VISIT PHYSICIAN OFFICE VISIT 16 2028.89 126.81 177.36 11.09 6061 OFFICE VISIT CONSULTATION 2 444.00 222.00 0.00 0.00 6070 DOCTOR SERVI PHYSICIAN IN-HOSPITAL VISIT/S 17 3162.46 186.03 193.91 11.41 7001 EMERGENCY RO PHYS TREATMENT MED EMERG 2 586.00 293.00 209.08 104.54 7040 XRAY X-RAY OUT-PATIENT 2 11885.36 5942.68 368.45 184.23 7054 DIAGNOSTIC MEDICAL TESTING 13 6924.00 532.62 326.07 25.08 7055 XRAY XRAY INTERP 9 926.76 102.97 596.11 66.23 7060 LABORATORY G LABORATORY OUT-PATIENT 3 925.56 308.52 700.56 233.52 7062 LABORATORY S LAB 80% 19 1277.70 67.25 14.64 0.77 7151 OTHER DURABLE MED EQUIP 2 315.00 157.50 0.00 0.00 7221 THERAPY PHYSIOTHERAPY 6 620.00 103.33 171.00 28.50 7249 OTHER AMBULANCE 2 297.05 148.53 165.80 82.90 9000 OFFICE VISIT PP OFFICE VISIT 139 23078.25 166.03 9908.00 71.28 9001 EMERGENCY RO PP ER VISIT 6 2730.00 455.00 755.00 125.83 9002 AUDIT/CONSUL PP COB 239 92061.64 385.20 7675.73 32.12 9004 AUDIT/CONSUL PP DIABETIC SUPPLIES 3 322.93 107.64 164.19 54.73 9005 PREVENTATIVE IMMUNIZATIONS 7 828.00 118.29 329.00 47.00 9006 PREVENTATIVE PP INJECTIONS 13 791.00 60.85 84.42 6.49 9007 MENTAL OR NE PP M/N 31 4170.00 134.52 2336.00 75.35 9009 OFFICE VISIT PP WELL CARE 14 4200.00 300.00 1479.00 105.64 9010 DOCTOR SERVI PP HOSPITAL VISIT 4 770.00 192.50 650.00 162.50 9011 HOSPITAL RO0 PP HOSPITAL ROOM AND BOARD 3 58648.68 19549.56 33677.64 11225.88 9012 SURGERY PP AMBULATORY OUT PATIENT SURGERY 4 14440.53 3610.13 11264.92 2816.23 9013 EMERGENCY RO PP EMERGENCY TREATMENT MEDICAL EMERGENCY 10 25990.43 2599.04 15968.39 1596.84 9014 MEDICAL SUPP PP DURABLE MED EQUIP 13 1984.70 152.67 1856.12 142.78 9015~XRAY PP X-RAY OUT PATIENT 9 , 31313.20 3479.24 24664.56 2740.51 9019 LABORATORY S PP LABORATORY OUT PATIENT 19 7193.33 378.60 4074.10 214.43 9020 SURGERY PP SURGERY 24 33577.00 1399.04 14781.00 615.88 9025 DIAGNOSTIC P P TESTING 24 4177.00 174.04 2085.00 86.88 9026 OFFICE VISIT PP ALLERGY 12 799.00 66.58 481.00 40.08 9040 OTHER PP CHIROPRACTIC 29 1680.00 57.93 480.00 16.55 9042 THERAPY PP THERAPY 4 480.00 120.00 160.00 40.00 9045 THERAPY PP PBYSICAL THERAPY 36 5270.90 146.41 1440.00 40.00 9050 AUDIT/CONSUL PP CONSULTATION 13 3915.85 301.22 2330.00 179.23 9055 PRESCRIPTION RX PHARMACARE 3 56513.92 18837.97 56363.92 18787.97 9070 DIAGNOSTIC PP MAMMOGRAPHY 6 1375.00 229.17 575.00 95.83 9080 XRAY PP RADIOLOGY 21 3410.00 162.38 1625.00 77.38 9081 XRAY PP XRAY INTERP 31 3992.00 128.77 981.00 31.65 9085 DIAGNOSTIC PP EKG 12 1192.35 99.36 420.00 35.00 9090 ANESTHESIA PP ANESTHESIA 2 3750.00 1875.00 1250.00 625.00 9095 LABORATORY S PP LAB 211 17070.69 80.90 6662.76 31.58 9099 MISCELLANEOU PP MISCELLANEOUS 8 5936.00 742.00 928.40 116.05 9105 MISCELLANEOU PSI HOSP DISCOUNT FEE 11 2026.97 184.27 2026.97 184.27 9108 AUDIT/CONSUL NYS SURCHARGE 1 5876.00 5876.00 5876.00 5876.00 9109 MISCELLANEOU NYS GME~S 1 1988.00 1988.00 1988.00 1988.00 9201 THERAPY PP ACUPUNCTURE 9 1342.00 149.11 1017.00 113.00 9204 THERAPY PP EPIDURALS 2 2500.00 1250.00 710.00 355.00 9207 THERAPY PP MRI 1 2500.00 2500.00 1280.00 1280.00 TOWN OF SOUTHOLD PROCEDURE FREQUENCY REPORT EMPLOYEE HEALTH BENEFIT PLANS ISLAND GROUP PROCESS DATES: 3/ 1/11 - 3/31/11 Client Totals PAGE 2 DATE 4/11/11 PROC CATEGORY DESCRIPTION NUM SVCS TOT.BILLED AVE.BILLED TOT.PAID AVE.PAID 9209 XRAY PP CT SCAN 4 5500,00 1375.00 1470.00 367.50 CLIENT TOTALS 1078 486363.98 451.17 223444.44 207.28