aurora_standard.bmins

Field	Type	Null
visit_no	char(20)	YES
seq_no	char(10)	YES
ins_id	char(10)	YES
plan_id	char(10)	YES
policy_no	char(20)	YES
group_no	char(20)	YES
ins_paid_amt	decimal(10,2)	YES
effect_dt	char(20)	YES
end_dt	char(20)	YES

References

Local Column

References

plan_id

Table	Column
HSPI_Bastrop.care_plan_activities	care_plan_id
HSPI_Bastrop.encounters	care_plan_id
HSPI_CURES2015_B1.care_plan_activities	care_plan_id
HSPI_CURES2015_B1.care_plans_categories_map	care_plan_id
HSPI_CURES2015_B1.encounters	care_plan_id
HSPI_CURES2015_B1.locations	pay_to_plan_id
HSPI_Central_Hospital.care_plan_activities	care_plan_id
HSPI_Central_Hospital.care_plans_categories_map	care_plan_id
HSPI_Central_Hospital.encounters	care_plan_id
HSPI_Central_Hospital.locations	pay_to_plan_id
HSPI_Dewitt.care_plan_activities	care_plan_id
HSPI_Dewitt.care_plans_categories_map	care_plan_id
HSPI_Dewitt.encounters	care_plan_id
HSPI_Dewitt.locations	pay_to_plan_id
HSPI_Fulton.care_plan_activities	care_plan_id
HSPI_Fulton.care_plans_categories_map	care_plan_id
HSPI_Fulton.encounters	care_plan_id
HSPI_Fulton.locations	pay_to_plan_id
HSPI_Inferno.care_plan_activities	care_plan_id
HSPI_Inferno.care_plans_categories_map	care_plan_id
HSPI_Inferno.encounters	care_plan_id
HSPI_Inferno.locations	pay_to_plan_id
HSPI_MU2015_E1.care_plan_activities	care_plan_id
HSPI_MU2015_E1.care_plans_categories_map	care_plan_id
HSPI_MU2015_E1.encounters	care_plan_id
HSPI_MU2015_E1.locations	pay_to_plan_id
HSPI_MU2015_G2.care_plan_activities	care_plan_id
HSPI_MU2015_G2.care_plans_categories_map	care_plan_id
HSPI_MU2015_G2.encounters	care_plan_id
HSPI_MU2015_G2.locations	pay_to_plan_id
HSPI_MU2015_G9.care_plan_activities	care_plan_id
HSPI_MU2015_G9.care_plans_categories_map	care_plan_id
HSPI_MU2015_G9.encounters	care_plan_id
HSPI_MU2015_G9.locations	pay_to_plan_id
HSPI_Sandbox.care_plan_activities	care_plan_id
HSPI_Sandbox.care_plans_categories_map	care_plan_id
HSPI_Sandbox.encounters	care_plan_id
HSPI_Sandbox.locations	pay_to_plan_id
HSPI_Summit_General.care_plan_activities	care_plan_id
HSPI_Summit_General.care_plans_categories_map	care_plan_id
HSPI_Summit_General.encounters	care_plan_id
HSPI_Summit_General.locations	pay_to_plan_id
HSPI_United_Physicians.care_plan_activities	care_plan_id
HSPI_United_Physicians.care_plans_categories_map	care_plan_id
HSPI_United_Physicians.encounters	care_plan_id
HSPI_United_Physicians.locations	pay_to_plan_id
MPI.care_plan_activities	care_plan_id
MPI.care_plans_categories_map	care_plan_id
MPI.encounters	care_plan_id
MPI.locations	pay_to_plan_id
aurora_standard.chhl7in1	ins_plan_id
aurora_standard.chhl7in1	prior_ins_plan_id
aurora_standard.hl7ft1	ins_plan_id
aurora_standard.hl7in1	ins_plan_id
aurora_standard.hl7in1	prior_ins_plan_id
aurora_standard.hl7in1ad	ins_plan_id
aurora_standard.hl7in1ad	prior_ins_plan_id

