_1548.patients_icd9_problems

Field Type Null Default Key Extra Comment
pip_id int(11) NO PRI auto_increment
pip_cus_id int(11) NO MUL
pip_cli_id int(11) NO MUL
pip_pat_id int(11) NO MUL
pip_icd_code varchar(6) NO MUL
pip_eic_id int(11) NO 0 MUL
pip_cdx_id int(11) NO MUL
pip_cs_id int(11) NO MUL
pip_code_id int(11) NO MUL
pip_code varchar(45) NO
pip_desc varchar(256) NO
pip_status varchar(12) NO
pip_sno_code varchar(45) NO
pip_date_diagnosed varchar(8) NO
pip_end_datetime varchar(12) NO
pip_diagnosed_ts varchar(12) NO
pip_diagnosed_by_usr_id int(11) YES
pip_resolved_by_usr_id int(11) YES
pip_created_by_usr_id int(11) YES
pip_education_provided char(1) NO 0
pip_disabled char(1) NO
pip_reconciled char(1) NO
pip_historical char(1) NO
pip_cog_status char(1) NO
pip_func_status tinyint(1) NO 0 Functional status
pip_modified datetime YES CURRENT_TIMESTAMP
pip_created datetime YES CURRENT_TIMESTAMP
pip_note text YES Problem note

References

Local Column References
pip_id
TableColumn
_1.auditsaud_pip_id
_1.audits_archiveaud_pip_id
_1.charts_care_plan_problems_pointerscpp_pip_id
_1.charts_dx_pointerscdp_pip_id
_1.charts_icd9_codescic_pip_id
_1.patients_icd9_problems_dx_modifierspipdm_pip_id
_1188.auditsaud_pip_id
_1188.audits_archiveaud_pip_id
_1188.charts_care_plan_problems_pointerscpp_pip_id
_1188.charts_dx_pointerscdp_pip_id
_1188.charts_icd9_codescic_pip_id
_1188.patients_icd9_problems_dx_modifierspipdm_pip_id
_1218.auditsaud_pip_id
_1218.audits_archiveaud_pip_id
_1218.charts_care_plan_problems_pointerscpp_pip_id
_1218.charts_dx_pointerscdp_pip_id
_1218.charts_icd9_codescic_pip_id
_1218.patients_icd9_problems_dx_modifierspipdm_pip_id
_1548.auditsaud_pip_id
_1548.audits_archiveaud_pip_id
_1548.charts_care_plan_problems_pointerscpp_pip_id
_1548.charts_dx_pointerscdp_pip_id
_1548.charts_icd9_codescic_pip_id
_1548.patients_icd9_problems_dx_modifierspipdm_pip_id
_435.auditsaud_pip_id
_435.audits_archiveaud_pip_id
_435.charts_care_plan_problems_pointerscpp_pip_id
_435.charts_dx_pointerscdp_pip_id
_435.charts_icd9_codescic_pip_id
_435.patients_icd9_problems_dx_modifierspipdm_pip_id
_436.auditsaud_pip_id
_436.audits_archiveaud_pip_id
_436.charts_care_plan_problems_pointerscpp_pip_id
_436.charts_dx_pointerscdp_pip_id
_436.charts_icd9_codescic_pip_id
_436.patients_icd9_problems_dx_modifierspipdm_pip_id
_436_archive_testing.auditsaud_pip_id
_436_archive_testing.audits_archiveaud_pip_id
_436_archive_testing.charts_care_plan_problems_pointerscpp_pip_id
_436_archive_testing.charts_dx_pointerscdp_pip_id
_436_archive_testing.charts_icd9_codescic_pip_id
_436_archive_testing.patients_icd9_problems_dx_modifierspipdm_pip_id
_437.auditsaud_pip_id
_437.audits_archiveaud_pip_id
_437.charts_care_plan_problems_pointerscpp_pip_id
_437.charts_dx_pointerscdp_pip_id
_437.charts_icd9_codescic_pip_id
_437.patients_icd9_problems_dx_modifierspipdm_pip_id
_8.auditsaud_pip_id
_8.audits_archiveaud_pip_id
_8.charts_care_plan_problems_pointerscpp_pip_id
_8.charts_dx_pointerscdp_pip_id
_8.charts_icd9_codescic_pip_id
_8.patients_icd9_problems_dx_modifierspipdm_pip_id
_81.auditsaud_pip_id
_81.audits_archiveaud_pip_id
_81.charts_care_plan_problems_pointerscpp_pip_id
_81.charts_dx_pointerscdp_pip_id
_81.charts_icd9_codescic_pip_id
_81.patients_icd9_problems_dx_modifierspipdm_pip_id
_999.auditsaud_pip_id
_999.audits_archiveaud_pip_id
_999.charts_care_plan_problems_pointerscpp_pip_id
_999.charts_dx_pointerscdp_pip_id
_999.charts_icd9_codescic_pip_id
_999.patients_icd9_problems_dx_modifierspipdm_pip_id