Pharmaprojects reports on pharmaceutical products (predominantly new chemical entities but also biotechnology products and novel formulations) under development in all major markets by over 800 companies in 28 countries. International journals, business newsletters, conference proceedings, stock brokerage and annual reports and publications are scanned by PJB Publications for inclusion in Pharmaprojects.
The following alphabetical list provides the two-letter label, the relevant alias, and an example for each Pharmaprojects field.
===== ============
Label Name/Example
===== ============
an or ui Accession Number
example 1: 015112.an.
example 2: 015112.ui.
ci or rw Chemical Information
example 1: methyl.ci.
example 2: methyl.rw.
example 3: metho$.ci.
example 4: phenol.rw
cn Company Name
example: sanofi.cn.
cy Country Information
example: canada.cy.
dc Drug Code
example: enzyme.dc.
de Descriptors
example 1: hormone h04z.de.
example 2: anaesthestic injectible n01a2.de.
em Entry Month
example 1: 9402.em.
example 2: new document.em.
hw Heading Word
example 1: h40z.hw.
example 2: hormone.hw.
nm Drug Name [from TI and SY fields]
example 1: gm$.nm.
example 2: uraprene.nm.
example 3: irtemazole.nm.
nt Notes
example 1: activator.nt.
example 2: alzheimers.nt.
rn Registry Number
example: 113558-89-7.rn.
sh Subject Headings [from TI, SY, DE fields]
example 1: hormone$.sh.
example 2: acadesine.sh.
example 3: albunex.sh.
so Source
[this field is display only]
sy Synonyms
example 1: artificial tear.sy.
example 2: uraprene.sy.
ti Title
example 1: dopamine pharmos.ti.
example 2: gm$.ti.
tx Text
example 1: inhibit$.tx.
example 2: cloned.tx.
example 3: side effect.tx.
tw Textword [from TX, CN, DC, CY and NT fields]
example 1: norway.tw.
example 2: sanofi.tw.
example 3: vaso$.tw.
The following are the Ovid limits for the Pharmaprojects database. Both forms of syntax for applying the limit directly at the command line are given where relevant.
Limit Name Example
Amended Documents
Sentence Syntax: limit 1 to amended documents
Country...
Sentence Syntax: limit 1 to canada
Drug Status...
Sentence Syntax: limit 1 to registered
Latest Update
Command Syntax: ..l/1 up=y
Sentence Syntax: limit 1 to latest update
Licensee
Sentence Syntax: limit 1 to licensee
New Documents
Sentence Syntax: limit 1 to new documents
Originator
Sentence Syntax: limit 1 to originator
Revised Documents
Sentence Syntax: limit 1 to revised documents
Change to Pharmaprojects Current file from another database
-----------------------------------------------------------
Command Syntax: ..c/phar
Sentence Syntax: use phar
Change to Pharmaprojects Launched file from another database
------------------------------------------------------------
Command Syntax: ..c/phap
Sentence Syntax: use phap
Change to Pharmaprojects Discontinued file
from another database
------------------------------------------
Command Syntax: ..c/phab
Sentence Syntax: use phab