aurora_standard.chmcontr

Field	Type	Null	Key	Extra
ssn	varchar(11)	YES	MUL
emr_no	bigint(20)	NO
contract_no	bigint(20) unsigned	NO	PRI	auto_increment
amount	decimal(16,2)	YES
interest_rate	decimal(3,3)	YES
no_payments	smallint(6)	YES
freq_days	varchar(2)	YES
start_date	date	YES
state_flag	varchar(1)	YES
input_by	int(11)	YES
signed_by	varchar(30)	YES
cosigned_by	varchar(30)	YES
comment	varchar(40)	YES
contract_bal	decimal(8,2)	YES
letter_date	date	YES
letter_no	varchar(10)	YES
date_closed	date	YES
contract_type	varchar(1)	YES
down_payment	decimal(12,2)	YES
guar_no	int(11)	YES

References

Local Column

References

ssn

Table	Column
Azalea.employees	emp_ssn
_1.charts	chrt_ssn
_1.cpoe_responses	cpoe_res_ssn
_1.encounters	enc_ssn
_1.encounters	enc_guarantor_ssn
_1.encounters	enc_ins1_insured_ssn
_1.encounters	enc_ins2_insured_ssn
_1.encounters	enc_ins3_insured_ssn
_1.examples	exa_ssn
_1.hl7_accessions	acc_ssn
_1.insurances_repository	irep_ins_insured_ssn
_1.non_patients	npat_ssn
_1.orders	ord_ssn
_1.patients	pat_ssn
_1.patients	pat_guarantor_ssn
_1.patients	pat_ins1_insured_ssn
_1.patients	pat_ins2_insured_ssn
_1.patients	pat_ins3_insured_ssn
_1.patients_demographics_snapshots	pds_ssn
_1.patients_demographics_snapshots	pds_guarantor_ssn
_1.patients_demographics_snapshots	pds_ins1_insured_ssn
_1.patients_demographics_snapshots	pds_ins2_insured_ssn
_1.patients_demographics_snapshots	pds_ins3_insured_ssn
_1.patients_responsibility_estimates	prest_ssn
_1.precerts	pre_ssn
_1.precerts	pre_guarantor_ssn
_1.precerts	pre_ins1_insured_ssn
_1.precerts	pre_ins2_insured_ssn
_1.radiology_orders	rad_ssn
_1.radiology_results	rad_res_ssn
_1188.charts	chrt_ssn
_1188.cpoe_responses	cpoe_res_ssn
_1188.encounters	enc_ssn
_1188.encounters	enc_guarantor_ssn
_1188.encounters	enc_ins1_insured_ssn
_1188.encounters	enc_ins2_insured_ssn
_1188.encounters	enc_ins3_insured_ssn
_1188.examples	exa_ssn
_1188.hl7_accessions	acc_ssn
_1188.insurances_repository	irep_ins_insured_ssn
_1188.non_patients	npat_ssn
_1188.orders	ord_ssn
_1188.patients	pat_ssn
_1188.patients	pat_guarantor_ssn
_1188.patients	pat_ins1_insured_ssn
_1188.patients	pat_ins2_insured_ssn
_1188.patients	pat_ins3_insured_ssn
_1188.patients_demographics_snapshots	pds_ssn
_1188.patients_demographics_snapshots	pds_guarantor_ssn
_1188.patients_demographics_snapshots	pds_ins1_insured_ssn
_1188.patients_demographics_snapshots	pds_ins2_insured_ssn
_1188.patients_demographics_snapshots	pds_ins3_insured_ssn
_1188.patients_responsibility_estimates	prest_ssn
_1188.precerts	pre_ssn
_1188.precerts	pre_guarantor_ssn
_1188.precerts	pre_ins1_insured_ssn
_1188.precerts	pre_ins2_insured_ssn
_1188.radiology_orders	rad_ssn
_1188.radiology_results	rad_res_ssn
_1218.charts	chrt_ssn
_1218.cpoe_responses	cpoe_res_ssn
_1218.encounters	enc_ssn
_1218.encounters	enc_guarantor_ssn
_1218.encounters	enc_ins1_insured_ssn
_1218.encounters	enc_ins2_insured_ssn
_1218.encounters	enc_ins3_insured_ssn
_1218.examples	exa_ssn
_1218.hl7_accessions	acc_ssn
_1218.insurances_repository	irep_ins_insured_ssn
_1218.non_patients	npat_ssn
_1218.orders	ord_ssn
_1218.patients	pat_ssn
_1218.patients	pat_guarantor_ssn
_1218.patients	pat_ins1_insured_ssn
_1218.patients	pat_ins2_insured_ssn
_1218.patients	pat_ins3_insured_ssn
_1218.patients_demographics_snapshots	pds_ssn
_1218.patients_demographics_snapshots	pds_guarantor_ssn
_1218.patients_demographics_snapshots	pds_ins1_insured_ssn
_1218.patients_demographics_snapshots	pds_ins2_insured_ssn
_1218.patients_demographics_snapshots	pds_ins3_insured_ssn
_1218.patients_responsibility_estimates	prest_ssn
_1218.precerts	pre_ssn
_1218.precerts	pre_guarantor_ssn
_1218.precerts	pre_ins1_insured_ssn
_1218.precerts	pre_ins2_insured_ssn
_1218.radiology_orders	rad_ssn
_1218.radiology_results	rad_res_ssn
_1548.charts	chrt_ssn
_1548.cpoe_responses	cpoe_res_ssn
_1548.encounters	enc_ssn
_1548.encounters	enc_guarantor_ssn
_1548.encounters	enc_ins1_insured_ssn
_1548.encounters	enc_ins2_insured_ssn
_1548.encounters	enc_ins3_insured_ssn
_1548.examples	exa_ssn
_1548.hl7_accessions	acc_ssn
_1548.insurances_repository	irep_ins_insured_ssn
_1548.non_patients	npat_ssn
_1548.orders	ord_ssn
_1548.patients	pat_ssn
_1548.patients	pat_guarantor_ssn
_1548.patients	pat_ins1_insured_ssn
_1548.patients	pat_ins2_insured_ssn
_1548.patients	pat_ins3_insured_ssn
_1548.patients_demographics_snapshots	pds_ssn
_1548.patients_demographics_snapshots	pds_guarantor_ssn
_1548.patients_demographics_snapshots	pds_ins1_insured_ssn
_1548.patients_demographics_snapshots	pds_ins2_insured_ssn
_1548.patients_demographics_snapshots	pds_ins3_insured_ssn
_1548.patients_responsibility_estimates	prest_ssn
_1548.precerts	pre_ssn
_1548.precerts	pre_guarantor_ssn
_1548.precerts	pre_ins1_insured_ssn
_1548.precerts	pre_ins2_insured_ssn
_1548.radiology_orders	rad_ssn
_1548.radiology_results	rad_res_ssn
_435.charts	chrt_ssn
_435.cpoe_responses	cpoe_res_ssn
_435.encounters	enc_ssn
_435.encounters	enc_guarantor_ssn
_435.encounters	enc_ins1_insured_ssn
_435.encounters	enc_ins2_insured_ssn
_435.encounters	enc_ins3_insured_ssn
_435.examples	exa_ssn
_435.hl7_accessions	acc_ssn
_435.insurances_repository	irep_ins_insured_ssn
_435.non_patients	npat_ssn
_435.orders	ord_ssn
_435.patients	pat_ssn
_435.patients	pat_guarantor_ssn
_435.patients	pat_ins1_insured_ssn
_435.patients	pat_ins2_insured_ssn
_435.patients	pat_ins3_insured_ssn
_435.patients_demographics_snapshots	pds_ssn
_435.patients_demographics_snapshots	pds_guarantor_ssn
_435.patients_demographics_snapshots	pds_ins1_insured_ssn
_435.patients_demographics_snapshots	pds_ins2_insured_ssn
_435.patients_demographics_snapshots	pds_ins3_insured_ssn
_435.patients_responsibility_estimates	prest_ssn
_435.precerts	pre_ssn
_435.precerts	pre_guarantor_ssn
_435.precerts	pre_ins1_insured_ssn
_435.precerts	pre_ins2_insured_ssn
_435.radiology_orders	rad_ssn
_435.radiology_results	rad_res_ssn
_436.charts	chrt_ssn
_436.cpoe_responses	cpoe_res_ssn
_436.encounters	enc_ssn
_436.encounters	enc_guarantor_ssn
_436.encounters	enc_ins1_insured_ssn
_436.encounters	enc_ins2_insured_ssn
_436.encounters	enc_ins3_insured_ssn
_436.examples	exa_ssn
_436.hl7_accessions	acc_ssn
_436.insurances_repository	irep_ins_insured_ssn
_436.non_patients	npat_ssn
_436.orders	ord_ssn
_436.patients	pat_ssn
_436.patients	pat_guarantor_ssn
_436.patients	pat_ins1_insured_ssn
_436.patients	pat_ins2_insured_ssn
_436.patients	pat_ins3_insured_ssn
_436.patients_demographics_snapshots	pds_ssn
_436.patients_demographics_snapshots	pds_guarantor_ssn
_436.patients_demographics_snapshots	pds_ins1_insured_ssn
_436.patients_demographics_snapshots	pds_ins2_insured_ssn
_436.patients_demographics_snapshots	pds_ins3_insured_ssn
_436.patients_responsibility_estimates	prest_ssn
_436.precerts	pre_ssn
_436.precerts	pre_guarantor_ssn
_436.precerts	pre_ins1_insured_ssn
_436.precerts	pre_ins2_insured_ssn
_436.radiology_orders	rad_ssn
_436.radiology_results	rad_res_ssn
_436_archive_testing.charts	chrt_ssn
_436_archive_testing.cpoe_responses	cpoe_res_ssn
_436_archive_testing.encounters	enc_ssn
_436_archive_testing.encounters	enc_guarantor_ssn
_436_archive_testing.encounters	enc_ins1_insured_ssn
_436_archive_testing.encounters	enc_ins2_insured_ssn
_436_archive_testing.encounters	enc_ins3_insured_ssn
_436_archive_testing.examples	exa_ssn
_436_archive_testing.hl7_accessions	acc_ssn
_436_archive_testing.insurances_repository	irep_ins_insured_ssn
_436_archive_testing.non_patients	npat_ssn
_436_archive_testing.orders	ord_ssn
_436_archive_testing.patients	pat_ssn
_436_archive_testing.patients	pat_guarantor_ssn
_436_archive_testing.patients	pat_ins1_insured_ssn
_436_archive_testing.patients	pat_ins2_insured_ssn
_436_archive_testing.patients	pat_ins3_insured_ssn
_436_archive_testing.patients_demographics_snapshots	pds_ssn
_436_archive_testing.patients_demographics_snapshots	pds_guarantor_ssn
_436_archive_testing.patients_demographics_snapshots	pds_ins1_insured_ssn
_436_archive_testing.patients_demographics_snapshots	pds_ins2_insured_ssn
_436_archive_testing.patients_demographics_snapshots	pds_ins3_insured_ssn
_436_archive_testing.patients_responsibility_estimates	prest_ssn
_436_archive_testing.precerts	pre_ssn
_436_archive_testing.precerts	pre_guarantor_ssn
_436_archive_testing.precerts	pre_ins1_insured_ssn
_436_archive_testing.precerts	pre_ins2_insured_ssn
_436_archive_testing.radiology_orders	rad_ssn
_436_archive_testing.radiology_results	rad_res_ssn
_437.charts	chrt_ssn
_437.cpoe_responses	cpoe_res_ssn
_437.encounters	enc_ssn
_437.encounters	enc_guarantor_ssn
_437.encounters	enc_ins1_insured_ssn
_437.encounters	enc_ins2_insured_ssn
_437.encounters	enc_ins3_insured_ssn
_437.examples	exa_ssn
_437.hl7_accessions	acc_ssn
_437.insurances_repository	irep_ins_insured_ssn
_437.non_patients	npat_ssn
_437.orders	ord_ssn
_437.patients	pat_ssn
_437.patients	pat_guarantor_ssn
_437.patients	pat_ins1_insured_ssn
_437.patients	pat_ins2_insured_ssn
_437.patients	pat_ins3_insured_ssn
_437.patients_demographics_snapshots	pds_ssn
_437.patients_demographics_snapshots	pds_guarantor_ssn
_437.patients_demographics_snapshots	pds_ins1_insured_ssn
_437.patients_demographics_snapshots	pds_ins2_insured_ssn
_437.patients_demographics_snapshots	pds_ins3_insured_ssn
_437.patients_responsibility_estimates	prest_ssn
_437.precerts	pre_ssn
_437.precerts	pre_guarantor_ssn
_437.precerts	pre_ins1_insured_ssn
_437.precerts	pre_ins2_insured_ssn
_437.radiology_orders	rad_ssn
_437.radiology_results	rad_res_ssn
_8.charts	chrt_ssn
_8.cpoe_responses	cpoe_res_ssn
_8.encounters	enc_ssn
_8.encounters	enc_guarantor_ssn
_8.encounters	enc_ins1_insured_ssn
_8.encounters	enc_ins2_insured_ssn
_8.encounters	enc_ins3_insured_ssn
_8.examples	exa_ssn
_8.hl7_accessions	acc_ssn
_8.insurances_repository	irep_ins_insured_ssn
_8.non_patients	npat_ssn
_8.orders	ord_ssn
_8.patients	pat_ssn
_8.patients	pat_guarantor_ssn
_8.patients	pat_ins1_insured_ssn
_8.patients	pat_ins2_insured_ssn
_8.patients	pat_ins3_insured_ssn
_8.patients_demographics_snapshots	pds_ssn
_8.patients_demographics_snapshots	pds_guarantor_ssn
_8.patients_demographics_snapshots	pds_ins1_insured_ssn
_8.patients_demographics_snapshots	pds_ins2_insured_ssn
_8.patients_demographics_snapshots	pds_ins3_insured_ssn
_8.patients_responsibility_estimates	prest_ssn
_8.precerts	pre_ssn
_8.precerts	pre_guarantor_ssn
_8.precerts	pre_ins1_insured_ssn
_8.precerts	pre_ins2_insured_ssn
_8.radiology_orders	rad_ssn
_8.radiology_results	rad_res_ssn
_81.charts	chrt_ssn
_81.cpoe_responses	cpoe_res_ssn
_81.encounters	enc_ssn
_81.encounters	enc_guarantor_ssn
_81.encounters	enc_ins1_insured_ssn
_81.encounters	enc_ins2_insured_ssn
_81.encounters	enc_ins3_insured_ssn
_81.examples	exa_ssn
_81.hl7_accessions	acc_ssn
_81.insurances_repository	irep_ins_insured_ssn
_81.non_patients	npat_ssn
_81.orders	ord_ssn
_81.patients	pat_ssn
_81.patients	pat_guarantor_ssn
_81.patients	pat_ins1_insured_ssn
_81.patients	pat_ins2_insured_ssn
_81.patients	pat_ins3_insured_ssn
_81.patients_demographics_snapshots	pds_ssn
_81.patients_demographics_snapshots	pds_guarantor_ssn
_81.patients_demographics_snapshots	pds_ins1_insured_ssn
_81.patients_demographics_snapshots	pds_ins2_insured_ssn
_81.patients_demographics_snapshots	pds_ins3_insured_ssn
_81.patients_responsibility_estimates	prest_ssn
_81.precerts	pre_ssn
_81.precerts	pre_guarantor_ssn
_81.precerts	pre_ins1_insured_ssn
_81.precerts	pre_ins2_insured_ssn
_81.radiology_orders	rad_ssn
_81.radiology_results	rad_res_ssn
_999.charts	chrt_ssn
_999.cpoe_responses	cpoe_res_ssn
_999.encounters	enc_ssn
_999.encounters	enc_guarantor_ssn
_999.encounters	enc_ins1_insured_ssn
_999.encounters	enc_ins2_insured_ssn
_999.encounters	enc_ins3_insured_ssn
_999.examples	exa_ssn
_999.hl7_accessions	acc_ssn
_999.insurances_repository	irep_ins_insured_ssn
_999.non_patients	npat_ssn
_999.orders	ord_ssn
_999.patients	pat_ssn
_999.patients	pat_guarantor_ssn
_999.patients	pat_ins1_insured_ssn
_999.patients	pat_ins2_insured_ssn
_999.patients	pat_ins3_insured_ssn
_999.patients_demographics_snapshots	pds_ssn
_999.patients_demographics_snapshots	pds_guarantor_ssn
_999.patients_demographics_snapshots	pds_ins1_insured_ssn
_999.patients_demographics_snapshots	pds_ins2_insured_ssn
_999.patients_demographics_snapshots	pds_ins3_insured_ssn
_999.patients_responsibility_estimates	prest_ssn
_999.precerts	pre_ssn
_999.precerts	pre_guarantor_ssn
_999.precerts	pre_ins1_insured_ssn
_999.precerts	pre_ins2_insured_ssn
_999.radiology_orders	rad_ssn
_999.radiology_results	rad_res_ssn
aurora_standard.abmmpi	gu_ssn
aurora_standard.abmvis	gu_ssn
aurora_standard.adupgu	guar_ssn
aurora_standard.aswguar	guar_ssn
aurora_standard.b2badd	p_ssn
aurora_standard.b2mrdr	p_ssn
aurora_standard.bdallvis	pat_ssn
aurora_standard.bdguar	guar_ssn
aurora_standard.bdmpi	p_ssn
aurora_standard.bdmpi	sp_ssn
aurora_standard.bdvis	pat_ssn
aurora_standard.bevis	p_ssn
aurora_standard.bevisbd	p_ssn
aurora_standard.bevisbd2	p_ssn
aurora_standard.bhar	p_ssn
aurora_standard.bhar	new_ssn
aurora_standard.bhar	g_ssn
aurora_standard.bhbadd	p_ssn
aurora_standard.bhguar	guar_ssn
aurora_standard.bhldgr	p_ssn
aurora_standard.bhldgr	guar_ssn
aurora_standard.bhmrdr	p_ssn
aurora_standard.bhppat	p_ssn
aurora_standard.bhtguar	guar_ssn
aurora_standard.bhtldgr	p_ssn
aurora_standard.bhtldgr	guar_ssn
aurora_standard.bhtmrdr	p_ssn
aurora_standard.bhtppat	p_ssn
aurora_standard.bmguar	guar_ssn
aurora_standard.bmmpi	p_ssn
aurora_standard.bmnkin	n_ssn
aurora_standard.bmpact	p_ssn
aurora_standard.bmpat	p_ssn
aurora_standard.bpar	p_ssn
aurora_standard.bpar	new_ssn
aurora_standard.bpar	g_ssn
aurora_standard.bpar2	p_ssn
aurora_standard.bpar2	new_ssn
aurora_standard.bpar2	g_ssn
aurora_standard.bpmpi	p_ssn
aurora_standard.bpmpi2	p_ssn
aurora_standard.bpmr	p_ssn
aurora_standard.bpmr2	p_ssn
aurora_standard.bsguar	guar_ssn
aurora_standard.bsinsur	spouse_ssn
aurora_standard.bsvis	pat_ssn
aurora_standard.bsvisbd	pat_ssn
aurora_standard.bvguar	gu_ssn
aurora_standard.bvmpi	p_ssn
aurora_standard.bvmpi2	p_ssn
aurora_standard.c7guarr	guar_ssn
aurora_standard.c7mpi	p_ssn
aurora_standard.c7mpi	gu_ssn
aurora_standard.c7vis	pat_ssn
aurora_standard.c8dtls	p_ssn
aurora_standard.c8guar	guar_ssn
aurora_standard.c8guar2	guar_ssn
aurora_standard.c9mpi	p_ssn
aurora_standard.c9vis	p_ssn
aurora_standard.cafc	pat_ssn
aurora_standard.caguarr	guar_ssn
aurora_standard.campi	spouse_ssn
aurora_standard.cavis	pat_ssn
aurora_standard.cavish	pat_ssn
aurora_standard.chhl7in2	ins_ssn
aurora_standard.chlmdssd	prev_ssn
aurora_standard.chltrnsd	prev_ssn
aurora_standard.chmarcnbf	g_ssn
aurora_standard.chmarcnbf	p_ssn
aurora_standard.chmarsi	pat_ssn
aurora_standard.chmarsi	gu_ssn
aurora_standard.chmarsi	sp_ssn
aurora_standard.chmazstd	pat_ssn
aurora_standard.chmazsti	pat_ssn
aurora_standard.chmazsto	pat_ssn
aurora_standard.chmcampi	pat_ssn
aurora_standard.chmcampi	gu_ssn
aurora_standard.chmcampi	sp_ssn
aurora_standard.chmcmhed	debtor_1_ssn
aurora_standard.chmcmhed	debtor_2_ssn
aurora_standard.chmcmhed	pat_ssn
aurora_standard.chmcssnd	new_ssn
aurora_standard.chmcssnd	old_ssn
aurora_standard.chmexmpi	pat_ssn
aurora_standard.chmexmpi	gu_ssn
aurora_standard.chmexmpi	sp_ssn
aurora_standard.chmexvis	pat_ssn
aurora_standard.chmguarr	guar_ssn
aurora_standard.chmhistp	p_ssn
aurora_standard.chmlastr	pat_ssn
aurora_standard.chmmhast	pat_ssn
aurora_standard.chmokipd	pat_ssn
aurora_standard.chmokopd	pat_ssn
aurora_standard.chmoperc	auto_ssn
aurora_standard.chmozpcd	debtor_1_ssn
aurora_standard.chmozpcd	debtor_2_ssn
aurora_standard.chmpatmr	spouse_ssn
aurora_standard.chmpatwc	mom_ssn
aurora_standard.chmpatwc	dad_ssn
aurora_standard.chmpdemo	p_ssn
aurora_standard.chmpdemo	sp_ssn
aurora_standard.chmpdemo	gu_ssn
aurora_standard.chmradex	pat_ssn
aurora_standard.chmradex	gu_ssn
aurora_standard.chmradex	sp_ssn
aurora_standard.chmtxstr	pat_ssn
aurora_standard.chpcobdd	dep_ssn
aurora_standard.chpdeped	depend_ssn
aurora_standard.chpempdd	person_ssn
aurora_standard.chxcntrc	id_is_ssn
aurora_standard.hl7gt1	guar_ssn
aurora_standard.hl7gt1ad	guar_ssn
aurora_standard.hl7in2	ins_ssn
aurora_standard.hl7in2ad	ins_ssn
aurora_standard.hl7pid	pat_ssn
aurora_standard.hl7pidad	pat_ssn
aurora_standard.kcvis	pat_ssn
aurora_standard.kcvisit	pat_ssn
aurora_standard.nbspouse	spouse_ssn
aurora_standard.ncexmpi	pat_ssn
aurora_standard.oddpaydd	empl_ssn
aurora_standard.oddpayid	empl_ssn
aurora_standard.oddpayod	empl_ssn
aurora_standard.oddpayre	empl_ssn
aurora_standard.odhpaydd	empl_ssn
aurora_standard.odhpayid	empl_ssn
aurora_standard.odhpayod	empl_ssn
aurora_standard.odhpayre	empl_ssn
aurora_standard.styoempd	depend_ssn
common.customers	cus_require_ssn

