Loading...
HomeMy WebLinkAbout10/2010 EHPLOYEE HEALTH CARE PLAN ISLAND GROUP CLAIM LAG REPORT - AMOUNT BILLED PLAN YEAR 11/ 1/09 - 10/31/10 CLAIMS All Units MONTH OF PAYMENT NOV 09 DEC 09 JAN 10 FEB 10 MAR 10 APE 10 MAY 10 JUN 10 JUL 10 AUG 10 SEP 10 OCT 10 ................................................................... MONTH OF SERVICE ................................................................... NOV 09 DEC 09 JAN 10 FEB 10 MAR 10 APR 10 MAY 10 JUN 10 JUL 10 AUG 10 SEP 10 OCT 10 TOTAL 106180.69 17.0) 220801.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) 4805.62 0.8) 5914.10 1.0) 68.07 0.0) O.OO 0,00 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 28422.18 3.9) 205295.93 28.1) 588659.75 53.2) 22016.22 3.0) 8879,05 1.2) 4816.15 0.7) 39797.49 5.5) 29603.78 4.0) 2188.22 0.3) 611.80 0.00 0.00 0.00 25035.32 6.1) 261381.52 63.7) 45387.84 11.1) 21396.16 5.2) 24259.92 5.9) 5791.84 1.4) 22387.20 5.5) 1581.24 0.3) 3537.28 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 99307.41 0.00 0.00 21.3) 156517.58 78945.12 0.00 33.6) 11.6) 145929.90 250537.02 143126.26 31.4) 36.9) 25.8) 11390.34 289392.40 256095.88 2.5) 42.6) 46.2) 6899.67 14580.28 75825.10 1.5) 2.1) 13.7) 35940.58 27720.03 60045.81 7.7) 4.1) 10.8) 2947.37 11082.10 12081.17 0.6) 1.6) 2.2) 6602,29 7160.43 7289.30 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 (17.9) 185669.85 70473,50 0.00 (38.2) (13.6) 154960.57 311211.08 102562.23 (31.9) (59.8) (14.6) 35226.47 42175.15 236905.95 ( 7.2) ( 8.1) (33.7) 23332.89 96367.39 363919.65 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 57993.86 0.00 (19.2) 243359.80 63672.55 0.1) 0.9) 1.4) 1.1) 1.3) ( 4.8) ( 18.5) ( 51.7) ( 80.8) (100.0) TOTAL 625907.68 536533.76 730290,57 410558.32 465535.14 679417.38 554463.52 486223.23 520227.12 703387.83 301353,66 63672.35 106180.69 1.8) 273799.10 4.5) 409366.32 6.7) 435355.84 7,2) 860164,46 14.2) 335125.64 5.5) 575708.69 9.5) 674425.14 11.1) 406644.44 6.7) 779225.47 12.8) 403721.59 6.6) 815853,18 13.4) 6075570.56 MONTH OF PAYMENT NOV 09 DEC 09 JAN 10 FEB 10 MAR 10 APRIO MAY 10 JUN 10 JUl 10 AUG 10 SEP 10 OCT 10 TOTAL **** TOWN OF SOUTHOLD **** EMPLOYEE HEALTH CARE PLAN ISLAND GROUP 11/ 9/10 CLAIM LAG REPORT - AMOUNT PAID PLAN YEAR 11/ 1/09 - 10/31/10 CLAIMS All Units ................................................................... MONTH OF SERVICE ................................................................... NOV 09 DEC 09 JAN 10 FEB 10 MAR 10 APR 10 MAY 10 JUN 10 JUL 10 AUG 10 SEP 10 OCT 10 TOTAL 70603.29 0.00 0.00 37.7) 80927.55 26918.34 0.00 43.2) 11.2) 15875.05 128230.82 12765.35 8.5) 53.4) ( 5.0) 14798.66 67639.57 122682.19 7.9) 28.2) (48.3) 3675.36 13257.27 104061.78 2.0) 5.5) (41.0) 418.37 2687.81 6475.95 0.2) 1.1) 2.5) 871.98 417.00 2025.90 0.5) 0.2) 0.8) 0.00 56,69 582.55 0.0) 0.2) 203.22 449,45 4724.58 ( 0.1) 0,2) 1.9) 126.74 281.40 441.31 ( 0.1) 0.1) 0.2) 0.00 46.76 180.99 0.0) 0.1) 0.00 0.00 179.32 0.1) 187498.22 239985.11 254119.92 0.00 0.00 0.00 14384.96 8.7) 135034.24 82.0) 5755.23 3.5) 5467.47 3.3) 1984,57 1.2) 965,16 0.6) 187.00 0.1) 107.51 0.1) 720.34 0.4) 164606.48 0.00 0.00 0.00 0.00 64160.00 29.2) 85373.42 38.9) 61781.23 28.1) 3416.77 1.6) 1235.08 0.6) 1862.81 0.9) 430.99 0.2) 1419.19 0.7) 219679.49 0.00 0.00 0.00 0.00 0.00 52819.69 17.9) 104367.10 35.5) 114894.10 39.0) 6533.43 2.2) 11518.81 3.9) 425.98 0.1) 3863.47 1.3) 294422.58 0,00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 101119.30 0.00 38.3) 132311.68 60085.65 50.0) (23.7) 21015.84 112054.70 8.0) (44.2) 7471,68 68768.37 2.8) (27.1) 1223.54 5163.03 0.5) (2.0) 1204.21 7385.79 0.5) ( 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 0.00 0.00 0.00 0.00 0,00 0,00 0,00 0.00 49217.54 0.00 0.00 OLO0 (30.9) 95307.45 62874.52 0,00 0.00 (59.8) (24.1) 9036.22 116497.52 41218.76 0.00 ( 5.7) (44.6) (27.6) 5861.70 81784.06 108013.67 50449.42 ( 3.7) (31.3) (72.4) (100.0) 264346.25 253457.54 159502.91 261156.10 149232.43 50449.42 70603.29 2.8) 107845.89 4.3) 156871.22 6,3) 219505.38 8.8) 320186.65 12.8) 153530,47 6.2) 276049.98 11,1) 313332,01 12.5) 196399.00 7.9) 248920.09 10.0) 174331.30 7.0) 260881.17 10.4) 2498456.45 TOWN OF SOUTHOLD PROCEDURE FREQUENCY REPORT EMPLOYEE HEALTH BENEFIT PLANS ISLAND GROUP PROCESS DATES: 10/ 1/10 - 10/31/10 Client Totals PAGE 1 DATE 11/ 9/10 PROC CATEGORY DESCRIPTION NUM SVCS TOT.BILLED AVE.BILLED TOT.PAID AVE.PAID 1MISCELLAREOU 6001 HOSPITAL RD0 6030 SURGERY 6050 AHESTHESIA 6060 OFFICE VISIT 6061 OFFICE VISIT 6999 EMERGENCY RO 7001EMERQENCY RO 7040 XRAY 7051XRAY 7054 DIAGNOSTIC ADMINISTRATIV~ FEES HOSPITAL ROOM AND BOARD SURGERY ANESTHESIA PHYSICIAN OFFICE VISIT CONSULTATION EMERGENCY TRF~ATMENT MEDICAL EMERGENCY PNYS TREATMENT MED EMERG X-RAY OUT-PAT IENT RADIOLOGY/PATHOLOGY MEDICAL TESTING 1300.00 1300.00 1300.00 1300.00 5184.81 5184.81 870.10 870.10 6125.00 680.56 58.97 6.55 2500.00 2500.00 800.00 800.00 5232.60 654.08 173.80 21.~ 600.00 600.00 480.00 480.00 4059.45 2029.73 2324.50 1162.25 285.00 285.00 12.34 12.34 12851.74 3212.94 598.89 149.72 2518.00 1259.00 119.77 59.89 461.00 153.67 27.11 9.04 7055 XRAY XRAY INTERP 3 588.00 196.00 69.90 23.30 7060 LABORATORY S LABORATORY OUT-PATIENT I 142.00 142.00 67.00 67.00 7062 LABORATORY S LAB 80% 18 2528.38 140.47 403.99 22.44 7151 OTHER DURABLE MED EQUIP 6 6B9.48 114.91 115.28 19.21 7249 OTHER AMBULANCE 2 2883.20 1441.60 349.67 174.84 9000 OFFICE VISIT PP OFFICE VISIT 167 27517.56 164.78 11802.00 70.67 9001 EMERGENCY RO PP ER VISJT 15 8208,00 547.20 2700.00 180.00 9002 AUDIT/CONSUL PP COB 368 305463.00 830.06 11254.04 30.58 9004 AUDIT/CONSUL PP DIABETIC SUPPLIES 9 1022.62 113.62 795.14 88.35 9005 PREVENTATIVE IMMUNIZATIONS 39 1822.99 46.74 989.00 25.36 9006 PREVENTATIVE PP INJECTIONS 90 7465.94 82.95 2204.34 24.49 9007 MENTAL OR NE PP M/N 60 9415.00 156.92 5000.75 83.35 9009 OFFICE VISIT PP WELL CARE 19 5243.00 275.95 1748.00 92.00 9010 DOCTOR SERVI PP HOSPITAL VISIT 5 935.00 187.00 696.00 139.20 9011 HOSPITAL RO0 PP NOSPITAL ROOM AND BOARD 3 8B668.54 29556.18 34627.94 11542.65 9012 SURGERY PP P~4BULATORY OUT PATIENT SURGERY 3 28660.19 9553.40 22823.15 7607.72 9013 EMERGENCY RO PP EMERGENCY TREATMENT MEDICAL EMERGENCY 11 37922.32 3447.48 28184.95 2562.27 9014 MEDICAL SUPP PP DURABLE MED EQUIP 7 813.53 116.22 665.28 95.04 9015 XRAY PP X-RAY OUT PATIENT 10 7298.40 729.84 5488.72 548.87 9019 LABORATORY S PP LABORATORY OUT PATIENT 20 9064.95 453.25 6542.60 327.13 9020 SURGERY PP SURGERY 29 63705.43 2196.74 12091.00 416.93 9021 SURGERY PP ASST SURGEON 3 7200.00 2400.00 984.00 328.00 9025 DIAGNOSTIC P P TESTING 42 9068.48 215.92 3772.00 89.81 9026 OFFICE VISIT PP ALLERGY 19 2085.50 109.76 1654.00 87.05 9040 OTRER PP CHIROPRACTIC 11 548.50 49.86 165.00 15.00 9045 TNERAPY PP PHYSICAL THERAPY 45 19644.72 436.55 1040.00 23.11 9050 AUDIT/CONSUL PP CONSULTATION 11 4087.00 371.55 1915.00 174.09 9055 PRESCRIPTION RX PHARMACARE 2 68775.40 34387.70 68775.40 34387.70 9070 DIAGNOSTIC PP MAMMOGRAPHy 6 1350.00 225.00 545.00 90.83 9080 XRAY PP RADIOLOGY 18 3595.00 199.72 1065.52 59.20 9081 XRAY PP XRAY INTERP 34 4528.00 133.18 1155.20 33.98 9085 DIAGNOSTIC PP EKG 9 725.00 80.56 270.00 30.00 9090 ANESTHESIA PP ANESTRESIA 7 9840.00 1405.71 5990.00 855.71 9095 LABORATORY S PP LAB 183 16080.84 87.87 4984.04 27.24 9099 MISCELLANEOU PP MISCELLANEOUS 5 3310.00 ~2.00 3000.00 600.00 9105 MISCELLANEOU PSI HOSP DISCOUNT FEE 4 1681.61 420.40 1681.61 420.40 9108 AUDIT/CONSUL NYS SURCHARQE I 2380.00 2580.00 2380.00 2380.00 9109 MISCELLAREOU NYS GME'S 1 2031.00 2031.00 2031.00 2031,00 9135 MISCELLANEOU PP IVF OFFICE VISIT 2 200.00 100.00 85.00 42.50 TONN OF SOUTHOLD PROCEDURE FREQUENCY REPORT EMPLOYEE HEALTH BENEFIT PLANS ISLAND GROUP PROCESS DATES: 10/ 1/10 - 10/31/10 Client Totals PAGE DATE 11/ 9/10 PROC CATEGORY DESCRIPTION 9180 MISCELLANEOU PP IVF RADIOLOGY 9195 MISCELLANEOU PP IVF LAB 9201 THERAPY PP ACUPUNCTURE 9207 THERAPY PP MRI 9209 XRAY PP CT SCAN CLIENT TOTALS NUM SVCS 2 8 1 2 5 1339 TOT.BILLED 450.00 464.00 133.00 2400.00 3625.00 815378.18 AVE.HILLED 225.00 58.00 133.00 1200.00 725.00 608.95 TOT.PAID AVE.PAID 200.00 100.00 209.00 26.13 113.00 113.00 1250.00 625.00 2159.00 431.80 260808.00 194.78