aurora_standard.abshl7d

Field Type Null Default Key Extra Comment
msg_no varchar(20) YES MUL
visit_no int(11) YES MUL
rec_type varchar(3) YES
code_type varchar(1) YES
sequence smallint(6) YES
i9_code varchar(10) YES
i9_date date YES
phy_no int(11) YES
i9_mdc smallint(6) YES
i9_drg smallint(6) YES
i9_poa varchar(1) YES
chs_rowID bigint(20) unsigned NO PRI auto_increment

References

Local Column References
i9_code
TableColumn
Icd.icd10_gemsi10g_i9_code
Icd.icd9_gemsi9g_i9_code
sequence
TableColumn
Loinc.answersans_sequence
Loinc.loinc_panels_and_formslpf_sequence
_1.charts_icd9_codescic_sequence
_1.encounters_icd9_codeseic_sequence
_1188.charts_icd9_codescic_sequence
_1188.encounters_icd9_codeseic_sequence
_1218.charts_icd9_codescic_sequence
_1218.encounters_icd9_codeseic_sequence
_1548.charts_icd9_codescic_sequence
_1548.encounters_icd9_codeseic_sequence
_435.charts_icd9_codescic_sequence
_435.encounters_icd9_codeseic_sequence
_436.charts_icd9_codescic_sequence
_436.encounters_icd9_codeseic_sequence
_436_archive_testing.charts_icd9_codescic_sequence
_436_archive_testing.encounters_icd9_codeseic_sequence
_437.charts_icd9_codescic_sequence
_437.encounters_icd9_codeseic_sequence
_8.charts_icd9_codescic_sequence
_8.encounters_icd9_codeseic_sequence
_81.charts_icd9_codescic_sequence
_81.encounters_icd9_codeseic_sequence
_999.charts_icd9_codescic_sequence
_999.encounters_icd9_codeseic_sequence
aurora_standard.stydeddvposting_sequence
aurora_standard.styincdvposting_sequence
aurora_standard.styobldvposting_sequence
common.lab_interface_mappingslim_sequence
visit_no
TableColumn
aurora_standard.anotesdan_visit_no
aurora_standard.bdfiledbd_visit_no
aurora_standard.chmarsipat_visit_no
aurora_standard.chmcampipat_visit_no
aurora_standard.chmcombrto_visit_no
aurora_standard.chmexmpipat_visit_no
aurora_standard.chmokipdpat_visit_no
aurora_standard.chmokopdpat_visit_no
aurora_standard.chmradedpat_visit_no
aurora_standard.chmradexpat_visit_no
aurora_standard.chrcombrto_visit_no
aurora_standard.ncexmpipat_visit_no
phy_no
TableColumn
aurora_standard.bsinsurfam_phy_no
aurora_standard.c7mpipri_phy_no
aurora_standard.campifam_phy_no
aurora_standard.chmabstradmit_phy_no
aurora_standard.chmabstrattend_phy_no
aurora_standard.chmarsifam_phy_no
aurora_standard.chmcampifam_phy_no
aurora_standard.chmexmpifam_phy_no
aurora_standard.chmpatmrfam_phy_no
aurora_standard.chmpdemofam_phy_no
aurora_standard.chmradexfam_phy_no
aurora_standard.chpwkmnrrefer_phy_no