aurora_standard.tmpcount

Field Type Null Default Key Extra Comment
bad_no varchar(20) YES
count smallint(6) YES
item_code varchar(20) YES
chs_rowID bigint(20) unsigned NO PRI auto_increment

References

Local Column References
count
TableColumn
EFaxes.efaxesefax_page_count
HSPI_CURES2015_B1.subscriptionserror_count
HSPI_Central_Hospital.subscriptionserror_count
HSPI_Dewitt.subscriptionserror_count
HSPI_Fulton.subscriptionserror_count
HSPI_Inferno.subscriptionserror_count
HSPI_MU2015_E1.subscriptionserror_count
HSPI_MU2015_G2.subscriptionserror_count
HSPI_MU2015_G9.subscriptionserror_count
HSPI_Sandbox.subscriptionserror_count
HSPI_Summit_General.subscriptionserror_count
HSPI_System.web_hook_request_logserror_count
HSPI_System.web_hook_triggerserror_count
HSPI_United_Physicians.subscriptionserror_count
Loinc.loinc_codes_frequencylcf_count
MPI.subscriptionserror_count
Snomed.concept_frequenciescf_count
Snomed_Dev_Orig.concept_frequenciescf_count
_1.appointment_recurrencearec_max_count
_1.charts_cpt_codeschcp_ndc_unit_count
_1.charts_stored_notes_frequencychsnf_count
_1.clients_fee_schedules_mapcfsm_ndc_unit_count
_1.configured_encounters_templates_cpt_codescetcc_ndc_unit_count
_1.cptcpt_ndc_unit_count
_1.cqm_stats_supplementalcqmss_count
_1.encounters_batchesebat_count
_1.encounters_batchesebat_patient_count
_1.encounters_cpt_codesecp_ndc_unit_count
_1.encounters_cpt_codes_statsecps_count
_1.encounters_cpt_codes_templatesecpt_ndc_unit_count
_1.encounters_icd9_codes_statseics_count
_1.encounters_soap_templates_frequencyestf_count
_1.encounters_statsencs_count
_1.encounters_stored_notes_frequencyesnf_count
_1.encounters_stored_notes_patients_frequencyesnpf_count
_1.hl7_accessions_statsaccs_count
_1.inventoryinv_ndc_unit_count
_1.inventory_cpt_mapinvcpt_unit_count
_1.orders_icd9_codes_statsoics_count
_1.orders_test_codes_statsotcs_count
_1.precerts_cpt_codes_statspcps_count
_1.precerts_icd9_codes_statspics_count
_1.test_codes_search_frequencytcof_count
_1188.appointment_recurrencearec_max_count
_1188.charts_cpt_codeschcp_ndc_unit_count
_1188.charts_stored_notes_frequencychsnf_count
_1188.clients_fee_schedules_mapcfsm_ndc_unit_count
_1188.configured_encounters_templates_cpt_codescetcc_ndc_unit_count
_1188.cptcpt_ndc_unit_count
_1188.cqm_stats_supplementalcqmss_count
_1188.encounters_batchesebat_count
_1188.encounters_batchesebat_patient_count
_1188.encounters_cpt_codesecp_ndc_unit_count
_1188.encounters_cpt_codes_statsecps_count
_1188.encounters_cpt_codes_templatesecpt_ndc_unit_count
_1188.encounters_icd9_codes_statseics_count
_1188.encounters_soap_templates_frequencyestf_count
_1188.encounters_statsencs_count
_1188.encounters_stored_notes_frequencyesnf_count
_1188.encounters_stored_notes_patients_frequencyesnpf_count
_1188.hl7_accessions_statsaccs_count
_1188.inventoryinv_ndc_unit_count
_1188.inventory_cpt_mapinvcpt_unit_count
_1188.orders_icd9_codes_statsoics_count
_1188.orders_test_codes_statsotcs_count
_1188.precerts_cpt_codes_statspcps_count
_1188.precerts_icd9_codes_statspics_count
_1188.test_codes_search_frequencytcof_count
_1218.appointment_recurrencearec_max_count
_1218.charts_cpt_codeschcp_ndc_unit_count
_1218.charts_stored_notes_frequencychsnf_count
_1218.clients_fee_schedules_mapcfsm_ndc_unit_count
_1218.configured_encounters_templates_cpt_codescetcc_ndc_unit_count
_1218.cptcpt_ndc_unit_count
_1218.cqm_stats_supplementalcqmss_count
_1218.encounters_batchesebat_count
_1218.encounters_batchesebat_patient_count
_1218.encounters_cpt_codesecp_ndc_unit_count
_1218.encounters_cpt_codes_statsecps_count
_1218.encounters_cpt_codes_templatesecpt_ndc_unit_count
_1218.encounters_icd9_codes_statseics_count
_1218.encounters_soap_templates_frequencyestf_count
_1218.encounters_statsencs_count
_1218.encounters_stored_notes_frequencyesnf_count
_1218.encounters_stored_notes_patients_frequencyesnpf_count
_1218.hl7_accessions_statsaccs_count
_1218.inventoryinv_ndc_unit_count
_1218.inventory_cpt_mapinvcpt_unit_count
_1218.orders_icd9_codes_statsoics_count
_1218.orders_test_codes_statsotcs_count
_1218.precerts_cpt_codes_statspcps_count
_1218.precerts_icd9_codes_statspics_count
_1218.test_codes_search_frequencytcof_count
_1548.appointment_recurrencearec_max_count
_1548.charts_cpt_codeschcp_ndc_unit_count
_1548.charts_stored_notes_frequencychsnf_count
_1548.clients_fee_schedules_mapcfsm_ndc_unit_count
_1548.configured_encounters_templates_cpt_codescetcc_ndc_unit_count
_1548.cptcpt_ndc_unit_count
_1548.cqm_stats_supplementalcqmss_count
_1548.encounters_batchesebat_count
_1548.encounters_batchesebat_patient_count
_1548.encounters_cpt_codesecp_ndc_unit_count
_1548.encounters_cpt_codes_statsecps_count
_1548.encounters_cpt_codes_templatesecpt_ndc_unit_count
_1548.encounters_icd9_codes_statseics_count
_1548.encounters_soap_templates_frequencyestf_count
_1548.encounters_statsencs_count
_1548.encounters_stored_notes_frequencyesnf_count
_1548.encounters_stored_notes_patients_frequencyesnpf_count
_1548.hl7_accessions_statsaccs_count
_1548.inventoryinv_ndc_unit_count
_1548.inventory_cpt_mapinvcpt_unit_count
_1548.orders_icd9_codes_statsoics_count
_1548.orders_test_codes_statsotcs_count
_1548.precerts_cpt_codes_statspcps_count
_1548.precerts_icd9_codes_statspics_count
_1548.test_codes_search_frequencytcof_count
_435.appointment_recurrencearec_max_count
_435.charts_cpt_codeschcp_ndc_unit_count
_435.charts_stored_notes_frequencychsnf_count
_435.clients_fee_schedules_mapcfsm_ndc_unit_count
_435.configured_encounters_templates_cpt_codescetcc_ndc_unit_count
_435.cptcpt_ndc_unit_count
_435.cqm_stats_supplementalcqmss_count
_435.encounters_batchesebat_count
_435.encounters_batchesebat_patient_count
_435.encounters_cpt_codesecp_ndc_unit_count
_435.encounters_cpt_codes_statsecps_count
_435.encounters_cpt_codes_templatesecpt_ndc_unit_count
_435.encounters_icd9_codes_statseics_count
_435.encounters_soap_templates_frequencyestf_count
_435.encounters_statsencs_count
_435.encounters_stored_notes_frequencyesnf_count
_435.encounters_stored_notes_patients_frequencyesnpf_count
_435.hl7_accessions_statsaccs_count
_435.inventoryinv_ndc_unit_count
_435.inventory_cpt_mapinvcpt_unit_count
_435.orders_icd9_codes_statsoics_count
_435.orders_test_codes_statsotcs_count
_435.precerts_cpt_codes_statspcps_count
_435.precerts_icd9_codes_statspics_count
_435.test_codes_search_frequencytcof_count
_436.appointment_recurrencearec_max_count
_436.charts_cpt_codeschcp_ndc_unit_count
_436.charts_stored_notes_frequencychsnf_count
_436.clients_fee_schedules_mapcfsm_ndc_unit_count
_436.configured_encounters_templates_cpt_codescetcc_ndc_unit_count
_436.cptcpt_ndc_unit_count
_436.cqm_stats_supplementalcqmss_count
_436.encounters_batchesebat_count
_436.encounters_batchesebat_patient_count
_436.encounters_cpt_codesecp_ndc_unit_count
_436.encounters_cpt_codes_statsecps_count
_436.encounters_cpt_codes_templatesecpt_ndc_unit_count
_436.encounters_icd9_codes_statseics_count
_436.encounters_soap_templates_frequencyestf_count
_436.encounters_statsencs_count
_436.encounters_stored_notes_frequencyesnf_count
_436.encounters_stored_notes_patients_frequencyesnpf_count
_436.hl7_accessions_statsaccs_count
_436.inventoryinv_ndc_unit_count
_436.inventory_cpt_mapinvcpt_unit_count
_436.orders_icd9_codes_statsoics_count
_436.orders_test_codes_statsotcs_count
_436.precerts_cpt_codes_statspcps_count
_436.precerts_icd9_codes_statspics_count
_436.test_codes_search_frequencytcof_count
_436_archive_testing.appointment_recurrencearec_max_count
_436_archive_testing.charts_cpt_codeschcp_ndc_unit_count
_436_archive_testing.charts_stored_notes_frequencychsnf_count
_436_archive_testing.clients_fee_schedules_mapcfsm_ndc_unit_count
_436_archive_testing.configured_encounters_templates_cpt_codescetcc_ndc_unit_count
_436_archive_testing.cptcpt_ndc_unit_count
_436_archive_testing.cqm_stats_supplementalcqmss_count
_436_archive_testing.encounters_batchesebat_count
_436_archive_testing.encounters_batchesebat_patient_count
_436_archive_testing.encounters_cpt_codesecp_ndc_unit_count
_436_archive_testing.encounters_cpt_codes_statsecps_count
_436_archive_testing.encounters_cpt_codes_templatesecpt_ndc_unit_count
_436_archive_testing.encounters_icd9_codes_statseics_count
_436_archive_testing.encounters_soap_templates_frequencyestf_count
_436_archive_testing.encounters_statsencs_count
_436_archive_testing.encounters_stored_notes_frequencyesnf_count
_436_archive_testing.encounters_stored_notes_patients_frequencyesnpf_count
_436_archive_testing.hl7_accessions_statsaccs_count
_436_archive_testing.inventoryinv_ndc_unit_count
_436_archive_testing.inventory_cpt_mapinvcpt_unit_count
_436_archive_testing.orders_icd9_codes_statsoics_count
_436_archive_testing.orders_test_codes_statsotcs_count
_436_archive_testing.precerts_cpt_codes_statspcps_count
_436_archive_testing.precerts_icd9_codes_statspics_count
_436_archive_testing.test_codes_search_frequencytcof_count
_437.appointment_recurrencearec_max_count
_437.charts_cpt_codeschcp_ndc_unit_count
_437.charts_stored_notes_frequencychsnf_count
_437.clients_fee_schedules_mapcfsm_ndc_unit_count
_437.configured_encounters_templates_cpt_codescetcc_ndc_unit_count
_437.cptcpt_ndc_unit_count
_437.cqm_stats_supplementalcqmss_count
_437.encounters_batchesebat_count
_437.encounters_batchesebat_patient_count
_437.encounters_cpt_codesecp_ndc_unit_count
_437.encounters_cpt_codes_statsecps_count
_437.encounters_cpt_codes_templatesecpt_ndc_unit_count
_437.encounters_icd9_codes_statseics_count
_437.encounters_soap_templates_frequencyestf_count
_437.encounters_statsencs_count
_437.encounters_stored_notes_frequencyesnf_count
_437.encounters_stored_notes_patients_frequencyesnpf_count
_437.hl7_accessions_statsaccs_count
_437.inventoryinv_ndc_unit_count
_437.inventory_cpt_mapinvcpt_unit_count
_437.orders_icd9_codes_statsoics_count
_437.orders_test_codes_statsotcs_count
_437.precerts_cpt_codes_statspcps_count
_437.precerts_icd9_codes_statspics_count
_437.test_codes_search_frequencytcof_count
_8.appointment_recurrencearec_max_count
_8.charts_cpt_codeschcp_ndc_unit_count
_8.charts_stored_notes_frequencychsnf_count
_8.clients_fee_schedules_mapcfsm_ndc_unit_count
_8.configured_encounters_templates_cpt_codescetcc_ndc_unit_count
_8.cptcpt_ndc_unit_count
_8.cqm_stats_supplementalcqmss_count
_8.encounters_batchesebat_count
_8.encounters_batchesebat_patient_count
_8.encounters_cpt_codesecp_ndc_unit_count
_8.encounters_cpt_codes_statsecps_count
_8.encounters_cpt_codes_templatesecpt_ndc_unit_count
_8.encounters_icd9_codes_statseics_count
_8.encounters_soap_templates_frequencyestf_count
_8.encounters_statsencs_count
_8.encounters_stored_notes_frequencyesnf_count
_8.encounters_stored_notes_patients_frequencyesnpf_count
_8.hl7_accessions_statsaccs_count
_8.inventoryinv_ndc_unit_count
_8.inventory_cpt_mapinvcpt_unit_count
_8.orders_icd9_codes_statsoics_count
_8.orders_test_codes_statsotcs_count
_8.precerts_cpt_codes_statspcps_count
_8.precerts_icd9_codes_statspics_count
_8.test_codes_search_frequencytcof_count
_81.appointment_recurrencearec_max_count
_81.charts_cpt_codeschcp_ndc_unit_count
_81.charts_stored_notes_frequencychsnf_count
_81.clients_fee_schedules_mapcfsm_ndc_unit_count
_81.configured_encounters_templates_cpt_codescetcc_ndc_unit_count
_81.cptcpt_ndc_unit_count
_81.cqm_stats_supplementalcqmss_count
_81.encounters_batchesebat_count
_81.encounters_batchesebat_patient_count
_81.encounters_cpt_codesecp_ndc_unit_count
_81.encounters_cpt_codes_statsecps_count
_81.encounters_cpt_codes_templatesecpt_ndc_unit_count
_81.encounters_icd9_codes_statseics_count
_81.encounters_soap_templates_frequencyestf_count
_81.encounters_statsencs_count
_81.encounters_stored_notes_frequencyesnf_count
_81.encounters_stored_notes_patients_frequencyesnpf_count
_81.hl7_accessions_statsaccs_count
_81.inventoryinv_ndc_unit_count
_81.inventory_cpt_mapinvcpt_unit_count
_81.orders_icd9_codes_statsoics_count
_81.orders_test_codes_statsotcs_count
_81.precerts_cpt_codes_statspcps_count
_81.precerts_icd9_codes_statspics_count
_81.test_codes_search_frequencytcof_count
_999.appointment_recurrencearec_max_count
_999.charts_cpt_codeschcp_ndc_unit_count
_999.charts_stored_notes_frequencychsnf_count
_999.clients_fee_schedules_mapcfsm_ndc_unit_count
_999.configured_encounters_templates_cpt_codescetcc_ndc_unit_count
_999.cptcpt_ndc_unit_count
_999.cqm_stats_supplementalcqmss_count
_999.encounters_batchesebat_count
_999.encounters_batchesebat_patient_count
_999.encounters_cpt_codesecp_ndc_unit_count
_999.encounters_cpt_codes_statsecps_count
_999.encounters_cpt_codes_templatesecpt_ndc_unit_count
_999.encounters_icd9_codes_statseics_count
_999.encounters_soap_templates_frequencyestf_count
_999.encounters_statsencs_count
_999.encounters_stored_notes_frequencyesnf_count
_999.encounters_stored_notes_patients_frequencyesnpf_count
_999.hl7_accessions_statsaccs_count
_999.inventoryinv_ndc_unit_count
_999.inventory_cpt_mapinvcpt_unit_count
_999.orders_icd9_codes_statsoics_count
_999.orders_test_codes_statsotcs_count
_999.precerts_cpt_codes_statspcps_count
_999.precerts_icd9_codes_statspics_count
_999.test_codes_search_frequencytcof_count
aurora_standard.activity_logsaccess_count
aurora_standard.chmedilrfile_count
aurora_standard.chmguardstmnt_count
aurora_standard.chmperxdline_count
aurora_standard.itemcountitem_count
aurora_standard.mmheaderrecord_count
aurora_standard.styoctccmfull_time_employee_count
aurora_standard.styoctccmtotal_employee_count
common.cqm_infocit_population_count
common.customers_statscst_count
common.leads_statsles_count
common.sfax_accountssfax_failure_count
common.sfaxessfax_page_count
common.users_login_statsuls_count
template_library.cptcpt_ndc_unit_count
template_library.encounters_cpt_codes_templatesecpt_ndc_unit_count
xlnt.pullrequestscomment_count
item_code
TableColumn
aurora_standard.chmbitmdvend_item_code
aurora_standard.chmschgdvend_item_code
aurora_standard.glstrackp_item_code
aurora_standard.glstrackm_item_code
aurora_standard.icactvvvend_item_code
aurora_standard.stiixrefvend_item_code
aurora_standard.stmaintdmaint_po_item_code
aurora_standard.stuctlgdvend_item_code
aurora_standard.sturqstdvend_item_code
aurora_standard.tmpctlgdvend_item_code
aurora_standard.tmplvl2vend_item_code
aurora_standard.tmplvl3vend_item_code
aurora_standard.tmpparlvlvend_item_code