aurora_standard.chmutah7

Field Type Null Default Key Extra Comment
tax_id char(13) YES
visit_no char(17) YES MUL
mr_no char(17) YES
ssn char(9) YES
zip_1 char(5) YES
dob char(8) YES
gender char(1) YES
adm_dt char(6) YES
adm_src char(1) YES
dischg_status char(2) YES
dischg_dt char(6) YES
dx_version char(1) YES
prin_dx char(7) YES
dx01 char(7) YES
dx02 char(7) YES
dx03 char(7) YES
dx04 char(7) YES
dx05 char(7) YES
dx06 char(7) YES
dx07 char(7) YES
dx08 char(7) YES
cpt_prin_proc char(9) YES
cpt_proc01 char(9) YES
cpt_proc02 char(9) YES
cpt_proc03 char(9) YES
cpt_proc04 char(9) YES
cpt_proc05 char(9) YES
cpt_proc_date char(6) YES
prcode_method char(1) YES
stmnt_per char(12) YES
tot_charges char(9) YES
pri_payer char(25) YES
sec_payer char(25) YES
ter_payer char(25) YES
att_phy_id char(12) YES
oth_phy_id char(12) YES
tob char(3) YES
reason1 char(7) YES
reason2 char(7) YES
reason3 char(7) YES

References