start_date

Table	Column
HSPI_Bastrop.PatientTracking	period_start_date
HSPI_Bastrop.allergies	period_start_date
HSPI_Bastrop.appointments	datetime_start_date
HSPI_Bastrop.care_plans	effective_start_date
HSPI_Bastrop.charges	dateOfService_start_date
HSPI_Bastrop.claim_items	billablePeriod_start_date
HSPI_Bastrop.claim_supporting_info	timingPeriod_start_date
HSPI_Bastrop.claims	billablePeriod_start_date
HSPI_Bastrop.conditions	onsetPeriod_start_date
HSPI_Bastrop.coverages	period_start_date
HSPI_Bastrop.encounter_occurence_span_codes	period_start_date
HSPI_Bastrop.encounters	period_start_date
HSPI_Bastrop.examples	datetime_start_date
HSPI_Bastrop.family_history	birthPeriod_start_date
HSPI_Bastrop.family_history	deathPeriod_start_date
HSPI_Bastrop.laboratory_results	effective_start_date
HSPI_Bastrop.medication_requests	dispense_period_start_date
HSPI_Bastrop.medications	effective_start_date
HSPI_Bastrop.observations	effective_start_date
HSPI_Bastrop.patient_tracking	period_start_date
HSPI_Bastrop.patients_authorization_ids	effectivePeriod_start_date
HSPI_Bastrop.problems	period_start_date
HSPI_Bastrop.procedures	performed_start_date
HSPI_CURES2015_B1.allergies	period_start_date
HSPI_CURES2015_B1.appointments	datetime_start_date
HSPI_CURES2015_B1.care_plans	effective_start_date
HSPI_CURES2015_B1.charges	dateOfService_start_date
HSPI_CURES2015_B1.claim_items	billablePeriod_start_date
HSPI_CURES2015_B1.claim_supporting_info	timingPeriod_start_date
HSPI_CURES2015_B1.claims	billablePeriod_start_date
HSPI_CURES2015_B1.conditions	onsetPeriod_start_date
HSPI_CURES2015_B1.coverages	period_start_date
HSPI_CURES2015_B1.encounter_occurence_span_codes	period_start_date
HSPI_CURES2015_B1.encounters	period_start_date
HSPI_CURES2015_B1.encounters	unableToWork_start_date
HSPI_CURES2015_B1.examples	datetime_start_date
HSPI_CURES2015_B1.family_history	birthPeriod_start_date
HSPI_CURES2015_B1.family_history	deathPeriod_start_date
HSPI_CURES2015_B1.invoices	generationPeriod_start_date
HSPI_CURES2015_B1.laboratory_results	effective_start_date
HSPI_CURES2015_B1.medication_requests	dispense_period_start_date
HSPI_CURES2015_B1.medications	effective_start_date
HSPI_CURES2015_B1.observations	effective_start_date
HSPI_CURES2015_B1.patient_tracking	period_start_date
HSPI_CURES2015_B1.patients_authorization_ids	effectivePeriod_start_date
HSPI_CURES2015_B1.problems	period_start_date
HSPI_CURES2015_B1.procedures	performed_start_date
HSPI_Central_Hospital.addresses	period_start_date
HSPI_Central_Hospital.allergies	period_start_date
HSPI_Central_Hospital.appointments	datetime_start_date
HSPI_Central_Hospital.care_plans	effective_start_date
HSPI_Central_Hospital.charges	dateOfService_start_date
HSPI_Central_Hospital.claim_items	billablePeriod_start_date
HSPI_Central_Hospital.claim_supporting_info	timingPeriod_start_date
HSPI_Central_Hospital.claims	billablePeriod_start_date
HSPI_Central_Hospital.conditions	onsetPeriod_start_date
HSPI_Central_Hospital.coverages	period_start_date
HSPI_Central_Hospital.encounter_occurence_span_codes	period_start_date
HSPI_Central_Hospital.encounters	period_start_date
HSPI_Central_Hospital.encounters	unableToWork_start_date
HSPI_Central_Hospital.examples	datetime_start_date
HSPI_Central_Hospital.family_history	birthPeriod_start_date
HSPI_Central_Hospital.family_history	deathPeriod_start_date
HSPI_Central_Hospital.invoices	generationPeriod_start_date
HSPI_Central_Hospital.laboratory_results	effective_start_date
HSPI_Central_Hospital.medication_requests	dispense_period_start_date
HSPI_Central_Hospital.medications	effective_start_date
HSPI_Central_Hospital.names	period_start_date
HSPI_Central_Hospital.observations	effective_start_date
HSPI_Central_Hospital.patient_tracking	period_start_date
HSPI_Central_Hospital.patients_authorization_ids	effectivePeriod_start_date
HSPI_Central_Hospital.problems	period_start_date
HSPI_Central_Hospital.procedures	performed_start_date
HSPI_Dewitt.addresses	period_start_date
HSPI_Dewitt.allergies	period_start_date
HSPI_Dewitt.appointments	datetime_start_date
HSPI_Dewitt.care_plans	effective_start_date
HSPI_Dewitt.charges	dateOfService_start_date
HSPI_Dewitt.claim_items	billablePeriod_start_date
HSPI_Dewitt.claim_supporting_info	timingPeriod_start_date
HSPI_Dewitt.claims	billablePeriod_start_date
HSPI_Dewitt.conditions	onsetPeriod_start_date
HSPI_Dewitt.coverages	period_start_date
HSPI_Dewitt.encounter_occurence_span_codes	period_start_date
HSPI_Dewitt.encounters	period_start_date
HSPI_Dewitt.encounters	unableToWork_start_date
HSPI_Dewitt.examples	datetime_start_date
HSPI_Dewitt.family_history	birthPeriod_start_date
HSPI_Dewitt.family_history	deathPeriod_start_date
HSPI_Dewitt.invoices	generationPeriod_start_date
HSPI_Dewitt.laboratory_results	effective_start_date
HSPI_Dewitt.medication_requests	dispense_period_start_date
HSPI_Dewitt.medications	effective_start_date
HSPI_Dewitt.names	period_start_date
HSPI_Dewitt.observations	effective_start_date
HSPI_Dewitt.patient_tracking	period_start_date
HSPI_Dewitt.patients_authorization_ids	effectivePeriod_start_date
HSPI_Dewitt.problems	period_start_date
HSPI_Dewitt.procedures	performed_start_date
HSPI_Fulton.addresses	period_start_date
HSPI_Fulton.allergies	period_start_date
HSPI_Fulton.appointments	datetime_start_date
HSPI_Fulton.care_plans	effective_start_date
HSPI_Fulton.charges	dateOfService_start_date
HSPI_Fulton.claim_items	billablePeriod_start_date
HSPI_Fulton.claim_supporting_info	timingPeriod_start_date
HSPI_Fulton.claims	billablePeriod_start_date
HSPI_Fulton.conditions	onsetPeriod_start_date
HSPI_Fulton.coverages	period_start_date
HSPI_Fulton.encounter_occurence_span_codes	period_start_date
HSPI_Fulton.encounters	period_start_date
HSPI_Fulton.encounters	unableToWork_start_date
HSPI_Fulton.examples	datetime_start_date
HSPI_Fulton.family_history	birthPeriod_start_date
HSPI_Fulton.family_history	deathPeriod_start_date
HSPI_Fulton.invoices	generationPeriod_start_date
HSPI_Fulton.laboratory_results	effective_start_date
HSPI_Fulton.medication_requests	dispense_period_start_date
HSPI_Fulton.medications	effective_start_date
HSPI_Fulton.names	period_start_date
HSPI_Fulton.observations	effective_start_date
HSPI_Fulton.patient_tracking	period_start_date
HSPI_Fulton.patients_authorization_ids	effectivePeriod_start_date
HSPI_Fulton.problems	period_start_date
HSPI_Fulton.procedures	performed_start_date
HSPI_Inferno.addresses	period_start_date
HSPI_Inferno.allergies	period_start_date
HSPI_Inferno.appointments	datetime_start_date
HSPI_Inferno.care_plans	effective_start_date
HSPI_Inferno.charges	dateOfService_start_date
HSPI_Inferno.claim_items	billablePeriod_start_date
HSPI_Inferno.claim_supporting_info	timingPeriod_start_date
HSPI_Inferno.claims	billablePeriod_start_date
HSPI_Inferno.conditions	onsetPeriod_start_date
HSPI_Inferno.coverages	period_start_date
HSPI_Inferno.encounter_occurence_span_codes	period_start_date
HSPI_Inferno.encounters	period_start_date
HSPI_Inferno.encounters	unableToWork_start_date
HSPI_Inferno.examples	datetime_start_date
HSPI_Inferno.family_history	birthPeriod_start_date
HSPI_Inferno.family_history	deathPeriod_start_date
HSPI_Inferno.invoices	generationPeriod_start_date
HSPI_Inferno.laboratory_results	effective_start_date
HSPI_Inferno.medication_requests	dispense_period_start_date
HSPI_Inferno.medications	effective_start_date
HSPI_Inferno.names	period_start_date
HSPI_Inferno.observations	effective_start_date
HSPI_Inferno.patient_tracking	period_start_date
HSPI_Inferno.patients_authorization_ids	effectivePeriod_start_date
HSPI_Inferno.problems	period_start_date
HSPI_Inferno.procedures	performed_start_date
HSPI_MU2015_E1.addresses	period_start_date
HSPI_MU2015_E1.allergies	period_start_date
HSPI_MU2015_E1.appointments	datetime_start_date
HSPI_MU2015_E1.care_plans	effective_start_date
HSPI_MU2015_E1.charges	dateOfService_start_date
HSPI_MU2015_E1.claim_items	billablePeriod_start_date
HSPI_MU2015_E1.claim_supporting_info	timingPeriod_start_date
HSPI_MU2015_E1.claims	billablePeriod_start_date
HSPI_MU2015_E1.conditions	onsetPeriod_start_date
HSPI_MU2015_E1.coverages	period_start_date
HSPI_MU2015_E1.encounter_occurence_span_codes	period_start_date
HSPI_MU2015_E1.encounters	period_start_date
HSPI_MU2015_E1.encounters	unableToWork_start_date
HSPI_MU2015_E1.examples	datetime_start_date
HSPI_MU2015_E1.family_history	birthPeriod_start_date
HSPI_MU2015_E1.family_history	deathPeriod_start_date
HSPI_MU2015_E1.invoices	generationPeriod_start_date
HSPI_MU2015_E1.laboratory_results	effective_start_date
HSPI_MU2015_E1.medication_requests	dispense_period_start_date
HSPI_MU2015_E1.medications	effective_start_date
HSPI_MU2015_E1.names	period_start_date
HSPI_MU2015_E1.observations	effective_start_date
HSPI_MU2015_E1.patient_tracking	period_start_date
HSPI_MU2015_E1.patients_authorization_ids	effectivePeriod_start_date
HSPI_MU2015_E1.problems	period_start_date
HSPI_MU2015_E1.procedures	performed_start_date
HSPI_MU2015_G2.addresses	period_start_date
HSPI_MU2015_G2.allergies	period_start_date
HSPI_MU2015_G2.appointments	datetime_start_date
HSPI_MU2015_G2.care_plans	effective_start_date
HSPI_MU2015_G2.charges	dateOfService_start_date
HSPI_MU2015_G2.claim_items	billablePeriod_start_date
HSPI_MU2015_G2.claim_supporting_info	timingPeriod_start_date
HSPI_MU2015_G2.claims	billablePeriod_start_date
HSPI_MU2015_G2.conditions	onsetPeriod_start_date
HSPI_MU2015_G2.coverages	period_start_date
HSPI_MU2015_G2.encounter_occurence_span_codes	period_start_date
HSPI_MU2015_G2.encounters	period_start_date
HSPI_MU2015_G2.encounters	unableToWork_start_date
HSPI_MU2015_G2.examples	datetime_start_date
HSPI_MU2015_G2.family_history	birthPeriod_start_date
HSPI_MU2015_G2.family_history	deathPeriod_start_date
HSPI_MU2015_G2.invoices	generationPeriod_start_date
HSPI_MU2015_G2.laboratory_results	effective_start_date
HSPI_MU2015_G2.medication_requests	dispense_period_start_date
HSPI_MU2015_G2.medications	effective_start_date
HSPI_MU2015_G2.names	period_start_date
HSPI_MU2015_G2.observations	effective_start_date
HSPI_MU2015_G2.patient_tracking	period_start_date
HSPI_MU2015_G2.patients_authorization_ids	effectivePeriod_start_date
HSPI_MU2015_G2.problems	period_start_date
HSPI_MU2015_G2.procedures	performed_start_date
HSPI_MU2015_G9.addresses	period_start_date
HSPI_MU2015_G9.allergies	period_start_date
HSPI_MU2015_G9.appointments	datetime_start_date
HSPI_MU2015_G9.care_plans	effective_start_date
HSPI_MU2015_G9.charges	dateOfService_start_date
HSPI_MU2015_G9.claim_items	billablePeriod_start_date
HSPI_MU2015_G9.claim_supporting_info	timingPeriod_start_date
HSPI_MU2015_G9.claims	billablePeriod_start_date
HSPI_MU2015_G9.conditions	onsetPeriod_start_date
HSPI_MU2015_G9.coverages	period_start_date
HSPI_MU2015_G9.encounter_occurence_span_codes	period_start_date
HSPI_MU2015_G9.encounters	period_start_date
HSPI_MU2015_G9.encounters	unableToWork_start_date
HSPI_MU2015_G9.examples	datetime_start_date
HSPI_MU2015_G9.family_history	birthPeriod_start_date
HSPI_MU2015_G9.family_history	deathPeriod_start_date
HSPI_MU2015_G9.invoices	generationPeriod_start_date
HSPI_MU2015_G9.laboratory_results	effective_start_date
HSPI_MU2015_G9.medication_requests	dispense_period_start_date
HSPI_MU2015_G9.medications	effective_start_date
HSPI_MU2015_G9.names	period_start_date
HSPI_MU2015_G9.observations	effective_start_date
HSPI_MU2015_G9.patient_tracking	period_start_date
HSPI_MU2015_G9.patients_authorization_ids	effectivePeriod_start_date
HSPI_MU2015_G9.problems	period_start_date
HSPI_MU2015_G9.procedures	performed_start_date
HSPI_Ness.allergies	period_start_date
HSPI_Ness.appointments	datetime_start_date
HSPI_Ness.claims	billablePeriod_start_date
HSPI_Ness.conditions	onsetPeriod_start_date
HSPI_Ness.coverages	period_start_date
HSPI_Ness.encounters	period_start_date
HSPI_Ness.family_history	birthPeriod_start_date
HSPI_Ness.family_history	deathPeriod_start_date
HSPI_Ness.laboratory_results	effective_start_date
HSPI_Ness.medications	effective_start_date
HSPI_Ness.observations	effective_start_date
HSPI_Ness.problems	period_start_date
HSPI_Ness.procedures	performed_start_date
HSPI_Sandbox.addresses	period_start_date
HSPI_Sandbox.allergies	period_start_date
HSPI_Sandbox.appointments	datetime_start_date
HSPI_Sandbox.care_plans	effective_start_date
HSPI_Sandbox.charges	dateOfService_start_date
HSPI_Sandbox.claim_items	billablePeriod_start_date
HSPI_Sandbox.claim_supporting_info	timingPeriod_start_date
HSPI_Sandbox.claims	billablePeriod_start_date
HSPI_Sandbox.conditions	onsetPeriod_start_date
HSPI_Sandbox.coverages	period_start_date
HSPI_Sandbox.encounter_occurence_span_codes	period_start_date
HSPI_Sandbox.encounters	period_start_date
HSPI_Sandbox.encounters	unableToWork_start_date
HSPI_Sandbox.examples	datetime_start_date
HSPI_Sandbox.family_history	birthPeriod_start_date
HSPI_Sandbox.family_history	deathPeriod_start_date
HSPI_Sandbox.invoices	generationPeriod_start_date
HSPI_Sandbox.laboratory_results	effective_start_date
HSPI_Sandbox.medication_requests	dispense_period_start_date
HSPI_Sandbox.medications	effective_start_date
HSPI_Sandbox.names	period_start_date
HSPI_Sandbox.observations	effective_start_date
HSPI_Sandbox.patient_tracking	period_start_date
HSPI_Sandbox.patients_authorization_ids	effectivePeriod_start_date
HSPI_Sandbox.problems	period_start_date
HSPI_Sandbox.procedures	performed_start_date
HSPI_Summit_General.addresses	period_start_date
HSPI_Summit_General.allergies	period_start_date
HSPI_Summit_General.appointments	datetime_start_date
HSPI_Summit_General.care_plans	effective_start_date
HSPI_Summit_General.charges	dateOfService_start_date
HSPI_Summit_General.claim_items	billablePeriod_start_date
HSPI_Summit_General.claim_supporting_info	timingPeriod_start_date
HSPI_Summit_General.claims	billablePeriod_start_date
HSPI_Summit_General.conditions	onsetPeriod_start_date
HSPI_Summit_General.coverages	period_start_date
HSPI_Summit_General.encounter_occurence_span_codes	period_start_date
HSPI_Summit_General.encounters	period_start_date
HSPI_Summit_General.encounters	unableToWork_start_date
HSPI_Summit_General.examples	datetime_start_date
HSPI_Summit_General.family_history	birthPeriod_start_date
HSPI_Summit_General.family_history	deathPeriod_start_date
HSPI_Summit_General.invoices	generationPeriod_start_date
HSPI_Summit_General.laboratory_results	effective_start_date
HSPI_Summit_General.medication_requests	dispense_period_start_date
HSPI_Summit_General.medications	effective_start_date
HSPI_Summit_General.names	period_start_date
HSPI_Summit_General.observations	effective_start_date
HSPI_Summit_General.patient_tracking	period_start_date
HSPI_Summit_General.patients_authorization_ids	effectivePeriod_start_date
HSPI_Summit_General.problems	period_start_date
HSPI_Summit_General.procedures	performed_start_date
HSPI_System.addresses	period_start_date
HSPI_United_Physicians.addresses	period_start_date
HSPI_United_Physicians.allergies	period_start_date
HSPI_United_Physicians.appointments	datetime_start_date
HSPI_United_Physicians.care_plans	effective_start_date
HSPI_United_Physicians.charges	dateOfService_start_date
HSPI_United_Physicians.claim_items	billablePeriod_start_date
HSPI_United_Physicians.claim_supporting_info	timingPeriod_start_date
HSPI_United_Physicians.claims	billablePeriod_start_date
HSPI_United_Physicians.conditions	onsetPeriod_start_date
HSPI_United_Physicians.coverages	period_start_date
HSPI_United_Physicians.encounter_occurence_span_codes	period_start_date
HSPI_United_Physicians.encounters	period_start_date
HSPI_United_Physicians.encounters	unableToWork_start_date
HSPI_United_Physicians.examples	datetime_start_date
HSPI_United_Physicians.family_history	birthPeriod_start_date
HSPI_United_Physicians.family_history	deathPeriod_start_date
HSPI_United_Physicians.invoices	generationPeriod_start_date
HSPI_United_Physicians.laboratory_results	effective_start_date
HSPI_United_Physicians.medication_requests	dispense_period_start_date
HSPI_United_Physicians.medications	effective_start_date
HSPI_United_Physicians.names	period_start_date
HSPI_United_Physicians.observations	effective_start_date
HSPI_United_Physicians.patient_tracking	period_start_date
HSPI_United_Physicians.patients_authorization_ids	effectivePeriod_start_date
HSPI_United_Physicians.problems	period_start_date
HSPI_United_Physicians.procedures	performed_start_date
MPI.addresses	period_start_date
MPI.allergies	period_start_date
MPI.appointments	datetime_start_date
MPI.care_plans	effective_start_date
MPI.charges	dateOfService_start_date
MPI.claim_items	billablePeriod_start_date
MPI.claim_supporting_info	timingPeriod_start_date
MPI.claims	billablePeriod_start_date
MPI.conditions	onsetPeriod_start_date
MPI.coverages	period_start_date
MPI.encounter_occurence_span_codes	period_start_date
MPI.encounters	period_start_date
MPI.encounters	unableToWork_start_date
MPI.examples	datetime_start_date
MPI.family_history	birthPeriod_start_date
MPI.family_history	deathPeriod_start_date
MPI.invoices	generationPeriod_start_date
MPI.laboratory_results	effective_start_date
MPI.medication_requests	dispense_period_start_date
MPI.medications	effective_start_date
MPI.names	period_start_date
MPI.observations	effective_start_date
MPI.patient_tracking	period_start_date
MPI.patients_authorization_ids	effectivePeriod_start_date
MPI.problems	period_start_date
MPI.procedures	performed_start_date
SSO.login_notifications	period_start_date
SSO.names	period_start_date
_1.charts_medications	cm_start_date
_1.encounters	enc_ins1_start_date
_1.encounters	enc_ins1_referral_start_date
_1.encounters	enc_ins2_start_date
_1.encounters	enc_ins3_start_date
_1.insurances_repository	irep_ins_start_date
_1.insurances_repository	irep_ins_referral_start_date
_1.patients	pat_ins1_start_date
_1.patients	pat_ins1_referral_start_date
_1.patients	pat_ins2_start_date
_1.patients	pat_ins3_start_date
_1.patients_configured_encounters_schedules	pces_start_date
_1.patients_demographics_snapshots	pds_ins1_start_date
_1.patients_demographics_snapshots	pds_ins1_referral_start_date
_1.patients_demographics_snapshots	pds_ins2_start_date
_1.patients_demographics_snapshots	pds_ins3_start_date
_1.patients_medications	pms_start_date
_1.patients_payments_schedules	pps_start_date
_1.precerts	pre_ins1_start_date
_1.precerts	pre_ins1_referral_start_date
_1.precerts	pre_ins2_start_date
_1188.charts_medications	cm_start_date
_1188.encounters	enc_ins1_start_date
_1188.encounters	enc_ins1_referral_start_date
_1188.encounters	enc_ins2_start_date
_1188.encounters	enc_ins3_start_date
_1188.insurances_repository	irep_ins_start_date
_1188.insurances_repository	irep_ins_referral_start_date
_1188.patients	pat_ins1_start_date
_1188.patients	pat_ins1_referral_start_date
_1188.patients	pat_ins2_start_date
_1188.patients	pat_ins3_start_date
_1188.patients_configured_encounters_schedules	pces_start_date
_1188.patients_demographics_snapshots	pds_ins1_start_date
_1188.patients_demographics_snapshots	pds_ins1_referral_start_date
_1188.patients_demographics_snapshots	pds_ins2_start_date
_1188.patients_demographics_snapshots	pds_ins3_start_date
_1188.patients_medications	pms_start_date
_1188.patients_payments_schedules	pps_start_date
_1188.precerts	pre_ins1_start_date
_1188.precerts	pre_ins1_referral_start_date
_1188.precerts	pre_ins2_start_date
_1218.charts_medications	cm_start_date
_1218.encounters	enc_ins1_start_date
_1218.encounters	enc_ins1_referral_start_date
_1218.encounters	enc_ins2_start_date
_1218.encounters	enc_ins3_start_date
_1218.insurances_repository	irep_ins_start_date
_1218.insurances_repository	irep_ins_referral_start_date
_1218.patients	pat_ins1_start_date
_1218.patients	pat_ins1_referral_start_date
_1218.patients	pat_ins2_start_date
_1218.patients	pat_ins3_start_date
_1218.patients_configured_encounters_schedules	pces_start_date
_1218.patients_demographics_snapshots	pds_ins1_start_date
_1218.patients_demographics_snapshots	pds_ins1_referral_start_date
_1218.patients_demographics_snapshots	pds_ins2_start_date
_1218.patients_demographics_snapshots	pds_ins3_start_date
_1218.patients_medications	pms_start_date
_1218.patients_payments_schedules	pps_start_date
_1218.precerts	pre_ins1_start_date
_1218.precerts	pre_ins1_referral_start_date
_1218.precerts	pre_ins2_start_date
_1548.charts_medications	cm_start_date
_1548.encounters	enc_ins1_start_date
_1548.encounters	enc_ins1_referral_start_date
_1548.encounters	enc_ins2_start_date
_1548.encounters	enc_ins3_start_date
_1548.insurances_repository	irep_ins_start_date
_1548.insurances_repository	irep_ins_referral_start_date
_1548.patients	pat_ins1_start_date
_1548.patients	pat_ins1_referral_start_date
_1548.patients	pat_ins2_start_date
_1548.patients	pat_ins3_start_date
_1548.patients_configured_encounters_schedules	pces_start_date
_1548.patients_demographics_snapshots	pds_ins1_start_date
_1548.patients_demographics_snapshots	pds_ins1_referral_start_date
_1548.patients_demographics_snapshots	pds_ins2_start_date
_1548.patients_demographics_snapshots	pds_ins3_start_date
_1548.patients_medications	pms_start_date
_1548.patients_payments_schedules	pps_start_date
_1548.precerts	pre_ins1_start_date
_1548.precerts	pre_ins1_referral_start_date
_1548.precerts	pre_ins2_start_date
_435.charts_medications	cm_start_date
_435.encounters	enc_ins1_start_date
_435.encounters	enc_ins1_referral_start_date
_435.encounters	enc_ins2_start_date
_435.encounters	enc_ins3_start_date
_435.insurances_repository	irep_ins_start_date
_435.insurances_repository	irep_ins_referral_start_date
_435.patients	pat_ins1_start_date
_435.patients	pat_ins1_referral_start_date
_435.patients	pat_ins2_start_date
_435.patients	pat_ins3_start_date
_435.patients_configured_encounters_schedules	pces_start_date
_435.patients_demographics_snapshots	pds_ins1_start_date
_435.patients_demographics_snapshots	pds_ins1_referral_start_date
_435.patients_demographics_snapshots	pds_ins2_start_date
_435.patients_demographics_snapshots	pds_ins3_start_date
_435.patients_medications	pms_start_date
_435.patients_payments_schedules	pps_start_date
_435.precerts	pre_ins1_start_date
_435.precerts	pre_ins1_referral_start_date
_435.precerts	pre_ins2_start_date
_436.charts_medications	cm_start_date
_436.encounters	enc_ins1_start_date
_436.encounters	enc_ins1_referral_start_date
_436.encounters	enc_ins2_start_date
_436.encounters	enc_ins3_start_date
_436.insurances_repository	irep_ins_start_date
_436.insurances_repository	irep_ins_referral_start_date
_436.patients	pat_ins1_start_date
_436.patients	pat_ins1_referral_start_date
_436.patients	pat_ins2_start_date
_436.patients	pat_ins3_start_date
_436.patients_configured_encounters_schedules	pces_start_date
_436.patients_demographics_snapshots	pds_ins1_start_date
_436.patients_demographics_snapshots	pds_ins1_referral_start_date
_436.patients_demographics_snapshots	pds_ins2_start_date
_436.patients_demographics_snapshots	pds_ins3_start_date
_436.patients_medications	pms_start_date
_436.patients_payments_schedules	pps_start_date
_436.precerts	pre_ins1_start_date
_436.precerts	pre_ins1_referral_start_date
_436.precerts	pre_ins2_start_date
_436_archive_testing.charts_medications	cm_start_date
_436_archive_testing.encounters	enc_ins1_start_date
_436_archive_testing.encounters	enc_ins1_referral_start_date
_436_archive_testing.encounters	enc_ins2_start_date
_436_archive_testing.encounters	enc_ins3_start_date
_436_archive_testing.insurances_repository	irep_ins_start_date
_436_archive_testing.insurances_repository	irep_ins_referral_start_date
_436_archive_testing.patients	pat_ins1_start_date
_436_archive_testing.patients	pat_ins1_referral_start_date
_436_archive_testing.patients	pat_ins2_start_date
_436_archive_testing.patients	pat_ins3_start_date
_436_archive_testing.patients_configured_encounters_schedules	pces_start_date
_436_archive_testing.patients_demographics_snapshots	pds_ins1_start_date
_436_archive_testing.patients_demographics_snapshots	pds_ins1_referral_start_date
_436_archive_testing.patients_demographics_snapshots	pds_ins2_start_date
_436_archive_testing.patients_demographics_snapshots	pds_ins3_start_date
_436_archive_testing.patients_medications	pms_start_date
_436_archive_testing.patients_payments_schedules	pps_start_date
_436_archive_testing.precerts	pre_ins1_start_date
_436_archive_testing.precerts	pre_ins1_referral_start_date
_436_archive_testing.precerts	pre_ins2_start_date
_437.charts_medications	cm_start_date
_437.encounters	enc_ins1_start_date
_437.encounters	enc_ins1_referral_start_date
_437.encounters	enc_ins2_start_date
_437.encounters	enc_ins3_start_date
_437.insurances_repository	irep_ins_start_date
_437.insurances_repository	irep_ins_referral_start_date
_437.patients	pat_ins1_start_date
_437.patients	pat_ins1_referral_start_date
_437.patients	pat_ins2_start_date
_437.patients	pat_ins3_start_date
_437.patients_configured_encounters_schedules	pces_start_date
_437.patients_demographics_snapshots	pds_ins1_start_date
_437.patients_demographics_snapshots	pds_ins1_referral_start_date
_437.patients_demographics_snapshots	pds_ins2_start_date
_437.patients_demographics_snapshots	pds_ins3_start_date
_437.patients_medications	pms_start_date
_437.patients_payments_schedules	pps_start_date
_437.precerts	pre_ins1_start_date
_437.precerts	pre_ins1_referral_start_date
_437.precerts	pre_ins2_start_date
_8.charts_medications	cm_start_date
_8.encounters	enc_ins1_start_date
_8.encounters	enc_ins1_referral_start_date
_8.encounters	enc_ins2_start_date
_8.encounters	enc_ins3_start_date
_8.insurances_repository	irep_ins_start_date
_8.insurances_repository	irep_ins_referral_start_date
_8.patients	pat_ins1_start_date
_8.patients	pat_ins1_referral_start_date
_8.patients	pat_ins2_start_date
_8.patients	pat_ins3_start_date
_8.patients_configured_encounters_schedules	pces_start_date
_8.patients_demographics_snapshots	pds_ins1_start_date
_8.patients_demographics_snapshots	pds_ins1_referral_start_date
_8.patients_demographics_snapshots	pds_ins2_start_date
_8.patients_demographics_snapshots	pds_ins3_start_date
_8.patients_medications	pms_start_date
_8.patients_payments_schedules	pps_start_date
_8.precerts	pre_ins1_start_date
_8.precerts	pre_ins1_referral_start_date
_8.precerts	pre_ins2_start_date
_81.charts_medications	cm_start_date
_81.encounters	enc_ins1_start_date
_81.encounters	enc_ins1_referral_start_date
_81.encounters	enc_ins2_start_date
_81.encounters	enc_ins3_start_date
_81.insurances_repository	irep_ins_start_date
_81.insurances_repository	irep_ins_referral_start_date
_81.patients	pat_ins1_start_date
_81.patients	pat_ins1_referral_start_date
_81.patients	pat_ins2_start_date
_81.patients	pat_ins3_start_date
_81.patients_configured_encounters_schedules	pces_start_date
_81.patients_demographics_snapshots	pds_ins1_start_date
_81.patients_demographics_snapshots	pds_ins1_referral_start_date
_81.patients_demographics_snapshots	pds_ins2_start_date
_81.patients_demographics_snapshots	pds_ins3_start_date
_81.patients_medications	pms_start_date
_81.patients_payments_schedules	pps_start_date
_81.precerts	pre_ins1_start_date
_81.precerts	pre_ins1_referral_start_date
_81.precerts	pre_ins2_start_date
_999.charts_medications	cm_start_date
_999.encounters	enc_ins1_start_date
_999.encounters	enc_ins1_referral_start_date
_999.encounters	enc_ins2_start_date
_999.encounters	enc_ins3_start_date
_999.insurances_repository	irep_ins_start_date
_999.insurances_repository	irep_ins_referral_start_date
_999.patients	pat_ins1_start_date
_999.patients	pat_ins1_referral_start_date
_999.patients	pat_ins2_start_date
_999.patients	pat_ins3_start_date
_999.patients_configured_encounters_schedules	pces_start_date
_999.patients_demographics_snapshots	pds_ins1_start_date
_999.patients_demographics_snapshots	pds_ins1_referral_start_date
_999.patients_demographics_snapshots	pds_ins2_start_date
_999.patients_demographics_snapshots	pds_ins3_start_date
_999.patients_medications	pms_start_date
_999.patients_payments_schedules	pps_start_date
_999.precerts	pre_ins1_start_date
_999.precerts	pre_ins1_referral_start_date
_999.precerts	pre_ins2_start_date
aurora_standard.chpinsrc	insrv_start_date
aurora_standard.chqlicnd	lic_start_date
aurora_standard.stfsyear	s_start_date
aurora_standard.stmaintd	maint_start_date
aurora_standard.styuimme	qtr_start_date
common.cqm_tracking	cqmt_reporting_start_date
common.cqm_tracking	cqmt_measurment_start_date
common.poverty_guidelines	povg_start_date

