aurora_standard.cadiag

Field Type Null Default Key Extra Comment
stupid_no varchar(20) YES
vis_no int(11) YES MUL
mr_no varchar(20) YES
evo_no varchar(20) YES
dx_type varchar(1) YES
dx_code varchar(5) YES
dx_date varchar(10) YES
seqno smallint(6) YES
poa varchar(1) YES
dx_ind char(4) YES

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
vis_no
TableColumn
aurora_standard.bmvismoms_vis_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