aurora_standard.chmokopd

Field Type Null Default Key Extra Comment
pat_name varchar(30) YES
pat_addr varchar(70) YES
pat_city varchar(25) YES
pat_st varchar(2) YES
pat_zip varchar(10) YES
pat_dob varchar(8) YES
pat_sex varchar(1) YES
blank_1 varchar(5) YES
pat_ssn varchar(8) YES
pat_race varchar(1) YES
pat_ethnic varchar(1) YES
pat_marital varchar(1) YES
pat_visit_no varchar(17) YES
pat_mr_no varchar(17) YES
mc_provider varchar(6) YES
npi_no varchar(10) YES
adm_dt varchar(8) YES
adm_hr varchar(2) YES
dischg_dt varchar(8) YES
dischg_hr varchar(2) YES
adm_src varchar(1) YES
adm_typ varchar(1) YES
dischg_status varchar(2) YES
e_code varchar(8) YES
e_code2 varchar(8) YES
e_code3 varchar(8) YES
att_phy varchar(11) YES
apc_1 varchar(4) YES
prin_dx varchar(7) YES
dx01 varchar(7) YES
dx02 varchar(7) YES
dx03 varchar(7) YES
dx04 varchar(7) YES
dx05 varchar(7) YES
dx06 varchar(7) YES
dx07 varchar(7) YES
dx08 varchar(7) YES
dx09 varchar(7) YES
dx10 varchar(7) YES
dx11 varchar(7) YES
dx12 varchar(7) YES
dx13 varchar(7) YES
dx14 varchar(7) YES
dx15 varchar(7) YES
prin_cpt varchar(13) YES
cpt01 varchar(13) YES
cpt02 varchar(13) YES
cpt03 varchar(13) YES
cpt04 varchar(13) YES
cpt05 varchar(13) YES
prin_proc_phy varchar(11) YES
proc01_phy varchar(11) YES
proc02_phy varchar(11) YES
proc03_phy varchar(11) YES
proc04_phy varchar(11) YES
proc05_phy varchar(11) YES
prin_proc_dt varchar(8) YES
proc01_dt varchar(8) YES
proc02_dt varchar(8) YES
proc03_dt varchar(8) YES
proc04_dt varchar(8) YES
proc05_dt varchar(8) YES
primary_id varchar(15) YES
primary_name varchar(25) YES
secondary_id varchar(15) YES
secondary_name varchar(25) YES
pri_payer_class varchar(1) YES
tot_charges varchar(7) YES
amt100 varchar(6) YES
amt110 varchar(6) YES
amt120 varchar(6) YES
amt130 varchar(6) YES
amt140 varchar(6) YES
amt150 varchar(6) YES
amt160 varchar(6) YES
amt170 varchar(6) YES
amt180 varchar(6) YES
amt190 varchar(6) YES
amt200 varchar(6) YES
amt210 varchar(6) YES
amt220 varchar(6) YES
amt230 varchar(6) YES
amt240 varchar(6) YES
amt250 varchar(6) YES
amt260 varchar(6) YES
amt270 varchar(6) YES
amt280 varchar(6) YES
amt290 varchar(6) YES
amt300 varchar(6) YES
amt310 varchar(6) YES
amt320 varchar(6) YES
amt330 varchar(6) YES
amt340 varchar(6) YES
amt350 varchar(6) YES
amt360 varchar(6) YES
amt370 varchar(6) YES
amt380 varchar(6) YES
amt390 varchar(6) YES
amt400 varchar(6) YES
amt410 varchar(6) YES
amt420 varchar(6) YES
amt430 varchar(6) YES
amt440 varchar(6) YES
amt450 varchar(6) YES
amt460 varchar(6) YES
amt470 varchar(6) YES
amt480 varchar(6) YES
amt490 varchar(6) YES
amt500 varchar(6) YES
amt510 varchar(6) YES
amt520 varchar(6) YES
amt530 varchar(6) YES
amt540 varchar(6) YES
amt550 varchar(6) YES
amt560 varchar(6) YES
amt570 varchar(6) YES
amt580 varchar(6) YES
amt590 varchar(6) YES
amt600 varchar(6) YES
amt610 varchar(6) YES
amt620 varchar(6) YES
amt630 varchar(6) YES
amt640 varchar(6) YES
amt650 varchar(6) YES
amt660 varchar(6) YES
amt670 varchar(6) YES
amt680 varchar(6) YES
amt690 varchar(6) YES
amt700 varchar(6) YES
amt710 varchar(6) YES
amt720 varchar(6) YES
amt730 varchar(6) YES
amt740 varchar(6) YES
amt750 varchar(6) YES
amt760 varchar(6) YES
amt770 varchar(6) YES
amt780 varchar(6) YES
amt790 varchar(6) YES
amt800 varchar(6) YES
amt810 varchar(6) YES
amt820 varchar(6) YES
amt830 varchar(6) YES
amt840 varchar(6) YES
amt850 varchar(6) YES
amt860 varchar(6) YES
amt870 varchar(6) YES
amt880 varchar(6) YES
amt890 varchar(6) YES
amt900 varchar(6) YES
amt910 varchar(6) YES
amt920 varchar(6) YES
amt930 varchar(6) YES
amt940 varchar(6) YES
amt950 varchar(6) YES
amt960 varchar(6) YES
amt970 varchar(6) YES
amt980 varchar(6) YES
amt990 varchar(6) YES
amt1000 varchar(6) YES
amt1010 varchar(6) YES
amt2100 varchar(6) YES
amt2110 varchar(6) YES
amt3100 varchar(6) YES
amt3110 varchar(6) YES
u100 varchar(7) YES
u110 varchar(7) YES
u120 varchar(7) YES
u130 varchar(7) YES
u140 varchar(7) YES
u150 varchar(7) YES
u160 varchar(7) YES
u170 varchar(7) YES
u180 varchar(7) YES
u190 varchar(7) YES
u200 varchar(7) YES
u210 varchar(7) YES
u220 varchar(7) YES
u230 varchar(7) YES
u240 varchar(7) YES
u250 varchar(7) YES
u260 varchar(7) YES
u270 varchar(7) YES
u280 varchar(7) YES
u290 varchar(7) YES
u300 varchar(7) YES
u310 varchar(7) YES
u320 varchar(7) YES
u330 varchar(7) YES
u340 varchar(7) YES
u350 varchar(7) YES
u360 varchar(7) YES
u370 varchar(7) YES
u380 varchar(7) YES
u390 varchar(7) YES
u400 varchar(7) YES
u410 varchar(7) YES
u420 varchar(7) YES
u430 varchar(7) YES
u440 varchar(7) YES
u450 varchar(7) YES
u460 varchar(7) YES
u470 varchar(7) YES
u480 varchar(7) YES
u490 varchar(7) YES
u500 varchar(7) YES
u510 varchar(7) YES
u520 varchar(7) YES
u530 varchar(7) YES
u540 varchar(7) YES
u550 varchar(7) YES
u560 varchar(7) YES
u570 varchar(7) YES
u580 varchar(7) YES
u590 varchar(7) YES
u600 varchar(7) YES
u610 varchar(7) YES
u620 varchar(7) YES
u630 varchar(7) YES
u640 varchar(7) YES
u650 varchar(7) YES
u660 varchar(7) YES
u670 varchar(7) YES
u680 varchar(7) YES
u690 varchar(7) YES
u700 varchar(7) YES
u710 varchar(7) YES
u720 varchar(7) YES
u730 varchar(7) YES
u740 varchar(7) YES
u750 varchar(7) YES
u760 varchar(7) YES
u770 varchar(7) YES
u780 varchar(7) YES
u790 varchar(7) YES
u800 varchar(7) YES
u810 varchar(7) YES
u820 varchar(7) YES
u830 varchar(7) YES
u840 varchar(7) YES
u850 varchar(7) YES
u860 varchar(7) YES
u870 varchar(7) YES
u880 varchar(7) YES
u890 varchar(7) YES
u900 varchar(7) YES
u910 varchar(7) YES
u920 varchar(7) YES
u930 varchar(7) YES
u940 varchar(7) YES
u950 varchar(7) YES
u960 varchar(7) YES
u970 varchar(7) YES
u980 varchar(7) YES
u990 varchar(7) YES
u1000 varchar(7) YES
u1010 varchar(7) YES
u2100 varchar(7) YES
u2110 varchar(7) YES
u3100 varchar(7) YES
u3110 varchar(7) YES
bill_type varchar(4) YES
apc_2 varchar(4) YES
apc_3 varchar(4) YES
chs_rowID bigint(20) unsigned NO PRI auto_increment

