aurora_standard.hl7in1ad

Field	Type	Null	Key	Extra
seg_in1	varchar(3)	YES
set_id	varchar(4)	YES
ins_plan_id	varchar(60)	YES
ins_comp_id	varchar(59)	YES
ins_comp_name	varchar(130)	YES
ins_comp_addr	varchar(106)	YES
ins_co_contact_per	varchar(48)	YES
ins_co_ph_num	varchar(20)	YES
group_num	varchar(12)	YES
group_name	varchar(130)	YES
ins_grp_emp_id	varchar(12)	YES
ins_grp_emp_name	varchar(130)	YES
plan_effect_date	varchar(8)	YES
plan_expire_date	varchar(8)	YES
authorize_info	varchar(55)	YES
plan_type	varchar(3)	YES
name_insured	varchar(48)	YES
ins_rel_to_pat	varchar(20)	YES
insured_dob	varchar(26)	YES
ins_addr	varchar(106)	YES
ass_of_benefits	varchar(2)	YES
coord_of_benefits	varchar(2)	YES
coord_ben_priority	varchar(2)	YES
notice_admis_flag	varchar(2)	YES
notice_admis_date	varchar(8)	YES
rpt_elig_flag	varchar(2)	YES
rpt_elig_date	varchar(8)	YES
rel_info_cd	varchar(2)	YES
preadmit_cert	varchar(15)	YES
verif_date_time	varchar(26)	YES
verif_by	varchar(60)	YES
type_agree_cd	varchar(2)	YES
billing_stat	varchar(2)	YES
lifetime_res_days	varchar(4)	YES
delay_b4_lr_day	varchar(4)	YES
comp_plan_cd	varchar(8)	YES
policy_num	varchar(15)	YES
policy_deduct	varchar(12)	YES
policy_limit_amt	varchar(12)	YES
policy_limit_days	varchar(4)	YES
rm_rate_semipri	varchar(12)	YES
rm_rate_priv	varchar(12)	YES
ins_empl_stat	varchar(60)	YES
ins_sex	varchar(1)	YES
ins_empl_addr	varchar(106)	YES
verif_stat	varchar(2)	YES
prior_ins_plan_id	varchar(8)	YES
cover_type	varchar(3)	YES
handicap	varchar(2)	YES
ins_id_num	varchar(12)	YES
chs_rowID	bigint(20) unsigned	NO	PRI	auto_increment

References

Local Column

References

set_id

Table	Column
HSPI_CURES2015_B1.invoice_batches	rule_set_id
HSPI_Central_Hospital.invoice_batches	rule_set_id
HSPI_Dewitt.invoice_batches	rule_set_id
HSPI_Fulton.invoice_batches	rule_set_id
HSPI_Inferno.invoice_batches	rule_set_id
HSPI_MU2015_E1.invoice_batches	rule_set_id
HSPI_MU2015_G2.invoice_batches	rule_set_id
HSPI_MU2015_G9.invoice_batches	rule_set_id
HSPI_Sandbox.invoice_batches	rule_set_id
HSPI_Summit_General.invoice_batches	rule_set_id
HSPI_United_Physicians.invoice_batches	rule_set_id
MPI.invoice_batches	rule_set_id
aurora_standard.vault_icd9s	order_set_id

policy_num

