FDAC213-Duplicate records in CE domain

April 11, 2019

Hi,

We have a CRF which captures information if Vomitting or DIARRHOEA has occurred since last visit . This question is asked at every visit (Visit 2-Visit 6).

Pre-specified term has been mapped to CETERM and CEOCCUR as Y or N (based on response) and CESTTPT (date of the previous Visit) and CEENTPT(Date of current Visit as which the question is asked) since the questionnare is related to the events occuring since the last Visit. However for the records where CEOCCUR is N , CESTDTC is null ; Pinnacle is throwing errors for Duplicate Records even though CESTTPT and CEENTPT are different . Can you please confirm if the mapping looks correct and this error can be ignored?

 

Thanks,

Priyanka

Forums

If you have prespecified terms, and one of them is selected, you should also set CEPRESP to "Y". See assumption 2 of the SDTMIG v.3.2.
Regarding record uniqueness, it is YOU who define what the keys for unique records are in the define.xml. Did you do that? The variables that form the unique key have to be marked by a "KeySequence" attribute on the "ItemRef". Validation software should pick that up to find out whether there are duplicate records.

--STTPT is of course a typical key for checking for duplicate records. As already stated, it should be picked up from the define.xml where it is marked as such using the KeySequence attribute. It is the user who decides what the keys for record uniqueness are.

Hi Priyanka, 

No, a new algorithm for SD1201 rule will not be available in the next release of Community until its patch update (~ 1 extra month).

Kind Regards, 

Sergiy

I looked into the matter in deep detail again.
The FDAC213 rule states: "The structure of Events class domains should be one records per Event per subject. No Events with the same Collected Term (--TERM), Decoded Term (--DECOD), Category (--CAT), Subcategory (--SCAT), Severity (--SEV), and Toxicity Grade (--TOXGR) values for the same Subject (USUBJID) and the same Start Date (--STDTC) are expected".  

So it might be that the software is not to blame for this warning, as essentially, the rule is just damned wrong. It ignores that the granularity of the uniqueness may be higher and complexer, as happened in this case, and it ignores that the sponsor is responsible for assigning the uniqueness keys, and not the FDA (or whoever developed the rule). The better way to express this is the CDISC rule CG013: "Each record is unique per sponsor defined key variables as documented in the define.xml".

Hi,

Yes, the problem is with the situation where CETERM is same (since it is pre-specified) and the CESTDTC is null for multiple records for a subject as these records have CEOCCUR as "N" collected at different time points. 

 

The below rule is applicable when the CEOCCUR is Y , since we will not expect the same start date for same CETERM  collected at different time points.

 

The structure of Events class domains should be one records per Event per subject. No Events with the same Collected Term (--TERM), Decoded Term (--DECOD), Category (--CAT), Subcategory (--SCAT), Severity (--SEV), and Toxicity Grade (--TOXGR) values for the same Subject (USUBJID) and the same Start Date (--STDTC) are expected