aurora_standard.styoctcc

Field	Type	Null	Key	Extra
fac_no	char(3)	YES
tax_year	char(4)	YES
lock_records	char(1)	YES
employer_name	char(60)	YES
employer_ein	char(12)	YES
employer_add1	char(60)	YES
employer_city	char(40)	YES
employer_state	char(2)	YES
employer_zip	char(10)	YES
employer_country	char(30)	YES
contact_name	char(40)	YES
contact_phone	char(30)	YES
cov_code_all	char(2)	YES
cov_code_jan	char(2)	YES
cov_code_feb	char(2)	YES
cov_code_mar	char(2)	YES
cov_code_apr	char(2)	YES
cov_code_may	char(2)	YES
cov_code_jun	char(2)	YES
cov_code_jul	char(2)	YES
cov_code_aug	char(2)	YES
cov_code_sep	char(2)	YES
cov_code_oct	char(2)	YES
cov_code_nov	char(2)	YES
cov_code_dec	char(2)	YES
min_cost_all	decimal(10,2)	YES
min_cost_jan	decimal(10,2)	YES
min_cost_feb	decimal(10,2)	YES
min_cost_mar	decimal(10,2)	YES
min_cost_apr	decimal(10,2)	YES
min_cost_may	decimal(10,2)	YES
min_cost_jun	decimal(10,2)	YES
min_cost_jul	decimal(10,2)	YES
min_cost_aug	decimal(10,2)	YES
min_cost_sep	decimal(10,2)	YES
min_cost_oct	decimal(10,2)	YES
min_cost_nov	decimal(10,2)	YES
min_cost_dec	decimal(10,2)	YES
code4980h_all	char(10)	YES
code4980h_jan	char(10)	YES
code4980h_feb	char(10)	YES
code4980h_mar	char(10)	YES
code4980h_apr	char(10)	YES
code4980h_may	char(10)	YES
code4980h_jun	char(10)	YES
code4980h_jul	char(10)	YES
code4980h_aug	char(10)	YES
code4980h_sep	char(10)	YES
code4980h_oct	char(10)	YES
code4980h_nov	char(10)	YES
code4980h_dec	char(10)	YES
include_depend	char(1)	YES
contact_lname	char(30)	YES
contact_fname	char(20)	YES
contact_mname	char(1)	YES
contact_suffix	char(4)	YES
chs_rowID	bigint(20) unsigned	NO	PRI	auto_increment
gov_entity_name	char(100)	YES
gov_entity_id_number	char(30)	YES
gov_entity_street	char(200)	YES
gov_entity_city	char(200)	YES
gov_entity_state	char(30)	YES
gov_entity_zip	char(30)	YES
gov_entity_contact_person_lname	char(200)	YES
gov_entity_contact_person_fname	varchar(200)	NO
gov_entity_contact_person_mname	varchar(200)	NO
gov_entity_contact_phone	char(30)	YES
form_1095c_number	decimal(5,0)	YES
is_auth_tran_ale	char(1)	YES
ale_form_1095c_number	decimal(5,0)	YES
is_member_of_aggregated_group	char(1)	YES
qualifying_offer_method	char(1)	YES
qualifying_offer_method_transition_relief	char(1)	YES
section_4980h_transition_relief	char(1)	YES
offer_method_98percent	char(1)	YES

References

Local Column

References

employer_city

