Loading...
HomeMy WebLinkAbout11/2010MONTH OF PAYMENT DEC 09 JAN 10 FED 10 MAR 10 APR 10 MAY 10 JUN 10 JUL 10 AUG 10 GEP 10 OCT 10 NOV 10 **** TOWN OF SOUTHOLD **** EMPLOYEE HEALTH CARE PLAN ISLAND GROUP 12/ 2/10 CLAIM LAG REPORT - AMOUNT BILLED PLAN YEAR 12/ 1/09 - 11/30/10 CLAIMS ALt Units ................................................................... MONTH OF SERVICE ....................... Z ........................................... DEC 09 JAN 10 FEB 10 MAR 10 APR 10 MAY 10 JUN 10 JUL 10 AUG 10 BEP 10 OCT 10 NOV 10 TOTAL 52997.66 9.9) 182757.55 34.1) 131760.91 24.6) 102221.53 19.1) 28870.36 5.4) 3526.58 0.7) 1046.00 0.2) 2801.09 0.5) 28880.09 5,4) 1671.99 0.3) 0.00 0,00 0.00 0.00 28422.18 0.00 3.9) 205295.93 25035.32 28.1) 6.1) 388689.75 261381.52 53.2) 63.6) 22016.22 45387.84 3.0) 11.0) 8879.05 21396,16 1.2) 8,2) 4816.15 24259.92 0.7) 5.9) 39797.49 5791.84 5.5) 1.4) 29603.78 22587.20 4.0) 5.5) 2188.22 1381.24 0.3) 0.3) 611.80 3537.28 0.1) 0.9) 0.00 446.05 0.00 0.00 0.00 99307.41 20.3) 156517.58 32.0) 145929.90 29.8) 11390.34 2.3) 6899.67 1.4) 35940.58 7,3) 2947.37 0.6) 6602.29 1.4) 23575.22 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 78945.12 0.00 11.5) 250537.02 143126.26 36,6) 24.4) 289392.40 256095.88 42.3) 43.6) 14580.28 75825,10 2.1) 12.9) 27720.03 60045.81 4.0) 10.2) 11082.10 12081.17 1.6) 2.1) 7160.43 7289.30 1.1) 1.2) 5316.26 32195.38 0,1) 4.8) 0.8) 5.5) 1.8) ( 17.1) ( 2.7) ( 38.0) ( 71.5) (100.0) TOTAL 536533.76 730290.57 411004.37 489110.36 684733.64 586658.90 494899,51 627674.26 722823.46 485899.23 223708.64 94280.18 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 0.00 87033.45 0.00 0.00 0.00 0.00 0.00 17.6) 185669.85 70473.50 0.00 0.00 0.00 0.00 57.5) (11.2) 154960.57 311211.08 102562.25 0.00 0,00 0.00 31,3) (49.6) (14.2) 35226.47 42175.15 236905.95 57993,86 0.00 0.00 7.1) ( 6.7) ( 32,8) ( 11.9) 23332.89 96367.39 363919.65 243359.80 63672,35 0.00 4.7) ( 15.3) ( 50.4) ( 50.1) ( 28.5) 8676.28 107447.14 19435.63 184545.57 160036.29 94280.18 52997.66 ( 0.9) 211179.73 3.5) 362092.16 6.0) 851570.21 14.0) 331737.12 5.5) 573394.97 9.4) 674034.14 11.1) 401838.82 6.6) 773511.37 12.7) 403653.52 6.6) 815853.18 13.4) 635954.00 10.4) 6087616.88 **** TOWN OF SOUTHOLD **** EMPLOYEE HEALTH CARE PLAN ISLAND GROUP 12/ 2/10 CLAIM LAG REPORT ~ AMOUNT PAID PLAN YEAR 12/ 1/09 - 11/30/10 CLAIMS All Units MONTR OF PAYMENT DEC 09 JAN 10 FES 10 MAR 10 APR 10 MAY 10 JUN 10 JUL 10 AUG 10 SEP 10 OCT 10 NOV 10 DEC 09 - 26918,34 0.00 0.00 0.00 0.00 0.00 0,00 0.00 0.00 0°00 0.00 0.00 11.2) JAN 10 128230.82 12765.35 0,00 0.00 0.00 0.00 0.00 0.00 0,00 O.OO 0.00 0.00 53.4) 5.0) FEB 10 67639,57 122682.19 14384.96 0.00 0,00 0.00 0.00 0.00 0,00 0.00 0.00 0.00 28.2) 48.3) 8.7) MAR 10 13257.27 104061.78 135034.24 64160.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 5.5) 41.0) 82.0) 28.6) APR 10 2687.81 6475.95 5755.23 85373.42 52819.69 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1.1) 2.5) 3.5) 38.1) 17.8) MAY 10 417.00 2025.90 5467.47 61781.23 104367.10 101119.30 0.00 0.00 0.00 0,00 0.00 0.00 0.2) 0.8) 3.3) 27.6) 35.1) 37.4) JUN 10 56.69 582.55 1984.57 3416.7-/ 114894.10 132311.68 60085.65 0.00 0.00 0.00 0.00 0.00 0,0) 0.2) 1.2) 1.5) 38.6) 48.9) 23.4) JUL 10 449.45 4724.58 965.16 1235.08 6533.43 21015.84 112054.70 49217,54 0.00 0.00 0.00 0.00 0.2) 1.9) 0.6) 0.6) 2.2) 7.8) 43.6) ( 30.1) AUG 10 281.40 441.31 187,00 1862.81 11518.81 7471.68 68768.37 95387.45 62874.52 0.00 0.00 0.00 0.1) 0.2) 0.1) 0.8) 3,9) 2,8) 26,8) (58,3) (23.8) SEP 10 46.76 180.99 107,51 430.99 425.98 1223.54 5163.03 9036.22 116497.52 41218.76 0.00 0.00 0.0) 0.1) 0,1) 0.2) 0.1) 0.5) 2.0) ( 5.5) (44.1) (23,3) OCT 10 0.00 179.32 720.34 1419.19 3863.47 1204.21 7385.79 5861.70 81784.06 108013.67 50449.42 0.00 0.1) 0.4) 0.6) 1.3) 0.5) 2.9) (3.6) (31.0) (61.0) (36.5) NOV 10 0.00 0.00 61.49 4414,19 3069,28 6188,64 3474.50 4133.16 2694.68 27867.66 87567.99 71041.88 0.0) 2.0) 1,0) 2.3) 1.4) ( 2.5) ( 1.0) (15.7) (63.5) (100.0) TOTAL 239985.11 254119.92 164667.97 224093.68 297491.86 270534.89 256932.04 163636.07 263850.78 177100.09 138017.41 71041.88 ................................................................... MONTH OF SERVICE ................................................................... TOTAL 26918.34 1.1) 140996,17 5.6) 204706.72 8.1) 316513.29 12.6) 153112.10 6.1) 275178.00 10.9) 313332.01 12.4) 196195.78 7.8) 248793.35 9.9) 174331.30 6.9) 260881.17 10.3) 210513.47 8.3) 2521471.70 TONN OF SOUTHOLD PROCEDURE FREQUENCY REPORT EMPLOYEE HEALTH BENEFIT PLANS ISLAND GROUP PROCESS DATES: 11/ 1/10 - 11/30/10 Client Totals PAGE 1 DATE 12/ 2/10 PROC CATEGORY DESCRIPTION NUM SVCG TOT.DILLED AVE.BILLED TOT.PAID AVE.PAID 6001 HOSPITAL HO0 6030 SURGERY 6050 ANESTHESIA 6060 OFFICE VISIT 6061 OFFICE VISIT 6070 DOCTOR SERVI 69~9 EMERGENCY RO 7001 EMERGENCY RO 7040 XRAY 7051XRAY 7054 DIAGNOSTIC 7055 XRAY HOSPITAL RO0~ AND BOARD 1 SURGERY 12 ANESTHESIA 1 PHYSICIAN OFFICE VISIT 18 CONSULTATION I PHYSICIAN IN-HOSPITAL VISIT/S 2 EMERGENCY TREATMENT MEDICAL EMERGENCY 3 PHYS TREATMENT MED EMERG 2 X-RAY OUT-PATIENT 4 RADIOLOGY/PATHOLOGY MEDICAL TESTING XRAY INTERP 18195.11 18195.11 2885.13 2885.13 28610.00 2384.17 999.42 83.29 -1540.00 -1540.00 -325.60 -325.60 2365.00 131.39 775.52 43.08 275.00 275.00 25.00 25.00 585.00 292.50 82.96 41.48 3325.01 1108.34 749.40 249.80 597.00 298.50 165.41 82.71 13266.35 3516.59 894.32 223.58 1 125.00 125.00 0.00 0.00 3 512.00 170.67 17.42 5.81 10 845.60 84.56 96.70 9.67 7060 LABORATORY S LABORATORY OUT-PATIENT 2 2360.25 1180,13 2259.62 1129.81 7062 LABORATORY S LAB 80% 16 4132.67 258.29 342.97 21.44 7145 MEDICAL SUPP IMMUNIZATION 1 25.00 25.00 0.00 0.00 7151 OTHER DURABLE MED EQUIP 4 630.00 157.50 77.89 ' 19.47 9000 OFFICE VISIT PP OFFICE VISIT 158 26624.80 168.51 12451.00 78.80 9001 EMERGENCY RO PP ER VISIT 10 6114.00 611.40 2040.00 204,00 9002 AUDIT/CONSUL PP COB 378 282483.11 747.31 1029B.24 27.24 9004 AUDIT/CONSUL PP DIABETIC SUPPLIES 4 810.92 202.73 663.04 165.76 9005 PREVENTATIVE IMMUNIZATIONS 30 1596.37 53.21 669.37 22.31 9006 PREVENTATIVE PP INJECTIONS 56 2504.52 44.72 673.58 12.03 9007 MENTAL OR NE PP M/N 38 5635.00 148.29 3493.00 91.92 9009 OFFICE VISIT PP WELL CARE 27 6619.00 245.15 1735.00 64.26 9010 DOCTOR SERVI PP HOSPITAL VISIT 8 2461.00 307.63 980.00 122.50 9011 HOSPITAL RO0 PP NOSPITAL ROOM AND BOARD 1 14185.46 14185.46 9726.87 9726.87 9012 SURGERY PP AMBULATORY OUT PATIENT SURGERY 1 3615.75 3615.75 2857.60 2857.60 9013 EMERGENCY RO PP EMERGENCY TREATMENT MEDICAL EMERGENCY 6 13131.60 2188.60 7745.42 1290.90 9014 MEDICAL SUPP PP DURABLE MED EQUIP 3 386.33 128,78 311.01 103.67 9015 XRAY PP X-RAY OUT PATIENT 12 11926.05 993.84 9120.84 760,07 9019 LABORATORY S PP LABORATORY OUT PATIENT 17 10814.51 636.15 8056.61 473.92 9020 SURGERY PP SURGERY 32 33611,00 1050.34 17421.00 544.41 9021 SURGERY PP ASST SURGEON 1 5000.00 5000.00 740.00 740.00 9025 DIAGNOSTIC P P TESTING 41 9308.00 227.02 3954.00 96.44 9026 OFFICE VISIT PP ALLERGY 14 887.00 63.36 563.00 40.21 9027 MISCELLANEOU PP ORTHOTICS/PROSTNETICS 1 500.00 500.00 325.00 325.00 9040 OTHER PP CHIROPRACTIC 28 1698.00 60.64 475.00 16.96 9045 THERAPY PP PHYSICAL THERAPY 31 3874.33 124.98 1390.00 44.84 9050 AUDIT/CONSUL PP CONSULTATION 22 6340.12 288.19 3685.00 167.50 9055 PRESCRIPTION RX PHARMACARE 2 68522.62 34261.31 68522.62 34261.31 9070 DIAGNOSTIC pP MAMMOQRAPNY 14 2885.00 206.07 1197.00 85.50 9080 XRAY PP RADIOLOGY 16 3001.00 187.56 1501.00 93.81 9081 XRAY PP XRAY INTERP 25 3181.00 127.24 830.00 33.20 9085 DIAGNOSTIC PP EKG 12 895.00 74.58 400.00 33.33 9090 ANESTHESIA PP ANESTHESIA 4 9880.00 2470.00 2938.00 734.50 9095 LABORATORY S PP LAB 235 20740,25 88.26 7449.70 31.70 9099 MISCELLANEOU PP MISCELLANEOUS 6 473.29 78.88 178.39 29.73 9105 MISCELLANEOU PSI HOSP DISCOUNT FEE 1 205.28 205.28 205.28 205.28 9108 AUDIT/CONSUL NYS SURCHARGE 1 9151.00 9151.00 9151.00 9151.00 9109 MISCELLANEOU NYS GME'S 1 2026.00 2026.00 2026.00 2026.00 TONN OF SOUTHOLD PROCEDURE FREQUENCY REPORT EMPLOYEE HEALTH RENEFIT PLANS ISLAND GROUP PROCESS DATES: 11/ 1/10 - 11/30/10 Client Totals PAGE 2 DATE 12/ 2/10 PROC CATEGORY DESCRIPTION 9135 MISCELLANEOU PP IVF OFFICE VISIT 2 NUM SVCS TOT.BILLED AVE.BILLED TOT.PAID AVE.PAID 9180 MISCELLANEOU PP IVF RADIOLOGY 2 9195 MISCELLANEOU PP IVF LAB 8 9201 THERAPY PP ACUPUNCTURE 6 9203 THERAPY PP HEARING AIDS 1 9204 THERAPY PP EPIDURALS 1 9205 THERAPY PP NERVE CONDUCTION 2 9206 THERAPY PP EMG 1 9207 THERAPY PP MRI 1 9209 XRAY PP CT SCAN 3 9211 DENTAL NERVE BLOCK 22 CLIENT TOTALS 1366 200.00 100.00 85.00 42.50 450.00 225.00 200.00 100.00 449.00 56.13 219.00 27.38 808.00 154.67 565.00 94.17 3300.00 3300.00 2925.00 2925.00 1250.00 1250.00 355.00 355.00 1000.00 500.00 720.00 360.00 200.00 200.00 175.00 175.00 1200.00 1200.00 625.00 625.00 2175.00 725.00 352.00 117.33 4100.00 186.36 1400.00 63.64 660528.30 483.55 210437.73 154.05