aurora_standard.chmpricc

Field Type Null Default Key Extra Comment
service_code varchar(10) YES UNI
type_code varchar(1) YES MUL
department varchar(3) YES MUL
issue_unit varchar(10) YES
charge_1 decimal(16,2) YES
charge_2 decimal(16,2) YES
charge_3 decimal(16,2) YES
ub_flag varchar(1) YES
ub_rev_code varchar(10) YES MUL
flag_1500 varchar(1) YES MUL
cpt_code varchar(10) YES MUL
primary_descrip varchar(30) YES MUL
other_descrip varchar(20) YES
gl_inp_no int(11) YES
gl_inp_no_d varchar(3) YES
gl_out_no int(11) YES
gl_out_no_d varchar(3) YES
gl_snf_no int(11) YES
gl_snf_no_d varchar(3) YES
gl_oth_no int(11) YES
gl_oth_no_d varchar(3) YES
class_no varchar(6) YES MUL
unit_cost decimal(16,2) YES
other_cost decimal(16,2) YES
on_hand decimal(10,4) YES
vendor_no varchar(10) YES MUL
location varchar(20) YES MUL
when_charge varchar(1) YES
inactive_flag varchar(1) YES
ndc varchar(13) YES
hcpcs_code varchar(10) YES
state_flag varchar(1) YES
charge_calc varchar(1) YES
usage_code varchar(1) YES
min_level decimal(10,4) YES
md_rev_code varchar(4) YES
comm_rev_code varchar(4) YES
comm_cpt_code varchar(10) YES
lab_test varchar(1) YES
fac_no varchar(3) YES
mod_1 varchar(2) YES
mod_2 varchar(2) YES
mod_3 varchar(2) YES
mod_4 varchar(2) YES
mod_5 varchar(2) YES
tos varchar(2) YES
allow_zero varchar(1) YES
gl_stats varchar(1) YES
unit_per_stat decimal(6,3) YES
create_by int(11) YES
create_date date YES
update_by int(11) YES
update_date date YES
ndc_uom varchar(2) YES
ndc_qty decimal(8,3) YES
prev_charge_1 decimal(16,2) YES
charge1_eff_date date YES
chs_rowID bigint(20) unsigned NO PRI auto_increment

References

