aurora_standard.stxperdd

Field Type Null Default Key Extra Comment
period varchar(2) YES
period_year varchar(4) YES
start_date date YES
chs_rowID bigint(20) unsigned NO PRI auto_increment

References

Local Column References
start_date
TableColumn
HSPI_Bastrop.PatientTrackingperiod_start_date
HSPI_Bastrop.allergiesperiod_start_date
HSPI_Bastrop.appointmentsdatetime_start_date
HSPI_Bastrop.care_planseffective_start_date
HSPI_Bastrop.chargesdateOfService_start_date
HSPI_Bastrop.claim_itemsbillablePeriod_start_date
HSPI_Bastrop.claim_supporting_infotimingPeriod_start_date
HSPI_Bastrop.claimsbillablePeriod_start_date
HSPI_Bastrop.conditionsonsetPeriod_start_date
HSPI_Bastrop.coveragesperiod_start_date
HSPI_Bastrop.encounter_occurence_span_codesperiod_start_date
HSPI_Bastrop.encountersperiod_start_date
HSPI_Bastrop.examplesdatetime_start_date
HSPI_Bastrop.family_historybirthPeriod_start_date
HSPI_Bastrop.family_historydeathPeriod_start_date
HSPI_Bastrop.laboratory_resultseffective_start_date
HSPI_Bastrop.medicationseffective_start_date
HSPI_Bastrop.observationseffective_start_date
HSPI_Bastrop.patient_trackingperiod_start_date
HSPI_Bastrop.patients_authorization_idseffectivePeriod_start_date
HSPI_Bastrop.problemsperiod_start_date
HSPI_Bastrop.proceduresperformed_start_date
HSPI_CURES2015_B1.allergiesperiod_start_date
HSPI_CURES2015_B1.appointmentsdatetime_start_date
HSPI_CURES2015_B1.care_planseffective_start_date
HSPI_CURES2015_B1.chargesdateOfService_start_date
HSPI_CURES2015_B1.claim_itemsbillablePeriod_start_date
HSPI_CURES2015_B1.claim_supporting_infotimingPeriod_start_date
HSPI_CURES2015_B1.claimsbillablePeriod_start_date
HSPI_CURES2015_B1.conditionsonsetPeriod_start_date
HSPI_CURES2015_B1.coveragesperiod_start_date
HSPI_CURES2015_B1.encounter_occurence_span_codesperiod_start_date
HSPI_CURES2015_B1.encountersperiod_start_date
HSPI_CURES2015_B1.encountersunableToWork_start_date
HSPI_CURES2015_B1.examplesdatetime_start_date
HSPI_CURES2015_B1.family_historybirthPeriod_start_date
HSPI_CURES2015_B1.family_historydeathPeriod_start_date
HSPI_CURES2015_B1.invoicesgenerationPeriod_start_date
HSPI_CURES2015_B1.laboratory_resultseffective_start_date
HSPI_CURES2015_B1.medicationseffective_start_date
HSPI_CURES2015_B1.observationseffective_start_date
HSPI_CURES2015_B1.patient_trackingperiod_start_date
HSPI_CURES2015_B1.patients_authorization_idseffectivePeriod_start_date
HSPI_CURES2015_B1.problemsperiod_start_date
HSPI_CURES2015_B1.proceduresperformed_start_date
HSPI_Central_Hospital.addressesperiod_start_date
HSPI_Central_Hospital.allergiesperiod_start_date
HSPI_Central_Hospital.appointmentsdatetime_start_date
HSPI_Central_Hospital.care_planseffective_start_date
HSPI_Central_Hospital.chargesdateOfService_start_date
HSPI_Central_Hospital.claim_itemsbillablePeriod_start_date
HSPI_Central_Hospital.claim_supporting_infotimingPeriod_start_date
HSPI_Central_Hospital.claimsbillablePeriod_start_date
HSPI_Central_Hospital.conditionsonsetPeriod_start_date
HSPI_Central_Hospital.coveragesperiod_start_date
HSPI_Central_Hospital.encounter_occurence_span_codesperiod_start_date
HSPI_Central_Hospital.encountersperiod_start_date
HSPI_Central_Hospital.encountersunableToWork_start_date
HSPI_Central_Hospital.examplesdatetime_start_date
HSPI_Central_Hospital.family_historybirthPeriod_start_date
HSPI_Central_Hospital.family_historydeathPeriod_start_date
HSPI_Central_Hospital.invoicesgenerationPeriod_start_date
HSPI_Central_Hospital.laboratory_resultseffective_start_date
HSPI_Central_Hospital.medicationseffective_start_date
HSPI_Central_Hospital.namesperiod_start_date
HSPI_Central_Hospital.observationseffective_start_date
HSPI_Central_Hospital.patient_trackingperiod_start_date
HSPI_Central_Hospital.patients_authorization_idseffectivePeriod_start_date
HSPI_Central_Hospital.problemsperiod_start_date
HSPI_Central_Hospital.proceduresperformed_start_date
HSPI_Dewitt.addressesperiod_start_date
HSPI_Dewitt.allergiesperiod_start_date
HSPI_Dewitt.appointmentsdatetime_start_date
HSPI_Dewitt.care_planseffective_start_date
HSPI_Dewitt.chargesdateOfService_start_date
HSPI_Dewitt.claim_itemsbillablePeriod_start_date
HSPI_Dewitt.claim_supporting_infotimingPeriod_start_date
HSPI_Dewitt.claimsbillablePeriod_start_date
HSPI_Dewitt.conditionsonsetPeriod_start_date
HSPI_Dewitt.coveragesperiod_start_date
HSPI_Dewitt.encounter_occurence_span_codesperiod_start_date
HSPI_Dewitt.encountersperiod_start_date
HSPI_Dewitt.encountersunableToWork_start_date
HSPI_Dewitt.examplesdatetime_start_date
HSPI_Dewitt.family_historybirthPeriod_start_date
HSPI_Dewitt.family_historydeathPeriod_start_date
HSPI_Dewitt.invoicesgenerationPeriod_start_date
HSPI_Dewitt.laboratory_resultseffective_start_date
HSPI_Dewitt.medicationseffective_start_date
HSPI_Dewitt.namesperiod_start_date
HSPI_Dewitt.observationseffective_start_date
HSPI_Dewitt.patient_trackingperiod_start_date
HSPI_Dewitt.patients_authorization_idseffectivePeriod_start_date
HSPI_Dewitt.problemsperiod_start_date
HSPI_Dewitt.proceduresperformed_start_date
HSPI_Fulton.addressesperiod_start_date
HSPI_Fulton.allergiesperiod_start_date
HSPI_Fulton.appointmentsdatetime_start_date
HSPI_Fulton.care_planseffective_start_date
HSPI_Fulton.chargesdateOfService_start_date
HSPI_Fulton.claim_itemsbillablePeriod_start_date
HSPI_Fulton.claim_supporting_infotimingPeriod_start_date
HSPI_Fulton.claimsbillablePeriod_start_date
HSPI_Fulton.conditionsonsetPeriod_start_date
HSPI_Fulton.coveragesperiod_start_date
HSPI_Fulton.encounter_occurence_span_codesperiod_start_date
HSPI_Fulton.encountersperiod_start_date
HSPI_Fulton.encountersunableToWork_start_date
HSPI_Fulton.examplesdatetime_start_date
HSPI_Fulton.family_historybirthPeriod_start_date
HSPI_Fulton.family_historydeathPeriod_start_date
HSPI_Fulton.invoicesgenerationPeriod_start_date
HSPI_Fulton.laboratory_resultseffective_start_date
HSPI_Fulton.medicationseffective_start_date
HSPI_Fulton.namesperiod_start_date
HSPI_Fulton.observationseffective_start_date
HSPI_Fulton.patient_trackingperiod_start_date
HSPI_Fulton.patients_authorization_idseffectivePeriod_start_date
HSPI_Fulton.problemsperiod_start_date
HSPI_Fulton.proceduresperformed_start_date
HSPI_Inferno.addressesperiod_start_date
HSPI_Inferno.allergiesperiod_start_date
HSPI_Inferno.appointmentsdatetime_start_date
HSPI_Inferno.care_planseffective_start_date
HSPI_Inferno.chargesdateOfService_start_date
HSPI_Inferno.claim_itemsbillablePeriod_start_date
HSPI_Inferno.claim_supporting_infotimingPeriod_start_date
HSPI_Inferno.claimsbillablePeriod_start_date
HSPI_Inferno.conditionsonsetPeriod_start_date
HSPI_Inferno.coveragesperiod_start_date
HSPI_Inferno.encounter_occurence_span_codesperiod_start_date
HSPI_Inferno.encountersperiod_start_date
HSPI_Inferno.encountersunableToWork_start_date
HSPI_Inferno.examplesdatetime_start_date
HSPI_Inferno.family_historybirthPeriod_start_date
HSPI_Inferno.family_historydeathPeriod_start_date
HSPI_Inferno.invoicesgenerationPeriod_start_date
HSPI_Inferno.laboratory_resultseffective_start_date
HSPI_Inferno.medicationseffective_start_date
HSPI_Inferno.namesperiod_start_date
HSPI_Inferno.observationseffective_start_date
HSPI_Inferno.patient_trackingperiod_start_date
HSPI_Inferno.patients_authorization_idseffectivePeriod_start_date
HSPI_Inferno.problemsperiod_start_date
HSPI_Inferno.proceduresperformed_start_date
HSPI_MU2015_E1.addressesperiod_start_date
HSPI_MU2015_E1.allergiesperiod_start_date
HSPI_MU2015_E1.appointmentsdatetime_start_date
HSPI_MU2015_E1.care_planseffective_start_date
HSPI_MU2015_E1.chargesdateOfService_start_date
HSPI_MU2015_E1.claim_itemsbillablePeriod_start_date
HSPI_MU2015_E1.claim_supporting_infotimingPeriod_start_date
HSPI_MU2015_E1.claimsbillablePeriod_start_date
HSPI_MU2015_E1.conditionsonsetPeriod_start_date
HSPI_MU2015_E1.coveragesperiod_start_date
HSPI_MU2015_E1.encounter_occurence_span_codesperiod_start_date
HSPI_MU2015_E1.encountersperiod_start_date
HSPI_MU2015_E1.encountersunableToWork_start_date
HSPI_MU2015_E1.examplesdatetime_start_date
HSPI_MU2015_E1.family_historybirthPeriod_start_date
HSPI_MU2015_E1.family_historydeathPeriod_start_date
HSPI_MU2015_E1.invoicesgenerationPeriod_start_date
HSPI_MU2015_E1.laboratory_resultseffective_start_date
HSPI_MU2015_E1.medicationseffective_start_date
HSPI_MU2015_E1.namesperiod_start_date
HSPI_MU2015_E1.observationseffective_start_date
HSPI_MU2015_E1.patient_trackingperiod_start_date
HSPI_MU2015_E1.patients_authorization_idseffectivePeriod_start_date
HSPI_MU2015_E1.problemsperiod_start_date
HSPI_MU2015_E1.proceduresperformed_start_date
HSPI_MU2015_G2.addressesperiod_start_date
HSPI_MU2015_G2.allergiesperiod_start_date
HSPI_MU2015_G2.appointmentsdatetime_start_date
HSPI_MU2015_G2.care_planseffective_start_date
HSPI_MU2015_G2.chargesdateOfService_start_date
HSPI_MU2015_G2.claim_itemsbillablePeriod_start_date
HSPI_MU2015_G2.claim_supporting_infotimingPeriod_start_date
HSPI_MU2015_G2.claimsbillablePeriod_start_date
HSPI_MU2015_G2.conditionsonsetPeriod_start_date
HSPI_MU2015_G2.coveragesperiod_start_date
HSPI_MU2015_G2.encounter_occurence_span_codesperiod_start_date
HSPI_MU2015_G2.encountersperiod_start_date
HSPI_MU2015_G2.encountersunableToWork_start_date
HSPI_MU2015_G2.examplesdatetime_start_date
HSPI_MU2015_G2.family_historybirthPeriod_start_date
HSPI_MU2015_G2.family_historydeathPeriod_start_date
HSPI_MU2015_G2.invoicesgenerationPeriod_start_date
HSPI_MU2015_G2.laboratory_resultseffective_start_date
HSPI_MU2015_G2.medicationseffective_start_date
HSPI_MU2015_G2.namesperiod_start_date
HSPI_MU2015_G2.observationseffective_start_date
HSPI_MU2015_G2.patient_trackingperiod_start_date
HSPI_MU2015_G2.patients_authorization_idseffectivePeriod_start_date
HSPI_MU2015_G2.problemsperiod_start_date
HSPI_MU2015_G2.proceduresperformed_start_date
HSPI_MU2015_G9.addressesperiod_start_date
HSPI_MU2015_G9.allergiesperiod_start_date
HSPI_MU2015_G9.appointmentsdatetime_start_date
HSPI_MU2015_G9.care_planseffective_start_date
HSPI_MU2015_G9.chargesdateOfService_start_date
HSPI_MU2015_G9.claim_itemsbillablePeriod_start_date
HSPI_MU2015_G9.claim_supporting_infotimingPeriod_start_date
HSPI_MU2015_G9.claimsbillablePeriod_start_date
HSPI_MU2015_G9.conditionsonsetPeriod_start_date
HSPI_MU2015_G9.coveragesperiod_start_date
HSPI_MU2015_G9.encounter_occurence_span_codesperiod_start_date
HSPI_MU2015_G9.encountersperiod_start_date
HSPI_MU2015_G9.encountersunableToWork_start_date
HSPI_MU2015_G9.examplesdatetime_start_date
HSPI_MU2015_G9.family_historybirthPeriod_start_date
HSPI_MU2015_G9.family_historydeathPeriod_start_date
HSPI_MU2015_G9.invoicesgenerationPeriod_start_date
HSPI_MU2015_G9.laboratory_resultseffective_start_date
HSPI_MU2015_G9.medicationseffective_start_date
HSPI_MU2015_G9.namesperiod_start_date
HSPI_MU2015_G9.observationseffective_start_date
HSPI_MU2015_G9.patient_trackingperiod_start_date
HSPI_MU2015_G9.patients_authorization_idseffectivePeriod_start_date
HSPI_MU2015_G9.problemsperiod_start_date
HSPI_MU2015_G9.proceduresperformed_start_date
HSPI_Ness.allergiesperiod_start_date
HSPI_Ness.appointmentsdatetime_start_date
HSPI_Ness.claimsbillablePeriod_start_date
HSPI_Ness.conditionsonsetPeriod_start_date
HSPI_Ness.coveragesperiod_start_date
HSPI_Ness.encountersperiod_start_date
HSPI_Ness.family_historybirthPeriod_start_date
HSPI_Ness.family_historydeathPeriod_start_date
HSPI_Ness.laboratory_resultseffective_start_date
HSPI_Ness.medicationseffective_start_date
HSPI_Ness.observationseffective_start_date
HSPI_Ness.problemsperiod_start_date
HSPI_Ness.proceduresperformed_start_date
HSPI_Sandbox.addressesperiod_start_date
HSPI_Sandbox.allergiesperiod_start_date
HSPI_Sandbox.appointmentsdatetime_start_date
HSPI_Sandbox.care_planseffective_start_date
HSPI_Sandbox.chargesdateOfService_start_date
HSPI_Sandbox.claim_itemsbillablePeriod_start_date
HSPI_Sandbox.claim_supporting_infotimingPeriod_start_date
HSPI_Sandbox.claimsbillablePeriod_start_date
HSPI_Sandbox.conditionsonsetPeriod_start_date
HSPI_Sandbox.coveragesperiod_start_date
HSPI_Sandbox.encounter_occurence_span_codesperiod_start_date
HSPI_Sandbox.encountersperiod_start_date
HSPI_Sandbox.encountersunableToWork_start_date
HSPI_Sandbox.examplesdatetime_start_date
HSPI_Sandbox.family_historybirthPeriod_start_date
HSPI_Sandbox.family_historydeathPeriod_start_date
HSPI_Sandbox.invoicesgenerationPeriod_start_date
HSPI_Sandbox.laboratory_resultseffective_start_date
HSPI_Sandbox.medicationseffective_start_date
HSPI_Sandbox.namesperiod_start_date
HSPI_Sandbox.observationseffective_start_date
HSPI_Sandbox.patient_trackingperiod_start_date
HSPI_Sandbox.patients_authorization_idseffectivePeriod_start_date
HSPI_Sandbox.problemsperiod_start_date
HSPI_Sandbox.proceduresperformed_start_date
HSPI_Summit_General.addressesperiod_start_date
HSPI_Summit_General.allergiesperiod_start_date
HSPI_Summit_General.appointmentsdatetime_start_date
HSPI_Summit_General.care_planseffective_start_date
HSPI_Summit_General.chargesdateOfService_start_date
HSPI_Summit_General.claim_itemsbillablePeriod_start_date
HSPI_Summit_General.claim_supporting_infotimingPeriod_start_date
HSPI_Summit_General.claimsbillablePeriod_start_date
HSPI_Summit_General.conditionsonsetPeriod_start_date
HSPI_Summit_General.coveragesperiod_start_date
HSPI_Summit_General.encounter_occurence_span_codesperiod_start_date
HSPI_Summit_General.encountersperiod_start_date
HSPI_Summit_General.encountersunableToWork_start_date
HSPI_Summit_General.examplesdatetime_start_date
HSPI_Summit_General.family_historybirthPeriod_start_date
HSPI_Summit_General.family_historydeathPeriod_start_date
HSPI_Summit_General.invoicesgenerationPeriod_start_date
HSPI_Summit_General.laboratory_resultseffective_start_date
HSPI_Summit_General.medicationseffective_start_date
HSPI_Summit_General.namesperiod_start_date
HSPI_Summit_General.observationseffective_start_date
HSPI_Summit_General.patient_trackingperiod_start_date
HSPI_Summit_General.patients_authorization_idseffectivePeriod_start_date
HSPI_Summit_General.problemsperiod_start_date
HSPI_Summit_General.proceduresperformed_start_date
HSPI_System.addressesperiod_start_date
HSPI_United_Physicians.addressesperiod_start_date
HSPI_United_Physicians.allergiesperiod_start_date
HSPI_United_Physicians.appointmentsdatetime_start_date
HSPI_United_Physicians.care_planseffective_start_date
HSPI_United_Physicians.chargesdateOfService_start_date
HSPI_United_Physicians.claim_itemsbillablePeriod_start_date
HSPI_United_Physicians.claim_supporting_infotimingPeriod_start_date
HSPI_United_Physicians.claimsbillablePeriod_start_date
HSPI_United_Physicians.conditionsonsetPeriod_start_date
HSPI_United_Physicians.coveragesperiod_start_date
HSPI_United_Physicians.encounter_occurence_span_codesperiod_start_date
HSPI_United_Physicians.encountersperiod_start_date
HSPI_United_Physicians.encountersunableToWork_start_date
HSPI_United_Physicians.examplesdatetime_start_date
HSPI_United_Physicians.family_historybirthPeriod_start_date
HSPI_United_Physicians.family_historydeathPeriod_start_date
HSPI_United_Physicians.invoicesgenerationPeriod_start_date
HSPI_United_Physicians.laboratory_resultseffective_start_date
HSPI_United_Physicians.medicationseffective_start_date
HSPI_United_Physicians.namesperiod_start_date
HSPI_United_Physicians.observationseffective_start_date
HSPI_United_Physicians.patient_trackingperiod_start_date
HSPI_United_Physicians.patients_authorization_idseffectivePeriod_start_date
HSPI_United_Physicians.problemsperiod_start_date
HSPI_United_Physicians.proceduresperformed_start_date
MPI.addressesperiod_start_date
MPI.allergiesperiod_start_date
MPI.appointmentsdatetime_start_date
MPI.care_planseffective_start_date
MPI.chargesdateOfService_start_date
MPI.claim_itemsbillablePeriod_start_date
MPI.claim_supporting_infotimingPeriod_start_date
MPI.claimsbillablePeriod_start_date
MPI.conditionsonsetPeriod_start_date
MPI.coveragesperiod_start_date
MPI.encounter_occurence_span_codesperiod_start_date
MPI.encountersperiod_start_date
MPI.encountersunableToWork_start_date
MPI.examplesdatetime_start_date
MPI.family_historybirthPeriod_start_date
MPI.family_historydeathPeriod_start_date
MPI.invoicesgenerationPeriod_start_date
MPI.laboratory_resultseffective_start_date
MPI.medicationseffective_start_date
MPI.namesperiod_start_date
MPI.observationseffective_start_date
MPI.patient_trackingperiod_start_date
MPI.patients_authorization_idseffectivePeriod_start_date
MPI.problemsperiod_start_date
MPI.proceduresperformed_start_date
SSO.login_notificationsperiod_start_date
SSO.namesperiod_start_date
_1.charts_medicationscm_start_date
_1.encountersenc_ins1_start_date
_1.encountersenc_ins1_referral_start_date
_1.encountersenc_ins2_start_date
_1.encountersenc_ins3_start_date
_1.insurances_repositoryirep_ins_start_date
_1.insurances_repositoryirep_ins_referral_start_date
_1.patientspat_ins1_start_date
_1.patientspat_ins1_referral_start_date
_1.patientspat_ins2_start_date
_1.patientspat_ins3_start_date
_1.patients_configured_encounters_schedulespces_start_date
_1.patients_demographics_snapshotspds_ins1_start_date
_1.patients_demographics_snapshotspds_ins1_referral_start_date
_1.patients_demographics_snapshotspds_ins2_start_date
_1.patients_demographics_snapshotspds_ins3_start_date
_1.patients_medicationspms_start_date
_1.patients_payments_schedulespps_start_date
_1.precertspre_ins1_start_date
_1.precertspre_ins1_referral_start_date
_1.precertspre_ins2_start_date
_1188.charts_medicationscm_start_date
_1188.encountersenc_ins1_start_date
_1188.encountersenc_ins1_referral_start_date
_1188.encountersenc_ins2_start_date
_1188.encountersenc_ins3_start_date
_1188.insurances_repositoryirep_ins_start_date
_1188.insurances_repositoryirep_ins_referral_start_date
_1188.patientspat_ins1_start_date
_1188.patientspat_ins1_referral_start_date
_1188.patientspat_ins2_start_date
_1188.patientspat_ins3_start_date
_1188.patients_configured_encounters_schedulespces_start_date
_1188.patients_demographics_snapshotspds_ins1_start_date
_1188.patients_demographics_snapshotspds_ins1_referral_start_date
_1188.patients_demographics_snapshotspds_ins2_start_date
_1188.patients_demographics_snapshotspds_ins3_start_date
_1188.patients_medicationspms_start_date
_1188.patients_payments_schedulespps_start_date
_1188.precertspre_ins1_start_date
_1188.precertspre_ins1_referral_start_date
_1188.precertspre_ins2_start_date
_1218.charts_medicationscm_start_date
_1218.encountersenc_ins1_start_date
_1218.encountersenc_ins1_referral_start_date
_1218.encountersenc_ins2_start_date
_1218.encountersenc_ins3_start_date
_1218.insurances_repositoryirep_ins_start_date
_1218.insurances_repositoryirep_ins_referral_start_date
_1218.patientspat_ins1_start_date
_1218.patientspat_ins1_referral_start_date
_1218.patientspat_ins2_start_date
_1218.patientspat_ins3_start_date
_1218.patients_configured_encounters_schedulespces_start_date
_1218.patients_demographics_snapshotspds_ins1_start_date
_1218.patients_demographics_snapshotspds_ins1_referral_start_date
_1218.patients_demographics_snapshotspds_ins2_start_date
_1218.patients_demographics_snapshotspds_ins3_start_date
_1218.patients_medicationspms_start_date
_1218.patients_payments_schedulespps_start_date
_1218.precertspre_ins1_start_date
_1218.precertspre_ins1_referral_start_date
_1218.precertspre_ins2_start_date
_1548.charts_medicationscm_start_date
_1548.encountersenc_ins1_start_date
_1548.encountersenc_ins1_referral_start_date
_1548.encountersenc_ins2_start_date
_1548.encountersenc_ins3_start_date
_1548.insurances_repositoryirep_ins_start_date
_1548.insurances_repositoryirep_ins_referral_start_date
_1548.patientspat_ins1_start_date
_1548.patientspat_ins1_referral_start_date
_1548.patientspat_ins2_start_date
_1548.patientspat_ins3_start_date
_1548.patients_configured_encounters_schedulespces_start_date
_1548.patients_demographics_snapshotspds_ins1_start_date
_1548.patients_demographics_snapshotspds_ins1_referral_start_date
_1548.patients_demographics_snapshotspds_ins2_start_date
_1548.patients_demographics_snapshotspds_ins3_start_date
_1548.patients_medicationspms_start_date
_1548.patients_payments_schedulespps_start_date
_1548.precertspre_ins1_start_date
_1548.precertspre_ins1_referral_start_date
_1548.precertspre_ins2_start_date
_435.charts_medicationscm_start_date
_435.encountersenc_ins1_start_date
_435.encountersenc_ins1_referral_start_date
_435.encountersenc_ins2_start_date
_435.encountersenc_ins3_start_date
_435.insurances_repositoryirep_ins_start_date
_435.insurances_repositoryirep_ins_referral_start_date
_435.patientspat_ins1_start_date
_435.patientspat_ins1_referral_start_date
_435.patientspat_ins2_start_date
_435.patientspat_ins3_start_date
_435.patients_configured_encounters_schedulespces_start_date
_435.patients_demographics_snapshotspds_ins1_start_date
_435.patients_demographics_snapshotspds_ins1_referral_start_date
_435.patients_demographics_snapshotspds_ins2_start_date
_435.patients_demographics_snapshotspds_ins3_start_date
_435.patients_medicationspms_start_date
_435.patients_payments_schedulespps_start_date
_435.precertspre_ins1_start_date
_435.precertspre_ins1_referral_start_date
_435.precertspre_ins2_start_date
_436.charts_medicationscm_start_date
_436.encountersenc_ins1_start_date
_436.encountersenc_ins1_referral_start_date
_436.encountersenc_ins2_start_date
_436.encountersenc_ins3_start_date
_436.insurances_repositoryirep_ins_start_date
_436.insurances_repositoryirep_ins_referral_start_date
_436.patientspat_ins1_start_date
_436.patientspat_ins1_referral_start_date
_436.patientspat_ins2_start_date
_436.patientspat_ins3_start_date
_436.patients_configured_encounters_schedulespces_start_date
_436.patients_demographics_snapshotspds_ins1_start_date
_436.patients_demographics_snapshotspds_ins1_referral_start_date
_436.patients_demographics_snapshotspds_ins2_start_date
_436.patients_demographics_snapshotspds_ins3_start_date
_436.patients_medicationspms_start_date
_436.patients_payments_schedulespps_start_date
_436.precertspre_ins1_start_date
_436.precertspre_ins1_referral_start_date
_436.precertspre_ins2_start_date
_436_archive_testing.charts_medicationscm_start_date
_436_archive_testing.encountersenc_ins1_start_date
_436_archive_testing.encountersenc_ins1_referral_start_date
_436_archive_testing.encountersenc_ins2_start_date
_436_archive_testing.encountersenc_ins3_start_date
_436_archive_testing.insurances_repositoryirep_ins_start_date
_436_archive_testing.insurances_repositoryirep_ins_referral_start_date
_436_archive_testing.patientspat_ins1_start_date
_436_archive_testing.patientspat_ins1_referral_start_date
_436_archive_testing.patientspat_ins2_start_date
_436_archive_testing.patientspat_ins3_start_date
_436_archive_testing.patients_configured_encounters_schedulespces_start_date
_436_archive_testing.patients_demographics_snapshotspds_ins1_start_date
_436_archive_testing.patients_demographics_snapshotspds_ins1_referral_start_date
_436_archive_testing.patients_demographics_snapshotspds_ins2_start_date
_436_archive_testing.patients_demographics_snapshotspds_ins3_start_date
_436_archive_testing.patients_medicationspms_start_date
_436_archive_testing.patients_payments_schedulespps_start_date
_436_archive_testing.precertspre_ins1_start_date
_436_archive_testing.precertspre_ins1_referral_start_date
_436_archive_testing.precertspre_ins2_start_date
_437.charts_medicationscm_start_date
_437.encountersenc_ins1_start_date
_437.encountersenc_ins1_referral_start_date
_437.encountersenc_ins2_start_date
_437.encountersenc_ins3_start_date
_437.insurances_repositoryirep_ins_start_date
_437.insurances_repositoryirep_ins_referral_start_date
_437.patientspat_ins1_start_date
_437.patientspat_ins1_referral_start_date
_437.patientspat_ins2_start_date
_437.patientspat_ins3_start_date
_437.patients_configured_encounters_schedulespces_start_date
_437.patients_demographics_snapshotspds_ins1_start_date
_437.patients_demographics_snapshotspds_ins1_referral_start_date
_437.patients_demographics_snapshotspds_ins2_start_date
_437.patients_demographics_snapshotspds_ins3_start_date
_437.patients_medicationspms_start_date
_437.patients_payments_schedulespps_start_date
_437.precertspre_ins1_start_date
_437.precertspre_ins1_referral_start_date
_437.precertspre_ins2_start_date
_8.charts_medicationscm_start_date
_8.encountersenc_ins1_start_date
_8.encountersenc_ins1_referral_start_date
_8.encountersenc_ins2_start_date
_8.encountersenc_ins3_start_date
_8.insurances_repositoryirep_ins_start_date
_8.insurances_repositoryirep_ins_referral_start_date
_8.patientspat_ins1_start_date
_8.patientspat_ins1_referral_start_date
_8.patientspat_ins2_start_date
_8.patientspat_ins3_start_date
_8.patients_configured_encounters_schedulespces_start_date
_8.patients_demographics_snapshotspds_ins1_start_date
_8.patients_demographics_snapshotspds_ins1_referral_start_date
_8.patients_demographics_snapshotspds_ins2_start_date
_8.patients_demographics_snapshotspds_ins3_start_date
_8.patients_medicationspms_start_date
_8.patients_payments_schedulespps_start_date
_8.precertspre_ins1_start_date
_8.precertspre_ins1_referral_start_date
_8.precertspre_ins2_start_date
_81.charts_medicationscm_start_date
_81.encountersenc_ins1_start_date
_81.encountersenc_ins1_referral_start_date
_81.encountersenc_ins2_start_date
_81.encountersenc_ins3_start_date
_81.insurances_repositoryirep_ins_start_date
_81.insurances_repositoryirep_ins_referral_start_date
_81.patientspat_ins1_start_date
_81.patientspat_ins1_referral_start_date
_81.patientspat_ins2_start_date
_81.patientspat_ins3_start_date
_81.patients_configured_encounters_schedulespces_start_date
_81.patients_demographics_snapshotspds_ins1_start_date
_81.patients_demographics_snapshotspds_ins1_referral_start_date
_81.patients_demographics_snapshotspds_ins2_start_date
_81.patients_demographics_snapshotspds_ins3_start_date
_81.patients_medicationspms_start_date
_81.patients_payments_schedulespps_start_date
_81.precertspre_ins1_start_date
_81.precertspre_ins1_referral_start_date
_81.precertspre_ins2_start_date
_999.charts_medicationscm_start_date
_999.encountersenc_ins1_start_date
_999.encountersenc_ins1_referral_start_date
_999.encountersenc_ins2_start_date
_999.encountersenc_ins3_start_date
_999.insurances_repositoryirep_ins_start_date
_999.insurances_repositoryirep_ins_referral_start_date
_999.patientspat_ins1_start_date
_999.patientspat_ins1_referral_start_date
_999.patientspat_ins2_start_date
_999.patientspat_ins3_start_date
_999.patients_configured_encounters_schedulespces_start_date
_999.patients_demographics_snapshotspds_ins1_start_date
_999.patients_demographics_snapshotspds_ins1_referral_start_date
_999.patients_demographics_snapshotspds_ins2_start_date
_999.patients_demographics_snapshotspds_ins3_start_date
_999.patients_medicationspms_start_date
_999.patients_payments_schedulespps_start_date
_999.precertspre_ins1_start_date
_999.precertspre_ins1_referral_start_date
_999.precertspre_ins2_start_date
aurora_standard.chpinsrcinsrv_start_date
aurora_standard.chqlicndlic_start_date
aurora_standard.stfsyears_start_date
aurora_standard.stmaintdmaint_start_date
aurora_standard.styuimmeqtr_start_date
common.cqm_trackingcqmt_reporting_start_date
common.cqm_trackingcqmt_measurment_start_date
common.poverty_guidelinespovg_start_date
period
TableColumn
HSPI_Bastrop.medication_requestsdispense_period_start_date
HSPI_CURES2015_B1.medication_requestsdispense_period_start_date
HSPI_Central_Hospital.medication_requestsdispense_period_start_date
HSPI_Dewitt.medication_requestsdispense_period_start_date
HSPI_Fulton.medication_requestsdispense_period_start_date
HSPI_Inferno.medication_requestsdispense_period_start_date
HSPI_MU2015_E1.medication_requestsdispense_period_start_date
HSPI_MU2015_G2.medication_requestsdispense_period_start_date
HSPI_MU2015_G9.medication_requestsdispense_period_start_date
HSPI_Sandbox.medication_requestsdispense_period_start_date
HSPI_Summit_General.medication_requestsdispense_period_start_date
HSPI_United_Physicians.medication_requestsdispense_period_start_date
MPI.medication_requestsdispense_period_start_date
aurora_standard.logdetldacct_period
aurora_standard.stgactvvacct_period
aurora_standard.stgcntrccurr_period
aurora_standard.stgcolpdcod_beg_period
aurora_standard.stgcolpdcod_end_period
aurora_standard.stgtranracct_period
aurora_standard.stgtranvacct_period
aurora_standard.stgwhsedacct_period
aurora_standard.stydeddvacct_period
aurora_standard.styemplrpay_period
aurora_standard.styincdvacct_period
aurora_standard.styobldvacct_period
aurora_standard.stypaydtend_of_period
aurora_standard.stytaxtdpay_period
aurora_standard.stytyperpay_period
aurora_standard.styuimmerpt_period
common.users_permissionsupr_invoice_close_period