The following items need to be changed/updated to support the Latin America (LA) data within STAR Core.

DEPENDENCIES:

• market_region / market ref table (Has been created)
• LA data transformation within PRINCE to match current data structure for tables such as
  • PRODUCTION_CONSOLIDATED
    • Data for a SCOPE is loaded with the following stored procedure - dbo.PRC_LOAD_SCOP_SRC_DTA_FRM_PPIW.sql
      • STAR.Designer.cs - here is the EDM schema and component model
• Name of additional fields in V_SCOP

PLAN OF ACTION

• Run through the code and identify any blockers/points of concern (PRE-COMPILE)
• Run / Update the current iteration of the codebase on the local STAR extract
  • To be completed and will need to be completed and run locally to identify other areas where these changes must be made.
• Update WCF update requirements
  • Star.StarDataAccessLayer - the following will need to be updated for all the following points.
    • SCOP_BuildDataTable() -
    • GetFreshScopeData() - 7094
    • SaveScopeData() - ln 7955
  • STAR_L4_PROD_MiddleTier/STAR.ScopingEngine in the function GetFreshScopeData around line 7094
• Update STAR.ScopingEngine - the following engine creates the SQL that pulls the query out of the db
  • Add a column for market_region and market in STAR.ScopingEngine.ScopingEngine.cs and the following
    • Update with new columns
      • BuildTable() - 96
      • CleanScopeTable() - 147
      • UpdateFilterTable() - 253
      • UpdatePipeColumns() - 412
• Update stored procedures with new fields
  • Add and update fields in the following procedures
    • dbo.PRC_CPY_SCOP.sql - 159
    • dbo.PRC_CLN_MRG_SCOP.sql - 47
    • dbo**.PRC_CRT_ACC_EXTRT_VW_FOR_USR.**sql - 44 (multiple locations)
    • dbo**.PRC_MAINT_SCOP_DTA.sql** - 89
    • dbo.PRC_MRG_SCOP.sql - 130
  • Update the following information
    • dbo.PRC_LOAD_SCOP_SRC_DTA_FRM_PPIW.sql
• Understand the exception reporting and ensure there aren’t any dependencies with the project.
• Update GUI with criteria fields (market_region, market)
  • STAR.ClientUI.ccCriteriaWizard.cs is where the UI builds the criteria wizard
  • STAR.ClientUI.ccCriteriaItem.cs - the addition of every criterion is added in cbeFieldName (currently holds ART, ASP, BRD, TRN_LN, etc), which is loaded into scopeDataPDC in STAR_L4_PROD_MiddleTier/STAR.ScopingEngine in the function GetFreshScopeData around line 7094

Basically, in storyboards the following would be done:

1. The user opens the app and finds themself on the main SCOPE screen when creating a new scope

1. Opens the Criteria