aurora_standard.stiinvtr

Field Type Null Default Key Extra Comment
item_code varchar(20) YES UNI
item_type varchar(1) YES
item_class varchar(6) YES
price_group varchar(6) YES
desc1 varchar(30) YES
desc2 varchar(30) YES
weight decimal(8,3) YES
weight_unit varchar(2) YES
volume decimal(8,3) YES
inv_acct_no int(11) YES
cog_acct_no int(11) YES
sales_acct_no int(11) YES
sell_unit varchar(2) YES
bill_unit varchar(2) YES
stock_unit varchar(2) YES
purch_unit varchar(2) YES
sell_factor decimal(6,2) YES
bill_factor decimal(6,2) YES
purch_factor decimal(6,2) YES
serialized varchar(1) YES
market_price varchar(1) YES
commodity_code varchar(10) YES
department varchar(3) YES
ub_flag varchar(1) YES
ub_rev_code varchar(10) YES
flag_1500 varchar(1) YES
cpt_code varchar(10) YES
when_charge varchar(1) YES
hcpc_code varchar(10) YES
contract_flag varchar(1) YES
contract_no varchar(20) YES
contract_cost decimal(10,2) YES
contract_exp date YES
charge_2 decimal(16,2) YES
gl_inp_no int(11) YES
gl_out_no int(11) YES
gl_snf_no int(11) YES
gl_oth_no int(11) YES
supp_acct_no int(11) YES
case_qty int(11) YES
brand_name varchar(10) YES
item_obsolete varchar(1) YES
location varchar(3) YES
pharmacy varchar(1) YES
misc1 varchar(6) YES
misc2 varchar(6) YES
misc3 varchar(6) YES
misc4 varchar(20) YES
misc5 varchar(20) YES
misc6 varchar(6) YES
taxable varchar(1) 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.chmpricccomm_cpt_code
aurora_standard.glspricecomm_cpt_code
common.loinc_codeslc_cpt_code
common.mednecmed_cpt_code
common.test_codes_cpttcc_cpt_code
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
weight
TableColumn
_1.encounters_soap_vitalsespv_weight
_1.orders_afpsoafp_weight
_1.patients_vitalspvs_weight
_1188.encounters_soap_vitalsespv_weight
_1188.orders_afpsoafp_weight
_1188.patients_vitalspvs_weight
_1218.encounters_soap_vitalsespv_weight
_1218.orders_afpsoafp_weight
_1218.patients_vitalspvs_weight
_1548.encounters_soap_vitalsespv_weight
_1548.orders_afpsoafp_weight
_1548.patients_vitalspvs_weight
_435.encounters_soap_vitalsespv_weight
_435.orders_afpsoafp_weight
_435.patients_vitalspvs_weight
_436.encounters_soap_vitalsespv_weight
_436.orders_afpsoafp_weight
_436.patients_vitalspvs_weight
_436_archive_testing.encounters_soap_vitalsespv_weight
_436_archive_testing.orders_afpsoafp_weight
_436_archive_testing.patients_vitalspvs_weight
_437.encounters_soap_vitalsespv_weight
_437.orders_afpsoafp_weight
_437.patients_vitalspvs_weight
_8.encounters_soap_vitalsespv_weight
_8.orders_afpsoafp_weight
_8.patients_vitalspvs_weight
_81.encounters_soap_vitalsespv_weight
_81.orders_afpsoafp_weight
_81.patients_vitalspvs_weight
_999.encounters_soap_vitalsespv_weight
_999.orders_afpsoafp_weight
_999.patients_vitalspvs_weight
aurora_standard.chmarsthib_weight
aurora_standard.chmdrgccrel_weight
aurora_standard.chxhistrh_weight
aurora_standard.ordersship_weight
aurora_standard.stoinvceship_weight
aurora_standard.stoordrdship_weight
aurora_standard.stoordreship_weight
aurora_standard.stoshipdship_weight
aurora_standard.stuordretotal_weight
aurora_standard.workdrgrel_weight
common.encounters_statusesess_weight
common.precerts_statusespss_weight
common.precerts_statusesps_weight
brand_name
TableColumn
_1.inventoryinv_brand_name
_1.patients_immunizationspim_brand_name
_1.patients_implantable_devicespid_brand_name
_1188.inventoryinv_brand_name
_1188.patients_immunizationspim_brand_name
_1188.patients_implantable_devicespid_brand_name
_1218.inventoryinv_brand_name
_1218.patients_immunizationspim_brand_name
_1218.patients_implantable_devicespid_brand_name
_1548.inventoryinv_brand_name
_1548.patients_immunizationspim_brand_name
_1548.patients_implantable_devicespid_brand_name
_435.inventoryinv_brand_name
_435.patients_immunizationspim_brand_name
_435.patients_implantable_devicespid_brand_name
_436.inventoryinv_brand_name
_436.patients_immunizationspim_brand_name
_436.patients_implantable_devicespid_brand_name
_436_archive_testing.inventoryinv_brand_name
_436_archive_testing.patients_immunizationspim_brand_name
_436_archive_testing.patients_implantable_devicespid_brand_name
_437.inventoryinv_brand_name
_437.patients_immunizationspim_brand_name
_437.patients_implantable_devicespid_brand_name
_8.inventoryinv_brand_name
_8.patients_immunizationspim_brand_name
_8.patients_implantable_devicespid_brand_name
_81.inventoryinv_brand_name
_81.patients_immunizationspim_brand_name
_81.patients_implantable_devicespid_brand_name
_999.inventoryinv_brand_name
_999.patients_immunizationspim_brand_name
_999.patients_implantable_devicespid_brand_name
common.drugsdrg_brand_name
common.vaccines_manufacturers_mapvmm_brand_name
volume
TableColumn
_1.ordersord_volume
_1.orders_templatesordt_volume
_1.radiology_ordersrad_volume
_1188.ordersord_volume
_1188.orders_templatesordt_volume
_1188.radiology_ordersrad_volume
_1218.ordersord_volume
_1218.orders_templatesordt_volume
_1218.radiology_ordersrad_volume
_1548.ordersord_volume
_1548.orders_templatesordt_volume
_1548.radiology_ordersrad_volume
_435.ordersord_volume
_435.orders_templatesordt_volume
_435.radiology_ordersrad_volume
_436.ordersord_volume
_436.orders_templatesordt_volume
_436.radiology_ordersrad_volume
_436_archive_testing.ordersord_volume
_436_archive_testing.orders_templatesordt_volume
_436_archive_testing.radiology_ordersrad_volume
_437.ordersord_volume
_437.orders_templatesordt_volume
_437.radiology_ordersrad_volume
_8.ordersord_volume
_8.orders_templatesordt_volume
_8.radiology_ordersrad_volume
_81.ordersord_volume
_81.orders_templatesordt_volume
_81.radiology_ordersrad_volume
_999.ordersord_volume
_999.orders_templatesordt_volume
_999.radiology_ordersrad_volume
common.test_codestco_x_minimum_specimen_volume
rcmroi.dev__rcm_roi_resultsmonthly_claim_volume
rcmroi.prod__rcm_roi_resultsmonthly_claim_volume
rcmroi.test__rcm_roi_resultsmonthly_claim_volume
template_library.orders_templatesordt_volume
ub_flag
TableColumn
aurora_standard.axlscdmmd_ub_flag
aurora_standard.axlscdmci_ub_flag
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
ub_rev_code
TableColumn
aurora_standard.chmstatcdef_ub_rev_code
inv_acct_no
TableColumn
aurora_standard.chrcntrcrx_inv_acct_no
item_class
TableColumn
aurora_standard.chrcntrcrx_item_class
item_type
TableColumn
aurora_standard.chrcntrcrx_item_type
aurora_standard.stultyprline_item_type
desc1
TableColumn
aurora_standard.chrschdrlabel_desc1
aurora_standard.chshotlrprob_desc1
aurora_standard.chsmodsrprob_desc1
aurora_standard.stmmastrwarr_desc1
aurora_standard.styocovccoverage_desc1
aurora_standard.styosafcsafe_desc1
desc2
TableColumn
aurora_standard.chrschdrlabel_desc2
aurora_standard.chshotlrprob_desc2
aurora_standard.chsmodsrprob_desc2
aurora_standard.stmaintdmaint_desc2
aurora_standard.stmmastrwarr_desc2
aurora_standard.sturondcrounding_desc2
aurora_standard.stymesgcmessage_desc2
aurora_standard.styocovccoverage_desc2
aurora_standard.styosafcsafe_desc2
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
taxable
TableColumn
aurora_standard.oddpayreinc_taxable
aurora_standard.odhpayreinc_taxable
aurora_standard.stpinvceinternet_taxable
aurora_standard.stpopendinternet_taxable
aurora_standard.stuinvceinternet_taxable
aurora_standard.stypayreinc_taxable
sales_acct_no
TableColumn
aurora_standard.strcntrcar_sales_acct_no