ins_id

Table	Column
_1.audits	aud_ins_id
_1.audits_archive	aud_ins_id
_1.cpt_analysis_codes	cac_ins_id
_1.encounters_claims_statuses	ecs_ins_id
_1.encounters_payments	epay_ins_id
_1.encounters_payments_edi_logs	epel_ins_id
_1.insurances_allowables_ins_map	iaim_ins_id
_1.insurances_allowed_amounts	iam_ins_id
_1.insurances_claims_centers	icc_ins_id
_1.insurances_classes_map	icm_ins_id
_1.insurances_contracted_pricing	icp_ins_id
_1.insurances_contracted_pricing_log	icpl_ins_id
_1.insurances_group_billing	igb_ins_id
_1.insurances_repository	irep_ins_id
_1.insurances_servicing_states	iss_ins_id
_1.insurances_stats	is_ins_id
_1.insurances_verification	iv_ins_id
_1.ledger	led_ins_id
_1.patients_images	pi_ins_id
_1.physicians_pins	pin_ins_id
_1.precerts_cpt_codes_insurance_statuses_map	pcpis_ins_id
_1.schedules_insurances_blocks	schins_ins_id
_1.voided_payments	vp_ins_id
_1188.audits	aud_ins_id
_1188.audits_archive	aud_ins_id
_1188.cpt_analysis_codes	cac_ins_id
_1188.encounters_claims_statuses	ecs_ins_id
_1188.encounters_payments	epay_ins_id
_1188.encounters_payments_edi_logs	epel_ins_id
_1188.insurances_allowables_ins_map	iaim_ins_id
_1188.insurances_allowed_amounts	iam_ins_id
_1188.insurances_claims_centers	icc_ins_id
_1188.insurances_classes_map	icm_ins_id
_1188.insurances_contracted_pricing	icp_ins_id
_1188.insurances_contracted_pricing_log	icpl_ins_id
_1188.insurances_group_billing	igb_ins_id
_1188.insurances_repository	irep_ins_id
_1188.insurances_servicing_states	iss_ins_id
_1188.insurances_stats	is_ins_id
_1188.insurances_verification	iv_ins_id
_1188.ledger	led_ins_id
_1188.patients_images	pi_ins_id
_1188.physicians_pins	pin_ins_id
_1188.precerts_cpt_codes_insurance_statuses_map	pcpis_ins_id
_1188.schedules_insurances_blocks	schins_ins_id
_1188.voided_payments	vp_ins_id
_1218.audits	aud_ins_id
_1218.audits_archive	aud_ins_id
_1218.cpt_analysis_codes	cac_ins_id
_1218.encounters_claims_statuses	ecs_ins_id
_1218.encounters_payments	epay_ins_id
_1218.encounters_payments_edi_logs	epel_ins_id
_1218.insurances_allowables_ins_map	iaim_ins_id
_1218.insurances_allowed_amounts	iam_ins_id
_1218.insurances_claims_centers	icc_ins_id
_1218.insurances_classes_map	icm_ins_id
_1218.insurances_contracted_pricing	icp_ins_id
_1218.insurances_contracted_pricing_log	icpl_ins_id
_1218.insurances_group_billing	igb_ins_id
_1218.insurances_repository	irep_ins_id
_1218.insurances_servicing_states	iss_ins_id
_1218.insurances_stats	is_ins_id
_1218.insurances_verification	iv_ins_id
_1218.ledger	led_ins_id
_1218.patients_images	pi_ins_id
_1218.physicians_pins	pin_ins_id
_1218.precerts_cpt_codes_insurance_statuses_map	pcpis_ins_id
_1218.schedules_insurances_blocks	schins_ins_id
_1218.voided_payments	vp_ins_id
_1548.audits	aud_ins_id
_1548.audits_archive	aud_ins_id
_1548.cpt_analysis_codes	cac_ins_id
_1548.encounters_claims_statuses	ecs_ins_id
_1548.encounters_payments	epay_ins_id
_1548.encounters_payments_edi_logs	epel_ins_id
_1548.insurances_allowables_ins_map	iaim_ins_id
_1548.insurances_allowed_amounts	iam_ins_id
_1548.insurances_claims_centers	icc_ins_id
_1548.insurances_classes_map	icm_ins_id
_1548.insurances_contracted_pricing	icp_ins_id
_1548.insurances_contracted_pricing_log	icpl_ins_id
_1548.insurances_group_billing	igb_ins_id
_1548.insurances_repository	irep_ins_id
_1548.insurances_servicing_states	iss_ins_id
_1548.insurances_stats	is_ins_id
_1548.insurances_verification	iv_ins_id
_1548.ledger	led_ins_id
_1548.patients_images	pi_ins_id
_1548.physicians_pins	pin_ins_id
_1548.precerts_cpt_codes_insurance_statuses_map	pcpis_ins_id
_1548.schedules_insurances_blocks	schins_ins_id
_1548.voided_payments	vp_ins_id
_435.audits	aud_ins_id
_435.audits_archive	aud_ins_id
_435.cpt_analysis_codes	cac_ins_id
_435.encounters_claims_statuses	ecs_ins_id
_435.encounters_payments	epay_ins_id
_435.encounters_payments_edi_logs	epel_ins_id
_435.insurances_allowables_ins_map	iaim_ins_id
_435.insurances_allowed_amounts	iam_ins_id
_435.insurances_claims_centers	icc_ins_id
_435.insurances_classes_map	icm_ins_id
_435.insurances_contracted_pricing	icp_ins_id
_435.insurances_contracted_pricing_log	icpl_ins_id
_435.insurances_group_billing	igb_ins_id
_435.insurances_repository	irep_ins_id
_435.insurances_servicing_states	iss_ins_id
_435.insurances_stats	is_ins_id
_435.insurances_verification	iv_ins_id
_435.ledger	led_ins_id
_435.patients_images	pi_ins_id
_435.physicians_pins	pin_ins_id
_435.precerts_cpt_codes_insurance_statuses_map	pcpis_ins_id
_435.schedules_insurances_blocks	schins_ins_id
_435.voided_payments	vp_ins_id
_436.audits	aud_ins_id
_436.audits_archive	aud_ins_id
_436.cpt_analysis_codes	cac_ins_id
_436.encounters_claims_statuses	ecs_ins_id
_436.encounters_payments	epay_ins_id
_436.encounters_payments_edi_logs	epel_ins_id
_436.insurances_allowables_ins_map	iaim_ins_id
_436.insurances_allowed_amounts	iam_ins_id
_436.insurances_claims_centers	icc_ins_id
_436.insurances_classes_map	icm_ins_id
_436.insurances_contracted_pricing	icp_ins_id
_436.insurances_contracted_pricing_log	icpl_ins_id
_436.insurances_group_billing	igb_ins_id
_436.insurances_repository	irep_ins_id
_436.insurances_servicing_states	iss_ins_id
_436.insurances_stats	is_ins_id
_436.insurances_verification	iv_ins_id
_436.ledger	led_ins_id
_436.patients_images	pi_ins_id
_436.physicians_pins	pin_ins_id
_436.precerts_cpt_codes_insurance_statuses_map	pcpis_ins_id
_436.schedules_insurances_blocks	schins_ins_id
_436.voided_payments	vp_ins_id
_436_archive_testing.audits	aud_ins_id
_436_archive_testing.audits_archive	aud_ins_id
_436_archive_testing.cpt_analysis_codes	cac_ins_id
_436_archive_testing.encounters_claims_statuses	ecs_ins_id
_436_archive_testing.encounters_payments	epay_ins_id
_436_archive_testing.encounters_payments_edi_logs	epel_ins_id
_436_archive_testing.insurances_allowables_ins_map	iaim_ins_id
_436_archive_testing.insurances_allowed_amounts	iam_ins_id
_436_archive_testing.insurances_claims_centers	icc_ins_id
_436_archive_testing.insurances_classes_map	icm_ins_id
_436_archive_testing.insurances_contracted_pricing	icp_ins_id
_436_archive_testing.insurances_contracted_pricing_log	icpl_ins_id
_436_archive_testing.insurances_group_billing	igb_ins_id
_436_archive_testing.insurances_repository	irep_ins_id
_436_archive_testing.insurances_servicing_states	iss_ins_id
_436_archive_testing.insurances_stats	is_ins_id
_436_archive_testing.insurances_verification	iv_ins_id
_436_archive_testing.ledger	led_ins_id
_436_archive_testing.patients_images	pi_ins_id
_436_archive_testing.physicians_pins	pin_ins_id
_436_archive_testing.precerts_cpt_codes_insurance_statuses_map	pcpis_ins_id
_436_archive_testing.schedules_insurances_blocks	schins_ins_id
_436_archive_testing.voided_payments	vp_ins_id
_437.audits	aud_ins_id
_437.audits_archive	aud_ins_id
_437.cpt_analysis_codes	cac_ins_id
_437.encounters_claims_statuses	ecs_ins_id
_437.encounters_payments	epay_ins_id
_437.encounters_payments_edi_logs	epel_ins_id
_437.insurances_allowables_ins_map	iaim_ins_id
_437.insurances_allowed_amounts	iam_ins_id
_437.insurances_claims_centers	icc_ins_id
_437.insurances_classes_map	icm_ins_id
_437.insurances_contracted_pricing	icp_ins_id
_437.insurances_contracted_pricing_log	icpl_ins_id
_437.insurances_group_billing	igb_ins_id
_437.insurances_repository	irep_ins_id
_437.insurances_servicing_states	iss_ins_id
_437.insurances_stats	is_ins_id
_437.insurances_verification	iv_ins_id
_437.ledger	led_ins_id
_437.patients_images	pi_ins_id
_437.physicians_pins	pin_ins_id
_437.precerts_cpt_codes_insurance_statuses_map	pcpis_ins_id
_437.schedules_insurances_blocks	schins_ins_id
_437.voided_payments	vp_ins_id
_8.audits	aud_ins_id
_8.audits_archive	aud_ins_id
_8.cpt_analysis_codes	cac_ins_id
_8.daily_close_calculations	dcc_ins_id
_8.encounters_claims_statuses	ecs_ins_id
_8.encounters_payments	epay_ins_id
_8.encounters_payments_edi_logs	epel_ins_id
_8.insurances_allowables_ins_map	iaim_ins_id
_8.insurances_allowed_amounts	iam_ins_id
_8.insurances_claims_centers	icc_ins_id
_8.insurances_classes_map	icm_ins_id
_8.insurances_contracted_pricing	icp_ins_id
_8.insurances_contracted_pricing_log	icpl_ins_id
_8.insurances_group_billing	igb_ins_id
_8.insurances_repository	irep_ins_id
_8.insurances_servicing_states	iss_ins_id
_8.insurances_stats	is_ins_id
_8.insurances_verification	iv_ins_id
_8.ledger	led_ins_id
_8.patients_images	pi_ins_id
_8.physicians_pins	pin_ins_id
_8.precerts_cpt_codes_insurance_statuses_map	pcpis_ins_id
_8.schedules_insurances_blocks	schins_ins_id
_8.voided_payments	vp_ins_id
_81.audits	aud_ins_id
_81.audits_archive	aud_ins_id
_81.cpt_analysis_codes	cac_ins_id
_81.encounters_claims_statuses	ecs_ins_id
_81.encounters_payments	epay_ins_id
_81.encounters_payments_edi_logs	epel_ins_id
_81.insurances_allowables_ins_map	iaim_ins_id
_81.insurances_allowed_amounts	iam_ins_id
_81.insurances_claims_centers	icc_ins_id
_81.insurances_classes_map	icm_ins_id
_81.insurances_contracted_pricing	icp_ins_id
_81.insurances_contracted_pricing_log	icpl_ins_id
_81.insurances_group_billing	igb_ins_id
_81.insurances_repository	irep_ins_id
_81.insurances_servicing_states	iss_ins_id
_81.insurances_stats	is_ins_id
_81.insurances_verification	iv_ins_id
_81.ledger	led_ins_id
_81.patients_images	pi_ins_id
_81.physicians_pins	pin_ins_id
_81.precerts_cpt_codes_insurance_statuses_map	pcpis_ins_id
_81.schedules_insurances_blocks	schins_ins_id
_81.voided_payments	vp_ins_id
_999.audits	aud_ins_id
_999.audits_archive	aud_ins_id
_999.cpt_analysis_codes	cac_ins_id
_999.encounters_claims_statuses	ecs_ins_id
_999.encounters_payments	epay_ins_id
_999.encounters_payments_edi_logs	epel_ins_id
_999.insurances_allowables_ins_map	iaim_ins_id
_999.insurances_allowed_amounts	iam_ins_id
_999.insurances_claims_centers	icc_ins_id
_999.insurances_classes_map	icm_ins_id
_999.insurances_contracted_pricing	icp_ins_id
_999.insurances_contracted_pricing_log	icpl_ins_id
_999.insurances_group_billing	igb_ins_id
_999.insurances_repository	irep_ins_id
_999.insurances_servicing_states	iss_ins_id
_999.insurances_stats	is_ins_id
_999.insurances_verification	iv_ins_id
_999.ledger	led_ins_id
_999.patients_images	pi_ins_id
_999.physicians_pins	pin_ins_id
_999.precerts_cpt_codes_insurance_statuses_map	pcpis_ins_id
_999.schedules_insurances_blocks	schins_ins_id
_999.voided_payments	vp_ins_id
common.ahi_audits	aud_ins_id

