Data load for alert summation keyfigure

• SFG Related data - need extra work

Analysis :

As part of March Release , We have added new columns  “MAETASUM, PLTETDSUM, WHIN and WHOUT”  in the below tables for IO requirement in Dev server.

Tables :

1. WEB.SR
2. WEB.[SR_ALERT]
3. WEB.[SR_ALERT_APIDP]
4. WEB.[SR_ALERT_History]
5. WEB.[SR_ALERT_APIDP_History]
6. WEB.[SR_ALERT_Delete_History]
7. WEB.[SR_ALERT_APIDP_Delete_History]
8. WEB.[SR_ALERT_LE]

Also, Below sps are modified on DEV server to populate data in these new column.

Finished Goods SP’s:

1. [dbo].[SP05_002_E2E_SR_LoadAlert_Horizon_Weekly]
2. [dbo].[SP05_024_E2E_SR_Update_SR_Alert_Horizon]
3. [dbo].[SP05_403_E2E_SubVersion_PIR_Load_SR_ALERT]

Semifinished Goods SP’s: (On below changes coordinating with Andrzej)

1. [dbo].[SP05_102_E2E_APIDP_LoadAlert_Horizon_Weekly]
2. [dbo].[SP05_124_E2E_APIDP_Update_SR_Alert_Horizon]

5)ADDED HORIZON worked on SSVV .

6)ADDED HORIZON WORKED ON SSHV

7)completed development and testing

8)deployed changes in dev and stage pushed code in giT