common.icd9

Field Type Null Default Key Extra Comment
icd_id int(11) NO PRI auto_increment
icd_code varchar(6) NO MUL
icd_desc varchar(24) NO MUL
icd_desc_long text NO
icd_modified timestamp YES CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
icd_created timestamp YES CURRENT_TIMESTAMP

References

Local Column References
icd_id
TableColumn
_1.charts_icd9_codescic_icd_id
_1.configured_encounters_templates_dx_codescetdxc_icd_id
_1.encounters_icd9_codeseic_icd_id
_1.encounters_icd9_codes_statseics_icd_id
_1.encounters_icd9_codes_templateseict_icd_id
_1.immunizations_icd_mapiim_icd_id
_1.orders_icd9_codesoic_icd_id
_1.orders_icd9_codes_statsoics_icd_id
_1.orders_icd9_codes_templatesoict_icd_id
_1.orders_icd9_test_codes_mapoitcm_icd_id
_1.precerts_icd9_codespic_icd_id
_1.precerts_icd9_codes_statspics_icd_id
_1.problems_listspl_icd_id
_1.radiology_orders_icd9_codesric_icd_id
_1188.charts_icd9_codescic_icd_id
_1188.configured_encounters_templates_dx_codescetdxc_icd_id
_1188.encounters_icd9_codeseic_icd_id
_1188.encounters_icd9_codes_statseics_icd_id
_1188.encounters_icd9_codes_templateseict_icd_id
_1188.immunizations_icd_mapiim_icd_id
_1188.orders_icd9_codesoic_icd_id
_1188.orders_icd9_codes_statsoics_icd_id
_1188.orders_icd9_codes_templatesoict_icd_id
_1188.orders_icd9_test_codes_mapoitcm_icd_id
_1188.precerts_icd9_codespic_icd_id
_1188.precerts_icd9_codes_statspics_icd_id
_1188.problems_listspl_icd_id
_1188.radiology_orders_icd9_codesric_icd_id
_1218.charts_icd9_codescic_icd_id
_1218.configured_encounters_templates_dx_codescetdxc_icd_id
_1218.encounters_icd9_codeseic_icd_id
_1218.encounters_icd9_codes_statseics_icd_id
_1218.encounters_icd9_codes_templateseict_icd_id
_1218.immunizations_icd_mapiim_icd_id
_1218.orders_icd9_codesoic_icd_id
_1218.orders_icd9_codes_statsoics_icd_id
_1218.orders_icd9_codes_templatesoict_icd_id
_1218.orders_icd9_test_codes_mapoitcm_icd_id
_1218.precerts_icd9_codespic_icd_id
_1218.precerts_icd9_codes_statspics_icd_id
_1218.problems_listspl_icd_id
_1218.radiology_orders_icd9_codesric_icd_id
_1548.charts_icd9_codescic_icd_id
_1548.configured_encounters_templates_dx_codescetdxc_icd_id
_1548.encounters_icd9_codeseic_icd_id
_1548.encounters_icd9_codes_statseics_icd_id
_1548.encounters_icd9_codes_templateseict_icd_id
_1548.immunizations_icd_mapiim_icd_id
_1548.orders_icd9_codesoic_icd_id
_1548.orders_icd9_codes_statsoics_icd_id
_1548.orders_icd9_codes_templatesoict_icd_id
_1548.orders_icd9_test_codes_mapoitcm_icd_id
_1548.precerts_icd9_codespic_icd_id
_1548.precerts_icd9_codes_statspics_icd_id
_1548.problems_listspl_icd_id
_1548.radiology_orders_icd9_codesric_icd_id
_435.charts_icd9_codescic_icd_id
_435.configured_encounters_templates_dx_codescetdxc_icd_id
_435.encounters_icd9_codeseic_icd_id
_435.encounters_icd9_codes_statseics_icd_id
_435.encounters_icd9_codes_templateseict_icd_id
_435.immunizations_icd_mapiim_icd_id
_435.orders_icd9_codesoic_icd_id
_435.orders_icd9_codes_statsoics_icd_id
_435.orders_icd9_codes_templatesoict_icd_id
_435.orders_icd9_test_codes_mapoitcm_icd_id
_435.precerts_icd9_codespic_icd_id
_435.precerts_icd9_codes_statspics_icd_id
_435.problems_listspl_icd_id
_435.radiology_orders_icd9_codesric_icd_id
_436.charts_icd9_codescic_icd_id
_436.configured_encounters_templates_dx_codescetdxc_icd_id
_436.encounters_icd9_codeseic_icd_id
_436.encounters_icd9_codes_statseics_icd_id
_436.encounters_icd9_codes_templateseict_icd_id
_436.immunizations_icd_mapiim_icd_id
_436.orders_icd9_codesoic_icd_id
_436.orders_icd9_codes_statsoics_icd_id
_436.orders_icd9_codes_templatesoict_icd_id
_436.orders_icd9_test_codes_mapoitcm_icd_id
_436.precerts_icd9_codespic_icd_id
_436.precerts_icd9_codes_statspics_icd_id
_436.problems_listspl_icd_id
_436.radiology_orders_icd9_codesric_icd_id
_436_archive_testing.charts_icd9_codescic_icd_id
_436_archive_testing.configured_encounters_templates_dx_codescetdxc_icd_id
_436_archive_testing.encounters_icd9_codeseic_icd_id
_436_archive_testing.encounters_icd9_codes_statseics_icd_id
_436_archive_testing.encounters_icd9_codes_templateseict_icd_id
_436_archive_testing.immunizations_icd_mapiim_icd_id
_436_archive_testing.orders_icd9_codesoic_icd_id
_436_archive_testing.orders_icd9_codes_statsoics_icd_id
_436_archive_testing.orders_icd9_codes_templatesoict_icd_id
_436_archive_testing.orders_icd9_test_codes_mapoitcm_icd_id
_436_archive_testing.precerts_icd9_codespic_icd_id
_436_archive_testing.precerts_icd9_codes_statspics_icd_id
_436_archive_testing.problems_listspl_icd_id
_436_archive_testing.radiology_orders_icd9_codesric_icd_id
_437.charts_icd9_codescic_icd_id
_437.configured_encounters_templates_dx_codescetdxc_icd_id
_437.encounters_icd9_codeseic_icd_id
_437.encounters_icd9_codes_statseics_icd_id
_437.encounters_icd9_codes_templateseict_icd_id
_437.immunizations_icd_mapiim_icd_id
_437.orders_icd9_codesoic_icd_id
_437.orders_icd9_codes_statsoics_icd_id
_437.orders_icd9_codes_templatesoict_icd_id
_437.orders_icd9_test_codes_mapoitcm_icd_id
_437.precerts_icd9_codespic_icd_id
_437.precerts_icd9_codes_statspics_icd_id
_437.problems_listspl_icd_id
_437.radiology_orders_icd9_codesric_icd_id
_8.charts_icd9_codescic_icd_id
_8.configured_encounters_templates_dx_codescetdxc_icd_id
_8.encounters_icd9_codeseic_icd_id
_8.encounters_icd9_codes_statseics_icd_id
_8.encounters_icd9_codes_templateseict_icd_id
_8.immunizations_icd_mapiim_icd_id
_8.orders_icd9_codesoic_icd_id
_8.orders_icd9_codes_statsoics_icd_id
_8.orders_icd9_codes_templatesoict_icd_id
_8.orders_icd9_test_codes_mapoitcm_icd_id
_8.precerts_icd9_codespic_icd_id
_8.precerts_icd9_codes_statspics_icd_id
_8.problems_listspl_icd_id
_8.radiology_orders_icd9_codesric_icd_id
_81.charts_icd9_codescic_icd_id
_81.configured_encounters_templates_dx_codescetdxc_icd_id
_81.encounters_icd9_codeseic_icd_id
_81.encounters_icd9_codes_statseics_icd_id
_81.encounters_icd9_codes_templateseict_icd_id
_81.immunizations_icd_mapiim_icd_id
_81.orders_icd9_codesoic_icd_id
_81.orders_icd9_codes_statsoics_icd_id
_81.orders_icd9_codes_templatesoict_icd_id
_81.orders_icd9_test_codes_mapoitcm_icd_id
_81.precerts_icd9_codespic_icd_id
_81.precerts_icd9_codes_statspics_icd_id
_81.problems_listspl_icd_id
_81.radiology_orders_icd9_codesric_icd_id
_999.charts_icd9_codescic_icd_id
_999.configured_encounters_templates_dx_codescetdxc_icd_id
_999.encounters_icd9_codeseic_icd_id
_999.encounters_icd9_codes_statseics_icd_id
_999.encounters_icd9_codes_templateseict_icd_id
_999.immunizations_icd_mapiim_icd_id
_999.orders_icd9_codesoic_icd_id
_999.orders_icd9_codes_statsoics_icd_id
_999.orders_icd9_codes_templatesoict_icd_id
_999.orders_icd9_test_codes_mapoitcm_icd_id
_999.precerts_icd9_codespic_icd_id
_999.precerts_icd9_codes_statspics_icd_id
_999.problems_listspl_icd_id
_999.radiology_orders_icd9_codesric_icd_id
common.icd9_ancillaryicda_icd_id
common.icd9_indexicdi_icd_id
template_library.encounters_icd9_codes_templateseict_icd_id
template_library.orders_icd9_codes_templatesoict_icd_id
icd_code
TableColumn
_1.immunizations_icd_mapiim_icd_code
_1.patients_icd9_problemspip_icd_code
_1188.immunizations_icd_mapiim_icd_code
_1188.patients_icd9_problemspip_icd_code
_1218.immunizations_icd_mapiim_icd_code
_1218.patients_icd9_problemspip_icd_code
_1548.immunizations_icd_mapiim_icd_code
_1548.patients_icd9_problemspip_icd_code
_435.immunizations_icd_mapiim_icd_code
_435.patients_icd9_problemspip_icd_code
_436.immunizations_icd_mapiim_icd_code
_436.patients_icd9_problemspip_icd_code
_436_archive_testing.immunizations_icd_mapiim_icd_code
_436_archive_testing.patients_icd9_problemspip_icd_code
_437.immunizations_icd_mapiim_icd_code
_437.patients_icd9_problemspip_icd_code
_8.immunizations_icd_mapiim_icd_code
_8.patients_icd9_problemspip_icd_code
_81.immunizations_icd_mapiim_icd_code
_81.patients_icd9_problemspip_icd_code
_999.immunizations_icd_mapiim_icd_code
_999.patients_icd9_problemspip_icd_code