 |
Page History
| Wiki Markup |
|---|
{scrollbar:icons=false} |
| Page info | ||||
|---|---|---|---|---|
|
| Panel | ||||
|---|---|---|---|---|
| ||||
|
Source Data, General Comments
The ICD-9 data is provided in two text files. One is diagnosis codes (also referred to as Volume 1 and Volume 2) the other is procedure codes (referred to as Volume 3). Each file is formatted as a two column flat file. Column one is the ICD-9 code. Column two is a definition. The columns are separated by white space. Both files are loaded as a single LexGrid coding scheme. Decision for this was based on the behavior of the UMLS load of ICD-9 UMLS data where diagnosis and procedures codes are loaded into a single coding scheme.
Source Data, Source
The ICD-9 data for this loader came from Centers for Medicare & Medicaid Services (CMS, http://www.cms.gov/). http://www.cms.hhs.gov/ICD9ProviderDiagnosticCodes/Downloads/v26_icd9.zip
...
- 0010 CHOLERA D/T VIB CHOLERAE
- 0011 CHOLERA D/T VIB EL TOR
- 0019 CHOLERA NOS
Source Data, Code Format
The ICD concpet code in the source data files does not contain a decimal point. The loader will add a decimal point to the concpet codes following these rules:
For diagnosis codes, the number part of the code will always be 3 digits with zero or one or two decimal digits. For procedure codes the numeric part of the code will be 2 digits with zero, one or two digits following the decimal point. Using the example diagnosis data above, 0010 will be read by the loader and 001.0 will be stored in the database.
Mappings
Coding Scheme data
No descriptive information about the data is included in the source. Default values are provided by the loader. The user must provided a version value to the loader which will be used as the coding scheme version.
...
Field Name | Value |
|---|---|
codingSchemeGuid | <generated value> |
codingSchemeName | ICD-9-CM |
codingSchemeUri | urn:oid:2.16.840.1.113883.6.2 |
representsVersion | <provided by user> |
formalName | ICD-9 CM Volume 1,2, and 3 |
defaultLanguage | ENG |
approxNumConcepts | Null |
description | International Classification of Diseases, Ninth Revision, Clinical Modification |
copyRight | Donna Pickett;Contact for Diseases; National Center for Health Statistics;3311 Toledo Road;Hyattsville;MD;United States; 20782;1-800-232-4636;dfp4@cdc.gov; http://www.cdc.gov/nchs |
isActive | Null |
owner | Null |
status | Null |
effectiveDate | Null |
releaseGuid | Null |
codingSchemeSource | U.S. Department of Health and Human Services, Centers for Medicare & Medicaid Services |
entryStateGuid | Null |
...
Field Name | Value |
|---|---|
supportedAttributeTag | Property |
id | definition |
idValue | definition |
propertyType | PRESENTATION |
Entity
Each row in the source file represents a concept. A LexGrid entityCode is the ICD concept code and entityName is the ICD definition. An entity type of concept is also created in the entityType table. The following tables are updated for each ICD concept: entity, entityType. Also, a property of type PRESENTATION is created for each concept so the property table is updated as well, where the property value is the ICD concept definition.
...
Field Name | Value |
|---|---|
propertyGuid | <generated > |
referenceGuid | < guid from entity table > |
referenceType | entity |
propertyId | definition |
propertyType | presentation |
propertyName | definition |
language | ENG |
format | Null |
isPreferred | 1 |
matchIfNoContext | 0 |
degreeOfFidelity | < blank > |
representationalForm | Null |
propertyValue | ASSAULT-CRIMINAL NEGLECT |
isActive | Null |
owner | Null |
status | Null |
effectiveDate | Null |
expirationDate | Null |
entryStateGuid | < generated > used if revision |
Relations
A default relations container is created by the loader.
...
Field Name | Value |
|---|---|
relationGuid | <generated > |
relationGuid | < from codingScheme table > |
containerName | icd9CmCmsVol1Vol2Vol3Relations |
isMapping | 0 |
representsVersion | Null |
sourceCodingScheme | Null |
sourceCodingSchemeVersion | Null |
targetCodingScheme | urn:oid:2.16.840.1.113883.6.2 |
targetCodingSchemeVersion | < provided by user > |
description | ICD-9-CM CMS Vol 1, Vol 2 and Vol 3 relations container |
isActive | Null |
owner | Null |
status | Null |
effectiveDate | Null |
expirationDate | Null |
entryStateGuid | < generated > |
Associations
There is no hierarchy present in the source files. However, the loader does create a root concept, @, that all other concepts are associated with via the hasSubType and isA relationships.
...
Field Name | Value |
|---|---|
entityGuid | <from entity table> |
entityType | ASSOCIATION |
Concept to Concept Associations
These are the concepts with relationships to each other. As mentioned earlier, there really are none in the ICD data. But we create a default root concept for all the ICD concepts to associate with.
...