amount

Table	Column
HSPI_CURES2015_B1.invoice_generation_rule_sets	minimum_amount
HSPI_Central_Hospital.invoice_generation_rule_sets	minimum_amount
HSPI_Dewitt.invoice_generation_rule_sets	minimum_amount
HSPI_Fulton.invoice_generation_rule_sets	minimum_amount
HSPI_Inferno.invoice_generation_rule_sets	minimum_amount
HSPI_MU2015_E1.invoice_generation_rule_sets	minimum_amount
HSPI_MU2015_G2.invoice_generation_rule_sets	minimum_amount
HSPI_MU2015_G9.invoice_generation_rule_sets	minimum_amount
HSPI_Sandbox.invoice_generation_rule_sets	minimum_amount
HSPI_Summit_General.invoice_generation_rule_sets	minimum_amount
HSPI_United_Physicians.invoice_generation_rule_sets	minimum_amount
MPI.invoice_generation_rule_sets	minimum_amount
_1.billing_codes	bil_negative_amount
_1.billing_codes	bil_positive_amount
_1.encounters_payments	epay_amount
_1.encounters_ub04	enc_ub04_39_a_amount
_1.encounters_ub04	enc_ub04_39_b_amount
_1.encounters_ub04	enc_ub04_39_c_amount
_1.encounters_ub04	enc_ub04_39_d_amount
_1.encounters_ub04	enc_ub04_40_a_amount
_1.encounters_ub04	enc_ub04_40_b_amount
_1.encounters_ub04	enc_ub04_40_c_amount
_1.encounters_ub04	enc_ub04_40_d_amount
_1.encounters_ub04	enc_ub04_41_a_amount
_1.encounters_ub04	enc_ub04_41_b_amount
_1.encounters_ub04	enc_ub04_41_c_amount
_1.encounters_ub04	enc_ub04_41_d_amount
_1.insurances_allowables_cpt_map	iacm_amount
_1.insurances_contracted_pricing	icp_amount
_1.ledger	led_amount
_1.ledger	led_orig_amount
_1.ledger	led_unit_amount
_1.patient_finance_records	pfr_min_due_amount
_1.patients	pat_min_due_amount
_1.patients_immunizations	pim_administered_amount
_1.patients_immunizations_templates	pimt_administered_amount
_1.patients_inventory	pinv_administered_amount
_1.patients_payments_schedules	pps_amount
_1.patients_responsibility_estimates	prest_allowed_amount
_1.patients_responsibility_estimates_services	prests_allowed_amount
_1.pre_services_line_adjustments	prestsla_amount
_1.voided_payments	vp_amount
_1.voided_payments	vp_orig_amount
_1188.billing_codes	bil_negative_amount
_1188.billing_codes	bil_positive_amount
_1188.encounters_payments	epay_amount
_1188.encounters_ub04	enc_ub04_39_a_amount
_1188.encounters_ub04	enc_ub04_39_b_amount
_1188.encounters_ub04	enc_ub04_39_c_amount
_1188.encounters_ub04	enc_ub04_39_d_amount
_1188.encounters_ub04	enc_ub04_40_a_amount
_1188.encounters_ub04	enc_ub04_40_b_amount
_1188.encounters_ub04	enc_ub04_40_c_amount
_1188.encounters_ub04	enc_ub04_40_d_amount
_1188.encounters_ub04	enc_ub04_41_a_amount
_1188.encounters_ub04	enc_ub04_41_b_amount
_1188.encounters_ub04	enc_ub04_41_c_amount
_1188.encounters_ub04	enc_ub04_41_d_amount
_1188.insurances_allowables_cpt_map	iacm_amount
_1188.insurances_contracted_pricing	icp_amount
_1188.ledger	led_amount
_1188.ledger	led_orig_amount
_1188.ledger	led_unit_amount
_1188.patient_finance_records	pfr_min_due_amount
_1188.patients	pat_min_due_amount
_1188.patients_immunizations	pim_administered_amount
_1188.patients_immunizations_templates	pimt_administered_amount
_1188.patients_inventory	pinv_administered_amount
_1188.patients_payments_schedules	pps_amount
_1188.patients_responsibility_estimates	prest_allowed_amount
_1188.patients_responsibility_estimates_services	prests_allowed_amount
_1188.pre_services_line_adjustments	prestsla_amount
_1188.voided_payments	vp_amount
_1188.voided_payments	vp_orig_amount
_1218.billing_codes	bil_negative_amount
_1218.billing_codes	bil_positive_amount
_1218.encounters_payments	epay_amount
_1218.encounters_ub04	enc_ub04_39_a_amount
_1218.encounters_ub04	enc_ub04_39_b_amount
_1218.encounters_ub04	enc_ub04_39_c_amount
_1218.encounters_ub04	enc_ub04_39_d_amount
_1218.encounters_ub04	enc_ub04_40_a_amount
_1218.encounters_ub04	enc_ub04_40_b_amount
_1218.encounters_ub04	enc_ub04_40_c_amount
_1218.encounters_ub04	enc_ub04_40_d_amount
_1218.encounters_ub04	enc_ub04_41_a_amount
_1218.encounters_ub04	enc_ub04_41_b_amount
_1218.encounters_ub04	enc_ub04_41_c_amount
_1218.encounters_ub04	enc_ub04_41_d_amount
_1218.insurances_allowables_cpt_map	iacm_amount
_1218.insurances_contracted_pricing	icp_amount
_1218.led_temporary_ledger_table_ANM	led_amount
_1218.led_temporary_ledger_table_ANM	led_orig_amount
_1218.ledger	led_amount
_1218.ledger	led_orig_amount
_1218.ledger	led_unit_amount
_1218.patient_finance_records	pfr_min_due_amount
_1218.patients	pat_min_due_amount
_1218.patients_immunizations	pim_administered_amount
_1218.patients_immunizations_templates	pimt_administered_amount
_1218.patients_inventory	pinv_administered_amount
_1218.patients_payments_schedules	pps_amount
_1218.patients_responsibility_estimates	prest_allowed_amount
_1218.patients_responsibility_estimates_services	prests_allowed_amount
_1218.pre_services_line_adjustments	prestsla_amount
_1218.voided_payments	vp_amount
_1218.voided_payments	vp_orig_amount
_1548.billing_codes	bil_negative_amount
_1548.billing_codes	bil_positive_amount
_1548.encounters_payments	epay_amount
_1548.encounters_ub04	enc_ub04_39_a_amount
_1548.encounters_ub04	enc_ub04_39_b_amount
_1548.encounters_ub04	enc_ub04_39_c_amount
_1548.encounters_ub04	enc_ub04_39_d_amount
_1548.encounters_ub04	enc_ub04_40_a_amount
_1548.encounters_ub04	enc_ub04_40_b_amount
_1548.encounters_ub04	enc_ub04_40_c_amount
_1548.encounters_ub04	enc_ub04_40_d_amount
_1548.encounters_ub04	enc_ub04_41_a_amount
_1548.encounters_ub04	enc_ub04_41_b_amount
_1548.encounters_ub04	enc_ub04_41_c_amount
_1548.encounters_ub04	enc_ub04_41_d_amount
_1548.insurances_allowables_cpt_map	iacm_amount
_1548.insurances_contracted_pricing	icp_amount
_1548.ledger	led_amount
_1548.ledger	led_orig_amount
_1548.ledger	led_unit_amount
_1548.patient_finance_records	pfr_min_due_amount
_1548.patients	pat_min_due_amount
_1548.patients_immunizations	pim_administered_amount
_1548.patients_immunizations_templates	pimt_administered_amount
_1548.patients_inventory	pinv_administered_amount
_1548.patients_payments_schedules	pps_amount
_1548.patients_responsibility_estimates	prest_allowed_amount
_1548.patients_responsibility_estimates_services	prests_allowed_amount
_1548.pre_services_line_adjustments	prestsla_amount
_1548.voided_payments	vp_amount
_1548.voided_payments	vp_orig_amount
_435.billing_codes	bil_negative_amount
_435.billing_codes	bil_positive_amount
_435.encounters_payments	epay_amount
_435.encounters_ub04	enc_ub04_39_a_amount
_435.encounters_ub04	enc_ub04_39_b_amount
_435.encounters_ub04	enc_ub04_39_c_amount
_435.encounters_ub04	enc_ub04_39_d_amount
_435.encounters_ub04	enc_ub04_40_a_amount
_435.encounters_ub04	enc_ub04_40_b_amount
_435.encounters_ub04	enc_ub04_40_c_amount
_435.encounters_ub04	enc_ub04_40_d_amount
_435.encounters_ub04	enc_ub04_41_a_amount
_435.encounters_ub04	enc_ub04_41_b_amount
_435.encounters_ub04	enc_ub04_41_c_amount
_435.encounters_ub04	enc_ub04_41_d_amount
_435.insurances_allowables_cpt_map	iacm_amount
_435.insurances_contracted_pricing	icp_amount
_435.ledger	led_amount
_435.ledger	led_orig_amount
_435.ledger	led_unit_amount
_435.patient_finance_records	pfr_min_due_amount
_435.patients	pat_min_due_amount
_435.patients_immunizations	pim_administered_amount
_435.patients_immunizations_templates	pimt_administered_amount
_435.patients_inventory	pinv_administered_amount
_435.patients_payments_schedules	pps_amount
_435.patients_responsibility_estimates	prest_allowed_amount
_435.patients_responsibility_estimates_services	prests_allowed_amount
_435.pre_services_line_adjustments	prestsla_amount
_435.voided_payments	vp_amount
_435.voided_payments	vp_orig_amount
_436.billing_codes	bil_negative_amount
_436.billing_codes	bil_positive_amount
_436.encounters_payments	epay_amount
_436.encounters_ub04	enc_ub04_39_a_amount
_436.encounters_ub04	enc_ub04_39_b_amount
_436.encounters_ub04	enc_ub04_39_c_amount
_436.encounters_ub04	enc_ub04_39_d_amount
_436.encounters_ub04	enc_ub04_40_a_amount
_436.encounters_ub04	enc_ub04_40_b_amount
_436.encounters_ub04	enc_ub04_40_c_amount
_436.encounters_ub04	enc_ub04_40_d_amount
_436.encounters_ub04	enc_ub04_41_a_amount
_436.encounters_ub04	enc_ub04_41_b_amount
_436.encounters_ub04	enc_ub04_41_c_amount
_436.encounters_ub04	enc_ub04_41_d_amount
_436.insurances_allowables_cpt_map	iacm_amount
_436.insurances_contracted_pricing	icp_amount
_436.ledger	led_amount
_436.ledger	led_orig_amount
_436.ledger	led_unit_amount
_436.patient_finance_records	pfr_min_due_amount
_436.patients	pat_min_due_amount
_436.patients_immunizations	pim_administered_amount
_436.patients_immunizations_templates	pimt_administered_amount
_436.patients_inventory	pinv_administered_amount
_436.patients_payments_schedules	pps_amount
_436.patients_responsibility_estimates	prest_allowed_amount
_436.patients_responsibility_estimates_services	prests_allowed_amount
_436.pre_services_line_adjustments	prestsla_amount
_436.voided_payments	vp_amount
_436.voided_payments	vp_orig_amount
_436_archive_testing.billing_codes	bil_negative_amount
_436_archive_testing.billing_codes	bil_positive_amount
_436_archive_testing.encounters_payments	epay_amount
_436_archive_testing.encounters_ub04	enc_ub04_39_a_amount
_436_archive_testing.encounters_ub04	enc_ub04_39_b_amount
_436_archive_testing.encounters_ub04	enc_ub04_39_c_amount
_436_archive_testing.encounters_ub04	enc_ub04_39_d_amount
_436_archive_testing.encounters_ub04	enc_ub04_40_a_amount
_436_archive_testing.encounters_ub04	enc_ub04_40_b_amount
_436_archive_testing.encounters_ub04	enc_ub04_40_c_amount
_436_archive_testing.encounters_ub04	enc_ub04_40_d_amount
_436_archive_testing.encounters_ub04	enc_ub04_41_a_amount
_436_archive_testing.encounters_ub04	enc_ub04_41_b_amount
_436_archive_testing.encounters_ub04	enc_ub04_41_c_amount
_436_archive_testing.encounters_ub04	enc_ub04_41_d_amount
_436_archive_testing.insurances_allowables_cpt_map	iacm_amount
_436_archive_testing.insurances_contracted_pricing	icp_amount
_436_archive_testing.ledger	led_amount
_436_archive_testing.ledger	led_orig_amount
_436_archive_testing.ledger	led_unit_amount
_436_archive_testing.patient_finance_records	pfr_min_due_amount
_436_archive_testing.patients	pat_min_due_amount
_436_archive_testing.patients_immunizations	pim_administered_amount
_436_archive_testing.patients_immunizations_templates	pimt_administered_amount
_436_archive_testing.patients_inventory	pinv_administered_amount
_436_archive_testing.patients_payments_schedules	pps_amount
_436_archive_testing.patients_responsibility_estimates	prest_allowed_amount
_436_archive_testing.patients_responsibility_estimates_services	prests_allowed_amount
_436_archive_testing.pre_services_line_adjustments	prestsla_amount
_436_archive_testing.voided_payments	vp_amount
_436_archive_testing.voided_payments	vp_orig_amount
_437.billing_codes	bil_negative_amount
_437.billing_codes	bil_positive_amount
_437.encounters_payments	epay_amount
_437.encounters_ub04	enc_ub04_39_a_amount
_437.encounters_ub04	enc_ub04_39_b_amount
_437.encounters_ub04	enc_ub04_39_c_amount
_437.encounters_ub04	enc_ub04_39_d_amount
_437.encounters_ub04	enc_ub04_40_a_amount
_437.encounters_ub04	enc_ub04_40_b_amount
_437.encounters_ub04	enc_ub04_40_c_amount
_437.encounters_ub04	enc_ub04_40_d_amount
_437.encounters_ub04	enc_ub04_41_a_amount
_437.encounters_ub04	enc_ub04_41_b_amount
_437.encounters_ub04	enc_ub04_41_c_amount
_437.encounters_ub04	enc_ub04_41_d_amount
_437.insurances_allowables_cpt_map	iacm_amount
_437.insurances_contracted_pricing	icp_amount
_437.ledger	led_amount
_437.ledger	led_orig_amount
_437.ledger	led_unit_amount
_437.patient_finance_records	pfr_min_due_amount
_437.patients	pat_min_due_amount
_437.patients_immunizations	pim_administered_amount
_437.patients_immunizations_templates	pimt_administered_amount
_437.patients_inventory	pinv_administered_amount
_437.patients_payments_schedules	pps_amount
_437.patients_responsibility_estimates	prest_allowed_amount
_437.patients_responsibility_estimates_services	prests_allowed_amount
_437.pre_services_line_adjustments	prestsla_amount
_437.voided_payments	vp_amount
_437.voided_payments	vp_orig_amount
_8.billing_codes	bil_negative_amount
_8.billing_codes	bil_positive_amount
_8.daily_close_calculations	dcc_last_payment_amount
_8.daily_close_calculations	dcc_bil_negative_amount
_8.daily_close_calculations	dcc_bil_positive_amount
_8.daily_close_calculations	dcc_led_amount
_8.daily_close_calculations	dcc_led_orig_amount
_8.encounters_payments	epay_amount
_8.encounters_ub04	enc_ub04_39_a_amount
_8.encounters_ub04	enc_ub04_39_b_amount
_8.encounters_ub04	enc_ub04_39_c_amount
_8.encounters_ub04	enc_ub04_39_d_amount
_8.encounters_ub04	enc_ub04_40_a_amount
_8.encounters_ub04	enc_ub04_40_b_amount
_8.encounters_ub04	enc_ub04_40_c_amount
_8.encounters_ub04	enc_ub04_40_d_amount
_8.encounters_ub04	enc_ub04_41_a_amount
_8.encounters_ub04	enc_ub04_41_b_amount
_8.encounters_ub04	enc_ub04_41_c_amount
_8.encounters_ub04	enc_ub04_41_d_amount
_8.insurances_allowables_cpt_map	iacm_amount
_8.insurances_contracted_pricing	icp_amount
_8.ledger	led_amount
_8.ledger	led_orig_amount
_8.ledger	led_unit_amount
_8.patient_finance_records	pfr_min_due_amount
_8.patients	pat_min_due_amount
_8.patients_immunizations	pim_administered_amount
_8.patients_immunizations_templates	pimt_administered_amount
_8.patients_inventory	pinv_administered_amount
_8.patients_payments_schedules	pps_amount
_8.patients_responsibility_estimates	prest_allowed_amount
_8.patients_responsibility_estimates_services	prests_allowed_amount
_8.pre_services_line_adjustments	prestsla_amount
_8.voided_payments	vp_amount
_8.voided_payments	vp_orig_amount
_81.billing_codes	bil_negative_amount
_81.billing_codes	bil_positive_amount
_81.encounters_payments	epay_amount
_81.encounters_ub04	enc_ub04_39_a_amount
_81.encounters_ub04	enc_ub04_39_b_amount
_81.encounters_ub04	enc_ub04_39_c_amount
_81.encounters_ub04	enc_ub04_39_d_amount
_81.encounters_ub04	enc_ub04_40_a_amount
_81.encounters_ub04	enc_ub04_40_b_amount
_81.encounters_ub04	enc_ub04_40_c_amount
_81.encounters_ub04	enc_ub04_40_d_amount
_81.encounters_ub04	enc_ub04_41_a_amount
_81.encounters_ub04	enc_ub04_41_b_amount
_81.encounters_ub04	enc_ub04_41_c_amount
_81.encounters_ub04	enc_ub04_41_d_amount
_81.insurances_allowables_cpt_map	iacm_amount
_81.insurances_contracted_pricing	icp_amount
_81.ledger	led_amount
_81.ledger	led_orig_amount
_81.ledger	led_unit_amount
_81.patient_finance_records	pfr_min_due_amount
_81.patients	pat_min_due_amount
_81.patients_immunizations	pim_administered_amount
_81.patients_immunizations_templates	pimt_administered_amount
_81.patients_inventory	pinv_administered_amount
_81.patients_payments_schedules	pps_amount
_81.patients_responsibility_estimates	prest_allowed_amount
_81.patients_responsibility_estimates_services	prests_allowed_amount
_81.pre_services_line_adjustments	prestsla_amount
_81.voided_payments	vp_amount
_81.voided_payments	vp_orig_amount
_999.billing_codes	bil_negative_amount
_999.billing_codes	bil_positive_amount
_999.encounters_payments	epay_amount
_999.encounters_ub04	enc_ub04_39_a_amount
_999.encounters_ub04	enc_ub04_39_b_amount
_999.encounters_ub04	enc_ub04_39_c_amount
_999.encounters_ub04	enc_ub04_39_d_amount
_999.encounters_ub04	enc_ub04_40_a_amount
_999.encounters_ub04	enc_ub04_40_b_amount
_999.encounters_ub04	enc_ub04_40_c_amount
_999.encounters_ub04	enc_ub04_40_d_amount
_999.encounters_ub04	enc_ub04_41_a_amount
_999.encounters_ub04	enc_ub04_41_b_amount
_999.encounters_ub04	enc_ub04_41_c_amount
_999.encounters_ub04	enc_ub04_41_d_amount
_999.insurances_allowables_cpt_map	iacm_amount
_999.insurances_contracted_pricing	icp_amount
_999.ledger	led_amount
_999.ledger	led_orig_amount
_999.ledger	led_unit_amount
_999.patient_finance_records	pfr_min_due_amount
_999.patients	pat_min_due_amount
_999.patients_immunizations	pim_administered_amount
_999.patients_immunizations_templates	pimt_administered_amount
_999.patients_inventory	pinv_administered_amount
_999.patients_payments_schedules	pps_amount
_999.patients_responsibility_estimates	prest_allowed_amount
_999.patients_responsibility_estimates_services	prests_allowed_amount
_999.pre_services_line_adjustments	prestsla_amount
_999.voided_payments	vp_amount
_999.voided_payments	vp_orig_amount
aurora_standard.amcbd	wo_amount
aurora_standard.chmnbcgr	tot_amount
aurora_standard.chmnbpyr	tot_amount
aurora_standard.chmtbtrr	tot_amount
aurora_standard.chpempir	life_amount
aurora_standard.chrdrugc	purch_amount
aurora_standard.chtwkhrd	carry_amount
aurora_standard.mktcus	proposal_amount
aurora_standard.oddpayre	cash_amount
aurora_standard.odhpayre	cash_amount
aurora_standard.stfactvd	depr_amount
aurora_standard.stfactvv	depr_amount
aurora_standard.stoinvce	item_amount
aurora_standard.stoinvce	trd_ds_amount
aurora_standard.stoinvce	st_tx_amount
aurora_standard.stoinvce	co_tx_amount
aurora_standard.stoinvce	ci_tx_amount
aurora_standard.stoinvce	frght_amount
aurora_standard.stoinvce	total_amount
aurora_standard.stoinvce	tax_amount
aurora_standard.stoordrd	tax_amount
aurora_standard.stoordrd	net_amount
aurora_standard.stoordre	item_amount
aurora_standard.stoordre	trd_ds_amount
aurora_standard.stoordre	tax_amount
aurora_standard.stoordre	frght_amount
aurora_standard.stoordre	total_amount
aurora_standard.stoshipd	tax_amount
aurora_standard.stoshipd	net_amount
aurora_standard.stpactvd	home_curr_amount
aurora_standard.stpinvce	disc_amount
aurora_standard.stpinvce	ap_amount
aurora_standard.stpinvce	home_curr_amount
aurora_standard.stpopend	orig_amount
aurora_standard.stpopend	home_curr_amount
aurora_standard.stractvd	home_curr_amount
aurora_standard.strcustr	stmt_amount
aurora_standard.strinvce	disc_amount
aurora_standard.strinvce	tax_amount
aurora_standard.strinvce	frght_amount
aurora_standard.strinvce	misc_amount
aurora_standard.strinvce	ar_amount
aurora_standard.strinvce	home_curr_amount
aurora_standard.strnoted	orig_amount
aurora_standard.stropend	orig_amount
aurora_standard.stropend	home_curr_amount
aurora_standard.stuinvce	misc_amount
aurora_standard.stuinvce	frght_amount
aurora_standard.stuordre	item_amount
aurora_standard.stuordre	trd_ds_amount
aurora_standard.stuordre	tax_amount
aurora_standard.stuordre	frght_amount
aurora_standard.stuordre	misc_amount
aurora_standard.stuordre	goods_amount
aurora_standard.stuordre	total_amount
aurora_standard.stuordre	prepay_amount
aurora_standard.styinccr	ot_shift_amount
aurora_standard.stypayre	cash_amount
aurora_standard.styrevsd	cash_amount
aurora_standard.tmp04d	chg_amount
aurora_standard.tmp15chd	chg_amount
common.billing_codes	bil_negative_amount
common.billing_codes	bil_positive_amount
common.rcm_stats_aging	rcmsa_0_30_amount
common.rcm_stats_aging	rcmsa_31_60_amount
common.rcm_stats_aging	rcmsa_61_90_amount
common.rcm_stats_aging	rcmsa_91_120_amount
common.rcm_stats_aging	rcmsa_121_amount
common.rcm_stats_aging	rcmsa_total_amount
template_library.patients_immunizations_templates	pimt_administered_amount

