aurora_standard.ttiinvtr

Field Type Null Default Key Extra Comment
item_code varchar(20) YES
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,0) YES
bill_factor decimal(6,0) YES
purch_factor decimal(6,0) 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,0) 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
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
sales_acct_no
TableColumn
aurora_standard.strcntrcar_sales_acct_no