Duplicate records rule for FW and PM could be extended?

b Bedeoan

on September 20, 2013

Hello,

I'm getting the following "duplicate records" message for FW when POOLID is fed and USUBJID is empty:
FWTESTCD, FWDTC, USUBJID FC, 2009-11-12T00:00:00, null SD1117 Duplicate records

The records listed as duplicates by the above rule have the same FWTESTCD and FWDTC, and USUBJID is null because POOLID is fed (and with distinct values).
Shouldn't this rule be extended somehow so that, if USUBJID is null, to check for duplicates by the values of (FWTESTCD, FWDTC, POOLID)?
...

I get a similar issue in SC:
PMEVAL, PMTESTCD, PMDTC, USUBJID null, LENGTH, 2010-04-07T17:22:23, AN008 SD1117 Duplicate records

For the same USUBJID I have multiple PM entries with the same PMTESTCD and PMDTC but on different masses - so with different PMSPID. Can't this rule be extended for PM to also consider PMSPID if not null?

Thanks!

Forums: Validation Rule Suggestions

s Sergiy

on October 3, 2013

Hi Amelia, SD1117 check was

Hi Amelia,

SD1117 check was not desined to work with POOLID. You can ignore those false-positive messages or try to modify the checks by adding POOLID variable:

<val:Unique ID="SD1117" Message="Duplicate records" Description="The structure of Findings class domains should be one records per Finding Result per subject or per pool. No Finding Result with the same Test Short Name (--TESTCD) for the same Subject (USUBJID) or Pool (POOLID) and the same Collection Date (--DTC) are expected." Category="Consistency" Type="Warning" Variable="%Domain%DTC" When="%Domain%TESTCD != ''" GroupBy="USUBJID,POOLID,%Domain%TESTCD,%Domain%CAT,%Domain%SCAT,%Domain%METHOD,%Domain%SPEC,%Domain%DRVFL,%Domain%EVAL,VISITNUM,%Domain%TPTNUM" Optional="POOLID,%Domain%DTC,%Domain%CAT,%Domain%SCAT,%Domain%METHOD,%Domain%SPEC,%Domain%DRVFL,%Domain%EVAL,VISITNUM,%Domain%TPTNUM" />

Regards,

Sergiy

s Sergiy

on October 3, 2013