aurora_standard.chmapcir

Field Type Null Default Key Extra Comment
visit_no varchar(10) NO PRI
x1 varchar(1) YES
input_by varchar(6) YES
x2 varchar(1) YES
age varchar(3) YES
x3 varchar(1) YES
sex varchar(1) YES
x4 varchar(1) YES
disp varchar(2) YES
x5 varchar(1) YES
diag_codes varchar(160) YES
x6 varchar(1) YES
cpt_codes varchar(400) YES
x7 varchar(1) YES
cpt_dates varchar(500) YES
x8 varchar(1) YES
rev_codes varchar(200) YES
x9 varchar(1) YES
cpt_units varchar(150) YES
x10 varchar(1) YES
from_date varchar(10) YES
x11 varchar(1) YES
thru_date varchar(10) YES
x12 varchar(1) YES
birth_date varchar(10) YES
x13 varchar(1) YES
date_format varchar(1) YES
x13a varchar(1) YES
cond_codes varchar(14) YES
x14 varchar(1) YES
bill_type varchar(3) YES
x15 varchar(1) YES
modifiers varchar(300) YES
x16 varchar(1) YES
pt_visit_type varchar(1) YES
x17 varchar(1) YES
apc_status varchar(1) YES
x18 varchar(1) YES
papc_1 varchar(18) YES
xp1 varchar(1) YES
papc_2 varchar(18) YES
xp2 varchar(1) YES
papc_3 varchar(18) YES
xp3 varchar(1) YES
papc_4 varchar(18) YES
xp4 varchar(1) YES
papc_5 varchar(18) YES
xp5 varchar(1) YES
papc_6 varchar(18) YES
xp6 varchar(1) YES
papc_7 varchar(18) YES
xp7 varchar(1) YES
papc_8 varchar(18) YES
xp8 varchar(1) YES
papc_9 varchar(18) YES
xp9 varchar(1) YES
papc_10 varchar(18) YES
xp10 varchar(1) YES
papc_11 varchar(18) YES
xp11 varchar(1) YES
papc_12 varchar(18) YES
xp12 varchar(1) YES
papc_13 varchar(18) YES
xp13 varchar(1) YES
papc_14 varchar(18) YES
xp14 varchar(1) YES
papc_15 varchar(18) YES
xp15 varchar(1) YES
papc_16 varchar(18) YES
xp16 varchar(1) YES
papc_17 varchar(18) YES
xp17 varchar(1) YES
papc_18 varchar(18) YES
xp18 varchar(1) YES
papc_19 varchar(18) YES
xp19 varchar(1) YES
papc_20 varchar(18) YES
xp20 varchar(1) YES
papc_21 varchar(18) YES
xp21 varchar(1) YES
papc_22 varchar(18) YES
xp22 varchar(1) YES
papc_23 varchar(18) YES
xp23 varchar(1) YES
papc_24 varchar(18) YES
xp24 varchar(1) YES
papc_25 varchar(18) YES
xp25 varchar(1) YES
papc_26 varchar(18) YES
xp26 varchar(1) YES
papc_27 varchar(18) YES
xp27 varchar(1) YES
papc_28 varchar(18) YES
xp28 varchar(1) YES
papc_29 varchar(18) YES
xp29 varchar(1) YES
papc_30 varchar(18) YES
xp30 varchar(1) YES
papc_31 varchar(18) YES
xp31 varchar(1) YES
papc_32 varchar(18) YES
xp32 varchar(1) YES
papc_33 varchar(18) YES
xp33 varchar(1) YES
papc_34 varchar(18) YES
xp34 varchar(1) YES
papc_35 varchar(18) YES
xp35 varchar(1) YES
papc_36 varchar(18) YES
xp36 varchar(1) YES
papc_37 varchar(18) YES
xp37 varchar(1) YES
papc_38 varchar(18) YES
xp38 varchar(1) YES
papc_39 varchar(18) YES
xp39 varchar(1) YES
papc_40 varchar(18) YES
xp40 varchar(1) YES
papc_41 varchar(18) YES
xp41 varchar(1) YES
papc_42 varchar(18) YES
xp42 varchar(1) YES
papc_43 varchar(18) YES
xp43 varchar(1) YES
papc_44 varchar(18) YES
xp44 varchar(1) YES
papc_45 varchar(18) YES
xp45 varchar(1) YES
papc_46 varchar(18) YES
xp46 varchar(1) YES
papc_47 varchar(18) YES
xp47 varchar(1) YES
papc_48 varchar(18) YES
xp48 varchar(1) YES
papc_49 varchar(18) YES
xp49 varchar(1) YES
papc_50 varchar(18) YES
x19 varchar(1) YES
claim_ret varchar(235) YES
x20 varchar(1) YES
dx_edits varchar(60) YES
x21 varchar(1) YES
retcode varchar(3) YES
x22 varchar(1) YES
retcode_msg varchar(60) YES

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
bill_type
TableColumn
_1.chartschrt_bill_type
_1.encountersenc_bill_type
_1.encounters_cpt_codesecp_next_payer_bill_type
_1.encounters_paymentsepay_bill_type
_1.insurancesins_ub04_bill_type
_1.locationsloc_ub04_bill_type
_1.ordersord_bill_type
_1.patientspat_bill_type
_1.patients_demographics_snapshotspds_bill_type
_1.physiciansphy_ub04_bill_type
_1.precertspre_bill_type
_1.radiology_ordersrad_bill_type
_1188.chartschrt_bill_type
_1188.encountersenc_bill_type
_1188.encounters_cpt_codesecp_next_payer_bill_type
_1188.encounters_paymentsepay_bill_type
_1188.insurancesins_ub04_bill_type
_1188.locationsloc_ub04_bill_type
_1188.ordersord_bill_type
_1188.patientspat_bill_type
_1188.patients_demographics_snapshotspds_bill_type
_1188.physiciansphy_ub04_bill_type
_1188.precertspre_bill_type
_1188.radiology_ordersrad_bill_type
_1218.chartschrt_bill_type
_1218.encountersenc_bill_type
_1218.encounters_cpt_codesecp_next_payer_bill_type
_1218.encounters_paymentsepay_bill_type
_1218.insurancesins_ub04_bill_type
_1218.locationsloc_ub04_bill_type
_1218.ordersord_bill_type
_1218.patientspat_bill_type
_1218.patients_demographics_snapshotspds_bill_type
_1218.physiciansphy_ub04_bill_type
_1218.precertspre_bill_type
_1218.radiology_ordersrad_bill_type
_1548.chartschrt_bill_type
_1548.encountersenc_bill_type
_1548.encounters_cpt_codesecp_next_payer_bill_type
_1548.encounters_paymentsepay_bill_type
_1548.insurancesins_ub04_bill_type
_1548.locationsloc_ub04_bill_type
_1548.ordersord_bill_type
_1548.patientspat_bill_type
_1548.patients_demographics_snapshotspds_bill_type
_1548.physiciansphy_ub04_bill_type
_1548.precertspre_bill_type
_1548.radiology_ordersrad_bill_type
_435.chartschrt_bill_type
_435.encountersenc_bill_type
_435.encounters_cpt_codesecp_next_payer_bill_type
_435.encounters_paymentsepay_bill_type
_435.insurancesins_ub04_bill_type
_435.ledger_running_balancelrb_next_payer_bill_type
_435.locationsloc_ub04_bill_type
_435.ordersord_bill_type
_435.patientspat_bill_type
_435.patients_demographics_snapshotspds_bill_type
_435.physiciansphy_ub04_bill_type
_435.precertspre_bill_type
_435.radiology_ordersrad_bill_type
_436.chartschrt_bill_type
_436.encountersenc_bill_type
_436.encounters_cpt_codesecp_next_payer_bill_type
_436.encounters_paymentsepay_bill_type
_436.insurancesins_ub04_bill_type
_436.ledger_running_balancelrb_next_payer_bill_type
_436.locationsloc_ub04_bill_type
_436.ordersord_bill_type
_436.patientspat_bill_type
_436.patients_demographics_snapshotspds_bill_type
_436.physiciansphy_ub04_bill_type
_436.precertspre_bill_type
_436.radiology_ordersrad_bill_type
_436_archive_testing.chartschrt_bill_type
_436_archive_testing.encountersenc_bill_type
_436_archive_testing.encounters_cpt_codesecp_next_payer_bill_type
_436_archive_testing.encounters_paymentsepay_bill_type
_436_archive_testing.insurancesins_ub04_bill_type
_436_archive_testing.ledger_running_balancelrb_next_payer_bill_type
_436_archive_testing.locationsloc_ub04_bill_type
_436_archive_testing.ordersord_bill_type
_436_archive_testing.patientspat_bill_type
_436_archive_testing.patients_demographics_snapshotspds_bill_type
_436_archive_testing.physiciansphy_ub04_bill_type
_436_archive_testing.precertspre_bill_type
_436_archive_testing.radiology_ordersrad_bill_type
_437.chartschrt_bill_type
_437.encountersenc_bill_type
_437.encounters_cpt_codesecp_next_payer_bill_type
_437.encounters_paymentsepay_bill_type
_437.insurancesins_ub04_bill_type
_437.ledger_running_balancelrb_next_payer_bill_type
_437.locationsloc_ub04_bill_type
_437.ordersord_bill_type
_437.patientspat_bill_type
_437.patients_demographics_snapshotspds_bill_type
_437.physiciansphy_ub04_bill_type
_437.precertspre_bill_type
_437.radiology_ordersrad_bill_type
_8.chartschrt_bill_type
_8.daily_close_calculationsdcc_next_payer_bill_type
_8.daily_close_calculationsdcc_enc_bill_type
_8.encountersenc_bill_type
_8.encounters_cpt_codesecp_next_payer_bill_type
_8.encounters_paymentsepay_bill_type
_8.insurancesins_ub04_bill_type
_8.locationsloc_ub04_bill_type
_8.ordersord_bill_type
_8.patientspat_bill_type
_8.patients_demographics_snapshotspds_bill_type
_8.physiciansphy_ub04_bill_type
_8.precertspre_bill_type
_8.radiology_ordersrad_bill_type
_81.chartschrt_bill_type
_81.encountersenc_bill_type
_81.encounters_cpt_codesecp_next_payer_bill_type
_81.encounters_paymentsepay_bill_type
_81.insurancesins_ub04_bill_type
_81.locationsloc_ub04_bill_type
_81.ordersord_bill_type
_81.patientspat_bill_type
_81.patients_demographics_snapshotspds_bill_type
_81.physiciansphy_ub04_bill_type
_81.precertspre_bill_type
_81.radiology_ordersrad_bill_type
_999.chartschrt_bill_type
_999.encountersenc_bill_type
_999.encounters_cpt_codesecp_next_payer_bill_type
_999.encounters_paymentsepay_bill_type
_999.insurancesins_ub04_bill_type
_999.locationsloc_ub04_bill_type
_999.ordersord_bill_type
_999.patientspat_bill_type
_999.patients_demographics_snapshotspds_bill_type
_999.physiciansphy_ub04_bill_type
_999.precertspre_bill_type
_999.radiology_ordersrad_bill_type
common.clientscli_ub04_bill_type
age
TableColumn
_1.chartschrt_age
_1.clinical_alertsca_pat_age
_1.cpoe_responsescpoe_res_age
_1.encountersenc_age
_1.hl7_accessionsacc_age
_1.ordersord_age
_1.precertspre_age
_1.radiology_ordersrad_age
_1.radiology_resultsrad_res_age
_1188.chartschrt_age
_1188.clinical_alertsca_pat_age
_1188.cpoe_responsescpoe_res_age
_1188.encountersenc_age
_1188.hl7_accessionsacc_age
_1188.ordersord_age
_1188.precertspre_age
_1188.radiology_ordersrad_age
_1188.radiology_resultsrad_res_age
_1218.chartschrt_age
_1218.clinical_alertsca_pat_age
_1218.cpoe_responsescpoe_res_age
_1218.encountersenc_age
_1218.hl7_accessionsacc_age
_1218.ordersord_age
_1218.precertspre_age
_1218.radiology_ordersrad_age
_1218.radiology_resultsrad_res_age
_1548.chartschrt_age
_1548.clinical_alertsca_pat_age
_1548.cpoe_responsescpoe_res_age
_1548.encountersenc_age
_1548.hl7_accessionsacc_age
_1548.ordersord_age
_1548.precertspre_age
_1548.radiology_ordersrad_age
_1548.radiology_resultsrad_res_age
_435.chartschrt_age
_435.clinical_alertsca_pat_age
_435.cpoe_responsescpoe_res_age
_435.encountersenc_age
_435.hl7_accessionsacc_age
_435.ordersord_age
_435.precertspre_age
_435.radiology_ordersrad_age
_435.radiology_resultsrad_res_age
_436.chartschrt_age
_436.clinical_alertsca_pat_age
_436.cpoe_responsescpoe_res_age
_436.encountersenc_age
_436.hl7_accessionsacc_age
_436.ordersord_age
_436.precertspre_age
_436.radiology_ordersrad_age
_436.radiology_resultsrad_res_age
_436_archive_testing.chartschrt_age
_436_archive_testing.clinical_alertsca_pat_age
_436_archive_testing.cpoe_responsescpoe_res_age
_436_archive_testing.encountersenc_age
_436_archive_testing.hl7_accessionsacc_age
_436_archive_testing.ordersord_age
_436_archive_testing.precertspre_age
_436_archive_testing.radiology_ordersrad_age
_436_archive_testing.radiology_resultsrad_res_age
_437.chartschrt_age
_437.clinical_alertsca_pat_age
_437.cpoe_responsescpoe_res_age
_437.encountersenc_age
_437.hl7_accessionsacc_age
_437.ordersord_age
_437.precertspre_age
_437.radiology_ordersrad_age
_437.radiology_resultsrad_res_age
_8.chartschrt_age
_8.clinical_alertsca_pat_age
_8.cpoe_responsescpoe_res_age
_8.encountersenc_age
_8.hl7_accessionsacc_age
_8.ordersord_age
_8.precertspre_age
_8.radiology_ordersrad_age
_8.radiology_resultsrad_res_age
_81.chartschrt_age
_81.clinical_alertsca_pat_age
_81.cpoe_responsescpoe_res_age
_81.encountersenc_age
_81.hl7_accessionsacc_age
_81.ordersord_age
_81.precertspre_age
_81.radiology_ordersrad_age
_81.radiology_resultsrad_res_age
_999.chartschrt_age
_999.clinical_alertsca_pat_age
_999.cpoe_responsescpoe_res_age
_999.encountersenc_age
_999.hl7_accessionsacc_age
_999.ordersord_age
_999.precertspre_age
_999.radiology_ordersrad_age
_999.radiology_resultsrad_res_age
aurora_standard.chmaptpcmin_age
aurora_standard.chmarbexpat_age
aurora_standard.chmbatexpat_age
aurora_standard.chmhcaphpat_age
aurora_standard.chmhcapspat_age
aurora_standard.chmhstmrpat_age
aurora_standard.chmhstrmpat_age
aurora_standard.chmmhastoutlier_age
aurora_standard.chrdintrstart_age
aurora_standard.chrdintrstop_age
aurora_standard.schprocedurcmin_age
from_date
TableColumn
_1.encounters_ub04enc_ub04_06_from_date
_1.schedulessch_from_date
_1.schedules_eventssevnt_from_date
_1.taskstask_from_date
_1188.encounters_ub04enc_ub04_06_from_date
_1188.schedulessch_from_date
_1188.schedules_eventssevnt_from_date
_1188.taskstask_from_date
_1218.encounters_ub04enc_ub04_06_from_date
_1218.schedulessch_from_date
_1218.schedules_eventssevnt_from_date
_1218.taskstask_from_date
_1548.encounters_ub04enc_ub04_06_from_date
_1548.schedulessch_from_date
_1548.schedules_eventssevnt_from_date
_1548.taskstask_from_date
_435.encounters_ub04enc_ub04_06_from_date
_435.schedulessch_from_date
_435.schedules_eventssevnt_from_date
_435.taskstask_from_date
_436.encounters_ub04enc_ub04_06_from_date
_436.schedulessch_from_date
_436.schedules_eventssevnt_from_date
_436.taskstask_from_date
_436_archive_testing.encounters_ub04enc_ub04_06_from_date
_436_archive_testing.schedulessch_from_date
_436_archive_testing.schedules_eventssevnt_from_date
_436_archive_testing.taskstask_from_date
_437.encounters_ub04enc_ub04_06_from_date
_437.schedulessch_from_date
_437.schedules_eventssevnt_from_date
_437.taskstask_from_date
_8.encounters_ub04enc_ub04_06_from_date
_8.schedulessch_from_date
_8.schedules_eventssevnt_from_date
_8.taskstask_from_date
_81.encounters_ub04enc_ub04_06_from_date
_81.schedulessch_from_date
_81.schedules_eventssevnt_from_date
_81.taskstask_from_date
_999.encounters_ub04enc_ub04_06_from_date
_999.schedulessch_from_date
_999.schedules_eventssevnt_from_date
_999.taskstask_from_date
aurora_standard.chmardydrev_from_date
aurora_standard.chmcptvceff_from_date
aurora_standard.chmvrsnceff_from_date
common.rcm_stats_generalrcmsg_from_date
common.rcm_stats_practice_analysisrcmspa_from_date
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
disp
TableColumn
aurora_standard.c8pvisdis_disp
aurora_standard.chmabstrexpired_disp
aurora_standard.chmptdatfinal_disp
aurora_standard.tmpmrrptexpired_disp
thru_date
TableColumn
aurora_standard.chmcptvceff_thru_date
aurora_standard.chmvrsnceff_thru_date
birth_date
TableColumn
aurora_standard.tmpmrrptedit_birth_date