end_dt

Table	Column
_1.charts_procedures	cp_end_dt
_1.patients_enrollments	pert_end_dt
_1.patients_health_concerns	phc_end_dt
_1.patients_names	pn_end_dt
_1188.charts_procedures	cp_end_dt
_1188.patients_enrollments	pert_end_dt
_1188.patients_health_concerns	phc_end_dt
_1188.patients_names	pn_end_dt
_1218.charts_procedures	cp_end_dt
_1218.patients_enrollments	pert_end_dt
_1218.patients_health_concerns	phc_end_dt
_1218.patients_names	pn_end_dt
_1548.charts_procedures	cp_end_dt
_1548.patients_enrollments	pert_end_dt
_1548.patients_health_concerns	phc_end_dt
_1548.patients_names	pn_end_dt
_435.charts_procedures	cp_end_dt
_435.patients_enrollments	pert_end_dt
_435.patients_health_concerns	phc_end_dt
_435.patients_names	pn_end_dt
_436.charts_procedures	cp_end_dt
_436.patients_enrollments	pert_end_dt
_436.patients_health_concerns	phc_end_dt
_436.patients_names	pn_end_dt
_436_archive_testing.charts_procedures	cp_end_dt
_436_archive_testing.patients_enrollments	pert_end_dt
_436_archive_testing.patients_health_concerns	phc_end_dt
_437.charts_procedures	cp_end_dt
_437.patients_enrollments	pert_end_dt
_437.patients_health_concerns	phc_end_dt
_437.patients_names	pn_end_dt
_8.charts_procedures	cp_end_dt
_8.patients_enrollments	pert_end_dt
_8.patients_health_concerns	phc_end_dt
_8.patients_names	pn_end_dt
_81.charts_procedures	cp_end_dt
_81.patients_enrollments	pert_end_dt
_81.patients_health_concerns	phc_end_dt
_81.patients_names	pn_end_dt
_999.charts_procedures	cp_end_dt
_999.patients_enrollments	pert_end_dt
_999.patients_health_concerns	phc_end_dt
_999.patients_names	pn_end_dt

