aurora_standard.chmozpcd

Field	Type	Null	Key	Extra
ref_no	varchar(16)	YES
debtor_type	varchar(1)	YES
debt_type	varchar(3)	YES
debtor_name_1	varchar(30)	YES
debtor_name_2	varchar(30)	YES
debtor_1_ecoa	varchar(1)	YES
debtor_2_ecoa	varchar(1)	YES
debtor_1_ssn	varchar(11)	YES
debtor_2_ssn	varchar(11)	YES
debtor_addr	varchar(30)	YES
debtor_city	varchar(20)	YES
debtor_state	varchar(2)	YES
debtor_zip	varchar(10)	YES
orig_client	varchar(24)	YES
principal	varchar(9)	YES
interest	varchar(9)	YES
int_calc_date	varchar(8)	YES
date_ser	varchar(8)	YES
debtor_phone	varchar(10)	YES
debtor_wphone	varchar(10)	YES
guar_dob	varchar(8)	YES
pat_dob	varchar(8)	YES
driver_license1	varchar(15)	YES
driver_license2	varchar(15)	YES
language	varchar(3)	YES
p_dialer	varchar(1)	YES
debt_desc	varchar(40)	YES
acct_comment	varchar(40)	YES
empl_name	varchar(30)	YES
empl_addr	varchar(30)	YES
empl_c_s_z	varchar(30)	YES
empl_details	varchar(20)	YES
bank_transit_no	varchar(9)	YES
bank_name	varchar(30)	YES
bank_acct	varchar(20)	YES
bank_addr	varchar(30)	YES
bank_city_st_zp	varchar(30)	YES
bank_phone	varchar(10)	YES
hist_date1	varchar(8)	YES
hist_cmnt1	varchar(50)	YES
hist_date2	varchar(8)	YES
hist_cmnt2	varchar(50)	YES
hist_date3	varchar(8)	YES
hist_cmnt3	varchar(50)	YES
hist_date4	varchar(8)	YES
hist_cmnt4	varchar(50)	YES
hist_date5	varchar(8)	YES
hist_cmnt5	varchar(50)	YES
filler1	varchar(94)	YES
version	varchar(1)	YES
end	varchar(2)	YES
chs_rowID	bigint(20) unsigned	NO	PRI	auto_increment

References

Local Column

References

version

