Skip Navigation Bar

Unified Medical Language System® (UMLS®)

UMLS Quick Start Guide | FAQs | Customer Support | UMLS Site Map

2012AB MedDRA Source Information




Skip to: Notes, Summary of Changes, Summary of Source-Provided Files Source-Provided File Details

Notes

The files found in the MedAscii directory of the MedDRA release contain the complete current MedDRA data set. Metathesaurus source processing requires only these files. The consecutive files, found in the SeqAscii directory, define what changes have been made in the MedDRA ASCII files since the last release. These files are not directly used for Metathesaurus source processing, except in limited cases to informally review updates or to confirm file integrity (e.g., as an exercise to verify that by applying current .seq changes to previous .asc data, the current .asc files can be recreated).

The information provided here applies explicitly to the English version of MedDRA, however the majority of it is also relevant to most MedDRA translations (Czech, Dutch, French, German, Hungarian, Italian, Portuguese and Spanish). The Japanese translation of MedDRA has significant differences. For additional information about the translations, see the representation pages for each specific source.

Summary of Changes:

  (return to top)

The following atom and attribute names (ATNs) have been deprecated from this version of MDR because the source did not provide any data values for the ICD9CM, CST95, and WHOART fields.

  • TTY = XM
  • ATN = MAPSETTYPE
  • ATN = MXR
  • ATN = XMAP
  • ATN = XMAPFROM
  • ATN = XMAPTO

Source-Provided Files: Summary

  (return to top)

The complete English language MedDRA distribution includes the following:

Documentation and Reference

File Name Description
ASCII_seq_datafiles_15_0_English.pdf ASCII and Consecutive Files Documentation. This is the primary documentation for the data files.
SMQ_intguide_15_0_English.pdf SMQ Introductory Guide
SMQ_Spreadsheet_15_0_English.xlsx SMQ Spreadsheet (English download only)
detail_report_15_0_English.pdf Detail Report (English download only)
intguide_15_0_English.pdf Introductory Guide (PDF)
readme_15_0_English.txt README listing files in the MedDRA distribution
version_report_15_0_English.xlsx Version Report (English download only)
whatsnew_15_0_English.pdf What's New in this version

Ascii data files

File Name Description
MedAscii/llt.asc Lower Level Terms
MedAscii/pt.asc Preferred Terms
MedAscii/hlt.asc High Level Terms
MedAscii/hlgt.asc High Level Group Terms
MedAscii/soc.asc System Organ Classes
MedAscii/soc_hlgt.asc Relationships between SOC and HLGT codes
MedAscii/hlgt_hlt.asc Relationships between HLGT and HLT codes
MedAscii/hlt_pt.asc Relationships between HLT and PT codes
MedAscii/intl_ord.asc International SOC sort order data
MedAscii/smq_list.asc Standardised MedDRA Query (SMQ) Listing
MedAscii/smq_content.asc Standardised MedDRA Query (SMQ) Listing
MedAscii/mdhier.asc Hierarchy data: data in this file is redundant to data in soc_hlgt.asc, hlgt_hlt.asc and hlt_pt.asc
MedAscii/meddra_history.asc History information
MedAscii/meddra_release.asc
 Release metadata

All information from the MedAscii files is included in the UMLS representation. Certain fields and files may not be directly processed because they contain redundant data.


Consecutive data files

File Name Description
SeqAscii/hlgt.seq High Level Group Terms
SeqAscii/hlgt_hlt.seq Relationships between HLGT and HLT codes
SeqAscii/hlt.seq High Level Terms
SeqAscii/hlt_pt.seq Relationships between HLT and PT codes
SeqAscii/intl_ord.seq International SOC sort order data
SeqAscii/llt.seq Lower Level Terms
SeqAscii/mdhier.seq Hierarchy data: data in this file is redundant to data in soc_hlgt.asc, hlgt_hlt.asc and hlt_pt.asc
SeqAscii/pt.seq Preferred Terms
SeqAscii/soc.seq System Organ Classes
SeqAscii/soc_hlgt.seq Relationships between SOC and HLGT codes