Table	Column
_1.encounters	enc_employer_city
_1.encounters	enc_ins1_employer_city
_1.encounters	enc_ins2_employer_city
_1.encounters	enc_ins3_employer_city
_1.insurances_repository	irep_ins_employer_city
_1.orders	ord_ins1_employer_city
_1.orders	ord_ins2_employer_city
_1.patients	pat_employer_city
_1.patients	pat_ins1_employer_city
_1.patients	pat_ins2_employer_city
_1.patients	pat_ins3_employer_city
_1.patients_demographics_snapshots	pds_employer_city
_1.patients_demographics_snapshots	pds_ins1_employer_city
_1.patients_demographics_snapshots	pds_ins2_employer_city
_1.patients_demographics_snapshots	pds_ins3_employer_city
_1.precerts	pre_employer_city
_1.precerts	pre_ins1_employer_city
_1.precerts	pre_ins2_employer_city
_1.radiology_orders	rad_ins1_employer_city
_1.radiology_orders	rad_ins2_employer_city
_1188.encounters	enc_employer_city
_1188.encounters	enc_ins1_employer_city
_1188.encounters	enc_ins2_employer_city
_1188.encounters	enc_ins3_employer_city
_1188.insurances_repository	irep_ins_employer_city
_1188.orders	ord_ins1_employer_city
_1188.orders	ord_ins2_employer_city
_1188.patients	pat_employer_city
_1188.patients	pat_ins1_employer_city
_1188.patients	pat_ins2_employer_city
_1188.patients	pat_ins3_employer_city
_1188.patients_demographics_snapshots	pds_employer_city
_1188.patients_demographics_snapshots	pds_ins1_employer_city
_1188.patients_demographics_snapshots	pds_ins2_employer_city
_1188.patients_demographics_snapshots	pds_ins3_employer_city
_1188.precerts	pre_employer_city
_1188.precerts	pre_ins1_employer_city
_1188.precerts	pre_ins2_employer_city
_1188.radiology_orders	rad_ins1_employer_city
_1188.radiology_orders	rad_ins2_employer_city
_1218.encounters	enc_employer_city
_1218.encounters	enc_ins1_employer_city
_1218.encounters	enc_ins2_employer_city
_1218.encounters	enc_ins3_employer_city
_1218.insurances_repository	irep_ins_employer_city
_1218.orders	ord_ins1_employer_city
_1218.orders	ord_ins2_employer_city
_1218.patients	pat_employer_city
_1218.patients	pat_ins1_employer_city
_1218.patients	pat_ins2_employer_city
_1218.patients	pat_ins3_employer_city
_1218.patients_demographics_snapshots	pds_employer_city
_1218.patients_demographics_snapshots	pds_ins1_employer_city
_1218.patients_demographics_snapshots	pds_ins2_employer_city
_1218.patients_demographics_snapshots	pds_ins3_employer_city
_1218.precerts	pre_employer_city
_1218.precerts	pre_ins1_employer_city
_1218.precerts	pre_ins2_employer_city
_1218.radiology_orders	rad_ins1_employer_city
_1218.radiology_orders	rad_ins2_employer_city
_1548.encounters	enc_employer_city
_1548.encounters	enc_ins1_employer_city
_1548.encounters	enc_ins2_employer_city
_1548.encounters	enc_ins3_employer_city
_1548.insurances_repository	irep_ins_employer_city
_1548.orders	ord_ins1_employer_city
_1548.orders	ord_ins2_employer_city
_1548.patients	pat_employer_city
_1548.patients	pat_ins1_employer_city
_1548.patients	pat_ins2_employer_city
_1548.patients	pat_ins3_employer_city
_1548.patients_demographics_snapshots	pds_employer_city
_1548.patients_demographics_snapshots	pds_ins1_employer_city
_1548.patients_demographics_snapshots	pds_ins2_employer_city
_1548.patients_demographics_snapshots	pds_ins3_employer_city
_1548.precerts	pre_employer_city
_1548.precerts	pre_ins1_employer_city
_1548.precerts	pre_ins2_employer_city
_1548.radiology_orders	rad_ins1_employer_city
_1548.radiology_orders	rad_ins2_employer_city
_435.encounters	enc_employer_city
_435.encounters	enc_ins1_employer_city
_435.encounters	enc_ins2_employer_city
_435.encounters	enc_ins3_employer_city
_435.insurances_repository	irep_ins_employer_city
_435.orders	ord_ins1_employer_city
_435.orders	ord_ins2_employer_city
_435.patients	pat_employer_city
_435.patients	pat_ins1_employer_city
_435.patients	pat_ins2_employer_city
_435.patients	pat_ins3_employer_city
_435.patients_demographics_snapshots	pds_employer_city
_435.patients_demographics_snapshots	pds_ins1_employer_city
_435.patients_demographics_snapshots	pds_ins2_employer_city
_435.patients_demographics_snapshots	pds_ins3_employer_city
_435.precerts	pre_employer_city
_435.precerts	pre_ins1_employer_city
_435.precerts	pre_ins2_employer_city
_435.radiology_orders	rad_ins1_employer_city
_435.radiology_orders	rad_ins2_employer_city
_436.encounters	enc_employer_city
_436.encounters	enc_ins1_employer_city
_436.encounters	enc_ins2_employer_city
_436.encounters	enc_ins3_employer_city
_436.insurances_repository	irep_ins_employer_city
_436.orders	ord_ins1_employer_city
_436.orders	ord_ins2_employer_city
_436.patients	pat_employer_city
_436.patients	pat_ins1_employer_city
_436.patients	pat_ins2_employer_city
_436.patients	pat_ins3_employer_city
_436.patients_demographics_snapshots	pds_employer_city
_436.patients_demographics_snapshots	pds_ins1_employer_city
_436.patients_demographics_snapshots	pds_ins2_employer_city
_436.patients_demographics_snapshots	pds_ins3_employer_city
_436.precerts	pre_employer_city
_436.precerts	pre_ins1_employer_city
_436.precerts	pre_ins2_employer_city
_436.radiology_orders	rad_ins1_employer_city
_436.radiology_orders	rad_ins2_employer_city
_436_archive_testing.encounters	enc_employer_city
_436_archive_testing.encounters	enc_ins1_employer_city
_436_archive_testing.encounters	enc_ins2_employer_city
_436_archive_testing.encounters	enc_ins3_employer_city
_436_archive_testing.insurances_repository	irep_ins_employer_city
_436_archive_testing.orders	ord_ins1_employer_city
_436_archive_testing.orders	ord_ins2_employer_city
_436_archive_testing.patients	pat_employer_city
_436_archive_testing.patients	pat_ins1_employer_city
_436_archive_testing.patients	pat_ins2_employer_city
_436_archive_testing.patients	pat_ins3_employer_city
_436_archive_testing.patients_demographics_snapshots	pds_employer_city
_436_archive_testing.patients_demographics_snapshots	pds_ins1_employer_city
_436_archive_testing.patients_demographics_snapshots	pds_ins2_employer_city
_436_archive_testing.patients_demographics_snapshots	pds_ins3_employer_city
_436_archive_testing.precerts	pre_employer_city
_436_archive_testing.precerts	pre_ins1_employer_city
_436_archive_testing.precerts	pre_ins2_employer_city
_436_archive_testing.radiology_orders	rad_ins1_employer_city
_436_archive_testing.radiology_orders	rad_ins2_employer_city
_437.encounters	enc_employer_city
_437.encounters	enc_ins1_employer_city
_437.encounters	enc_ins2_employer_city
_437.encounters	enc_ins3_employer_city
_437.insurances_repository	irep_ins_employer_city
_437.orders	ord_ins1_employer_city
_437.orders	ord_ins2_employer_city
_437.patients	pat_employer_city
_437.patients	pat_ins1_employer_city
_437.patients	pat_ins2_employer_city
_437.patients	pat_ins3_employer_city
_437.patients_demographics_snapshots	pds_employer_city
_437.patients_demographics_snapshots	pds_ins1_employer_city
_437.patients_demographics_snapshots	pds_ins2_employer_city
_437.patients_demographics_snapshots	pds_ins3_employer_city
_437.precerts	pre_employer_city
_437.precerts	pre_ins1_employer_city
_437.precerts	pre_ins2_employer_city
_437.radiology_orders	rad_ins1_employer_city
_437.radiology_orders	rad_ins2_employer_city
_8.encounters	enc_employer_city
_8.encounters	enc_ins1_employer_city
_8.encounters	enc_ins2_employer_city
_8.encounters	enc_ins3_employer_city
_8.insurances_repository	irep_ins_employer_city
_8.orders	ord_ins1_employer_city
_8.orders	ord_ins2_employer_city
_8.patients	pat_employer_city
_8.patients	pat_ins1_employer_city
_8.patients	pat_ins2_employer_city
_8.patients	pat_ins3_employer_city
_8.patients_demographics_snapshots	pds_employer_city
_8.patients_demographics_snapshots	pds_ins1_employer_city
_8.patients_demographics_snapshots	pds_ins2_employer_city
_8.patients_demographics_snapshots	pds_ins3_employer_city
_8.precerts	pre_employer_city
_8.precerts	pre_ins1_employer_city
_8.precerts	pre_ins2_employer_city
_8.radiology_orders	rad_ins1_employer_city
_8.radiology_orders	rad_ins2_employer_city
_81.encounters	enc_employer_city
_81.encounters	enc_ins1_employer_city
_81.encounters	enc_ins2_employer_city
_81.encounters	enc_ins3_employer_city
_81.insurances_repository	irep_ins_employer_city
_81.orders	ord_ins1_employer_city
_81.orders	ord_ins2_employer_city
_81.patients	pat_employer_city
_81.patients	pat_ins1_employer_city
_81.patients	pat_ins2_employer_city
_81.patients	pat_ins3_employer_city
_81.patients_demographics_snapshots	pds_employer_city
_81.patients_demographics_snapshots	pds_ins1_employer_city
_81.patients_demographics_snapshots	pds_ins2_employer_city
_81.patients_demographics_snapshots	pds_ins3_employer_city
_81.precerts	pre_employer_city
_81.precerts	pre_ins1_employer_city
_81.precerts	pre_ins2_employer_city
_81.radiology_orders	rad_ins1_employer_city
_81.radiology_orders	rad_ins2_employer_city
_999.encounters	enc_employer_city
_999.encounters	enc_ins1_employer_city
_999.encounters	enc_ins2_employer_city
_999.encounters	enc_ins3_employer_city
_999.insurances_repository	irep_ins_employer_city
_999.orders	ord_ins1_employer_city
_999.orders	ord_ins2_employer_city
_999.patients	pat_employer_city
_999.patients	pat_ins1_employer_city
_999.patients	pat_ins2_employer_city
_999.patients	pat_ins3_employer_city
_999.patients_demographics_snapshots	pds_employer_city
_999.patients_demographics_snapshots	pds_ins1_employer_city
_999.patients_demographics_snapshots	pds_ins2_employer_city
_999.patients_demographics_snapshots	pds_ins3_employer_city
_999.precerts	pre_employer_city
_999.precerts	pre_ins1_employer_city
_999.precerts	pre_ins2_employer_city
_999.radiology_orders	rad_ins1_employer_city
_999.radiology_orders	rad_ins2_employer_city