Table	Column
AzaleaStats.login_events	loge_browser_version
AzaleaStats.pull_requests_environments	pullenv_release_version
HSPI_CURES2015_B1.allergies	code_version
HSPI_CURES2015_B1.allergies	status_version
HSPI_CURES2015_B1.allergies	reaction_version
HSPI_CURES2015_B1.allergies	severity_version
HSPI_CURES2015_B1.allergies	type_version
HSPI_CURES2015_B1.charge_master_codes	ndcQuantity_version
HSPI_CURES2015_B1.claim_items	quantity_version
HSPI_CURES2015_B1.claim_supporting_info	valueQuantity_version
HSPI_CURES2015_B1.conditions	onsetAge_version
HSPI_CURES2015_B1.contacts	role_version
HSPI_CURES2015_B1.contacts	gender_version
HSPI_CURES2015_B1.coverages	type_version
HSPI_CURES2015_B1.coverages	relationship_version
HSPI_CURES2015_B1.examples	exampleQuantity_version
HSPI_CURES2015_B1.guarantors	relationship_version
HSPI_CURES2015_B1.immunizations	quantity_version
HSPI_CURES2015_B1.medication_requests	dosage_route_version
HSPI_CURES2015_B1.medication_requests	dosage_quantity_version
HSPI_CURES2015_B1.medication_requests	dispense_quantity_version
HSPI_CURES2015_B1.medication_requests	dispense_duration_version
HSPI_CURES2015_B1.medications	route_version
HSPI_CURES2015_B1.medications	quantity_version
HSPI_CURES2015_B1.medications	stopReason_version
HSPI_CURES2015_B1.observations	type_version
HSPI_CURES2015_B1.observations	code_version
HSPI_CURES2015_B1.observations	quantity_version
HSPI_CURES2015_B1.observations	interpretation_version
HSPI_CURES2015_B1.observations	range_low_version
HSPI_CURES2015_B1.observations	range_high_version
HSPI_CURES2015_B1.observations_components	type_version
HSPI_CURES2015_B1.observations_components	code_version
HSPI_CURES2015_B1.observations_components	quantity_version
HSPI_CURES2015_B1.observations_components	interpretation_version
HSPI_CURES2015_B1.observations_components	range_low_version
HSPI_CURES2015_B1.observations_components	range_high_version
HSPI_CURES2015_B1.participants	type_version
HSPI_CURES2015_B1.patient_abstracts	gender_version
HSPI_CURES2015_B1.patient_abstracts	marital_status_version
HSPI_CURES2015_B1.patients	gender_version
HSPI_CURES2015_B1.patients	marital_status_version
HSPI_CURES2015_B1.patients_ethnicities	ethnicity_version
HSPI_CURES2015_B1.patients_races	race_version
HSPI_CURES2015_B1.problems	type_version
HSPI_CURES2015_B1.problems	diagnosis_version
HSPI_CURES2015_B1.problems	status_version
HSPI_CURES2015_B1.problems	severity_version
HSPI_CURES2015_B1.specimens	quantity_version
HSPI_Central_Hospital.allergies	code_version
HSPI_Central_Hospital.allergies	status_version
HSPI_Central_Hospital.allergies	reaction_version
HSPI_Central_Hospital.allergies	severity_version
HSPI_Central_Hospital.allergies	type_version
HSPI_Central_Hospital.charge_master_codes	ndcQuantity_version
HSPI_Central_Hospital.claim_items	quantity_version
HSPI_Central_Hospital.claim_supporting_info	valueQuantity_version
HSPI_Central_Hospital.conditions	onsetAge_version
HSPI_Central_Hospital.contacts	role_version
HSPI_Central_Hospital.contacts	gender_version
HSPI_Central_Hospital.coverages	type_version
HSPI_Central_Hospital.coverages	relationship_version
HSPI_Central_Hospital.examples	exampleQuantity_version
HSPI_Central_Hospital.guarantors	relationship_version
HSPI_Central_Hospital.immunizations	quantity_version
HSPI_Central_Hospital.medication_requests	dosage_route_version
HSPI_Central_Hospital.medication_requests	dosage_quantity_version
HSPI_Central_Hospital.medication_requests	dispense_quantity_version
HSPI_Central_Hospital.medication_requests	dispense_duration_version
HSPI_Central_Hospital.medications	route_version
HSPI_Central_Hospital.medications	quantity_version
HSPI_Central_Hospital.medications	stopReason_version
HSPI_Central_Hospital.observations	type_version
HSPI_Central_Hospital.observations	code_version
HSPI_Central_Hospital.observations	quantity_version
HSPI_Central_Hospital.observations	interpretation_version
HSPI_Central_Hospital.observations	range_low_version
HSPI_Central_Hospital.observations	range_high_version
HSPI_Central_Hospital.observations_components	type_version
HSPI_Central_Hospital.observations_components	code_version
HSPI_Central_Hospital.observations_components	quantity_version
HSPI_Central_Hospital.observations_components	interpretation_version
HSPI_Central_Hospital.observations_components	range_low_version
HSPI_Central_Hospital.observations_components	range_high_version
HSPI_Central_Hospital.participants	type_version
HSPI_Central_Hospital.patient_abstracts	gender_version
HSPI_Central_Hospital.patient_abstracts	marital_status_version
HSPI_Central_Hospital.patients	gender_version
HSPI_Central_Hospital.patients	marital_status_version
HSPI_Central_Hospital.patients_ethnicities	ethnicity_version
HSPI_Central_Hospital.patients_races	race_version
HSPI_Central_Hospital.problems	type_version
HSPI_Central_Hospital.problems	diagnosis_version
HSPI_Central_Hospital.problems	status_version
HSPI_Central_Hospital.problems	severity_version
HSPI_Central_Hospital.specimens	quantity_version
HSPI_Dewitt.allergies	code_version
HSPI_Dewitt.allergies	status_version
HSPI_Dewitt.allergies	reaction_version
HSPI_Dewitt.allergies	severity_version
HSPI_Dewitt.allergies	type_version
HSPI_Dewitt.charge_master_codes	ndcQuantity_version
HSPI_Dewitt.claim_items	quantity_version
HSPI_Dewitt.claim_supporting_info	valueQuantity_version
HSPI_Dewitt.conditions	onsetAge_version
HSPI_Dewitt.contacts	role_version
HSPI_Dewitt.contacts	gender_version
HSPI_Dewitt.coverages	type_version
HSPI_Dewitt.coverages	relationship_version
HSPI_Dewitt.examples	exampleQuantity_version
HSPI_Dewitt.guarantors	relationship_version
HSPI_Dewitt.immunizations	quantity_version
HSPI_Dewitt.medication_requests	dosage_route_version
HSPI_Dewitt.medication_requests	dosage_quantity_version
HSPI_Dewitt.medication_requests	dispense_quantity_version
HSPI_Dewitt.medication_requests	dispense_duration_version
HSPI_Dewitt.medications	route_version
HSPI_Dewitt.medications	quantity_version
HSPI_Dewitt.medications	stopReason_version
HSPI_Dewitt.observations	type_version
HSPI_Dewitt.observations	code_version
HSPI_Dewitt.observations	quantity_version
HSPI_Dewitt.observations	interpretation_version
HSPI_Dewitt.observations	range_low_version
HSPI_Dewitt.observations	range_high_version
HSPI_Dewitt.observations_components	type_version
HSPI_Dewitt.observations_components	code_version
HSPI_Dewitt.observations_components	quantity_version
HSPI_Dewitt.observations_components	interpretation_version
HSPI_Dewitt.observations_components	range_low_version
HSPI_Dewitt.observations_components	range_high_version
HSPI_Dewitt.participants	type_version
HSPI_Dewitt.patient_abstracts	gender_version
HSPI_Dewitt.patient_abstracts	marital_status_version
HSPI_Dewitt.patients	gender_version
HSPI_Dewitt.patients	marital_status_version
HSPI_Dewitt.patients_ethnicities	ethnicity_version
HSPI_Dewitt.patients_races	race_version
HSPI_Dewitt.problems	type_version
HSPI_Dewitt.problems	diagnosis_version
HSPI_Dewitt.problems	status_version
HSPI_Dewitt.problems	severity_version
HSPI_Dewitt.specimens	quantity_version
HSPI_Fulton.allergies	code_version
HSPI_Fulton.allergies	status_version
HSPI_Fulton.allergies	reaction_version
HSPI_Fulton.allergies	severity_version
HSPI_Fulton.allergies	type_version
HSPI_Fulton.charge_master_codes	ndcQuantity_version
HSPI_Fulton.claim_items	quantity_version
HSPI_Fulton.claim_supporting_info	valueQuantity_version
HSPI_Fulton.conditions	onsetAge_version
HSPI_Fulton.contacts	role_version
HSPI_Fulton.contacts	gender_version
HSPI_Fulton.coverages	type_version
HSPI_Fulton.coverages	relationship_version
HSPI_Fulton.examples	exampleQuantity_version
HSPI_Fulton.guarantors	relationship_version
HSPI_Fulton.immunizations	quantity_version
HSPI_Fulton.medication_requests	dosage_route_version
HSPI_Fulton.medication_requests	dosage_quantity_version
HSPI_Fulton.medication_requests	dispense_quantity_version
HSPI_Fulton.medication_requests	dispense_duration_version
HSPI_Fulton.medications	route_version
HSPI_Fulton.medications	quantity_version
HSPI_Fulton.medications	stopReason_version
HSPI_Fulton.observations	type_version
HSPI_Fulton.observations	code_version
HSPI_Fulton.observations	quantity_version
HSPI_Fulton.observations	interpretation_version
HSPI_Fulton.observations	range_low_version
HSPI_Fulton.observations	range_high_version
HSPI_Fulton.observations_components	type_version
HSPI_Fulton.observations_components	code_version
HSPI_Fulton.observations_components	quantity_version
HSPI_Fulton.observations_components	interpretation_version
HSPI_Fulton.observations_components	range_low_version
HSPI_Fulton.observations_components	range_high_version
HSPI_Fulton.participants	type_version
HSPI_Fulton.patient_abstracts	gender_version
HSPI_Fulton.patient_abstracts	marital_status_version
HSPI_Fulton.patients	gender_version
HSPI_Fulton.patients	marital_status_version
HSPI_Fulton.patients_ethnicities	ethnicity_version
HSPI_Fulton.patients_races	race_version
HSPI_Fulton.problems	type_version
HSPI_Fulton.problems	diagnosis_version
HSPI_Fulton.problems	status_version
HSPI_Fulton.problems	severity_version
HSPI_Fulton.specimens	quantity_version
HSPI_Inferno.allergies	code_version
HSPI_Inferno.allergies	status_version
HSPI_Inferno.allergies	reaction_version
HSPI_Inferno.allergies	severity_version
HSPI_Inferno.allergies	type_version
HSPI_Inferno.charge_master_codes	ndcQuantity_version
HSPI_Inferno.claim_items	quantity_version
HSPI_Inferno.claim_supporting_info	valueQuantity_version
HSPI_Inferno.conditions	onsetAge_version
HSPI_Inferno.contacts	role_version
HSPI_Inferno.contacts	gender_version
HSPI_Inferno.coverages	type_version
HSPI_Inferno.coverages	relationship_version
HSPI_Inferno.examples	exampleQuantity_version
HSPI_Inferno.guarantors	relationship_version
HSPI_Inferno.immunizations	quantity_version
HSPI_Inferno.medication_requests	dosage_route_version
HSPI_Inferno.medication_requests	dosage_quantity_version
HSPI_Inferno.medication_requests	dispense_quantity_version
HSPI_Inferno.medication_requests	dispense_duration_version
HSPI_Inferno.medications	route_version
HSPI_Inferno.medications	quantity_version
HSPI_Inferno.medications	stopReason_version
HSPI_Inferno.observations	type_version
HSPI_Inferno.observations	code_version
HSPI_Inferno.observations	quantity_version
HSPI_Inferno.observations	interpretation_version
HSPI_Inferno.observations	range_low_version
HSPI_Inferno.observations	range_high_version
HSPI_Inferno.observations_components	type_version
HSPI_Inferno.observations_components	code_version
HSPI_Inferno.observations_components	quantity_version
HSPI_Inferno.observations_components	interpretation_version
HSPI_Inferno.observations_components	range_low_version
HSPI_Inferno.observations_components	range_high_version
HSPI_Inferno.participants	type_version
HSPI_Inferno.patient_abstracts	gender_version
HSPI_Inferno.patient_abstracts	marital_status_version
HSPI_Inferno.patients	gender_version
HSPI_Inferno.patients	marital_status_version
HSPI_Inferno.patients_ethnicities	ethnicity_version
HSPI_Inferno.patients_races	race_version
HSPI_Inferno.problems	type_version
HSPI_Inferno.problems	diagnosis_version
HSPI_Inferno.problems	status_version
HSPI_Inferno.problems	severity_version
HSPI_Inferno.specimens	quantity_version
HSPI_MU2015_E1.allergies	code_version
HSPI_MU2015_E1.allergies	status_version
HSPI_MU2015_E1.allergies	reaction_version
HSPI_MU2015_E1.allergies	severity_version
HSPI_MU2015_E1.allergies	type_version
HSPI_MU2015_E1.charge_master_codes	ndcQuantity_version
HSPI_MU2015_E1.claim_items	quantity_version
HSPI_MU2015_E1.claim_supporting_info	valueQuantity_version
HSPI_MU2015_E1.conditions	onsetAge_version
HSPI_MU2015_E1.contacts	role_version
HSPI_MU2015_E1.contacts	gender_version
HSPI_MU2015_E1.coverages	type_version
HSPI_MU2015_E1.coverages	relationship_version
HSPI_MU2015_E1.examples	exampleQuantity_version
HSPI_MU2015_E1.guarantors	relationship_version
HSPI_MU2015_E1.immunizations	quantity_version
HSPI_MU2015_E1.medication_requests	dosage_route_version
HSPI_MU2015_E1.medication_requests	dosage_quantity_version
HSPI_MU2015_E1.medication_requests	dispense_quantity_version
HSPI_MU2015_E1.medication_requests	dispense_duration_version
HSPI_MU2015_E1.medications	route_version
HSPI_MU2015_E1.medications	quantity_version
HSPI_MU2015_E1.medications	stopReason_version
HSPI_MU2015_E1.observations	type_version
HSPI_MU2015_E1.observations	code_version
HSPI_MU2015_E1.observations	quantity_version
HSPI_MU2015_E1.observations	interpretation_version
HSPI_MU2015_E1.observations	range_low_version
HSPI_MU2015_E1.observations	range_high_version
HSPI_MU2015_E1.observations_components	type_version
HSPI_MU2015_E1.observations_components	code_version
HSPI_MU2015_E1.observations_components	quantity_version
HSPI_MU2015_E1.observations_components	interpretation_version
HSPI_MU2015_E1.observations_components	range_low_version
HSPI_MU2015_E1.observations_components	range_high_version
HSPI_MU2015_E1.participants	type_version
HSPI_MU2015_E1.patient_abstracts	gender_version
HSPI_MU2015_E1.patient_abstracts	marital_status_version
HSPI_MU2015_E1.patients	gender_version
HSPI_MU2015_E1.patients	marital_status_version
HSPI_MU2015_E1.patients_ethnicities	ethnicity_version
HSPI_MU2015_E1.patients_races	race_version
HSPI_MU2015_E1.problems	type_version
HSPI_MU2015_E1.problems	diagnosis_version
HSPI_MU2015_E1.problems	status_version
HSPI_MU2015_E1.problems	severity_version
HSPI_MU2015_E1.specimens	quantity_version
HSPI_MU2015_G2.allergies	code_version
HSPI_MU2015_G2.allergies	status_version
HSPI_MU2015_G2.allergies	reaction_version
HSPI_MU2015_G2.allergies	severity_version
HSPI_MU2015_G2.allergies	type_version
HSPI_MU2015_G2.charge_master_codes	ndcQuantity_version
HSPI_MU2015_G2.claim_items	quantity_version
HSPI_MU2015_G2.claim_supporting_info	valueQuantity_version
HSPI_MU2015_G2.conditions	onsetAge_version
HSPI_MU2015_G2.contacts	role_version
HSPI_MU2015_G2.contacts	gender_version
HSPI_MU2015_G2.coverages	type_version
HSPI_MU2015_G2.coverages	relationship_version
HSPI_MU2015_G2.examples	exampleQuantity_version
HSPI_MU2015_G2.guarantors	relationship_version
HSPI_MU2015_G2.immunizations	quantity_version
HSPI_MU2015_G2.medication_requests	dosage_route_version
HSPI_MU2015_G2.medication_requests	dosage_quantity_version
HSPI_MU2015_G2.medication_requests	dispense_quantity_version
HSPI_MU2015_G2.medication_requests	dispense_duration_version
HSPI_MU2015_G2.medications	route_version
HSPI_MU2015_G2.medications	quantity_version
HSPI_MU2015_G2.medications	stopReason_version
HSPI_MU2015_G2.observations	type_version
HSPI_MU2015_G2.observations	code_version
HSPI_MU2015_G2.observations	quantity_version
HSPI_MU2015_G2.observations	interpretation_version
HSPI_MU2015_G2.observations	range_low_version
HSPI_MU2015_G2.observations	range_high_version
HSPI_MU2015_G2.observations_components	type_version
HSPI_MU2015_G2.observations_components	code_version
HSPI_MU2015_G2.observations_components	quantity_version
HSPI_MU2015_G2.observations_components	interpretation_version
HSPI_MU2015_G2.observations_components	range_low_version
HSPI_MU2015_G2.observations_components	range_high_version
HSPI_MU2015_G2.participants	type_version
HSPI_MU2015_G2.patient_abstracts	gender_version
HSPI_MU2015_G2.patient_abstracts	marital_status_version
HSPI_MU2015_G2.patients	gender_version
HSPI_MU2015_G2.patients	marital_status_version
HSPI_MU2015_G2.patients_ethnicities	ethnicity_version
HSPI_MU2015_G2.patients_races	race_version
HSPI_MU2015_G2.problems	type_version
HSPI_MU2015_G2.problems	diagnosis_version
HSPI_MU2015_G2.problems	status_version
HSPI_MU2015_G2.problems	severity_version
HSPI_MU2015_G2.specimens	quantity_version
HSPI_MU2015_G9.allergies	code_version
HSPI_MU2015_G9.allergies	status_version
HSPI_MU2015_G9.allergies	reaction_version
HSPI_MU2015_G9.allergies	severity_version
HSPI_MU2015_G9.allergies	type_version
HSPI_MU2015_G9.charge_master_codes	ndcQuantity_version
HSPI_MU2015_G9.claim_items	quantity_version
HSPI_MU2015_G9.claim_supporting_info	valueQuantity_version
HSPI_MU2015_G9.conditions	onsetAge_version
HSPI_MU2015_G9.contacts	role_version
HSPI_MU2015_G9.contacts	gender_version
HSPI_MU2015_G9.coverages	type_version
HSPI_MU2015_G9.coverages	relationship_version
HSPI_MU2015_G9.examples	exampleQuantity_version
HSPI_MU2015_G9.guarantors	relationship_version
HSPI_MU2015_G9.immunizations	quantity_version
HSPI_MU2015_G9.medication_requests	dosage_route_version
HSPI_MU2015_G9.medication_requests	dosage_quantity_version
HSPI_MU2015_G9.medication_requests	dispense_quantity_version
HSPI_MU2015_G9.medication_requests	dispense_duration_version
HSPI_MU2015_G9.medications	route_version
HSPI_MU2015_G9.medications	quantity_version
HSPI_MU2015_G9.medications	stopReason_version
HSPI_MU2015_G9.observations	type_version
HSPI_MU2015_G9.observations	code_version
HSPI_MU2015_G9.observations	quantity_version
HSPI_MU2015_G9.observations	interpretation_version
HSPI_MU2015_G9.observations	range_low_version
HSPI_MU2015_G9.observations	range_high_version
HSPI_MU2015_G9.observations_components	type_version
HSPI_MU2015_G9.observations_components	code_version
HSPI_MU2015_G9.observations_components	quantity_version
HSPI_MU2015_G9.observations_components	interpretation_version
HSPI_MU2015_G9.observations_components	range_low_version
HSPI_MU2015_G9.observations_components	range_high_version
HSPI_MU2015_G9.participants	type_version
HSPI_MU2015_G9.patient_abstracts	gender_version
HSPI_MU2015_G9.patient_abstracts	marital_status_version
HSPI_MU2015_G9.patients	gender_version
HSPI_MU2015_G9.patients	marital_status_version
HSPI_MU2015_G9.patients_ethnicities	ethnicity_version
HSPI_MU2015_G9.patients_races	race_version
HSPI_MU2015_G9.problems	type_version
HSPI_MU2015_G9.problems	diagnosis_version
HSPI_MU2015_G9.problems	status_version
HSPI_MU2015_G9.problems	severity_version
HSPI_MU2015_G9.specimens	quantity_version
HSPI_Sandbox.allergies	code_version
HSPI_Sandbox.allergies	status_version
HSPI_Sandbox.allergies	reaction_version
HSPI_Sandbox.allergies	severity_version
HSPI_Sandbox.allergies	type_version
HSPI_Sandbox.charge_master_codes	ndcQuantity_version
HSPI_Sandbox.claim_items	quantity_version
HSPI_Sandbox.claim_supporting_info	valueQuantity_version
HSPI_Sandbox.conditions	onsetAge_version
HSPI_Sandbox.contacts	role_version
HSPI_Sandbox.contacts	gender_version
HSPI_Sandbox.coverages	type_version
HSPI_Sandbox.coverages	relationship_version
HSPI_Sandbox.examples	exampleQuantity_version
HSPI_Sandbox.guarantors	relationship_version
HSPI_Sandbox.immunizations	quantity_version
HSPI_Sandbox.medication_requests	dosage_route_version
HSPI_Sandbox.medication_requests	dosage_quantity_version
HSPI_Sandbox.medication_requests	dispense_quantity_version
HSPI_Sandbox.medication_requests	dispense_duration_version
HSPI_Sandbox.medications	route_version
HSPI_Sandbox.medications	quantity_version
HSPI_Sandbox.medications	stopReason_version
HSPI_Sandbox.observations	type_version
HSPI_Sandbox.observations	code_version
HSPI_Sandbox.observations	quantity_version
HSPI_Sandbox.observations	interpretation_version
HSPI_Sandbox.observations	range_low_version
HSPI_Sandbox.observations	range_high_version
HSPI_Sandbox.observations_components	type_version
HSPI_Sandbox.observations_components	code_version
HSPI_Sandbox.observations_components	quantity_version
HSPI_Sandbox.observations_components	interpretation_version
HSPI_Sandbox.observations_components	range_low_version
HSPI_Sandbox.observations_components	range_high_version
HSPI_Sandbox.participants	type_version
HSPI_Sandbox.patient_abstracts	gender_version
HSPI_Sandbox.patient_abstracts	marital_status_version
HSPI_Sandbox.patients	gender_version
HSPI_Sandbox.patients	marital_status_version
HSPI_Sandbox.patients_ethnicities	ethnicity_version
HSPI_Sandbox.patients_races	race_version
HSPI_Sandbox.problems	type_version
HSPI_Sandbox.problems	diagnosis_version
HSPI_Sandbox.problems	status_version
HSPI_Sandbox.problems	severity_version
HSPI_Sandbox.specimens	quantity_version
HSPI_Summit_General.allergies	code_version
HSPI_Summit_General.allergies	status_version
HSPI_Summit_General.allergies	reaction_version
HSPI_Summit_General.allergies	severity_version
HSPI_Summit_General.allergies	type_version
HSPI_Summit_General.charge_master_codes	ndcQuantity_version
HSPI_Summit_General.claim_items	quantity_version
HSPI_Summit_General.claim_supporting_info	valueQuantity_version
HSPI_Summit_General.conditions	onsetAge_version
HSPI_Summit_General.contacts	role_version
HSPI_Summit_General.contacts	gender_version
HSPI_Summit_General.coverages	type_version
HSPI_Summit_General.coverages	relationship_version
HSPI_Summit_General.examples	exampleQuantity_version
HSPI_Summit_General.guarantors	relationship_version
HSPI_Summit_General.immunizations	quantity_version
HSPI_Summit_General.medication_requests	dosage_route_version
HSPI_Summit_General.medication_requests	dosage_quantity_version
HSPI_Summit_General.medication_requests	dispense_quantity_version
HSPI_Summit_General.medication_requests	dispense_duration_version
HSPI_Summit_General.medications	route_version
HSPI_Summit_General.medications	quantity_version
HSPI_Summit_General.medications	stopReason_version
HSPI_Summit_General.observations	type_version
HSPI_Summit_General.observations	code_version
HSPI_Summit_General.observations	quantity_version
HSPI_Summit_General.observations	interpretation_version
HSPI_Summit_General.observations	range_low_version
HSPI_Summit_General.observations	range_high_version
HSPI_Summit_General.observations_components	type_version
HSPI_Summit_General.observations_components	code_version
HSPI_Summit_General.observations_components	quantity_version
HSPI_Summit_General.observations_components	interpretation_version
HSPI_Summit_General.observations_components	range_low_version
HSPI_Summit_General.observations_components	range_high_version
HSPI_Summit_General.participants	type_version
HSPI_Summit_General.patient_abstracts	gender_version
HSPI_Summit_General.patient_abstracts	marital_status_version
HSPI_Summit_General.patients	gender_version
HSPI_Summit_General.patients	marital_status_version
HSPI_Summit_General.patients_ethnicities	ethnicity_version
HSPI_Summit_General.patients_races	race_version
HSPI_Summit_General.problems	type_version
HSPI_Summit_General.problems	diagnosis_version
HSPI_Summit_General.problems	status_version
HSPI_Summit_General.problems	severity_version
HSPI_Summit_General.specimens	quantity_version
HSPI_System.web_hook_triggers	requested_version
HSPI_United_Physicians.allergies	code_version
HSPI_United_Physicians.allergies	status_version
HSPI_United_Physicians.allergies	reaction_version
HSPI_United_Physicians.allergies	severity_version
HSPI_United_Physicians.allergies	type_version
HSPI_United_Physicians.charge_master_codes	ndcQuantity_version
HSPI_United_Physicians.claim_items	quantity_version
HSPI_United_Physicians.claim_supporting_info	valueQuantity_version
HSPI_United_Physicians.conditions	onsetAge_version
HSPI_United_Physicians.contacts	role_version
HSPI_United_Physicians.contacts	gender_version
HSPI_United_Physicians.coverages	type_version
HSPI_United_Physicians.coverages	relationship_version
HSPI_United_Physicians.examples	exampleQuantity_version
HSPI_United_Physicians.guarantors	relationship_version
HSPI_United_Physicians.immunizations	quantity_version
HSPI_United_Physicians.medication_requests	dosage_route_version
HSPI_United_Physicians.medication_requests	dosage_quantity_version
HSPI_United_Physicians.medication_requests	dispense_quantity_version
HSPI_United_Physicians.medication_requests	dispense_duration_version
HSPI_United_Physicians.medications	route_version
HSPI_United_Physicians.medications	quantity_version
HSPI_United_Physicians.medications	stopReason_version
HSPI_United_Physicians.observations	type_version
HSPI_United_Physicians.observations	code_version
HSPI_United_Physicians.observations	quantity_version
HSPI_United_Physicians.observations	interpretation_version
HSPI_United_Physicians.observations	range_low_version
HSPI_United_Physicians.observations	range_high_version
HSPI_United_Physicians.observations_components	type_version
HSPI_United_Physicians.observations_components	code_version
HSPI_United_Physicians.observations_components	quantity_version
HSPI_United_Physicians.observations_components	interpretation_version
HSPI_United_Physicians.observations_components	range_low_version
HSPI_United_Physicians.observations_components	range_high_version
HSPI_United_Physicians.participants	type_version
HSPI_United_Physicians.patient_abstracts	gender_version
HSPI_United_Physicians.patient_abstracts	marital_status_version
HSPI_United_Physicians.patients	gender_version
HSPI_United_Physicians.patients	marital_status_version
HSPI_United_Physicians.patients_ethnicities	ethnicity_version
HSPI_United_Physicians.patients_races	race_version
HSPI_United_Physicians.problems	type_version
HSPI_United_Physicians.problems	diagnosis_version
HSPI_United_Physicians.problems	status_version
HSPI_United_Physicians.problems	severity_version
HSPI_United_Physicians.specimens	quantity_version
MPI.allergies	code_version
MPI.allergies	status_version
MPI.allergies	reaction_version
MPI.allergies	severity_version
MPI.allergies	type_version
MPI.charge_master_codes	ndcQuantity_version
MPI.claim_items	quantity_version
MPI.claim_supporting_info	valueQuantity_version
MPI.conditions	onsetAge_version
MPI.contacts	role_version
MPI.contacts	gender_version
MPI.coverages	type_version
MPI.coverages	relationship_version
MPI.examples	exampleQuantity_version
MPI.guarantors	relationship_version
MPI.immunizations	quantity_version
MPI.medication_requests	dosage_route_version
MPI.medication_requests	dosage_quantity_version
MPI.medication_requests	dispense_quantity_version
MPI.medication_requests	dispense_duration_version
MPI.medications	route_version
MPI.medications	quantity_version
MPI.medications	stopReason_version
MPI.observations	type_version
MPI.observations	code_version
MPI.observations	quantity_version
MPI.observations	interpretation_version
MPI.observations	range_low_version
MPI.observations	range_high_version
MPI.observations_components	type_version
MPI.observations_components	code_version
MPI.observations_components	quantity_version
MPI.observations_components	interpretation_version
MPI.observations_components	range_low_version
MPI.observations_components	range_high_version
MPI.participants	type_version
MPI.patient_abstracts	gender_version
MPI.patient_abstracts	marital_status_version
MPI.patients	gender_version
MPI.patients	marital_status_version
MPI.patients_ethnicities	ethnicity_version
MPI.patients_races	race_version
MPI.problems	type_version
MPI.problems	diagnosis_version
MPI.problems	status_version
MPI.problems	severity_version
MPI.specimens	quantity_version
SSO.login_events	browser_version
_1.erx_config	erx_config_request_version
_1.patients_implantable_devices	pid_version
_1188.erx_config	erx_config_request_version
_1188.patients_implantable_devices	pid_version
_1218.erx_config	erx_config_request_version
_1218.patients_implantable_devices	pid_version
_1548.erx_config	erx_config_request_version
_1548.patients_implantable_devices	pid_version
_435.erx_config	erx_config_request_version
_435.patients_implantable_devices	pid_version
_436.erx_config	erx_config_request_version
_436.patients_implantable_devices	pid_version
_436_archive_testing.erx_config	erx_config_request_version
_436_archive_testing.patients_implantable_devices	pid_version
_437.erx_config	erx_config_request_version
_437.patients_implantable_devices	pid_version
_8.erx_config	erx_config_request_version
_8.patients_implantable_devices	pid_version
_81.erx_config	erx_config_request_version
_81.patients_implantable_devices	pid_version
_999.erx_config	erx_config_request_version
_999.patients_implantable_devices	pid_version
aurora_standard.abmmpi	priv_version
aurora_standard.chmarstpi	dx_version
aurora_standard.chmarstpr	dx_version
aurora_standard.chmazstd	drg_version
aurora_standard.chmazstd	icd_version
aurora_standard.chmazsti	drg_version
aurora_standard.chmazsti	icd_version
aurora_standard.chmazsto	drg_version
aurora_standard.chmazsto	icd_version
aurora_standard.chmcostrc	dx_version
aurora_standard.chmhid4c	dx_version
aurora_standard.chmhipad	pnotice_version
aurora_standard.chmlastr	icd_version
aurora_standard.chmnvstb	icd_version
aurora_standard.chmnvstr	icd_version
aurora_standard.chmtxstr	icd_version
aurora_standard.chmub04b	f_66_version
aurora_standard.chmutah6	dx_version
aurora_standard.chmutah7	dx_version
aurora_standard.chmutaha	dx_version
aurora_standard.chmutaht	dx_version
aurora_standard.chsmodsc	module_version
aurora_standard.tmpub04r	f_66_version
common.cqm_info	cit_version
common.fax_accounts	fxa_sfax_acc_version
common.interfaces_types	it_api_version
common.login_events	loge_browser_version
common.sfax_accounts	sfax_acc_version
inpatient_pricer.drg_codes	grouper_version
inpatient_pricer.pricer_grouper_version_dates	hac_version
xlnt.pullrequest_deployments	release_version

