aurora_standard.oeorder

Field Type Null Default Key Extra Comment
order_id int(11) NO PRI auto_increment
visit_no int(11) YES
grp_id smallint(6) YES
subgrp_id smallint(6) YES
itm_id int(11) YES
service_code varchar(10) YES
cpt_code varchar(10) YES
itm_desc varchar(30) YES
order_status char(1) YES
order_units int(11) YES
order_date date YES
order_time time YES
order_by int(11) YES
procedure_date date YES
procedure_time time YES
finished_date date YES
finished_time time YES
finished_by int(11) YES
phy_number int(11) YES
urg_id smallint(6) YES
medical_nec char(4) YES
order_reason varchar(255) YES
batch_id char(10) YES
rev_date date YES
rev_time time YES
orgitm_id int(11) YES
orgservice_code varchar(10) YES
rev_by varchar(255) YES

References

Local Column References
batch_id
TableColumn
HSPI_Bastrop.chargescharge_batch_id
HSPI_Bastrop.claim_itemsclaim_batch_id
HSPI_Bastrop.claimsclaim_batch_id
HSPI_Bastrop.invoice_batches_facilities_mapinvoice_batch_id
HSPI_Bastrop.invoicesinvoice_batch_id
HSPI_Bastrop.transactionstransaction_batch_id
HSPI_CURES2015_B1.chargescharge_batch_id
HSPI_CURES2015_B1.claim_itemsclaim_batch_id
HSPI_CURES2015_B1.claimsclaim_batch_id
HSPI_CURES2015_B1.claims_claim_batches_mapclaim_batch_id
HSPI_CURES2015_B1.fa_transaction_wrapperstransaction_batch_id
HSPI_CURES2015_B1.invoice_batches_facilities_mapinvoice_batch_id
HSPI_CURES2015_B1.invoicesinvoice_batch_id
HSPI_CURES2015_B1.transaction_batch_financial_accountstransaction_batch_id
HSPI_CURES2015_B1.transactionstransaction_batch_id
HSPI_Central_Hospital.chargescharge_batch_id
HSPI_Central_Hospital.claim_filesclaim_batch_id
HSPI_Central_Hospital.claim_itemsclaim_batch_id
HSPI_Central_Hospital.claimsclaim_batch_id
HSPI_Central_Hospital.claims_claim_batches_mapclaim_batch_id
HSPI_Central_Hospital.fa_transaction_wrapperstransaction_batch_id
HSPI_Central_Hospital.invoice_batches_facilities_mapinvoice_batch_id
HSPI_Central_Hospital.invoicesinvoice_batch_id
HSPI_Central_Hospital.transaction_batch_financial_accountstransaction_batch_id
HSPI_Central_Hospital.transactionstransaction_batch_id
HSPI_Dewitt.chargescharge_batch_id
HSPI_Dewitt.claim_filesclaim_batch_id
HSPI_Dewitt.claim_itemsclaim_batch_id
HSPI_Dewitt.claimsclaim_batch_id
HSPI_Dewitt.claims_claim_batches_mapclaim_batch_id
HSPI_Dewitt.fa_transaction_wrapperstransaction_batch_id
HSPI_Dewitt.invoice_batches_facilities_mapinvoice_batch_id
HSPI_Dewitt.invoicesinvoice_batch_id
HSPI_Dewitt.transaction_batch_financial_accountstransaction_batch_id
HSPI_Dewitt.transactionstransaction_batch_id
HSPI_Fulton.chargescharge_batch_id
HSPI_Fulton.claim_filesclaim_batch_id
HSPI_Fulton.claim_itemsclaim_batch_id
HSPI_Fulton.claimsclaim_batch_id
HSPI_Fulton.claims_claim_batches_mapclaim_batch_id
HSPI_Fulton.fa_transaction_wrapperstransaction_batch_id
HSPI_Fulton.invoice_batches_facilities_mapinvoice_batch_id
HSPI_Fulton.invoicesinvoice_batch_id
HSPI_Fulton.transaction_batch_financial_accountstransaction_batch_id
HSPI_Fulton.transactionstransaction_batch_id
HSPI_Inferno.chargescharge_batch_id
HSPI_Inferno.claim_filesclaim_batch_id
HSPI_Inferno.claim_itemsclaim_batch_id
HSPI_Inferno.claimsclaim_batch_id
HSPI_Inferno.claims_claim_batches_mapclaim_batch_id
HSPI_Inferno.fa_transaction_wrapperstransaction_batch_id
HSPI_Inferno.invoice_batches_facilities_mapinvoice_batch_id
HSPI_Inferno.invoicesinvoice_batch_id
HSPI_Inferno.transaction_batch_financial_accountstransaction_batch_id
HSPI_Inferno.transactionstransaction_batch_id
HSPI_MU2015_E1.chargescharge_batch_id
HSPI_MU2015_E1.claim_filesclaim_batch_id
HSPI_MU2015_E1.claim_itemsclaim_batch_id
HSPI_MU2015_E1.claimsclaim_batch_id
HSPI_MU2015_E1.claims_claim_batches_mapclaim_batch_id
HSPI_MU2015_E1.fa_transaction_wrapperstransaction_batch_id
HSPI_MU2015_E1.invoice_batches_facilities_mapinvoice_batch_id
HSPI_MU2015_E1.invoicesinvoice_batch_id
HSPI_MU2015_E1.transaction_batch_financial_accountstransaction_batch_id
HSPI_MU2015_E1.transactionstransaction_batch_id
HSPI_MU2015_G2.chargescharge_batch_id
HSPI_MU2015_G2.claim_filesclaim_batch_id
HSPI_MU2015_G2.claim_itemsclaim_batch_id
HSPI_MU2015_G2.claimsclaim_batch_id
HSPI_MU2015_G2.claims_claim_batches_mapclaim_batch_id
HSPI_MU2015_G2.fa_transaction_wrapperstransaction_batch_id
HSPI_MU2015_G2.invoice_batches_facilities_mapinvoice_batch_id
HSPI_MU2015_G2.invoicesinvoice_batch_id
HSPI_MU2015_G2.transaction_batch_financial_accountstransaction_batch_id
HSPI_MU2015_G2.transactionstransaction_batch_id
HSPI_MU2015_G9.chargescharge_batch_id
HSPI_MU2015_G9.claim_filesclaim_batch_id
HSPI_MU2015_G9.claim_itemsclaim_batch_id
HSPI_MU2015_G9.claimsclaim_batch_id
HSPI_MU2015_G9.claims_claim_batches_mapclaim_batch_id
HSPI_MU2015_G9.fa_transaction_wrapperstransaction_batch_id
HSPI_MU2015_G9.invoice_batches_facilities_mapinvoice_batch_id
HSPI_MU2015_G9.invoicesinvoice_batch_id
HSPI_MU2015_G9.transaction_batch_financial_accountstransaction_batch_id
HSPI_MU2015_G9.transactionstransaction_batch_id
HSPI_Sandbox.chargescharge_batch_id
HSPI_Sandbox.claim_filesclaim_batch_id
HSPI_Sandbox.claim_itemsclaim_batch_id
HSPI_Sandbox.claimsclaim_batch_id
HSPI_Sandbox.claims_claim_batches_mapclaim_batch_id
HSPI_Sandbox.fa_transaction_wrapperstransaction_batch_id
HSPI_Sandbox.invoice_batches_facilities_mapinvoice_batch_id
HSPI_Sandbox.invoicesinvoice_batch_id
HSPI_Sandbox.transaction_batch_financial_accountstransaction_batch_id
HSPI_Sandbox.transactionstransaction_batch_id
HSPI_Summit_General.chargescharge_batch_id
HSPI_Summit_General.claim_filesclaim_batch_id
HSPI_Summit_General.claim_itemsclaim_batch_id
HSPI_Summit_General.claimsclaim_batch_id
HSPI_Summit_General.claims_claim_batches_mapclaim_batch_id
HSPI_Summit_General.fa_transaction_wrapperstransaction_batch_id
HSPI_Summit_General.invoice_batches_facilities_mapinvoice_batch_id
HSPI_Summit_General.invoicesinvoice_batch_id
HSPI_Summit_General.transaction_batch_financial_accountstransaction_batch_id
HSPI_Summit_General.transactionstransaction_batch_id
HSPI_United_Physicians.chargescharge_batch_id
HSPI_United_Physicians.claim_filesclaim_batch_id
HSPI_United_Physicians.claim_itemsclaim_batch_id
HSPI_United_Physicians.claimsclaim_batch_id
HSPI_United_Physicians.claims_claim_batches_mapclaim_batch_id
HSPI_United_Physicians.fa_transaction_wrapperstransaction_batch_id
HSPI_United_Physicians.invoice_batches_facilities_mapinvoice_batch_id
HSPI_United_Physicians.invoicesinvoice_batch_id
HSPI_United_Physicians.transaction_batch_financial_accountstransaction_batch_id
HSPI_United_Physicians.transactionstransaction_batch_id
MPI.chargescharge_batch_id
MPI.claim_filesclaim_batch_id
MPI.claim_itemsclaim_batch_id
MPI.claimsclaim_batch_id
MPI.claims_claim_batches_mapclaim_batch_id
MPI.fa_transaction_wrapperstransaction_batch_id
MPI.invoice_batches_facilities_mapinvoice_batch_id
MPI.invoicesinvoice_batch_id
MPI.transaction_batch_financial_accountstransaction_batch_id
MPI.transactionstransaction_batch_id
aurora_standard.hl7ft1trans_batch_id
xlnt.selenium_test_queueselenium_test_batch_id
order_id
TableColumn
HSPI_Bastrop.laboratory_order_diagnoses_maplaboratory_order_id
HSPI_Bastrop.laboratory_order_specimens_maplaboratory_order_id
HSPI_Bastrop.laboratory_resultslaboratory_order_id
HSPI_CURES2015_B1.care_plan_activitieslaboratory_order_id
HSPI_CURES2015_B1.laboratory_order_diagnoses_maplaboratory_order_id
HSPI_CURES2015_B1.laboratory_order_specimens_maplaboratory_order_id
HSPI_CURES2015_B1.laboratory_resultslaboratory_order_id
HSPI_Central_Hospital.care_plan_activitieslaboratory_order_id
HSPI_Central_Hospital.laboratory_order_diagnoses_maplaboratory_order_id
HSPI_Central_Hospital.laboratory_order_specimens_maplaboratory_order_id
HSPI_Central_Hospital.laboratory_resultslaboratory_order_id
HSPI_Dewitt.care_plan_activitieslaboratory_order_id
HSPI_Dewitt.laboratory_order_diagnoses_maplaboratory_order_id
HSPI_Dewitt.laboratory_order_specimens_maplaboratory_order_id
HSPI_Dewitt.laboratory_resultslaboratory_order_id
HSPI_Fulton.care_plan_activitieslaboratory_order_id
HSPI_Fulton.laboratory_order_diagnoses_maplaboratory_order_id
HSPI_Fulton.laboratory_order_specimens_maplaboratory_order_id
HSPI_Fulton.laboratory_resultslaboratory_order_id
HSPI_Inferno.care_plan_activitieslaboratory_order_id
HSPI_Inferno.laboratory_order_diagnoses_maplaboratory_order_id
HSPI_Inferno.laboratory_order_specimens_maplaboratory_order_id
HSPI_Inferno.laboratory_resultslaboratory_order_id
HSPI_MU2015_E1.care_plan_activitieslaboratory_order_id
HSPI_MU2015_E1.laboratory_order_diagnoses_maplaboratory_order_id
HSPI_MU2015_E1.laboratory_order_specimens_maplaboratory_order_id
HSPI_MU2015_E1.laboratory_resultslaboratory_order_id
HSPI_MU2015_G2.care_plan_activitieslaboratory_order_id
HSPI_MU2015_G2.laboratory_order_diagnoses_maplaboratory_order_id
HSPI_MU2015_G2.laboratory_order_specimens_maplaboratory_order_id
HSPI_MU2015_G2.laboratory_resultslaboratory_order_id
HSPI_MU2015_G9.care_plan_activitieslaboratory_order_id
HSPI_MU2015_G9.laboratory_order_diagnoses_maplaboratory_order_id
HSPI_MU2015_G9.laboratory_order_specimens_maplaboratory_order_id
HSPI_MU2015_G9.laboratory_resultslaboratory_order_id
HSPI_Ness.laboratory_order_diagnoses_maplaboratory_order_id
HSPI_Ness.laboratory_order_specimens_maplaboratory_order_id
HSPI_Ness.laboratory_resultslaboratory_order_id
HSPI_Sandbox.care_plan_activitieslaboratory_order_id
HSPI_Sandbox.laboratory_order_diagnoses_maplaboratory_order_id
HSPI_Sandbox.laboratory_order_specimens_maplaboratory_order_id
HSPI_Sandbox.laboratory_resultslaboratory_order_id
HSPI_Summit_General.care_plan_activitieslaboratory_order_id
HSPI_Summit_General.laboratory_order_diagnoses_maplaboratory_order_id
HSPI_Summit_General.laboratory_order_specimens_maplaboratory_order_id
HSPI_Summit_General.laboratory_resultslaboratory_order_id
HSPI_United_Physicians.care_plan_activitieslaboratory_order_id
HSPI_United_Physicians.laboratory_order_diagnoses_maplaboratory_order_id
HSPI_United_Physicians.laboratory_order_specimens_maplaboratory_order_id
HSPI_United_Physicians.laboratory_resultslaboratory_order_id
MPI.care_plan_activitieslaboratory_order_id
MPI.laboratory_order_diagnoses_maplaboratory_order_id
MPI.laboratory_order_specimens_maplaboratory_order_id
MPI.laboratory_resultslaboratory_order_id
_1.hl7_ordersord_order_id
_1.labs_orderslo_order_id
_1188.hl7_ordersord_order_id
_1188.labs_orderslo_order_id
_1218.hl7_ordersord_order_id
_1218.labs_orderslo_order_id
_1548.hl7_ordersord_order_id
_1548.labs_orderslo_order_id
_435.hl7_ordersord_order_id
_435.labs_orderslo_order_id
_436.hl7_ordersord_order_id
_436.labs_orderslo_order_id
_436_archive_testing.hl7_ordersord_order_id
_436_archive_testing.labs_orderslo_order_id
_437.hl7_ordersord_order_id
_437.labs_orderslo_order_id
_8.hl7_ordersord_order_id
_8.labs_orderslo_order_id
_81.hl7_ordersord_order_id
_81.labs_orderslo_order_id
_999.hl7_ordersord_order_id
_999.labs_orderslo_order_id
order_status
TableColumn
HSPI_Bastrop.laboratory_orderslaboratory_order_status
HSPI_CURES2015_B1.laboratory_orderslaboratory_order_status
HSPI_Central_Hospital.laboratory_orderslaboratory_order_status
HSPI_Dewitt.laboratory_orderslaboratory_order_status
HSPI_Fulton.laboratory_orderslaboratory_order_status
HSPI_Inferno.laboratory_orderslaboratory_order_status
HSPI_MU2015_E1.laboratory_orderslaboratory_order_status
HSPI_MU2015_G2.laboratory_orderslaboratory_order_status
HSPI_MU2015_G9.laboratory_orderslaboratory_order_status
HSPI_Ness.laboratory_orderslaboratory_order_status
HSPI_Sandbox.laboratory_orderslaboratory_order_status
HSPI_Summit_General.laboratory_orderslaboratory_order_status
HSPI_United_Physicians.laboratory_orderslaboratory_order_status
MPI.laboratory_orderslaboratory_order_status
cpt_code
TableColumn
Loinc.loinc_codeslc_cpt_code
_1.clients_fee_schedules_mapcfsm_cpt_code
_1.clinical_interventions_test_codes_mapcitcm_cpt_code
_1.immunizations_cpt_mapicm_cpt_code
_1.insurances_allowables_cpt_mapiacm_cpt_code
_1.insurances_contracted_pricingicp_cpt_code
_1.insurances_contracted_pricing_logicpl_cpt_code
_1.patients_responsibility_estimates_servicesprests_cpt_code
_1188.clients_fee_schedules_mapcfsm_cpt_code
_1188.clinical_interventions_test_codes_mapcitcm_cpt_code
_1188.immunizations_cpt_mapicm_cpt_code
_1188.insurances_allowables_cpt_mapiacm_cpt_code
_1188.insurances_contracted_pricingicp_cpt_code
_1188.insurances_contracted_pricing_logicpl_cpt_code
_1188.patients_responsibility_estimates_servicesprests_cpt_code
_1218.clients_fee_schedules_mapcfsm_cpt_code
_1218.clinical_interventions_test_codes_mapcitcm_cpt_code
_1218.immunizations_cpt_mapicm_cpt_code
_1218.insurances_allowables_cpt_mapiacm_cpt_code
_1218.insurances_contracted_pricingicp_cpt_code
_1218.insurances_contracted_pricing_logicpl_cpt_code
_1218.patients_responsibility_estimates_servicesprests_cpt_code
_1548.clients_fee_schedules_mapcfsm_cpt_code
_1548.clinical_interventions_test_codes_mapcitcm_cpt_code
_1548.immunizations_cpt_mapicm_cpt_code
_1548.insurances_allowables_cpt_mapiacm_cpt_code
_1548.insurances_contracted_pricingicp_cpt_code
_1548.insurances_contracted_pricing_logicpl_cpt_code
_1548.patients_responsibility_estimates_servicesprests_cpt_code
_435.clients_fee_schedules_mapcfsm_cpt_code
_435.clinical_interventions_test_codes_mapcitcm_cpt_code
_435.immunizations_cpt_mapicm_cpt_code
_435.insurances_allowables_cpt_mapiacm_cpt_code
_435.insurances_contracted_pricingicp_cpt_code
_435.insurances_contracted_pricing_logicpl_cpt_code
_435.patients_responsibility_estimates_servicesprests_cpt_code
_436.clients_fee_schedules_mapcfsm_cpt_code
_436.clinical_interventions_test_codes_mapcitcm_cpt_code
_436.immunizations_cpt_mapicm_cpt_code
_436.insurances_allowables_cpt_mapiacm_cpt_code
_436.insurances_contracted_pricingicp_cpt_code
_436.insurances_contracted_pricing_logicpl_cpt_code
_436.patients_responsibility_estimates_servicesprests_cpt_code
_436_archive_testing.clients_fee_schedules_mapcfsm_cpt_code
_436_archive_testing.clinical_interventions_test_codes_mapcitcm_cpt_code
_436_archive_testing.immunizations_cpt_mapicm_cpt_code
_436_archive_testing.insurances_allowables_cpt_mapiacm_cpt_code
_436_archive_testing.insurances_contracted_pricingicp_cpt_code
_436_archive_testing.insurances_contracted_pricing_logicpl_cpt_code
_436_archive_testing.patients_responsibility_estimates_servicesprests_cpt_code
_437.clients_fee_schedules_mapcfsm_cpt_code
_437.clinical_interventions_test_codes_mapcitcm_cpt_code
_437.immunizations_cpt_mapicm_cpt_code
_437.insurances_allowables_cpt_mapiacm_cpt_code
_437.insurances_contracted_pricingicp_cpt_code
_437.insurances_contracted_pricing_logicpl_cpt_code
_437.patients_responsibility_estimates_servicesprests_cpt_code
_8.clients_fee_schedules_mapcfsm_cpt_code
_8.clinical_interventions_test_codes_mapcitcm_cpt_code
_8.immunizations_cpt_mapicm_cpt_code
_8.insurances_allowables_cpt_mapiacm_cpt_code
_8.insurances_contracted_pricingicp_cpt_code
_8.insurances_contracted_pricing_logicpl_cpt_code
_8.patients_responsibility_estimates_servicesprests_cpt_code
_81.clients_fee_schedules_mapcfsm_cpt_code
_81.clinical_interventions_test_codes_mapcitcm_cpt_code
_81.immunizations_cpt_mapicm_cpt_code
_81.insurances_allowables_cpt_mapiacm_cpt_code
_81.insurances_contracted_pricingicp_cpt_code
_81.insurances_contracted_pricing_logicpl_cpt_code
_81.patients_responsibility_estimates_servicesprests_cpt_code
_999.clients_fee_schedules_mapcfsm_cpt_code
_999.clinical_interventions_test_codes_mapcitcm_cpt_code
_999.immunizations_cpt_mapicm_cpt_code
_999.insurances_allowables_cpt_mapiacm_cpt_code
_999.insurances_contracted_pricingicp_cpt_code
_999.insurances_contracted_pricing_logicpl_cpt_code
_999.patients_responsibility_estimates_servicesprests_cpt_code
aurora_standard.axlscdmmd_cpt_code
aurora_standard.axlscdmci_cpt_code
aurora_standard.c5cdmoth_cpt_code
aurora_standard.c5cdmwc_cpt_code
aurora_standard.c5cdmcomm_cpt_code
aurora_standard.c5cdmdroth_cpt_code
aurora_standard.c5cdmdrwc_cpt_code
aurora_standard.c5cdmdrcomm_cpt_code
aurora_standard.c7cdmcomm_cpt_code
aurora_standard.c8cdmcomm_cpt_code
aurora_standard.chmpricaprev_cpt_code
aurora_standard.chmpricacur_cpt_code
aurora_standard.chmpricccomm_cpt_code
aurora_standard.glspricecomm_cpt_code
common.loinc_codeslc_cpt_code
common.mednecmed_cpt_code
common.test_codes_cpttcc_cpt_code
grp_id
TableColumn
Messaging.messages_accessmxs_grp_id
Messaging.messages_access_newmxs_grp_id
Messaging.messages_groupsmg_grp_id
Messaging.messages_groups_membersmgm_grp_id
_1.appointmentsapt_grp_id
_1.appointments_reasonsare_grp_id
_1.charts_care_planccp_assigned_grp_id
_1.clinical_alerts_accesscaa_grp_id
_1.clinical_interventions_groups_mapcigm_grp_id
_1.cpt_quickpickcptqp_grp_id
_1.encounters_soap_templates_accessesta_grp_id
_1.encounters_stored_notes_accessesna_grp_id
_1.groups_membersgms_grp_id
_1.health_maintenance_associationshma_grp_id
_1.patient_access_restrictionpatar_grp_id
_1.patients_historiesph_grp_id
_1.patients_popup_receiversppr_grp_id
_1.patients_referralspref_assigned_grp_id
_1.pi_user_access_mappi_access_grp_id
_1.recalls_reasonsrr_grp_id
_1.recalls_reasons_associationsrra_grp_id
_1.roomsrms_grp_id
_1.taskstask_assign_to_grp_id
_1.tasks_assigned_maptamap_grp_id
_1.tasks_assignmentstaskass_assigned_grp_id
_1.tasks_categoriestcat_grp_id
_1188.appointmentsapt_grp_id
_1188.appointments_reasonsare_grp_id
_1188.charts_care_planccp_assigned_grp_id
_1188.clinical_alerts_accesscaa_grp_id
_1188.clinical_interventions_groups_mapcigm_grp_id
_1188.cpt_quickpickcptqp_grp_id
_1188.encounters_soap_templates_accessesta_grp_id
_1188.encounters_stored_notes_accessesna_grp_id
_1188.groups_membersgms_grp_id
_1188.health_maintenance_associationshma_grp_id
_1188.patient_access_restrictionpatar_grp_id
_1188.patients_historiesph_grp_id
_1188.patients_popup_receiversppr_grp_id
_1188.patients_referralspref_assigned_grp_id
_1188.pi_user_access_mappi_access_grp_id
_1188.recalls_reasonsrr_grp_id
_1188.recalls_reasons_associationsrra_grp_id
_1188.roomsrms_grp_id
_1188.taskstask_assign_to_grp_id
_1188.tasks_assigned_maptamap_grp_id
_1188.tasks_assignmentstaskass_assigned_grp_id
_1188.tasks_categoriestcat_grp_id
_1218.appointmentsapt_grp_id
_1218.appointments_reasonsare_grp_id
_1218.charts_care_planccp_assigned_grp_id
_1218.clinical_alerts_accesscaa_grp_id
_1218.clinical_interventions_groups_mapcigm_grp_id
_1218.cpt_quickpickcptqp_grp_id
_1218.encounters_soap_templates_accessesta_grp_id
_1218.encounters_stored_notes_accessesna_grp_id
_1218.groups_membersgms_grp_id
_1218.health_maintenance_associationshma_grp_id
_1218.patient_access_restrictionpatar_grp_id
_1218.patients_historiesph_grp_id
_1218.patients_popup_receiversppr_grp_id
_1218.patients_referralspref_assigned_grp_id
_1218.pi_user_access_mappi_access_grp_id
_1218.recalls_reasonsrr_grp_id
_1218.recalls_reasons_associationsrra_grp_id
_1218.roomsrms_grp_id
_1218.taskstask_assign_to_grp_id
_1218.tasks_assigned_maptamap_grp_id
_1218.tasks_assignmentstaskass_assigned_grp_id
_1218.tasks_categoriestcat_grp_id
_1548.appointmentsapt_grp_id
_1548.appointments_reasonsare_grp_id
_1548.charts_care_planccp_assigned_grp_id
_1548.clinical_alerts_accesscaa_grp_id
_1548.clinical_interventions_groups_mapcigm_grp_id
_1548.cpt_quickpickcptqp_grp_id
_1548.encounters_soap_templates_accessesta_grp_id
_1548.encounters_stored_notes_accessesna_grp_id
_1548.groups_membersgms_grp_id
_1548.health_maintenance_associationshma_grp_id
_1548.patient_access_restrictionpatar_grp_id
_1548.patients_historiesph_grp_id
_1548.patients_popup_receiversppr_grp_id
_1548.patients_referralspref_assigned_grp_id
_1548.pi_user_access_mappi_access_grp_id
_1548.recalls_reasonsrr_grp_id
_1548.recalls_reasons_associationsrra_grp_id
_1548.roomsrms_grp_id
_1548.taskstask_assign_to_grp_id
_1548.tasks_assigned_maptamap_grp_id
_1548.tasks_assignmentstaskass_assigned_grp_id
_1548.tasks_categoriestcat_grp_id
_435.appointmentsapt_grp_id
_435.appointments_reasonsare_grp_id
_435.charts_care_planccp_assigned_grp_id
_435.clinical_alerts_accesscaa_grp_id
_435.clinical_interventions_groups_mapcigm_grp_id
_435.cpt_quickpickcptqp_grp_id
_435.encounters_soap_templates_accessesta_grp_id
_435.encounters_stored_notes_accessesna_grp_id
_435.groups_membersgms_grp_id
_435.health_maintenance_associationshma_grp_id
_435.patient_access_restrictionpatar_grp_id
_435.patients_historiesph_grp_id
_435.patients_popup_receiversppr_grp_id
_435.patients_referralspref_assigned_grp_id
_435.pi_user_access_mappi_access_grp_id
_435.recalls_reasonsrr_grp_id
_435.recalls_reasons_associationsrra_grp_id
_435.roomsrms_grp_id
_435.taskstask_assign_to_grp_id
_435.tasks_assigned_maptamap_grp_id
_435.tasks_assignmentstaskass_assigned_grp_id
_435.tasks_categoriestcat_grp_id
_436.appointmentsapt_grp_id
_436.appointments_reasonsare_grp_id
_436.charts_care_planccp_assigned_grp_id
_436.clinical_alerts_accesscaa_grp_id
_436.clinical_interventions_groups_mapcigm_grp_id
_436.cpt_quickpickcptqp_grp_id
_436.encounters_soap_templates_accessesta_grp_id
_436.encounters_stored_notes_accessesna_grp_id
_436.groups_membersgms_grp_id
_436.health_maintenance_associationshma_grp_id
_436.patient_access_restrictionpatar_grp_id
_436.patients_historiesph_grp_id
_436.patients_popup_receiversppr_grp_id
_436.patients_referralspref_assigned_grp_id
_436.pi_user_access_mappi_access_grp_id
_436.recalls_reasonsrr_grp_id
_436.recalls_reasons_associationsrra_grp_id
_436.roomsrms_grp_id
_436.taskstask_assign_to_grp_id
_436.tasks_assigned_maptamap_grp_id
_436.tasks_assignmentstaskass_assigned_grp_id
_436.tasks_categoriestcat_grp_id
_436_archive_testing.appointmentsapt_grp_id
_436_archive_testing.appointments_reasonsare_grp_id
_436_archive_testing.charts_care_planccp_assigned_grp_id
_436_archive_testing.clinical_alerts_accesscaa_grp_id
_436_archive_testing.clinical_interventions_groups_mapcigm_grp_id
_436_archive_testing.cpt_quickpickcptqp_grp_id
_436_archive_testing.encounters_soap_templates_accessesta_grp_id
_436_archive_testing.encounters_stored_notes_accessesna_grp_id
_436_archive_testing.groups_membersgms_grp_id
_436_archive_testing.health_maintenance_associationshma_grp_id
_436_archive_testing.patient_access_restrictionpatar_grp_id
_436_archive_testing.patients_historiesph_grp_id
_436_archive_testing.patients_popup_receiversppr_grp_id
_436_archive_testing.patients_referralspref_assigned_grp_id
_436_archive_testing.pi_user_access_mappi_access_grp_id
_436_archive_testing.recalls_reasonsrr_grp_id
_436_archive_testing.recalls_reasons_associationsrra_grp_id
_436_archive_testing.roomsrms_grp_id
_436_archive_testing.taskstask_assign_to_grp_id
_436_archive_testing.tasks_assigned_maptamap_grp_id
_436_archive_testing.tasks_assignmentstaskass_assigned_grp_id
_436_archive_testing.tasks_categoriestcat_grp_id
_437.appointmentsapt_grp_id
_437.appointments_reasonsare_grp_id
_437.charts_care_planccp_assigned_grp_id
_437.clinical_alerts_accesscaa_grp_id
_437.clinical_interventions_groups_mapcigm_grp_id
_437.cpt_quickpickcptqp_grp_id
_437.encounters_soap_templates_accessesta_grp_id
_437.encounters_stored_notes_accessesna_grp_id
_437.groups_membersgms_grp_id
_437.health_maintenance_associationshma_grp_id
_437.patient_access_restrictionpatar_grp_id
_437.patients_historiesph_grp_id
_437.patients_popup_receiversppr_grp_id
_437.patients_referralspref_assigned_grp_id
_437.pi_user_access_mappi_access_grp_id
_437.recalls_reasonsrr_grp_id
_437.recalls_reasons_associationsrra_grp_id
_437.roomsrms_grp_id
_437.taskstask_assign_to_grp_id
_437.tasks_assigned_maptamap_grp_id
_437.tasks_assignmentstaskass_assigned_grp_id
_437.tasks_categoriestcat_grp_id
_8.appointmentsapt_grp_id
_8.appointments_reasonsare_grp_id
_8.charts_care_planccp_assigned_grp_id
_8.clinical_alerts_accesscaa_grp_id
_8.clinical_interventions_groups_mapcigm_grp_id
_8.cpt_quickpickcptqp_grp_id
_8.encounters_soap_templates_accessesta_grp_id
_8.encounters_stored_notes_accessesna_grp_id
_8.groups_membersgms_grp_id
_8.health_maintenance_associationshma_grp_id
_8.patient_access_restrictionpatar_grp_id
_8.patients_historiesph_grp_id
_8.patients_popup_receiversppr_grp_id
_8.patients_referralspref_assigned_grp_id
_8.pi_user_access_mappi_access_grp_id
_8.recalls_reasonsrr_grp_id
_8.recalls_reasons_associationsrra_grp_id
_8.roomsrms_grp_id
_8.taskstask_assign_to_grp_id
_8.tasks_assigned_maptamap_grp_id
_8.tasks_assignmentstaskass_assigned_grp_id
_8.tasks_categoriestcat_grp_id
_81.appointmentsapt_grp_id
_81.appointments_reasonsare_grp_id
_81.charts_care_planccp_assigned_grp_id
_81.clinical_alerts_accesscaa_grp_id
_81.clinical_interventions_groups_mapcigm_grp_id
_81.cpt_quickpickcptqp_grp_id
_81.encounters_soap_templates_accessesta_grp_id
_81.encounters_stored_notes_accessesna_grp_id
_81.groups_membersgms_grp_id
_81.health_maintenance_associationshma_grp_id
_81.patient_access_restrictionpatar_grp_id
_81.patients_historiesph_grp_id
_81.patients_popup_receiversppr_grp_id
_81.patients_referralspref_assigned_grp_id
_81.pi_user_access_mappi_access_grp_id
_81.recalls_reasonsrr_grp_id
_81.recalls_reasons_associationsrra_grp_id
_81.roomsrms_grp_id
_81.taskstask_assign_to_grp_id
_81.tasks_assigned_maptamap_grp_id
_81.tasks_assignmentstaskass_assigned_grp_id
_81.tasks_categoriestcat_grp_id
_999.appointmentsapt_grp_id
_999.appointments_reasonsare_grp_id
_999.charts_care_planccp_assigned_grp_id
_999.clinical_alerts_accesscaa_grp_id
_999.clinical_interventions_groups_mapcigm_grp_id
_999.cpt_quickpickcptqp_grp_id
_999.encounters_soap_templates_accessesta_grp_id
_999.encounters_stored_notes_accessesna_grp_id
_999.groups_membersgms_grp_id
_999.health_maintenance_associationshma_grp_id
_999.patient_access_restrictionpatar_grp_id
_999.patients_historiesph_grp_id
_999.patients_popup_receiversppr_grp_id
_999.patients_referralspref_assigned_grp_id
_999.pi_user_access_mappi_access_grp_id
_999.recalls_reasonsrr_grp_id
_999.recalls_reasons_associationsrra_grp_id
_999.roomsrms_grp_id
_999.taskstask_assign_to_grp_id
_999.tasks_assigned_maptamap_grp_id
_999.tasks_assignmentstaskass_assigned_grp_id
_999.tasks_categoriestcat_grp_id
common.configurations_optionsconfopt_grp_id
visit_no
TableColumn
aurora_standard.anotesdan_visit_no
aurora_standard.bdfiledbd_visit_no
aurora_standard.chmarsipat_visit_no
aurora_standard.chmcampipat_visit_no
aurora_standard.chmcombrto_visit_no
aurora_standard.chmexmpipat_visit_no
aurora_standard.chmokipdpat_visit_no
aurora_standard.chmokopdpat_visit_no
aurora_standard.chmradedpat_visit_no
aurora_standard.chmradexpat_visit_no
aurora_standard.chrcombrto_visit_no
aurora_standard.ncexmpipat_visit_no
order_date
TableColumn
aurora_standard.strcustrlast_order_date