signed_by

Table	Column
_1.documents_signed	dsig_signed_by
_1.encounters_signed	esig_signed_by
_1.encounters_soap	esp_signed_by
_1.encounters_soap	esp_reviewer_signed_by
_1.lab_results_signed	lrsig_signed_by
_1.radiology_results_signed	rrsig_signed_by
_1.signatures	sig_signed_by
_1188.documents_signed	dsig_signed_by
_1188.encounters_signed	esig_signed_by
_1188.encounters_soap	esp_signed_by
_1188.encounters_soap	esp_reviewer_signed_by
_1188.lab_results_signed	lrsig_signed_by
_1188.radiology_results_signed	rrsig_signed_by
_1188.signatures	sig_signed_by
_1218.documents_signed	dsig_signed_by
_1218.encounters_signed	esig_signed_by
_1218.encounters_soap	esp_signed_by
_1218.encounters_soap	esp_reviewer_signed_by
_1218.lab_results_signed	lrsig_signed_by
_1218.radiology_results_signed	rrsig_signed_by
_1218.signatures	sig_signed_by
_1548.documents_signed	dsig_signed_by
_1548.encounters_signed	esig_signed_by
_1548.encounters_soap	esp_signed_by
_1548.encounters_soap	esp_reviewer_signed_by
_1548.lab_results_signed	lrsig_signed_by
_1548.radiology_results_signed	rrsig_signed_by
_1548.signatures	sig_signed_by
_435.documents_signed	dsig_signed_by
_435.encounters_signed	esig_signed_by
_435.encounters_soap	esp_signed_by
_435.encounters_soap	esp_reviewer_signed_by
_435.lab_results_signed	lrsig_signed_by
_435.radiology_results_signed	rrsig_signed_by
_435.signatures	sig_signed_by
_436.documents_signed	dsig_signed_by
_436.encounters_signed	esig_signed_by
_436.encounters_soap	esp_signed_by
_436.encounters_soap	esp_reviewer_signed_by
_436.lab_results_signed	lrsig_signed_by
_436.radiology_results_signed	rrsig_signed_by
_436.signatures	sig_signed_by
_436_archive_testing.documents_signed	dsig_signed_by
_436_archive_testing.encounters_signed	esig_signed_by
_436_archive_testing.encounters_soap	esp_signed_by
_436_archive_testing.encounters_soap	esp_reviewer_signed_by
_436_archive_testing.lab_results_signed	lrsig_signed_by
_436_archive_testing.radiology_results_signed	rrsig_signed_by
_436_archive_testing.signatures	sig_signed_by
_437.documents_signed	dsig_signed_by
_437.encounters_signed	esig_signed_by
_437.encounters_soap	esp_signed_by
_437.encounters_soap	esp_reviewer_signed_by
_437.lab_results_signed	lrsig_signed_by
_437.radiology_results_signed	rrsig_signed_by
_437.signatures	sig_signed_by
_8.documents_signed	dsig_signed_by
_8.encounters_signed	esig_signed_by
_8.encounters_soap	esp_signed_by
_8.encounters_soap	esp_reviewer_signed_by
_8.lab_results_signed	lrsig_signed_by
_8.radiology_results_signed	rrsig_signed_by
_8.signatures	sig_signed_by
_81.documents_signed	dsig_signed_by
_81.encounters_signed	esig_signed_by
_81.encounters_soap	esp_signed_by
_81.encounters_soap	esp_reviewer_signed_by
_81.lab_results_signed	lrsig_signed_by
_81.radiology_results_signed	rrsig_signed_by
_81.signatures	sig_signed_by
_999.documents_signed	dsig_signed_by
_999.encounters_signed	esig_signed_by
_999.encounters_soap	esp_signed_by
_999.encounters_soap	esp_reviewer_signed_by
_999.lab_results_signed	lrsig_signed_by
_999.radiology_results_signed	rrsig_signed_by
_999.signatures	sig_signed_by

