_1548.insurances_new

Field	Type	Null	Default	Key	Extra
ins_id	int(11)	NO		PRI	auto_increment
ins_cus_id	int(11)	NO		MUL
ins_cli_id	int(11)	NO		MUL
ins_lab_id	int(11)	NO		MUL
ins_name	varchar(40)	NO
ins_payer_id	varchar(5)	NO
ins_edi_payer	char(1)	NO
ins_global	char(1)	NO
ins_payer_type	varchar(10)	NO
ins_nationwide	char(1)	NO
ins_states	text	NO
ins_note	text	NO
ins_precert_files	text	NO
ins_cpt_analysis	char(1)	NO		MUL
ins_disabled	char(1)	NO
ins_modified	datetime	YES	CURRENT_TIMESTAMP
ins_created	datetime	YES	CURRENT_TIMESTAMP

References

Local Column

References

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

ins_name

Table	Column
_1.encounters_claims_statuses	ecs_ins_name
_1188.encounters_claims_statuses	ecs_ins_name
_1218.encounters_claims_statuses	ecs_ins_name
_1548.encounters_claims_statuses	ecs_ins_name
_435.encounters_claims_statuses	ecs_ins_name
_436.encounters_claims_statuses	ecs_ins_name
_436_archive_testing.encounters_claims_statuses	ecs_ins_name
_437.encounters_claims_statuses	ecs_ins_name
_8.encounters_claims_statuses	ecs_ins_name
_81.encounters_claims_statuses	ecs_ins_name
_999.encounters_claims_statuses	ecs_ins_name
aurora_standard.chmgltcr	oth_ins_name

ins_payer_id

Table	Column
_1.encounters_claims_statuses	ecs_ins_payer_id
_1188.encounters_claims_statuses	ecs_ins_payer_id
_1218.encounters_claims_statuses	ecs_ins_payer_id
_1548.encounters_claims_statuses	ecs_ins_payer_id
_435.encounters_claims_statuses	ecs_ins_payer_id
_436.encounters_claims_statuses	ecs_ins_payer_id
_436_archive_testing.encounters_claims_statuses	ecs_ins_payer_id
_437.encounters_claims_statuses	ecs_ins_payer_id
_8.encounters_claims_statuses	ecs_ins_payer_id
_81.encounters_claims_statuses	ecs_ins_payer_id
_999.encounters_claims_statuses	ecs_ins_payer_id