Source-Provided Files: Details

(return to top)

Details on format of input files and representation of source data. Consult the MedDRA documentation for additional details.

file:llt.asc

  return to Ascii data files

Lower Level Terms, represented with TTY="LT" or "OL" (for non-current LLTs). Every PT has one identical LT for data entry purposes. In addition, LTs may be synonyms, lexical variants, quasi-synonyms, or sub-elements of their PT.Therefore, the pt_code is represented in MRCONSO as a Source-asserted Descriptor Identifier (SDUI), indicating that the LT and PT are closely related but not necessarily synonymous.

# Field Name Description Representation
1
 llt_code 8-digit code to identify Lowest Level Term MRCONSO.CODE (TTY="LT", "OL")
2
 llt_name Full name of Lowest Level Term MRCONSO.STR
3
 pt_code 8-digit code to identify Preferred Term for this LLT MRCONSO.SDUI
4
 llt_whoart_code Code allocated by the WHO-ART terminology MRSAT: ATN="MXR"; ATV = "WHOART: <value>"
5
 llt_harts_code Code allocated by the HARTS terminology MRSAT: ATN="MXR"; ATV = "HARTS: <value>"
6
 llt_costart_sym Symbol allocated by the COSTART terminology MRSAT: ATN="MXR"; ATV = "COSTART: <value>" Also represented in MRMAP, MRSMAP
7
 llt_icd9_code Code allocated by the 9th Revision of the International Classification of Diseases, ICD-9 MRSAT: ATN="MXR"; ATV = "ICD9: <value>"
8
 llt_icd9cm_code Code allocated by the 9th Revision of the International Classification of Diseases, Clinical Modification ICD-9-CM MRSAT: ATN="MXR"; ATV = "COSTART: <value>" Also represented in MRMAP, MRSMAP
9
 llt_icd10_code Code allocated by the 10th revision of the International Classification of Diseases, ICD-10 NOTE: ALWAYS NULL
10
 llt_currency Indicates whether the Lowest Level Term is current or non-current Used to assign the termtype: If value = "Y", termtype = "LT"; if value = "N", termtype = "OL", SUPPRESS = "Y"
11
 llt_jart_code Code allocated by the J-ART terminology MRSAT: ATN = "MXR"; ATV = "J-ART": <value>"

file:pt.asc

  return to Ascii data files

Preferred Terms

# Field Name Description Representation
1
 pt_code 8-digit code to identify Preferred Term MRCONSO.CODE (TTY = "PT"); MRCONSO.SDUI
2
 pt_name Full name of Preferred Term MRCONSO.STR
3
 null_field This field is null  
4
 pt_soc_code Primary System Organ Class to which the Preferred Term is linked MRSAT: ATN = "MPS"
5
 pt_whoart_code Code allocated by the WHO-ART terminology MRSAT: ATN = "MXR"; ATV = "WHOART: <value>"
6
 pt_harts_code Code allocated by the HARTS terminology MRSAT: ATN = "MXR"; ATV = "HARTS: <value>"
7
 pt_costart_sym Symbol allocated by the COSTART terminology MRSAT: ATN = "MXR"; ATV = "COSTART: <value>" Also represented in MRMAP, MRSMAP
8
 pt_icd9_code Code allocated by the 9th Revision of the International Classification of Diseases, ICD-9 MRSAT: ATN = "MXR"; ATV = "ICD9: <value>"
9
 pt_icd9cm_code Code allocated by the 9th Revision of the International Classification of Diseases, Clinical Modification, ICD-9-CM MRSAT: ATN = "MXR"; ATV = "ICD9CM: <value>"Also represented in MRMAP, MRSMAP
10
 pt_icd10_code Code allocated by the 10th revision of the International Classification of Diseases, ICD-10 Note: ALWAYS NULL
11
 pt_jart_code Code allocated by the J-ART terminology MRSAT: ATN = "MXR"; ATV = "J-ART: <value>"

file:hlt.asc

  return to Ascii data files

