aurora_standard.stuprice

Field	Type	Null	Key	Extra
price_code	bigint(20) unsigned	NO	PRI	auto_increment
description	varchar(30)	YES
price_level	smallint(6)	YES
item_code	varchar(20)	YES
item_class	varchar(6)	YES
vend_code	varchar(6)	YES
trd_ds_code	varchar(6)	YES
order_type	varchar(3)	YES
purch_unit	varchar(2)	YES
begin_date	date	YES
end_date	date	YES
disc_type	varchar(1)	YES
tolerance_level	smallint(6)	YES

References

Local Column

References

end_date

Table	Column
HSPI_Bastrop.PatientTracking	period_end_date
HSPI_Bastrop.allergies	period_end_date
HSPI_Bastrop.appointments	datetime_end_date
HSPI_Bastrop.care_plans	effective_end_date
HSPI_Bastrop.charges	dateOfService_end_date
HSPI_Bastrop.claim_items	billablePeriod_end_date
HSPI_Bastrop.claim_supporting_info	timingPeriod_end_date
HSPI_Bastrop.claims	billablePeriod_end_date
HSPI_Bastrop.conditions	onsetPeriod_end_date
HSPI_Bastrop.coverages	period_end_date
HSPI_Bastrop.encounter_occurence_span_codes	period_end_date
HSPI_Bastrop.encounters	period_end_date
HSPI_Bastrop.examples	datetime_end_date
HSPI_Bastrop.family_history	birthPeriod_end_date
HSPI_Bastrop.family_history	deathPeriod_end_date
HSPI_Bastrop.laboratory_results	effective_end_date
HSPI_Bastrop.medication_requests	dispense_period_end_date
HSPI_Bastrop.medications	effective_end_date
HSPI_Bastrop.observations	effective_end_date
HSPI_Bastrop.patient_tracking	period_end_date
HSPI_Bastrop.patients_authorization_ids	effectivePeriod_end_date
HSPI_Bastrop.problems	period_end_date
HSPI_Bastrop.procedures	performed_end_date
HSPI_CURES2015_B1.allergies	period_end_date
HSPI_CURES2015_B1.appointments	datetime_end_date
HSPI_CURES2015_B1.care_plans	effective_end_date
HSPI_CURES2015_B1.charges	dateOfService_end_date
HSPI_CURES2015_B1.claim_items	billablePeriod_end_date
HSPI_CURES2015_B1.claim_supporting_info	timingPeriod_end_date
HSPI_CURES2015_B1.claims	billablePeriod_end_date
HSPI_CURES2015_B1.conditions	onsetPeriod_end_date
HSPI_CURES2015_B1.coverages	period_end_date
HSPI_CURES2015_B1.encounter_occurence_span_codes	period_end_date
HSPI_CURES2015_B1.encounters	period_end_date
HSPI_CURES2015_B1.encounters	unableToWork_end_date
HSPI_CURES2015_B1.examples	datetime_end_date
HSPI_CURES2015_B1.family_history	birthPeriod_end_date
HSPI_CURES2015_B1.family_history	deathPeriod_end_date
HSPI_CURES2015_B1.invoices	generationPeriod_end_date
HSPI_CURES2015_B1.laboratory_results	effective_end_date
HSPI_CURES2015_B1.medication_requests	dispense_period_end_date
HSPI_CURES2015_B1.medications	effective_end_date
HSPI_CURES2015_B1.observations	effective_end_date
HSPI_CURES2015_B1.patient_tracking	period_end_date
HSPI_CURES2015_B1.patients_authorization_ids	effectivePeriod_end_date
HSPI_CURES2015_B1.problems	period_end_date
HSPI_CURES2015_B1.procedures	performed_end_date
HSPI_Central_Hospital.addresses	period_end_date
HSPI_Central_Hospital.allergies	period_end_date
HSPI_Central_Hospital.appointments	datetime_end_date
HSPI_Central_Hospital.care_plans	effective_end_date
HSPI_Central_Hospital.charges	dateOfService_end_date
HSPI_Central_Hospital.claim_items	billablePeriod_end_date
HSPI_Central_Hospital.claim_supporting_info	timingPeriod_end_date
HSPI_Central_Hospital.claims	billablePeriod_end_date
HSPI_Central_Hospital.conditions	onsetPeriod_end_date
HSPI_Central_Hospital.coverages	period_end_date
HSPI_Central_Hospital.encounter_occurence_span_codes	period_end_date
HSPI_Central_Hospital.encounters	period_end_date
HSPI_Central_Hospital.encounters	unableToWork_end_date
HSPI_Central_Hospital.examples	datetime_end_date
HSPI_Central_Hospital.family_history	birthPeriod_end_date
HSPI_Central_Hospital.family_history	deathPeriod_end_date
HSPI_Central_Hospital.invoices	generationPeriod_end_date
HSPI_Central_Hospital.laboratory_results	effective_end_date
HSPI_Central_Hospital.medication_requests	dispense_period_end_date
HSPI_Central_Hospital.medications	effective_end_date
HSPI_Central_Hospital.names	period_end_date
HSPI_Central_Hospital.observations	effective_end_date
HSPI_Central_Hospital.patient_tracking	period_end_date
HSPI_Central_Hospital.patients_authorization_ids	effectivePeriod_end_date
HSPI_Central_Hospital.problems	period_end_date
HSPI_Central_Hospital.procedures	performed_end_date
HSPI_Dewitt.addresses	period_end_date
HSPI_Dewitt.allergies	period_end_date
HSPI_Dewitt.appointments	datetime_end_date
HSPI_Dewitt.care_plans	effective_end_date
HSPI_Dewitt.charges	dateOfService_end_date
HSPI_Dewitt.claim_items	billablePeriod_end_date
HSPI_Dewitt.claim_supporting_info	timingPeriod_end_date
HSPI_Dewitt.claims	billablePeriod_end_date
HSPI_Dewitt.conditions	onsetPeriod_end_date
HSPI_Dewitt.coverages	period_end_date
HSPI_Dewitt.encounter_occurence_span_codes	period_end_date
HSPI_Dewitt.encounters	period_end_date
HSPI_Dewitt.encounters	unableToWork_end_date
HSPI_Dewitt.examples	datetime_end_date
HSPI_Dewitt.family_history	birthPeriod_end_date
HSPI_Dewitt.family_history	deathPeriod_end_date
HSPI_Dewitt.invoices	generationPeriod_end_date
HSPI_Dewitt.laboratory_results	effective_end_date
HSPI_Dewitt.medication_requests	dispense_period_end_date
HSPI_Dewitt.medications	effective_end_date
HSPI_Dewitt.names	period_end_date
HSPI_Dewitt.observations	effective_end_date
HSPI_Dewitt.patient_tracking	period_end_date
HSPI_Dewitt.patients_authorization_ids	effectivePeriod_end_date
HSPI_Dewitt.problems	period_end_date
HSPI_Dewitt.procedures	performed_end_date
HSPI_Fulton.addresses	period_end_date
HSPI_Fulton.allergies	period_end_date
HSPI_Fulton.appointments	datetime_end_date
HSPI_Fulton.care_plans	effective_end_date
HSPI_Fulton.charges	dateOfService_end_date
HSPI_Fulton.claim_items	billablePeriod_end_date
HSPI_Fulton.claim_supporting_info	timingPeriod_end_date
HSPI_Fulton.claims	billablePeriod_end_date
HSPI_Fulton.conditions	onsetPeriod_end_date
HSPI_Fulton.coverages	period_end_date
HSPI_Fulton.encounter_occurence_span_codes	period_end_date
HSPI_Fulton.encounters	period_end_date
HSPI_Fulton.encounters	unableToWork_end_date
HSPI_Fulton.examples	datetime_end_date
HSPI_Fulton.family_history	birthPeriod_end_date
HSPI_Fulton.family_history	deathPeriod_end_date
HSPI_Fulton.invoices	generationPeriod_end_date
HSPI_Fulton.laboratory_results	effective_end_date
HSPI_Fulton.medication_requests	dispense_period_end_date
HSPI_Fulton.medications	effective_end_date
HSPI_Fulton.names	period_end_date
HSPI_Fulton.observations	effective_end_date
HSPI_Fulton.patient_tracking	period_end_date
HSPI_Fulton.patients_authorization_ids	effectivePeriod_end_date
HSPI_Fulton.problems	period_end_date
HSPI_Fulton.procedures	performed_end_date
HSPI_Inferno.addresses	period_end_date
HSPI_Inferno.allergies	period_end_date
HSPI_Inferno.appointments	datetime_end_date
HSPI_Inferno.care_plans	effective_end_date
HSPI_Inferno.charges	dateOfService_end_date
HSPI_Inferno.claim_items	billablePeriod_end_date
HSPI_Inferno.claim_supporting_info	timingPeriod_end_date
HSPI_Inferno.claims	billablePeriod_end_date
HSPI_Inferno.conditions	onsetPeriod_end_date
HSPI_Inferno.coverages	period_end_date
HSPI_Inferno.encounter_occurence_span_codes	period_end_date
HSPI_Inferno.encounters	period_end_date
HSPI_Inferno.encounters	unableToWork_end_date
HSPI_Inferno.examples	datetime_end_date
HSPI_Inferno.family_history	birthPeriod_end_date
HSPI_Inferno.family_history	deathPeriod_end_date
HSPI_Inferno.invoices	generationPeriod_end_date
HSPI_Inferno.laboratory_results	effective_end_date
HSPI_Inferno.medication_requests	dispense_period_end_date
HSPI_Inferno.medications	effective_end_date
HSPI_Inferno.names	period_end_date
HSPI_Inferno.observations	effective_end_date
HSPI_Inferno.patient_tracking	period_end_date
HSPI_Inferno.patients_authorization_ids	effectivePeriod_end_date
HSPI_Inferno.problems	period_end_date
HSPI_Inferno.procedures	performed_end_date
HSPI_MU2015_E1.addresses	period_end_date
HSPI_MU2015_E1.allergies	period_end_date
HSPI_MU2015_E1.appointments	datetime_end_date
HSPI_MU2015_E1.care_plans	effective_end_date
HSPI_MU2015_E1.charges	dateOfService_end_date
HSPI_MU2015_E1.claim_items	billablePeriod_end_date
HSPI_MU2015_E1.claim_supporting_info	timingPeriod_end_date
HSPI_MU2015_E1.claims	billablePeriod_end_date
HSPI_MU2015_E1.conditions	onsetPeriod_end_date
HSPI_MU2015_E1.coverages	period_end_date
HSPI_MU2015_E1.encounter_occurence_span_codes	period_end_date
HSPI_MU2015_E1.encounters	period_end_date
HSPI_MU2015_E1.encounters	unableToWork_end_date
HSPI_MU2015_E1.examples	datetime_end_date
HSPI_MU2015_E1.family_history	birthPeriod_end_date
HSPI_MU2015_E1.family_history	deathPeriod_end_date
HSPI_MU2015_E1.invoices	generationPeriod_end_date
HSPI_MU2015_E1.laboratory_results	effective_end_date
HSPI_MU2015_E1.medication_requests	dispense_period_end_date
HSPI_MU2015_E1.medications	effective_end_date
HSPI_MU2015_E1.names	period_end_date
HSPI_MU2015_E1.observations	effective_end_date
HSPI_MU2015_E1.patient_tracking	period_end_date
HSPI_MU2015_E1.patients_authorization_ids	effectivePeriod_end_date
HSPI_MU2015_E1.problems	period_end_date
HSPI_MU2015_E1.procedures	performed_end_date
HSPI_MU2015_G2.addresses	period_end_date
HSPI_MU2015_G2.allergies	period_end_date
HSPI_MU2015_G2.appointments	datetime_end_date
HSPI_MU2015_G2.care_plans	effective_end_date
HSPI_MU2015_G2.charges	dateOfService_end_date
HSPI_MU2015_G2.claim_items	billablePeriod_end_date
HSPI_MU2015_G2.claim_supporting_info	timingPeriod_end_date
HSPI_MU2015_G2.claims	billablePeriod_end_date
HSPI_MU2015_G2.conditions	onsetPeriod_end_date
HSPI_MU2015_G2.coverages	period_end_date
HSPI_MU2015_G2.encounter_occurence_span_codes	period_end_date
HSPI_MU2015_G2.encounters	period_end_date
HSPI_MU2015_G2.encounters	unableToWork_end_date
HSPI_MU2015_G2.examples	datetime_end_date
HSPI_MU2015_G2.family_history	birthPeriod_end_date
HSPI_MU2015_G2.family_history	deathPeriod_end_date
HSPI_MU2015_G2.invoices	generationPeriod_end_date
HSPI_MU2015_G2.laboratory_results	effective_end_date
HSPI_MU2015_G2.medication_requests	dispense_period_end_date
HSPI_MU2015_G2.medications	effective_end_date
HSPI_MU2015_G2.names	period_end_date
HSPI_MU2015_G2.observations	effective_end_date
HSPI_MU2015_G2.patient_tracking	period_end_date
HSPI_MU2015_G2.patients_authorization_ids	effectivePeriod_end_date
HSPI_MU2015_G2.problems	period_end_date
HSPI_MU2015_G2.procedures	performed_end_date
HSPI_MU2015_G9.addresses	period_end_date
HSPI_MU2015_G9.allergies	period_end_date
HSPI_MU2015_G9.appointments	datetime_end_date
HSPI_MU2015_G9.care_plans	effective_end_date
HSPI_MU2015_G9.charges	dateOfService_end_date
HSPI_MU2015_G9.claim_items	billablePeriod_end_date
HSPI_MU2015_G9.claim_supporting_info	timingPeriod_end_date
HSPI_MU2015_G9.claims	billablePeriod_end_date
HSPI_MU2015_G9.conditions	onsetPeriod_end_date
HSPI_MU2015_G9.coverages	period_end_date
HSPI_MU2015_G9.encounter_occurence_span_codes	period_end_date
HSPI_MU2015_G9.encounters	period_end_date
HSPI_MU2015_G9.encounters	unableToWork_end_date
HSPI_MU2015_G9.examples	datetime_end_date
HSPI_MU2015_G9.family_history	birthPeriod_end_date
HSPI_MU2015_G9.family_history	deathPeriod_end_date
HSPI_MU2015_G9.invoices	generationPeriod_end_date
HSPI_MU2015_G9.laboratory_results	effective_end_date
HSPI_MU2015_G9.medication_requests	dispense_period_end_date
HSPI_MU2015_G9.medications	effective_end_date
HSPI_MU2015_G9.names	period_end_date
HSPI_MU2015_G9.observations	effective_end_date
HSPI_MU2015_G9.patient_tracking	period_end_date
HSPI_MU2015_G9.patients_authorization_ids	effectivePeriod_end_date
HSPI_MU2015_G9.problems	period_end_date
HSPI_MU2015_G9.procedures	performed_end_date
HSPI_Ness.allergies	period_end_date
HSPI_Ness.appointments	datetime_end_date
HSPI_Ness.claims	billablePeriod_end_date
HSPI_Ness.conditions	onsetPeriod_end_date
HSPI_Ness.coverages	period_end_date
HSPI_Ness.encounters	period_end_date
HSPI_Ness.family_history	birthPeriod_end_date
HSPI_Ness.family_history	deathPeriod_end_date
HSPI_Ness.laboratory_results	effective_end_date
HSPI_Ness.medications	effective_end_date
HSPI_Ness.observations	effective_end_date
HSPI_Ness.problems	period_end_date
HSPI_Ness.procedures	performed_end_date
HSPI_Sandbox.addresses	period_end_date
HSPI_Sandbox.allergies	period_end_date
HSPI_Sandbox.appointments	datetime_end_date
HSPI_Sandbox.care_plans	effective_end_date
HSPI_Sandbox.charges	dateOfService_end_date
HSPI_Sandbox.claim_items	billablePeriod_end_date
HSPI_Sandbox.claim_supporting_info	timingPeriod_end_date
HSPI_Sandbox.claims	billablePeriod_end_date
HSPI_Sandbox.conditions	onsetPeriod_end_date
HSPI_Sandbox.coverages	period_end_date
HSPI_Sandbox.encounter_occurence_span_codes	period_end_date
HSPI_Sandbox.encounters	period_end_date
HSPI_Sandbox.encounters	unableToWork_end_date
HSPI_Sandbox.examples	datetime_end_date
HSPI_Sandbox.family_history	birthPeriod_end_date
HSPI_Sandbox.family_history	deathPeriod_end_date
HSPI_Sandbox.invoices	generationPeriod_end_date
HSPI_Sandbox.laboratory_results	effective_end_date
HSPI_Sandbox.medication_requests	dispense_period_end_date
HSPI_Sandbox.medications	effective_end_date
HSPI_Sandbox.names	period_end_date
HSPI_Sandbox.observations	effective_end_date
HSPI_Sandbox.patient_tracking	period_end_date
HSPI_Sandbox.patients_authorization_ids	effectivePeriod_end_date
HSPI_Sandbox.problems	period_end_date
HSPI_Sandbox.procedures	performed_end_date
HSPI_Summit_General.addresses	period_end_date
HSPI_Summit_General.allergies	period_end_date
HSPI_Summit_General.appointments	datetime_end_date
HSPI_Summit_General.care_plans	effective_end_date
HSPI_Summit_General.charges	dateOfService_end_date
HSPI_Summit_General.claim_items	billablePeriod_end_date
HSPI_Summit_General.claim_supporting_info	timingPeriod_end_date
HSPI_Summit_General.claims	billablePeriod_end_date
HSPI_Summit_General.conditions	onsetPeriod_end_date
HSPI_Summit_General.coverages	period_end_date
HSPI_Summit_General.encounter_occurence_span_codes	period_end_date
HSPI_Summit_General.encounters	period_end_date
HSPI_Summit_General.encounters	unableToWork_end_date
HSPI_Summit_General.examples	datetime_end_date
HSPI_Summit_General.family_history	birthPeriod_end_date
HSPI_Summit_General.family_history	deathPeriod_end_date
HSPI_Summit_General.invoices	generationPeriod_end_date
HSPI_Summit_General.laboratory_results	effective_end_date
HSPI_Summit_General.medication_requests	dispense_period_end_date
HSPI_Summit_General.medications	effective_end_date
HSPI_Summit_General.names	period_end_date
HSPI_Summit_General.observations	effective_end_date
HSPI_Summit_General.patient_tracking	period_end_date
HSPI_Summit_General.patients_authorization_ids	effectivePeriod_end_date
HSPI_Summit_General.problems	period_end_date
HSPI_Summit_General.procedures	performed_end_date
HSPI_System.addresses	period_end_date
HSPI_United_Physicians.addresses	period_end_date
HSPI_United_Physicians.allergies	period_end_date
HSPI_United_Physicians.appointments	datetime_end_date
HSPI_United_Physicians.care_plans	effective_end_date
HSPI_United_Physicians.charges	dateOfService_end_date
HSPI_United_Physicians.claim_items	billablePeriod_end_date
HSPI_United_Physicians.claim_supporting_info	timingPeriod_end_date
HSPI_United_Physicians.claims	billablePeriod_end_date
HSPI_United_Physicians.conditions	onsetPeriod_end_date
HSPI_United_Physicians.coverages	period_end_date
HSPI_United_Physicians.encounter_occurence_span_codes	period_end_date
HSPI_United_Physicians.encounters	period_end_date
HSPI_United_Physicians.encounters	unableToWork_end_date
HSPI_United_Physicians.examples	datetime_end_date
HSPI_United_Physicians.family_history	birthPeriod_end_date
HSPI_United_Physicians.family_history	deathPeriod_end_date
HSPI_United_Physicians.invoices	generationPeriod_end_date
HSPI_United_Physicians.laboratory_results	effective_end_date
HSPI_United_Physicians.medication_requests	dispense_period_end_date
HSPI_United_Physicians.medications	effective_end_date
HSPI_United_Physicians.names	period_end_date
HSPI_United_Physicians.observations	effective_end_date
HSPI_United_Physicians.patient_tracking	period_end_date
HSPI_United_Physicians.patients_authorization_ids	effectivePeriod_end_date
HSPI_United_Physicians.problems	period_end_date
HSPI_United_Physicians.procedures	performed_end_date
MPI.addresses	period_end_date
MPI.allergies	period_end_date
MPI.appointments	datetime_end_date
MPI.care_plans	effective_end_date
MPI.charges	dateOfService_end_date
MPI.claim_items	billablePeriod_end_date
MPI.claim_supporting_info	timingPeriod_end_date
MPI.claims	billablePeriod_end_date
MPI.conditions	onsetPeriod_end_date
MPI.coverages	period_end_date
MPI.encounter_occurence_span_codes	period_end_date
MPI.encounters	period_end_date
MPI.encounters	unableToWork_end_date
MPI.examples	datetime_end_date
MPI.family_history	birthPeriod_end_date
MPI.family_history	deathPeriod_end_date
MPI.invoices	generationPeriod_end_date
MPI.laboratory_results	effective_end_date
MPI.medication_requests	dispense_period_end_date
MPI.medications	effective_end_date
MPI.names	period_end_date
MPI.observations	effective_end_date
MPI.patient_tracking	period_end_date
MPI.patients_authorization_ids	effectivePeriod_end_date
MPI.problems	period_end_date
MPI.procedures	performed_end_date
SSO.login_notifications	period_end_date
SSO.names	period_end_date
_1.configured_encounters	confenc_end_date
_1.encounters	enc_ins1_end_date
_1.encounters	enc_ins1_referral_end_date
_1.encounters	enc_ins2_end_date
_1.encounters	enc_ins3_end_date
_1.insurances_repository	irep_ins_end_date
_1.insurances_repository	irep_ins_referral_end_date
_1.patients	pat_ins1_end_date
_1.patients	pat_ins1_referral_end_date
_1.patients	pat_ins2_end_date
_1.patients	pat_ins3_end_date
_1.patients_configured_encounters_schedules	pces_end_date
_1.patients_demographics_snapshots	pds_ins1_end_date
_1.patients_demographics_snapshots	pds_ins1_referral_end_date
_1.patients_demographics_snapshots	pds_ins2_end_date
_1.patients_demographics_snapshots	pds_ins3_end_date
_1.patients_payments_schedules	pps_end_date
_1.precerts	pre_ins1_end_date
_1.precerts	pre_ins1_referral_end_date
_1.precerts	pre_ins2_end_date
_1188.encounters	enc_ins1_end_date
_1188.encounters	enc_ins1_referral_end_date
_1188.encounters	enc_ins2_end_date
_1188.encounters	enc_ins3_end_date
_1188.insurances_repository	irep_ins_end_date
_1188.insurances_repository	irep_ins_referral_end_date
_1188.patients	pat_ins1_end_date
_1188.patients	pat_ins1_referral_end_date
_1188.patients	pat_ins2_end_date
_1188.patients	pat_ins3_end_date
_1188.patients_configured_encounters_schedules	pces_end_date
_1188.patients_demographics_snapshots	pds_ins1_end_date
_1188.patients_demographics_snapshots	pds_ins1_referral_end_date
_1188.patients_demographics_snapshots	pds_ins2_end_date
_1188.patients_demographics_snapshots	pds_ins3_end_date
_1188.patients_payments_schedules	pps_end_date
_1188.precerts	pre_ins1_end_date
_1188.precerts	pre_ins1_referral_end_date
_1188.precerts	pre_ins2_end_date
_1218.encounters	enc_ins1_end_date
_1218.encounters	enc_ins1_referral_end_date
_1218.encounters	enc_ins2_end_date
_1218.encounters	enc_ins3_end_date
_1218.insurances_repository	irep_ins_end_date
_1218.insurances_repository	irep_ins_referral_end_date
_1218.patients	pat_ins1_end_date
_1218.patients	pat_ins1_referral_end_date
_1218.patients	pat_ins2_end_date
_1218.patients	pat_ins3_end_date
_1218.patients_configured_encounters_schedules	pces_end_date
_1218.patients_demographics_snapshots	pds_ins1_end_date
_1218.patients_demographics_snapshots	pds_ins1_referral_end_date
_1218.patients_demographics_snapshots	pds_ins2_end_date
_1218.patients_demographics_snapshots	pds_ins3_end_date
_1218.patients_payments_schedules	pps_end_date
_1218.precerts	pre_ins1_end_date
_1218.precerts	pre_ins1_referral_end_date
_1218.precerts	pre_ins2_end_date
_1548.configured_encounters	confenc_end_date
_1548.encounters	enc_ins1_end_date
_1548.encounters	enc_ins1_referral_end_date
_1548.encounters	enc_ins2_end_date
_1548.encounters	enc_ins3_end_date
_1548.insurances_repository	irep_ins_end_date
_1548.insurances_repository	irep_ins_referral_end_date
_1548.patients	pat_ins1_end_date
_1548.patients	pat_ins1_referral_end_date
_1548.patients	pat_ins2_end_date
_1548.patients	pat_ins3_end_date
_1548.patients_configured_encounters_schedules	pces_end_date
_1548.patients_demographics_snapshots	pds_ins1_end_date
_1548.patients_demographics_snapshots	pds_ins1_referral_end_date
_1548.patients_demographics_snapshots	pds_ins2_end_date
_1548.patients_demographics_snapshots	pds_ins3_end_date
_1548.patients_payments_schedules	pps_end_date
_1548.precerts	pre_ins1_end_date
_1548.precerts	pre_ins1_referral_end_date
_1548.precerts	pre_ins2_end_date
_435.configured_encounters	confenc_end_date
_435.encounters	enc_ins1_end_date
_435.encounters	enc_ins1_referral_end_date
_435.encounters	enc_ins2_end_date
_435.encounters	enc_ins3_end_date
_435.insurances_repository	irep_ins_end_date
_435.insurances_repository	irep_ins_referral_end_date
_435.patients	pat_ins1_end_date
_435.patients	pat_ins1_referral_end_date
_435.patients	pat_ins2_end_date
_435.patients	pat_ins3_end_date
_435.patients_configured_encounters_schedules	pces_end_date
_435.patients_demographics_snapshots	pds_ins1_end_date
_435.patients_demographics_snapshots	pds_ins1_referral_end_date
_435.patients_demographics_snapshots	pds_ins2_end_date
_435.patients_demographics_snapshots	pds_ins3_end_date
_435.patients_payments_schedules	pps_end_date
_435.precerts	pre_ins1_end_date
_435.precerts	pre_ins1_referral_end_date
_435.precerts	pre_ins2_end_date
_436.configured_encounters	confenc_end_date
_436.encounters	enc_ins1_end_date
_436.encounters	enc_ins1_referral_end_date
_436.encounters	enc_ins2_end_date
_436.encounters	enc_ins3_end_date
_436.insurances_repository	irep_ins_end_date
_436.insurances_repository	irep_ins_referral_end_date
_436.patients	pat_ins1_end_date
_436.patients	pat_ins1_referral_end_date
_436.patients	pat_ins2_end_date
_436.patients	pat_ins3_end_date
_436.patients_configured_encounters_schedules	pces_end_date
_436.patients_demographics_snapshots	pds_ins1_end_date
_436.patients_demographics_snapshots	pds_ins1_referral_end_date
_436.patients_demographics_snapshots	pds_ins2_end_date
_436.patients_demographics_snapshots	pds_ins3_end_date
_436.patients_payments_schedules	pps_end_date
_436.precerts	pre_ins1_end_date
_436.precerts	pre_ins1_referral_end_date
_436.precerts	pre_ins2_end_date
_436_archive_testing.configured_encounters	confenc_end_date
_436_archive_testing.encounters	enc_ins1_end_date
_436_archive_testing.encounters	enc_ins1_referral_end_date
_436_archive_testing.encounters	enc_ins2_end_date
_436_archive_testing.encounters	enc_ins3_end_date
_436_archive_testing.insurances_repository	irep_ins_end_date
_436_archive_testing.insurances_repository	irep_ins_referral_end_date
_436_archive_testing.patients	pat_ins1_end_date
_436_archive_testing.patients	pat_ins1_referral_end_date
_436_archive_testing.patients	pat_ins2_end_date
_436_archive_testing.patients	pat_ins3_end_date
_436_archive_testing.patients_configured_encounters_schedules	pces_end_date
_436_archive_testing.patients_demographics_snapshots	pds_ins1_end_date
_436_archive_testing.patients_demographics_snapshots	pds_ins1_referral_end_date
_436_archive_testing.patients_demographics_snapshots	pds_ins2_end_date
_436_archive_testing.patients_demographics_snapshots	pds_ins3_end_date
_436_archive_testing.patients_payments_schedules	pps_end_date
_436_archive_testing.precerts	pre_ins1_end_date
_436_archive_testing.precerts	pre_ins1_referral_end_date
_436_archive_testing.precerts	pre_ins2_end_date
_437.configured_encounters	confenc_end_date
_437.encounters	enc_ins1_end_date
_437.encounters	enc_ins1_referral_end_date
_437.encounters	enc_ins2_end_date
_437.encounters	enc_ins3_end_date
_437.insurances_repository	irep_ins_end_date
_437.insurances_repository	irep_ins_referral_end_date
_437.patients	pat_ins1_end_date
_437.patients	pat_ins1_referral_end_date
_437.patients	pat_ins2_end_date
_437.patients	pat_ins3_end_date
_437.patients_configured_encounters_schedules	pces_end_date
_437.patients_demographics_snapshots	pds_ins1_end_date
_437.patients_demographics_snapshots	pds_ins1_referral_end_date
_437.patients_demographics_snapshots	pds_ins2_end_date
_437.patients_demographics_snapshots	pds_ins3_end_date
_437.patients_payments_schedules	pps_end_date
_437.precerts	pre_ins1_end_date
_437.precerts	pre_ins1_referral_end_date
_437.precerts	pre_ins2_end_date
_8.configured_encounters	confenc_end_date
_8.encounters	enc_ins1_end_date
_8.encounters	enc_ins1_referral_end_date
_8.encounters	enc_ins2_end_date
_8.encounters	enc_ins3_end_date
_8.insurances_repository	irep_ins_end_date
_8.insurances_repository	irep_ins_referral_end_date
_8.patients	pat_ins1_end_date
_8.patients	pat_ins1_referral_end_date
_8.patients	pat_ins2_end_date
_8.patients	pat_ins3_end_date
_8.patients_configured_encounters_schedules	pces_end_date
_8.patients_demographics_snapshots	pds_ins1_end_date
_8.patients_demographics_snapshots	pds_ins1_referral_end_date
_8.patients_demographics_snapshots	pds_ins2_end_date
_8.patients_demographics_snapshots	pds_ins3_end_date
_8.patients_payments_schedules	pps_end_date
_8.precerts	pre_ins1_end_date
_8.precerts	pre_ins1_referral_end_date
_8.precerts	pre_ins2_end_date
_81.encounters	enc_ins1_end_date
_81.encounters	enc_ins1_referral_end_date
_81.encounters	enc_ins2_end_date
_81.encounters	enc_ins3_end_date
_81.insurances_repository	irep_ins_end_date
_81.insurances_repository	irep_ins_referral_end_date
_81.patients	pat_ins1_end_date
_81.patients	pat_ins1_referral_end_date
_81.patients	pat_ins2_end_date
_81.patients	pat_ins3_end_date
_81.patients_configured_encounters_schedules	pces_end_date
_81.patients_demographics_snapshots	pds_ins1_end_date
_81.patients_demographics_snapshots	pds_ins1_referral_end_date
_81.patients_demographics_snapshots	pds_ins2_end_date
_81.patients_demographics_snapshots	pds_ins3_end_date
_81.patients_payments_schedules	pps_end_date
_81.precerts	pre_ins1_end_date
_81.precerts	pre_ins1_referral_end_date
_81.precerts	pre_ins2_end_date
_999.configured_encounters	confenc_end_date
_999.encounters	enc_ins1_end_date
_999.encounters	enc_ins1_referral_end_date
_999.encounters	enc_ins2_end_date
_999.encounters	enc_ins3_end_date
_999.insurances_repository	irep_ins_end_date
_999.insurances_repository	irep_ins_referral_end_date
_999.patients	pat_ins1_end_date
_999.patients	pat_ins1_referral_end_date
_999.patients	pat_ins2_end_date
_999.patients	pat_ins3_end_date
_999.patients_configured_encounters_schedules	pces_end_date
_999.patients_demographics_snapshots	pds_ins1_end_date
_999.patients_demographics_snapshots	pds_ins1_referral_end_date
_999.patients_demographics_snapshots	pds_ins2_end_date
_999.patients_demographics_snapshots	pds_ins3_end_date
_999.patients_payments_schedules	pps_end_date
_999.precerts	pre_ins1_end_date
_999.precerts	pre_ins1_referral_end_date
_999.precerts	pre_ins2_end_date
aurora_standard.chmlogrc	log_end_date
aurora_standard.chpcobdd	dep_end_date
aurora_standard.chpcober	cobra_end_date
aurora_standard.chpempdd	person_end_date
aurora_standard.chpinsrc	insrv_end_date
aurora_standard.chpinsuc	plan_end_date
aurora_standard.chtcntrc	period_end_date
aurora_standard.chtemplr	msg_end_date
aurora_standard.defaults	period_end_date
aurora_standard.hl7in3	cert_end_date
aurora_standard.stfsyear	s_end_date
aurora_standard.stmaintd	maint_end_date
aurora_standard.stmmastr	warr_end_date
aurora_standard.stycafer	curr_end_date
aurora_standard.styuimme	qtr_end_date
common.clients_enrollments_map	cem_no_end_date
common.cqm_tracking	cqmt_reporting_end_date
common.cqm_tracking	cqmt_measurement_end_date