employer_state

Table	Column
_1.encounters	enc_employer_state
_1.encounters	enc_ins1_employer_state
_1.encounters	enc_ins2_employer_state
_1.encounters	enc_ins3_employer_state
_1.insurances_repository	irep_ins_employer_state
_1.orders	ord_ins1_employer_state
_1.orders	ord_ins2_employer_state
_1.patients	pat_employer_state
_1.patients	pat_ins1_employer_state
_1.patients	pat_ins2_employer_state
_1.patients	pat_ins3_employer_state
_1.patients_demographics_snapshots	pds_employer_state
_1.patients_demographics_snapshots	pds_ins1_employer_state
_1.patients_demographics_snapshots	pds_ins2_employer_state
_1.patients_demographics_snapshots	pds_ins3_employer_state
_1.precerts	pre_employer_state
_1.precerts	pre_ins1_employer_state
_1.precerts	pre_ins2_employer_state
_1.radiology_orders	rad_ins1_employer_state
_1.radiology_orders	rad_ins2_employer_state
_1188.encounters	enc_employer_state
_1188.encounters	enc_ins1_employer_state
_1188.encounters	enc_ins2_employer_state
_1188.encounters	enc_ins3_employer_state
_1188.insurances_repository	irep_ins_employer_state
_1188.orders	ord_ins1_employer_state
_1188.orders	ord_ins2_employer_state
_1188.patients	pat_employer_state
_1188.patients	pat_ins1_employer_state
_1188.patients	pat_ins2_employer_state
_1188.patients	pat_ins3_employer_state
_1188.patients_demographics_snapshots	pds_employer_state
_1188.patients_demographics_snapshots	pds_ins1_employer_state
_1188.patients_demographics_snapshots	pds_ins2_employer_state
_1188.patients_demographics_snapshots	pds_ins3_employer_state
_1188.precerts	pre_employer_state
_1188.precerts	pre_ins1_employer_state
_1188.precerts	pre_ins2_employer_state
_1188.radiology_orders	rad_ins1_employer_state
_1188.radiology_orders	rad_ins2_employer_state
_1218.encounters	enc_employer_state
_1218.encounters	enc_ins1_employer_state
_1218.encounters	enc_ins2_employer_state
_1218.encounters	enc_ins3_employer_state
_1218.insurances_repository	irep_ins_employer_state
_1218.orders	ord_ins1_employer_state
_1218.orders	ord_ins2_employer_state
_1218.patients	pat_employer_state
_1218.patients	pat_ins1_employer_state
_1218.patients	pat_ins2_employer_state
_1218.patients	pat_ins3_employer_state
_1218.patients_demographics_snapshots	pds_employer_state
_1218.patients_demographics_snapshots	pds_ins1_employer_state
_1218.patients_demographics_snapshots	pds_ins2_employer_state
_1218.patients_demographics_snapshots	pds_ins3_employer_state
_1218.precerts	pre_employer_state
_1218.precerts	pre_ins1_employer_state
_1218.precerts	pre_ins2_employer_state
_1218.radiology_orders	rad_ins1_employer_state
_1218.radiology_orders	rad_ins2_employer_state
_1548.encounters	enc_employer_state
_1548.encounters	enc_ins1_employer_state
_1548.encounters	enc_ins2_employer_state
_1548.encounters	enc_ins3_employer_state
_1548.insurances_repository	irep_ins_employer_state
_1548.orders	ord_ins1_employer_state
_1548.orders	ord_ins2_employer_state
_1548.patients	pat_employer_state
_1548.patients	pat_ins1_employer_state
_1548.patients	pat_ins2_employer_state
_1548.patients	pat_ins3_employer_state
_1548.patients_demographics_snapshots	pds_employer_state
_1548.patients_demographics_snapshots	pds_ins1_employer_state
_1548.patients_demographics_snapshots	pds_ins2_employer_state
_1548.patients_demographics_snapshots	pds_ins3_employer_state
_1548.precerts	pre_employer_state
_1548.precerts	pre_ins1_employer_state
_1548.precerts	pre_ins2_employer_state
_1548.radiology_orders	rad_ins1_employer_state
_1548.radiology_orders	rad_ins2_employer_state
_435.encounters	enc_employer_state
_435.encounters	enc_ins1_employer_state
_435.encounters	enc_ins2_employer_state
_435.encounters	enc_ins3_employer_state
_435.insurances_repository	irep_ins_employer_state
_435.orders	ord_ins1_employer_state
_435.orders	ord_ins2_employer_state
_435.patients	pat_employer_state
_435.patients	pat_ins1_employer_state
_435.patients	pat_ins2_employer_state
_435.patients	pat_ins3_employer_state
_435.patients_demographics_snapshots	pds_employer_state
_435.patients_demographics_snapshots	pds_ins1_employer_state
_435.patients_demographics_snapshots	pds_ins2_employer_state
_435.patients_demographics_snapshots	pds_ins3_employer_state
_435.precerts	pre_employer_state
_435.precerts	pre_ins1_employer_state
_435.precerts	pre_ins2_employer_state
_435.radiology_orders	rad_ins1_employer_state
_435.radiology_orders	rad_ins2_employer_state
_436.encounters	enc_employer_state
_436.encounters	enc_ins1_employer_state
_436.encounters	enc_ins2_employer_state
_436.encounters	enc_ins3_employer_state
_436.insurances_repository	irep_ins_employer_state
_436.orders	ord_ins1_employer_state
_436.orders	ord_ins2_employer_state
_436.patients	pat_employer_state
_436.patients	pat_ins1_employer_state
_436.patients	pat_ins2_employer_state
_436.patients	pat_ins3_employer_state
_436.patients_demographics_snapshots	pds_employer_state
_436.patients_demographics_snapshots	pds_ins1_employer_state
_436.patients_demographics_snapshots	pds_ins2_employer_state
_436.patients_demographics_snapshots	pds_ins3_employer_state
_436.precerts	pre_employer_state
_436.precerts	pre_ins1_employer_state
_436.precerts	pre_ins2_employer_state
_436.radiology_orders	rad_ins1_employer_state
_436.radiology_orders	rad_ins2_employer_state
_436_archive_testing.encounters	enc_employer_state
_436_archive_testing.encounters	enc_ins1_employer_state
_436_archive_testing.encounters	enc_ins2_employer_state
_436_archive_testing.encounters	enc_ins3_employer_state
_436_archive_testing.insurances_repository	irep_ins_employer_state
_436_archive_testing.orders	ord_ins1_employer_state
_436_archive_testing.orders	ord_ins2_employer_state
_436_archive_testing.patients	pat_employer_state
_436_archive_testing.patients	pat_ins1_employer_state
_436_archive_testing.patients	pat_ins2_employer_state
_436_archive_testing.patients	pat_ins3_employer_state
_436_archive_testing.patients_demographics_snapshots	pds_employer_state
_436_archive_testing.patients_demographics_snapshots	pds_ins1_employer_state
_436_archive_testing.patients_demographics_snapshots	pds_ins2_employer_state
_436_archive_testing.patients_demographics_snapshots	pds_ins3_employer_state
_436_archive_testing.precerts	pre_employer_state
_436_archive_testing.precerts	pre_ins1_employer_state
_436_archive_testing.precerts	pre_ins2_employer_state
_436_archive_testing.radiology_orders	rad_ins1_employer_state
_436_archive_testing.radiology_orders	rad_ins2_employer_state
_437.encounters	enc_employer_state
_437.encounters	enc_ins1_employer_state
_437.encounters	enc_ins2_employer_state
_437.encounters	enc_ins3_employer_state
_437.insurances_repository	irep_ins_employer_state
_437.orders	ord_ins1_employer_state
_437.orders	ord_ins2_employer_state
_437.patients	pat_employer_state
_437.patients	pat_ins1_employer_state
_437.patients	pat_ins2_employer_state
_437.patients	pat_ins3_employer_state
_437.patients_demographics_snapshots	pds_employer_state
_437.patients_demographics_snapshots	pds_ins1_employer_state
_437.patients_demographics_snapshots	pds_ins2_employer_state
_437.patients_demographics_snapshots	pds_ins3_employer_state
_437.precerts	pre_employer_state
_437.precerts	pre_ins1_employer_state
_437.precerts	pre_ins2_employer_state
_437.radiology_orders	rad_ins1_employer_state
_437.radiology_orders	rad_ins2_employer_state
_8.encounters	enc_employer_state
_8.encounters	enc_ins1_employer_state
_8.encounters	enc_ins2_employer_state
_8.encounters	enc_ins3_employer_state
_8.insurances_repository	irep_ins_employer_state
_8.orders	ord_ins1_employer_state
_8.orders	ord_ins2_employer_state
_8.patients	pat_employer_state
_8.patients	pat_ins1_employer_state
_8.patients	pat_ins2_employer_state
_8.patients	pat_ins3_employer_state
_8.patients_demographics_snapshots	pds_employer_state
_8.patients_demographics_snapshots	pds_ins1_employer_state
_8.patients_demographics_snapshots	pds_ins2_employer_state
_8.patients_demographics_snapshots	pds_ins3_employer_state
_8.precerts	pre_employer_state
_8.precerts	pre_ins1_employer_state
_8.precerts	pre_ins2_employer_state
_8.radiology_orders	rad_ins1_employer_state
_8.radiology_orders	rad_ins2_employer_state
_81.encounters	enc_employer_state
_81.encounters	enc_ins1_employer_state
_81.encounters	enc_ins2_employer_state
_81.encounters	enc_ins3_employer_state
_81.insurances_repository	irep_ins_employer_state
_81.orders	ord_ins1_employer_state
_81.orders	ord_ins2_employer_state
_81.patients	pat_employer_state
_81.patients	pat_ins1_employer_state
_81.patients	pat_ins2_employer_state
_81.patients	pat_ins3_employer_state
_81.patients_demographics_snapshots	pds_employer_state
_81.patients_demographics_snapshots	pds_ins1_employer_state
_81.patients_demographics_snapshots	pds_ins2_employer_state
_81.patients_demographics_snapshots	pds_ins3_employer_state
_81.precerts	pre_employer_state
_81.precerts	pre_ins1_employer_state
_81.precerts	pre_ins2_employer_state
_81.radiology_orders	rad_ins1_employer_state
_81.radiology_orders	rad_ins2_employer_state
_999.encounters	enc_employer_state
_999.encounters	enc_ins1_employer_state
_999.encounters	enc_ins2_employer_state
_999.encounters	enc_ins3_employer_state
_999.insurances_repository	irep_ins_employer_state
_999.orders	ord_ins1_employer_state
_999.orders	ord_ins2_employer_state
_999.patients	pat_employer_state
_999.patients	pat_ins1_employer_state
_999.patients	pat_ins2_employer_state
_999.patients	pat_ins3_employer_state
_999.patients_demographics_snapshots	pds_employer_state
_999.patients_demographics_snapshots	pds_ins1_employer_state
_999.patients_demographics_snapshots	pds_ins2_employer_state
_999.patients_demographics_snapshots	pds_ins3_employer_state
_999.precerts	pre_employer_state
_999.precerts	pre_ins1_employer_state
_999.precerts	pre_ins2_employer_state
_999.radiology_orders	rad_ins1_employer_state
_999.radiology_orders	rad_ins2_employer_state

