aurora_standard.hl7in3

Field Type Null Default Key Extra Comment
hl7joinno smallint(6) YES
seg_in3 varchar(3) YES
set_id varchar(4) YES
cert_num varchar(59) YES
cert_by varchar(60) YES
cert_req varchar(1) YES
penalty varchar(10) YES
cert_date_time varchar(26) YES
cert_mod_d_t varchar(26) YES
operator varchar(60) YES
cert_begin_date varchar(8) YES
cert_end_date varchar(8) YES
days varchar(3) YES
non_concur_cd_desc varchar(60) YES
noncon_eff_d_t varchar(26) YES
phys_reviewer varchar(60) YES
certif_cont varchar(48) YES
cert_cont_ph_num varchar(40) YES
appeal_reasason varchar(60) YES
cert_agency varchar(60) YES
cert_agcy_ph_num varchar(40) YES
precert_req_wind varchar(40) YES
case_mngr varchar(48) YES
sec_opn_date varchar(8) YES
sec_opn_stat varchar(1) YES
sec_opn_doc_rec varchar(1) YES
sec_opn_phys varchar(60) YES
chs_rowID bigint(20) unsigned NO PRI auto_increment

References

Local Column References
days
TableColumn
HSPI_Bastrop.locationsinpatient_lag_days
HSPI_Bastrop.locationsoutpatient_lag_days
HSPI_CURES2015_B1.locationsinpatient_lag_days
HSPI_CURES2015_B1.locationsoutpatient_lag_days
HSPI_Central_Hospital.locationsinpatient_lag_days
HSPI_Central_Hospital.locationsoutpatient_lag_days
HSPI_Dewitt.locationsinpatient_lag_days
HSPI_Dewitt.locationsoutpatient_lag_days
HSPI_Fulton.locationsinpatient_lag_days
HSPI_Fulton.locationsoutpatient_lag_days
HSPI_Inferno.locationsinpatient_lag_days
HSPI_Inferno.locationsoutpatient_lag_days
HSPI_MU2015_E1.locationsinpatient_lag_days
HSPI_MU2015_E1.locationsoutpatient_lag_days
HSPI_MU2015_G2.locationsinpatient_lag_days
HSPI_MU2015_G2.locationsoutpatient_lag_days
HSPI_MU2015_G9.locationsinpatient_lag_days
HSPI_MU2015_G9.locationsoutpatient_lag_days
HSPI_Sandbox.locationsinpatient_lag_days
HSPI_Sandbox.locationsoutpatient_lag_days
HSPI_Summit_General.locationsinpatient_lag_days
HSPI_Summit_General.locationsoutpatient_lag_days
HSPI_United_Physicians.locationsinpatient_lag_days
HSPI_United_Physicians.locationsoutpatient_lag_days
MPI.locationsinpatient_lag_days
MPI.locationsoutpatient_lag_days
_1.appointment_recurrencearec_days
_1.appointment_recurrencearec_exclude_days
_1.clients_fee_schedules_mapcfsm_global_days
_1.encounters_cpt_codesecp_global_days
_1.orders_afpsoafp_lmp_gest_days
_1.orders_afpsoafp_us_gest_days
_1.recall_list_templatesrclt_days
_1188.appointment_recurrencearec_days
_1188.appointment_recurrencearec_exclude_days
_1188.clients_fee_schedules_mapcfsm_global_days
_1188.encounters_cpt_codesecp_global_days
_1188.orders_afpsoafp_lmp_gest_days
_1188.orders_afpsoafp_us_gest_days
_1188.recall_list_templatesrclt_days
_1218.appointment_recurrencearec_days
_1218.appointment_recurrencearec_exclude_days
_1218.clients_fee_schedules_mapcfsm_global_days
_1218.encounters_cpt_codesecp_global_days
_1218.orders_afpsoafp_lmp_gest_days
_1218.orders_afpsoafp_us_gest_days
_1218.recall_list_templatesrclt_days
_1548.appointment_recurrencearec_days
_1548.appointment_recurrencearec_exclude_days
_1548.clients_fee_schedules_mapcfsm_global_days
_1548.encounters_cpt_codesecp_global_days
_1548.orders_afpsoafp_lmp_gest_days
_1548.orders_afpsoafp_us_gest_days
_1548.recall_list_templatesrclt_days
_435.appointment_recurrencearec_days
_435.appointment_recurrencearec_exclude_days
_435.clients_fee_schedules_mapcfsm_global_days
_435.encounters_cpt_codesecp_global_days
_435.orders_afpsoafp_lmp_gest_days
_435.orders_afpsoafp_us_gest_days
_435.recall_list_templatesrclt_days
_436.appointment_recurrencearec_days
_436.appointment_recurrencearec_exclude_days
_436.clients_fee_schedules_mapcfsm_global_days
_436.encounters_cpt_codesecp_global_days
_436.orders_afpsoafp_lmp_gest_days
_436.orders_afpsoafp_us_gest_days
_436.recall_list_templatesrclt_days
_436_archive_testing.appointment_recurrencearec_days
_436_archive_testing.appointment_recurrencearec_exclude_days
_436_archive_testing.clients_fee_schedules_mapcfsm_global_days
_436_archive_testing.encounters_cpt_codesecp_global_days
_436_archive_testing.orders_afpsoafp_lmp_gest_days
_436_archive_testing.orders_afpsoafp_us_gest_days
_436_archive_testing.recall_list_templatesrclt_days
_437.appointment_recurrencearec_days
_437.appointment_recurrencearec_exclude_days
_437.clients_fee_schedules_mapcfsm_global_days
_437.encounters_cpt_codesecp_global_days
_437.orders_afpsoafp_lmp_gest_days
_437.orders_afpsoafp_us_gest_days
_437.recall_list_templatesrclt_days
_8.appointment_recurrencearec_days
_8.appointment_recurrencearec_exclude_days
_8.clients_fee_schedules_mapcfsm_global_days
_8.encounters_cpt_codesecp_global_days
_8.orders_afpsoafp_lmp_gest_days
_8.orders_afpsoafp_us_gest_days
_8.recall_list_templatesrclt_days
_81.appointment_recurrencearec_days
_81.appointment_recurrencearec_exclude_days
_81.clients_fee_schedules_mapcfsm_global_days
_81.encounters_cpt_codesecp_global_days
_81.orders_afpsoafp_lmp_gest_days
_81.orders_afpsoafp_us_gest_days
_81.recall_list_templatesrclt_days
_999.appointment_recurrencearec_days
_999.appointment_recurrencearec_exclude_days
_999.clients_fee_schedules_mapcfsm_global_days
_999.encounters_cpt_codesecp_global_days
_999.orders_afpsoafp_lmp_gest_days
_999.orders_afpsoafp_us_gest_days
_999.recall_list_templatesrclt_days
aurora_standard.acensusmtd_pat_days
aurora_standard.acensusytd_pat_days
aurora_standard.adshmdno_days
aurora_standard.adshrevno_days
aurora_standard.amcbdcoll_days
aurora_standard.chhcntrcstatement_days
aurora_standard.chhcntrcphys_lag_days
aurora_standard.chhcntrcint_lag_days
aurora_standard.chhl7in1lifetime_res_days
aurora_standard.chhl7in1policy_limit_days
aurora_standard.chm835pdnon_cov_days
aurora_standard.chm835pdcov_days
aurora_standard.chmardydar_days
aurora_standard.chmbenedi_precert_days
aurora_standard.chmbenedo_precert_days
aurora_standard.chmbenedfiling_days
aurora_standard.chmblogdnon_cov_days
aurora_standard.chmblogdcovered_days
aurora_standard.chmbremdnon_cov_days
aurora_standard.chmbremdcovered_days
aurora_standard.chmcntrcstatement_days
aurora_standard.chmcntrcphys_lag_days
aurora_standard.chmcntrcint_lag_days
aurora_standard.chmcntrcar_rev_days
aurora_standard.chmcontrfreq_days
aurora_standard.chmgltcda_bill_days
aurora_standard.chmgltcdb_bill_days
aurora_standard.chmibendfiling_days
aurora_standard.chmmesscage_days
aurora_standard.chmmhasticu_days
aurora_standard.chmmhastccu_days
aurora_standard.chmnotacno_days
aurora_standard.chmnotecno_days
aurora_standard.chmplogdnon_cov_days
aurora_standard.chmplogdcovered_days
aurora_standard.chmpnotcno_days
aurora_standard.chmspeccreview_days
aurora_standard.chmtkl1dtklr_days
aurora_standard.chmtkl2dtklr_days
aurora_standard.chmtkl3dtklr_days
aurora_standard.chmtkl4dtklr_days
aurora_standard.chmtkl5dtklr_days
aurora_standard.chmtkl6dtklr_days
aurora_standard.chmtkl7dtklr_days
aurora_standard.chmtkl8dtklr_days
aurora_standard.chmtkl9dtklr_days
aurora_standard.chqcmeudcme_days
aurora_standard.chrcntrclag_days
aurora_standard.chrdrugcauto_dc_days
aurora_standard.chxcntrcmam_notice_days
aurora_standard.chycntrcapp_notice_days
aurora_standard.hl7dg1outlier_days
aurora_standard.hl7in1lifetime_res_days
aurora_standard.hl7in1policy_limit_days
aurora_standard.hl7in1adlifetime_res_days
aurora_standard.hl7in1adpolicy_limit_days
aurora_standard.logdetldcovered_days
aurora_standard.logdetldnon_cov_days
aurora_standard.schopendatecopen_days
aurora_standard.sticntrcilocar_ina_days
aurora_standard.sticntrcilocar_ret_days
aurora_standard.stppytoreta_days
aurora_standard.stptermrdue_days
aurora_standard.stptermrdisc_days
aurora_standard.stpvendreta_days
aurora_standard.strcntrcauto_inactive_days
aurora_standard.strcntrcinactive_ret_days
aurora_standard.strtermrdue_days
aurora_standard.strtermrdisc_days
aurora_standard.stucntrcretention_days
aurora_standard.stucntrceta_days
inpatient_pricer.per_diem_adjustment_factorsno_days
set_id
TableColumn
HSPI_CURES2015_B1.invoice_batchesrule_set_id
HSPI_Central_Hospital.invoice_batchesrule_set_id
HSPI_Dewitt.invoice_batchesrule_set_id
HSPI_Fulton.invoice_batchesrule_set_id
HSPI_Inferno.invoice_batchesrule_set_id
HSPI_MU2015_E1.invoice_batchesrule_set_id
HSPI_MU2015_G2.invoice_batchesrule_set_id
HSPI_MU2015_G9.invoice_batchesrule_set_id
HSPI_Sandbox.invoice_batchesrule_set_id
HSPI_Summit_General.invoice_batchesrule_set_id
HSPI_United_Physicians.invoice_batchesrule_set_id
MPI.invoice_batchesrule_set_id
aurora_standard.vault_icd9sorder_set_id
operator
TableColumn
_1.clinical_alertsca_operator
_1.clinical_interventionsci_pat_age_operator
_1.clinical_interventions_vitals_mapcivm_operator
_1188.clinical_alertsca_operator
_1188.clinical_interventionsci_pat_age_operator
_1188.clinical_interventions_vitals_mapcivm_operator
_1218.clinical_alertsca_operator
_1218.clinical_interventionsci_pat_age_operator
_1218.clinical_interventions_vitals_mapcivm_operator
_1548.clinical_alertsca_operator
_1548.clinical_interventionsci_pat_age_operator
_1548.clinical_interventions_vitals_mapcivm_operator
_435.clinical_alertsca_operator
_435.clinical_interventionsci_pat_age_operator
_435.clinical_interventions_vitals_mapcivm_operator
_436.clinical_alertsca_operator
_436.clinical_interventionsci_pat_age_operator
_436.clinical_interventions_vitals_mapcivm_operator
_436_archive_testing.clinical_alertsca_operator
_436_archive_testing.clinical_interventionsci_pat_age_operator
_436_archive_testing.clinical_interventions_vitals_mapcivm_operator
_437.clinical_alertsca_operator
_437.clinical_interventionsci_pat_age_operator
_437.clinical_interventions_vitals_mapcivm_operator
_8.clinical_alertsca_operator
_8.clinical_interventionsci_pat_age_operator
_8.clinical_interventions_vitals_mapcivm_operator
_81.clinical_alertsca_operator
_81.clinical_interventionsci_pat_age_operator
_81.clinical_interventions_vitals_mapcivm_operator
_999.clinical_alertsca_operator
_999.clinical_interventionsci_pat_age_operator
_999.clinical_interventions_vitals_mapcivm_operator
cert_by
TableColumn
aurora_standard.chmadmidins_cert_by
aurora_standard.chmadmtrins_cert_by
aurora_standard.hhmadmtrins_cert_by
aurora_standard.visit_insurancesins_cert_by
cert_req
TableColumn
aurora_standard.chminsrcins_cert_req
aurora_standard.chpinsucins_cert_req