HOME : SUPPORT : TRAINING : ONLINE COURSES
Welcome
Lesson 1: Drug Pipeline Directory Basics
Lesson 2: IMS R&D
Focus
Lesson 3: Pharmaprojects
Lesson 4: Adis R&D Insight
Lesson 5: Prous Databases
Lesson 6: Course
Wrap-up

Need Help?
Email Course Coordinator

The Record...

Sharon wanted information on licensing. The status of the drug should provide this data. We'll look at the entire record to see if there is anything else that might be of interest.

The first part of the record in Pharmaprojects includes basic drug data, such as the drug name, company information, and synonyms for the drug. Note that there is no separate listing for trade or brand names in this database. All names are listed under synonyms.

This file, like IMS, has extensive market data. It also has extensive status information including the status of each country globally where the drug is being marketed. This should help Sharon track marketing of the drug worldwide.

Note: In order to give you supplemental information (tips, learn more comments) about the Dialog record, we have had to add spaces between some of the fields. Print out the complete record for File 128 to have a concise duplicate of the Dialog record you will retrieve online. You can compare it to the parts of the record we will highlight later in the lesson.

Here are a few things Sharon might want to see from this part of the record.

  1. Drug/product name: Pharmaprojects compiles a wealth of alternative product nomenclature, including chemical names, lab codes, brand names, and generic names. These facilitate initial identification and provide more synonyms for effective follow-up searches in biomedical literature files. Tip 3-3
  2. Company name: The company name field includes the originator and licensee. Pharmaprojects always prefers parent company names in indexing for both originators and licensees, but will often include originating subsidiary names in the text.
    Learn More
  3. Other parts of the record include the molecular formula and CAS® Registry Number
    Tip 3-4 Tip 3-5
  4. Synonyms: In Pharmaprojects the synonyms field includes the trade or brand name, laboratory code, and generic name, unlike IMS R&D Focus which provides separate fields for each data element.
  5. Development status: Pharmaprojects provides thorough recaps of developmental stage transitions and dates and consistently identifies when records were last updated. This file shows the most advanced stage of development a compound has reached in any country.
  6. Patent information is also provided in some records. The patent number, country where the patent was filed, and priority information (date the patent was first filed and country of filing). The patent assignee is not listed as it was in IMS.
    Learn More

Review the bibliographic parts of the record and then go to the next page.

1/19/1 
DIALOG(R)File 128: PHARMAPROJECTS
(c) 2007 INFORMA UK LTD. All rights reserved.

0030985        ** Image available **
Drug Name:     vatalanib
World Status:  Phase III Clinical Trial
Pharma Status: Active
Synonyms:      CGP-79787
               CGP-79787D
               PTK-787
               PTK/ZK
               VEGF-TK1
               ZK-222584
Originator:    Novartis (Switzerland) [Phase III Clinical Trial] 
New Entity:    Yes
Latest Upd:    Updated On  By  Latest Change
               20070119    JB  Filing plans updated



CHEMICAL DATA


Origin:        Code    Description
               CH-SY   Chemical, synthetic

Tip 3-6    Tip 3-7    Learn More
CAS Reg. No:   212141-54-3
Rot. Bonds:    4
Mol. Formula:  C20H15CLN4


Hydrogen Bond Donors: 1     Hydrogen Bond Acceptors: 4
Mol. Weight:   346.82       AlogP: 4.46


Chemical Name: 
            N-(4-Chlorophenyl)-4-(pyridin-4-ylmethyl)phthalazin-1-amine 
Tip 3-8


 STRUCTURE


COUNTRY DATA
Status:     (Active)         Learn More
            France             Phase II Clinical Trial/Licensing
                               Availability Unknown
            Germany            Phase III Clinical Trial/Licensing
                               Availability Unknown
            Switzerland        Phase III Clinical Trial/Licensing
                               Availability Unknown
            World              Phase III Clinical Trial

*Portions of record not shown.

We can see from the Status information that vatalanib has reached Phase III Clinical Trial in Germany and Switzerland, but is still in Phase II Clinical Trials in France.

Go to the next page


3-4
Next page

Authoritative Answers Enriched by ProQuest

Search Tip 3-3:

Using /NA or NA= retrieves all names: chemical name, laboratory code, brand name, and generic name.

Search Tip 3-4:

The molecular formula is searchable using the MF= prefix.

Example:
s mf=c44h72no12

Search Tip 3-5:

Use the CAS® Registry Number to search in a biomedical literature file such as Embase® (File 72, 73) or MEDLINE® (File 154, 155).

Example:
s rn=104987-11-3

Search Tip 3-6:

Country names in the /CO originator field are usually spelled out in full. UK and USA are exceptions.

Search Tip 3-7:

Use the (S) operator to link licensee (/LI), originator (/LO), or company (/CO) name with status of the drug.

Example:
s merck(S)phase()iii/LI

Search Tip 3-8:

The chemical name can be searched in the basic and additional indexes. Remember to use proximity connectors when searching in the basic index.

Example:
s 14alpha(w)dihydroxy/cn


Note: When searching using the prefix CN=, use the EXPAND command to verify spelling, punctuation, and spacing.

Learn More #1:

Company data can be searched in different ways depending on what the status of the company is: an originator or licensor or licensee.

Dialog allows us to search for these specific pieces of information.

/CO, CO= Includes company name of originator and licensee

Example: S CO=MERCK?
/LI, LI= Includes name of licensee

Example: S TAKEDA/LI
/LO, LO= Includes the Originator

Example: S LO=ALMIRALL?

You cannot search for patent assignee in this database, as you can in IMS R&D Focus.

Note: You may also want to EXPAND to retrieve the exact spelling of the corporate name (e.g., expand li=merck)

Print page

Learn More #2:

To find patent information, use the following prefixes:

Print page

Learn More #3:

Licensing arrangements utilize the licensee (LI=) or Licensor (LO=) fields for the company name.

General licensing opportunities can be found indexed in two places:

Example: To search for licensing availability, use the update segment of the record. To search for March 2006 licensing opportunities in Japan:
S 200603? (s) licensing(w)opportunities/up and japan(s)licensing/st

Note: Any product licensed to and launched by a company will only have that company's name in the company name field if further launches are planned by that licensee. The licensee's name will, however, remain in the text field. The originator's name will always remain in the company name field.

To find products by a company or the originating company, search:
Example: s pfizer/lo

To search for products in Phase III clinical trials by Pfizer as a licensee:
Example: : s pfizer/LI(s)III/LI

Print page

Learn More #4:

Key stages in the life cycle of a pharmaceutical product are cross-referenced to country names in Pharmaprojects. Status data for 40 countries, representing major markets worldwide is indexed in Pharmaprojects.

In addition, the Status field WORLD, followed by the most advanced stage of development for the product recorded anywhere in the world is used (e.g., s launched(s)world/st).

Searchable "stage" or STATUS terms include: Preclinical, Phase I, Phase II, Phase III, Clinical Trial, Pre-Registration, Registered, Launched, Available for Licensing, Withdrawn, or Suspended.

More than one phase of development will be documented in many Pharmaprojects records, as it is not at all uncommon for a product to be approved in one country while still undergoing clinical trials necessary for approval in another.

Use the (S) connector to ensure that STATUS keywords are cross-referenced in the same subfield as designated countries.

Example: s (iii(S)japan and available(s)licensing(s) usa)/st

Note: Because the /ST field is indexed word-by-word, only significant portions of Status keyword phrases need to be searched, e.g., S (III(S) USA)/ST. The term CLINICAL will retrieve Phases i , ii and iii, as well as records where the phase is unspecified but human studies are known to be underway.

Print page