employer_zip

Table	Column
_1.encounters	enc_employer_zip
_1.encounters	enc_ins1_employer_zip
_1.encounters	enc_ins2_employer_zip
_1.encounters	enc_ins3_employer_zip
_1.insurances_repository	irep_ins_employer_zip
_1.orders	ord_ins1_employer_zip
_1.orders	ord_ins2_employer_zip
_1.patients	pat_employer_zip
_1.patients	pat_ins1_employer_zip
_1.patients	pat_ins2_employer_zip
_1.patients	pat_ins3_employer_zip
_1.patients_demographics_snapshots	pds_employer_zip
_1.patients_demographics_snapshots	pds_ins1_employer_zip
_1.patients_demographics_snapshots	pds_ins2_employer_zip
_1.patients_demographics_snapshots	pds_ins3_employer_zip
_1.precerts	pre_employer_zip
_1.precerts	pre_ins1_employer_zip
_1.precerts	pre_ins2_employer_zip
_1.radiology_orders	rad_ins1_employer_zip
_1.radiology_orders	rad_ins2_employer_zip
_1188.encounters	enc_employer_zip
_1188.encounters	enc_ins1_employer_zip
_1188.encounters	enc_ins2_employer_zip
_1188.encounters	enc_ins3_employer_zip
_1188.insurances_repository	irep_ins_employer_zip
_1188.orders	ord_ins1_employer_zip
_1188.orders	ord_ins2_employer_zip
_1188.patients	pat_employer_zip
_1188.patients	pat_ins1_employer_zip
_1188.patients	pat_ins2_employer_zip
_1188.patients	pat_ins3_employer_zip
_1188.patients_demographics_snapshots	pds_employer_zip
_1188.patients_demographics_snapshots	pds_ins1_employer_zip
_1188.patients_demographics_snapshots	pds_ins2_employer_zip
_1188.patients_demographics_snapshots	pds_ins3_employer_zip
_1188.precerts	pre_employer_zip
_1188.precerts	pre_ins1_employer_zip
_1188.precerts	pre_ins2_employer_zip
_1188.radiology_orders	rad_ins1_employer_zip
_1188.radiology_orders	rad_ins2_employer_zip
_1218.encounters	enc_employer_zip
_1218.encounters	enc_ins1_employer_zip
_1218.encounters	enc_ins2_employer_zip
_1218.encounters	enc_ins3_employer_zip
_1218.insurances_repository	irep_ins_employer_zip
_1218.orders	ord_ins1_employer_zip
_1218.orders	ord_ins2_employer_zip
_1218.patients	pat_employer_zip
_1218.patients	pat_ins1_employer_zip
_1218.patients	pat_ins2_employer_zip
_1218.patients	pat_ins3_employer_zip
_1218.patients_demographics_snapshots	pds_employer_zip
_1218.patients_demographics_snapshots	pds_ins1_employer_zip
_1218.patients_demographics_snapshots	pds_ins2_employer_zip
_1218.patients_demographics_snapshots	pds_ins3_employer_zip
_1218.precerts	pre_employer_zip
_1218.precerts	pre_ins1_employer_zip
_1218.precerts	pre_ins2_employer_zip
_1218.radiology_orders	rad_ins1_employer_zip
_1218.radiology_orders	rad_ins2_employer_zip
_1548.encounters	enc_employer_zip
_1548.encounters	enc_ins1_employer_zip
_1548.encounters	enc_ins2_employer_zip
_1548.encounters	enc_ins3_employer_zip
_1548.insurances_repository	irep_ins_employer_zip
_1548.orders	ord_ins1_employer_zip
_1548.orders	ord_ins2_employer_zip
_1548.patients	pat_employer_zip
_1548.patients	pat_ins1_employer_zip
_1548.patients	pat_ins2_employer_zip
_1548.patients	pat_ins3_employer_zip
_1548.patients_demographics_snapshots	pds_employer_zip
_1548.patients_demographics_snapshots	pds_ins1_employer_zip
_1548.patients_demographics_snapshots	pds_ins2_employer_zip
_1548.patients_demographics_snapshots	pds_ins3_employer_zip
_1548.precerts	pre_employer_zip
_1548.precerts	pre_ins1_employer_zip
_1548.precerts	pre_ins2_employer_zip
_1548.radiology_orders	rad_ins1_employer_zip
_1548.radiology_orders	rad_ins2_employer_zip
_435.encounters	enc_employer_zip
_435.encounters	enc_ins1_employer_zip
_435.encounters	enc_ins2_employer_zip
_435.encounters	enc_ins3_employer_zip
_435.insurances_repository	irep_ins_employer_zip
_435.orders	ord_ins1_employer_zip
_435.orders	ord_ins2_employer_zip
_435.patients	pat_employer_zip
_435.patients	pat_ins1_employer_zip
_435.patients	pat_ins2_employer_zip
_435.patients	pat_ins3_employer_zip
_435.patients_demographics_snapshots	pds_employer_zip
_435.patients_demographics_snapshots	pds_ins1_employer_zip
_435.patients_demographics_snapshots	pds_ins2_employer_zip
_435.patients_demographics_snapshots	pds_ins3_employer_zip
_435.precerts	pre_employer_zip
_435.precerts	pre_ins1_employer_zip
_435.precerts	pre_ins2_employer_zip
_435.radiology_orders	rad_ins1_employer_zip
_435.radiology_orders	rad_ins2_employer_zip
_436.encounters	enc_employer_zip
_436.encounters	enc_ins1_employer_zip
_436.encounters	enc_ins2_employer_zip
_436.encounters	enc_ins3_employer_zip
_436.insurances_repository	irep_ins_employer_zip
_436.orders	ord_ins1_employer_zip
_436.orders	ord_ins2_employer_zip
_436.patients	pat_employer_zip
_436.patients	pat_ins1_employer_zip
_436.patients	pat_ins2_employer_zip
_436.patients	pat_ins3_employer_zip
_436.patients_demographics_snapshots	pds_employer_zip
_436.patients_demographics_snapshots	pds_ins1_employer_zip
_436.patients_demographics_snapshots	pds_ins2_employer_zip
_436.patients_demographics_snapshots	pds_ins3_employer_zip
_436.precerts	pre_employer_zip
_436.precerts	pre_ins1_employer_zip
_436.precerts	pre_ins2_employer_zip
_436.radiology_orders	rad_ins1_employer_zip
_436.radiology_orders	rad_ins2_employer_zip
_436_archive_testing.encounters	enc_employer_zip
_436_archive_testing.encounters	enc_ins1_employer_zip
_436_archive_testing.encounters	enc_ins2_employer_zip
_436_archive_testing.encounters	enc_ins3_employer_zip
_436_archive_testing.insurances_repository	irep_ins_employer_zip
_436_archive_testing.orders	ord_ins1_employer_zip
_436_archive_testing.orders	ord_ins2_employer_zip
_436_archive_testing.patients	pat_employer_zip
_436_archive_testing.patients	pat_ins1_employer_zip
_436_archive_testing.patients	pat_ins2_employer_zip
_436_archive_testing.patients	pat_ins3_employer_zip
_436_archive_testing.patients_demographics_snapshots	pds_employer_zip
_436_archive_testing.patients_demographics_snapshots	pds_ins1_employer_zip
_436_archive_testing.patients_demographics_snapshots	pds_ins2_employer_zip
_436_archive_testing.patients_demographics_snapshots	pds_ins3_employer_zip
_436_archive_testing.precerts	pre_employer_zip
_436_archive_testing.precerts	pre_ins1_employer_zip
_436_archive_testing.precerts	pre_ins2_employer_zip
_436_archive_testing.radiology_orders	rad_ins1_employer_zip
_436_archive_testing.radiology_orders	rad_ins2_employer_zip
_437.encounters	enc_employer_zip
_437.encounters	enc_ins1_employer_zip
_437.encounters	enc_ins2_employer_zip
_437.encounters	enc_ins3_employer_zip
_437.insurances_repository	irep_ins_employer_zip
_437.orders	ord_ins1_employer_zip
_437.orders	ord_ins2_employer_zip
_437.patients	pat_employer_zip
_437.patients	pat_ins1_employer_zip
_437.patients	pat_ins2_employer_zip
_437.patients	pat_ins3_employer_zip
_437.patients_demographics_snapshots	pds_employer_zip
_437.patients_demographics_snapshots	pds_ins1_employer_zip
_437.patients_demographics_snapshots	pds_ins2_employer_zip
_437.patients_demographics_snapshots	pds_ins3_employer_zip
_437.precerts	pre_employer_zip
_437.precerts	pre_ins1_employer_zip
_437.precerts	pre_ins2_employer_zip
_437.radiology_orders	rad_ins1_employer_zip
_437.radiology_orders	rad_ins2_employer_zip
_8.encounters	enc_employer_zip
_8.encounters	enc_ins1_employer_zip
_8.encounters	enc_ins2_employer_zip
_8.encounters	enc_ins3_employer_zip
_8.insurances_repository	irep_ins_employer_zip
_8.orders	ord_ins1_employer_zip
_8.orders	ord_ins2_employer_zip
_8.patients	pat_employer_zip
_8.patients	pat_ins1_employer_zip
_8.patients	pat_ins2_employer_zip
_8.patients	pat_ins3_employer_zip
_8.patients_demographics_snapshots	pds_employer_zip
_8.patients_demographics_snapshots	pds_ins1_employer_zip
_8.patients_demographics_snapshots	pds_ins2_employer_zip
_8.patients_demographics_snapshots	pds_ins3_employer_zip
_8.precerts	pre_employer_zip
_8.precerts	pre_ins1_employer_zip
_8.precerts	pre_ins2_employer_zip
_8.radiology_orders	rad_ins1_employer_zip
_8.radiology_orders	rad_ins2_employer_zip
_81.encounters	enc_employer_zip
_81.encounters	enc_ins1_employer_zip
_81.encounters	enc_ins2_employer_zip
_81.encounters	enc_ins3_employer_zip
_81.insurances_repository	irep_ins_employer_zip
_81.orders	ord_ins1_employer_zip
_81.orders	ord_ins2_employer_zip
_81.patients	pat_employer_zip
_81.patients	pat_ins1_employer_zip
_81.patients	pat_ins2_employer_zip
_81.patients	pat_ins3_employer_zip
_81.patients_demographics_snapshots	pds_employer_zip
_81.patients_demographics_snapshots	pds_ins1_employer_zip
_81.patients_demographics_snapshots	pds_ins2_employer_zip
_81.patients_demographics_snapshots	pds_ins3_employer_zip
_81.precerts	pre_employer_zip
_81.precerts	pre_ins1_employer_zip
_81.precerts	pre_ins2_employer_zip
_81.radiology_orders	rad_ins1_employer_zip
_81.radiology_orders	rad_ins2_employer_zip
_999.encounters	enc_employer_zip
_999.encounters	enc_ins1_employer_zip
_999.encounters	enc_ins2_employer_zip
_999.encounters	enc_ins3_employer_zip
_999.insurances_repository	irep_ins_employer_zip
_999.orders	ord_ins1_employer_zip
_999.orders	ord_ins2_employer_zip
_999.patients	pat_employer_zip
_999.patients	pat_ins1_employer_zip
_999.patients	pat_ins2_employer_zip
_999.patients	pat_ins3_employer_zip
_999.patients_demographics_snapshots	pds_employer_zip
_999.patients_demographics_snapshots	pds_ins1_employer_zip
_999.patients_demographics_snapshots	pds_ins2_employer_zip
_999.patients_demographics_snapshots	pds_ins3_employer_zip
_999.precerts	pre_employer_zip
_999.precerts	pre_ins1_employer_zip
_999.precerts	pre_ins2_employer_zip
_999.radiology_orders	rad_ins1_employer_zip
_999.radiology_orders	rad_ins2_employer_zip

