_436_archive_testing.insurances

Field	Type	Null	Default	Key	Extra	Comment
ins_id	int(11)	NO		PRI	auto_increment
ins_cus_id	int(11)	NO	0	MUL
ins_cli_id	int(11)	NO	0	MUL
ins_lab_id	int(11)	NO	0	MUL
ins_insa_id	int(11)	NO
ins_insci_id	int(11)	NO	0
ins_name	varchar(40)	NO
ins_mnemonic	varchar(20)	NO				Short insurance name for display purposes
ins_ic_id	int(11)	NO	0	MUL		Insurance Class ID
ins_address1	varchar(40)	NO
ins_address2	varchar(40)	NO
ins_city	varchar(30)	NO
ins_state	varchar(2)	NO
ins_zip	varchar(5)	NO
ins_zip_plus4	varchar(4)	NO
ins_phone	varchar(20)	NO
ins_payer_id	varchar(24)	NO
ins_payer_id_ub04	varchar(24)	NO
ins_payer_id_eligibility	varchar(24)	NO
ins_edi_payer	char(1)	NO	0	MUL
ins_ub04_surgery_center	tinyint(1)	NO	0			Indicates encounters with this insurance should default to ub04
ins_ub04_bill_type	varchar(4)	YES				Indicates encounters with this insurance should default to this ub04 bill type
ins_global	char(1)	NO	0
ins_note	text	YES
ins_precert_files	text	YES
ins_cpt_analysis	char(1)	NO	0
ins_states	text	YES
ins_status	int(1)	NO	0			0: Complete, 1: Incomplete
ins_nationwide	tinyint(1)	NO	0
ins_type	varchar(6)	NO				Type
ins_keywords	text	YES
ins_exc_adj_sec_claims	char(1)	NO	0
ins_use_primary_group	tinyint(1)	NO	0
ins_disabled	char(1)	NO	0	MUL
ins_cs_id	int(11)	NO	3	MUL		Default diagnostic coding system for the insurance. Defaults to ICD10
ins_tpl_code	varchar(3)	YES				Third Party Liability Code
ins_id_ext	int(11)	NO	0	MUL		External ID for imports. Consider using the external_identifiers table instead
ins_external_id	varchar(120)	NO
ins_id_interface_ext	varchar(128)	NO		MUL
ins_accept_dependent_segments	tinyint(1)	YES	0			indicates that insurance accepts dependent segments in 270 file
ins_accept_assignment	tinyint(1)	YES	1			Indicates when using this insurance encounters should default to accept assignment
ins_assignment_benefits	tinyint(1)	YES	1			Indicates when using this insurance encounters should default to assignments of benefits
ins_action_date_interval	int(11)	YES
ins_submitter_id	varchar(50)	YES				Submitter ID
ins_modified	timestamp	YES	CURRENT_TIMESTAMP		on update CURRENT_TIMESTAMP
ins_created	timestamp	YES	CURRENT_TIMESTAMP
ins_mapped	int(11)	NO	0

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_type

Table	Column
_1.encounters_claims_statuses	ecs_ins_type
_1.precerts_cpt_codes_insurance_statuses_map	pcpis_ins_type
_1188.encounters_claims_statuses	ecs_ins_type
_1188.precerts_cpt_codes_insurance_statuses_map	pcpis_ins_type
_1218.encounters_claims_statuses	ecs_ins_type
_1218.precerts_cpt_codes_insurance_statuses_map	pcpis_ins_type
_1548.encounters_claims_statuses	ecs_ins_type
_1548.precerts_cpt_codes_insurance_statuses_map	pcpis_ins_type
_435.encounters_claims_statuses	ecs_ins_type
_435.precerts_cpt_codes_insurance_statuses_map	pcpis_ins_type
_436.encounters_claims_statuses	ecs_ins_type
_436.precerts_cpt_codes_insurance_statuses_map	pcpis_ins_type
_436_archive_testing.encounters_claims_statuses	ecs_ins_type
_436_archive_testing.precerts_cpt_codes_insurance_statuses_map	pcpis_ins_type
_437.encounters_claims_statuses	ecs_ins_type
_437.precerts_cpt_codes_insurance_statuses_map	pcpis_ins_type
_8.encounters_claims_statuses	ecs_ins_type
_8.precerts_cpt_codes_insurance_statuses_map	pcpis_ins_type
_81.encounters_claims_statuses	ecs_ins_type
_81.precerts_cpt_codes_insurance_statuses_map	pcpis_ins_type
_999.encounters_claims_statuses	ecs_ins_type
_999.precerts_cpt_codes_insurance_statuses_map	pcpis_ins_type

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