2012AB MedDRA Japanese Source Information
Skip to: Notes, Summary of Changes, Summary
of
Source-Provided
Files Source-Provided
File Details
Notes
The files found in the ASCII/MDRA_J141 directory of the MedDRA release
contain the complete current MedDRA Japanese data set.
Metathesaurus source processing requires only these files. The
consecutive files, found in the ASC_SEQ/MDRA_J141 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 Japanese translation
of MedDRA. For information about other translations (Czech, Dutch,
French, German, Hungarian, Italian, Portuguese, and Spanish) see the
representation pages for each specific source and for MedDRA (English) which
contains information relevant to the translation sources.
Summary of Changes:
(return to top)
No changes have been made to the original data files or to
representation of MDRJPN in 2012AA.
Source-Provided Files: Summary
(return to top)
The Japanese language MedDRA distribution includes the
following:
Documentation and Reference
| File Name |
Description |
| ASCII_seq_datafiles_14_1_Japanese.doc |
ASCII and Consecutive Files Documentation. This is the
primary documentation for the data files. |
| SMQ_intguide_14_1_Japanese.doc |
SMQ Introductory Guide |
| SMQ_spreadsheet_14_1_Japanese.xls |
SMQ Spreadsheet |
| intguide_14_1_Japanese.doc |
Introductory Guide |
| version_report_14_1_Japanese.xls |
Version Report |
| whatsnew_14_1_Japanese.doc |
What's New in this version |
Ascii data files
All information from the ASCII/MDRA_J141 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 |
| ASC_SEQ/MDRA_J141/hlt_j.seq |
High Level Terms |
| ASC_SEQ/MDRA_J141/hlt_pt.seq |
Relationships between HLT and PT codes |
| ASC_SEQ/MDRA_J141/llt.seq |
Lower Level Terms (English) |
| ASC_SEQ/MDRA_J141/llt_j.seq |
Lower Level Terms (Japanese) |
| ASC_SEQ/MDRA_J141/mdhier.seq |
Hierarchy data: data in this file is redundant to data in
soc_hlgt.asc, hlgt_hlt.asc and hlt_pt.asc |
| ASC_SEQ/MDRA_J141/pt.seq |
Preferred Terms (English) |
| ASC_SEQ/MDRA_J141/pt_j.seq |
Preferred Terms (Japanese) |
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.
- kanji: Japanese-Chinese characters
- kana: Japanese phonetic symbols
- kana1: alternate kana name
- kana2: alternate kana name
file:llt_j.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 |
2
|
llt_kanji |
Full name of Lowest Level Term |
MRCONSO.STR (TTY= "LT" or "OL") |
3
|
llt_jcurr |
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" |
4
|
llt_kana |
Kana form of Lowest Level Term |
MRCONSO.STR (TTY = "LTJKN" or "OLJKN") |
5
|
llt_kana1 |
Alternate kana form of Lowest Level Term |
MRCONSO.STR (TTY = "LTJKN1" or "OLJKN1") |
6
|
llt_kana2 |
Alternate kana form of Lowest Level Term |
MRCONSO.STR (TTY = "LTJKN2" or "OLJKN2") |
file:pt_j.asc
return to Ascii
data
files
Preferred Terms
| # |
Field Name |
Description |
Representation |
1
|
pt_code |
8-digit code to identify Preferred Term |
MRCONSO.CODE, MRCONSO.SDUI |
2
|
pt_kanji |
Full name of Preferred Term |
MRCONSO.STR (TTY = "PT") |
3
|
pt_kana |
Kana form of Preferred Term |
MRCONSO.STR (TTY = "PTJKN") |
4
|
pt_kana1 |
Alternate kana form of Preferred Term |
MRCONSO.STR (TTY = "PTJKN1") |
5
|
pt_kana2 |
Alternate kana form of Prefered Term |
MRCONSO.STR (TTY = "PTJKN2") |
file:hlt_j.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 |
2
|
hlt_kanji |
Full name of High Level Term |
MRCONSO.STR (TTY = "HT") |
3
|
hlt_kana |
Kana form of High Level Term |
MRCONSO.STR (TTY = "HTJKN") |
4
|
hlt_kana1 |
Alternate kana form of High Level Term |
MRCONSO.STR (TTY = "HTJKN1") |
5
|
hlt_kana2 |
Alternate kana form of High Level Term |
MRCONSO.STR (TTY = "HTJKN2") |
file:hlgt_j.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 |
2
|
hlgt_kanji |
Full name of High Level Group Term |
MRCONSO.STR (TTY = "HG") |
3
|
hlgt_kana |
Kana form of High Level Group Term |
MRCONSO.STR (TTY = "HGJKN") |
4
|
hlgt_kana1 |
Alternate kana form of High Level Group Term |
MRCONSO.STR (TTY = "HGJKN1") |
5
|
hlgt_kana2 |
Alternate kana form of High Level Group Term |
MRCONSO.STR (TTY = "HGJKN2") |
file:soc_j.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 |
2
|
soc_kanji |
Full name of System Organ Class |
MRCONSO.STR (TTY = "OS") |
3
|
soc_order |
System Organ Class Order |
Not processed |
4
|
soc_kana |
Kana form of System Organ Class |
MRCONSO.STR (TTY = "OSJKN") |
5
|
soc_kana1 |
Alternate kana form of System Organ Class |
MRCONSO.STR (TTY = "OSJKN1") |
6
|
soc_kana2 |
Alternate kana form of System Organ Class |
MRCONSO.STR (TTY = "OSJKN2") |
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_j.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_kanji |
Name for the SMQ; each SMQ carries "(SMQ)" at the end of the
name |
MRCONSO.STR (TTY = "SMQ") |
3
|
SMQ_desc_kanji |
Descdript of the SMQ including inclusion and exclusion criteria |
MRDEF.DEF |
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 |