Table	Column
_1.encounters	enc_ins1_policy_num
_1.encounters	enc_ins2_policy_num
_1.encounters	enc_ins3_policy_num
_1.insurances_repository	irep_ins_policy_num
_1.insurances_verification	iv_policy_num
_1.orders	ord_ins1_policy_num
_1.orders	ord_ins2_policy_num
_1.patients	pat_ins1_policy_num
_1.patients	pat_ins2_policy_num
_1.patients	pat_ins3_policy_num
_1.patients_demographics_snapshots	pds_ins1_policy_num
_1.patients_demographics_snapshots	pds_ins2_policy_num
_1.patients_demographics_snapshots	pds_ins3_policy_num
_1.precerts	pre_ins1_policy_num
_1.precerts	pre_ins2_policy_num
_1.radiology_orders	rad_ins1_policy_num
_1.radiology_orders	rad_ins2_policy_num
_1188.encounters	enc_ins1_policy_num
_1188.encounters	enc_ins2_policy_num
_1188.encounters	enc_ins3_policy_num
_1188.insurances_repository	irep_ins_policy_num
_1188.insurances_verification	iv_policy_num
_1188.orders	ord_ins1_policy_num
_1188.orders	ord_ins2_policy_num
_1188.patients	pat_ins1_policy_num
_1188.patients	pat_ins2_policy_num
_1188.patients	pat_ins3_policy_num
_1188.patients_demographics_snapshots	pds_ins1_policy_num
_1188.patients_demographics_snapshots	pds_ins2_policy_num
_1188.patients_demographics_snapshots	pds_ins3_policy_num
_1188.precerts	pre_ins1_policy_num
_1188.precerts	pre_ins2_policy_num
_1188.radiology_orders	rad_ins1_policy_num
_1188.radiology_orders	rad_ins2_policy_num
_1218.encounters	enc_ins1_policy_num
_1218.encounters	enc_ins2_policy_num
_1218.encounters	enc_ins3_policy_num
_1218.insurances_repository	irep_ins_policy_num
_1218.insurances_verification	iv_policy_num
_1218.orders	ord_ins1_policy_num
_1218.orders	ord_ins2_policy_num
_1218.patients	pat_ins1_policy_num
_1218.patients	pat_ins2_policy_num
_1218.patients	pat_ins3_policy_num
_1218.patients_demographics_snapshots	pds_ins1_policy_num
_1218.patients_demographics_snapshots	pds_ins2_policy_num
_1218.patients_demographics_snapshots	pds_ins3_policy_num
_1218.precerts	pre_ins1_policy_num
_1218.precerts	pre_ins2_policy_num
_1218.radiology_orders	rad_ins1_policy_num
_1218.radiology_orders	rad_ins2_policy_num
_1548.encounters	enc_ins1_policy_num
_1548.encounters	enc_ins2_policy_num
_1548.encounters	enc_ins3_policy_num
_1548.insurances_repository	irep_ins_policy_num
_1548.insurances_verification	iv_policy_num
_1548.orders	ord_ins1_policy_num
_1548.orders	ord_ins2_policy_num
_1548.patients	pat_ins1_policy_num
_1548.patients	pat_ins2_policy_num
_1548.patients	pat_ins3_policy_num
_1548.patients_demographics_snapshots	pds_ins1_policy_num
_1548.patients_demographics_snapshots	pds_ins2_policy_num
_1548.patients_demographics_snapshots	pds_ins3_policy_num
_1548.precerts	pre_ins1_policy_num
_1548.precerts	pre_ins2_policy_num
_1548.radiology_orders	rad_ins1_policy_num
_1548.radiology_orders	rad_ins2_policy_num
_435.encounters	enc_ins1_policy_num
_435.encounters	enc_ins2_policy_num
_435.encounters	enc_ins3_policy_num
_435.insurances_repository	irep_ins_policy_num
_435.insurances_verification	iv_policy_num
_435.orders	ord_ins1_policy_num
_435.orders	ord_ins2_policy_num
_435.patients	pat_ins1_policy_num
_435.patients	pat_ins2_policy_num
_435.patients	pat_ins3_policy_num
_435.patients_demographics_snapshots	pds_ins1_policy_num
_435.patients_demographics_snapshots	pds_ins2_policy_num
_435.patients_demographics_snapshots	pds_ins3_policy_num
_435.precerts	pre_ins1_policy_num
_435.precerts	pre_ins2_policy_num
_435.radiology_orders	rad_ins1_policy_num
_435.radiology_orders	rad_ins2_policy_num
_436.encounters	enc_ins1_policy_num
_436.encounters	enc_ins2_policy_num
_436.encounters	enc_ins3_policy_num
_436.insurances_repository	irep_ins_policy_num
_436.insurances_verification	iv_policy_num
_436.orders	ord_ins1_policy_num
_436.orders	ord_ins2_policy_num
_436.patients	pat_ins1_policy_num
_436.patients	pat_ins2_policy_num
_436.patients	pat_ins3_policy_num
_436.patients_demographics_snapshots	pds_ins1_policy_num
_436.patients_demographics_snapshots	pds_ins2_policy_num
_436.patients_demographics_snapshots	pds_ins3_policy_num
_436.precerts	pre_ins1_policy_num
_436.precerts	pre_ins2_policy_num
_436.radiology_orders	rad_ins1_policy_num
_436.radiology_orders	rad_ins2_policy_num
_436_archive_testing.encounters	enc_ins1_policy_num
_436_archive_testing.encounters	enc_ins2_policy_num
_436_archive_testing.encounters	enc_ins3_policy_num
_436_archive_testing.insurances_repository	irep_ins_policy_num
_436_archive_testing.insurances_verification	iv_policy_num
_436_archive_testing.orders	ord_ins1_policy_num
_436_archive_testing.orders	ord_ins2_policy_num
_436_archive_testing.patients	pat_ins1_policy_num
_436_archive_testing.patients	pat_ins2_policy_num
_436_archive_testing.patients	pat_ins3_policy_num
_436_archive_testing.patients_demographics_snapshots	pds_ins1_policy_num
_436_archive_testing.patients_demographics_snapshots	pds_ins2_policy_num
_436_archive_testing.patients_demographics_snapshots	pds_ins3_policy_num
_436_archive_testing.precerts	pre_ins1_policy_num
_436_archive_testing.precerts	pre_ins2_policy_num
_436_archive_testing.radiology_orders	rad_ins1_policy_num
_436_archive_testing.radiology_orders	rad_ins2_policy_num
_437.encounters	enc_ins1_policy_num
_437.encounters	enc_ins2_policy_num
_437.encounters	enc_ins3_policy_num
_437.insurances_repository	irep_ins_policy_num
_437.insurances_verification	iv_policy_num
_437.orders	ord_ins1_policy_num
_437.orders	ord_ins2_policy_num
_437.patients	pat_ins1_policy_num
_437.patients	pat_ins2_policy_num
_437.patients	pat_ins3_policy_num
_437.patients_demographics_snapshots	pds_ins1_policy_num
_437.patients_demographics_snapshots	pds_ins2_policy_num
_437.patients_demographics_snapshots	pds_ins3_policy_num
_437.precerts	pre_ins1_policy_num
_437.precerts	pre_ins2_policy_num
_437.radiology_orders	rad_ins1_policy_num
_437.radiology_orders	rad_ins2_policy_num
_8.encounters	enc_ins1_policy_num
_8.encounters	enc_ins2_policy_num
_8.encounters	enc_ins3_policy_num
_8.insurances_repository	irep_ins_policy_num
_8.insurances_verification	iv_policy_num
_8.orders	ord_ins1_policy_num
_8.orders	ord_ins2_policy_num
_8.patients	pat_ins1_policy_num
_8.patients	pat_ins2_policy_num
_8.patients	pat_ins3_policy_num
_8.patients_demographics_snapshots	pds_ins1_policy_num
_8.patients_demographics_snapshots	pds_ins2_policy_num
_8.patients_demographics_snapshots	pds_ins3_policy_num
_8.precerts	pre_ins1_policy_num
_8.precerts	pre_ins2_policy_num
_8.radiology_orders	rad_ins1_policy_num
_8.radiology_orders	rad_ins2_policy_num
_81.encounters	enc_ins1_policy_num
_81.encounters	enc_ins2_policy_num
_81.encounters	enc_ins3_policy_num
_81.insurances_repository	irep_ins_policy_num
_81.insurances_verification	iv_policy_num
_81.orders	ord_ins1_policy_num
_81.orders	ord_ins2_policy_num
_81.patients	pat_ins1_policy_num
_81.patients	pat_ins2_policy_num
_81.patients	pat_ins3_policy_num
_81.patients_demographics_snapshots	pds_ins1_policy_num
_81.patients_demographics_snapshots	pds_ins2_policy_num
_81.patients_demographics_snapshots	pds_ins3_policy_num
_81.precerts	pre_ins1_policy_num
_81.precerts	pre_ins2_policy_num
_81.radiology_orders	rad_ins1_policy_num
_81.radiology_orders	rad_ins2_policy_num
_999.encounters	enc_ins1_policy_num
_999.encounters	enc_ins2_policy_num
_999.encounters	enc_ins3_policy_num
_999.insurances_repository	irep_ins_policy_num
_999.insurances_verification	iv_policy_num
_999.orders	ord_ins1_policy_num
_999.orders	ord_ins2_policy_num
_999.patients	pat_ins1_policy_num
_999.patients	pat_ins2_policy_num
_999.patients	pat_ins3_policy_num
_999.patients_demographics_snapshots	pds_ins1_policy_num
_999.patients_demographics_snapshots	pds_ins2_policy_num
_999.patients_demographics_snapshots	pds_ins3_policy_num
_999.precerts	pre_ins1_policy_num
_999.precerts	pre_ins2_policy_num
_999.radiology_orders	rad_ins1_policy_num
_999.radiology_orders	rad_ins2_policy_num

