aurora_standard.chxleasr

Field Type Null Default Key Extra Comment
acct_no varchar(20) YES MUL
id_no varchar(20) YES
req_seq smallint(6) YES
req_date date YES
req_time time YES
last_name varchar(20) YES
first_name varchar(20) YES
mid_name varchar(20) YES
dob date YES
sex varchar(1) YES
allergies varchar(70) YES
check_in time YES
check_out time YES
last_exam date YES
routine_stat varchar(1) YES
portable varchar(1) YES
on_iv varchar(1) YES
on_o2 varchar(1) YES
stret_amb_wchr varchar(1) YES
input_by smallint(6) YES
shield varchar(1) YES
pdp varchar(1) YES
lmp date YES
order_phys int(11) YES
xray_diag varchar(40) YES
myelogram varchar(1) YES
fluro_min decimal(2,0) YES
fluro_sec decimal(2,0) YES
contrast_lot_no varchar(20) YES
contrast_expire date YES
height varchar(2) YES
weight varchar(3) YES
chs_rowID bigint(20) unsigned NO PRI auto_increment

References

Local Column References
sex
TableColumn
HSPI_CURES2015_B1.patientsbirth_sex
HSPI_Central_Hospital.patientsbirth_sex
HSPI_Dewitt.patientsbirth_sex
HSPI_Fulton.patientsbirth_sex
HSPI_Inferno.patientsbirth_sex
HSPI_MU2015_E1.patientsbirth_sex
HSPI_MU2015_G2.patientsbirth_sex
HSPI_MU2015_G9.patientsbirth_sex
HSPI_Sandbox.patientsbirth_sex
HSPI_Summit_General.patientsbirth_sex
HSPI_United_Physicians.patientsbirth_sex
MPI.patientsbirth_sex
_1.chartschrt_sex
_1.clinical_alertsca_pat_sex
_1.clinical_interventionsci_pat_sex
_1.cpoe_responsescpoe_res_sex
_1.encountersenc_sex
_1.encountersenc_ins1_insured_sex
_1.encountersenc_ins2_insured_sex
_1.encountersenc_ins3_insured_sex
_1.health_maintenancehm_sex
_1.hl7_accessionsacc_sex
_1.insurances_repositoryirep_ins_insured_sex
_1.non_patientsnpat_sex
_1.ordersord_sex
_1.patient_educationpe_sex
_1.patient_history_fieldsphf_sex
_1.patientspat_sex
_1.patientspat_birth_sex
_1.patientspat_ins1_insured_sex
_1.patientspat_ins2_insured_sex
_1.patientspat_ins3_insured_sex
_1.patients_demographics_snapshotspds_sex
_1.patients_demographics_snapshotspds_ins1_insured_sex
_1.patients_demographics_snapshotspds_ins2_insured_sex
_1.patients_demographics_snapshotspds_ins3_insured_sex
_1.patients_responsibility_estimatesprest_sex
_1.precertspre_sex
_1.precertspre_ins1_insured_sex
_1.precertspre_ins2_insured_sex
_1.radiology_ordersrad_sex
_1.radiology_resultsrad_res_sex
_1188.chartschrt_sex
_1188.clinical_alertsca_pat_sex
_1188.clinical_interventionsci_pat_sex
_1188.cpoe_responsescpoe_res_sex
_1188.encountersenc_sex
_1188.encountersenc_ins1_insured_sex
_1188.encountersenc_ins2_insured_sex
_1188.encountersenc_ins3_insured_sex
_1188.health_maintenancehm_sex
_1188.hl7_accessionsacc_sex
_1188.insurances_repositoryirep_ins_insured_sex
_1188.non_patientsnpat_sex
_1188.ordersord_sex
_1188.patient_educationpe_sex
_1188.patient_history_fieldsphf_sex
_1188.patientspat_sex
_1188.patientspat_birth_sex
_1188.patientspat_ins1_insured_sex
_1188.patientspat_ins2_insured_sex
_1188.patientspat_ins3_insured_sex
_1188.patients_demographics_snapshotspds_sex
_1188.patients_demographics_snapshotspds_ins1_insured_sex
_1188.patients_demographics_snapshotspds_ins2_insured_sex
_1188.patients_demographics_snapshotspds_ins3_insured_sex
_1188.patients_responsibility_estimatesprest_sex
_1188.precertspre_sex
_1188.precertspre_ins1_insured_sex
_1188.precertspre_ins2_insured_sex
_1188.radiology_ordersrad_sex
_1188.radiology_resultsrad_res_sex
_1218.chartschrt_sex
_1218.clinical_alertsca_pat_sex
_1218.clinical_interventionsci_pat_sex
_1218.cpoe_responsescpoe_res_sex
_1218.encountersenc_sex
_1218.encountersenc_ins1_insured_sex
_1218.encountersenc_ins2_insured_sex
_1218.encountersenc_ins3_insured_sex
_1218.health_maintenancehm_sex
_1218.hl7_accessionsacc_sex
_1218.insurances_repositoryirep_ins_insured_sex
_1218.non_patientsnpat_sex
_1218.ordersord_sex
_1218.patient_educationpe_sex
_1218.patient_history_fieldsphf_sex
_1218.patientspat_sex
_1218.patientspat_birth_sex
_1218.patientspat_ins1_insured_sex
_1218.patientspat_ins2_insured_sex
_1218.patientspat_ins3_insured_sex
_1218.patients_demographics_snapshotspds_sex
_1218.patients_demographics_snapshotspds_ins1_insured_sex
_1218.patients_demographics_snapshotspds_ins2_insured_sex
_1218.patients_demographics_snapshotspds_ins3_insured_sex
_1218.patients_responsibility_estimatesprest_sex
_1218.precertspre_sex
_1218.precertspre_ins1_insured_sex
_1218.precertspre_ins2_insured_sex
_1218.radiology_ordersrad_sex
_1218.radiology_resultsrad_res_sex
_1548.chartschrt_sex
_1548.clinical_alertsca_pat_sex
_1548.clinical_interventionsci_pat_sex
_1548.cpoe_responsescpoe_res_sex
_1548.encountersenc_sex
_1548.encountersenc_ins1_insured_sex
_1548.encountersenc_ins2_insured_sex
_1548.encountersenc_ins3_insured_sex
_1548.health_maintenancehm_sex
_1548.hl7_accessionsacc_sex
_1548.insurances_repositoryirep_ins_insured_sex
_1548.non_patientsnpat_sex
_1548.ordersord_sex
_1548.patient_educationpe_sex
_1548.patient_history_fieldsphf_sex
_1548.patientspat_sex
_1548.patientspat_birth_sex
_1548.patientspat_ins1_insured_sex
_1548.patientspat_ins2_insured_sex
_1548.patientspat_ins3_insured_sex
_1548.patients_demographics_snapshotspds_sex
_1548.patients_demographics_snapshotspds_ins1_insured_sex
_1548.patients_demographics_snapshotspds_ins2_insured_sex
_1548.patients_demographics_snapshotspds_ins3_insured_sex
_1548.patients_responsibility_estimatesprest_sex
_1548.precertspre_sex
_1548.precertspre_ins1_insured_sex
_1548.precertspre_ins2_insured_sex
_1548.radiology_ordersrad_sex
_1548.radiology_resultsrad_res_sex
_435.chartschrt_sex
_435.clinical_alertsca_pat_sex
_435.clinical_interventionsci_pat_sex
_435.cpoe_responsescpoe_res_sex
_435.encountersenc_sex
_435.encountersenc_ins1_insured_sex
_435.encountersenc_ins2_insured_sex
_435.encountersenc_ins3_insured_sex
_435.health_maintenancehm_sex
_435.hl7_accessionsacc_sex
_435.insurances_repositoryirep_ins_insured_sex
_435.non_patientsnpat_sex
_435.ordersord_sex
_435.patient_educationpe_sex
_435.patient_history_fieldsphf_sex
_435.patientspat_sex
_435.patientspat_birth_sex
_435.patientspat_ins1_insured_sex
_435.patientspat_ins2_insured_sex
_435.patientspat_ins3_insured_sex
_435.patients_demographics_snapshotspds_sex
_435.patients_demographics_snapshotspds_ins1_insured_sex
_435.patients_demographics_snapshotspds_ins2_insured_sex
_435.patients_demographics_snapshotspds_ins3_insured_sex
_435.patients_responsibility_estimatesprest_sex
_435.precertspre_sex
_435.precertspre_ins1_insured_sex
_435.precertspre_ins2_insured_sex
_435.radiology_ordersrad_sex
_435.radiology_resultsrad_res_sex
_436.chartschrt_sex
_436.clinical_alertsca_pat_sex
_436.clinical_interventionsci_pat_sex
_436.cpoe_responsescpoe_res_sex
_436.encountersenc_sex
_436.encountersenc_ins1_insured_sex
_436.encountersenc_ins2_insured_sex
_436.encountersenc_ins3_insured_sex
_436.health_maintenancehm_sex
_436.hl7_accessionsacc_sex
_436.insurances_repositoryirep_ins_insured_sex
_436.non_patientsnpat_sex
_436.ordersord_sex
_436.patient_educationpe_sex
_436.patient_history_fieldsphf_sex
_436.patientspat_sex
_436.patientspat_birth_sex
_436.patientspat_ins1_insured_sex
_436.patientspat_ins2_insured_sex
_436.patientspat_ins3_insured_sex
_436.patients_demographics_snapshotspds_sex
_436.patients_demographics_snapshotspds_ins1_insured_sex
_436.patients_demographics_snapshotspds_ins2_insured_sex
_436.patients_demographics_snapshotspds_ins3_insured_sex
_436.patients_responsibility_estimatesprest_sex
_436.precertspre_sex
_436.precertspre_ins1_insured_sex
_436.precertspre_ins2_insured_sex
_436.radiology_ordersrad_sex
_436.radiology_resultsrad_res_sex
_436_archive_testing.chartschrt_sex
_436_archive_testing.clinical_alertsca_pat_sex
_436_archive_testing.clinical_interventionsci_pat_sex
_436_archive_testing.cpoe_responsescpoe_res_sex
_436_archive_testing.encountersenc_sex
_436_archive_testing.encountersenc_ins1_insured_sex
_436_archive_testing.encountersenc_ins2_insured_sex
_436_archive_testing.encountersenc_ins3_insured_sex
_436_archive_testing.health_maintenancehm_sex
_436_archive_testing.hl7_accessionsacc_sex
_436_archive_testing.insurances_repositoryirep_ins_insured_sex
_436_archive_testing.non_patientsnpat_sex
_436_archive_testing.ordersord_sex
_436_archive_testing.patient_educationpe_sex
_436_archive_testing.patient_history_fieldsphf_sex
_436_archive_testing.patientspat_sex
_436_archive_testing.patientspat_ins1_insured_sex
_436_archive_testing.patientspat_ins2_insured_sex
_436_archive_testing.patientspat_ins3_insured_sex
_436_archive_testing.patients_demographics_snapshotspds_sex
_436_archive_testing.patients_demographics_snapshotspds_ins1_insured_sex
_436_archive_testing.patients_demographics_snapshotspds_ins2_insured_sex
_436_archive_testing.patients_demographics_snapshotspds_ins3_insured_sex
_436_archive_testing.patients_responsibility_estimatesprest_sex
_436_archive_testing.precertspre_sex
_436_archive_testing.precertspre_ins1_insured_sex
_436_archive_testing.precertspre_ins2_insured_sex
_436_archive_testing.radiology_ordersrad_sex
_436_archive_testing.radiology_resultsrad_res_sex
_437.chartschrt_sex
_437.clinical_alertsca_pat_sex
_437.clinical_interventionsci_pat_sex
_437.cpoe_responsescpoe_res_sex
_437.encountersenc_sex
_437.encountersenc_ins1_insured_sex
_437.encountersenc_ins2_insured_sex
_437.encountersenc_ins3_insured_sex
_437.health_maintenancehm_sex
_437.hl7_accessionsacc_sex
_437.insurances_repositoryirep_ins_insured_sex
_437.non_patientsnpat_sex
_437.ordersord_sex
_437.patient_educationpe_sex
_437.patient_history_fieldsphf_sex
_437.patientspat_sex
_437.patientspat_birth_sex
_437.patientspat_ins1_insured_sex
_437.patientspat_ins2_insured_sex
_437.patientspat_ins3_insured_sex
_437.patients_demographics_snapshotspds_sex
_437.patients_demographics_snapshotspds_ins1_insured_sex
_437.patients_demographics_snapshotspds_ins2_insured_sex
_437.patients_demographics_snapshotspds_ins3_insured_sex
_437.patients_responsibility_estimatesprest_sex
_437.precertspre_sex
_437.precertspre_ins1_insured_sex
_437.precertspre_ins2_insured_sex
_437.radiology_ordersrad_sex
_437.radiology_resultsrad_res_sex
_8.chartschrt_sex
_8.clinical_alertsca_pat_sex
_8.clinical_interventionsci_pat_sex
_8.cpoe_responsescpoe_res_sex
_8.encountersenc_sex
_8.encountersenc_ins1_insured_sex
_8.encountersenc_ins2_insured_sex
_8.encountersenc_ins3_insured_sex
_8.health_maintenancehm_sex
_8.hl7_accessionsacc_sex
_8.insurances_repositoryirep_ins_insured_sex
_8.non_patientsnpat_sex
_8.ordersord_sex
_8.patient_educationpe_sex
_8.patient_history_fieldsphf_sex
_8.patientspat_sex
_8.patientspat_birth_sex
_8.patientspat_ins1_insured_sex
_8.patientspat_ins2_insured_sex
_8.patientspat_ins3_insured_sex
_8.patients_demographics_snapshotspds_sex
_8.patients_demographics_snapshotspds_ins1_insured_sex
_8.patients_demographics_snapshotspds_ins2_insured_sex
_8.patients_demographics_snapshotspds_ins3_insured_sex
_8.patients_responsibility_estimatesprest_sex
_8.precertspre_sex
_8.precertspre_ins1_insured_sex
_8.precertspre_ins2_insured_sex
_8.radiology_ordersrad_sex
_8.radiology_resultsrad_res_sex
_81.chartschrt_sex
_81.clinical_alertsca_pat_sex
_81.clinical_interventionsci_pat_sex
_81.cpoe_responsescpoe_res_sex
_81.encountersenc_sex
_81.encountersenc_ins1_insured_sex
_81.encountersenc_ins2_insured_sex
_81.encountersenc_ins3_insured_sex
_81.health_maintenancehm_sex
_81.hl7_accessionsacc_sex
_81.insurances_repositoryirep_ins_insured_sex
_81.non_patientsnpat_sex
_81.ordersord_sex
_81.patient_educationpe_sex
_81.patient_history_fieldsphf_sex
_81.patientspat_sex
_81.patientspat_birth_sex
_81.patientspat_ins1_insured_sex
_81.patientspat_ins2_insured_sex
_81.patientspat_ins3_insured_sex
_81.patients_demographics_snapshotspds_sex
_81.patients_demographics_snapshotspds_ins1_insured_sex
_81.patients_demographics_snapshotspds_ins2_insured_sex
_81.patients_demographics_snapshotspds_ins3_insured_sex
_81.patients_responsibility_estimatesprest_sex
_81.precertspre_sex
_81.precertspre_ins1_insured_sex
_81.precertspre_ins2_insured_sex
_81.radiology_ordersrad_sex
_81.radiology_resultsrad_res_sex
_999.chartschrt_sex
_999.clinical_alertsca_pat_sex
_999.clinical_interventionsci_pat_sex
_999.cpoe_responsescpoe_res_sex
_999.encountersenc_sex
_999.encountersenc_ins1_insured_sex
_999.encountersenc_ins2_insured_sex
_999.encountersenc_ins3_insured_sex
_999.health_maintenancehm_sex
_999.hl7_accessionsacc_sex
_999.insurances_repositoryirep_ins_insured_sex
_999.non_patientsnpat_sex
_999.ordersord_sex
_999.patient_educationpe_sex
_999.patient_history_fieldsphf_sex
_999.patientspat_sex
_999.patientspat_birth_sex
_999.patientspat_ins1_insured_sex
_999.patientspat_ins2_insured_sex
_999.patientspat_ins3_insured_sex
_999.patients_demographics_snapshotspds_sex
_999.patients_demographics_snapshotspds_ins1_insured_sex
_999.patients_demographics_snapshotspds_ins2_insured_sex
_999.patients_demographics_snapshotspds_ins3_insured_sex
_999.patients_responsibility_estimatesprest_sex
_999.precertspre_sex
_999.precertspre_ins1_insured_sex
_999.precertspre_ins2_insured_sex
_999.radiology_ordersrad_sex
_999.radiology_resultsrad_res_sex
aurora_standard.abmmpii1_sex
aurora_standard.abmmpii2_sex
aurora_standard.abmmpii3_sex
aurora_standard.abmmpigu_sex
aurora_standard.abmvisgu_sex
aurora_standard.abmvisi1_sex
aurora_standard.abmvisi2_sex
aurora_standard.abmvisi3_sex
aurora_standard.bevispat_sex
aurora_standard.bevisbdpat_sex
aurora_standard.bevisbd2pat_sex
aurora_standard.bharp_sex
aurora_standard.bharg_sex
aurora_standard.bparp_sex
aurora_standard.bparg_sex
aurora_standard.bpar2p_sex
aurora_standard.bpar2g_sex
aurora_standard.bpmpip_sex
aurora_standard.bpmpi2p_sex
aurora_standard.bpmrp_sex
aurora_standard.bpmr2p_sex
aurora_standard.c7mpip_sex
aurora_standard.c7mpigu_sex
aurora_standard.c8dtlsp_sex
aurora_standard.c9mpip_sex
aurora_standard.chhl7in1ins_sex
aurora_standard.chmarbexpat_sex
aurora_standard.chmarsipat_sex
aurora_standard.chmarsiins1_sex
aurora_standard.chmarsiins2_sex
aurora_standard.chmarsiins3_sex
aurora_standard.chmazstdpat_sex
aurora_standard.chmazstipat_sex
aurora_standard.chmazstopat_sex
aurora_standard.chmbatexpat_sex
aurora_standard.chmcampipat_sex
aurora_standard.chmcampiins1_sex
aurora_standard.chmcampiins2_sex
aurora_standard.chmcampiins3_sex
aurora_standard.chmcmhedpat_sex
aurora_standard.chmexmpipat_sex
aurora_standard.chmexmpiins1_sex
aurora_standard.chmexmpiins2_sex
aurora_standard.chmexmpiins3_sex
aurora_standard.chmexvisins1_sex
aurora_standard.chmexvisins2_sex
aurora_standard.chmexvisins3_sex
aurora_standard.chmhcaphpat_sex
aurora_standard.chmhcapspat_sex
aurora_standard.chmhistpp_sex
aurora_standard.chmhstmrpat_sex
aurora_standard.chmhstrmpat_sex
aurora_standard.chmlastrpat_sex
aurora_standard.chmmhastpat_sex
aurora_standard.chmmrhdrupd_sex
aurora_standard.chmnrcexpat_sex
aurora_standard.chmokipdpat_sex
aurora_standard.chmokopdpat_sex
aurora_standard.chmpdemop_sex
aurora_standard.chmpdemoins1_sex
aurora_standard.chmpdemoins2_sex
aurora_standard.chmpdemoins3_sex
aurora_standard.chmradexpat_sex
aurora_standard.chmradexins1_sex
aurora_standard.chmradexins2_sex
aurora_standard.chmradexins3_sex
aurora_standard.chmtxstrpat_sex
aurora_standard.hl7gt1guar_sex
aurora_standard.hl7gt1adguar_sex
aurora_standard.hl7in1ins_sex
aurora_standard.hl7in1adins_sex
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
height
TableColumn
_1.encounters_soap_vitalsespv_height
_1.patients_vitalspvs_height
_1188.encounters_soap_vitalsespv_height
_1188.patients_vitalspvs_height
_1218.encounters_soap_vitalsespv_height
_1218.patients_vitalspvs_height
_1548.encounters_soap_vitalsespv_height
_1548.patients_vitalspvs_height
_435.encounters_soap_vitalsespv_height
_435.patients_vitalspvs_height
_436.encounters_soap_vitalsespv_height
_436.patients_vitalspvs_height
_436_archive_testing.encounters_soap_vitalsespv_height
_436_archive_testing.patients_vitalspvs_height
_437.encounters_soap_vitalsespv_height
_437.patients_vitalspvs_height
_8.encounters_soap_vitalsespv_height
_8.patients_vitalspvs_height
_81.encounters_soap_vitalsespv_height
_81.patients_vitalspvs_height
_999.encounters_soap_vitalsespv_height
_999.patients_vitalspvs_height
ahiWiki.filearchivefa_height
ahiWiki.imageimg_height
ahiWiki.oldimageoi_height
ahiWiki.uploadstashus_image_height
aurora_standard.chxhistrh_height
weight
TableColumn
_1.encounters_soap_vitalsespv_weight
_1.orders_afpsoafp_weight
_1.patients_vitalspvs_weight
_1188.encounters_soap_vitalsespv_weight
_1188.orders_afpsoafp_weight
_1188.patients_vitalspvs_weight
_1218.encounters_soap_vitalsespv_weight
_1218.orders_afpsoafp_weight
_1218.patients_vitalspvs_weight
_1548.encounters_soap_vitalsespv_weight
_1548.orders_afpsoafp_weight
_1548.patients_vitalspvs_weight
_435.encounters_soap_vitalsespv_weight
_435.orders_afpsoafp_weight
_435.patients_vitalspvs_weight
_436.encounters_soap_vitalsespv_weight
_436.orders_afpsoafp_weight
_436.patients_vitalspvs_weight
_436_archive_testing.encounters_soap_vitalsespv_weight
_436_archive_testing.orders_afpsoafp_weight
_436_archive_testing.patients_vitalspvs_weight
_437.encounters_soap_vitalsespv_weight
_437.orders_afpsoafp_weight
_437.patients_vitalspvs_weight
_8.encounters_soap_vitalsespv_weight
_8.orders_afpsoafp_weight
_8.patients_vitalspvs_weight
_81.encounters_soap_vitalsespv_weight
_81.orders_afpsoafp_weight
_81.patients_vitalspvs_weight
_999.encounters_soap_vitalsespv_weight
_999.orders_afpsoafp_weight
_999.patients_vitalspvs_weight
aurora_standard.chmarsthib_weight
aurora_standard.chmdrgccrel_weight
aurora_standard.chxhistrh_weight
aurora_standard.ordersship_weight
aurora_standard.stoinvceship_weight
aurora_standard.stoordrdship_weight
aurora_standard.stoordreship_weight
aurora_standard.stoshipdship_weight
aurora_standard.stuordretotal_weight
aurora_standard.workdrgrel_weight
common.encounters_statusesess_weight
common.precerts_statusespss_weight
common.precerts_statusesps_weight
allergies
TableColumn
_1.patients_erx_updatespeu_update_allergies
_1188.patients_erx_updatespeu_update_allergies
_1218.patients_erx_updatespeu_update_allergies
_1548.patients_erx_updatespeu_update_allergies
_435.patients_erx_updatespeu_update_allergies
_436.patients_erx_updatespeu_update_allergies
_436_archive_testing.patients_erx_updatespeu_update_allergies
_437.patients_erx_updatespeu_update_allergies
_8.patients_erx_updatespeu_update_allergies
_81.patients_erx_updatespeu_update_allergies
_999.patients_erx_updatespeu_update_allergies
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
mid_name
TableColumn
aurora_standard.c7insur2p_mid_name
aurora_standard.c7insur3p_mid_name
aurora_standard.chmstmtdg_mid_name
acct_no
TableColumn
aurora_standard.chmcashdnon_pat_acct_no
aurora_standard.chmnbcgdnon_pat_acct_no
aurora_standard.chmnbpydnon_pat_acct_no
aurora_standard.chmnchgdnon_pat_acct_no
aurora_standard.chmnpatrnon_pat_acct_no
aurora_standard.chmnpaydnon_pat_acct_no
aurora_standard.chmrefndcontr_acct_no
aurora_standard.chpcashrcash_acct_no
aurora_standard.chpcobpdcash_acct_no
aurora_standard.chpcobpdbal_acct_no
aurora_standard.chrcntrcrx_inv_acct_no
aurora_standard.chrcntrcrx_exp_acct_no
aurora_standard.curs_tempcash_acct_no
aurora_standard.np_statmnon_pat_acct_no
aurora_standard.sticntrcinv_acct_no
aurora_standard.sticntrcsales_acct_no
aurora_standard.sticntrccog_acct_no
aurora_standard.sticntrcadj_acct_no
aurora_standard.sticntrccount_acct_no
aurora_standard.sticntrchold_acct_no
aurora_standard.stiinvtrinv_acct_no
aurora_standard.stiinvtrcog_acct_no
aurora_standard.stiinvtrsales_acct_no
aurora_standard.stiinvtrsupp_acct_no
aurora_standard.stitrandexp_acct_no
aurora_standard.stiwhserinv_acct_no
aurora_standard.stpcntrcap_acct_no
aurora_standard.stpcntrccd_cash_acct_no
aurora_standard.stpcntrccd_disc_acct_no
aurora_standard.stpinvcedisc_acct_no
aurora_standard.stpinvceap_acct_no
aurora_standard.stpinvcecash_acct_no
aurora_standard.stpopendap_acct_no
aurora_standard.stpopendcash_acct_no
aurora_standard.stpvendrcash_acct_no
aurora_standard.stpvendrexp_acct_no
aurora_standard.stpvendrhosp_acct_no
aurora_standard.strcntrcar_acct_no
aurora_standard.strcntrcar_sales_acct_no
aurora_standard.strcntrcar_tax_acct_no
aurora_standard.strcntrcar_frght_acct_no
aurora_standard.strcntrcar_misc_acct_no
aurora_standard.strcntrcar_fc_acct_no
aurora_standard.strcntrccr_cash_acct_no
aurora_standard.strcntrccr_disc_acct_no
aurora_standard.strinvcedisc_acct_no
aurora_standard.strinvcetax_acct_no
aurora_standard.strinvcefrght_acct_no
aurora_standard.strinvcemisc_acct_no
aurora_standard.strinvcear_acct_no
aurora_standard.stropendar_acct_no
aurora_standard.stucntrcap_acct_no
aurora_standard.stucntrcdisc_acct_no
aurora_standard.stucntrcfrght_acct_no
aurora_standard.stucntrcmisc_acct_no
aurora_standard.stucntrcinv_acct_no
aurora_standard.stucntrcadj_acct_no
aurora_standard.stucntrcprepaid_acct_no
aurora_standard.stucntrcsupp_acct_no
aurora_standard.stucntrccap_acct_no
aurora_standard.stucntrcnon_acct_no
aurora_standard.stucntrcdiff_acct_no
aurora_standard.stucntrccash_acct_no
aurora_standard.stucntrcret_acct_no
aurora_standard.stucntrcret_fee_acct_no
aurora_standard.stuinvcdgl_acct_no
aurora_standard.stultyprgl_acct_no
aurora_standard.stuordrdgl_acct_no
aurora_standard.stxcurrrex_diff_acct_no
aurora_standard.stxfinsdfin_acct_no
aurora_standard.stxinforsrc_acct_no
aurora_standard.stxmtaxrar_acct_no
aurora_standard.stxmtaxrar_disc_acct_no
aurora_standard.stxmtaxrap_acct_no
aurora_standard.stxmtaxrap_disc_acct_no
aurora_standard.stycntrcco_bank_acct_no
aurora_standard.styddepdbank_acct_no
aurora_standard.styemplrbank_acct_no
aurora_standard.styempodbal_acct_no
aurora_standard.stypayodbal_acct_no
aurora_standard.stypayrecash_acct_no
aurora_standard.stypddrdbank_acct_no
aurora_standard.styrevsdcash_acct_no
aurora_standard.stytypodbal_acct_no
aurora_standard.styuimmrui_acct_no
aurora_standard.ttiinvtrinv_acct_no
aurora_standard.ttiinvtrcog_acct_no
aurora_standard.ttiinvtrsales_acct_no
aurora_standard.ttiinvtrsupp_acct_no
aurora_standard.wkactvvinv_acct_no
id_no
TableColumn
aurora_standard.chxcntrcauto_id_no
aurora_standard.chxhistdh_id_no
aurora_standard.chxhistrh_id_no
aurora_standard.chycntrcauto_id_no
aurora_standard.chyhistdh_id_no
aurora_standard.chyhistrh_id_no