aurora_standard.stxstatn

Field Type Null Default Key Extra Comment
number int(11) YES
stat varchar(6) YES
chs_rowID bigint(20) unsigned NO PRI auto_increment

References

Local Column References
number
TableColumn
API.partner_accountsphone_number
AzaleaStats.error_reportserr_source_line_number
EFaxes.efaxes_recipientsefr_number
HSPI_Bastrop.coveragesgroup_number
HSPI_Bastrop.coveragespolicy_number
HSPI_Bastrop.locationsclia_number
HSPI_Bastrop.phone_numbersphone_number
HSPI_CURES2015_B1.cbos_inventory_logdocument_number
HSPI_CURES2015_B1.coveragesgroup_number
HSPI_CURES2015_B1.coveragespolicy_number
HSPI_CURES2015_B1.locationsclia_number
HSPI_CURES2015_B1.phone_numbersphone_number
HSPI_Central_Hospital.cbos_inventory_logdocument_number
HSPI_Central_Hospital.coveragesgroup_number
HSPI_Central_Hospital.coveragespolicy_number
HSPI_Central_Hospital.locationsclia_number
HSPI_Central_Hospital.phone_numbersphone_number
HSPI_Dewitt.cbos_inventory_logdocument_number
HSPI_Dewitt.coveragesgroup_number
HSPI_Dewitt.coveragespolicy_number
HSPI_Dewitt.locationsclia_number
HSPI_Dewitt.phone_numbersphone_number
HSPI_Fulton.cbos_inventory_logdocument_number
HSPI_Fulton.coveragesgroup_number
HSPI_Fulton.coveragespolicy_number
HSPI_Fulton.locationsclia_number
HSPI_Fulton.phone_numbersphone_number
HSPI_Inferno.cbos_inventory_logdocument_number
HSPI_Inferno.coveragesgroup_number
HSPI_Inferno.coveragespolicy_number
HSPI_Inferno.locationsclia_number
HSPI_Inferno.phone_numbersphone_number
HSPI_MU2015_E1.cbos_inventory_logdocument_number
HSPI_MU2015_E1.coveragesgroup_number
HSPI_MU2015_E1.coveragespolicy_number
HSPI_MU2015_E1.locationsclia_number
HSPI_MU2015_E1.phone_numbersphone_number
HSPI_MU2015_G2.cbos_inventory_logdocument_number
HSPI_MU2015_G2.coveragesgroup_number
HSPI_MU2015_G2.coveragespolicy_number
HSPI_MU2015_G2.locationsclia_number
HSPI_MU2015_G2.phone_numbersphone_number
HSPI_MU2015_G9.cbos_inventory_logdocument_number
HSPI_MU2015_G9.coveragesgroup_number
HSPI_MU2015_G9.coveragespolicy_number
HSPI_MU2015_G9.locationsclia_number
HSPI_MU2015_G9.phone_numbersphone_number
HSPI_Ness.coveragesgroup_number
HSPI_Ness.coveragespolicy_number
HSPI_Ness.phone_numbersphone_number
HSPI_Sandbox.cbos_inventory_logdocument_number
HSPI_Sandbox.coveragesgroup_number
HSPI_Sandbox.coveragespolicy_number
HSPI_Sandbox.locationsclia_number
HSPI_Sandbox.phone_numbersphone_number
HSPI_Summit_General.cbos_inventory_logdocument_number
HSPI_Summit_General.coveragesgroup_number
HSPI_Summit_General.coveragespolicy_number
HSPI_Summit_General.locationsclia_number
HSPI_Summit_General.phone_numbersphone_number
HSPI_System.phone_numbersphone_number
HSPI_United_Physicians.cbos_inventory_logdocument_number
HSPI_United_Physicians.coveragesgroup_number
HSPI_United_Physicians.coveragespolicy_number
HSPI_United_Physicians.locationsclia_number
HSPI_United_Physicians.phone_numbersphone_number
MPI.cbos_inventory_logdocument_number
MPI.coveragesgroup_number
MPI.coveragespolicy_number
MPI.locationsclia_number
MPI.phone_numbersphone_number
SSO.developer_profilesphone_number
_1.client_contactsclicon_fax_number
_1.encounters_claims_supplemental_informationsecsi_control_number
_1.encounters_cpt_codesecp_prescription_number
_1.encounters_ub04enc_ub04_81_a_number
_1.encounters_ub04enc_ub04_81_b_number
_1.encounters_ub04enc_ub04_81_c_number
_1.encounters_ub04enc_ub04_81_d_number
_1.hl7_ordersord_group_number
_1.inventoryinv_lot_number
_1.inventoryinv_product_number
_1.patientspat_emergency_number
_1.patients_demographics_snapshotspds_emergency_number
_1.patients_historiesph_enc_version_number
_1.patients_inventorypinv_lot_number
_1.patients_inventorypinv_product_number
_1.patients_prescriptionsprx_order_number
_1188.client_contactsclicon_fax_number
_1188.encounters_claims_supplemental_informationsecsi_control_number
_1188.encounters_cpt_codesecp_prescription_number
_1188.encounters_ub04enc_ub04_81_a_number
_1188.encounters_ub04enc_ub04_81_b_number
_1188.encounters_ub04enc_ub04_81_c_number
_1188.encounters_ub04enc_ub04_81_d_number
_1188.hl7_ordersord_group_number
_1188.inventoryinv_lot_number
_1188.inventoryinv_product_number
_1188.patientspat_emergency_number
_1188.patients_demographics_snapshotspds_emergency_number
_1188.patients_historiesph_enc_version_number
_1188.patients_inventorypinv_lot_number
_1188.patients_inventorypinv_product_number
_1188.patients_prescriptionsprx_order_number
_1218.client_contactsclicon_fax_number
_1218.encounters_claims_supplemental_informationsecsi_control_number
_1218.encounters_cpt_codesecp_prescription_number
_1218.encounters_ub04enc_ub04_81_a_number
_1218.encounters_ub04enc_ub04_81_b_number
_1218.encounters_ub04enc_ub04_81_c_number
_1218.encounters_ub04enc_ub04_81_d_number
_1218.hl7_ordersord_group_number
_1218.inventoryinv_lot_number
_1218.inventoryinv_product_number
_1218.patientspat_emergency_number
_1218.patients_demographics_snapshotspds_emergency_number
_1218.patients_historiesph_enc_version_number
_1218.patients_inventorypinv_lot_number
_1218.patients_inventorypinv_product_number
_1218.patients_prescriptionsprx_order_number
_1548.client_contactsclicon_fax_number
_1548.encounters_claims_supplemental_informationsecsi_control_number
_1548.encounters_cpt_codesecp_prescription_number
_1548.encounters_ub04enc_ub04_81_a_number
_1548.encounters_ub04enc_ub04_81_b_number
_1548.encounters_ub04enc_ub04_81_c_number
_1548.encounters_ub04enc_ub04_81_d_number
_1548.hl7_ordersord_group_number
_1548.inventoryinv_lot_number
_1548.inventoryinv_product_number
_1548.patientspat_emergency_number
_1548.patients_demographics_snapshotspds_emergency_number
_1548.patients_historiesph_enc_version_number
_1548.patients_inventorypinv_lot_number
_1548.patients_inventorypinv_product_number
_1548.patients_prescriptionsprx_order_number
_435.client_contactsclicon_fax_number
_435.encounters_claims_supplemental_informationsecsi_control_number
_435.encounters_cpt_codesecp_prescription_number
_435.encounters_ub04enc_ub04_81_a_number
_435.encounters_ub04enc_ub04_81_b_number
_435.encounters_ub04enc_ub04_81_c_number
_435.encounters_ub04enc_ub04_81_d_number
_435.hl7_ordersord_group_number
_435.inventoryinv_lot_number
_435.inventoryinv_product_number
_435.patientspat_emergency_number
_435.patients_demographics_snapshotspds_emergency_number
_435.patients_historiesph_enc_version_number
_435.patients_inventorypinv_lot_number
_435.patients_inventorypinv_product_number
_435.patients_prescriptionsprx_order_number
_436.client_contactsclicon_fax_number
_436.encounters_claims_supplemental_informationsecsi_control_number
_436.encounters_cpt_codesecp_prescription_number
_436.encounters_ub04enc_ub04_81_a_number
_436.encounters_ub04enc_ub04_81_b_number
_436.encounters_ub04enc_ub04_81_c_number
_436.encounters_ub04enc_ub04_81_d_number
_436.hl7_ordersord_group_number
_436.inventoryinv_lot_number
_436.inventoryinv_product_number
_436.patientspat_emergency_number
_436.patients_demographics_snapshotspds_emergency_number
_436.patients_historiesph_enc_version_number
_436.patients_inventorypinv_lot_number
_436.patients_inventorypinv_product_number
_436.patients_prescriptionsprx_order_number
_436_archive_testing.client_contactsclicon_fax_number
_436_archive_testing.encounters_claims_supplemental_informationsecsi_control_number
_436_archive_testing.encounters_cpt_codesecp_prescription_number
_436_archive_testing.encounters_ub04enc_ub04_81_a_number
_436_archive_testing.encounters_ub04enc_ub04_81_b_number
_436_archive_testing.encounters_ub04enc_ub04_81_c_number
_436_archive_testing.encounters_ub04enc_ub04_81_d_number
_436_archive_testing.hl7_ordersord_group_number
_436_archive_testing.inventoryinv_lot_number
_436_archive_testing.inventoryinv_product_number
_436_archive_testing.patientspat_emergency_number
_436_archive_testing.patients_demographics_snapshotspds_emergency_number
_436_archive_testing.patients_historiesph_enc_version_number
_436_archive_testing.patients_inventorypinv_lot_number
_436_archive_testing.patients_inventorypinv_product_number
_436_archive_testing.patients_prescriptionsprx_order_number
_437.client_contactsclicon_fax_number
_437.encounters_claims_supplemental_informationsecsi_control_number
_437.encounters_cpt_codesecp_prescription_number
_437.encounters_ub04enc_ub04_81_a_number
_437.encounters_ub04enc_ub04_81_b_number
_437.encounters_ub04enc_ub04_81_c_number
_437.encounters_ub04enc_ub04_81_d_number
_437.hl7_ordersord_group_number
_437.inventoryinv_lot_number
_437.inventoryinv_product_number
_437.patientspat_emergency_number
_437.patients_demographics_snapshotspds_emergency_number
_437.patients_historiesph_enc_version_number
_437.patients_inventorypinv_lot_number
_437.patients_inventorypinv_product_number
_437.patients_prescriptionsprx_order_number
_8.client_contactsclicon_fax_number
_8.encounters_claims_supplemental_informationsecsi_control_number
_8.encounters_cpt_codesecp_prescription_number
_8.encounters_ub04enc_ub04_81_a_number
_8.encounters_ub04enc_ub04_81_b_number
_8.encounters_ub04enc_ub04_81_c_number
_8.encounters_ub04enc_ub04_81_d_number
_8.hl7_ordersord_group_number
_8.inventoryinv_lot_number
_8.inventoryinv_product_number
_8.patientspat_emergency_number
_8.patients_demographics_snapshotspds_emergency_number
_8.patients_historiesph_enc_version_number
_8.patients_inventorypinv_lot_number
_8.patients_inventorypinv_product_number
_8.patients_prescriptionsprx_order_number
_81.client_contactsclicon_fax_number
_81.encounters_claims_supplemental_informationsecsi_control_number
_81.encounters_cpt_codesecp_prescription_number
_81.encounters_ub04enc_ub04_81_a_number
_81.encounters_ub04enc_ub04_81_b_number
_81.encounters_ub04enc_ub04_81_c_number
_81.encounters_ub04enc_ub04_81_d_number
_81.hl7_ordersord_group_number
_81.inventoryinv_lot_number
_81.inventoryinv_product_number
_81.patientspat_emergency_number
_81.patients_demographics_snapshotspds_emergency_number
_81.patients_historiesph_enc_version_number
_81.patients_inventorypinv_lot_number
_81.patients_inventorypinv_product_number
_81.patients_prescriptionsprx_order_number
_999.client_contactsclicon_fax_number
_999.encounters_claims_supplemental_informationsecsi_control_number
_999.encounters_cpt_codesecp_prescription_number
_999.encounters_ub04enc_ub04_81_a_number
_999.encounters_ub04enc_ub04_81_b_number
_999.encounters_ub04enc_ub04_81_c_number
_999.encounters_ub04enc_ub04_81_d_number
_999.hl7_ordersord_group_number
_999.inventoryinv_lot_number
_999.inventoryinv_product_number
_999.patientspat_emergency_number
_999.patients_demographics_snapshotspds_emergency_number
_999.patients_historiesph_enc_version_number
_999.patients_inventorypinv_lot_number
_999.patients_inventorypinv_product_number
_999.patients_prescriptionsprx_order_number
aurora_standard.acptwrkcpt_number
aurora_standard.acptwrkdec_number
aurora_standard.addcdmdept_number
aurora_standard.b2baddmr_number
aurora_standard.bhbaddmr_number
aurora_standard.bhldgrmr_number
aurora_standard.bhphybakmr_number
aurora_standard.bhtldgrmr_number
aurora_standard.caadjgl_number
aurora_standard.cachrggl_number
aurora_standard.cachrg2gl_number
aurora_standard.cachrgcagl_number
aurora_standard.cachrgevogl_number
aurora_standard.canullchrggl_number
aurora_standard.capaygl_number
aurora_standard.caroomgl_number
aurora_standard.cgsinptrauto_number
aurora_standard.chcimmucjoin_number
aurora_standard.chcmanucjoin_number
aurora_standard.chcprovcjoin_number
aurora_standard.chcsericjoin_number
aurora_standard.chm15chdphys_number
aurora_standard.chm835pssvc_number
aurora_standard.chmbatexmc_number
aurora_standard.chmblogdseq_number
aurora_standard.chmmbc37policy_number
aurora_standard.chmmbc37ocna_number
aurora_standard.chmmbc50payor_number
aurora_standard.chmmbc51check_number
aurora_standard.chmmhbcrcheck_number
aurora_standard.chmmnecaorig_number
aurora_standard.chmpatmdmr_number
aurora_standard.chmphyncmr_number
aurora_standard.chmpressclient_number
aurora_standard.chpcobrdcobra_number
aurora_standard.chpemphdseq_number
aurora_standard.chplicedlicense_number
aurora_standard.chpparbacus_number
aurora_standard.chqcarddphy_number
aurora_standard.chqchekdphy_number
aurora_standard.chqchrtdphy_number
aurora_standard.chqcmeudphy_number
aurora_standard.chqletrdphy_number
aurora_standard.chqliabdphy_number
aurora_standard.chqlicndlicense_number
aurora_standard.chqlicndphy_number
aurora_standard.chqnpdbdphy_number
aurora_standard.chqphyncphy_number
aurora_standard.chqstafdphy_number
aurora_standard.chrdfileid_number
aurora_standard.chtclokdinc_number
aurora_standard.hhtclokdinc_number
aurora_standard.oeorderphy_number
aurora_standard.stfasstrpo_number
aurora_standard.stonwalldept_number
aurora_standard.stpapckvdocument_number
aurora_standard.stpapckvposting_number
aurora_standard.stpapckvcheck_number
aurora_standard.stpapckvaccount_number
aurora_standard.stxerorderr_number
aurora_standard.stxerorherr_number
aurora_standard.stxhelpdhlp_number
aurora_standard.stxmssgrmssg_number
aurora_standard.stycntrcein_number
aurora_standard.stycntrcstate_number
aurora_standard.stycntrcsuta_number
aurora_standard.stydeddvdocument_number
aurora_standard.stydeddvcheck_number
aurora_standard.stydeddvempl_acct_number
aurora_standard.styempidinc_number
aurora_standard.styincdvdocument_number
aurora_standard.styincdvcheck_number
aurora_standard.styobldvdocument_number
aurora_standard.styobldvcheck_number
aurora_standard.styoctccgov_entity_id_number
aurora_standard.styoctccform_1095c_number
aurora_standard.styoctccale_form_1095c_number
aurora_standard.stypddrdtrace_number
aurora_standard.styptodvdocument_number
aurora_standard.styrtimdinc_number
aurora_standard.stytimedinc_number
aurora_standard.stytypidinc_number
aurora_standard.stywtwoestate_number
aurora_standard.stywtwoelocal_number
aurora_standard.timetablinc_number
aurora_standard.timetabl_ininc_number
aurora_standard.tmpmrrptcontrol_number
aurora_standard.vault_relationshipsrelationship_code_number
common.appointments_clienttell_statusesacs_number
common.card_connect_merchant_accountsccma_hsn_number
common.card_connect_merchant_devices_mapccmdm_hsn_number
common.faxesfax_number
xlnt.buildsbamboo_build_number
xlnt.selenium_test_queuebuild_number
xlnt.selenium_test_resultsbuild_number
stat
TableColumn
_1.precertspre_stat
_1.precerts_mapprem_stat
_1188.precertspre_stat
_1188.precerts_mapprem_stat
_1218.precertspre_stat
_1218.precerts_mapprem_stat
_1548.precertspre_stat
_1548.precerts_mapprem_stat
_435.precertspre_stat
_435.precerts_mapprem_stat
_436.precertspre_stat
_436.precerts_mapprem_stat
_436_archive_testing.precertspre_stat
_436_archive_testing.precerts_mapprem_stat
_437.precertspre_stat
_437.precerts_mapprem_stat
_8.precertspre_stat
_8.precerts_mapprem_stat
_81.precertspre_stat
_81.precerts_mapprem_stat
_999.precertspre_stat
_999.precerts_mapprem_stat
aurora_standard.abmvisdis_stat
aurora_standard.apsardis_stat
aurora_standard.apsar0dis_stat
aurora_standard.apsarbddis_stat
aurora_standard.apsarhistdis_stat
aurora_standard.audroomdnurs_stat
aurora_standard.audroomdbill_stat
aurora_standard.b2mrdrdis_stat
aurora_standard.bhmrdrdis_stat
aurora_standard.bhtmrdrdis_stat
aurora_standard.c8bal0bill_stat
aurora_standard.c8balsbill_stat
aurora_standard.cgrsubgdsubg_stat
aurora_standard.chhl7in1billing_stat
aurora_standard.chhl7in1ins_empl_stat
aurora_standard.chhl7in1verif_stat
aurora_standard.chhl7in2champus_stat
aurora_standard.chmarsiins1_empl_stat
aurora_standard.chmarsiins2_empl_stat
aurora_standard.chmarsiins3_empl_stat
aurora_standard.chmarstipmarital_stat
aurora_standard.chmarstpmarital_stat
aurora_standard.chmarstpqemp_stat
aurora_standard.chmarstpyemp_stat
aurora_standard.chmbillebill_stat
aurora_standard.chmcampiins1_empl_stat
aurora_standard.chmcampiins2_empl_stat
aurora_standard.chmcampiins3_empl_stat
aurora_standard.chmdfypddfy_stat
aurora_standard.chmexmpiins1_empl_stat
aurora_standard.chmexmpiins2_empl_stat
aurora_standard.chmexmpiins3_empl_stat
aurora_standard.chmhipadrestrictions_stat
aurora_standard.chmpatirempl_stat
aurora_standard.chmpdemoins1_empl_stat
aurora_standard.chmpdemoins2_empl_stat
aurora_standard.chmpdemoins3_empl_stat
aurora_standard.chmpresgdcg_stat
aurora_standard.chmpresg2dcg_stat
aurora_standard.chmpriccunit_per_stat
aurora_standard.chmradexins1_empl_stat
aurora_standard.chmradexins2_empl_stat
aurora_standard.chmradexins3_empl_stat
aurora_standard.chmroomdnurs_stat
aurora_standard.chmroomdbill_stat
aurora_standard.chmrtrndf_nurs_stat
aurora_standard.chmrtrndt_nurs_stat
aurora_standard.chmtkl1dcoll_stat
aurora_standard.chmtkl2dcoll_stat
aurora_standard.chmtkl3dcoll_stat
aurora_standard.chmtkl4dcoll_stat
aurora_standard.chmtkl5dcoll_stat
aurora_standard.chmtkl6dcoll_stat
aurora_standard.chmtkl7dcoll_stat
aurora_standard.chmtkl8dcoll_stat
aurora_standard.chmtkl9dcoll_stat
aurora_standard.chmutahmar_stat
aurora_standard.chmutah1mar_stat
aurora_standard.chmutah4mar_stat
aurora_standard.chmutahtemp_stat
aurora_standard.chpcemprmarital_stat
aurora_standard.chppersrmarital_stat
aurora_standard.chxexamdexam_stat
aurora_standard.chxexamrroutine_stat
aurora_standard.chxleasdexam_stat
aurora_standard.chxleasrroutine_stat
aurora_standard.chyrespdexam_stat
aurora_standard.chyresprroutine_stat
aurora_standard.hl7gt1guar_empl_stat
aurora_standard.hl7gt1ambul_stat
aurora_standard.hl7gt1job_stat
aurora_standard.hl7gt1adguar_empl_stat
aurora_standard.hl7in1billing_stat
aurora_standard.hl7in1ins_empl_stat
aurora_standard.hl7in1verif_stat
aurora_standard.hl7in1adbilling_stat
aurora_standard.hl7in1adins_empl_stat
aurora_standard.hl7in1adverif_stat
aurora_standard.hl7in2champus_stat
aurora_standard.hl7in2ambulatory_stat
aurora_standard.hl7in2marital_stat
aurora_standard.hl7in2adchampus_stat
aurora_standard.hl7in3sec_opn_stat
aurora_standard.hl7obrresult_stat
aurora_standard.hl7obxobserv_res_stat
aurora_standard.hl7pidmarital_stat
aurora_standard.hl7pidadmarital_stat
aurora_standard.hl7pv1ambul_stat
aurora_standard.hl7pv1bed_stat
aurora_standard.hl7pv1acct_stat
aurora_standard.hl7pv1adambul_stat
aurora_standard.hl7pv1adbed_stat
aurora_standard.hl7pv1adacct_stat
aurora_standard.stxautorauto_stat
aurora_standard.styemplrmarital_stat
aurora_standard.stytaxtdmarital_stat