description

Table	Column
HSPI_Bastrop.devices	device_description
HSPI_CURES2015_B1.devices	device_description
HSPI_Central_Hospital.devices	device_description
HSPI_Dewitt.devices	device_description
HSPI_Fulton.devices	device_description
HSPI_Inferno.devices	device_description
HSPI_MU2015_E1.devices	device_description
HSPI_MU2015_G2.devices	device_description
HSPI_MU2015_G9.devices	device_description
HSPI_Sandbox.devices	device_description
HSPI_Summit_General.devices	device_description
HSPI_United_Physicians.devices	device_description
MPI.devices	device_description
_1.adjustment_rules	ar_description
_1.cqm_errors	cqmer_description
_1.encounters_alert_rules	ear_description
_1.patients_implantable_devices	pid_device_description
_1188.cqm_errors	cqmer_description
_1188.encounters_alert_rules	ear_description
_1188.patients_implantable_devices	pid_device_description
_1218.adjustment_rules	ar_description
_1218.cqm_errors	cqmer_description
_1218.encounters_alert_rules	ear_description
_1218.patients_implantable_devices	pid_device_description
_1548.adjustment_rules	ar_description
_1548.cqm_errors	cqmer_description
_1548.encounters_alert_rules	ear_description
_1548.patients_implantable_devices	pid_device_description
_435.adjustment_rules	ar_description
_435.cqm_errors	cqmer_description
_435.encounters_alert_rules	ear_description
_435.patients_implantable_devices	pid_device_description
_436.adjustment_rules	ar_description
_436.cqm_errors	cqmer_description
_436.encounters_alert_rules	ear_description
_436.patients_implantable_devices	pid_device_description
_436_archive_testing.adjustment_rules	ar_description
_436_archive_testing.cqm_errors	cqmer_description
_436_archive_testing.encounters_alert_rules	ear_description
_436_archive_testing.patients_implantable_devices	pid_device_description
_437.adjustment_rules	ar_description
_437.cqm_errors	cqmer_description
_437.encounters_alert_rules	ear_description
_437.patients_implantable_devices	pid_device_description
_8.adjustment_rules	ar_description
_8.cqm_errors	cqmer_description
_8.encounters_alert_rules	ear_description
_8.patients_implantable_devices	pid_device_description
_81.cqm_errors	cqmer_description
_81.encounters_alert_rules	ear_description
_81.patients_implantable_devices	pid_device_description
_999.adjustment_rules	ar_description
_999.cqm_errors	cqmer_description
_999.encounters_alert_rules	ear_description
_999.patients_implantable_devices	pid_device_description
ahiWiki.filearchive	fa_description
ahiWiki.image	img_description
ahiWiki.oldimage	oi_description
aurora_standard.medgenix_modules	module_description
aurora_standard.stfclond	asst_description
aurora_standard.stpapckv	acct_description
aurora_standard.stultypr	update_description
aurora_standard.stxparmd	val_description
aurora_standard.stydeddv	home_description
aurora_standard.styincdv	home_description
aurora_standard.styintfc	source_description
aurora_standard.styjobtc	job_description
aurora_standard.styobldv	home_description
aurora_standard.styptodv	home_description
common.data_import_options	dio_description
common.data_import_value_types	divt_description
common.dev_requests	dev_description
common.dev_requests_screencasts	drs_description
common.insurances_claim_indicators	insci_description
common.smoking_statuses	ss_description
common.test_codes	tco_x_specimen_description
common.test_codes_profiles	tcp_description

