aurora_standard.chmhdpcd

Field Type Null Default Key Extra Comment
visit_no int(11) NO
mr_no char(20) YES
d_p_c char(1) YES
h_seq smallint(6) YES
h_type char(1) YES
h_date date YES
h_code char(10) YES
poa char(1) YES
proc_phy smallint(6) YES
chs_rowID bigint(20) unsigned NO PRI auto_increment

References

Local Column References
poa
TableColumn
_1.encounters_ub04enc_ub04_72_a_poa
_1.encounters_ub04enc_ub04_72_b_poa
_1.encounters_ub04enc_ub04_72_c_poa
_1188.encounters_ub04enc_ub04_72_a_poa
_1188.encounters_ub04enc_ub04_72_b_poa
_1188.encounters_ub04enc_ub04_72_c_poa
_1218.encounters_ub04enc_ub04_72_a_poa
_1218.encounters_ub04enc_ub04_72_b_poa
_1218.encounters_ub04enc_ub04_72_c_poa
_1548.encounters_ub04enc_ub04_72_a_poa
_1548.encounters_ub04enc_ub04_72_b_poa
_1548.encounters_ub04enc_ub04_72_c_poa
_435.encounters_ub04enc_ub04_72_a_poa
_435.encounters_ub04enc_ub04_72_b_poa
_435.encounters_ub04enc_ub04_72_c_poa
_436.encounters_ub04enc_ub04_72_a_poa
_436.encounters_ub04enc_ub04_72_b_poa
_436.encounters_ub04enc_ub04_72_c_poa
_436_archive_testing.encounters_ub04enc_ub04_72_a_poa
_436_archive_testing.encounters_ub04enc_ub04_72_b_poa
_436_archive_testing.encounters_ub04enc_ub04_72_c_poa
_437.encounters_ub04enc_ub04_72_a_poa
_437.encounters_ub04enc_ub04_72_b_poa
_437.encounters_ub04enc_ub04_72_c_poa
_8.encounters_ub04enc_ub04_72_a_poa
_8.encounters_ub04enc_ub04_72_b_poa
_8.encounters_ub04enc_ub04_72_c_poa
_81.encounters_ub04enc_ub04_72_a_poa
_81.encounters_ub04enc_ub04_72_b_poa
_81.encounters_ub04enc_ub04_72_c_poa
_999.encounters_ub04enc_ub04_72_a_poa
_999.encounters_ub04enc_ub04_72_b_poa
_999.encounters_ub04enc_ub04_72_c_poa
aurora_standard.abshl7di9_poa
aurora_standard.chmazstdprin_poa
aurora_standard.chmazstiprin_poa
aurora_standard.chmazstoprin_poa
aurora_standard.chmlastrpri_poa
aurora_standard.chmmhastadm_poa
aurora_standard.chmokipdprin_poa
aurora_standard.chmtxstrpri_poa
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
mr_no
TableColumn
aurora_standard.bsinsursnf_mr_no
aurora_standard.bsinsurprev_mr_no
aurora_standard.chhcntrcauto_snf_mr_no
aurora_standard.chhcntrcauto_mr_no
aurora_standard.chmarbexpat_mr_no
aurora_standard.chmarsipat_mr_no
aurora_standard.chmbatexpat_mr_no
aurora_standard.chmcampipat_mr_no
aurora_standard.chmcntrcauto_snf_mr_no
aurora_standard.chmcntrcauto_mr_no
aurora_standard.chmexmpipat_mr_no
aurora_standard.chmhstmrpat_mr_no
aurora_standard.chmhstrmpat_mr_no
aurora_standard.chmlastrmother_mr_no
aurora_standard.chmmhastco_mr_no
aurora_standard.chmmrhdrupd_mr_no
aurora_standard.chmnrcexpat_mr_no
aurora_standard.chmokipdpat_mr_no
aurora_standard.chmokopdpat_mr_no
aurora_standard.chmpatmrsnf_mr_no
aurora_standard.chmpatmrprev_mr_no
aurora_standard.chmradedpat_mr_no
aurora_standard.chmradexpat_mr_no
aurora_standard.chmreqsrofc_mr_no
aurora_standard.ncexmpipat_mr_no
proc_phy
TableColumn
aurora_standard.chmazstdprin_proc_phy
aurora_standard.chmazstiprin_proc_phy
aurora_standard.chmazstoprin_proc_phy
aurora_standard.chmokipdprin_proc_phy
aurora_standard.chmokopdprin_proc_phy