visit_no

Table	Column
aurora_standard.anotesd	an_visit_no
aurora_standard.bdfiled	bd_visit_no
aurora_standard.chmarsi	pat_visit_no
aurora_standard.chmcampi	pat_visit_no
aurora_standard.chmcombr	to_visit_no
aurora_standard.chmexmpi	pat_visit_no
aurora_standard.chmokipd	pat_visit_no
aurora_standard.chmokopd	pat_visit_no
aurora_standard.chmraded	pat_visit_no
aurora_standard.chmradex	pat_visit_no
aurora_standard.chrcombr	to_visit_no
aurora_standard.ncexmpi	pat_visit_no

group_no

Table	Column
aurora_standard.chmarsi	ins1_group_no
aurora_standard.chmarsi	ins2_group_no
aurora_standard.chmarsi	ins3_group_no
aurora_standard.chmcampi	ins1_group_no
aurora_standard.chmcampi	ins2_group_no
aurora_standard.chmcampi	ins3_group_no
aurora_standard.chmexmpi	ins1_group_no
aurora_standard.chmexmpi	ins2_group_no
aurora_standard.chmexmpi	ins3_group_no
aurora_standard.chmexvis	ins1_group_no
aurora_standard.chmexvis	ins2_group_no
aurora_standard.chmexvis	ins3_group_no
aurora_standard.chmpdemo	ins1_group_no
aurora_standard.chmpdemo	ins2_group_no
aurora_standard.chmpdemo	ins3_group_no
aurora_standard.chmradex	ins1_group_no
aurora_standard.chmradex	ins2_group_no
aurora_standard.chmradex	ins3_group_no
aurora_standard.chpcobrd	cobra_group_no

