SPM (7.0.0.18212)

SPM.xse Format - Export and Import [m111404]

The initial version of the SPM format has been rewritten for efficiency and accuracy. This SPM format runs in EDP to export plans from a facility. The saved exported file is then imported (copied) to another facility. The file includes plan and shared contracts and plans' planned tasks and samples. The EDD file can be edited to select records for import.

Use Avery Word Templates to Print Labels [m111500]

The current SPM Label apps were enhanced with an option to use a client-designed Word template. Since the output is a Word document, it can be edited prior to printing. In addition, this option has the capability to print bar codes.

SPM - RT_SPM_CONTAINER - Please Add STATUS_FLAG [m113612]

STATUS_FLAG added to table RT_SPM_CONTAINER; affects both SPM and EDGE Schemas.

SPM - Completeness Summary Shows "N" if any NST Samples Exist in Task [m114722]

The "N: Sample(s) not taken" is added to the list of "* Status" explanations of the results of the "SPM - Completeness Report - Summary" Report.

COC WorkFlow Redesigned for SPM 7 [m141942]

The SPM COC workflow has been redesigned for efficiency, specifically for large databases. The original one-screen workflow is now a three-screen workflow which includes the COC Manager, the COC Edit and the List of Unassigned Samples for selection.

Propagate Planned Task Updates to Scheduled Tasks [m142409]

This new feature for SPM 7 eliminates the need to reschedule a scheduled task when a change is made to the planned task. Propagation can be applied to all, selected, or none of the scheduled tasks.

Propagate Contract Changes Planned and Scheduled Tasks [m142411]

This new feature for SPM 7 propagates contract changes to affected planned and scheduled tasks. Due to the existence of shared contracts, propagation will also apply to tasks from other plans and other facilities. Propagation can be applied to all, selected, or none of the planned and scheduled tasks.

Completeness Report Summary - Include Manually Marked Completed Tasks [m145980]

The Completeness Report Summary was modified to include tasks manually marked as completed which were previously excluded from the summary/list.

New EDD Format to Copy Contracts [m146671]

This new EDD Format for SPM Contract 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 saved EDD file can then be imported into the same or another facility.

Task Details Bar Codes in Work Request Summary Report [m147682]

The SPM Work Request Summary Report using an Excel template has been enhanced with an option to print bar codes using a Word template. Currently, the scheduled task code, the location code and the sample code can be printed as bar codes.

EDGE Field EDD Report - Add Historical Flow Depth [m148829]

The historical flow depth data, if available, will now be included in the EDGE Field EDD Report EDGE_Historical tab and marked as "Flow" in the value group column.

Add date fields to COC Summary Report [m151684]

Four date fields/columns have been added to the EDGE COC Summary Report:
1) SAMPLE_date
2) SENT_TO_LAB_DATE
3) SAMPLE_RECEIPT_DATE
4) ANALYSIS_DATE

EDGE Field EDD Lake Level and Elevation [m151889]

The Lake_Ref_Elev data, if available, will be included in the EDGE Field EDD Report facility_readonly tab. The latest facility reference elevation value will be listed under the LAKE_REF_ELEV column.

SPM: Enterprise filter upgrades for scheduler [m153977]

NO RELEASE NOTE

EDGE_SPM Format Remove Required for CAS_RN, ANALYTIC_METHOD and TOTAL_DISSOLVED from COC_ANALYSIS [m154026]

For the COC_ANALYSIS row, making CAS_RN, ANALYTIC_METHOD and total_dissolved columns not required, allows the DT_CHAIN_OF_CUSTODY_MAG table to be updated without updating the DT_CHAIN_OF_CUSTODY_MAG_MEMBER table. This table is updated only when all three fields above are present.