High Level Terms

# Field Name Description Representation
1
 hlt_code 8-digit code to identify High Level Term MRCONSO.CODE (TTY = "HT")
2
 hlt_name Full name of High Level Term MRCONSO.STR
3
 hlt_whoart_code Code allocated by the WHO-ART terminology MRSAT: ATN = "MXR"; ATV = "WHOART: <value>"NOTE:" All null except one case
4
 hlt_harts_code Code allocated by the HARTS terminology NOTE: ALWAYS NULL
5
 hlt_costart_sym Symbol allocated by the COSTART terminology MRSAT: ATN = "MXR"; ATV = "COSTART: <value>"NOTE:" All null except one case; also represented in MRMAP, MRSMAP
6
 hlt_icd9_code Code allocated by the 9th Revision of the International Classification of Diseases, ICD-9 NOTE: ALWAYS NULL
7
 hlt_icd9cm_code Code allocated by the 9th Revision of the International Classification of Diseases, Clinical Modification ICD-9-CM NOTE: ALWAYS NULL
8
 hlt_icd10_code Code allocated by the 10th revision of the International Classification of Diseases, ICD-10 NOTE: ALWAYS NULL
9
 hlt_jart_code Code allocated by the J-ART terminology NOTE: ALWAYS NULL

file:hlgt.asc

  return to Ascii data files

High Level Group Terms

# Field Name Description Representation
1
 hlgt_code 8-digit code to identify High Level Group Term MRCONSO.CODE (TTY = "HG")
2
 hlgt_name Full name of High Level Group Term MRCONSO.STR
3
 hlgt_whoart_code Code allocated by the WHO-ART terminology NOTE: ALWAYS NULL
4
 hlgt_harts_code Code allocated by the HARTS terminology NOTE: ALWAYS NULL
5
 hlgt_costart_sym Symbol allocated by the COSTART terminology NOTE: ALWAYS NULL
6
 hlgt_icd9_code Code allocated by the 9th Revision of the International Classification of Diseases, ICD-9 NOTE: ALWAYS NULL
7
 hlgt_icd9cm_code Code allocated by the 9th Revision of the International Classification of Diseases, Clinical Modification ICD-9-CM NOTE: ALWAYS NULL
8
 hlgt_icd10_code Code allocated by the 10th revision of the International Classification of Diseases, ICD-10 NOTE: ALWAYS NULL
9
 hlgt_jart_code Code allocated by the J-ART terminology NOTE: ALWAYS NULL

file:soc.asc

  return to Ascii data files

System Organ Classes

# Field Name Description Representation
1
 soc_code 8-digit code to identify System Organ Class MRCONSO.CODE (TTY = "OS")
2
 soc_name Full name of System Organ Class MRCONSO.STR
3
 soc_abbrev System Organ Class Abbreviation MRCONSO.CODE (TTY = "AB")
4
 soc_whoart_code Code allocated by the WHO-ART terminology NOTE: ALWAYS NULL
5
 soc_harts_code Code allocated by the HARTS terminology NOTE: ALWAYS NULL
6
 soc_costart_sym Symbol allocated by the COSTART terminology NOTE: ALWAYS NULL
7
 soc_icd9_code Code allocated by the 9th Revision of the International Classification of Diseases, ICD-9 NOTE: ALWAYS NULL
8
 soc_icd9cm_code Code allocated by the 9th Revision of the International Classification of Diseases, Clinical Modification ICD-9-CM NOTE: ALWAYS NULL
9
 soc_icd10_code Code allocated by the 10th revision of the International Classification of Diseases, ICD-10 NOTE: ALWAYS NULL
10
 soc_jart_code Code allocated by the J-ART terminology NOTE: ALWAYS NULL

file:soc_hlgt.asc

  return to Ascii data files
# Field Name Description Representation
1
 soc_code 8-digit code to identify System Organ Class Used to create hierarchy
2
 hlgt_code 8-digit code to identify High Level Group Term Used to create hierarchy

file:hlgt_hlt.asc

  return to Ascii data files
