aurora_standard.chhl7in1

Field	Type	Null
seg_in1	char(3)	NO
set_id	char(4)	YES
ins_plan_id	char(60)	YES
ins_comp_id	char(59)	YES
ins_comp_name	char(130)	YES
ins_comp_addr	char(106)	YES
ins_co_contact_per	char(48)	YES
ins_co_ph_num	char(20)	YES
group_num	char(12)	YES
group_name	char(130)	YES
ins_grp_emp_id	char(12)	YES
ins_grp_emp_name	char(130)	YES
plan_effect_date	char(8)	YES
plan_expire_date	char(8)	YES
authorize_info	char(55)	YES
plan_type	char(3)	YES
ins_name_last	char(20)	YES
ins_name_first	char(20)	YES
ins_name_mid	char(20)	YES
ins_rel_to_pat	char(20)	YES
insured_dob	char(26)	YES
ins_addr1	char(30)	YES
ins_addr2	char(30)	YES
ins_city	char(20)	YES
ins_state_init	char(2)	YES
ins_zip_1	char(5)	YES
ins_zip_2	char(5)	YES
ass_of_benefits	char(2)	YES
coord_of_benefits	char(2)	YES
coord_ben_priority	char(2)	YES
notice_admis_flag	char(2)	YES
notice_admis_date	char(8)	YES
rpt_elig_flag	char(2)	YES
rpt_elig_date	char(8)	YES
rel_info_cd	char(2)	YES
preadmit_cert	char(15)	YES
verif_date_time	char(26)	YES
verif_by	char(60)	YES
type_agree_cd	char(2)	YES
billing_stat	char(2)	YES
lifetime_res_days	char(4)	YES
delay_b4_lr_day	char(4)	YES
comp_plan_cd	char(8)	YES
policy_num	char(15)	YES
policy_deduct	char(12)	YES
policy_limit_amt	char(12)	YES
policy_limit_days	char(4)	YES
rm_rate_semipri	char(12)	YES
rm_rate_priv	char(12)	YES
ins_empl_stat	char(60)	YES
ins_sex	char(1)	YES
ins_empl_addr1	char(30)	YES
ins_empl_addr2	char(30)	YES
ins_empl_city	char(20)	YES
ins_empl_state	char(2)	YES
ins_empl_zip_1	char(5)	YES
ins_empl_zip_2	char(5)	YES
verif_stat	char(2)	YES
prior_ins_plan_id	char(8)	YES
cover_type	char(3)	YES
handicap	char(2)	YES
ins_id_num	char(12)	YES

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

group_name

Table	Column
aurora_standard.chpcobrd	cob_group_name
aurora_standard.stxsubgc	sub_group_name

ins_plan_id

Table	Column
aurora_standard.hl7in1	prior_ins_plan_id
aurora_standard.hl7in1ad	prior_ins_plan_id