Search TipsEntering Codes into a Lookup Table
There are two ways to enter codes into a lookup table.
- Add
- Import
Adding Codes
You may enter codes into a lookup table by typing each code. To enter a few codes to a lookup table, it is easier to add codes one at a time.
Importing Codes
To enter a large number codes to a lookup table, it is easier to import the data from another table, CSV file or text file. Use the following key when entering values in the CODETYPE column:
|
Code Type |
Value |
|
REV |
1 |
|
CDM |
2 |
|
DRG |
3 |
|
*CPT4 |
4 |
|
*HCPC |
5 |
|
HIEC |
6 |
|
NDC |
7 |
|
HCPCPS |
8 |
|
*ICD9 |
9 |
|
**OTHER |
0 |
|
*ICD10 |
11 |
* Can be used together in a lookup table.
** Compatible with all code types. Code ranges are not compatible with a code type of ICD-10 or OTHER.