employer_name

Table	Column
_1.encounters	enc_ins1_employer_name
_1.encounters	enc_ins2_employer_name
_1.encounters	enc_ins3_employer_name
_1.insurances_repository	irep_ins_employer_name
_1.orders	ord_ins1_employer_name
_1.orders	ord_ins2_employer_name
_1.patients	pat_ins1_employer_name
_1.patients	pat_ins2_employer_name
_1.patients	pat_ins3_employer_name
_1.patients_demographics_snapshots	pds_ins1_employer_name
_1.patients_demographics_snapshots	pds_ins2_employer_name
_1.patients_demographics_snapshots	pds_ins3_employer_name
_1.precerts	pre_ins1_employer_name
_1.precerts	pre_ins2_employer_name
_1.radiology_orders	rad_ins1_employer_name
_1.radiology_orders	rad_ins2_employer_name
_1188.encounters	enc_ins1_employer_name
_1188.encounters	enc_ins2_employer_name
_1188.encounters	enc_ins3_employer_name
_1188.insurances_repository	irep_ins_employer_name
_1188.orders	ord_ins1_employer_name
_1188.orders	ord_ins2_employer_name
_1188.patients	pat_ins1_employer_name
_1188.patients	pat_ins2_employer_name
_1188.patients	pat_ins3_employer_name
_1188.patients_demographics_snapshots	pds_ins1_employer_name
_1188.patients_demographics_snapshots	pds_ins2_employer_name
_1188.patients_demographics_snapshots	pds_ins3_employer_name
_1188.precerts	pre_ins1_employer_name
_1188.precerts	pre_ins2_employer_name
_1188.radiology_orders	rad_ins1_employer_name
_1188.radiology_orders	rad_ins2_employer_name
_1218.encounters	enc_ins1_employer_name
_1218.encounters	enc_ins2_employer_name
_1218.encounters	enc_ins3_employer_name
_1218.insurances_repository	irep_ins_employer_name
_1218.orders	ord_ins1_employer_name
_1218.orders	ord_ins2_employer_name
_1218.patients	pat_ins1_employer_name
_1218.patients	pat_ins2_employer_name
_1218.patients	pat_ins3_employer_name
_1218.patients_demographics_snapshots	pds_ins1_employer_name
_1218.patients_demographics_snapshots	pds_ins2_employer_name
_1218.patients_demographics_snapshots	pds_ins3_employer_name
_1218.precerts	pre_ins1_employer_name
_1218.precerts	pre_ins2_employer_name
_1218.radiology_orders	rad_ins1_employer_name
_1218.radiology_orders	rad_ins2_employer_name
_1548.encounters	enc_ins1_employer_name
_1548.encounters	enc_ins2_employer_name
_1548.encounters	enc_ins3_employer_name
_1548.insurances_repository	irep_ins_employer_name
_1548.orders	ord_ins1_employer_name
_1548.orders	ord_ins2_employer_name
_1548.patients	pat_ins1_employer_name
_1548.patients	pat_ins2_employer_name
_1548.patients	pat_ins3_employer_name
_1548.patients_demographics_snapshots	pds_ins1_employer_name
_1548.patients_demographics_snapshots	pds_ins2_employer_name
_1548.patients_demographics_snapshots	pds_ins3_employer_name
_1548.precerts	pre_ins1_employer_name
_1548.precerts	pre_ins2_employer_name
_1548.radiology_orders	rad_ins1_employer_name
_1548.radiology_orders	rad_ins2_employer_name
_435.encounters	enc_ins1_employer_name
_435.encounters	enc_ins2_employer_name
_435.encounters	enc_ins3_employer_name
_435.insurances_repository	irep_ins_employer_name
_435.orders	ord_ins1_employer_name
_435.orders	ord_ins2_employer_name
_435.patients	pat_ins1_employer_name
_435.patients	pat_ins2_employer_name
_435.patients	pat_ins3_employer_name
_435.patients_demographics_snapshots	pds_ins1_employer_name
_435.patients_demographics_snapshots	pds_ins2_employer_name
_435.patients_demographics_snapshots	pds_ins3_employer_name
_435.precerts	pre_ins1_employer_name
_435.precerts	pre_ins2_employer_name
_435.radiology_orders	rad_ins1_employer_name
_435.radiology_orders	rad_ins2_employer_name
_436.encounters	enc_ins1_employer_name
_436.encounters	enc_ins2_employer_name
_436.encounters	enc_ins3_employer_name
_436.insurances_repository	irep_ins_employer_name
_436.orders	ord_ins1_employer_name
_436.orders	ord_ins2_employer_name
_436.patients	pat_ins1_employer_name
_436.patients	pat_ins2_employer_name
_436.patients	pat_ins3_employer_name
_436.patients_demographics_snapshots	pds_ins1_employer_name
_436.patients_demographics_snapshots	pds_ins2_employer_name
_436.patients_demographics_snapshots	pds_ins3_employer_name
_436.precerts	pre_ins1_employer_name
_436.precerts	pre_ins2_employer_name
_436.radiology_orders	rad_ins1_employer_name
_436.radiology_orders	rad_ins2_employer_name
_436_archive_testing.encounters	enc_ins1_employer_name
_436_archive_testing.encounters	enc_ins2_employer_name
_436_archive_testing.encounters	enc_ins3_employer_name
_436_archive_testing.insurances_repository	irep_ins_employer_name
_436_archive_testing.orders	ord_ins1_employer_name
_436_archive_testing.orders	ord_ins2_employer_name
_436_archive_testing.patients	pat_ins1_employer_name
_436_archive_testing.patients	pat_ins2_employer_name
_436_archive_testing.patients	pat_ins3_employer_name
_436_archive_testing.patients_demographics_snapshots	pds_ins1_employer_name
_436_archive_testing.patients_demographics_snapshots	pds_ins2_employer_name
_436_archive_testing.patients_demographics_snapshots	pds_ins3_employer_name
_436_archive_testing.precerts	pre_ins1_employer_name
_436_archive_testing.precerts	pre_ins2_employer_name
_436_archive_testing.radiology_orders	rad_ins1_employer_name
_436_archive_testing.radiology_orders	rad_ins2_employer_name
_437.encounters	enc_ins1_employer_name
_437.encounters	enc_ins2_employer_name
_437.encounters	enc_ins3_employer_name
_437.insurances_repository	irep_ins_employer_name
_437.orders	ord_ins1_employer_name
_437.orders	ord_ins2_employer_name
_437.patients	pat_ins1_employer_name
_437.patients	pat_ins2_employer_name
_437.patients	pat_ins3_employer_name
_437.patients_demographics_snapshots	pds_ins1_employer_name
_437.patients_demographics_snapshots	pds_ins2_employer_name
_437.patients_demographics_snapshots	pds_ins3_employer_name
_437.precerts	pre_ins1_employer_name
_437.precerts	pre_ins2_employer_name
_437.radiology_orders	rad_ins1_employer_name
_437.radiology_orders	rad_ins2_employer_name
_8.encounters	enc_ins1_employer_name
_8.encounters	enc_ins2_employer_name
_8.encounters	enc_ins3_employer_name
_8.insurances_repository	irep_ins_employer_name
_8.orders	ord_ins1_employer_name
_8.orders	ord_ins2_employer_name
_8.patients	pat_ins1_employer_name
_8.patients	pat_ins2_employer_name
_8.patients	pat_ins3_employer_name
_8.patients_demographics_snapshots	pds_ins1_employer_name
_8.patients_demographics_snapshots	pds_ins2_employer_name
_8.patients_demographics_snapshots	pds_ins3_employer_name
_8.precerts	pre_ins1_employer_name
_8.precerts	pre_ins2_employer_name
_8.radiology_orders	rad_ins1_employer_name
_8.radiology_orders	rad_ins2_employer_name
_81.encounters	enc_ins1_employer_name
_81.encounters	enc_ins2_employer_name
_81.encounters	enc_ins3_employer_name
_81.insurances_repository	irep_ins_employer_name
_81.orders	ord_ins1_employer_name
_81.orders	ord_ins2_employer_name
_81.patients	pat_ins1_employer_name
_81.patients	pat_ins2_employer_name
_81.patients	pat_ins3_employer_name
_81.patients_demographics_snapshots	pds_ins1_employer_name
_81.patients_demographics_snapshots	pds_ins2_employer_name
_81.patients_demographics_snapshots	pds_ins3_employer_name
_81.precerts	pre_ins1_employer_name
_81.precerts	pre_ins2_employer_name
_81.radiology_orders	rad_ins1_employer_name
_81.radiology_orders	rad_ins2_employer_name
_999.encounters	enc_ins1_employer_name
_999.encounters	enc_ins2_employer_name
_999.encounters	enc_ins3_employer_name
_999.insurances_repository	irep_ins_employer_name
_999.orders	ord_ins1_employer_name
_999.orders	ord_ins2_employer_name
_999.patients	pat_ins1_employer_name
_999.patients	pat_ins2_employer_name
_999.patients	pat_ins3_employer_name
_999.patients_demographics_snapshots	pds_ins1_employer_name
_999.patients_demographics_snapshots	pds_ins2_employer_name
_999.patients_demographics_snapshots	pds_ins3_employer_name
_999.precerts	pre_ins1_employer_name
_999.precerts	pre_ins2_employer_name
_999.radiology_orders	rad_ins1_employer_name
_999.radiology_orders	rad_ins2_employer_name

