This wiki page is to document how fee schedule data needs to be constructed in order to import using WebChart’s Fee Schedule Import Tool.
- File format: Data file shall be formatted in Comma Separated Values (CSV).
- The first row of the file shall contain column header information.
- Each subsequent row shall represent a fee schedule.
Column Definition
The fee schedule column definition shall contain all columns listed below regardless if there is a value or not.
- R = Required
- O = Optional
| Name | Type | Required | Comments |
| Fee Schedule Name | char 100 | R | Name of fee schedule |
| Billing Code | char 15 | R | Billing code to load |
| Description | char 255 | R | Description of the Billing Code |
| Amount | double(9,2) | R | Dollar amount for Billing Code (max 9 digits before decimal, 2 digits after, ie 123456789.00) |
Examples of CSV
Fee Schedule Example
This example shows how to import multiple Billing codes into 1 fee schedule labeled ‘DEF Biz’.
Fee Schedule Name,Billing Code,Description,Amount
DEF Biz,13153,REPAIR WOUND/LESION ADD-ON,$291.00
DEF Biz,15050,SKIN PINCH GRAFT,$751.00
DEF Biz,16000,INITIAL TREATMENT OF BURN(S),$120.00
DEF Biz,16020,TREATMENT OF BURN(S),$143.00
DEF Biz,16025,TREATMENT OF BURN(S),$245.00
DEF Biz,16030,TREATMENT OF BURN(S),$289.00
DEF Biz,17003,"DESTROY LESIONS, 2-14",$22.00
DEF Biz,17110,"DESTRUCT LESION, 1-14",$157.00
DEF Biz,17250,"CHEMICAL CAUTERY, TISSUE",$119.00
DEF Biz,20000,INCISION OF ABSCESS,$325.00
DEF Biz,20005,INCISION OF DEEP ABSCESS,$469.00