aurora_standard.chmcptcc

Field Type Null Default Key Extra Comment
number varchar(10) YES UNI
descrip varchar(40) YES MUL
del_date date YES
descrip_2 varchar(60) YES
sex_only varchar(1) YES
date_added date YES
apc varchar(5) YES
status_ind varchar(2) YES
rhc_qv varchar(2) 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
descrip
TableColumn
aurora_standard.addcdmbill_descrip
aurora_standard.afcdmdept_descrip
aurora_standard.afcdmbill_descrip
aurora_standard.apscdmbill_descrip
aurora_standard.apscdm2bill_descrip
aurora_standard.apscdmabill_descrip
aurora_standard.aseycmcbill_descrip
aurora_standard.aseycmhbill_descrip
aurora_standard.aswcdmbill_descrip
aurora_standard.axlscdmbill_descrip
aurora_standard.bdcdmdept_descrip
aurora_standard.bdcdmbill_descrip
aurora_standard.becdmbill_descrip
aurora_standard.bfcdmdept_descrip
aurora_standard.bfcdmbill_descrip
aurora_standard.bfcdminvbill_descrip
aurora_standard.bfcdmprobill_descrip
aurora_standard.bfcdmrhcbill_descrip
aurora_standard.bfrhccdmdept_descrip
aurora_standard.bfrhccdmbill_descrip
aurora_standard.bgcdmbill_descrip
aurora_standard.bmcdmbill_descrip
aurora_standard.bokcdmbill_descrip
aurora_standard.bpcdmhosbill_descrip
aurora_standard.bpcdmrhcbill_descrip
aurora_standard.bvcdmbill_descrip
aurora_standard.bvclncdmbill_descrip
aurora_standard.c5cdmbill_descrip
aurora_standard.c5cdmdrbill_descrip
aurora_standard.c7cdmprimary_descrip
aurora_standard.c7cdmother_descrip
aurora_standard.c7cdm720bill_descrip
aurora_standard.c7cdmoldbill_descrip
aurora_standard.c7cdmrxbill_descrip
aurora_standard.c7cdmsphbill_descrip
aurora_standard.c7cdmsupbill_descrip
aurora_standard.c7cdmxlsbill_descrip
aurora_standard.c7dmebill_descrip
aurora_standard.c8cdmprimary_descrip
aurora_standard.c8cdmother_descrip
aurora_standard.chmapcdcd_descrip
aurora_standard.chmapcjcj_descrip
aurora_standard.chmapckck_descrip
aurora_standard.chmapcpcp_descrip
aurora_standard.chmclocdloc_descrip
aurora_standard.chmerapcera_descrip
aurora_standard.chmmnecbpolicy_descrip
aurora_standard.chmoceeco_descrip
aurora_standard.chmprchdprev_descrip
aurora_standard.chmprchdcur_descrip
aurora_standard.chmpriccprimary_descrip
aurora_standard.chmpriccother_descrip
aurora_standard.chmradexps_descrip
aurora_standard.chplocaclocation_descrip
aurora_standard.chractpcactn_descrip
aurora_standard.chractscactns_descrip
aurora_standard.chrintpcpi_descrip
aurora_standard.chrintscpis_descrip
aurora_standard.drg_workw_descrip
aurora_standard.glspriceprimary_descrip
aurora_standard.glspriceother_descrip
aurora_standard.hl7ft1trans_descrip
aurora_standard.samcdmcbill_descrip
aurora_standard.stonwallbill_descrip
aurora_standard.sturaterrate_descrip
aurora_standard.workdescw_descrip
apc
TableColumn
aurora_standard.chmcptcdest_apc
aurora_standard.chmcptcdactual_apc
aurora_standard.chmhaadrdr_apc
aurora_standard.chmhaapypy_apc
aurora_standard.workcptwk_apc