| id | title | date | version | lastAuthor | mimeType | links | source | wikigdrive |
|---|---|---|---|---|---|---|---|---|
1N6H4YEgK5O5BzM2oWsVL-k6RTG8KUlGVUaqjP1sC5r0 |
Fee Schedule Import Tool |
2024-12-18T13:55:56.892Z |
32 |
bhamm |
text/x-markdown |
0008bcbb1563384efe0a28ada6f97e9432e65f10 |
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.
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 |
| CPT Code | char 15 | R | CPT code to load |
| Description | char 255 | R | Description of the CPT Code |
| Amount | double(9,2) | R | Dollar amount for CPT Code (max 9 digits before decimal, 2 digits after, ie 123456789.00) |
This example shows how to import multiple CPT codes into 1 fee schedule labeled 'DEF Biz'.
{{% pre %}}
Fee Schedule Name,CPT 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
{{% /pre %}}