# Field Name Description Representation
1
 hlt_code 8-digit code to identify High Level Term Used to create hierarchy
2
 pt_code 8-digit code to identify Preferred Term Used to create hierarchy

file:hlt_pt.asc

  return to Ascii data files
# Field Name Description Representation
1
 hlt_code 8-digit code to identify High Level Term Used to create hierarchy
2
 pt_code 8-digit code to identify Preferred Term Used to create hierarchy

file:intl_ord.asc

  return to Ascii data files
# Field Name Description Representation
1
 intl_ord_code Serial code for international System Organ Class sort order MRSAT: ATN = "MISO"
2
 soc_code 8-digit code to identify System Organ Class  

file:smq_list.asc

  return to Ascii data files
# Field Name Description Representation
1
 SMQ_code 8-digit code assigned to the Standardised MedDRA Query, starts with "2" MRCONSO.CODE
2
 SMQ_name Name for the SMQ; each SMQ carries "(SMQ)" at the end of the name MRCONSO.STR
3
 SMQ_level Value between 1 and 5 identifying the level of the SMQ within the hierarchy MRSAT: ATN = "SMQ_LEVEL"
4
 SMQ_description Description of the SMQ including inclusion and exclusion criteria MRDEF.DEF
5
 SMQ_source Source for the development of the SMQ (e.g., medical references) MRSAT: ATN = "SMQ_SOURCE"
6
 SMQ_note Note for users to better understand the scope and development process for the SMQ. The description of the algorithm used is included (if applicable), as well as the definition of categories MRSAT: ATN = "SOS"
7
 MedDRA_version MedDRA version to use in conjunction with this SMQ Not used (value is always the current version)
8
 Status Status of the SMQ. "A" = an active SMQ; "I" = an inactive SMQ. MRSAT: ATN = "SMQ_STATUS"
9
 SMQ_algorithm If the SMQ was developed for use with an algorithm, the Boolean expression of the algorithm is included. "N" if the SMQ does not utilize an algorithm. MRSAT: ATN = "SMQ_ALGO"

file:smq_content.asc

  return to Ascii data files
# Field Name Description Representation
1
 SMQ_code 8-digit code assigned to the Standardised MedDRA Query, starts with "2" Used to create a "has_member" relationship between the SMQ and its members
2
 Term_code Subordinate term code; it could be a code for a MedDRA PT, LLT or child SMQ Used to create a "has_member" relationship between the SMQ and its members
3
 Term_level MedDRA hierarchy level of the term (4 = "PT", 5 = "LLT") or 0 for a child SMQ MRSAT: ATN = "SMQ_TERM_LEVEL"
4
 Term_scope Defines the MedDRA term as a member of the broad scope (1), narrow scope (2) of the SMQ search, or a child SMQ (0) (zero) MRSAT: ATN = "SMQ_TERM_SCOPE" Attached to the RUI
5
 Term_category The category is assigned a single alphabetical letter depending on the algorithm applied. If the SMQ does not use algorithms, then all Term_category values are assigned "A." For a child SMQ, this field is assigned "S." MRSAT: ATN = "SMQ_TERM_CAT" Attached to the RUI
6
 Term_weight Term weight is used for some SMQ algorithms. "0" is used as default. MRSAT: ATN = "SMQ_TERM_WEIGHT" Attached to the RUI
7
 Term_status Identifies a term as active within this SMQ or inactive within this SMQ. When a term is added to an SMQ, the value is set to "A" for Active. The term can be flagged as "I" for inactive if the term is no longer used in the SMQ. MRSAT: ATN = "SMQ_TERM_STATUS" Attached to the RUI
8
 Term_addition_version Identifies the version of MedDRA in which this term was added to the SMQ MRSAT: ATN = "SMQ_TERM_ADDVERSION" Attached to the RUI
9
 Term_last_modified_version Identifies the version of MedDRA in which this term was last modified in this SMQ. MRSAT: ATN = "SMQ_TERM_LMVERSION" Attached to the RUI