Skip to main content


         This documentation site is for previous versions. Visit our new documentation site for current releases.      
 

This content has been archived and is no longer being updated.

Links may not function; however, this content may be relevant to outdated versions of the product.

Data storage in Pega Pharmacovigilance

Updated on July 14, 2017

Pega Pharmacovigilance uses the following solutions to hold key reference data that are used in processing adverse event cases and performing data lookups:

Local data storage

The following classes are sources for the data types that are used in the application:

Local data storage classDescription
PegaLS-FW-AECPFW-Data-EvaluationCodesFDA CDRH manufacturer evaluation codes
PegaLS-FW-AECPFW-Data-ICHCodesICH 2-character country codes
PegaLS-FW-AECPFW-Data-RouteOfAdministrationRoute of drug administration, for example, oral
PegaLS-FW-AECPFW-Data-ProductConfigurationQuestionnaire and labeledness applicability for drugs
PegaLS-FW-AECPFW-Data-ProductLabelednessConfigurationLabeledness configuration for drugs
PegaLS-FW-AECPFW-Data-ReporterQualificationReporter qualifications per E2B R3 and eMDR
PegaLS-FW-AECPFW-Data-NullFlavorMasterListValid nullflavors for each attribute per entity

MedDRA data model

The following Life Sciences Industry Foundation classes include database tables that are used in MedDRA data lookups:

ClassDatabase tableDescription
PegaLS-FW-Int-MDHIERARCHYMD_HIERARCHYHierarchical path for each PT
PegaLS-FW-Int-HLGTHLTCOMPHLGT_HLT_COMPHLGT and HLT association
PegaLS-FW-Int-HLGTPERFTERMHLGT_PERF_TERMHLGTs
PegaLS-FW-Int-HLTPERFCOMPHLT_PERF_COMPHLT and PT association
PegaLS-FW-Int-HLTPERFTERMHLT_PERF_TERMHLTs
PegaLS-FW-Int-LOWLEVELTERMLOW_LEVEL_TERMLLTs and associated PTs
PegaLS-FW-Int-PERFTERMPERF_TERMPTs
PegaLS-FW-Int-SOCHLGTCOMPSOC_HLGT_COMPSOC and HLGT association
PegaLS-FW-Int-SOCTERMSOC_TERMSOC terms

Product data model

The Product data model includes Life Sciences Industry Foundation classes and database tables that are used in WHO drug lookup and in sample drug browsing:

WHO Drug Dictionary

ClassDatabase table
PegaLS-FW-Int-WHO-Drug-C-AtcCodeWHO_DRUG_C_ATC_CODE
PegaLS-FW-Int-WHO-Drug-C-CountryWHO_DRUG_C_COUNTRY
PegaLS-FW-Int-WHO-Drug-C-IngredientsWHO_DRUG_C_INGREDIENTS
PegaLS-FW-Int-WHO-Drug-C-MedicinalProductWHO_DRUG_C_MEDICINAL_PRODUCT
PegaLS-FW-Int-WHO-Drug-C-OrganizationWHO_DRUG_C_ORGANIZATION
PegaLS-FW-Int-WHO-Drug-C-PharmaFormWHO_DRUG_C_PHARMA_FORM
PegaLS-FW-Int-WHO-Drug-C-PharmaProductWHO_DRUG_C_PHARMA_PRODUCT
PegaLS-FW-Int-WHO-Drug-C-ProductGroupWHO_DRUG_C_PRODUCT_GROUP
PegaLS-FW-Int-WHO-Drug-C-ProductTypeWHO_DRUG_C_PRODUCT_TYPE
PegaLS-FW-Int-WHO-Drug-C-SourceWHO_DRUG_C_SOURCE
PegaLS-FW-Int-WHO-Drug-C-StrengthWHO_DRUG_C_STRENGTH
PegaLS-FW-Int-WHO-Drug-C-SubstanceWHO_DRUG_C_SUBSTANCE
PegaLS-FW-Int-WHO-Drug-C-TherapeuticGroupWHO_DRUG_C_THERAPEUTIC_GROUP
PegaLS-FW-Int-WHO-Drug-C-UnitWHO_DRUG_C_UNIT
PegaLS-FW-Int-WHO-Drug-C-UnitLWHO_DRUG_C_UNIT_L
PegaLS-FW-Int-WHO-Drug-C-UnitXWHO_DRUG_C_UNIT_X

Internal sample products

ClassDatabase tableDescription
PegaLS-FW-Int-ProductInfoLS_PRODUCTSInformation about the product
PegaLS-FW-Int-ProductTypeLS_PRODUCTTYPEType of the product
PegaLS-FW-Int-ProdActiveSubstanceLS_PROD_ACTIVESUBSTANCEInformation about the active substance
PegaLS-FW-Int-IngredientsLS_INGREDIENTSThe ingredients of the product
PegaLS-FW-Int-ATCCodesLS_ATCCODESList of ATC codes
PegaLS-FW-Int-ProdAtcCodeLS_PROD_ATCCODEInformation about products mapped to ATC codes

Tags

Pega Pharmacovigilance 7.31 Pega Pharmacovigilance Data Integration Healthcare and Life Sciences

Have a question? Get answers now.

Visit the Support Center to ask questions, engage in discussions, share ideas, and help others.

Did you find this content helpful?

Want to help us improve this content?

We'd prefer it if you saw us at our best.

Pega.com is not optimized for Internet Explorer. For the optimal experience, please use:

Close Deprecation Notice
Contact us