order_type

Table	Column
_1.physician_order_delegations	phyod_order_type
_1188.physician_order_delegations	phyod_order_type
_1218.physician_order_delegations	phyod_order_type
_1548.physician_order_delegations	phyod_order_type
_435.physician_order_delegations	phyod_order_type
_436.physician_order_delegations	phyod_order_type
_436_archive_testing.physician_order_delegations	phyod_order_type
_437.physician_order_delegations	phyod_order_type
_8.physician_order_delegations	phyod_order_type
_81.physician_order_delegations	phyod_order_type
_999.physician_order_delegations	phyod_order_type

item_code

Table	Column
aurora_standard.chmbitmd	vend_item_code
aurora_standard.chmschgd	vend_item_code
aurora_standard.glstrack	p_item_code
aurora_standard.glstrack	m_item_code
aurora_standard.icactvv	vend_item_code
aurora_standard.stiixref	vend_item_code
aurora_standard.stmaintd	maint_po_item_code
aurora_standard.stuctlgd	vend_item_code
aurora_standard.sturqstd	vend_item_code
aurora_standard.tmpctlgd	vend_item_code
aurora_standard.tmplvl2	vend_item_code
aurora_standard.tmplvl3	vend_item_code
aurora_standard.tmpparlvl	vend_item_code

begin_date

Table	Column
aurora_standard.chmlogrc	log_begin_date
aurora_standard.chpcobdd	dep_begin_date
aurora_standard.chpcober	cobra_begin_date
aurora_standard.chpinsuc	plan_begin_date
aurora_standard.chtcntrc	period_begin_date
aurora_standard.defaults	period_begin_date
aurora_standard.hl7in3	cert_begin_date

item_class

Table	Column
aurora_standard.chrcntrc	rx_item_class

vend_code

Table	Column
aurora_standard.vndxref	old_vend_code
aurora_standard.vndxref	new_vend_code