References

Local Column References
primary_id
TableColumn
HSPI_System.portal_theme_configslogo_primary_id
secondary_id
TableColumn
_1.billing_providersbp_secondary_id
_1188.billing_providersbp_secondary_id
_1218.billing_providersbp_secondary_id
_1548.billing_providersbp_secondary_id
_8.billing_providersbp_secondary_id
_81.billing_providersbp_secondary_id
_999.billing_providersbp_secondary_id
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
pat_sex
TableColumn
_1.clinical_alertsca_pat_sex
_1.clinical_interventionsci_pat_sex
_1188.clinical_alertsca_pat_sex
_1188.clinical_interventionsci_pat_sex
_1218.clinical_alertsca_pat_sex
_1218.clinical_interventionsci_pat_sex
_1548.clinical_alertsca_pat_sex
_1548.clinical_interventionsci_pat_sex
_435.clinical_alertsca_pat_sex
_435.clinical_interventionsci_pat_sex
_436.clinical_alertsca_pat_sex
_436.clinical_interventionsci_pat_sex
_436_archive_testing.clinical_alertsca_pat_sex
_436_archive_testing.clinical_interventionsci_pat_sex
_437.clinical_alertsca_pat_sex
_437.clinical_interventionsci_pat_sex
_8.clinical_alertsca_pat_sex
_8.clinical_interventionsci_pat_sex
_81.clinical_alertsca_pat_sex
_81.clinical_interventionsci_pat_sex
_999.clinical_alertsca_pat_sex
_999.clinical_interventionsci_pat_sex
dx10
TableColumn
_1.encounters_cpt_codesecp_dx10
_1188.encounters_cpt_codesecp_dx10
_1218.encounters_cpt_codesecp_dx10
_1548.encounters_cpt_codesecp_dx10
_435.encounters_cpt_codesecp_dx10
_436.encounters_cpt_codesecp_dx10
_436_archive_testing.encounters_cpt_codesecp_dx10
_437.encounters_cpt_codesecp_dx10
_8.encounters_cpt_codesecp_dx10
_81.encounters_cpt_codesecp_dx10
_999.encounters_cpt_codesecp_dx10
aurora_standard.chmmhastother_dx10
aurora_standard.chmmhastpoa_dx10
e_code
TableColumn
_1.encounters_ub04enc_ub04_74_e_code
_1188.encounters_ub04enc_ub04_74_e_code
_1218.encounters_ub04enc_ub04_74_e_code
_1548.encounters_ub04enc_ub04_74_e_code
_435.encounters_ub04enc_ub04_74_e_code
_436.encounters_ub04enc_ub04_74_e_code
_436_archive_testing.encounters_ub04enc_ub04_74_e_code
_437.encounters_ub04enc_ub04_74_e_code
_8.encounters_ub04enc_ub04_74_e_code
_81.encounters_ub04enc_ub04_74_e_code
_999.encounters_ub04enc_ub04_74_e_code
adm_dt
TableColumn
aurora_standard.acampilast_adm_dt
aurora_standard.bhppatlast_adm_dt
aurora_standard.bhtppatlast_adm_dt
adm_hr
TableColumn
aurora_standard.bhppatlast_adm_hr
aurora_standard.bhtppatlast_adm_hr
dx11
TableColumn
aurora_standard.chmmhastother_dx11
aurora_standard.chmmhastpoa_dx11
dx12
TableColumn
aurora_standard.chmmhastother_dx12
aurora_standard.chmmhastpoa_dx12
dx13
TableColumn
aurora_standard.chmmhastother_dx13
aurora_standard.chmmhastpoa_dx13
dx14
TableColumn
aurora_standard.chmmhastother_dx14
aurora_standard.chmmhastpoa_dx14
dx15
TableColumn
aurora_standard.chmmhastother_dx15
aurora_standard.chmmhastpoa_dx15
att_phy
TableColumn
aurora_standard.chmmhastco_att_phy
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
adm_typ
TableColumn
aurora_standard.chmstatcdef_adm_typ