comment

Table	Column
_1.orders_comments	orc_comment
_1.orders_comments_templates	orct_comment
_1.precerts_comments	prc_comment
_1.radiology_order_notes	radnot_comment
_1188.orders_comments	orc_comment
_1188.orders_comments_templates	orct_comment
_1188.precerts_comments	prc_comment
_1188.radiology_order_notes	radnot_comment
_1218.orders_comments	orc_comment
_1218.orders_comments_templates	orct_comment
_1218.precerts_comments	prc_comment
_1218.radiology_order_notes	radnot_comment
_1548.orders_comments	orc_comment
_1548.orders_comments_templates	orct_comment
_1548.precerts_comments	prc_comment
_1548.radiology_order_notes	radnot_comment
_435.orders_comments	orc_comment
_435.orders_comments_templates	orct_comment
_435.precerts_comments	prc_comment
_435.radiology_order_notes	radnot_comment
_436.orders_comments	orc_comment
_436.orders_comments_templates	orct_comment
_436.precerts_comments	prc_comment
_436.radiology_order_notes	radnot_comment
_436_archive_testing.orders_comments	orc_comment
_436_archive_testing.orders_comments_templates	orct_comment
_436_archive_testing.precerts_comments	prc_comment
_436_archive_testing.radiology_order_notes	radnot_comment
_437.orders_comments	orc_comment
_437.orders_comments_templates	orct_comment
_437.precerts_comments	prc_comment
_437.radiology_order_notes	radnot_comment
_8.orders_comments	orc_comment
_8.orders_comments_templates	orct_comment
_8.precerts_comments	prc_comment
_8.radiology_order_notes	radnot_comment
_81.orders_comments	orc_comment
_81.orders_comments_templates	orct_comment
_81.precerts_comments	prc_comment
_81.radiology_order_notes	radnot_comment
_999.orders_comments	orc_comment
_999.orders_comments_templates	orct_comment
_999.precerts_comments	prc_comment
_999.radiology_order_notes	radnot_comment
ahiWiki.archive	ar_comment
ahiWiki.logging	log_comment
ahiWiki.recentchanges	rc_comment
ahiWiki.revision	rev_comment
aurora_standard.audppayd	denial_comment
aurora_standard.chmabstr	status_comment
aurora_standard.chmblogd	denial_comment
aurora_standard.chmbremd	denial_comment
aurora_standard.chmmcqud	emp_comment
aurora_standard.chmmcqud	sp_emp_comment
aurora_standard.chmozpcd	acct_comment
aurora_standard.chmppayd	denial_comment
aurora_standard.chpevald	reviewer_comment
aurora_standard.hl7nte	src_comment
aurora_standard.hl7ntead	src_comment
common.service_tickets_comments	stcp_comment
template_library.orders_comments_templates	orct_comment

guar_no

Table	Column
aurora_standard.anmpi	new_guar_no
aurora_standard.apsmpi	new_guar_no
aurora_standard.bs2mpi	new_guar_no
aurora_standard.bsmpi	new_guar_no

letter_date

Table	Column
common.clients_contract_data	ccd_finance_churn_letter_date

date_closed

Table	Column
common.dev_requests	dev_date_closed