aurora_standard.chmsubcc

Field Type Null Default Key Extra Comment
contract_code varchar(10) YES
con_no smallint(6) YES
pat_type varchar(10) YES
claim_type varchar(2) YES
descrip varchar(30) YES
method varchar(10) YES
method_no smallint(6) YES UNI
start_rev_cd varchar(4) YES
end_rev_cd varchar(4) YES
start_cpt varchar(10) YES
end_cpt varchar(10) YES
modifier varchar(2) YES
start_icd9p varchar(10) YES
end_icd9p varchar(10) YES
phy_no smallint(6) YES
stop_loss decimal(10,2) YES
lesr_of_chgs varchar(1) YES
chs_rowID bigint(20) unsigned NO PRI auto_increment

References

Local Column References
method
TableColumn
API.request_logs_v2http_method
HSPI_System.web_hook_request_logshttp_method
_1.encounters_soap_snapshotsesss_storage_method
_1.patientspat_contact_method
_1.patientspat_apt_not_contact_method
_1.patients_demographics_snapshotspds_contact_method
_1.patients_demographics_snapshotspds_apt_not_contact_method
_1.patients_prescriptionsprx_send_method
_1.recall_listrcl_contact_method
_1188.encounters_soap_snapshotsesss_storage_method
_1188.patientspat_contact_method
_1188.patientspat_apt_not_contact_method
_1188.patients_demographics_snapshotspds_contact_method
_1188.patients_demographics_snapshotspds_apt_not_contact_method
_1188.patients_prescriptionsprx_send_method
_1188.recall_listrcl_contact_method
_1218.encounters_soap_snapshotsesss_storage_method
_1218.patientspat_contact_method
_1218.patientspat_apt_not_contact_method
_1218.patients_demographics_snapshotspds_contact_method
_1218.patients_demographics_snapshotspds_apt_not_contact_method
_1218.patients_prescriptionsprx_send_method
_1218.recall_listrcl_contact_method
_1548.encounters_soap_snapshotsesss_storage_method
_1548.patientspat_contact_method
_1548.patientspat_apt_not_contact_method
_1548.patients_demographics_snapshotspds_contact_method
_1548.patients_demographics_snapshotspds_apt_not_contact_method
_1548.patients_prescriptionsprx_send_method
_1548.recall_listrcl_contact_method
_435.encounters_soap_snapshotsesss_storage_method
_435.patientspat_contact_method
_435.patientspat_apt_not_contact_method
_435.patients_demographics_snapshotspds_contact_method
_435.patients_demographics_snapshotspds_apt_not_contact_method
_435.patients_prescriptionsprx_send_method
_435.recall_listrcl_contact_method
_436.encounters_soap_snapshotsesss_storage_method
_436.patientspat_contact_method
_436.patientspat_apt_not_contact_method
_436.patients_demographics_snapshotspds_contact_method
_436.patients_demographics_snapshotspds_apt_not_contact_method
_436.patients_prescriptionsprx_send_method
_436.recall_listrcl_contact_method
_436_archive_testing.encounters_soap_snapshotsesss_storage_method
_436_archive_testing.patientspat_contact_method
_436_archive_testing.patientspat_apt_not_contact_method
_436_archive_testing.patients_demographics_snapshotspds_contact_method
_436_archive_testing.patients_demographics_snapshotspds_apt_not_contact_method
_436_archive_testing.patients_prescriptionsprx_send_method
_436_archive_testing.recall_listrcl_contact_method
_437.encounters_soap_snapshotsesss_storage_method
_437.patientspat_contact_method
_437.patientspat_apt_not_contact_method
_437.patients_demographics_snapshotspds_contact_method
_437.patients_demographics_snapshotspds_apt_not_contact_method
_437.patients_prescriptionsprx_send_method
_437.recall_listrcl_contact_method
_8.encounters_soap_snapshotsesss_storage_method
_8.patientspat_contact_method
_8.patientspat_apt_not_contact_method
_8.patients_demographics_snapshotspds_contact_method
_8.patients_demographics_snapshotspds_apt_not_contact_method
_8.patients_prescriptionsprx_send_method
_8.recall_listrcl_contact_method
_81.encounters_soap_snapshotsesss_storage_method
_81.patientspat_contact_method
_81.patientspat_apt_not_contact_method
_81.patients_demographics_snapshotspds_contact_method
_81.patients_demographics_snapshotspds_apt_not_contact_method
_81.patients_prescriptionsprx_send_method
_81.recall_listrcl_contact_method
_999.encounters_soap_snapshotsesss_storage_method
_999.patientspat_contact_method
_999.patientspat_apt_not_contact_method
_999.patients_demographics_snapshotspds_contact_method
_999.patients_demographics_snapshotspds_apt_not_contact_method
_999.patients_prescriptionsprx_send_method
_999.recall_listrcl_contact_method
aurora_standard.chmhidiacoding_method
aurora_standard.chminsrcclaim_method
aurora_standard.chmutah7prcode_method
aurora_standard.chpinsucclaim_method
aurora_standard.chtcntrcpay_method
aurora_standard.defaultspay_method
aurora_standard.sticntrccost_method
aurora_standard.stoinvcepay_method
aurora_standard.stoordrepay_method
aurora_standard.stppytorpay_method
aurora_standard.stpvendrpay_method
aurora_standard.strcustrpay_method
aurora_standard.strcustrcc_method
aurora_standard.styaccrraccr_method
aurora_standard.styoctccqualifying_offer_method
common.clients_contract_dataccd_invoicing_method
common.clients_contract_dataccd_payment_method
common.clients_contract_dataccd_collections_method
common.usersusr_apersona_contact_method
xlnt.loghttp_method
modifier
TableColumn
_1.clients_fee_schedules_mapcfsm_modifier
_1.cptcpt_modifier
_1.cpt_analysis_codescac_modifier
_1188.clients_fee_schedules_mapcfsm_modifier
_1188.cptcpt_modifier
_1188.cpt_analysis_codescac_modifier
_1218.clients_fee_schedules_mapcfsm_modifier
_1218.cptcpt_modifier
_1218.cpt_analysis_codescac_modifier
_1548.clients_fee_schedules_mapcfsm_modifier
_1548.cptcpt_modifier
_1548.cpt_analysis_codescac_modifier
_435.clients_fee_schedules_mapcfsm_modifier
_435.cptcpt_modifier
_435.cpt_analysis_codescac_modifier
_436.clients_fee_schedules_mapcfsm_modifier
_436.cptcpt_modifier
_436.cpt_analysis_codescac_modifier
_436_archive_testing.clients_fee_schedules_mapcfsm_modifier
_436_archive_testing.cptcpt_modifier
_436_archive_testing.cpt_analysis_codescac_modifier
_437.clients_fee_schedules_mapcfsm_modifier
_437.cptcpt_modifier
_437.cpt_analysis_codescac_modifier
_8.clients_fee_schedules_mapcfsm_modifier
_8.cptcpt_modifier
_8.cpt_analysis_codescac_modifier
_81.clients_fee_schedules_mapcfsm_modifier
_81.cptcpt_modifier
_81.cpt_analysis_codescac_modifier
_999.clients_fee_schedules_mapcfsm_modifier
_999.cptcpt_modifier
_999.cpt_analysis_codescac_modifier
aurora_standard.chmachgdcpt_modifier
common.cqm_conditionscqc_target_att_modifier
common.cqm_conditionscqc_target2_att_modifier
template_library.cptcpt_modifier
claim_type
TableColumn
_1.encounters_claims_filesecf_claim_type
_1188.encounters_claims_filesecf_claim_type
_1218.encounters_claims_filesecf_claim_type
_1548.encounters_claims_filesecf_claim_type
_435.encounters_claims_filesecf_claim_type
_436.encounters_claims_filesecf_claim_type
_436_archive_testing.encounters_claims_filesecf_claim_type
_437.encounters_claims_filesecf_claim_type
_8.encounters_claims_filesecf_claim_type
_81.encounters_claims_filesecf_claim_type
_999.encounters_claims_filesecf_claim_type
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
phy_no
TableColumn
aurora_standard.bsinsurfam_phy_no
aurora_standard.c7mpipri_phy_no
aurora_standard.campifam_phy_no
aurora_standard.chmabstradmit_phy_no
aurora_standard.chmabstrattend_phy_no
aurora_standard.chmarsifam_phy_no
aurora_standard.chmcampifam_phy_no
aurora_standard.chmexmpifam_phy_no
aurora_standard.chmpatmrfam_phy_no
aurora_standard.chmpdemofam_phy_no
aurora_standard.chmradexfam_phy_no
aurora_standard.chpwkmnrrefer_phy_no