Viewing Data in the Browse Repository Data Window
The Browse Repository Data window displays dictionary terms and verbatim terms. It offers the following special features:
-
Viewing deleted data. See Viewing Current and Historical Data.
-
Complete Related Term information. See Viewing Terms Related to the Current Term.
-
Conducting searches for common parent terms. See Using a Child Search.
-
The Date feature enables you to browse a dictionary at a certain point in time.
The Browse Repository Data window displays a domain view of the TMS Repository. That is, you can see only those terms and relations, whether they are external, company, domain terms and relations or VTAs, that are assigned to the TMS domain you are currently in. The current TMS domain is displayed in parentheses in the window's title bar. You can go to a different TMS domain at any time by selecting Options and then Change Domain from the menu.
For information about understanding and using the dictionary hierarchy tree structure display, see Using the Tree Structure.
The Browse Repository Data window has a dictionary hierarchy tree structure on the left and three data blocks on the right, and includes the following features:
- Viewing Current and Historical Data
- Current Level Block
- Level Above Block
- Level Below Block
- Changing the Sort Order
- Viewing Terms Related to the Current Term
- Understanding the Origin Field
- Using a Child Search
- Using an Extended Search
Parent topic: Browsing the Repository in TMS
Viewing Current and Historical Data
You can view deleted terms and relations as well as current ones by clicking the All Data option in the Data Currency group at the top of the Browse Repository Data window. You can differentiate deleted data from current data by examining the line and T icons in the left-hand column. Visible black T and line icons indicate current terms and relations, respectively. If the line icon has been replaced by a red X, the relation has been deleted. If the T icon has been replaced by a red X, the term has been deleted.
In addition, you can view the terms and relations that were current or deleted at any point in a dictionary's history. Performing a query against a dictionary on a particular date enables you to view which terms were current on that date, and the terms to which they related.
To query dictionary data on a specific date:
- Click the Date option at the top of the window.
- Enter a date (in DD-MON-YYYY format) in the Date field.
- Query for dictionary data in the Current Level block. TMS returns the dictionary data matching your query, marking the currency of terms and relations on the selected date.
Parent topic: Viewing Data in the Browse Repository Data Window
Current Level Block
TMS displays the current level in the middle block in the window, with data displayed in the rest of the window as it relates to the current level and term.
In strong dictionaries, TMS displays relations hierarchically. The level above shows parent terms of the current term, while the level below shows the current term's child terms. In weak dictionary folders, the level above shows relations that contain the current level as a reference term, while the level below displays terms that are reference terms in relations with the current term. See Level Above Block and Level Below Block for information on how to specify which one you want to view.
For more information, see:
Parent topic: Viewing Data in the Browse Repository Data Window
Current Level
The current level is the level displayed in the Current Level block at the middle of the screen at any given time. You can select the current level by clicking on it in the dictionary hierarchy tree structure. The header above the first column of the Current Level block also displays the name of the level selected in the navigator tree.
To view data, you must then execute a query in the middle block. You can change the display order by clicking on column heads.
Parent topic: Current Level Block
Current Term
The current term is the term displayed on a blue background in the Current Level block. After a query, TMS makes the top record the current term by default. You can change the current term by selecting another one with your cursor, or querying for it. TMS displays data on screen as it relates to the current level and term—that is, the upper block displays terms in the level above the current level and related to the current term, and the lower block displays terms in the level below the current level that are related to the current term.
Parent topic: Current Level Block
Changing the Data Displayed
To move related terms of the current term into the Current Level block, double-click on the related term or click on the level you want in the tree structure while the current term is displayed on the right. You can only move in one-level increments; if you select a level two or more levels removed from the current level, TMS displays a blank screen and you must execute a query to see data. However, you can move to the display of related terms in any related level as long as you move one level at a time.
To see unrelated terms in any level, click on the level you want in the tree structure and then execute a query in the Current Level block.
Parent topic: Current Level Block
Current Level Block Fields
The current level provides the following term information:
-
Level_Name: The name of the term. Free-form text of up to 300 alphanumeric characters.
-
Level: The short name of the level in which this term is stored.
-
Code: Optional user-defined field designed to serve as the primary key within this dictionary; must be unique within the dictionary.
-
Alt Code: Optional user-defined field.
-
Sub Type: Company, Domain and External are dictionary terms. Accepted and Misspelled are VTAs.
External terms are supplied by the vendor or were part of a legacy dictionary. They are global. Company terms were created in this company and are global. Domain terms were created in this company and are available only within one or more domains.
Accepted VTAs link a correctly spelled verbatim term to a dictionary term. Misspelled VTAs link a misspelled verbatim term to a dictionary term.
-
Glb?: (Global?) If selected, this term is available in all domains. If not selected, it is available in the current domain. (It may be available in other domains as well.)
-
Appr?: (Approved?) This setting has a somewhat different meaning depending on whether it refers to a verbatim or a dictionary term.
If selected for a VTA, the VTA is approved and does not require manual approval. TMS can use the VTA in Autoclassification.
If selected for a dictionary term, the term is approved as a potential classification. If you are adding more domain or company terms that you want to use instead of an external dictionary term, you can deselect the Appr? box for the external dictionary term.
-
Status: Optional. Enter a value to describe the status of the term.
-
Category: Optional. MedDRA supplies categories for some of its terms, such as Diagnosis, Adverse Event, or Undefined Procedures. These are displayed here. For other dictionaries, you can assign categories to terms according to your company's policies. Free-form text; up to 65 alphanumeric characters.
-
Origin: The manner in which this term was introduced to the TMS Repository.
-
ID: An ID that is unique across TMS and serves as the primary key in TMS.
-
Comment Text: Optional. Use for any information that would be helpful to others using the dictionary. For example, "This drug should be included in the next version of WHO-Drug, and I have submitted it," or "This may seem wrong, but I've checked with the investigator." Free-form text; up to 200 alphanumeric characters.
-
Created By: The user ID of the person who added the current term or executed the load script.
-
Creation: The creation timestamp for the current term.
-
Valid To: Date until which the term is valid.
-
Deleted By: The TMS user who deleted this term, if any.
-
Trans.Id.: Not used in this release.
-
Values 1-4: The last four fields are available for customization and may have descriptive labels.
Parent topic: Current Level Block
Level Above Block
For strong dictionaries, the block at the top of the screen displays terms related to the current term that are in the level above the current level in the dictionary hierarchy. If two (or more) levels are related to the current level just above it in the hierarchy, the current level is displayed twice (or more) in the tree structure. The level displayed in the Level Above block depends on which display of the current level you click in the tree structure.
For weak dictionary folders, the upper block displays relations in which the current term is the reference term for the relation. Each row represents a term and its relation to the current term. The fields in the upper block are:
-
Term: For dictionaries with strong definition, this field displays the parent term of the term selected in the middle block. For dictionaries with weak definition, this field displays term(s) that have the selected term (in the middle block) defined as a reference term.
-
Relation: The relationship between the upper block term and the selected term (in the middle block). STRONG denotes a hierarchical relationship; any other description denotes a named relation.
-
Level: The name of the dictionary and level in which this term is stored.
-
Code: Optional user-defined field designed to serve as the primary key within this dictionary for the related term; must be unique within the dictionary.
-
PL?: The Primary Link?/Primary Path Link? box, if selected, denotes that the current term is either a Primary Link or Primary Path Link in this level for the current term. Refer to the relation line between the levels in the TMS tree structure to determine the relationship between the selected levels.
-
DPL?: The Domain Primary Link? box. If selected, this term is the Primary Link in this level for the current term in the current domain.
-
RGlb: The Relation Global? box. If selected, this relation is valid across all domains.
-
Appr?: (Approved?) This setting has a somewhat different meaning depending on whether it refers to a VTA or a dictionary term. Selected by default.
If selected for a VTA, the VTA is approved; TMS can use the VTA in Autoclassification and manual approval is not required.
If selected for a dictionary term, the term is approved as a potential classification.
-
Type: (Relation Type) Inherits the type of the term on this row: Dictionary or Verbatim.
-
Sub Type: (Relation Subtype) Company, Domain and External are relations to dictionary terms. Accepted and Misspelled subtypes apply to VTAs and VTIs.
External relations are supplied by the vendor or were part of a legacy dictionary. They are global. Company relations were created in this company and are global. Domain relations were created in this company and are available only within one or more domains.
Accepted VTAs and VTIs link a correctly spelled verbatim term to a dictionary term. Misspelled VTAs and VTIs link a misspelled verbatim term to a dictionary term.
-
R. Status: (Relation Status) Optional. Enter a value to describe the status of the relationship.
-
R.Trans.ID: Not used in this release.
-
Alt Code: Optional user-defined field.
-
ID: An ID that is unique across TMS and serves as the primary key in TMS for the related term.
-
Category: Optional, user-defined. MedDRA supplies categories for some of its terms, such as Diagnosis, Adverse Event, or Undefined Procedures. These are displayed here.
-
Origin: The manner in which this term was introduced to the TMS Repository.
-
Relation Comment: User-defined comment about the relationship between these two terms. Information in this field could provide information for users browsing the TMS Repository.
-
Created By: The user ID of the person who added the current term or executed the load script.
-
Created: Timestamp for the creation of this term.
-
Relation Created By: The TMS user who created this relation.
-
Relation Created: Timestamp for the creation of this relation.
-
Relation Valid Until: TMS uses this value to maintain an audit trail of relations. When a relation is created, it receives a default end timestamp in the distant future (currently August 3500). When a relation is updated, a new relation record is created and the old relation's end timestamp is set to the creation timestamp of the new relation. This field is used to recreate the dictionary at a given point in time.
-
Relation Deleted By: The TMS user who deleted this relation, if any.
-
Values 1-4: The last four fields are available for customization and may have descriptive labels.
Parent topic: Viewing Data in the Browse Repository Data Window
Level Below Block
For strong dictionaries, the block at the bottom of the screen displays terms related to the current term that are in the level below the current level in the dictionary hierarchy. For weak dictionary folders, the lower block displays relations in which the current term is the source term for the relation.
Each row represents a term and its relation to the current term. The fields are:
-
Relation: The named relation between the selected term (in the middle block) and this term (the reference term).
-
Term: The reference term for this relationship.
-
Level: The name of the dictionary and level in which this term is stored.
-
Code: Optional user-defined field designed to serve as the primary key within this dictionary for the related term; must be unique within the dictionary.
-
RGlb?: (Relation Global?) If selected, this relation is valid across all domains.
-
Appr?: (Approved?) This setting has a somewhat different meaning depending on whether it refers to a VTA or a dictionary term. Selected by default.
If selected for a VTA, the VTA is approved; TMS can use the VTA in Autoclassification and manual approval is not required.
If selected for a dictionary term, the term is approved as a potential classification.
-
Alt Code: Optional user-defined field.
-
Type: (Relation Type). Inherits the type of the term on this row: Dictionary or Verbatim.
-
Sub Type: (Relation Subtype). Company, Domain and External are relations to dictionary terms. Accepted and Misspelled apply to VTAs and VTIs.
External relations are supplied by the vendor or were part of a legacy dictionary. They are global. Company relations were created in this company and are global. Domain relations were created in this company and are available only within one or more domains.
Accepted VTAs and VTIs link a correctly spelled verbatim term to a dictionary term. Misspelled VTAs and VTIs link a misspelled verbatim term to a dictionary term.
-
R. Status: (Relation Status) Optional. Enter a value to describe the status of the relationship.
-
R.Trans.ID: Not used in this release.
-
Category: Optional. MedDRA supplies categories for some of its terms, such as Diagnosis, Adverse Event, or Undefined Procedures. These are displayed here.
-
ID: An ID that is unique across TMS and serves as the primary key in TMS for the related term.
-
Origin: The manner in which this term was introduced to the TMS Repository.
-
Comment Text: Optional. Information entered by the person who added, modified, or deleted this term.
Parent topic: Viewing Data in the Browse Repository Data Window
Changing the Sort Order
In the Current Level block, you can sort terms using some of the column heads as criteria. Click on an active column head—one that looks like a button—once to indicate that you want to sort on it (alphabetically for character fields, numerically for numeric fields). Click again to sort in the opposite order.
Note:
TMS sorts numbers by the first digits, no matter how many digits the number contains, so that 12345 comes before 543 in ascending order.
Parent topic: Viewing Data in the Browse Repository Data Window
Viewing Terms Related to the Current Term
When you highlight a term in the Current Level block and click either the Above Current or Below Current button, TMS launches the Drill Down Dictionary Hierarchy window, which displays the terms that relate to the current term in the selected direction, and the related terms. The data structure depicted in this window differs somewhat for terms in strong dictionaries and weak dictionary folders.
For more information, see:
- Display of Deleted Data in Virtual Dictionaries
- Strong Dictionaries in the Drill Down Dictionary Hierarchy Window
- Weak Dictionary Folders in the Drill Down Dictionary Hierarchy Window
Parent topic: Viewing Data in the Browse Repository Data Window
Display of Deleted Data in Virtual Dictionaries
In virtual dictionaries, some of the terms and relations you browse may have been deleted in the base dictionary since the virtual dictionary's cut-off date. The Drill Down Dictionary Hierarchy window flags deleted records with a red X. If the X appears:
-
On the line connecting the terms, the relation has been deleted.
-
On the T icon to the immediate left of the term, the term has been deleted.
Parent topic: Viewing Terms Related to the Current Term
Strong Dictionaries in the Drill Down Dictionary Hierarchy Window
In strong dictionaries, you can see all the current term's related terms in the levels above or below it by selecting Above Current or Below Current. A shortcut window appears and displays all related terms in all levels either above or below the current term in the tree structure. Click on a related term, and information about it appears on the right. To see information about the relation between that term and the current term, click the Relation tab.
In the tree structure in both the Above Current and Below Current windows, the current term is listed at the top, with the related terms listed below. This means that terms in the levels above are actually displayed below the current term. However, their level short name is clearly displayed.
The tree structure of the Level Above window also displays derivable paths. The window denotes Primary Links and Primary Path Links with a green P next to the relationship. Primary paths are not visible in the Level Below window.
Parent topic: Viewing Terms Related to the Current Term
Weak Dictionary Folders in the Drill Down Dictionary Hierarchy Window
Because weak dictionary folders have no dictionary-defined hierarchy, and thus no parent or child relations, the Drill Down Dictionary Hierarchy window displays chains of relations that share the same named relation. For example, selecting the term "France" from a weak dictionary folder of geographic terms might yield the results in Figure 13-2 when you click Level Above.
Figure 13-2 Figure 13-2 Sample Results in the Level Above Window for a Weak Dictionary Folder
![Description of Figure 13-2 Sample Results in the Level Above Window for a Weak Dictionary Folder" Description of Figure 13-2 Sample Results in the Level Above Window for a Weak Dictionary Folder"](img/lvlabve1.gif)
Starting with the current term "France," the window displays all relations that use the named relation "Narrower Term," up to the term "World." You can also display any relations from "France" that use other named relations by selecting a different relationship from the Named Relation list at the top of the window (seen in Figure 13-3).
Figure 13-3 Figure 13-3 Choosing a Named Relation in Drill Down Dictionary Hierarchy
![Description of "Figure 13-3 Choosing a Named Relation in Drill Down Dictionary Hierarchy" Description of "Figure 13-3 Choosing a Named Relation in Drill Down Dictionary Hierarchy"](img/drlldwn2.gif)
Clicking Above Current yields the relations that use the Reciprocal Indicator part of the named relation, while Below Current yields relations that use the Indicator. Thus, in the examples shown above, the named relations Abbreviation, Narrower Term Partitive, Narrower Term Instantive, and Used For are all Reciprocal Indicator relationships.
Parent topic: Viewing Terms Related to the Current Term
Understanding the Origin Field
The Origin field identifies the origin of a term in the TMS Repository. By default, the following search objects appear in the list, and you can include any other user-defined search objects in this list as well:
Origin Type | Definition |
---|---|
Loaded |
Verbatim term was loaded into dictionary |
Direct Match |
Verbatim term exactly matches dictionary term or VTA |
Non Appr VTA Match |
Verbatim term matched to a Nonapproved verbatim term. |
Domain Match |
Verbatim term exactly matches an Approved VTA in another domain |
Manual Match |
Verbatim term manually classified to dictionary term or VTA |
Parent topic: Viewing Data in the Browse Repository Data Window
Using a Child Search
The Child Search option allows you to query for terms on a child level of the current level, and then search for their parent terms. You can choose to search for all parent terms of all selected child terms or for only those parent terms common to all selected child terms. This option is for strong dictionaries only.
To perform a child search:
-
Select a term in the current level and click Child Search. The Child Search window opens.
-
Open a query (F7, or select Query and then Open).
-
Filter the query by selecting the following attributes from the top of the Child Search window:
-
If the current level has more than one child level, select the child level from which you want to start this query. You can include terms from different child levels in the same child search.
-
Choose a Standard or Context Server Query.
-
-
Enter your search criteria in the right side of the window, and execute the query. TMS returns the matches that satisfy your query for child terms in the right side of the window.
-
Click in the row for any child term(s) you want to include in the search, and click the < button. TMS moves the term to the Selected Term block.
-
Select the Any? box to search for all parent terms of all child terms that you will select, or deselect it to search only for those parent terms common to all selected child terms.
-
Click OK. TMS returns you to the Browse Repository Data window and displays the results of the query—the parent terms yielded by the child search—in the middle block. If the query did not retrieve any records, the data in the middle block is unchanged.
Parent topic: Viewing Data in the Browse Repository Data Window
Using an Extended Search
The Browse Repository Data window displays only one domain at a time, and restricts all queries to the selected dictionary level. To query for dictionary data across multiple domains or across all dictionary levels, you must perform an Extended Search. Extended Searches also enable you to search for terms using user-defined search objects.
After you find the results of your Extended Search and choose a term, TMS can close the Extended Search window and make that term the currently selected record in the Browse Repository Data window.
To perform an Extended Search:
Parent topic: Viewing Data in the Browse Repository Data Window