language

Table	Column
HSPI_CURES2015_B1.patient_abstracts	preferred_language_version
HSPI_CURES2015_B1.patients	preferred_language_version
HSPI_Central_Hospital.patient_abstracts	preferred_language_version
HSPI_Central_Hospital.patients	preferred_language_version
HSPI_Dewitt.patient_abstracts	preferred_language_version
HSPI_Dewitt.patients	preferred_language_version
HSPI_Fulton.patient_abstracts	preferred_language_version
HSPI_Fulton.patients	preferred_language_version
HSPI_Inferno.patient_abstracts	preferred_language_version
HSPI_Inferno.patients	preferred_language_version
HSPI_MU2015_E1.patient_abstracts	preferred_language_version
HSPI_MU2015_E1.patients	preferred_language_version
HSPI_MU2015_G2.patient_abstracts	preferred_language_version
HSPI_MU2015_G2.patients	preferred_language_version
HSPI_MU2015_G9.patient_abstracts	preferred_language_version
HSPI_MU2015_G9.patients	preferred_language_version
HSPI_Sandbox.patient_abstracts	preferred_language_version
HSPI_Sandbox.patients	preferred_language_version
HSPI_Summit_General.patient_abstracts	preferred_language_version
HSPI_Summit_General.patients	preferred_language_version
HSPI_United_Physicians.patient_abstracts	preferred_language_version
HSPI_United_Physicians.patients	preferred_language_version
MPI.patient_abstracts	preferred_language_version
MPI.patients	preferred_language_version
_1.clinical_interventions	ci_language
_1188.clinical_interventions	ci_language
_1218.clinical_interventions	ci_language
_1548.clinical_interventions	ci_language
_435.clinical_interventions	ci_language
_436.clinical_interventions	ci_language
_436_archive_testing.clinical_interventions	ci_language
_437.clinical_interventions	ci_language
_8.clinical_interventions	ci_language
_81.clinical_interventions	ci_language
_999.clinical_interventions	ci_language
ahiWiki.sites	site_language
aurora_standard.bdmpi	prim_language
aurora_standard.bsinsur	prim_language
aurora_standard.campi	prim_language
aurora_standard.chmpatmr	prim_language
aurora_standard.hl7pid	prim_language
aurora_standard.hl7pidad	prim_language