Local Column References
ssn
TableColumn
Azalea.employeesemp_ssn
_1.chartschrt_ssn
_1.cpoe_responsescpoe_res_ssn
_1.encountersenc_ssn
_1.encountersenc_guarantor_ssn
_1.encountersenc_ins1_insured_ssn
_1.encountersenc_ins2_insured_ssn
_1.encountersenc_ins3_insured_ssn
_1.examplesexa_ssn
_1.hl7_accessionsacc_ssn
_1.insurances_repositoryirep_ins_insured_ssn
_1.non_patientsnpat_ssn
_1.ordersord_ssn
_1.patientspat_ssn
_1.patientspat_guarantor_ssn
_1.patientspat_ins1_insured_ssn
_1.patientspat_ins2_insured_ssn
_1.patientspat_ins3_insured_ssn
_1.patients_demographics_snapshotspds_ssn
_1.patients_demographics_snapshotspds_guarantor_ssn
_1.patients_demographics_snapshotspds_ins1_insured_ssn
_1.patients_demographics_snapshotspds_ins2_insured_ssn
_1.patients_demographics_snapshotspds_ins3_insured_ssn
_1.patients_responsibility_estimatesprest_ssn
_1.physiciansphy_ssn_federal_tax_id
_1.precertspre_ssn
_1.precertspre_guarantor_ssn
_1.precertspre_ins1_insured_ssn
_1.precertspre_ins2_insured_ssn
_1.radiology_ordersrad_ssn
_1.radiology_resultsrad_res_ssn
_1188.chartschrt_ssn
_1188.cpoe_responsescpoe_res_ssn
_1188.encountersenc_ssn
_1188.encountersenc_guarantor_ssn
_1188.encountersenc_ins1_insured_ssn
_1188.encountersenc_ins2_insured_ssn
_1188.encountersenc_ins3_insured_ssn
_1188.examplesexa_ssn
_1188.hl7_accessionsacc_ssn
_1188.insurances_repositoryirep_ins_insured_ssn
_1188.non_patientsnpat_ssn
_1188.ordersord_ssn
_1188.patientspat_ssn
_1188.patientspat_guarantor_ssn
_1188.patientspat_ins1_insured_ssn
_1188.patientspat_ins2_insured_ssn
_1188.patientspat_ins3_insured_ssn
_1188.patients_demographics_snapshotspds_ssn
_1188.patients_demographics_snapshotspds_guarantor_ssn
_1188.patients_demographics_snapshotspds_ins1_insured_ssn
_1188.patients_demographics_snapshotspds_ins2_insured_ssn
_1188.patients_demographics_snapshotspds_ins3_insured_ssn
_1188.patients_responsibility_estimatesprest_ssn
_1188.physiciansphy_ssn_federal_tax_id
_1188.precertspre_ssn
_1188.precertspre_guarantor_ssn
_1188.precertspre_ins1_insured_ssn
_1188.precertspre_ins2_insured_ssn
_1188.radiology_ordersrad_ssn
_1188.radiology_resultsrad_res_ssn
_1218.chartschrt_ssn
_1218.cpoe_responsescpoe_res_ssn
_1218.encountersenc_ssn
_1218.encountersenc_guarantor_ssn
_1218.encountersenc_ins1_insured_ssn
_1218.encountersenc_ins2_insured_ssn
_1218.encountersenc_ins3_insured_ssn
_1218.examplesexa_ssn
_1218.hl7_accessionsacc_ssn
_1218.insurances_repositoryirep_ins_insured_ssn
_1218.non_patientsnpat_ssn
_1218.ordersord_ssn
_1218.patientspat_ssn
_1218.patientspat_guarantor_ssn
_1218.patientspat_ins1_insured_ssn
_1218.patientspat_ins2_insured_ssn
_1218.patientspat_ins3_insured_ssn
_1218.patients_demographics_snapshotspds_ssn
_1218.patients_demographics_snapshotspds_guarantor_ssn
_1218.patients_demographics_snapshotspds_ins1_insured_ssn
_1218.patients_demographics_snapshotspds_ins2_insured_ssn
_1218.patients_demographics_snapshotspds_ins3_insured_ssn
_1218.patients_responsibility_estimatesprest_ssn
_1218.physiciansphy_ssn_federal_tax_id
_1218.precertspre_ssn
_1218.precertspre_guarantor_ssn
_1218.precertspre_ins1_insured_ssn
_1218.precertspre_ins2_insured_ssn
_1218.radiology_ordersrad_ssn
_1218.radiology_resultsrad_res_ssn
_1548.chartschrt_ssn
_1548.cpoe_responsescpoe_res_ssn
_1548.encountersenc_ssn
_1548.encountersenc_guarantor_ssn
_1548.encountersenc_ins1_insured_ssn
_1548.encountersenc_ins2_insured_ssn
_1548.encountersenc_ins3_insured_ssn
_1548.examplesexa_ssn
_1548.hl7_accessionsacc_ssn
_1548.insurances_repositoryirep_ins_insured_ssn
_1548.non_patientsnpat_ssn
_1548.ordersord_ssn
_1548.patientspat_ssn
_1548.patientspat_guarantor_ssn
_1548.patientspat_ins1_insured_ssn
_1548.patientspat_ins2_insured_ssn
_1548.patientspat_ins3_insured_ssn
_1548.patients_demographics_snapshotspds_ssn
_1548.patients_demographics_snapshotspds_guarantor_ssn
_1548.patients_demographics_snapshotspds_ins1_insured_ssn
_1548.patients_demographics_snapshotspds_ins2_insured_ssn
_1548.patients_demographics_snapshotspds_ins3_insured_ssn
_1548.patients_responsibility_estimatesprest_ssn
_1548.physiciansphy_ssn_federal_tax_id
_1548.precertspre_ssn
_1548.precertspre_guarantor_ssn
_1548.precertspre_ins1_insured_ssn
_1548.precertspre_ins2_insured_ssn
_1548.radiology_ordersrad_ssn
_1548.radiology_resultsrad_res_ssn
_435.chartschrt_ssn
_435.cpoe_responsescpoe_res_ssn
_435.encountersenc_ssn
_435.encountersenc_guarantor_ssn
_435.encountersenc_ins1_insured_ssn
_435.encountersenc_ins2_insured_ssn
_435.encountersenc_ins3_insured_ssn
_435.examplesexa_ssn
_435.hl7_accessionsacc_ssn
_435.insurances_repositoryirep_ins_insured_ssn
_435.non_patientsnpat_ssn
_435.ordersord_ssn
_435.patientspat_ssn
_435.patientspat_guarantor_ssn
_435.patientspat_ins1_insured_ssn
_435.patientspat_ins2_insured_ssn
_435.patientspat_ins3_insured_ssn
_435.patients_demographics_snapshotspds_ssn
_435.patients_demographics_snapshotspds_guarantor_ssn
_435.patients_demographics_snapshotspds_ins1_insured_ssn
_435.patients_demographics_snapshotspds_ins2_insured_ssn
_435.patients_demographics_snapshotspds_ins3_insured_ssn
_435.patients_responsibility_estimatesprest_ssn
_435.physiciansphy_ssn_federal_tax_id
_435.precertspre_ssn
_435.precertspre_guarantor_ssn
_435.precertspre_ins1_insured_ssn
_435.precertspre_ins2_insured_ssn
_435.radiology_ordersrad_ssn
_435.radiology_resultsrad_res_ssn
_436.chartschrt_ssn
_436.cpoe_responsescpoe_res_ssn
_436.encountersenc_ssn
_436.encountersenc_guarantor_ssn
_436.encountersenc_ins1_insured_ssn
_436.encountersenc_ins2_insured_ssn
_436.encountersenc_ins3_insured_ssn
_436.examplesexa_ssn
_436.hl7_accessionsacc_ssn
_436.insurances_repositoryirep_ins_insured_ssn
_436.non_patientsnpat_ssn
_436.ordersord_ssn
_436.patientspat_ssn
_436.patientspat_guarantor_ssn
_436.patientspat_ins1_insured_ssn
_436.patientspat_ins2_insured_ssn
_436.patientspat_ins3_insured_ssn
_436.patients_demographics_snapshotspds_ssn
_436.patients_demographics_snapshotspds_guarantor_ssn
_436.patients_demographics_snapshotspds_ins1_insured_ssn
_436.patients_demographics_snapshotspds_ins2_insured_ssn
_436.patients_demographics_snapshotspds_ins3_insured_ssn
_436.patients_responsibility_estimatesprest_ssn
_436.physiciansphy_ssn_federal_tax_id
_436.precertspre_ssn
_436.precertspre_guarantor_ssn
_436.precertspre_ins1_insured_ssn
_436.precertspre_ins2_insured_ssn
_436.radiology_ordersrad_ssn
_436.radiology_resultsrad_res_ssn
_436_archive_testing.chartschrt_ssn
_436_archive_testing.cpoe_responsescpoe_res_ssn
_436_archive_testing.encountersenc_ssn
_436_archive_testing.encountersenc_guarantor_ssn
_436_archive_testing.encountersenc_ins1_insured_ssn
_436_archive_testing.encountersenc_ins2_insured_ssn
_436_archive_testing.encountersenc_ins3_insured_ssn
_436_archive_testing.examplesexa_ssn
_436_archive_testing.hl7_accessionsacc_ssn
_436_archive_testing.insurances_repositoryirep_ins_insured_ssn
_436_archive_testing.non_patientsnpat_ssn
_436_archive_testing.ordersord_ssn
_436_archive_testing.patientspat_ssn
_436_archive_testing.patientspat_guarantor_ssn
_436_archive_testing.patientspat_ins1_insured_ssn
_436_archive_testing.patientspat_ins2_insured_ssn
_436_archive_testing.patientspat_ins3_insured_ssn
_436_archive_testing.patients_demographics_snapshotspds_ssn
_436_archive_testing.patients_demographics_snapshotspds_guarantor_ssn
_436_archive_testing.patients_demographics_snapshotspds_ins1_insured_ssn
_436_archive_testing.patients_demographics_snapshotspds_ins2_insured_ssn
_436_archive_testing.patients_demographics_snapshotspds_ins3_insured_ssn
_436_archive_testing.patients_responsibility_estimatesprest_ssn
_436_archive_testing.physiciansphy_ssn_federal_tax_id
_436_archive_testing.precertspre_ssn
_436_archive_testing.precertspre_guarantor_ssn
_436_archive_testing.precertspre_ins1_insured_ssn
_436_archive_testing.precertspre_ins2_insured_ssn
_436_archive_testing.radiology_ordersrad_ssn
_436_archive_testing.radiology_resultsrad_res_ssn
_437.chartschrt_ssn
_437.cpoe_responsescpoe_res_ssn
_437.encountersenc_ssn
_437.encountersenc_guarantor_ssn
_437.encountersenc_ins1_insured_ssn
_437.encountersenc_ins2_insured_ssn
_437.encountersenc_ins3_insured_ssn
_437.examplesexa_ssn
_437.hl7_accessionsacc_ssn
_437.insurances_repositoryirep_ins_insured_ssn
_437.non_patientsnpat_ssn
_437.ordersord_ssn
_437.patientspat_ssn
_437.patientspat_guarantor_ssn
_437.patientspat_ins1_insured_ssn
_437.patientspat_ins2_insured_ssn
_437.patientspat_ins3_insured_ssn
_437.patients_demographics_snapshotspds_ssn
_437.patients_demographics_snapshotspds_guarantor_ssn
_437.patients_demographics_snapshotspds_ins1_insured_ssn
_437.patients_demographics_snapshotspds_ins2_insured_ssn
_437.patients_demographics_snapshotspds_ins3_insured_ssn
_437.patients_responsibility_estimatesprest_ssn
_437.physiciansphy_ssn_federal_tax_id
_437.precertspre_ssn
_437.precertspre_guarantor_ssn
_437.precertspre_ins1_insured_ssn
_437.precertspre_ins2_insured_ssn
_437.radiology_ordersrad_ssn
_437.radiology_resultsrad_res_ssn
_8.chartschrt_ssn
_8.cpoe_responsescpoe_res_ssn
_8.encountersenc_ssn
_8.encountersenc_guarantor_ssn
_8.encountersenc_ins1_insured_ssn
_8.encountersenc_ins2_insured_ssn
_8.encountersenc_ins3_insured_ssn
_8.examplesexa_ssn
_8.hl7_accessionsacc_ssn
_8.insurances_repositoryirep_ins_insured_ssn
_8.non_patientsnpat_ssn
_8.ordersord_ssn
_8.patientspat_ssn
_8.patientspat_guarantor_ssn
_8.patientspat_ins1_insured_ssn
_8.patientspat_ins2_insured_ssn
_8.patientspat_ins3_insured_ssn
_8.patients_demographics_snapshotspds_ssn
_8.patients_demographics_snapshotspds_guarantor_ssn
_8.patients_demographics_snapshotspds_ins1_insured_ssn
_8.patients_demographics_snapshotspds_ins2_insured_ssn
_8.patients_demographics_snapshotspds_ins3_insured_ssn
_8.patients_responsibility_estimatesprest_ssn
_8.physiciansphy_ssn_federal_tax_id
_8.precertspre_ssn
_8.precertspre_guarantor_ssn
_8.precertspre_ins1_insured_ssn
_8.precertspre_ins2_insured_ssn
_8.radiology_ordersrad_ssn
_8.radiology_resultsrad_res_ssn
_81.chartschrt_ssn
_81.cpoe_responsescpoe_res_ssn
_81.encountersenc_ssn
_81.encountersenc_guarantor_ssn
_81.encountersenc_ins1_insured_ssn
_81.encountersenc_ins2_insured_ssn
_81.encountersenc_ins3_insured_ssn
_81.examplesexa_ssn
_81.hl7_accessionsacc_ssn
_81.insurances_repositoryirep_ins_insured_ssn
_81.non_patientsnpat_ssn
_81.ordersord_ssn
_81.patientspat_ssn
_81.patientspat_guarantor_ssn
_81.patientspat_ins1_insured_ssn
_81.patientspat_ins2_insured_ssn
_81.patientspat_ins3_insured_ssn
_81.patients_demographics_snapshotspds_ssn
_81.patients_demographics_snapshotspds_guarantor_ssn
_81.patients_demographics_snapshotspds_ins1_insured_ssn
_81.patients_demographics_snapshotspds_ins2_insured_ssn
_81.patients_demographics_snapshotspds_ins3_insured_ssn
_81.patients_responsibility_estimatesprest_ssn
_81.physiciansphy_ssn_federal_tax_id
_81.precertspre_ssn
_81.precertspre_guarantor_ssn
_81.precertspre_ins1_insured_ssn
_81.precertspre_ins2_insured_ssn
_81.radiology_ordersrad_ssn
_81.radiology_resultsrad_res_ssn
_999.chartschrt_ssn
_999.cpoe_responsescpoe_res_ssn
_999.encountersenc_ssn
_999.encountersenc_guarantor_ssn
_999.encountersenc_ins1_insured_ssn
_999.encountersenc_ins2_insured_ssn
_999.encountersenc_ins3_insured_ssn
_999.examplesexa_ssn
_999.hl7_accessionsacc_ssn
_999.insurances_repositoryirep_ins_insured_ssn
_999.non_patientsnpat_ssn
_999.ordersord_ssn
_999.patientspat_ssn
_999.patientspat_guarantor_ssn
_999.patientspat_ins1_insured_ssn
_999.patientspat_ins2_insured_ssn
_999.patientspat_ins3_insured_ssn
_999.patients_demographics_snapshotspds_ssn
_999.patients_demographics_snapshotspds_guarantor_ssn
_999.patients_demographics_snapshotspds_ins1_insured_ssn
_999.patients_demographics_snapshotspds_ins2_insured_ssn
_999.patients_demographics_snapshotspds_ins3_insured_ssn
_999.patients_responsibility_estimatesprest_ssn
_999.physiciansphy_ssn_federal_tax_id
_999.precertspre_ssn
_999.precertspre_guarantor_ssn
_999.precertspre_ins1_insured_ssn
_999.precertspre_ins2_insured_ssn
_999.radiology_ordersrad_ssn
_999.radiology_resultsrad_res_ssn
aurora_standard.abmmpigu_ssn
aurora_standard.abmvisgu_ssn
aurora_standard.adupguguar_ssn
aurora_standard.aswguarguar_ssn
aurora_standard.b2baddp_ssn
aurora_standard.b2mrdrp_ssn
aurora_standard.bdallvispat_ssn
aurora_standard.bdguarguar_ssn
aurora_standard.bdmpip_ssn
aurora_standard.bdmpisp_ssn
aurora_standard.bdvispat_ssn
aurora_standard.bevisp_ssn
aurora_standard.bevisbdp_ssn
aurora_standard.bevisbd2p_ssn
aurora_standard.bharp_ssn
aurora_standard.bharnew_ssn
aurora_standard.bharg_ssn
aurora_standard.bhbaddp_ssn
aurora_standard.bhguarguar_ssn
aurora_standard.bhldgrp_ssn
aurora_standard.bhldgrguar_ssn
aurora_standard.bhmrdrp_ssn
aurora_standard.bhppatp_ssn
aurora_standard.bhtguarguar_ssn
aurora_standard.bhtldgrp_ssn
aurora_standard.bhtldgrguar_ssn
aurora_standard.bhtmrdrp_ssn
aurora_standard.bhtppatp_ssn
aurora_standard.bmguarguar_ssn
aurora_standard.bmmpip_ssn
aurora_standard.bmnkinn_ssn
aurora_standard.bmpactp_ssn
aurora_standard.bmpatp_ssn
aurora_standard.bparp_ssn
aurora_standard.bparnew_ssn
aurora_standard.bparg_ssn
aurora_standard.bpar2p_ssn
aurora_standard.bpar2new_ssn
aurora_standard.bpar2g_ssn
aurora_standard.bpmpip_ssn
aurora_standard.bpmpi2p_ssn
aurora_standard.bpmrp_ssn
aurora_standard.bpmr2p_ssn
aurora_standard.bsguarguar_ssn
aurora_standard.bsinsurspouse_ssn
aurora_standard.bsvispat_ssn
aurora_standard.bsvisbdpat_ssn
aurora_standard.bvguargu_ssn
aurora_standard.bvmpip_ssn
aurora_standard.bvmpi2p_ssn
aurora_standard.c7guarrguar_ssn
aurora_standard.c7mpip_ssn
aurora_standard.c7mpigu_ssn
aurora_standard.c7vispat_ssn
aurora_standard.c8dtlsp_ssn
aurora_standard.c8guarguar_ssn
aurora_standard.c8guar2guar_ssn
aurora_standard.c9mpip_ssn
aurora_standard.c9visp_ssn
aurora_standard.cafcpat_ssn
aurora_standard.caguarrguar_ssn
aurora_standard.campispouse_ssn
aurora_standard.cavispat_ssn
aurora_standard.cavishpat_ssn
aurora_standard.chhl7in2ins_ssn
aurora_standard.chlmdssdprev_ssn
aurora_standard.chltrnsdprev_ssn
aurora_standard.chmarcnbfg_ssn
aurora_standard.chmarcnbfp_ssn
aurora_standard.chmarsipat_ssn
aurora_standard.chmarsigu_ssn
aurora_standard.chmarsisp_ssn
aurora_standard.chmazstdpat_ssn
aurora_standard.chmazstipat_ssn
aurora_standard.chmazstopat_ssn
aurora_standard.chmcampipat_ssn
aurora_standard.chmcampigu_ssn
aurora_standard.chmcampisp_ssn
aurora_standard.chmcmheddebtor_1_ssn
aurora_standard.chmcmheddebtor_2_ssn
aurora_standard.chmcmhedpat_ssn
aurora_standard.chmcssndnew_ssn
aurora_standard.chmcssndold_ssn
aurora_standard.chmexmpipat_ssn
aurora_standard.chmexmpigu_ssn
aurora_standard.chmexmpisp_ssn
aurora_standard.chmexvispat_ssn
aurora_standard.chmguarrguar_ssn
aurora_standard.chmhistpp_ssn
aurora_standard.chmlastrpat_ssn
aurora_standard.chmmhastpat_ssn
aurora_standard.chmokipdpat_ssn
aurora_standard.chmokopdpat_ssn
aurora_standard.chmopercauto_ssn
aurora_standard.chmozpcddebtor_1_ssn
aurora_standard.chmozpcddebtor_2_ssn
aurora_standard.chmpatmrspouse_ssn
aurora_standard.chmpatwcmom_ssn
aurora_standard.chmpatwcdad_ssn
aurora_standard.chmpdemop_ssn
aurora_standard.chmpdemosp_ssn
aurora_standard.chmpdemogu_ssn
aurora_standard.chmradexpat_ssn
aurora_standard.chmradexgu_ssn
aurora_standard.chmradexsp_ssn
aurora_standard.chmtxstrpat_ssn
aurora_standard.chpcobdddep_ssn
aurora_standard.chpdepeddepend_ssn
aurora_standard.chpempddperson_ssn
aurora_standard.chxcntrcid_is_ssn
aurora_standard.hl7gt1guar_ssn
aurora_standard.hl7gt1adguar_ssn
aurora_standard.hl7in2ins_ssn
aurora_standard.hl7in2adins_ssn
aurora_standard.hl7pidpat_ssn
aurora_standard.hl7pidadpat_ssn
aurora_standard.kcvispat_ssn
aurora_standard.kcvisitpat_ssn
aurora_standard.nbspousespouse_ssn
aurora_standard.ncexmpipat_ssn
aurora_standard.oddpayddempl_ssn
aurora_standard.oddpayidempl_ssn
aurora_standard.oddpayodempl_ssn
aurora_standard.oddpayreempl_ssn
aurora_standard.odhpayddempl_ssn
aurora_standard.odhpayidempl_ssn
aurora_standard.odhpayodempl_ssn
aurora_standard.odhpayreempl_ssn
aurora_standard.styoempddepend_ssn
common.customerscus_require_ssn
gender
TableColumn
Azalea.employeesemp_gender
_1.systems_componentsscmp_gender
_1188.systems_componentsscmp_gender
_1218.systems_componentsscmp_gender
_1548.systems_componentsscmp_gender
_435.systems_componentsscmp_gender
_436.systems_componentsscmp_gender
_436_archive_testing.systems_componentsscmp_gender
_437.systems_componentsscmp_gender
_8.systems_componentsscmp_gender
_81.systems_componentsscmp_gender
_999.systems_componentsscmp_gender
aurora_standard.chmclaimpat_gender
template_library.systems_componentsscmp_gender
tax_id
TableColumn
_1.billing_providersbp_federal_tax_id
_1.locationsloc_tax_id
_1.physiciansphy_federal_tax_id
_1188.billing_providersbp_federal_tax_id
_1188.locationsloc_tax_id
_1188.physiciansphy_federal_tax_id
_1218.billing_providersbp_federal_tax_id
_1218.locationsloc_tax_id
_1218.physiciansphy_federal_tax_id
_1548.billing_providersbp_federal_tax_id
_1548.locationsloc_tax_id
_1548.physiciansphy_federal_tax_id
_435.billing_providersbp_federal_tax_id
_435.locationsloc_tax_id
_435.physiciansphy_federal_tax_id
_436.billing_providersbp_federal_tax_id
_436.locationsloc_tax_id
_436.physiciansphy_federal_tax_id
_436_archive_testing.billing_providersbp_federal_tax_id
_436_archive_testing.locationsloc_tax_id
_436_archive_testing.physiciansphy_federal_tax_id
_437.billing_providersbp_federal_tax_id
_437.locationsloc_tax_id
_437.physiciansphy_federal_tax_id
_8.billing_providersbp_federal_tax_id
_8.locationsloc_tax_id
_8.physiciansphy_federal_tax_id
_81.billing_providersbp_federal_tax_id
_81.locationsloc_tax_id
_81.physiciansphy_federal_tax_id
_999.billing_providersbp_federal_tax_id
_999.locationsloc_tax_id
_999.physiciansphy_federal_tax_id
aurora_standard.chmcostafed_tax_id
aurora_standard.chmhid4afed_tax_id
aurora_standard.stpcntrcfederal_tax_id
aurora_standard.stpvendrfederal_tax_id
common.clientscli_federal_tax_id
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
adm_dt
TableColumn
aurora_standard.acampilast_adm_dt
aurora_standard.bhppatlast_adm_dt
aurora_standard.bhtppatlast_adm_dt
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
zip_1
TableColumn
aurora_standard.bdmpisp_zip_1
aurora_standard.bdmpink_zip_1
aurora_standard.bdmpipat_zip_1
aurora_standard.bsinsurspouse_zip_1
aurora_standard.bsinsurnextkin_zip_1
aurora_standard.bsinsurpatient_zip_1
aurora_standard.campispouse_zip_1
aurora_standard.campinextkin_zip_1
aurora_standard.campipatient_zip_1
aurora_standard.chhl7adtpatient_zip_1
aurora_standard.chhl7in1ins_zip_1
aurora_standard.chhl7in1ins_empl_zip_1
aurora_standard.chmp340bpatient_zip_1
aurora_standard.chmpatirsubscri_zip_1
aurora_standard.chmpatmrspouse_zip_1
aurora_standard.chmpatmrnextkin_zip_1
aurora_standard.chmpatmrpatient_zip_1
aurora_standard.chmpresspatient_zip_1
aurora_standard.nbspousespouse_zip_1
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
prin_dx
TableColumn
aurora_standard.chmmhastpoa_prin_dx
dischg_dt
TableColumn
aurora_standard.chmmhatrbegin_dischg_dt
aurora_standard.chmmhatrend_dischg_dt
adm_src
TableColumn
aurora_standard.chmstatcdef_adm_src