Updates to views on flexible code list tables

Summary

Context based LM tables in mapping (Enhancement 33470471)

Description

Queries pertaining to the views based on flexible code list had context setting depending on the agency, such as, NMPA and MFDS to pick up the appropriate attribute for the corresponding E2B(R3) report generation. These queries required updates for newer profiles to be include the corresponding attributes.

The following View queries have been enhanced to make them independent of the agency:

View Name	Impacted Area
V$LM_CASE_CLASSIFICATION	All E2B(R3) Profiles - ICH, EMA, PMDA, MFDS, NMPA, and eVAERS OBSERVESTUDYTYPE[C.5.4] All E2B(R2) Profiles - ICH, EMA, FDA (2.1/2.2), and PMDA OBSERVESTUDYTYPE[A.2.3.3] NMPA E2B(R3) REPORTSOURCE [C.1.CN.1] REPORTCATEGORY[C.1.CN.2] MFDS E2B(R3) OTHERSTUDIESTYPE [C.5.4.KR.1]
V$LM_CAUSALITY	EMA R2B(R3) DRUGASSESSMENTSOURCE [G.k.9.i.2.r.1] EUDRUGASSESSMENTSOURCE[G.k.9.i.2.r.1.EU.1] EUDRUGASSESSMENTMETHOD[G.k.9.i.2.r.2.EU.1] DRUGRESULT[G.k.9.i.2.r.3] EUDRUGRESULT[G.k.9.i.2.r.3.EU.1] PMDA(R3) / PMDA(R2) DRUGRESULT[G.k.9.i.2.r.3] NMPA DRUGASSESSMENTSOURCE [G.k.9.i.2.r.1] DRUGRESULT[G.k.9.i.2.r.3] CNSOURCEOFASSESS[G.k.9.i.2.r.CN.1] CNRESULTASSESS[G.k.9.i.2.r.CN.2] MFDS DRUGASSESSMENTSOURCE [G.k.9.i.2.r.1] KRCTRESULTOFASSESSMENT[G.k.9.i.2.r.3.KR.2] KRMETHODOFASSESSMENT[G.k.9.i.2.r.2.KR.1] WHOUMCRESULTOFASSESSMENT[G.k.9.i.2.r.3.KR.] PMDA_DEVICE F8_HEALTHDAMAGE_DETAIL REPORTCLASS F10_HEALTHDAMAGE_DETAIL F10_DESCRIPTIONOFDEVICEPROBLEM F8_DESCRIPTIONOFDEVICEPROBLEM
V$LM_DEV_PHASE/ V$LM_DEV_PHASE_DLP	PMDA E2B(R3) MHLWPHASEOFSTUDIES[J2.13.r.3] PMDA E2B(R2) MHLWPHASEOFSTUDIES[J.12.i.2]
V$LM_ETHNIC_GROUP	eVAERS PATIENTETHNICITYGROUP[FDA.D.12] NMPA E2B(R3) PATIENTMINORITY[D.CN.1] eMDR PATIENTETHNICITYGROUP[A5.a]
V$LM_ETHNICITY/ V$LM_ETHNICITY_DLP	NMPA E2B(R3) PATIENTRACE[D.CN.2]
V$LM_MEDIA_TYPE/ V$LM_MEDIA_TYPE_DLP	All E2B(R3) Profiles - ICH, EMA, PMDA, MFDS, NMPA, and eVAERS INCLUDEDOCUMENT[C.1.6.1.r.2] LITINCLUDEDOCUMENT[C.4.r.2] PMDA Device MEDIATYPE
V$LM_MILITARY_STATUS	eVAERS PATMILSTATUS [FDA.D.14]
V$LM_REPORTER_TYPE	MFDS E2B(R3) QUALIFICATIONR3[C.2.r.4]
V$LM_RISK_CATEGORY_OTC	PMDA(R3) MHLWRISKCATEGORYOFOTCDRUGS [J2.5.k] PMDA(R2) MHLWRISKCATEGORYOFOTCDRUGS [J2.5.k]
V$LM_ROUTE_ACQUIRE_OTC	PMDA(R3) MHLWROUTEFORACQUIRINGOTCDRUGS[J2.6.k]
V$LM_SPECIALIZED_PROD_CATEGORY	eVAERS SPPRODCATEGORY [FDA.G.k.10.1]
V$LM_RPT_CATEGORY/ V$LM_RPT_CATEGORY_DLP	PMDA(R3) MHLWADMICSRCASENUMCLASSR3 [J2.1a] PMDA(R2) MHLWADMICSRCASENUMCLASS[J.4a]