Local Column References
cpt_code
TableColumn
Loinc.loinc_codeslc_cpt_code
_1.clients_fee_schedules_mapcfsm_cpt_code
_1.clinical_interventions_test_codes_mapcitcm_cpt_code
_1.immunizations_cpt_mapicm_cpt_code
_1.insurances_allowables_cpt_mapiacm_cpt_code
_1.insurances_contracted_pricingicp_cpt_code
_1.insurances_contracted_pricing_logicpl_cpt_code
_1.patients_responsibility_estimates_servicesprests_cpt_code
_1188.clients_fee_schedules_mapcfsm_cpt_code
_1188.clinical_interventions_test_codes_mapcitcm_cpt_code
_1188.immunizations_cpt_mapicm_cpt_code
_1188.insurances_allowables_cpt_mapiacm_cpt_code
_1188.insurances_contracted_pricingicp_cpt_code
_1188.insurances_contracted_pricing_logicpl_cpt_code
_1188.patients_responsibility_estimates_servicesprests_cpt_code
_1218.clients_fee_schedules_mapcfsm_cpt_code
_1218.clinical_interventions_test_codes_mapcitcm_cpt_code
_1218.immunizations_cpt_mapicm_cpt_code
_1218.insurances_allowables_cpt_mapiacm_cpt_code
_1218.insurances_contracted_pricingicp_cpt_code
_1218.insurances_contracted_pricing_logicpl_cpt_code
_1218.patients_responsibility_estimates_servicesprests_cpt_code
_1548.clients_fee_schedules_mapcfsm_cpt_code
_1548.clinical_interventions_test_codes_mapcitcm_cpt_code
_1548.immunizations_cpt_mapicm_cpt_code
_1548.insurances_allowables_cpt_mapiacm_cpt_code
_1548.insurances_contracted_pricingicp_cpt_code
_1548.insurances_contracted_pricing_logicpl_cpt_code
_1548.patients_responsibility_estimates_servicesprests_cpt_code
_435.clients_fee_schedules_mapcfsm_cpt_code
_435.clinical_interventions_test_codes_mapcitcm_cpt_code
_435.immunizations_cpt_mapicm_cpt_code
_435.insurances_allowables_cpt_mapiacm_cpt_code
_435.insurances_contracted_pricingicp_cpt_code
_435.insurances_contracted_pricing_logicpl_cpt_code
_435.patients_responsibility_estimates_servicesprests_cpt_code
_436.clients_fee_schedules_mapcfsm_cpt_code
_436.clinical_interventions_test_codes_mapcitcm_cpt_code
_436.immunizations_cpt_mapicm_cpt_code
_436.insurances_allowables_cpt_mapiacm_cpt_code
_436.insurances_contracted_pricingicp_cpt_code
_436.insurances_contracted_pricing_logicpl_cpt_code
_436.patients_responsibility_estimates_servicesprests_cpt_code
_436_archive_testing.clients_fee_schedules_mapcfsm_cpt_code
_436_archive_testing.clinical_interventions_test_codes_mapcitcm_cpt_code
_436_archive_testing.immunizations_cpt_mapicm_cpt_code
_436_archive_testing.insurances_allowables_cpt_mapiacm_cpt_code
_436_archive_testing.insurances_contracted_pricingicp_cpt_code
_436_archive_testing.insurances_contracted_pricing_logicpl_cpt_code
_436_archive_testing.patients_responsibility_estimates_servicesprests_cpt_code
_437.clients_fee_schedules_mapcfsm_cpt_code
_437.clinical_interventions_test_codes_mapcitcm_cpt_code
_437.immunizations_cpt_mapicm_cpt_code
_437.insurances_allowables_cpt_mapiacm_cpt_code
_437.insurances_contracted_pricingicp_cpt_code
_437.insurances_contracted_pricing_logicpl_cpt_code
_437.patients_responsibility_estimates_servicesprests_cpt_code
_8.clients_fee_schedules_mapcfsm_cpt_code
_8.clinical_interventions_test_codes_mapcitcm_cpt_code
_8.immunizations_cpt_mapicm_cpt_code
_8.insurances_allowables_cpt_mapiacm_cpt_code
_8.insurances_contracted_pricingicp_cpt_code
_8.insurances_contracted_pricing_logicpl_cpt_code
_8.patients_responsibility_estimates_servicesprests_cpt_code
_81.clients_fee_schedules_mapcfsm_cpt_code
_81.clinical_interventions_test_codes_mapcitcm_cpt_code
_81.immunizations_cpt_mapicm_cpt_code
_81.insurances_allowables_cpt_mapiacm_cpt_code
_81.insurances_contracted_pricingicp_cpt_code
_81.insurances_contracted_pricing_logicpl_cpt_code
_81.patients_responsibility_estimates_servicesprests_cpt_code
_999.clients_fee_schedules_mapcfsm_cpt_code
_999.clinical_interventions_test_codes_mapcitcm_cpt_code
_999.immunizations_cpt_mapicm_cpt_code
_999.insurances_allowables_cpt_mapiacm_cpt_code
_999.insurances_contracted_pricingicp_cpt_code
_999.insurances_contracted_pricing_logicpl_cpt_code
_999.patients_responsibility_estimates_servicesprests_cpt_code
aurora_standard.axlscdmmd_cpt_code
aurora_standard.axlscdmci_cpt_code
aurora_standard.c5cdmoth_cpt_code
aurora_standard.c5cdmwc_cpt_code
aurora_standard.c5cdmcomm_cpt_code
aurora_standard.c5cdmdroth_cpt_code
aurora_standard.c5cdmdrwc_cpt_code
aurora_standard.c5cdmdrcomm_cpt_code
aurora_standard.c7cdmcomm_cpt_code
aurora_standard.c8cdmcomm_cpt_code
aurora_standard.chmpricaprev_cpt_code
aurora_standard.chmpricacur_cpt_code
aurora_standard.glspricecomm_cpt_code
common.loinc_codeslc_cpt_code
common.mednecmed_cpt_code
common.test_codes_cpttcc_cpt_code
ndc
TableColumn
_1.charts_cpt_codeschcp_ndc
_1.configured_encounters_templates_cpt_codescetcc_ndc
_1.encounters_cpt_codesecp_ndc
_1.encounters_cpt_codes_templatesecpt_ndc
_1.immunizationsimz_ndc
_1188.charts_cpt_codeschcp_ndc
_1188.configured_encounters_templates_cpt_codescetcc_ndc
_1188.encounters_cpt_codesecp_ndc
_1188.encounters_cpt_codes_templatesecpt_ndc
_1188.immunizationsimz_ndc
_1218.charts_cpt_codeschcp_ndc
_1218.configured_encounters_templates_cpt_codescetcc_ndc
_1218.encounters_cpt_codesecp_ndc
_1218.encounters_cpt_codes_templatesecpt_ndc
_1218.immunizationsimz_ndc
_1548.charts_cpt_codeschcp_ndc
_1548.configured_encounters_templates_cpt_codescetcc_ndc
_1548.encounters_cpt_codesecp_ndc
_1548.encounters_cpt_codes_templatesecpt_ndc
_1548.immunizationsimz_ndc
_435.charts_cpt_codeschcp_ndc
_435.configured_encounters_templates_cpt_codescetcc_ndc
_435.encounters_cpt_codesecp_ndc
_435.encounters_cpt_codes_templatesecpt_ndc
_435.immunizationsimz_ndc
_436.charts_cpt_codeschcp_ndc
_436.configured_encounters_templates_cpt_codescetcc_ndc
_436.encounters_cpt_codesecp_ndc
_436.encounters_cpt_codes_templatesecpt_ndc
_436.immunizationsimz_ndc
_436_archive_testing.charts_cpt_codeschcp_ndc
_436_archive_testing.configured_encounters_templates_cpt_codescetcc_ndc
_436_archive_testing.encounters_cpt_codesecp_ndc
_436_archive_testing.encounters_cpt_codes_templatesecpt_ndc
_436_archive_testing.immunizationsimz_ndc
_437.charts_cpt_codeschcp_ndc
_437.configured_encounters_templates_cpt_codescetcc_ndc
_437.encounters_cpt_codesecp_ndc
_437.encounters_cpt_codes_templatesecpt_ndc
_437.immunizationsimz_ndc
_8.charts_cpt_codeschcp_ndc
_8.configured_encounters_templates_cpt_codescetcc_ndc
_8.encounters_cpt_codesecp_ndc
_8.encounters_cpt_codes_templatesecpt_ndc
_8.immunizationsimz_ndc
_81.charts_cpt_codeschcp_ndc
_81.configured_encounters_templates_cpt_codescetcc_ndc
_81.encounters_cpt_codesecp_ndc
_81.encounters_cpt_codes_templatesecpt_ndc
_81.immunizationsimz_ndc
_999.charts_cpt_codeschcp_ndc
_999.configured_encounters_templates_cpt_codescetcc_ndc
_999.encounters_cpt_codesecp_ndc
_999.encounters_cpt_codes_templatesecpt_ndc
_999.immunizationsimz_ndc
template_library.encounters_cpt_codes_templatesecpt_ndc
create_date
TableColumn
_1.configured_encountersconfenc_create_date
_1548.configured_encountersconfenc_create_date
_435.configured_encountersconfenc_create_date
_436.configured_encountersconfenc_create_date
_436_archive_testing.configured_encountersconfenc_create_date
_437.configured_encountersconfenc_create_date
_8.configured_encountersconfenc_create_date
_999.configured_encountersconfenc_create_date
location
TableColumn
_1.cpoe_responsescpoe_res_location
_1.encounters_soap_vitalsespv_location
_1.hl7_accessionsacc_location
_1.patients_immunizationspim_location
_1.precertspre_scheduled_location
_1.precerts_mapprem_location
_1.radiology_resultsrad_res_location
_1188.cpoe_responsescpoe_res_location
_1188.encounters_soap_vitalsespv_location
_1188.hl7_accessionsacc_location
_1188.patients_immunizationspim_location
_1188.precertspre_scheduled_location
_1188.precerts_mapprem_location
_1188.radiology_resultsrad_res_location
_1218.cpoe_responsescpoe_res_location
_1218.encounters_soap_vitalsespv_location
_1218.hl7_accessionsacc_location
_1218.patients_immunizationspim_location
_1218.precertspre_scheduled_location
_1218.precerts_mapprem_location
_1218.radiology_resultsrad_res_location
_1548.cpoe_responsescpoe_res_location
_1548.encounters_soap_vitalsespv_location
_1548.hl7_accessionsacc_location
_1548.patients_immunizationspim_location
_1548.precertspre_scheduled_location
_1548.precerts_mapprem_location
_1548.radiology_resultsrad_res_location
_435.cpoe_responsescpoe_res_location
_435.encounters_soap_vitalsespv_location
_435.hl7_accessionsacc_location
_435.patients_immunizationspim_location
_435.precertspre_scheduled_location
_435.precerts_mapprem_location
_435.radiology_resultsrad_res_location
_436.cpoe_responsescpoe_res_location
_436.encounters_soap_vitalsespv_location
_436.hl7_accessionsacc_location
_436.patients_immunizationspim_location
_436.precertspre_scheduled_location
_436.precerts_mapprem_location
_436.radiology_resultsrad_res_location
_436_archive_testing.cpoe_responsescpoe_res_location
_436_archive_testing.encounters_soap_vitalsespv_location
_436_archive_testing.hl7_accessionsacc_location
_436_archive_testing.patients_immunizationspim_location
_436_archive_testing.precertspre_scheduled_location
_436_archive_testing.precerts_mapprem_location
_436_archive_testing.radiology_resultsrad_res_location
_437.cpoe_responsescpoe_res_location
_437.encounters_soap_vitalsespv_location
_437.hl7_accessionsacc_location
_437.patients_immunizationspim_location
_437.precertspre_scheduled_location
_437.precerts_mapprem_location
_437.radiology_resultsrad_res_location
_8.cpoe_responsescpoe_res_location
_8.encounters_soap_vitalsespv_location
_8.hl7_accessionsacc_location
_8.patients_immunizationspim_location
_8.precertspre_scheduled_location
_8.precerts_mapprem_location
_8.radiology_resultsrad_res_location
_81.cpoe_responsescpoe_res_location
_81.encounters_soap_vitalsespv_location
_81.hl7_accessionsacc_location
_81.patients_immunizationspim_location
_81.precertspre_scheduled_location
_81.precerts_mapprem_location
_81.radiology_resultsrad_res_location
_999.cpoe_responsescpoe_res_location
_999.encounters_soap_vitalsespv_location
_999.hl7_accessionsacc_location
_999.patients_immunizationspim_location
_999.precertspre_scheduled_location
_999.precerts_mapprem_location
_999.radiology_resultsrad_res_location
aurora_standard.bhguaremp_location
aurora_standard.bhtguaremp_location
aurora_standard.chpinsrdclass_location
aurora_standard.chplocacclass_location
aurora_standard.chqcmeudcme_location
aurora_standard.chqletrdletter_location
aurora_standard.chrcntrcrx_location
aurora_standard.mergdocsfile_location
aurora_standard.mergsigsfile_location
aurora_standard.sthcadjdstock_location
aurora_standard.sticadjdstock_location
aurora_standard.stilocarstock_location
aurora_standard.stipyxlcrev_location
aurora_standard.stipyxlcexp_location
aurora_standard.stistkldstock_location
aurora_standard.stock2stock_location
aurora_standard.stoshipdstock_location
aurora_standard.tmplocarstock_location
type_code
TableColumn
_1.hl7_accessionsacc_type_code
_1.patients_icd9_problems_dx_modifierspipdm_type_code
_1188.hl7_accessionsacc_type_code
_1188.patients_icd9_problems_dx_modifierspipdm_type_code
_1218.hl7_accessionsacc_type_code
_1218.patients_icd9_problems_dx_modifierspipdm_type_code
_1548.hl7_accessionsacc_type_code
_1548.patients_icd9_problems_dx_modifierspipdm_type_code
_435.hl7_accessionsacc_type_code
_435.patients_icd9_problems_dx_modifierspipdm_type_code
_436.hl7_accessionsacc_type_code
_436.patients_icd9_problems_dx_modifierspipdm_type_code
_436_archive_testing.hl7_accessionsacc_type_code
_436_archive_testing.patients_icd9_problems_dx_modifierspipdm_type_code
_437.hl7_accessionsacc_type_code
_437.patients_icd9_problems_dx_modifierspipdm_type_code
_8.hl7_accessionsacc_type_code
_8.patients_icd9_problems_dx_modifierspipdm_type_code
_81.hl7_accessionsacc_type_code
_81.patients_icd9_problems_dx_modifierspipdm_type_code
_999.hl7_accessionsacc_type_code
_999.patients_icd9_problems_dx_modifierspipdm_type_code
aurora_standard.stmaintdmaint_type_code
aurora_standard.stmnotednote_type_code
aurora_standard.stmwarrdwarr_type_code
common.clientscli_service_type_code
mod_1
TableColumn
aurora_standard.axlscdmmd_mod_1
aurora_standard.axlscdmci_mod_1
aurora_standard.chmpricaprev_mod_1
aurora_standard.chmpricacur_mod_1
mod_2
TableColumn
aurora_standard.axlscdmmd_mod_2
aurora_standard.axlscdmci_mod_2
aurora_standard.chmpricaprev_mod_2
aurora_standard.chmpricacur_mod_2
ub_flag
TableColumn
aurora_standard.axlscdmmd_ub_flag
aurora_standard.axlscdmci_ub_flag
fac_no
TableColumn
aurora_standard.chmpricaprev_fac_no
aurora_standard.chmpricacur_fac_no
aurora_standard.chpcashrcash_fac_no
aurora_standard.chpcobpdcash_fac_no
aurora_standard.chpcobpdbal_fac_no
aurora_standard.chscustddept_fac_no
aurora_standard.chshotlrdept_fac_no
aurora_standard.chtemplrdflt_fac_no
aurora_standard.curs_tempcash_fac_no
aurora_standard.curs_tempap_fac_no
aurora_standard.stgrowpdrod_beg_fac_no
aurora_standard.stgrowpdrod_end_fac_no
aurora_standard.stpcashddist_fac_no
aurora_standard.stpcashddisc_fac_no
aurora_standard.stpcashecash_fac_no
aurora_standard.stpcntrccash_fac_no
aurora_standard.stpcntrcdisc_fac_no
aurora_standard.stpinvcecash_fac_no
aurora_standard.stpopendap_fac_no
aurora_standard.stpopendcash_fac_no
aurora_standard.stucntrccash_fac_no
aurora_standard.stuinvcecash_fac_no
aurora_standard.stxfinsdfin_fac_no
aurora_standard.styaccrrliab_fac_no
aurora_standard.styaccrrexpense_fac_no
aurora_standard.styemplrcash_fac_no
aurora_standard.stypayfdcash_fac_no
aurora_standard.stypayodbal_fac_no
aurora_standard.stypayrecash_fac_no
aurora_standard.styrevsdcash_fac_no
aurora_standard.stytypercash_fac_no
ub_rev_code
TableColumn
aurora_standard.chmstatcdef_ub_rev_code
class_no
TableColumn
aurora_standard.chrhhdccproduct_class_no
aurora_standard.chrhhmprproduct_class_no
aurora_standard.drugclasproduct_class_no
department
TableColumn
aurora_standard.curs_tempcash_department
aurora_standard.sticntrcuse_department
aurora_standard.stpcashddist_department
aurora_standard.stpcashddisc_department
aurora_standard.stpcashecash_department
aurora_standard.stpcasheoa_department
aurora_standard.stpinvcedisc_department
aurora_standard.stpinvceap_department
aurora_standard.stpinvcecash_department
aurora_standard.stpopendap_department
aurora_standard.stpopendcash_department
aurora_standard.stpvendrcash_department
aurora_standard.stpvendrexp_department
aurora_standard.strcashddist_department
aurora_standard.strcashddisc_department
aurora_standard.strcashecash_department
aurora_standard.strcasheoa_department
aurora_standard.strinvcedisc_department
aurora_standard.strinvcetax_department
aurora_standard.strinvcefrght_department
aurora_standard.strinvcemisc_department
aurora_standard.strinvcear_department
aurora_standard.stropendar_department
aurora_standard.stucntrcuse_department
aurora_standard.styapckddist_department
aurora_standard.stydeddvhome_department
aurora_standard.stydeddvgl_department
aurora_standard.styincdvhome_department
aurora_standard.styincdvgl_department
aurora_standard.styobldvhome_department
aurora_standard.styobldvgl_department
aurora_standard.styptodvhome_department
common.service_ticketsstc_department
unit_cost
TableColumn
aurora_standard.gary13calc_avg_unit_cost
aurora_standard.gary14calc_avg_unit_cost
aurora_standard.gary2avg_unit_cost
aurora_standard.pharm1pricc_unit_cost
aurora_standard.stilocaravg_unit_cost
aurora_standard.stilocarpurch_unit_cost
aurora_standard.stipurcdpurch_unit_cost
aurora_standard.tmplocaravg_unit_cost
aurora_standard.tmplocarpurch_unit_cost
on_hand
TableColumn
aurora_standard.sthcadjdqty_on_hand
aurora_standard.sticadjdqty_on_hand
aurora_standard.stilocarqty_on_hand
aurora_standard.tmplocarqty_on_hand
update_by
TableColumn
aurora_standard.stmaintdmaint_update_by
aurora_standard.stmnotednote_update_by
aurora_standard.stmwarrdwarr_update_by
update_date
TableColumn
aurora_standard.stmaintdmaint_update_date
aurora_standard.stmnotednote_update_date
aurora_standard.stmwarrdwarr_update_date