Details
-
Story
-
Resolution: Completed
-
Medium
-
None
-
None
-
GxP
-
CM Sprint 125
-
Yes
Description
Problem Statement
In current PCM tracker, many standard attributes are utilized and displayed as per their text value coming from the hiearchy tables.
Each of those entries usually comes aas a combination of KEY : DESCRIPTION, where the key always remains the same, but the description can be amended over time.
Purpose of this change is to make sure we bring both Key and Description for thos attributes and that the description are alwyas reflective of the last description in the hiearchy
For the country hierarchy, we will need to bring:
- country (desc present, missing key)
- market (desc present, missing key)
- sub region (both key and desc missing)
- region (desc present, missing key)
UDH table to refer to is PGSUDH_DL_PROD.PGSUDH_CDM.GLOBAL_COUNTRY_HIERARCHY
Acceptance Criteria
- Key and description are treated as separate fields
- Key fields are loaded in main tracker but hidden by default
- Desc fields are loaded in the main tracker and shown by default
- All those fields are reported appropriately in both Excel reports and Tableau databases
- the check for lastest description is performed as part of daily MD run to always reflect the latest description. it applies to all records in the repository, even the past due ones
- A data check is performed on all PCM records to make sure that for a single key, there is only one single value displayed
qTest: Test Execution
Attachments
Issue Links
- has to be done after
-
OS-15027 Requirement Gathering :OS-14772 - Country codes, region codes, cluster codes, and market codes | PCM Addition in Event tracker
- Closed
-
OS-15028 Analysis :OS-14772 - Country codes, region codes, cluster codes, and market codes | PCM Addition in Event tracker
- Closed
- relates to
-
OS-15029 Development & Unit testing :OS-14772 - Country codes, region codes, cluster codes, and market codes | PCM Addition in Event tracker
- Done
-
OS-15030 Test Case Preperation :OS-14772 - Country codes, region codes, cluster codes, and market codes | PCM Addition in Event tracker
- Done
-
OS-15031 Peer Code review :OS-14772 - Country codes, region codes, cluster codes, and market codes | PCM Addition in Event tracker
- Done
-
OS-15032 Testing :OS-14772 - Country codes, region codes, cluster codes, and market codes | PCM Addition in Event tracker
- Done
-
OS-15033 Test Script review :OS-14772 - Country codes, region codes, cluster codes, and market codes | PCM Addition in Event tracker
- Done
-
OS-16305 CM-Dev-Fields and field names are not exported appropriately in Excel reports
- Done
-
OS-16306 CM-Dev-Sub region field is not displayed by default in main tracker of PCM event tracker
- Done
- links to
-
TC-2884 001_Navigation_PCM Event Tracker
-
TC-2885 002_PCM Event Tracker_Main Grid_Columns
-
TC-2886 003_PCM Event Tracker_Excel Reports