end

Table	Column
RxNorm.retired	ver_end
_1.appointment_recurrence	arec_apt_datestamp_end
_1.appointments	apt_datestamp_end
_1.closed_periods_daily	clpd_ar_end
_1.patients_authorization_numbers	pan_date_end
_1.schedules	sch_time_end
_1.schedules_events	sevnt_time_end
_1.schedules_exceptions	sexc_time_end
_1188.appointment_recurrence	arec_apt_datestamp_end
_1188.appointments	apt_datestamp_end
_1188.closed_periods_daily	clpd_ar_end
_1188.patients_authorization_numbers	pan_date_end
_1188.schedules	sch_time_end
_1188.schedules_events	sevnt_time_end
_1188.schedules_exceptions	sexc_time_end
_1218.appointment_recurrence	arec_apt_datestamp_end
_1218.appointments	apt_datestamp_end
_1218.closed_periods_daily	clpd_ar_end
_1218.patients_authorization_numbers	pan_date_end
_1218.schedules	sch_time_end
_1218.schedules_events	sevnt_time_end
_1218.schedules_exceptions	sexc_time_end
_1548.appointment_recurrence	arec_apt_datestamp_end
_1548.appointments	apt_datestamp_end
_1548.closed_periods_daily	clpd_ar_end
_1548.patients_authorization_numbers	pan_date_end
_1548.schedules	sch_time_end
_1548.schedules_events	sevnt_time_end
_1548.schedules_exceptions	sexc_time_end
_435.appointment_recurrence	arec_apt_datestamp_end
_435.appointments	apt_datestamp_end
_435.closed_periods_daily	clpd_ar_end
_435.patients_authorization_numbers	pan_date_end
_435.schedules	sch_time_end
_435.schedules_events	sevnt_time_end
_435.schedules_exceptions	sexc_time_end
_436.appointment_recurrence	arec_apt_datestamp_end
_436.appointments	apt_datestamp_end
_436.closed_periods_daily	clpd_ar_end
_436.patients_authorization_numbers	pan_date_end
_436.schedules	sch_time_end
_436.schedules_events	sevnt_time_end
_436.schedules_exceptions	sexc_time_end
_436_archive_testing.appointment_recurrence	arec_apt_datestamp_end
_436_archive_testing.appointments	apt_datestamp_end
_436_archive_testing.closed_periods_daily	clpd_ar_end
_436_archive_testing.patients_authorization_numbers	pan_date_end
_436_archive_testing.schedules	sch_time_end
_436_archive_testing.schedules_events	sevnt_time_end
_436_archive_testing.schedules_exceptions	sexc_time_end
_437.appointment_recurrence	arec_apt_datestamp_end
_437.appointments	apt_datestamp_end
_437.closed_periods_daily	clpd_ar_end
_437.patients_authorization_numbers	pan_date_end
_437.schedules	sch_time_end
_437.schedules_events	sevnt_time_end
_437.schedules_exceptions	sexc_time_end
_8.appointment_recurrence	arec_apt_datestamp_end
_8.appointments	apt_datestamp_end
_8.closed_periods_daily	clpd_ar_end
_8.patients_authorization_numbers	pan_date_end
_8.schedules	sch_time_end
_8.schedules_events	sevnt_time_end
_8.schedules_exceptions	sexc_time_end
_81.appointment_recurrence	arec_apt_datestamp_end
_81.appointments	apt_datestamp_end
_81.closed_periods_daily	clpd_ar_end
_81.patients_authorization_numbers	pan_date_end
_81.schedules	sch_time_end
_81.schedules_events	sevnt_time_end
_81.schedules_exceptions	sexc_time_end
_999.appointment_recurrence	arec_apt_datestamp_end
_999.appointments	apt_datestamp_end
_999.closed_periods_daily	clpd_ar_end
_999.patients_authorization_numbers	pan_date_end
_999.schedules	sch_time_end
_999.schedules_events	sevnt_time_end
_999.schedules_exceptions	sexc_time_end
ahiWiki.ipblocks	ipb_range_end
aurora_standard.abmvis	cycle_end
aurora_standard.chlswbdd	data_end
aurora_standard.chlswbhd	data_end
aurora_standard.chlswbtd	data_end
aurora_standard.chltrand	asmnt_end
aurora_standard.chltrnhd	data_end
aurora_standard.chltrnsd	data_end
aurora_standard.chltrntd	data_end
aurora_standard.chm10cmc	cm_category_end
aurora_standard.chmpread	date_con_end
aurora_standard.chmpread	date_pa_end
aurora_standard.chtshftc	shift_end
aurora_standard.hl7gt1	guar_date_end
aurora_standard.hl7gt1ad	guar_date_end
aurora_standard.stfcntrc	fiscal_end
common.applicants	app_employer_1_end
common.applicants	app_employer_2_end
common.applicants	app_employer_3_end
common.applicants	app_employer_4_end
common.clients	cli_schedule_time_end
common.customers	cus_email_end
common.data_import_clients_meta_data	dicmd_import_end
common.health_insurance_prospective_payment_system_codes	hippsc_effective_end

