Announcement

Collapse
No announcement yet.

Removing MedDRA Non-Current Terms

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Removing MedDRA Non-Current Terms

    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)
    Code:
    /***  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)
    Code:
    /** Delete non-current terms from low_level_terms table ***/
    proc sql;
    delete from pdict.low_level_term&pwstring where llt_currency='N';
    quit;
    Last edited by Ronni Rubenstein; 04-03-2008, 12:21 PM.

  • #2
    Non-Current Terms removed in 3.1

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

    Comment

    Working...
    X