Formats

Seven formats are provided with SPM and are available in the following sub-folders of the installed \Program Files\EarthSoft\SPM\Format folder:

•EZSPM Format – A simplified version of the SPM format. The EZSPM format allows users to easily create multiple planned and scheduled tasks, samples, results, containers, and activities with limited manual data entry. This format assumes the plan already exists in SPM and the SPM_CONTRACT_MAG information is already setup. Files can be added via this format and linked by Task_Code.

•EZSRN Format – A simplified Sample Receipt Notifications (SRN) format that is designed to streamline the essential information needed by labs. The format has four sections: SDG_Samples, Sample_Issues, SRN_Invoices, and Files.

•SPM Format – The SPM Format runs in EDP to export SPM plans from a facility. The saved exported file is then imported (copied) to another facility. The file includes plan and shared contracts as well as the planned and scheduled tasks and samples. The format has the contract start date as an additional primary key (used to check for duplicates) together with the plan code and lab code. The EDD file can be edited to select records for import.

•SPM_CONTRACT Format – The SPM_CONTRACT Format will export contracts from a selected plan code, contractor code, and (optional) Method Analyte Group to a different plan code and/or a different contractor code. The format has the contract start date as an additional primary key (used to check for duplicates) together with the plan code and lab code. The saved EDD file can then be imported into the same or another facility.

•SPM_eQuote Format – The SPM_eQuote format is intended to create SPM contracts, and includes all necessary fields required for the creation of an SPM contract. Laboratories may create and submit an eQuote (as an .XML or .XLSX file) with the data needed for the SPM analytical contract, which provides a more automated workflow and minimizes errors.

•SPM_REF Format – The SPM_REF format contains the reference values relative to SPM data—specifically cost calculations and containers. The SPM_REF Format can be used to conveniently upload SPM-related reference values via EDP.

•SRN Format – Used to submit information pertaining to Sample Receipt Notifications (SRNs). The SRN typically includes information such as the number of samples received, the overall state of the samples received, details of any issues apparent in the samples received, and SRN amendments sent back to the laboratory. The SRN Format has separate sections for issues associated with bottles, samples, and tests in addition to general issues. The format also supports creating COCs from the coc_lab section.