aurora_standard.chrrated

Field Type Null Default Key Extra Comment
rate_code varchar(2) YES
cost decimal(10,2) YES
multiplier decimal(5,4) YES
fee decimal(10,2) YES
chs_rowID bigint(20) unsigned NO PRI auto_increment

References

Local Column References
cost
TableColumn
HSPI_Bastrop.examplesexample_cost
HSPI_CURES2015_B1.examplesexample_cost
HSPI_Central_Hospital.examplesexample_cost
HSPI_Dewitt.examplesexample_cost
HSPI_Fulton.examplesexample_cost
HSPI_Inferno.examplesexample_cost
HSPI_MU2015_E1.examplesexample_cost
HSPI_MU2015_G2.examplesexample_cost
HSPI_MU2015_G9.examplesexample_cost
HSPI_Sandbox.examplesexample_cost
HSPI_Summit_General.examplesexample_cost
HSPI_United_Physicians.examplesexample_cost
MPI.examplesexample_cost
_1.inventoryinv_cost
_1188.inventoryinv_cost
_1218.inventoryinv_cost
_1548.inventoryinv_cost
_435.inventoryinv_cost
_436.inventoryinv_cost
_436_archive_testing.inventoryinv_cost
_437.inventoryinv_cost
_8.inventoryinv_cost
_81.inventoryinv_cost
_999.inventoryinv_cost
aurora_standard.audpchgddirect_cost
aurora_standard.audpchgdindirect_cost
aurora_standard.audroomddirect_cost
aurora_standard.audroomdindirect_cost
aurora_standard.axlscdmunit_cost
aurora_standard.axlscdmother_cost
aurora_standard.c7cdmunit_cost
aurora_standard.c8cdmunit_cost
aurora_standard.c8cdmother_cost
aurora_standard.chmadmtrtot_cost
aurora_standard.chmmbc41oth_carrier_cost
aurora_standard.chmmhbcdoth_cost
aurora_standard.chmnetwdimplants_cost
aurora_standard.chmpchgddirect_cost
aurora_standard.chmpchgdindirect_cost
aurora_standard.chmprchdlast_cost
aurora_standard.chmpriccunit_cost
aurora_standard.chmpriccother_cost
aurora_standard.chmroomddirect_cost
aurora_standard.chmroomdindirect_cost
aurora_standard.chpinsrcinsrv_cost
aurora_standard.chpvacidvac_phy_cost
aurora_standard.chsfaconasset_cost
aurora_standard.gary13calc_avg_unit_cost
aurora_standard.gary14calc_avg_unit_cost
aurora_standard.gary2avg_unit_cost
aurora_standard.glspriceunit_cost
aurora_standard.glspriceother_cost
aurora_standard.hl7dg1outlier_cost
aurora_standard.hl7ft1unit_cost
aurora_standard.item1unit_cost
aurora_standard.ohonetasst_cost
aurora_standard.pharm1pricc_unit_cost
aurora_standard.stfasstrasset_cost
aurora_standard.stfmtncdactual_cost
aurora_standard.stiadjmdadj_cost
aurora_standard.stiinvtrcontract_cost
aurora_standard.stilocaravg_unit_cost
aurora_standard.stilocarpurch_unit_cost
aurora_standard.stilocarlast_cost
aurora_standard.stipurcdpurch_unit_cost
aurora_standard.stmaintdmaint_est_cost
aurora_standard.stmaintdmaint_actual_cost
aurora_standard.stmmastrpurch_cost
aurora_standard.stoshipditem_cost
aurora_standard.sturatedfrom_cost
aurora_standard.sturatedto_cost
aurora_standard.sturtrndreturn_cost
aurora_standard.tmplocaravg_unit_cost
aurora_standard.tmplocarpurch_unit_cost
aurora_standard.tmplocarlast_cost
aurora_standard.ttiinvtrcontract_cost
multiplier
TableColumn
_1.patients_inventorypinv_administered_multiplier
_1188.patients_inventorypinv_administered_multiplier
_1218.patients_inventorypinv_administered_multiplier
_1548.patients_inventorypinv_administered_multiplier
_435.patients_inventorypinv_administered_multiplier
_436.patients_inventorypinv_administered_multiplier
_436_archive_testing.patients_inventorypinv_administered_multiplier
_437.patients_inventorypinv_administered_multiplier
_8.patients_inventorypinv_administered_multiplier
_81.patients_inventorypinv_administered_multiplier
_999.patients_inventorypinv_administered_multiplier
aurora_standard.stxautorauto_multiplier
common.clientscli_payer_multiplier
fee
TableColumn
_1.sliding_fee_scale_breakpoint_valuessfsbv_discount_flat_fee
_1188.sliding_fee_scale_breakpoint_valuessfsbv_discount_flat_fee
_1218.sliding_fee_scale_breakpoint_valuessfsbv_discount_flat_fee
_1548.sliding_fee_scale_breakpoint_valuessfsbv_discount_flat_fee
_435.sliding_fee_scale_breakpoint_valuessfsbv_discount_flat_fee
_436.sliding_fee_scale_breakpoint_valuessfsbv_discount_flat_fee
_436_archive_testing.sliding_fee_scale_breakpoint_valuessfsbv_discount_flat_fee
_437.sliding_fee_scale_breakpoint_valuessfsbv_discount_flat_fee
_8.sliding_fee_scale_breakpoint_valuessfsbv_discount_flat_fee
_81.sliding_fee_scale_breakpoint_valuessfsbv_discount_flat_fee
_999.sliding_fee_scale_breakpoint_valuessfsbv_discount_flat_fee
aurora_standard.apscdmpro_fee
aurora_standard.sturtrnereturn_fee
common.clients_contract_dataccd_setup_fee
rate_code
TableColumn
aurora_standard.sticlsscstk_rate_code
aurora_standard.sticlsscsup_rate_code
aurora_standard.sticlsscnon_rate_code