My Oracle Support Banner

Can AERS Batch Reclassify Be Run For Specific Dictionaries or Version Only? (Doc ID 757145.1)

Last updated on MAY 28, 2009

Applies to:

Adverse Event Reporting System - Version: 4.5.1 to 4.6.1
Information in this document applies to any platform.


We regularly load updates of the MedDRA and WHO-Drug dictionaries, and specify virtual
dictionaries to identify previous versions used.

While it makes sense to force the reclassify of verbatims coded vs. MedDRA each time a new version
is loaded, we would like not to force the update vs. the WHO Drug dictionary.

The reason for this is that the WHO-Drug dictionary in the B2 format

(the format currently supported by AERS) includes in each update changes in naming of drugs (e.g. from "LASIX" to "LASIX /00032602/") that are only aimed at keeping the drug name unique in the drug market that the dictionary update reflects but do not correctly fit to the drug market at the time the information in the AERS case refers to.

The batch reclassify of drug names vs. a new version of WHO-Drug dictionary always causes an
undesired workload to manually classify a number of drug names that because of those changes of
namings in the dictionary (e.g. from "LASIX" to "LASIX /00032602/") transform drug names that
match a dictionary term to "Unmapped" drug names.

To avoid this undesired activities to maintain coding of drug names:
Can AERS Batch Reclassify be run for specific Dictionaries only? (e.g. MedDRA, and not WHO-Drug)


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.