aurora_standard.chttimsh

Field	Type	Null	Key	Extra
card_no	bigint(20) unsigned	NO	PRI	auto_increment
empl_code	varchar(6)	YES
begin_date	date	YES
end_date	date	YES
day_1_date	date	YES
day_2_date	date	YES
day_3_date	date	YES
day_4_date	date	YES
day_5_date	date	YES
day_6_date	date	YES
day_7_date	date	YES
day_8_date	date	YES
day_9_date	date	YES
day_10_date	date	YES
day_11_date	date	YES
day_12_date	date	YES
day_13_date	date	YES
day_14_date	date	YES
day_1_code	varchar(6)	YES
day_2_code	varchar(6)	YES
day_3_code	varchar(6)	YES
day_4_code	varchar(6)	YES
day_5_code	varchar(6)	YES
day_6_code	varchar(6)	YES
day_7_code	varchar(6)	YES
day_8_code	varchar(6)	YES
day_9_code	varchar(6)	YES
day_10_code	varchar(6)	YES
day_11_code	varchar(6)	YES
day_12_code	varchar(6)	YES
day_13_code	varchar(6)	YES
day_14_code	varchar(6)	YES
day_1_hrs	decimal(4,2)	YES
day_2_hrs	decimal(4,2)	YES
day_3_hrs	decimal(4,2)	YES
day_4_hrs	decimal(4,2)	YES
day_5_hrs	decimal(4,2)	YES
day_6_hrs	decimal(4,2)	YES
day_7_hrs	decimal(4,2)	YES
day_8_hrs	decimal(4,2)	YES
day_9_hrs	decimal(4,2)	YES
day_10_hrs	decimal(4,2)	YES
day_11_hrs	decimal(4,2)	YES
day_12_hrs	decimal(4,2)	YES
day_13_hrs	decimal(4,2)	YES
day_14_hrs	decimal(4,2)	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

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

empl_code

Table	Column
aurora_standard.chtsupvc	supv_empl_code
aurora_standard.stypddrd	adj_empl_code

card_no

Table	Column
aurora_standard.stpvendr	credit_card_no
aurora_standard.styrtimd	rec_card_no
aurora_standard.styrtime	rec_card_no