aurora_standard.activity_logs

Field Type Null Default Key Extra Comment
chs_rowID int(11) NO PRI auto_increment
title varchar(255) YES
url text NO
options text NO
input_by int(11) NO -1 MUL
from_ip varchar(255) NO ? MUL
from_program varchar(255) YES MUL
access_count int(11) NO 1
session_id varchar(255) NO ? MUL
exit_status varchar(255) NO ?
details text YES
created_at datetime YES MUL
updated_at datetime YES MUL
activity_type varchar(255) NO - MUL

References

Local Column References
url
TableColumn
API.oauth_auth_requestssmart_fhir_url
API.oauth_smart_launchsmart_fhir_url
API.request_logs_v2http_url
AzaleaStats.login_eventsloge_redirect_url
HSPI_System.web_hooksexternal_url
_1.clinical_interventions_resourcescir_url
_1.erx_anserx_ans_web_browser_url
_1.erx_anserx_ans_pda_browser_url
_1.erx_anserx_ans_win_upload_url
_1.erx_anserx_ans_win_download_url
_1.erx_anserx_ans_engine_download_url
_1.erx_anserx_ans_engine_upload_url
_1.erx_anserx_ans_link_download_url
_1.erx_anserx_ans_link_upload_url
_1.erx_anserx_ans_ac_web_browser_url
_1.erx_anserx_ans_ac_engine_download_url
_1.erx_anserx_ans_ac_engine_upload_url
_1.erx_anserx_ans_ac_link_download_url
_1.erx_anserx_ans_ac_link_upload_url
_1.erx_anserx_ans_payer_engine_url
_1.erx_anserx_ans_registration_url
_1.patient_education_resourcesper_url
_1.patients_education_resultsperes_generating_url
_1.patients_urlspu_url
_1188.clinical_interventions_resourcescir_url
_1188.erx_anserx_ans_web_browser_url
_1188.erx_anserx_ans_pda_browser_url
_1188.erx_anserx_ans_win_upload_url
_1188.erx_anserx_ans_win_download_url
_1188.erx_anserx_ans_engine_download_url
_1188.erx_anserx_ans_engine_upload_url
_1188.erx_anserx_ans_link_download_url
_1188.erx_anserx_ans_link_upload_url
_1188.erx_anserx_ans_ac_web_browser_url
_1188.erx_anserx_ans_ac_engine_download_url
_1188.erx_anserx_ans_ac_engine_upload_url
_1188.erx_anserx_ans_ac_link_download_url
_1188.erx_anserx_ans_ac_link_upload_url
_1188.erx_anserx_ans_payer_engine_url
_1188.erx_anserx_ans_registration_url
_1188.patient_education_resourcesper_url
_1188.patients_education_resultsperes_generating_url
_1188.patients_urlspu_url
_1218.clinical_interventions_resourcescir_url
_1218.erx_anserx_ans_web_browser_url
_1218.erx_anserx_ans_pda_browser_url
_1218.erx_anserx_ans_win_upload_url
_1218.erx_anserx_ans_win_download_url
_1218.erx_anserx_ans_engine_download_url
_1218.erx_anserx_ans_engine_upload_url
_1218.erx_anserx_ans_link_download_url
_1218.erx_anserx_ans_link_upload_url
_1218.erx_anserx_ans_ac_web_browser_url
_1218.erx_anserx_ans_ac_engine_download_url
_1218.erx_anserx_ans_ac_engine_upload_url
_1218.erx_anserx_ans_ac_link_download_url
_1218.erx_anserx_ans_ac_link_upload_url
_1218.erx_anserx_ans_payer_engine_url
_1218.erx_anserx_ans_registration_url
_1218.patient_education_resourcesper_url
_1218.patients_education_resultsperes_generating_url
_1218.patients_urlspu_url
_1548.clinical_interventions_resourcescir_url
_1548.erx_anserx_ans_web_browser_url
_1548.erx_anserx_ans_pda_browser_url
_1548.erx_anserx_ans_win_upload_url
_1548.erx_anserx_ans_win_download_url
_1548.erx_anserx_ans_engine_download_url
_1548.erx_anserx_ans_engine_upload_url
_1548.erx_anserx_ans_link_download_url
_1548.erx_anserx_ans_link_upload_url
_1548.erx_anserx_ans_ac_web_browser_url
_1548.erx_anserx_ans_ac_engine_download_url
_1548.erx_anserx_ans_ac_engine_upload_url
_1548.erx_anserx_ans_ac_link_download_url
_1548.erx_anserx_ans_ac_link_upload_url
_1548.erx_anserx_ans_payer_engine_url
_1548.erx_anserx_ans_registration_url
_1548.patient_education_resourcesper_url
_1548.patients_education_resultsperes_generating_url
_1548.patients_urlspu_url
_435.clinical_interventions_resourcescir_url
_435.erx_anserx_ans_web_browser_url
_435.erx_anserx_ans_pda_browser_url
_435.erx_anserx_ans_win_upload_url
_435.erx_anserx_ans_win_download_url
_435.erx_anserx_ans_engine_download_url
_435.erx_anserx_ans_engine_upload_url
_435.erx_anserx_ans_link_download_url
_435.erx_anserx_ans_link_upload_url
_435.erx_anserx_ans_ac_web_browser_url
_435.erx_anserx_ans_ac_engine_download_url
_435.erx_anserx_ans_ac_engine_upload_url
_435.erx_anserx_ans_ac_link_download_url
_435.erx_anserx_ans_ac_link_upload_url
_435.erx_anserx_ans_payer_engine_url
_435.erx_anserx_ans_registration_url
_435.patient_education_resourcesper_url
_435.patients_education_resultsperes_generating_url
_435.patients_urlspu_url
_436.clinical_interventions_resourcescir_url
_436.erx_anserx_ans_web_browser_url
_436.erx_anserx_ans_pda_browser_url
_436.erx_anserx_ans_win_upload_url
_436.erx_anserx_ans_win_download_url
_436.erx_anserx_ans_engine_download_url
_436.erx_anserx_ans_engine_upload_url
_436.erx_anserx_ans_link_download_url
_436.erx_anserx_ans_link_upload_url
_436.erx_anserx_ans_ac_web_browser_url
_436.erx_anserx_ans_ac_engine_download_url
_436.erx_anserx_ans_ac_engine_upload_url
_436.erx_anserx_ans_ac_link_download_url
_436.erx_anserx_ans_ac_link_upload_url
_436.erx_anserx_ans_payer_engine_url
_436.erx_anserx_ans_registration_url
_436.patient_education_resourcesper_url
_436.patients_education_resultsperes_generating_url
_436.patients_urlspu_url
_436_archive_testing.clinical_interventions_resourcescir_url
_436_archive_testing.erx_anserx_ans_web_browser_url
_436_archive_testing.erx_anserx_ans_pda_browser_url
_436_archive_testing.erx_anserx_ans_win_upload_url
_436_archive_testing.erx_anserx_ans_win_download_url
_436_archive_testing.erx_anserx_ans_engine_download_url
_436_archive_testing.erx_anserx_ans_engine_upload_url
_436_archive_testing.erx_anserx_ans_link_download_url
_436_archive_testing.erx_anserx_ans_link_upload_url
_436_archive_testing.erx_anserx_ans_ac_web_browser_url
_436_archive_testing.erx_anserx_ans_ac_engine_download_url
_436_archive_testing.erx_anserx_ans_ac_engine_upload_url
_436_archive_testing.erx_anserx_ans_ac_link_download_url
_436_archive_testing.erx_anserx_ans_ac_link_upload_url
_436_archive_testing.erx_anserx_ans_payer_engine_url
_436_archive_testing.erx_anserx_ans_registration_url
_436_archive_testing.patient_education_resourcesper_url
_436_archive_testing.patients_education_resultsperes_generating_url
_436_archive_testing.patients_urlspu_url
_437.clinical_interventions_resourcescir_url
_437.erx_anserx_ans_web_browser_url
_437.erx_anserx_ans_pda_browser_url
_437.erx_anserx_ans_win_upload_url
_437.erx_anserx_ans_win_download_url
_437.erx_anserx_ans_engine_download_url
_437.erx_anserx_ans_engine_upload_url
_437.erx_anserx_ans_link_download_url
_437.erx_anserx_ans_link_upload_url
_437.erx_anserx_ans_ac_web_browser_url
_437.erx_anserx_ans_ac_engine_download_url
_437.erx_anserx_ans_ac_engine_upload_url
_437.erx_anserx_ans_ac_link_download_url
_437.erx_anserx_ans_ac_link_upload_url
_437.erx_anserx_ans_payer_engine_url
_437.erx_anserx_ans_registration_url
_437.patient_education_resourcesper_url
_437.patients_education_resultsperes_generating_url
_437.patients_urlspu_url
_8.clinical_interventions_resourcescir_url
_8.erx_anserx_ans_web_browser_url
_8.erx_anserx_ans_pda_browser_url
_8.erx_anserx_ans_win_upload_url
_8.erx_anserx_ans_win_download_url
_8.erx_anserx_ans_engine_download_url
_8.erx_anserx_ans_engine_upload_url
_8.erx_anserx_ans_link_download_url
_8.erx_anserx_ans_link_upload_url
_8.erx_anserx_ans_ac_web_browser_url
_8.erx_anserx_ans_ac_engine_download_url
_8.erx_anserx_ans_ac_engine_upload_url
_8.erx_anserx_ans_ac_link_download_url
_8.erx_anserx_ans_ac_link_upload_url
_8.erx_anserx_ans_payer_engine_url
_8.erx_anserx_ans_registration_url
_8.patient_education_resourcesper_url
_8.patients_education_resultsperes_generating_url
_8.patients_urlspu_url
_81.clinical_interventions_resourcescir_url
_81.erx_anserx_ans_web_browser_url
_81.erx_anserx_ans_pda_browser_url
_81.erx_anserx_ans_win_upload_url
_81.erx_anserx_ans_win_download_url
_81.erx_anserx_ans_engine_download_url
_81.erx_anserx_ans_engine_upload_url
_81.erx_anserx_ans_link_download_url
_81.erx_anserx_ans_link_upload_url
_81.erx_anserx_ans_ac_web_browser_url
_81.erx_anserx_ans_ac_engine_download_url
_81.erx_anserx_ans_ac_engine_upload_url
_81.erx_anserx_ans_ac_link_download_url
_81.erx_anserx_ans_ac_link_upload_url
_81.erx_anserx_ans_payer_engine_url
_81.erx_anserx_ans_registration_url
_81.patient_education_resourcesper_url
_81.patients_education_resultsperes_generating_url
_81.patients_urlspu_url
_999.clinical_interventions_resourcescir_url
_999.erx_anserx_ans_web_browser_url
_999.erx_anserx_ans_pda_browser_url
_999.erx_anserx_ans_win_upload_url
_999.erx_anserx_ans_win_download_url
_999.erx_anserx_ans_engine_download_url
_999.erx_anserx_ans_engine_upload_url
_999.erx_anserx_ans_link_download_url
_999.erx_anserx_ans_link_upload_url
_999.erx_anserx_ans_ac_web_browser_url
_999.erx_anserx_ans_ac_engine_download_url
_999.erx_anserx_ans_ac_engine_upload_url
_999.erx_anserx_ans_ac_link_download_url
_999.erx_anserx_ans_ac_link_upload_url
_999.erx_anserx_ans_payer_engine_url
_999.erx_anserx_ans_registration_url
_999.patient_education_resourcesper_url
_999.patients_education_resultsperes_generating_url
_999.patients_urlspu_url
ahiWiki.interwikiiw_url
ahiWiki.transcachetc_url
aurora_standard.chsprogmenuctrue_url
aurora_standard.quicklinkstrue_url
aurora_standard.workmenuctrue_url
common.customerscus_url
common.customerscus_logout_url
common.dev_requests_screencastsdrs_embed_url
common.dev_requests_screencastsdrs_thumbnail_url
common.dev_requests_screencastsdrs_url
common.dev_requests_urlsdru_url
common.leadslea_url
common.login_eventsloge_redirect_url
rcmroi.dev__sf_tokensinstance_url
rcmroi.prod__sf_tokensinstance_url
rcmroi.test__sf_tokensinstance_url
xlnt.buildsresults_url
xlnt.selenium_test_queuebase_url
title
TableColumn
Azalea.employeesemp_title
AzaleaStats.pull_requestspull_title
_1.billing_reports_queuebrq_title
_1.clinical_interventions_test_codes_mapcitcm_reporting_title
_1.daily_close_schedulesdcs_title
_1.encounters_formsefrm_title
_1.encounters_soap_templatesest_phy_title
_1.erx_notificationserx_nots_title
_1.formsfrm_title
_1.handoutshand_title
_1.notesnot_title
_1.orders_test_codes_mapotcm_reporting_title
_1.radiology_orders_test_codes_maprtcm_reporting_title
_1.radiology_results_test_codes_maprrtcm_reporting_title
_1.reports_queuerq_title
_1188.billing_reports_queuebrq_title
_1188.clinical_interventions_test_codes_mapcitcm_reporting_title
_1188.daily_close_schedulesdcs_title
_1188.encounters_formsefrm_title
_1188.encounters_soap_templatesest_phy_title
_1188.erx_notificationserx_nots_title
_1188.formsfrm_title
_1188.handoutshand_title
_1188.notesnot_title
_1188.orders_test_codes_mapotcm_reporting_title
_1188.radiology_orders_test_codes_maprtcm_reporting_title
_1188.radiology_results_test_codes_maprrtcm_reporting_title
_1188.reports_queuerq_title
_1218.billing_reports_queuebrq_title
_1218.clinical_interventions_test_codes_mapcitcm_reporting_title
_1218.daily_close_schedulesdcs_title
_1218.encounters_formsefrm_title
_1218.encounters_soap_templatesest_phy_title
_1218.erx_notificationserx_nots_title
_1218.formsfrm_title
_1218.handoutshand_title
_1218.notesnot_title
_1218.orders_test_codes_mapotcm_reporting_title
_1218.radiology_orders_test_codes_maprtcm_reporting_title
_1218.radiology_results_test_codes_maprrtcm_reporting_title
_1218.reports_queuerq_title
_1548.billing_reports_queuebrq_title
_1548.clinical_interventions_test_codes_mapcitcm_reporting_title
_1548.daily_close_schedulesdcs_title
_1548.encounters_formsefrm_title
_1548.encounters_soap_templatesest_phy_title
_1548.erx_notificationserx_nots_title
_1548.formsfrm_title
_1548.handoutshand_title
_1548.notesnot_title
_1548.orders_test_codes_mapotcm_reporting_title
_1548.radiology_orders_test_codes_maprtcm_reporting_title
_1548.radiology_results_test_codes_maprrtcm_reporting_title
_1548.reports_queuerq_title
_435.billing_reports_queuebrq_title
_435.clinical_interventions_test_codes_mapcitcm_reporting_title
_435.daily_close_schedulesdcs_title
_435.encounters_formsefrm_title
_435.encounters_soap_templatesest_phy_title
_435.erx_notificationserx_nots_title
_435.formsfrm_title
_435.handoutshand_title
_435.notesnot_title
_435.orders_test_codes_mapotcm_reporting_title
_435.radiology_orders_test_codes_maprtcm_reporting_title
_435.radiology_results_test_codes_maprrtcm_reporting_title
_435.reports_queuerq_title
_436.billing_reports_queuebrq_title
_436.clinical_interventions_test_codes_mapcitcm_reporting_title
_436.daily_close_schedulesdcs_title
_436.encounters_formsefrm_title
_436.encounters_soap_templatesest_phy_title
_436.erx_notificationserx_nots_title
_436.formsfrm_title
_436.handoutshand_title
_436.notesnot_title
_436.orders_test_codes_mapotcm_reporting_title
_436.radiology_orders_test_codes_maprtcm_reporting_title
_436.radiology_results_test_codes_maprrtcm_reporting_title
_436.reports_queuerq_title
_436_archive_testing.billing_reports_queuebrq_title
_436_archive_testing.clinical_interventions_test_codes_mapcitcm_reporting_title
_436_archive_testing.daily_close_schedulesdcs_title
_436_archive_testing.encounters_formsefrm_title
_436_archive_testing.encounters_soap_templatesest_phy_title
_436_archive_testing.erx_notificationserx_nots_title
_436_archive_testing.formsfrm_title
_436_archive_testing.handoutshand_title
_436_archive_testing.notesnot_title
_436_archive_testing.orders_test_codes_mapotcm_reporting_title
_436_archive_testing.radiology_orders_test_codes_maprtcm_reporting_title
_436_archive_testing.radiology_results_test_codes_maprrtcm_reporting_title
_436_archive_testing.reports_queuerq_title
_437.billing_reports_queuebrq_title
_437.clinical_interventions_test_codes_mapcitcm_reporting_title
_437.daily_close_schedulesdcs_title
_437.encounters_formsefrm_title
_437.encounters_soap_templatesest_phy_title
_437.erx_notificationserx_nots_title
_437.formsfrm_title
_437.handoutshand_title
_437.notesnot_title
_437.orders_test_codes_mapotcm_reporting_title
_437.radiology_orders_test_codes_maprtcm_reporting_title
_437.radiology_results_test_codes_maprrtcm_reporting_title
_437.reports_queuerq_title
_8.billing_reports_queuebrq_title
_8.clinical_interventions_test_codes_mapcitcm_reporting_title
_8.daily_close_schedulesdcs_title
_8.encounters_formsefrm_title
_8.encounters_soap_templatesest_phy_title
_8.erx_notificationserx_nots_title
_8.formsfrm_title
_8.handoutshand_title
_8.notesnot_title
_8.orders_test_codes_mapotcm_reporting_title
_8.radiology_orders_test_codes_maprtcm_reporting_title
_8.radiology_results_test_codes_maprrtcm_reporting_title
_8.reports_queuerq_title
_81.billing_reports_queuebrq_title
_81.clinical_interventions_test_codes_mapcitcm_reporting_title
_81.daily_close_schedulesdcs_title
_81.encounters_formsefrm_title
_81.encounters_soap_templatesest_phy_title
_81.erx_notificationserx_nots_title
_81.formsfrm_title
_81.handoutshand_title
_81.notesnot_title
_81.orders_test_codes_mapotcm_reporting_title
_81.radiology_orders_test_codes_maprtcm_reporting_title
_81.radiology_results_test_codes_maprrtcm_reporting_title
_81.reports_queuerq_title
_999.billing_reports_queuebrq_title
_999.clinical_interventions_test_codes_mapcitcm_reporting_title
_999.daily_close_schedulesdcs_title
_999.encounters_formsefrm_title
_999.encounters_soap_templatesest_phy_title
_999.erx_notificationserx_nots_title
_999.formsfrm_title
_999.handoutshand_title
_999.notesnot_title
_999.orders_test_codes_mapotcm_reporting_title
_999.radiology_orders_test_codes_maprtcm_reporting_title
_999.radiology_results_test_codes_maprrtcm_reporting_title
_999.reports_queuerq_title
ahiWiki.archivear_title
ahiWiki.categorycat_title
ahiWiki.iwlinksiwl_title
ahiWiki.jobjob_title
ahiWiki.langlinksll_title
ahiWiki.logginglog_title
ahiWiki.pagepage_title
ahiWiki.pagelinkspl_title
ahiWiki.protected_titlespt_title
ahiWiki.querycacheqc_title
ahiWiki.querycachetwoqcc_title
ahiWiki.recentchangesrc_title
ahiWiki.redirectrd_title
ahiWiki.searchindexsi_title
ahiWiki.templatelinkstl_title
ahiWiki.watchlistwl_title
aurora_standard.bsguarnm_title
aurora_standard.bvguarnm_title
aurora_standard.bvmpinm_title
aurora_standard.bvmpi2nm_title
aurora_standard.cgscliprclip_title
aurora_standard.chmapcccgrp_title
aurora_standard.chmdi10clong_title
aurora_standard.chmdiagelong_title
aurora_standard.chmdiagxlong_title
aurora_standard.chmhcahpdr_title
aurora_standard.chmpdemop_title
aurora_standard.chmpdemosp_title
aurora_standard.chmpdemogu_title
aurora_standard.chmpdemofam_phy_title
aurora_standard.chmpdemoattend_phy_title
aurora_standard.chmpdemoadmit_phy_title
aurora_standard.chmpr10clong_title
aurora_standard.chmpsvcdrend_title
aurora_standard.chmpsvcdref_title
aurora_standard.chpcemprjob_title
aurora_standard.chpcntrceduc_dir_title
aurora_standard.chtraindstu_title
aurora_standard.chxtechctech_title
aurora_standard.chytechctech_title
aurora_standard.hl7gt1job_title
aurora_standard.hl7in2job_title
aurora_standard.newicd10short_title
aurora_standard.newicd10long_title
aurora_standard.newicd9cshort_title
aurora_standard.newicd9clong_title
aurora_standard.ohoemplrjob_title
aurora_standard.stfnoteenote_title
aurora_standard.stfnoternote_title
aurora_standard.styemplrjob_title
aurora_standard.wrkicd9short_title
common.contactscon_title
common.cqm_infocit_title
common.leadslea_title
common.reports_queue_ordersrqo_title
common.test_codestco_reporting_title
common.usersusr_title
common.view_configs_optionsvwco_title
common.view_configs_optionsvwco_hide_title
template_library.encounters_soap_templatesest_phy_title
template_library.formsfrm_title
details
TableColumn
_1.hl7_notesnot_details
_1.precerts_notesprn_details
_1.radiology_results_notesrrnot_details
_1188.hl7_notesnot_details
_1188.precerts_notesprn_details
_1188.radiology_results_notesrrnot_details
_1218.hl7_notesnot_details
_1218.precerts_notesprn_details
_1218.radiology_results_notesrrnot_details
_1548.hl7_notesnot_details
_1548.precerts_notesprn_details
_1548.radiology_results_notesrrnot_details
_435.hl7_notesnot_details
_435.precerts_notesprn_details
_435.radiology_results_notesrrnot_details
_436.hl7_notesnot_details
_436.precerts_notesprn_details
_436.radiology_results_notesrrnot_details
_436_archive_testing.hl7_notesnot_details
_436_archive_testing.precerts_notesprn_details
_436_archive_testing.radiology_results_notesrrnot_details
_437.hl7_notesnot_details
_437.precerts_notesprn_details
_437.radiology_results_notesrrnot_details
_8.hl7_notesnot_details
_8.precerts_notesprn_details
_8.radiology_results_notesrrnot_details
_81.hl7_notesnot_details
_81.precerts_notesprn_details
_81.radiology_results_notesrrnot_details
_999.hl7_notesnot_details
_999.precerts_notesprn_details
_999.radiology_results_notesrrnot_details
aurora_standard.chmozpcdempl_details
common.application_notesappn_details
common.clients_notescln_details
common.leads_noteslen_details
common.running_cronsrcron_details
common.service_tickets_notesstns_details
common.support_threadsspt_details
common.users_permissionsupr_customer_details
common.users_permissionsupr_client_details
common.users_permissionsupr_patient_details
common.users_permissionsupr_donor_details
common.users_permissionsupr_physician_details
common.users_permissionsupr_insurance_details
common.users_permissionsupr_encounter_details
common.users_permissionsupr_encounter_soap_details
common.users_permissionsupr_precert_details
common.users_permissionsupr_location_details
common.users_permissionsupr_lead_details
common.users_permissionsupr_contact_details
common.users_permissionsupr_test_code_details
common.users_permissionsupr_feature_request_details
common.users_permissionsupr_web_user_details
common.users_permissionsupr_order_details
common.users_permissionsupr_devrequest_details
common.users_permissionsupr_payment_details
common.users_permissionsupr_unapplied_payment_details
common.users_permissionsupr_fee_schedule_details
common.users_permissionsupr_resource_details
common.users_permissionsupr_apt_reason_details
common.users_permissionsupr_rcl_reason_details
common.users_permissionsupr_task_category_details
common.users_permissionsupr_recall_list_details
common.users_permissionsupr_guarantor_details
common.users_permissionsupr_custom_charge_details
common.users_permissionsupr_non_patient_details
common.users_permissionsupr_imz_details
options
TableColumn
aurora_standard.chtemplrno_options
common.users_permissionsupr_report_options
updated_at
TableColumn
aurora_standard.printoutsoriginal_updated_at
session_id
TableColumn
common.telehealth_sessionsths_session_id