group_num

Table	Column
_1.encounters	enc_ins1_group_num
_1.encounters	enc_ins2_group_num
_1.encounters	enc_ins3_group_num
_1.insurances_repository	irep_ins_group_num
_1.insurances_verification	iv_group_num
_1.orders	ord_ins1_group_num
_1.orders	ord_ins2_group_num
_1.patients	pat_ins1_group_num
_1.patients	pat_ins2_group_num
_1.patients	pat_ins3_group_num
_1.patients_demographics_snapshots	pds_ins1_group_num
_1.patients_demographics_snapshots	pds_ins2_group_num
_1.patients_demographics_snapshots	pds_ins3_group_num
_1.physicians_pins	pin_group_num
_1.precerts	pre_ins1_group_num
_1.precerts	pre_ins2_group_num
_1.radiology_orders	rad_ins1_group_num
_1.radiology_orders	rad_ins2_group_num
_1188.encounters	enc_ins1_group_num
_1188.encounters	enc_ins2_group_num
_1188.encounters	enc_ins3_group_num
_1188.insurances_repository	irep_ins_group_num
_1188.insurances_verification	iv_group_num
_1188.orders	ord_ins1_group_num
_1188.orders	ord_ins2_group_num
_1188.patients	pat_ins1_group_num
_1188.patients	pat_ins2_group_num
_1188.patients	pat_ins3_group_num
_1188.patients_demographics_snapshots	pds_ins1_group_num
_1188.patients_demographics_snapshots	pds_ins2_group_num
_1188.patients_demographics_snapshots	pds_ins3_group_num
_1188.physicians_pins	pin_group_num
_1188.precerts	pre_ins1_group_num
_1188.precerts	pre_ins2_group_num
_1188.radiology_orders	rad_ins1_group_num
_1188.radiology_orders	rad_ins2_group_num
_1218.encounters	enc_ins1_group_num
_1218.encounters	enc_ins2_group_num
_1218.encounters	enc_ins3_group_num
_1218.insurances_repository	irep_ins_group_num
_1218.insurances_verification	iv_group_num
_1218.orders	ord_ins1_group_num
_1218.orders	ord_ins2_group_num
_1218.patients	pat_ins1_group_num
_1218.patients	pat_ins2_group_num
_1218.patients	pat_ins3_group_num
_1218.patients_demographics_snapshots	pds_ins1_group_num
_1218.patients_demographics_snapshots	pds_ins2_group_num
_1218.patients_demographics_snapshots	pds_ins3_group_num
_1218.physicians_pins	pin_group_num
_1218.precerts	pre_ins1_group_num
_1218.precerts	pre_ins2_group_num
_1218.radiology_orders	rad_ins1_group_num
_1218.radiology_orders	rad_ins2_group_num
_1548.encounters	enc_ins1_group_num
_1548.encounters	enc_ins2_group_num
_1548.encounters	enc_ins3_group_num
_1548.insurances_repository	irep_ins_group_num
_1548.insurances_verification	iv_group_num
_1548.orders	ord_ins1_group_num
_1548.orders	ord_ins2_group_num
_1548.patients	pat_ins1_group_num
_1548.patients	pat_ins2_group_num
_1548.patients	pat_ins3_group_num
_1548.patients_demographics_snapshots	pds_ins1_group_num
_1548.patients_demographics_snapshots	pds_ins2_group_num
_1548.patients_demographics_snapshots	pds_ins3_group_num
_1548.physicians_pins	pin_group_num
_1548.precerts	pre_ins1_group_num
_1548.precerts	pre_ins2_group_num
_1548.radiology_orders	rad_ins1_group_num
_1548.radiology_orders	rad_ins2_group_num
_435.encounters	enc_ins1_group_num
_435.encounters	enc_ins2_group_num
_435.encounters	enc_ins3_group_num
_435.insurances_repository	irep_ins_group_num
_435.insurances_verification	iv_group_num
_435.orders	ord_ins1_group_num
_435.orders	ord_ins2_group_num
_435.patients	pat_ins1_group_num
_435.patients	pat_ins2_group_num
_435.patients	pat_ins3_group_num
_435.patients_demographics_snapshots	pds_ins1_group_num
_435.patients_demographics_snapshots	pds_ins2_group_num
_435.patients_demographics_snapshots	pds_ins3_group_num
_435.physicians_pins	pin_group_num
_435.precerts	pre_ins1_group_num
_435.precerts	pre_ins2_group_num
_435.radiology_orders	rad_ins1_group_num
_435.radiology_orders	rad_ins2_group_num
_436.encounters	enc_ins1_group_num
_436.encounters	enc_ins2_group_num
_436.encounters	enc_ins3_group_num
_436.insurances_repository	irep_ins_group_num
_436.insurances_verification	iv_group_num
_436.orders	ord_ins1_group_num
_436.orders	ord_ins2_group_num
_436.patients	pat_ins1_group_num
_436.patients	pat_ins2_group_num
_436.patients	pat_ins3_group_num
_436.patients_demographics_snapshots	pds_ins1_group_num
_436.patients_demographics_snapshots	pds_ins2_group_num
_436.patients_demographics_snapshots	pds_ins3_group_num
_436.physicians_pins	pin_group_num
_436.precerts	pre_ins1_group_num
_436.precerts	pre_ins2_group_num
_436.radiology_orders	rad_ins1_group_num
_436.radiology_orders	rad_ins2_group_num
_436_archive_testing.encounters	enc_ins1_group_num
_436_archive_testing.encounters	enc_ins2_group_num
_436_archive_testing.encounters	enc_ins3_group_num
_436_archive_testing.insurances_repository	irep_ins_group_num
_436_archive_testing.insurances_verification	iv_group_num
_436_archive_testing.orders	ord_ins1_group_num
_436_archive_testing.orders	ord_ins2_group_num
_436_archive_testing.patients	pat_ins1_group_num
_436_archive_testing.patients	pat_ins2_group_num
_436_archive_testing.patients	pat_ins3_group_num
_436_archive_testing.patients_demographics_snapshots	pds_ins1_group_num
_436_archive_testing.patients_demographics_snapshots	pds_ins2_group_num
_436_archive_testing.patients_demographics_snapshots	pds_ins3_group_num
_436_archive_testing.physicians_pins	pin_group_num
_436_archive_testing.precerts	pre_ins1_group_num
_436_archive_testing.precerts	pre_ins2_group_num
_436_archive_testing.radiology_orders	rad_ins1_group_num
_436_archive_testing.radiology_orders	rad_ins2_group_num
_437.encounters	enc_ins1_group_num
_437.encounters	enc_ins2_group_num
_437.encounters	enc_ins3_group_num
_437.insurances_repository	irep_ins_group_num
_437.insurances_verification	iv_group_num
_437.orders	ord_ins1_group_num
_437.orders	ord_ins2_group_num
_437.patients	pat_ins1_group_num
_437.patients	pat_ins2_group_num
_437.patients	pat_ins3_group_num
_437.patients_demographics_snapshots	pds_ins1_group_num
_437.patients_demographics_snapshots	pds_ins2_group_num
_437.patients_demographics_snapshots	pds_ins3_group_num
_437.physicians_pins	pin_group_num
_437.precerts	pre_ins1_group_num
_437.precerts	pre_ins2_group_num
_437.radiology_orders	rad_ins1_group_num
_437.radiology_orders	rad_ins2_group_num
_8.encounters	enc_ins1_group_num
_8.encounters	enc_ins2_group_num
_8.encounters	enc_ins3_group_num
_8.insurances_repository	irep_ins_group_num
_8.insurances_verification	iv_group_num
_8.orders	ord_ins1_group_num
_8.orders	ord_ins2_group_num
_8.patients	pat_ins1_group_num
_8.patients	pat_ins2_group_num
_8.patients	pat_ins3_group_num
_8.patients_demographics_snapshots	pds_ins1_group_num
_8.patients_demographics_snapshots	pds_ins2_group_num
_8.patients_demographics_snapshots	pds_ins3_group_num
_8.physicians_pins	pin_group_num
_8.precerts	pre_ins1_group_num
_8.precerts	pre_ins2_group_num
_8.radiology_orders	rad_ins1_group_num
_8.radiology_orders	rad_ins2_group_num
_81.encounters	enc_ins1_group_num
_81.encounters	enc_ins2_group_num
_81.encounters	enc_ins3_group_num
_81.insurances_repository	irep_ins_group_num
_81.insurances_verification	iv_group_num
_81.orders	ord_ins1_group_num
_81.orders	ord_ins2_group_num
_81.patients	pat_ins1_group_num
_81.patients	pat_ins2_group_num
_81.patients	pat_ins3_group_num
_81.patients_demographics_snapshots	pds_ins1_group_num
_81.patients_demographics_snapshots	pds_ins2_group_num
_81.patients_demographics_snapshots	pds_ins3_group_num
_81.physicians_pins	pin_group_num
_81.precerts	pre_ins1_group_num
_81.precerts	pre_ins2_group_num
_81.radiology_orders	rad_ins1_group_num
_81.radiology_orders	rad_ins2_group_num
_999.encounters	enc_ins1_group_num
_999.encounters	enc_ins2_group_num
_999.encounters	enc_ins3_group_num
_999.insurances_repository	irep_ins_group_num
_999.insurances_verification	iv_group_num
_999.orders	ord_ins1_group_num
_999.orders	ord_ins2_group_num
_999.patients	pat_ins1_group_num
_999.patients	pat_ins2_group_num
_999.patients	pat_ins3_group_num
_999.patients_demographics_snapshots	pds_ins1_group_num
_999.patients_demographics_snapshots	pds_ins2_group_num
_999.patients_demographics_snapshots	pds_ins3_group_num
_999.physicians_pins	pin_group_num
_999.precerts	pre_ins1_group_num
_999.precerts	pre_ins2_group_num
_999.radiology_orders	rad_ins1_group_num
_999.radiology_orders	rad_ins2_group_num

