aurora_standard.bhppat

Field Type Null Default Key Extra Comment
mrno char(20) YES MUL
full_nm char(50) YES
med_rec_no char(20) YES
p_ssn char(11) YES
dob char(10) YES
last_adm_dt char(10) YES
last_adm_hr varchar(2) YES
fac varchar(3) YES
birth_dt date YES

References

Local Column References
dob
TableColumn
_1.chartschrt_dob
_1.cpoe_responsescpoe_res_dob
_1.donorsdon_dob
_1.encountersenc_dob
_1.encountersenc_guarantor_dob
_1.encountersenc_ins1_insured_dob
_1.encountersenc_ins2_insured_dob
_1.encountersenc_ins3_insured_dob
_1.hl7_accessionsacc_dob
_1.insurances_repositoryirep_ins_insured_dob
_1.ordersord_dob
_1.patientspat_dob
_1.patientspat_guarantor_dob
_1.patientspat_ins1_insured_dob
_1.patientspat_ins2_insured_dob
_1.patientspat_ins3_insured_dob
_1.patients_demographics_snapshotspds_dob
_1.patients_demographics_snapshotspds_guarantor_dob
_1.patients_demographics_snapshotspds_ins1_insured_dob
_1.patients_demographics_snapshotspds_ins2_insured_dob
_1.patients_demographics_snapshotspds_ins3_insured_dob
_1.patients_responsibility_estimatesprest_dob
_1.precertspre_dob
_1.precertspre_guarantor_dob
_1.precertspre_ins1_insured_dob
_1.precertspre_ins2_insured_dob
_1.radiology_ordersrad_dob
_1.radiology_resultsrad_res_dob
_1188.chartschrt_dob
_1188.cpoe_responsescpoe_res_dob
_1188.donorsdon_dob
_1188.encountersenc_dob
_1188.encountersenc_guarantor_dob
_1188.encountersenc_ins1_insured_dob
_1188.encountersenc_ins2_insured_dob
_1188.encountersenc_ins3_insured_dob
_1188.hl7_accessionsacc_dob
_1188.insurances_repositoryirep_ins_insured_dob
_1188.ordersord_dob
_1188.patientspat_dob
_1188.patientspat_guarantor_dob
_1188.patientspat_ins1_insured_dob
_1188.patientspat_ins2_insured_dob
_1188.patientspat_ins3_insured_dob
_1188.patients_demographics_snapshotspds_dob
_1188.patients_demographics_snapshotspds_guarantor_dob
_1188.patients_demographics_snapshotspds_ins1_insured_dob
_1188.patients_demographics_snapshotspds_ins2_insured_dob
_1188.patients_demographics_snapshotspds_ins3_insured_dob
_1188.patients_responsibility_estimatesprest_dob
_1188.precertspre_dob
_1188.precertspre_guarantor_dob
_1188.precertspre_ins1_insured_dob
_1188.precertspre_ins2_insured_dob
_1188.radiology_ordersrad_dob
_1188.radiology_resultsrad_res_dob
_1218.chartschrt_dob
_1218.cpoe_responsescpoe_res_dob
_1218.donorsdon_dob
_1218.encountersenc_dob
_1218.encountersenc_guarantor_dob
_1218.encountersenc_ins1_insured_dob
_1218.encountersenc_ins2_insured_dob
_1218.encountersenc_ins3_insured_dob
_1218.hl7_accessionsacc_dob
_1218.insurances_repositoryirep_ins_insured_dob
_1218.ordersord_dob
_1218.patientspat_dob
_1218.patientspat_guarantor_dob
_1218.patientspat_ins1_insured_dob
_1218.patientspat_ins2_insured_dob
_1218.patientspat_ins3_insured_dob
_1218.patients_demographics_snapshotspds_dob
_1218.patients_demographics_snapshotspds_guarantor_dob
_1218.patients_demographics_snapshotspds_ins1_insured_dob
_1218.patients_demographics_snapshotspds_ins2_insured_dob
_1218.patients_demographics_snapshotspds_ins3_insured_dob
_1218.patients_responsibility_estimatesprest_dob
_1218.precertspre_dob
_1218.precertspre_guarantor_dob
_1218.precertspre_ins1_insured_dob
_1218.precertspre_ins2_insured_dob
_1218.radiology_ordersrad_dob
_1218.radiology_resultsrad_res_dob
_1548.chartschrt_dob
_1548.cpoe_responsescpoe_res_dob
_1548.donorsdon_dob
_1548.encountersenc_dob
_1548.encountersenc_guarantor_dob
_1548.encountersenc_ins1_insured_dob
_1548.encountersenc_ins2_insured_dob
_1548.encountersenc_ins3_insured_dob
_1548.hl7_accessionsacc_dob
_1548.insurances_repositoryirep_ins_insured_dob
_1548.ordersord_dob
_1548.patientspat_dob
_1548.patientspat_guarantor_dob
_1548.patientspat_ins1_insured_dob
_1548.patientspat_ins2_insured_dob
_1548.patientspat_ins3_insured_dob
_1548.patients_demographics_snapshotspds_dob
_1548.patients_demographics_snapshotspds_guarantor_dob
_1548.patients_demographics_snapshotspds_ins1_insured_dob
_1548.patients_demographics_snapshotspds_ins2_insured_dob
_1548.patients_demographics_snapshotspds_ins3_insured_dob
_1548.patients_responsibility_estimatesprest_dob
_1548.precertspre_dob
_1548.precertspre_guarantor_dob
_1548.precertspre_ins1_insured_dob
_1548.precertspre_ins2_insured_dob
_1548.radiology_ordersrad_dob
_1548.radiology_resultsrad_res_dob
_435.chartschrt_dob
_435.cpoe_responsescpoe_res_dob
_435.donorsdon_dob
_435.encountersenc_dob
_435.encountersenc_guarantor_dob
_435.encountersenc_ins1_insured_dob
_435.encountersenc_ins2_insured_dob
_435.encountersenc_ins3_insured_dob
_435.hl7_accessionsacc_dob
_435.insurances_repositoryirep_ins_insured_dob
_435.ordersord_dob
_435.patientspat_dob
_435.patientspat_guarantor_dob
_435.patientspat_ins1_insured_dob
_435.patientspat_ins2_insured_dob
_435.patientspat_ins3_insured_dob
_435.patients_demographics_snapshotspds_dob
_435.patients_demographics_snapshotspds_guarantor_dob
_435.patients_demographics_snapshotspds_ins1_insured_dob
_435.patients_demographics_snapshotspds_ins2_insured_dob
_435.patients_demographics_snapshotspds_ins3_insured_dob
_435.patients_responsibility_estimatesprest_dob
_435.precertspre_dob
_435.precertspre_guarantor_dob
_435.precertspre_ins1_insured_dob
_435.precertspre_ins2_insured_dob
_435.radiology_ordersrad_dob
_435.radiology_resultsrad_res_dob
_436.chartschrt_dob
_436.cpoe_responsescpoe_res_dob
_436.donorsdon_dob
_436.encountersenc_dob
_436.encountersenc_guarantor_dob
_436.encountersenc_ins1_insured_dob
_436.encountersenc_ins2_insured_dob
_436.encountersenc_ins3_insured_dob
_436.hl7_accessionsacc_dob
_436.insurances_repositoryirep_ins_insured_dob
_436.ordersord_dob
_436.patientspat_dob
_436.patientspat_guarantor_dob
_436.patientspat_ins1_insured_dob
_436.patientspat_ins2_insured_dob
_436.patientspat_ins3_insured_dob
_436.patients_demographics_snapshotspds_dob
_436.patients_demographics_snapshotspds_guarantor_dob
_436.patients_demographics_snapshotspds_ins1_insured_dob
_436.patients_demographics_snapshotspds_ins2_insured_dob
_436.patients_demographics_snapshotspds_ins3_insured_dob
_436.patients_responsibility_estimatesprest_dob
_436.precertspre_dob
_436.precertspre_guarantor_dob
_436.precertspre_ins1_insured_dob
_436.precertspre_ins2_insured_dob
_436.radiology_ordersrad_dob
_436.radiology_resultsrad_res_dob
_436_archive_testing.chartschrt_dob
_436_archive_testing.cpoe_responsescpoe_res_dob
_436_archive_testing.donorsdon_dob
_436_archive_testing.encountersenc_dob
_436_archive_testing.encountersenc_guarantor_dob
_436_archive_testing.encountersenc_ins1_insured_dob
_436_archive_testing.encountersenc_ins2_insured_dob
_436_archive_testing.encountersenc_ins3_insured_dob
_436_archive_testing.hl7_accessionsacc_dob
_436_archive_testing.insurances_repositoryirep_ins_insured_dob
_436_archive_testing.ordersord_dob
_436_archive_testing.patientspat_dob
_436_archive_testing.patientspat_guarantor_dob
_436_archive_testing.patientspat_ins1_insured_dob
_436_archive_testing.patientspat_ins2_insured_dob
_436_archive_testing.patientspat_ins3_insured_dob
_436_archive_testing.patients_demographics_snapshotspds_dob
_436_archive_testing.patients_demographics_snapshotspds_guarantor_dob
_436_archive_testing.patients_demographics_snapshotspds_ins1_insured_dob
_436_archive_testing.patients_demographics_snapshotspds_ins2_insured_dob
_436_archive_testing.patients_demographics_snapshotspds_ins3_insured_dob
_436_archive_testing.patients_responsibility_estimatesprest_dob
_436_archive_testing.precertspre_dob
_436_archive_testing.precertspre_guarantor_dob
_436_archive_testing.precertspre_ins1_insured_dob
_436_archive_testing.precertspre_ins2_insured_dob
_436_archive_testing.radiology_ordersrad_dob
_436_archive_testing.radiology_resultsrad_res_dob
_437.chartschrt_dob
_437.cpoe_responsescpoe_res_dob
_437.donorsdon_dob
_437.encountersenc_dob
_437.encountersenc_guarantor_dob
_437.encountersenc_ins1_insured_dob
_437.encountersenc_ins2_insured_dob
_437.encountersenc_ins3_insured_dob
_437.hl7_accessionsacc_dob
_437.insurances_repositoryirep_ins_insured_dob
_437.ordersord_dob
_437.patientspat_dob
_437.patientspat_guarantor_dob
_437.patientspat_ins1_insured_dob
_437.patientspat_ins2_insured_dob
_437.patientspat_ins3_insured_dob
_437.patients_demographics_snapshotspds_dob
_437.patients_demographics_snapshotspds_guarantor_dob
_437.patients_demographics_snapshotspds_ins1_insured_dob
_437.patients_demographics_snapshotspds_ins2_insured_dob
_437.patients_demographics_snapshotspds_ins3_insured_dob
_437.patients_responsibility_estimatesprest_dob
_437.precertspre_dob
_437.precertspre_guarantor_dob
_437.precertspre_ins1_insured_dob
_437.precertspre_ins2_insured_dob
_437.radiology_ordersrad_dob
_437.radiology_resultsrad_res_dob
_8.chartschrt_dob
_8.cpoe_responsescpoe_res_dob
_8.donorsdon_dob
_8.encountersenc_dob
_8.encountersenc_guarantor_dob
_8.encountersenc_ins1_insured_dob
_8.encountersenc_ins2_insured_dob
_8.encountersenc_ins3_insured_dob
_8.hl7_accessionsacc_dob
_8.insurances_repositoryirep_ins_insured_dob
_8.ordersord_dob
_8.patientspat_dob
_8.patientspat_guarantor_dob
_8.patientspat_ins1_insured_dob
_8.patientspat_ins2_insured_dob
_8.patientspat_ins3_insured_dob
_8.patients_demographics_snapshotspds_dob
_8.patients_demographics_snapshotspds_guarantor_dob
_8.patients_demographics_snapshotspds_ins1_insured_dob
_8.patients_demographics_snapshotspds_ins2_insured_dob
_8.patients_demographics_snapshotspds_ins3_insured_dob
_8.patients_responsibility_estimatesprest_dob
_8.precertspre_dob
_8.precertspre_guarantor_dob
_8.precertspre_ins1_insured_dob
_8.precertspre_ins2_insured_dob
_8.radiology_ordersrad_dob
_8.radiology_resultsrad_res_dob
_81.chartschrt_dob
_81.cpoe_responsescpoe_res_dob
_81.donorsdon_dob
_81.encountersenc_dob
_81.encountersenc_guarantor_dob
_81.encountersenc_ins1_insured_dob
_81.encountersenc_ins2_insured_dob
_81.encountersenc_ins3_insured_dob
_81.hl7_accessionsacc_dob
_81.insurances_repositoryirep_ins_insured_dob
_81.ordersord_dob
_81.patientspat_dob
_81.patientspat_guarantor_dob
_81.patientspat_ins1_insured_dob
_81.patientspat_ins2_insured_dob
_81.patientspat_ins3_insured_dob
_81.patients_demographics_snapshotspds_dob
_81.patients_demographics_snapshotspds_guarantor_dob
_81.patients_demographics_snapshotspds_ins1_insured_dob
_81.patients_demographics_snapshotspds_ins2_insured_dob
_81.patients_demographics_snapshotspds_ins3_insured_dob
_81.patients_responsibility_estimatesprest_dob
_81.precertspre_dob
_81.precertspre_guarantor_dob
_81.precertspre_ins1_insured_dob
_81.precertspre_ins2_insured_dob
_81.radiology_ordersrad_dob
_81.radiology_resultsrad_res_dob
_999.chartschrt_dob
_999.cpoe_responsescpoe_res_dob
_999.donorsdon_dob
_999.encountersenc_dob
_999.encountersenc_guarantor_dob
_999.encountersenc_ins1_insured_dob
_999.encountersenc_ins2_insured_dob
_999.encountersenc_ins3_insured_dob
_999.hl7_accessionsacc_dob
_999.insurances_repositoryirep_ins_insured_dob
_999.ordersord_dob
_999.patientspat_dob
_999.patientspat_guarantor_dob
_999.patientspat_ins1_insured_dob
_999.patientspat_ins2_insured_dob
_999.patientspat_ins3_insured_dob
_999.patients_demographics_snapshotspds_dob
_999.patients_demographics_snapshotspds_guarantor_dob
_999.patients_demographics_snapshotspds_ins1_insured_dob
_999.patients_demographics_snapshotspds_ins2_insured_dob
_999.patients_demographics_snapshotspds_ins3_insured_dob
_999.patients_responsibility_estimatesprest_dob
_999.precertspre_dob
_999.precertspre_guarantor_dob
_999.precertspre_ins1_insured_dob
_999.precertspre_ins2_insured_dob
_999.radiology_ordersrad_dob
_999.radiology_resultsrad_res_dob
aurora_standard.abmmpii1_dob
aurora_standard.abmmpii2_dob
aurora_standard.abmmpii3_dob
aurora_standard.abmmpigu_dob
aurora_standard.abmvisgu_dob
aurora_standard.abmvisi1_dob
aurora_standard.abmvisi2_dob
aurora_standard.abmvisi3_dob
aurora_standard.bevisbd2p_dob
aurora_standard.bharp_dob
aurora_standard.bharg_dob
aurora_standard.bmmpip_dob
aurora_standard.bmnkinn_dob
aurora_standard.bmpactp_dob
aurora_standard.bmpatp_dob
aurora_standard.bparp_dob
aurora_standard.bparg_dob
aurora_standard.bpar2p_dob
aurora_standard.bpar2g_dob
aurora_standard.bpmpip_dob
aurora_standard.bpmpi2p_dob
aurora_standard.bpmrp_dob
aurora_standard.bpmr2p_dob
aurora_standard.c7mpip_dob
aurora_standard.c7mpigu_dob
aurora_standard.c8dtlsp_dob
aurora_standard.c8guarg_dob
aurora_standard.c8guar2g_dob
aurora_standard.c9mpip_dob
aurora_standard.chhl7in1insured_dob
aurora_standard.chmarcnbfg_dob
aurora_standard.chmarcnbfp_dob
aurora_standard.chmarsipat_dob
aurora_standard.chmarsigu_dob
aurora_standard.chmarsisp_dob
aurora_standard.chmazstdpat_dob
aurora_standard.chmazstipat_dob
aurora_standard.chmazstopat_dob
aurora_standard.chmbatexpat_dob
aurora_standard.chmcampipat_dob
aurora_standard.chmcampigu_dob
aurora_standard.chmcampisp_dob
aurora_standard.chmclaimpat_dob
aurora_standard.chmcmhedguar_dob
aurora_standard.chmcmhedpat_dob
aurora_standard.chmexmpipat_dob
aurora_standard.chmexmpigu_dob
aurora_standard.chmexmpisp_dob
aurora_standard.chmhistpp_dob
aurora_standard.chmlastrpat_dob
aurora_standard.chmmashrpat_dob
aurora_standard.chmmhastpat_dob
aurora_standard.chmnrcexpat_dob
aurora_standard.chmokipdpat_dob
aurora_standard.chmokopdpat_dob
aurora_standard.chmozpcdguar_dob
aurora_standard.chmozpcdpat_dob
aurora_standard.chmpatirsubscr_dob
aurora_standard.chmpatwcmom_dob
aurora_standard.chmpatwcdad_dob
aurora_standard.chmpdemop_dob
aurora_standard.chmpdemosp_dob
aurora_standard.chmpdemogu_dob
aurora_standard.chmradexpat_dob
aurora_standard.chmradexgu_dob
aurora_standard.chmradexsp_dob
aurora_standard.chmtxstrpat_dob
aurora_standard.chqphyncphy_dob
aurora_standard.chxhistrh_dob
aurora_standard.chyhistrh_dob
aurora_standard.hl7in1insured_dob
aurora_standard.hl7in1adinsured_dob
aurora_standard.ncexmpipat_dob
aurora_standard.styoempddepend_dob
fac
TableColumn
aurora_standard.TABLE 1424new_fac
aurora_standard.TABLE 1425new_fac
aurora_standard.chmcntrcbatch_by_fac
aurora_standard.chmpaytcpmt_fac
aurora_standard.chmpaytcadj_fac
aurora_standard.chmpaytcar_fac
aurora_standard.chpcntrccobra_cash_fac
aurora_standard.chpcntrccobra_bal_fac
aurora_standard.chpcntrccobra_fee_fac
aurora_standard.chscustddept_fac
aurora_standard.glxrefnew_fac
aurora_standard.glxrefold_fac
aurora_standard.hl7mshsend_fac
aurora_standard.hl7mshrec_fac
aurora_standard.hl7mshadsend_fac
aurora_standard.hl7mshadrec_fac
aurora_standard.hl7pd1pat_prim_fac
aurora_standard.hl7pd1adpat_prim_fac
aurora_standard.hl7pv1servicing_fac
aurora_standard.hl7pv1adservicing_fac
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