aurora_standard.c8dtls

Field Type Null Default Key Extra Comment
mpino char(20) YES
p_sex char(1) YES
p_ssn char(11) YES
p_dob char(20) YES
race char(7) YES
religion char(20) YES
marital char(1) YES
mrno char(20) YES

References

Local Column References
race
TableColumn
_1.chartschrt_race
_1.encountersenc_race
_1.orders_afpsoafp_race
_1.patientspat_race
_1.precertspre_race
_1188.chartschrt_race
_1188.encountersenc_race
_1188.orders_afpsoafp_race
_1188.patientspat_race
_1188.precertspre_race
_1218.chartschrt_race
_1218.encountersenc_race
_1218.orders_afpsoafp_race
_1218.patientspat_race
_1218.precertspre_race
_1548.chartschrt_race
_1548.encountersenc_race
_1548.orders_afpsoafp_race
_1548.patientspat_race
_1548.precertspre_race
_435.chartschrt_race
_435.encountersenc_race
_435.orders_afpsoafp_race
_435.patientspat_race
_435.precertspre_race
_436.chartschrt_race
_436.encountersenc_race
_436.orders_afpsoafp_race
_436.patientspat_race
_436.precertspre_race
_436_archive_testing.chartschrt_race
_436_archive_testing.encountersenc_race
_436_archive_testing.orders_afpsoafp_race
_436_archive_testing.patientspat_race
_436_archive_testing.precertspre_race
_437.chartschrt_race
_437.encountersenc_race
_437.orders_afpsoafp_race
_437.patientspat_race
_437.precertspre_race
_8.chartschrt_race
_8.encountersenc_race
_8.orders_afpsoafp_race
_8.patientspat_race
_8.precertspre_race
_81.chartschrt_race
_81.encountersenc_race
_81.orders_afpsoafp_race
_81.patientspat_race
_81.precertspre_race
_999.chartschrt_race
_999.encountersenc_race
_999.orders_afpsoafp_race
_999.patientspat_race
_999.precertspre_race
aurora_standard.bharp_race
aurora_standard.bharg_race
aurora_standard.bhguarg_race
aurora_standard.bhtguarg_race
aurora_standard.bparp_race
aurora_standard.bparg_race
aurora_standard.bpar2p_race
aurora_standard.bpar2g_race
aurora_standard.bpmpip_race
aurora_standard.bpmpi2p_race
aurora_standard.chmazstdpat_race
aurora_standard.chmazstipat_race
aurora_standard.chmazstopat_race
aurora_standard.chmhistpp_race
aurora_standard.chmlastrpat_race
aurora_standard.chmmhastpat_race
aurora_standard.chmokipdpat_race
aurora_standard.chmokopdpat_race
aurora_standard.chmtxstrpat_race
aurora_standard.hl7gt1guar_race
aurora_standard.tmpmrrptsex_race
mrno
TableColumn
aurora_standard.abmmpigu_mrno
aurora_standard.abmvisgu_mrno
aurora_standard.amrnowkgood_mrno
aurora_standard.amrnowkold_mrno
aurora_standard.apsmpi2ca_mrno
aurora_standard.aseympica_mrno
aurora_standard.b2baddnew_mrno
aurora_standard.b2mrdrnew_mrno
aurora_standard.bhbaddnew_mrno
aurora_standard.bhldgrnew_mrno
aurora_standard.bhmrdrnew_mrno
aurora_standard.bhtldgrnew_mrno
aurora_standard.bvmpinew_mrno
aurora_standard.bvmpi2new_mrno
aurora_standard.chmcntrcassign_mrno
aurora_standard.chxcntrcid_is_mrno
marital
TableColumn
aurora_standard.chmarsipat_marital
aurora_standard.chmazstdpat_marital
aurora_standard.chmazstipat_marital
aurora_standard.chmazstopat_marital
aurora_standard.chmcampipat_marital
aurora_standard.chmexmpipat_marital
aurora_standard.chmlastrpat_marital
aurora_standard.chmmrhdrupd_marital
aurora_standard.chmokipdpat_marital
aurora_standard.chmokopdpat_marital
aurora_standard.chmpdemop_marital
aurora_standard.chmradexpat_marital
aurora_standard.chmtxstrpat_marital
aurora_standard.ohoemaddstate_marital
aurora_standard.ohoemaddfed_marital
aurora_standard.styemplrstate_marital
aurora_standard.stytaxtdstate_marital