Upload Reference Values with SPM_REF EDD Format
Copyright © 2018 EarthSoft, Inc • Modified: 12 Dec 2018
The SPM_REF EDD format, supplied in the SPM installation directory in .\Program Files\EarthSoft\SPM\Format\SPM\, can be used to conveniently upload SPM-related reference values via EQuIS Data Processor (EDP). The format accounts for several types of reference values:
An example EDD named "SPM_Example_EDD.xlsx" is also supplied in the same folder, which houses some example container and cost calculation data.
Containers are created in Professional in RT_SPM_CONTAINER, and are named within that process.
SPM imports existing containers from RT_SPM_CONTAINER, and a NEW record is created in DT_SPM_CONTRACT_CONTAINER. Container names in SPM can be edited, and those changes will be reflected in the DT_SPM_CONTRACT_CONTAINER.
Cost calculations are stored in RT_SPM_COST_CALC and RT_SPM_COST_CALC_MAG. See the article Use Advanced Cost in Laboratory Contracts for more details on how to use cost calculations.