aurora_standard.chmarbex

Field Type Null Default Key Extra Comment
last_name char(30) YES
first_name char(20) YES
pat_age char(3) YES
pat_sex char(1) YES
phone char(10) YES
pat_zip1 char(5) YES
pri_fc char(2) YES
dis_dt char(8) YES
pat_status char(3) YES
adm_src char(1) YES
dis_status char(2) YES
drg char(3) YES
adm_dt char(8) YES
pat_mr_no char(20) YES

References

Local Column References
phone
TableColumn
Azalea.employeesemp_phone
EFaxes.efax_accountsefaxacc_phone
_1.billing_providersbp_phone
_1.chartschrt_phone
_1.client_contactsclicon_primary_phone
_1.cpoe_responsescpoe_res_phone
_1.donorsdon_phone
_1.encountersenc_phone
_1.encountersenc_guarantor_phone
_1.examplesexa_phone
_1.hl7_accessionsacc_phone
_1.hl7_lab_locationshll_phone
_1.insurancesins_phone
_1.insurances_claims_centersicc_phone
_1.locationsloc_phone
_1.non_patientsnpat_phone
_1.ordersord_phone
_1.patient_next_of_kinpnk_phone
_1.patientspat_phone
_1.patientspat_guarantor_phone
_1.patients_demographics_snapshotspds_phone
_1.patients_demographics_snapshotspds_guarantor_phone
_1.physiciansphy_phone
_1.precertspre_phone
_1.precertspre_guarantor_phone
_1.radiology_ordersrad_phone
_1.radiology_resultsrad_res_phone
_1188.billing_providersbp_phone
_1188.chartschrt_phone
_1188.client_contactsclicon_primary_phone
_1188.cpoe_responsescpoe_res_phone
_1188.donorsdon_phone
_1188.encountersenc_phone
_1188.encountersenc_guarantor_phone
_1188.examplesexa_phone
_1188.hl7_accessionsacc_phone
_1188.hl7_lab_locationshll_phone
_1188.insurancesins_phone
_1188.insurances_claims_centersicc_phone
_1188.locationsloc_phone
_1188.non_patientsnpat_phone
_1188.ordersord_phone
_1188.patient_next_of_kinpnk_phone
_1188.patientspat_phone
_1188.patientspat_guarantor_phone
_1188.patients_demographics_snapshotspds_phone
_1188.patients_demographics_snapshotspds_guarantor_phone
_1188.physiciansphy_phone
_1188.precertspre_phone
_1188.precertspre_guarantor_phone
_1188.radiology_ordersrad_phone
_1188.radiology_resultsrad_res_phone
_1218.billing_providersbp_phone
_1218.chartschrt_phone
_1218.client_contactsclicon_primary_phone
_1218.cpoe_responsescpoe_res_phone
_1218.donorsdon_phone
_1218.encountersenc_phone
_1218.encountersenc_guarantor_phone
_1218.examplesexa_phone
_1218.hl7_accessionsacc_phone
_1218.hl7_lab_locationshll_phone
_1218.insurancesins_phone
_1218.insurances_claims_centersicc_phone
_1218.locationsloc_phone
_1218.non_patientsnpat_phone
_1218.ordersord_phone
_1218.patient_next_of_kinpnk_phone
_1218.patientspat_phone
_1218.patientspat_guarantor_phone
_1218.patients_demographics_snapshotspds_phone
_1218.patients_demographics_snapshotspds_guarantor_phone
_1218.physiciansphy_phone
_1218.precertspre_phone
_1218.precertspre_guarantor_phone
_1218.radiology_ordersrad_phone
_1218.radiology_resultsrad_res_phone
_1548.billing_providersbp_phone
_1548.chartschrt_phone
_1548.client_contactsclicon_primary_phone
_1548.cpoe_responsescpoe_res_phone
_1548.donorsdon_phone
_1548.encountersenc_phone
_1548.encountersenc_guarantor_phone
_1548.examplesexa_phone
_1548.hl7_accessionsacc_phone
_1548.hl7_lab_locationshll_phone
_1548.insurancesins_phone
_1548.insurances_claims_centersicc_phone
_1548.locationsloc_phone
_1548.non_patientsnpat_phone
_1548.ordersord_phone
_1548.patient_next_of_kinpnk_phone
_1548.patientspat_phone
_1548.patientspat_guarantor_phone
_1548.patients_demographics_snapshotspds_phone
_1548.patients_demographics_snapshotspds_guarantor_phone
_1548.physiciansphy_phone
_1548.precertspre_phone
_1548.precertspre_guarantor_phone
_1548.radiology_ordersrad_phone
_1548.radiology_resultsrad_res_phone
_435.billing_providersbp_phone
_435.chartschrt_phone
_435.client_contactsclicon_primary_phone
_435.cpoe_responsescpoe_res_phone
_435.donorsdon_phone
_435.encountersenc_phone
_435.encountersenc_guarantor_phone
_435.examplesexa_phone
_435.hl7_accessionsacc_phone
_435.hl7_lab_locationshll_phone
_435.insurancesins_phone
_435.insurances_claims_centersicc_phone
_435.locationsloc_phone
_435.non_patientsnpat_phone
_435.ordersord_phone
_435.patient_next_of_kinpnk_phone
_435.patientspat_phone
_435.patientspat_guarantor_phone
_435.patients_demographics_snapshotspds_phone
_435.patients_demographics_snapshotspds_guarantor_phone
_435.physiciansphy_phone
_435.precertspre_phone
_435.precertspre_guarantor_phone
_435.radiology_ordersrad_phone
_435.radiology_resultsrad_res_phone
_436.billing_providersbp_phone
_436.chartschrt_phone
_436.client_contactsclicon_primary_phone
_436.cpoe_responsescpoe_res_phone
_436.donorsdon_phone
_436.encountersenc_phone
_436.encountersenc_guarantor_phone
_436.examplesexa_phone
_436.hl7_accessionsacc_phone
_436.hl7_lab_locationshll_phone
_436.insurancesins_phone
_436.insurances_claims_centersicc_phone
_436.locationsloc_phone
_436.non_patientsnpat_phone
_436.ordersord_phone
_436.patient_next_of_kinpnk_phone
_436.patientspat_phone
_436.patientspat_guarantor_phone
_436.patients_demographics_snapshotspds_phone
_436.patients_demographics_snapshotspds_guarantor_phone
_436.physiciansphy_phone
_436.precertspre_phone
_436.precertspre_guarantor_phone
_436.radiology_ordersrad_phone
_436.radiology_resultsrad_res_phone
_436_archive_testing.billing_providersbp_phone
_436_archive_testing.chartschrt_phone
_436_archive_testing.client_contactsclicon_primary_phone
_436_archive_testing.cpoe_responsescpoe_res_phone
_436_archive_testing.donorsdon_phone
_436_archive_testing.encountersenc_phone
_436_archive_testing.encountersenc_guarantor_phone
_436_archive_testing.examplesexa_phone
_436_archive_testing.hl7_accessionsacc_phone
_436_archive_testing.hl7_lab_locationshll_phone
_436_archive_testing.insurancesins_phone
_436_archive_testing.insurances_claims_centersicc_phone
_436_archive_testing.locationsloc_phone
_436_archive_testing.non_patientsnpat_phone
_436_archive_testing.ordersord_phone
_436_archive_testing.patient_next_of_kinpnk_phone
_436_archive_testing.patientspat_phone
_436_archive_testing.patientspat_guarantor_phone
_436_archive_testing.patients_demographics_snapshotspds_phone
_436_archive_testing.patients_demographics_snapshotspds_guarantor_phone
_436_archive_testing.physiciansphy_phone
_436_archive_testing.precertspre_phone
_436_archive_testing.precertspre_guarantor_phone
_436_archive_testing.radiology_ordersrad_phone
_436_archive_testing.radiology_resultsrad_res_phone
_437.billing_providersbp_phone
_437.chartschrt_phone
_437.client_contactsclicon_primary_phone
_437.cpoe_responsescpoe_res_phone
_437.donorsdon_phone
_437.encountersenc_phone
_437.encountersenc_guarantor_phone
_437.examplesexa_phone
_437.hl7_accessionsacc_phone
_437.hl7_lab_locationshll_phone
_437.insurancesins_phone
_437.insurances_claims_centersicc_phone
_437.locationsloc_phone
_437.non_patientsnpat_phone
_437.ordersord_phone
_437.patient_next_of_kinpnk_phone
_437.patientspat_phone
_437.patientspat_guarantor_phone
_437.patients_demographics_snapshotspds_phone
_437.patients_demographics_snapshotspds_guarantor_phone
_437.physiciansphy_phone
_437.precertspre_phone
_437.precertspre_guarantor_phone
_437.radiology_ordersrad_phone
_437.radiology_resultsrad_res_phone
_8.billing_providersbp_phone
_8.chartschrt_phone
_8.client_contactsclicon_primary_phone
_8.cpoe_responsescpoe_res_phone
_8.donorsdon_phone
_8.encountersenc_phone
_8.encountersenc_guarantor_phone
_8.examplesexa_phone
_8.hl7_accessionsacc_phone
_8.hl7_lab_locationshll_phone
_8.insurancesins_phone
_8.insurances_claims_centersicc_phone
_8.locationsloc_phone
_8.non_patientsnpat_phone
_8.ordersord_phone
_8.patient_next_of_kinpnk_phone
_8.patientspat_phone
_8.patientspat_guarantor_phone
_8.patients_demographics_snapshotspds_phone
_8.patients_demographics_snapshotspds_guarantor_phone
_8.physiciansphy_phone
_8.precertspre_phone
_8.precertspre_guarantor_phone
_8.radiology_ordersrad_phone
_8.radiology_resultsrad_res_phone
_81.billing_providersbp_phone
_81.chartschrt_phone
_81.client_contactsclicon_primary_phone
_81.cpoe_responsescpoe_res_phone
_81.donorsdon_phone
_81.encountersenc_phone
_81.encountersenc_guarantor_phone
_81.examplesexa_phone
_81.hl7_accessionsacc_phone
_81.hl7_lab_locationshll_phone
_81.insurancesins_phone
_81.insurances_claims_centersicc_phone
_81.locationsloc_phone
_81.non_patientsnpat_phone
_81.ordersord_phone
_81.patient_next_of_kinpnk_phone
_81.patientspat_phone
_81.patientspat_guarantor_phone
_81.patients_demographics_snapshotspds_phone
_81.patients_demographics_snapshotspds_guarantor_phone
_81.physiciansphy_phone
_81.precertspre_phone
_81.precertspre_guarantor_phone
_81.radiology_ordersrad_phone
_81.radiology_resultsrad_res_phone
_999.billing_providersbp_phone
_999.chartschrt_phone
_999.client_contactsclicon_primary_phone
_999.cpoe_responsescpoe_res_phone
_999.donorsdon_phone
_999.encountersenc_phone
_999.encountersenc_guarantor_phone
_999.examplesexa_phone
_999.hl7_accessionsacc_phone
_999.hl7_lab_locationshll_phone
_999.insurancesins_phone
_999.insurances_claims_centersicc_phone
_999.locationsloc_phone
_999.non_patientsnpat_phone
_999.ordersord_phone
_999.patient_next_of_kinpnk_phone
_999.patientspat_phone
_999.patientspat_guarantor_phone
_999.patients_demographics_snapshotspds_phone
_999.patients_demographics_snapshotspds_guarantor_phone
_999.physiciansphy_phone
_999.precertspre_phone
_999.precertspre_guarantor_phone
_999.radiology_ordersrad_phone
_999.radiology_resultsrad_res_phone
aurora_standard.bdmpisp_phone
aurora_standard.bfinsrcprecert_phone
aurora_standard.bfrhcgu_phone
aurora_standard.bharp_phone
aurora_standard.bharg_phone
aurora_standard.bharge_phone
aurora_standard.bharem_phone
aurora_standard.bhguaremp_phone
aurora_standard.bhphybakhome_phone
aurora_standard.bhphybakoffice_phone
aurora_standard.bhphybakcellular_phone
aurora_standard.bhphybakpage_phone
aurora_standard.bhtguaremp_phone
aurora_standard.bmmpip_phone
aurora_standard.bmnkinn_phone
aurora_standard.bmnkinnw_phone
aurora_standard.bmnkinnc_phone
aurora_standard.bmpactp_phone
aurora_standard.bparp_phone
aurora_standard.bparg_phone
aurora_standard.bparge_phone
aurora_standard.bparem_phone
aurora_standard.bpar2p_phone
aurora_standard.bpar2g_phone
aurora_standard.bpar2ge_phone
aurora_standard.bpar2em_phone
aurora_standard.bpmpip_phone
aurora_standard.bpmpi2p_phone
aurora_standard.bsinsurspouse_phone
aurora_standard.bsinsurnextkin_phone
aurora_standard.bsinsurpatient_phone
aurora_standard.bsinsurpat_emp_phone
aurora_standard.bsinsurpat_cell_phone
aurora_standard.bsinsursp_cell_phone
aurora_standard.bsinsurnk_cell_phone
aurora_standard.bvguarwork_phone
aurora_standard.bvmpiwork_phone
aurora_standard.bvmpi2work_phone
aurora_standard.bwphyncoffice_phone
aurora_standard.c5insrcprecert_phone
aurora_standard.c5insrcdrprecert_phone
aurora_standard.c7insur2ins_phone
aurora_standard.c7insur3ins_phone
aurora_standard.c8mpip_phone
aurora_standard.c8phyhome_phone
aurora_standard.c8phyoffice_phone
aurora_standard.c8phycellular_phone
aurora_standard.c8phypage_phone
aurora_standard.cainsrcprecert_phone
aurora_standard.cainsrc2precert_phone
aurora_standard.campispouse_phone
aurora_standard.campisp_cell_phone
aurora_standard.campinextkin_phone
aurora_standard.campink_cell_phone
aurora_standard.campipatient_phone
aurora_standard.campipat_emp_phone
aurora_standard.campipat_cell_phone
aurora_standard.caphyoffice_phone
aurora_standard.caphynchm_phone
aurora_standard.caphyncwk_phone
aurora_standard.caphynccell_phone
aurora_standard.chlswbhdfac_phone
aurora_standard.chlswbhdagt_phone
aurora_standard.chlswbhdsfw_phone
aurora_standard.chltrnhdfac_phone
aurora_standard.chltrnhdagt_phone
aurora_standard.chltrnhdsfw_phone
aurora_standard.chmadmwcref_phone
aurora_standard.chmarcnbfg_phone
aurora_standard.chmarcnbfg_emp_phone
aurora_standard.chmarcnbfins1_phone
aurora_standard.chmarcnbfins2_phone
aurora_standard.chmarsipat_phone
aurora_standard.chmarsigu_phone
aurora_standard.chmarsipat_emp_phone
aurora_standard.chmarsisp_phone
aurora_standard.chmarstfac_phone
aurora_standard.chmarstifac_phone
aurora_standard.chmcampipat_phone
aurora_standard.chmcampigu_phone
aurora_standard.chmcampipat_emp_phone
aurora_standard.chmcampisp_phone
aurora_standard.chmcmheddebtor_phone
aurora_standard.chmcmhedpat_phone
aurora_standard.chmcostapat_phone
aurora_standard.chmemplrother_phone
aurora_standard.chmescptcontact_phone
aurora_standard.chmexmpipat_phone
aurora_standard.chmexmpigu_phone
aurora_standard.chmexmpipat_emp_phone
aurora_standard.chmexmpisp_phone
aurora_standard.chmguarrgu_emp_phone
aurora_standard.chmhistpp_phone
aurora_standard.chmhl7iccompany_phone
aurora_standard.chminsrcprecert_phone
aurora_standard.chmnvstbprov_phone
aurora_standard.chmnvstrprov_phone
aurora_standard.chmozpcddebtor_phone
aurora_standard.chmozpcdbank_phone
aurora_standard.chmpatmrspouse_phone
aurora_standard.chmpatmrnextkin_phone
aurora_standard.chmpatmrpatient_phone
aurora_standard.chmpatmrpat_emp_phone
aurora_standard.chmpatmrpat_cell_phone
aurora_standard.chmpatmrsp_cell_phone
aurora_standard.chmpatmrnk_cell_phone
aurora_standard.chmpatwcmom_phone
aurora_standard.chmpatwcdad_phone
aurora_standard.chmpdemop_phone
aurora_standard.chmpdemop_emp_phone
aurora_standard.chmpdemosp_phone
aurora_standard.chmpdemogu_phone
aurora_standard.chmpdemoins1_phone
aurora_standard.chmpdemoins2_phone
aurora_standard.chmpdemoins3_phone
aurora_standard.chmphynchome_phone
aurora_standard.chmphyncoffice_phone
aurora_standard.chmphynccellular_phone
aurora_standard.chmphyncpage_phone
aurora_standard.chmradexpat_phone
aurora_standard.chmradexpat_emp_phone
aurora_standard.chmradexgu_phone
aurora_standard.chmradexsp_phone
aurora_standard.chpcardccontact_phone
aurora_standard.chpcarddcontact_phone
aurora_standard.chpcempron_call_phone
aurora_standard.chpcntrceduc_phone
aurora_standard.chpemerdwork_phone
aurora_standard.chpemerdhome_phone
aurora_standard.chpemerdother_phone
aurora_standard.chpinsucprecert_phone
aurora_standard.chppersron_call_phone
aurora_standard.chppersrcell_phone
aurora_standard.chshotlrother_phone
aurora_standard.cuphynchome_phone
aurora_standard.cuphyncoffice_phone
aurora_standard.nbspousespouse_phone
aurora_standard.ohoemplrhome_phone
aurora_standard.stp1099ccontact_phone
aurora_standard.stp1099cvend_phone
aurora_standard.stppytorfax_phone
aurora_standard.stprepsdrep_phone
aurora_standard.stpvendrfax_phone
aurora_standard.stpvendragent_phone
aurora_standard.strcustrfax_phone
aurora_standard.styoctcccontact_phone
aurora_standard.styoctccgov_entity_contact_phone
aurora_standard.styuimmrcont_phone
aurora_standard.styw2mm1cont_phone
aurora_standard.vault_providershome_phone
aurora_standard.vault_providersoffice_phone
aurora_standard.vault_providerscell_phone
common.applicantsapp_phone
common.applicantsapp_cell_phone
common.applicantsapp_employer_1_phone
common.applicantsapp_employer_2_phone
common.applicantsapp_employer_3_phone
common.applicantsapp_employer_4_phone
common.applicantsapp_reference_1_phone
common.applicantsapp_reference_2_phone
common.applicantsapp_reference_3_phone
common.applicantsapp_reference_4_phone
common.clients_contract_dataccd_payer_phone
common.contact_importsci_phone
common.fax_accountsfxa_phone
common.lab_interfaces_performing_siteslips_phone
common.leadslea_phone
common.sfax_accountssfax_acc_phone
common.usersusr_cell_phone
rcmroi.dev__sf_usersmobile_phone
rcmroi.prod__sf_usersmobile_phone
rcmroi.test__sf_usersmobile_phone
pat_sex
TableColumn
_1.clinical_alertsca_pat_sex
_1.clinical_interventionsci_pat_sex
_1188.clinical_alertsca_pat_sex
_1188.clinical_interventionsci_pat_sex
_1218.clinical_alertsca_pat_sex
_1218.clinical_interventionsci_pat_sex
_1548.clinical_alertsca_pat_sex
_1548.clinical_interventionsci_pat_sex
_435.clinical_alertsca_pat_sex
_435.clinical_interventionsci_pat_sex
_436.clinical_alertsca_pat_sex
_436.clinical_interventionsci_pat_sex
_436_archive_testing.clinical_alertsca_pat_sex
_436_archive_testing.clinical_interventionsci_pat_sex
_437.clinical_alertsca_pat_sex
_437.clinical_interventionsci_pat_sex
_8.clinical_alertsca_pat_sex
_8.clinical_interventionsci_pat_sex
_81.clinical_alertsca_pat_sex
_81.clinical_interventionsci_pat_sex
_999.clinical_alertsca_pat_sex
_999.clinical_interventionsci_pat_sex
pat_age
TableColumn
_1.clinical_alertsca_pat_age
_1188.clinical_alertsca_pat_age
_1218.clinical_alertsca_pat_age
_1548.clinical_alertsca_pat_age
_435.clinical_alertsca_pat_age
_436.clinical_alertsca_pat_age
_436_archive_testing.clinical_alertsca_pat_age
_437.clinical_alertsca_pat_age
_8.clinical_alertsca_pat_age
_81.clinical_alertsca_pat_age
_999.clinical_alertsca_pat_age
drg
TableColumn
aurora_standard.abshl7di9_drg
aurora_standard.chmabstrest_drg
aurora_standard.chmabstractual_drg
aurora_standard.chmclaimfin_drg
aurora_standard.chmclaimms_drg
aurora_standard.chmcostams_drg
aurora_standard.chmhidiaest_drg
aurora_standard.chmpresgms_drg
aurora_standard.chmpresg2ms_drg
aurora_standard.chmvtotdest_drg
aurora_standard.drg_workw_drg
aurora_standard.logdetldest_drg
aurora_standard.ohocptcpt_drg
aurora_standard.workdescw_drg
adm_dt
TableColumn
aurora_standard.acampilast_adm_dt
aurora_standard.bhppatlast_adm_dt
aurora_standard.bhtppatlast_adm_dt
last_name
TableColumn
aurora_standard.c7insur2p_last_name
aurora_standard.c7insur3p_last_name
aurora_standard.chm1500rpat_last_name
aurora_standard.chmcmhedpat_last_name
aurora_standard.chmstmtdg_last_name
first_name
TableColumn
aurora_standard.c7insur2p_first_name
aurora_standard.c7insur3p_first_name
aurora_standard.chm1500rpat_first_name
aurora_standard.chmcmhedpat_first_name
aurora_standard.chmstmtdg_first_name
pat_status
TableColumn
aurora_standard.chmgltcda_pat_status
aurora_standard.chmgltcdb_pat_status
aurora_standard.chmpricaprev_pat_status
aurora_standard.chmpricacur_pat_status
adm_src
TableColumn
aurora_standard.chmstatcdef_adm_src