fac_no

Table	Column
aurora_standard.chmprica	prev_fac_no
aurora_standard.chmprica	cur_fac_no
aurora_standard.chpcashr	cash_fac_no
aurora_standard.chpcobpd	cash_fac_no
aurora_standard.chpcobpd	bal_fac_no
aurora_standard.chscustd	dept_fac_no
aurora_standard.chshotlr	dept_fac_no
aurora_standard.chtemplr	dflt_fac_no
aurora_standard.curs_temp	cash_fac_no
aurora_standard.curs_temp	ap_fac_no
aurora_standard.stgrowpd	rod_beg_fac_no
aurora_standard.stgrowpd	rod_end_fac_no
aurora_standard.stpcashd	dist_fac_no
aurora_standard.stpcashd	disc_fac_no
aurora_standard.stpcashe	cash_fac_no
aurora_standard.stpcntrc	cash_fac_no
aurora_standard.stpcntrc	disc_fac_no
aurora_standard.stpinvce	cash_fac_no
aurora_standard.stpopend	ap_fac_no
aurora_standard.stpopend	cash_fac_no
aurora_standard.stucntrc	cash_fac_no
aurora_standard.stuinvce	cash_fac_no
aurora_standard.stxfinsd	fin_fac_no
aurora_standard.styaccrr	liab_fac_no
aurora_standard.styaccrr	expense_fac_no
aurora_standard.styemplr	cash_fac_no
aurora_standard.stypayfd	cash_fac_no
aurora_standard.stypayod	bal_fac_no
aurora_standard.stypayre	cash_fac_no
aurora_standard.styrevsd	cash_fac_no
aurora_standard.stytyper	cash_fac_no

tax_year

Table	Column
aurora_standard.stycntrc	w2_tax_year