seq_no

Table	Column
aurora_standard.chmarsta	rec_seq_no
aurora_standard.chmarstac	rec_seq_no
aurora_standard.chmarstai	rec_seq_no
aurora_standard.chmarstd	rec_seq_no
aurora_standard.chmarstdi	rec_seq_no
aurora_standard.chmarste	rec_seq_no
aurora_standard.chmarsth	rec_seq_no
aurora_standard.chmarsthi	rec_seq_no
aurora_standard.chmarstph	rec_seq_no
aurora_standard.chmarstpi	rec_seq_no
aurora_standard.chmarstpo	rec_seq_no
aurora_standard.chmarstpq	rec_seq_no
aurora_standard.chmarstpr	rec_seq_no
aurora_standard.chmarstps	rec_seq_no
aurora_standard.chmarstpt	rec_seq_no
aurora_standard.chmarstpy	rec_seq_no
aurora_standard.chmcosta	rec_seq_no
aurora_standard.chmcostb	rec_seq_no
aurora_standard.chmcostd	rec_seq_no
aurora_standard.chmcostrc	rec_seq_no
aurora_standard.chmgltcd	a_seq_no
aurora_standard.chmgltcd	b_seq_no
aurora_standard.chmhid4a	rec_seq_no
aurora_standard.chmhid4b	rec_seq_no
aurora_standard.chmhid4c	rec_seq_no
aurora_standard.chmhid4d	rec_seq_no
aurora_standard.chmhid4g	rec_seq_no
aurora_standard.chrhhdcc	listing_seq_no
aurora_standard.chrhhmpr	listing_seq_no
aurora_standard.chrhhndc	listing_seq_no
aurora_standard.chrhhndc	firm_seq_no
aurora_standard.chrhhroc	listing_seq_no
aurora_standard.chrmndc	listing_seq_no
aurora_standard.chrmndc	firm_seq_no
aurora_standard.chxhistd	h_seq_no
aurora_standard.chyhistd	h_seq_no
aurora_standard.drugclas	listing_seq_no
aurora_standard.formulat	listing_seq_no
aurora_standard.listings	listing_seq_no
aurora_standard.listings	firm_seq_no
aurora_standard.package	listing_seq_no
aurora_standard.routes	listing_seq_no

policy_no

Table	Column
aurora_standard.chqliabd	liab_policy_no