insured_dob

Table	Column
_1.encounters	enc_ins1_insured_dob
_1.encounters	enc_ins2_insured_dob
_1.encounters	enc_ins3_insured_dob
_1.insurances_repository	irep_ins_insured_dob
_1.patients	pat_ins1_insured_dob
_1.patients	pat_ins2_insured_dob
_1.patients	pat_ins3_insured_dob
_1.patients_demographics_snapshots	pds_ins1_insured_dob
_1.patients_demographics_snapshots	pds_ins2_insured_dob
_1.patients_demographics_snapshots	pds_ins3_insured_dob
_1.precerts	pre_ins1_insured_dob
_1.precerts	pre_ins2_insured_dob
_1188.encounters	enc_ins1_insured_dob
_1188.encounters	enc_ins2_insured_dob
_1188.encounters	enc_ins3_insured_dob
_1188.insurances_repository	irep_ins_insured_dob
_1188.patients	pat_ins1_insured_dob
_1188.patients	pat_ins2_insured_dob
_1188.patients	pat_ins3_insured_dob
_1188.patients_demographics_snapshots	pds_ins1_insured_dob
_1188.patients_demographics_snapshots	pds_ins2_insured_dob
_1188.patients_demographics_snapshots	pds_ins3_insured_dob
_1188.precerts	pre_ins1_insured_dob
_1188.precerts	pre_ins2_insured_dob
_1218.encounters	enc_ins1_insured_dob
_1218.encounters	enc_ins2_insured_dob
_1218.encounters	enc_ins3_insured_dob
_1218.insurances_repository	irep_ins_insured_dob
_1218.patients	pat_ins1_insured_dob
_1218.patients	pat_ins2_insured_dob
_1218.patients	pat_ins3_insured_dob
_1218.patients_demographics_snapshots	pds_ins1_insured_dob
_1218.patients_demographics_snapshots	pds_ins2_insured_dob
_1218.patients_demographics_snapshots	pds_ins3_insured_dob
_1218.precerts	pre_ins1_insured_dob
_1218.precerts	pre_ins2_insured_dob
_1548.encounters	enc_ins1_insured_dob
_1548.encounters	enc_ins2_insured_dob
_1548.encounters	enc_ins3_insured_dob
_1548.insurances_repository	irep_ins_insured_dob
_1548.patients	pat_ins1_insured_dob
_1548.patients	pat_ins2_insured_dob
_1548.patients	pat_ins3_insured_dob
_1548.patients_demographics_snapshots	pds_ins1_insured_dob
_1548.patients_demographics_snapshots	pds_ins2_insured_dob
_1548.patients_demographics_snapshots	pds_ins3_insured_dob
_1548.precerts	pre_ins1_insured_dob
_1548.precerts	pre_ins2_insured_dob
_435.encounters	enc_ins1_insured_dob
_435.encounters	enc_ins2_insured_dob
_435.encounters	enc_ins3_insured_dob
_435.insurances_repository	irep_ins_insured_dob
_435.patients	pat_ins1_insured_dob
_435.patients	pat_ins2_insured_dob
_435.patients	pat_ins3_insured_dob
_435.patients_demographics_snapshots	pds_ins1_insured_dob
_435.patients_demographics_snapshots	pds_ins2_insured_dob
_435.patients_demographics_snapshots	pds_ins3_insured_dob
_435.precerts	pre_ins1_insured_dob
_435.precerts	pre_ins2_insured_dob
_436.encounters	enc_ins1_insured_dob
_436.encounters	enc_ins2_insured_dob
_436.encounters	enc_ins3_insured_dob
_436.insurances_repository	irep_ins_insured_dob
_436.patients	pat_ins1_insured_dob
_436.patients	pat_ins2_insured_dob
_436.patients	pat_ins3_insured_dob
_436.patients_demographics_snapshots	pds_ins1_insured_dob
_436.patients_demographics_snapshots	pds_ins2_insured_dob
_436.patients_demographics_snapshots	pds_ins3_insured_dob
_436.precerts	pre_ins1_insured_dob
_436.precerts	pre_ins2_insured_dob
_436_archive_testing.encounters	enc_ins1_insured_dob
_436_archive_testing.encounters	enc_ins2_insured_dob
_436_archive_testing.encounters	enc_ins3_insured_dob
_436_archive_testing.insurances_repository	irep_ins_insured_dob
_436_archive_testing.patients	pat_ins1_insured_dob
_436_archive_testing.patients	pat_ins2_insured_dob
_436_archive_testing.patients	pat_ins3_insured_dob
_436_archive_testing.patients_demographics_snapshots	pds_ins1_insured_dob
_436_archive_testing.patients_demographics_snapshots	pds_ins2_insured_dob
_436_archive_testing.patients_demographics_snapshots	pds_ins3_insured_dob
_436_archive_testing.precerts	pre_ins1_insured_dob
_436_archive_testing.precerts	pre_ins2_insured_dob
_437.encounters	enc_ins1_insured_dob
_437.encounters	enc_ins2_insured_dob
_437.encounters	enc_ins3_insured_dob
_437.insurances_repository	irep_ins_insured_dob
_437.patients	pat_ins1_insured_dob
_437.patients	pat_ins2_insured_dob
_437.patients	pat_ins3_insured_dob
_437.patients_demographics_snapshots	pds_ins1_insured_dob
_437.patients_demographics_snapshots	pds_ins2_insured_dob
_437.patients_demographics_snapshots	pds_ins3_insured_dob
_437.precerts	pre_ins1_insured_dob
_437.precerts	pre_ins2_insured_dob
_8.encounters	enc_ins1_insured_dob
_8.encounters	enc_ins2_insured_dob
_8.encounters	enc_ins3_insured_dob
_8.insurances_repository	irep_ins_insured_dob
_8.patients	pat_ins1_insured_dob
_8.patients	pat_ins2_insured_dob
_8.patients	pat_ins3_insured_dob
_8.patients_demographics_snapshots	pds_ins1_insured_dob
_8.patients_demographics_snapshots	pds_ins2_insured_dob
_8.patients_demographics_snapshots	pds_ins3_insured_dob
_8.precerts	pre_ins1_insured_dob
_8.precerts	pre_ins2_insured_dob
_81.encounters	enc_ins1_insured_dob
_81.encounters	enc_ins2_insured_dob
_81.encounters	enc_ins3_insured_dob
_81.insurances_repository	irep_ins_insured_dob
_81.patients	pat_ins1_insured_dob
_81.patients	pat_ins2_insured_dob
_81.patients	pat_ins3_insured_dob
_81.patients_demographics_snapshots	pds_ins1_insured_dob
_81.patients_demographics_snapshots	pds_ins2_insured_dob
_81.patients_demographics_snapshots	pds_ins3_insured_dob
_81.precerts	pre_ins1_insured_dob
_81.precerts	pre_ins2_insured_dob
_999.encounters	enc_ins1_insured_dob
_999.encounters	enc_ins2_insured_dob
_999.encounters	enc_ins3_insured_dob
_999.insurances_repository	irep_ins_insured_dob
_999.patients	pat_ins1_insured_dob
_999.patients	pat_ins2_insured_dob
_999.patients	pat_ins3_insured_dob
_999.patients_demographics_snapshots	pds_ins1_insured_dob
_999.patients_demographics_snapshots	pds_ins2_insured_dob
_999.patients_demographics_snapshots	pds_ins3_insured_dob
_999.precerts	pre_ins1_insured_dob
_999.precerts	pre_ins2_insured_dob

ins_plan_id

Table	Column
aurora_standard.chhl7in1	prior_ins_plan_id
aurora_standard.hl7in1	prior_ins_plan_id

group_name

Table	Column
aurora_standard.chpcobrd	cob_group_name
aurora_standard.stxsubgc	sub_group_name