aurora_standard.chrdrugc

Field Type Null Default Key Extra Comment
fac_no varchar(3) YES
ndc_labeler decimal(5,0) YES MUL
ndc_product decimal(4,0) YES
ndc_package decimal(2,0) YES
dea_class varchar(1) YES
rx_otc_ind varchar(1) YES
prod_name varchar(30) YES
prod_form varchar(8) YES
prod_strength decimal(10,3) YES
prod_str_um varchar(8) YES
unit_cost_factor decimal(6,1) YES
size_u_m varchar(2) YES
pack_qty decimal(6,0) YES
brand_name varchar(30) YES
thera_class varchar(10) YES
unit_dose varchar(1) YES
awp_date date YES
awp_unit_price decimal(11,5) YES
dp_unit_price decimal(11,5) YES
min_reorder_pt decimal(9,0) YES
purch_amount decimal(9,0) YES
vendor varchar(6) YES
auto_dc_days decimal(3,0) YES
price_1 decimal(9,2) YES
price_2 decimal(9,2) YES
price_3 decimal(9,2) YES
form_flag varchar(1) YES
audit_use_flag varchar(1) YES
default_prn decimal(4,0) YES
abbr_code varchar(10) YES UNI
service_code varchar(10) YES
default_route varchar(10) YES
default_increment decimal(8,4) YES
default_dose varchar(10) YES
default_comm_code varchar(3) YES
pyxis_code varchar(10) YES
default_type varchar(1) YES
last_used date YES
rate_code varchar(2) YES
price_lock varchar(1) YES
on_hand decimal(12,2) YES
stock_flag varchar(1) YES
gen_doses varchar(1) YES
default_dose_str decimal(10,3) YES
default_dose_um varchar(8) YES
diluent_1 varchar(10) YES
diluent_2 varchar(10) YES
diluent_3 varchar(10) YES
diluent_4 varchar(10) YES
vend_item_cd varchar(20) YES
ndc_code varchar(13) YES
chs_rowID bigint(20) unsigned NO PRI auto_increment

References

Local Column References
ndc_code
TableColumn
_1.clients_fee_schedules_mapcfsm_ndc_code
_1.clinical_interventions_medications_mapcimm_ndc_code
_1.cptcpt_ndc_code
_1.inventoryinv_ndc_code
_1.patients_inventorypinv_ndc_code
_1.patients_responsibility_estimates_servicesprests_ndc_code
_1188.clients_fee_schedules_mapcfsm_ndc_code
_1188.clinical_interventions_medications_mapcimm_ndc_code
_1188.cptcpt_ndc_code
_1188.inventoryinv_ndc_code
_1188.patients_inventorypinv_ndc_code
_1188.patients_responsibility_estimates_servicesprests_ndc_code
_1218.clients_fee_schedules_mapcfsm_ndc_code
_1218.clinical_interventions_medications_mapcimm_ndc_code
_1218.cptcpt_ndc_code
_1218.inventoryinv_ndc_code
_1218.patients_inventorypinv_ndc_code
_1218.patients_responsibility_estimates_servicesprests_ndc_code
_1548.clients_fee_schedules_mapcfsm_ndc_code
_1548.clinical_interventions_medications_mapcimm_ndc_code
_1548.cptcpt_ndc_code
_1548.inventoryinv_ndc_code
_1548.patients_inventorypinv_ndc_code
_1548.patients_responsibility_estimates_servicesprests_ndc_code
_435.clients_fee_schedules_mapcfsm_ndc_code
_435.clinical_interventions_medications_mapcimm_ndc_code
_435.cptcpt_ndc_code
_435.inventoryinv_ndc_code
_435.patients_inventorypinv_ndc_code
_435.patients_responsibility_estimates_servicesprests_ndc_code
_436.clients_fee_schedules_mapcfsm_ndc_code
_436.clinical_interventions_medications_mapcimm_ndc_code
_436.cptcpt_ndc_code
_436.inventoryinv_ndc_code
_436.patients_inventorypinv_ndc_code
_436.patients_responsibility_estimates_servicesprests_ndc_code
_436_archive_testing.clients_fee_schedules_mapcfsm_ndc_code
_436_archive_testing.clinical_interventions_medications_mapcimm_ndc_code
_436_archive_testing.cptcpt_ndc_code
_436_archive_testing.inventoryinv_ndc_code
_436_archive_testing.patients_inventorypinv_ndc_code
_436_archive_testing.patients_responsibility_estimates_servicesprests_ndc_code
_437.clients_fee_schedules_mapcfsm_ndc_code
_437.clinical_interventions_medications_mapcimm_ndc_code
_437.cptcpt_ndc_code
_437.inventoryinv_ndc_code
_437.patients_inventorypinv_ndc_code
_437.patients_responsibility_estimates_servicesprests_ndc_code
_8.clients_fee_schedules_mapcfsm_ndc_code
_8.clinical_interventions_medications_mapcimm_ndc_code
_8.cptcpt_ndc_code
_8.inventoryinv_ndc_code
_8.patients_inventorypinv_ndc_code
_8.patients_responsibility_estimates_servicesprests_ndc_code
_81.clients_fee_schedules_mapcfsm_ndc_code
_81.clinical_interventions_medications_mapcimm_ndc_code
_81.cptcpt_ndc_code
_81.inventoryinv_ndc_code
_81.patients_inventorypinv_ndc_code
_81.patients_responsibility_estimates_servicesprests_ndc_code
_999.clients_fee_schedules_mapcfsm_ndc_code
_999.clinical_interventions_medications_mapcimm_ndc_code
_999.cptcpt_ndc_code
_999.inventoryinv_ndc_code
_999.patients_inventorypinv_ndc_code
_999.patients_responsibility_estimates_servicesprests_ndc_code
aurora_standard.lngdrgprev_ndc_code
template_library.cptcpt_ndc_code
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
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
on_hand
TableColumn
aurora_standard.sthcadjdqty_on_hand
aurora_standard.sticadjdqty_on_hand
aurora_standard.stilocarqty_on_hand
aurora_standard.tmplocarqty_on_hand
rate_code
TableColumn
aurora_standard.sticlsscstk_rate_code
aurora_standard.sticlsscsup_rate_code
aurora_standard.sticlsscnon_rate_code
vendor
TableColumn
aurora_standard.stmmastrpurch_vendor
aurora_standard.stmmastrmaint_vendor
aurora_standard.stuctlgdprimary_vendor
aurora_standard.tmpctlgdprimary_vendor