Removing MedDRA Non-Current Terms

[Greg Wagner]

Removing MedDRA Non-Current Terms

Currently, the MedDRA non-current terms are not being filtered out of the dictionary even though the flag column can be specified within the dictionary setup. This will be addressed in an upcoming release, but for now, the non-current terms must be removed when building the MedDRA dictionary.

To do this, the following code snippets can be added to the end of the dictionary scripts:

MedDRA.sql (SQL Server script)

/***  Remove non-current terms from low_level_term table *****/  
GO  
delete from low_level_term where llt_currency='N'  
GO

MedDRA.sas (SAS System Script)

/** Delete non-current terms from low_level_terms table ***/
proc sql;
delete from pdict.low_level_term&pwstring where llt_currency='N';
quit;

[Greg Wagner]

Non-Current Terms removed in 3.1

In version 3.1 the system will now filter the Non-current terms.