empl_name

Table	Column
aurora_standard.chhl7in2	ins_empl_name
aurora_standard.hl7gt1	guar_empl_name
aurora_standard.hl7gt1ad	guar_empl_name
aurora_standard.hl7in2	ins_empl_name
aurora_standard.hl7in2ad	ins_empl_name

filler1

Table	Column
aurora_standard.chltrnsd	s_filler1

empl_addr

Table	Column
aurora_standard.chmarsi	ins1_empl_addr
aurora_standard.chmarsi	ins2_empl_addr
aurora_standard.chmarsi	ins3_empl_addr
aurora_standard.chmcampi	ins1_empl_addr
aurora_standard.chmcampi	ins2_empl_addr
aurora_standard.chmcampi	ins3_empl_addr
aurora_standard.chmexmpi	ins1_empl_addr
aurora_standard.chmexmpi	ins2_empl_addr
aurora_standard.chmexmpi	ins3_empl_addr
aurora_standard.chmpdemo	ins1_empl_addr
aurora_standard.chmpdemo	ins2_empl_addr
aurora_standard.chmpdemo	ins3_empl_addr
aurora_standard.chmradex	ins1_empl_addr
aurora_standard.chmradex	ins2_empl_addr
aurora_standard.chmradex	ins3_empl_addr
aurora_standard.hl7gt1	guar_empl_addr
aurora_standard.hl7gt1ad	guar_empl_addr
aurora_standard.hl7in1	ins_empl_addr
aurora_standard.hl7in1ad	ins_empl_addr

interest

Table	Column
aurora_standard.strnoted	percent_interest
aurora_standard.stxratid	expense_interest