EZSPM Format – Relevant RT_COMPANY_TYPE Assigned When Creating New RT_COMPANY Record [d44105]
When creating a new record in the RT_COMPANY table, COMPANY_TYPE will automatically be assigned a valid variation of "Lab" from the RT_COMPANY_TYPE table.
EZSPM Format – REQUEST_ANALYSIS_DETAIL No Longer Flags Field Duplicates as Duplicate Rows [d43097]
The REQUEST_ANALYSIS_DETAIL table no longer flags field duplicates as duplicate rows when there are differences in SAMPLE_TYPE_CODE.
EZSRN Format – Added po_number to SDG_Samples Section [d44221]
Added DT_CHAIN_OF_CUSTODY.PO_NUMBER
mapping to the SDG_Samples section to allow the creation and population of new COC records.
EZSRN Format – Added Warning when Creating New COC in SDG_SAMPLE Section [d44627]
Added a warning to the SDG_SAMPLE section when the CHAIN_OF_CUSTODFY field is populated to notify the user if the value does not yet exist.
EZSRN Format – Error Added for Invalid Chain of Custody ID [d44466]
Updated SRN_Issues.chain_of_custody in the EZSRN Format to display an error if the COC ID used does not exist in the DT_CHAIN_OF_CUSTODY table.
Schema – SPM – Incorrect EUID Column Definitions in EUID-Based _ID Tables Causing Mismatches [d47666]
Adjusted the following tables to have a EUID column ID:
- DT_SPM_PLANNED_SAMPLE
- DT_SPM_SCHEDULED_SAMPLE
- RT_SPM_CONTAINER
SPM – "Other" Activity for Equipment Needs the Equipment to be Location-specific [d42826]
Updated the error message to be more specific when adding "Other" activities to a planned SPM task from the Equipment tab when DT_EQUIPMENT.SYS_LOC_CODE is blank.
SPM – Blank Screen After Using Batch Scheduler [d43016]
Fixed a bug in SPM where the SPM plan closes after a user schedules tasks via the Batch Scheduler and the SPM blank screen is then blank.
SPM – 'Day Offset' Setting No Longer Moves Sample to Previous Month [d44054]
Resolved bug which caused multiple samples to be allocated to a single month when creating a Planned Task with a configured "Day Offset".
SPM – Delete and Remove Behave the Same Way for Planned Task Samples [d44076]
Fixed an issue that caused an error when using the Delete key to remove a sample. The Delete key now behaves the same way as the Remove button.
SPM – Editing a COC – Filtering Added to List of Unassigned Samples [d44735]
Updated Samples in SPM with filtering for easier selection when assigning samples to a Chain of Custody (COC).
SPM – Error Received When Selecting "Open Report" in Reports Tab [d44033]
Fixed a bug where an error appeared when selecting "Open Report" in the Reports tab of SPM.
SPM – Fixed Error Occurring After Running Grid Report [d44036]
Fixed a bug where an error appears after running a grid report (e.g., ARII, SPM – Analytical Results or SPM Completeness Table) and navigating back to parameters.
SPM - Planned Task Details Report – Bottles Sheet Output Matches Data in SPM - Task Details Report [d44884]
Updated the Bottle Sheet tab in the SPM - Planned Task Details report to display all records making use of a shared container instead of showing only one record per shared container.
SPM COC Report – Filtered Status Correctly Displays [d44438]
Fixed an issue when filtering the SPM - COC Report. This report now correctly displays the filtered status of Analytic Methods using non-shared containers with the same container description.
SPM COC Report – Limit Data Output to Lab Assigned to Sample [d42695]
Updated the ContractMagSPM_Bottles tab in the SPM COC Report to have only data output for the Lab assigned to sample.
SPM Completeness Report – Unplanned Purge Data Included When 'Include Unplanned Data' is Set to True [d43561]
Updated the SPM Completeness Report - Detailed report so that unplanned purge data will only be present in the report output when the 'Include Unplanned Data' parameter is set to True.
SPM Completeness Table - Activities Report – Displays Purge Activities [d44316]
Updated the SPM - Completeness Table - Activities Report to display purge activities.
SPM Enterprise – Resource Groups Page – Display Associated Equipment When Session Facility is Set to Facility Group [d43451]
Updated the SPM Enterprise Resource Groups tab so that when a Session Facility Group is selected, the page will display associated equipment for any facility within the selected Session Facility Group.
SPM Enterprise – Scheduler Page – Task Status Grid Update [d44041]
Updated the Task Status grid on the SPM Enterprise Scheduler page to be easier to read and interpret task scheduling information.
SPM Format – Planned Task Errors Flagged Prior to Create/Commit [d44235]
Format-specific errors will now be displayed. Invalid values for planned_task_code in the SPM Plan Task and Samples section are flagged with an error and warnings are displayed for contract_start_date and plan_code in the SPM Contract section.
SPM Format – Planned_Sample_Result Does Not Support Field Duplicates [d45357]
Fixed a bug in the SPM format that flagged samples with different sample_type_codes as duplicate records.
SPM Labels (Custom2) Report – Missing MAG When Analytic_Method Column Not Populated for Shared Containers [d42715]
Fixed an issue that prevented the SPM - Labels (custom2) report from showing all MAGs for shared containers when an analytic method was not populated in the contract analytic method.
SPM Laboratory Invoice Report – Added Lab Code(s) Parameter [d44801]
Added a Lab Code(s) parameter to the SPM - Laboratory Invoice Report for filtering of invoices by lab when the report is generated.
SPM Task Details and SPM Planned Task Details Reports – Include Remark [d42945]
Updated the SPM - Planned Task Details report to include DT_SPM_PLANNED_SAMPLE.REMARK on the Bottle Sheet tab in the report output.
Updated the SPM - Task Details report to include DT_SPM_SCHEDULED_SAMPLE.REMARK on the Bottle Sheet tab in the report output.
SPM_CONTRACT Format – Creating Package in EDP Successful when Copying Contract MAGs or Containers [d44043]
Fixed an issue where exporting contracts in the SPM_CONTRACT format to a different plan code and/or a different contractor code were not populating. These contracts should now populate correctly during the Create step in EDP:
- Contractor Code
- Plan Code
- Method Analyte Group (optional)
SPM_eQuote Format – Added Lookup to PREP_METHOD [d42563]
Added lookup to Lab_eQuote PREP_METHOD, allowing users to populate the PREP_METHOD field. Users can create new PREP_METHODs in the RT_PREP_METHOD table using the Add By Value option.
SPM_eQuote Format – Added Lookup to Preservative [d44558]
Updated the preservative field in the Lab_eQuote section to be a lookup column referencing RT_PRESERVATIVE.PRESERVATIVE.
SPM_eQuote Format – Added shared_container_YN field [d44202]
Added at_spm_contract_mth_container.shared_container_yn field to the Lab_eQuote section so that the correct fields are populated when the Collect – Field EDD Report is run.
SPM_eQuote Format – Added Warnings for New Reference Values [d43041]
Updated the SPM_eQuote format to flag the method_analyte_group_code, analytic_method, cas_rn, reporting_unit, container_size_unit, holding_time_unit, and container_code fields in the Lab_eQuote section with a warning when a corresponding row in the database does not exist.