FO_ICD9
This table is used to list all valid ICD9 codes and descriptions available to the User for searching and choosing at the time an order is created. Each record represents a single ICD9 or ICD 10 code.
| Field | Type | Notes |
|---|---|---|
|
ICD_ID |
decimal(18, 0) |
ID field, a counter. Unique |
|
Code |
varchar(255) |
ICD code. Enter a unique code. |
|
Description |
varchar(255) |
Description of ICD code for searches. Enter a description. |
|
Validity |
varchar(50) |
Informational |
|
Type |
varchar(50) |
Informational |
|
Status |
varchar(50) |
Informational |
|
ShortDescription |
varchar(255) |
Informational |
|
LongDescription |
varchar(255) |
Informational |
|
FullDescription |
varchar(255) |
Informational |
|
LastUpdate |
datetime |
System timestamp when record was last updated. Informational |
|
UpdateByUser |
varchar(50) |
User who last edited the record. Informational |
|
Active |
varchar(50) |
Informational |
|
DiagCodingMethod |
varchar(50) |
Diagnosis Methodology Enter 9 or 10 (what do 9 and 10 mean?) |
for all yellow items above it would be helpful to have more information to give the reader and some hints about what they should enter into the record, especially validity, type, status and active.
There are four kinds of description fields, how are they different, where are they used?