<< Click to Display Table of Contents >> Navigation:  SPM > SPM > Formats > EZSPM Format

Format Name: EZSPM

File Name: EZSPM.zip

Software: EQuIS SPM

Source: SPM install (and xcopies)

Export(s): Not Applicable

 

Description: The EZSPM format is 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. Due to the simplified nature of the EZSPM format, there is not a distinct one-to-one relationship between the SPM format sections and the EZSPM format sections.

 

Installation Instructions: This format requires a licensed SPM and the SPM Schema applied to the database.

•For SPM usage, no additional steps are necessary.

 

Overview: The Analysis_Request_General, Analysis_Request_Detail, and Activity_Request_Detail sections automatically create multiple Task, Sample, and Activity rows, respectively, on EDD load. The Task, Sample, and Activity sections can then be reviewed and modified before creating and committing. The Analysis_Request_General, Analysis_Request_Detail, and Activity_Request_Detail sections do not map to any database tables—these sections just create rows in other sections of the EZSPM format.

 

The EZSPM format contains the following sections:

•Analysis_Request_General – No data table mappings, automatically populates and creates values in the Task section of the EDD. Some reference values can be added, but it is not advised to add reference values using this format. This section must be pre-populated before loading into EDP to populate the Task section.

•Analysis_Request_Detail – No data table mappings, automatically populates and creates values in the Sample section of the EDD. Some reference values can be added, but it is not advised to add reference values using this format. This section must be pre-populated before loading into EDP to populate the Sample section.

•Activity_Request_Detail – No data table mappings, automatically populates and creates values in the Activity section of the EDD. Some reference values can be added, but it is not advised to add reference values using this format. This section must be pre-populated before loading into EDP to populate the Activity section.

•Task – Parts of this section can be automatically populated by the Analysis_Request_General section. This section is for data related to sampling events that were planned or scheduled in SPM.  

•Sample – Parts of this section can be automatically populated by the Analysis_Request_Detail section. This section is used for data related to the samples involved in the associated SPM task.

•Activity – Parts of this section can be automatically populated by the Activity_Request_Detail section. This section is used for data related to specific actions being performed at specific locations during a sampling event.

•Collect_Members – EQuIS Collect users associated with the SPM plan can be defined here.

•Files – Any files that are associated with a sample delivery group can be reported here.

 

The workflow for configuring SPM plans and tasks with this format may include:

1.Open the EZSPM format in EDP.

2.Add a single row to the Analysis_Request_General section. This will correspond to one Task row. Note that each EDD can only have one Analysis_Request_General row.

3.Add one or more rows to Analysis_Request_Detail section. Each row in Analysis_Request_Detail will create one to many Sample rows.  Analysis_Request_Detail.location_group or Analysis_Request_Detail.location dictates how many Sample rows will be created. One Sample row will be created for every location within the location_group, or individual location listed.  The Sample section creates samples, results, and containers when committed. One container per SPM_CONTRACT_MAG will be created.

4.Add one or more rows to Activity_Request_Detail. Each row in Activity_Request_Detail will create one to many Activity rows.  Activity_Request_Detail.location_group or Activity_Request_Detail.location dictates how many Activity rows will be created. One Activity row will be created for every location within the location_group, or individual location listed.

5.Save the EDD.

6.Clear EDP or reopen the EZSPM format.

7.Open the EDD saved in Step 5.

8.Review the Task, Sample, and Activity rows for errors.

9.Add Collect_Members rows as desired. This section allows users to add specific user_names to existing Collect groups.

10.Create and Commit.

 

Limitations/Assumptions: The checks and mappings in any EDD format involve assumptions. The following are assumptions and limitations for the EZSPM format.

•The Samples table contains a check to ensure the records plan_code, lab_code, contract_start_date, method_analyte_group_code, and spm_contract_mag corresponds to a row in DT_SPM_CONTRACT_MAG. A "plan_code, lab_code, contract_start_date, method_analyte_group_code, and spm_contract_mag must correspond to a row in dt_spm_contract_mag" error will occur if a record does not match or fields called upon by the check are NULL in DT_SPM_CONTRACT_MAG. The fields included in this check are outlined below:

•DT_SPM_CONTRACT_MAG.SPM_CONTRACT_ID must be populated for the associated DT_SPM_CONTRACT record to provide the plan_code (DT_SPM_CONTRACT.PLAN_CODE), lab_code (DT_SPM_CONTRACT.CONTRACTOR_CODE) and contract_start_date (DT_SPM_CONTRACT.CONTRACT_START_DATE).

•DT_SPM_CONTRACT_MAG.REMARK must be populated with the spm_contract_mag_id to provide the spm_contract_mag.

•DT_SPM_CONTRACT_MAG.METHOD_ANALYTE_GROUP_CODE must be populated to provide the method_analyte_group_code.

 

•When populating the Analysis_Request_Detail and Activity_Request_Detail sections, either populate location_group or location. Do not populate both.  

 

 

The tables below provide detailed automatic population information for the Task, Sample, and Activity sections. Blank cells indicate that the field is not automatically populated.

 

 

 

 

 

 

 

EQuIS Table Mappings: