Excel Output changes – Drug Pipeline Databases
Changes implemented to improve the export from AdisInsight: Drugs and IMS R&D Focus – specifically. Changes may be noticeable elsewhere too
Existing column names changed
- Drug Company Company information (see also New columns, below)
- molecularFormula Molecular Formula
- mechanism Mechanism Of Action
- route Route Of Administration
- highestPhase Phase Of Development (Highest)
- devPhases Phase Of Development (see also New columns, below)
New columns introduced
- Subfields of Company Information
- Company Information – Name
- Company information – Type
- Company information – Role (now includes also Licensee and Originator)
- Company information – Country/Region
- Subfields of Phase Of Development
- Phase Of Development - Phase
- Phase Of Development - Country/Region
- Phase Of Development - Indication
- Phase Of Development - Route Of Administration
- Phase Of Development - Formulation
- Phase Of Development - On Fast Track
- Phase Of Development - Qualifiers And Comments
- Other new columns
- Substance
- Generic Name
- Synonym
- Molecular formula
- Therapeutic Class
- Indication
- Drug Status
- One-to-Many
- AdisInsight: Drugs and IMS R&D Focus ONLY now support 'One-to-Many' functionality
- Company Information
- Phase of Development
- References (Adis only)
- These fields contain multiple values per record that were previously hidden in Excel
- Implementation of One-to-Many allows EACH value to be displayed on individual rows and columns to enable filtering and sorting.