3.3.3 Configuring the New Priority

To configure the priority and color code for the alerts, follow the below steps:

1. Access the Atomic Schema and access the FCC_ZCS_ALERT_PRIORITY_DIM table.
2. Change the following parameter value:
   • N_ALERT_PRIORITY_ID
   • V_ALERT_PRIORITY_CODE
   • V_ALERT_PRIORITY_NAME
   • V_ALERT_PRIORITY_DSPLY_COLR

   Figure 3-5 FCC_ZCS_Alert Priority_DIM_table

   
   

   

   
   

   MERGE INTO FCC_ZCS_ALERT_PRIORITY_DIM T USING (
   SELECT '4' N_ALERT_PRIORITY_ID, 'B' V_ALERT_PRIORITY_CODE, 'Lower
   Medium' V_ALERT_PRIORITY_NAME, '#25C0D6' V_ALERT_PRIORITY_DSPLY_COLR
   FROM DUAL) S
   ON ( T.N_ALERT_PRIORITY_ID = S.N_ALERT_PRIORITY_ID )
   WHEN MATCHED THEN UPDATE SET T.V_ALERT_PRIORITY_CODE =
   S.V_ALERT_PRIORITY_CODE, T.V_ALERT_PRIORITY_NAME =
   S.V_ALERT_PRIORITY_NAME, T.V_ALERT_PRIORITY_DSPLY_COLR =
   S.V_ALERT_PRIORITY_DSPLY_COLR
   WHEN NOT MATCHED THEN INSERT
   (N_ALERT_PRIORITY_ID,V_ALERT_PRIORITY_CODE,V_ALERT_PRIORITY_NAME,V_ALERT
   _PRIORITY_DSPLY_COLR)
   VALUES
   (S.N_ALERT_PRIORITY_ID,S.V_ALERT_PRIORITY_CODE,S.V_ALERT_PRIORITY_NAME,S
   .V_ALERT_PRIORITY_DSPLY_COLR)
   /

3. Access the FCC_ZCS_ALERT_PRIORITY_TL table.
4. Change the following parameter value:
   • V_ALERT_PRIORITY_CODE
   • V_ALERT_PRIORITY_NAME
   • V_LOCALE

     Note:

     The FCC_ZCS_ALERT_PRIORITY_DIM table and FCC_ZCS_ALERT_PRIORITY_TL table must have the same parameter value entry.

   Figure 3-6 FCC_ZCS_Alert_Priority_TL

   
   

   

   
   

   MERGE INTO FCC_ZCS_ALERT_PRIORITY_TL T USING (
   SELECT 'B' V_ALERT_PRIORITY_CODE, 'Lower Medium' V_ALERT_PRIORITY_NAME,
   'en_US' V_LOCALE FROM DUAL) S
   ON ( )
   WHEN MATCHED THEN UPDATE SET T.V_ALERT_PRIORITY_CODE =
   S.V_ALERT_PRIORITY_CODE, T.V_ALERT_PRIORITY_NAME =
   S.V_ALERT_PRIORITY_NAME, T.V_LOCALE = S.V_LOCALE
   WHEN NOT MATCHED THEN INSERT
   (V_ALERT_PRIORITY_CODE,V_ALERT_PRIORITY_NAME,V_LOCALE)
   VALUES
   (S.V_ALERT_PRIORITY_CODE,S.V_ALERT_PRIORITY_NAME,S.V_LOCALE)
   /

The priority for the new alerts are decided based on the score configured for the priority.

To define the priority and color code for the new alerts created based on the score, follow the below steps:

1. Access the Atomic Schema and access the FCC_ZCS_ALERT_PRIORITY_CONF table.
2. Change the following parameter value:
   • N_ALERT_PRIORITY_SEQ
   • V_ALERT_PRIORITY_CODE
   • N_ALERT_PRIORITY_MIN_SCORE
   • N_ALERT_PRIORITY_MAX_SCORE
   • V_ALERT_TYPE_CODE

Figure 3-7 FCC_ZCS_Alert_Priority_Conf_table

MERGE INTO FCC_ZCS_ALERT_PRIORITY_CONF T USING (
SELECT '37' N_ALERT_PRIORITY_SEQ, 'B' V_ALERT_PRIORITY_CODE, '81'
N_ALERT_PRIORITY_MIN_SCORE, '85' N_ALERT_PRIORITY_MAX_SCORE, 'CS_RT_SAN'
V_ALERT_TYPE_CODE, 'AMEA' V_JRSDCN_CD, 'a' V_BUS_DMN_LIST_TX FROM DUAL)
S
ON ( T.N_ALERT_PRIORITY_SEQ = S.N_ALERT_PRIORITY_SEQ )
WHEN MATCHED THEN UPDATE SET T.V_ALERT_PRIORITY_CODE =
S.V_ALERT_PRIORITY_CODE, T.N_ALERT_PRIORITY_MIN_SCORE =
S.N_ALERT_PRIORITY_MIN_SCORE, T.N_ALERT_PRIORITY_MAX_SCORE =
S.N_ALERT_PRIORITY_MAX_SCORE, T.V_ALERT_TYPE_CODE = S.V_ALERT_TYPE_CODE,
T.V_JRSDCN_CD = S.V_JRSDCN_CD, T.V_BUS_DMN_LIST_TX = S.V_BUS_DMN_LIST_TX
WHEN NOT MATCHED THEN INSERT
(N_ALERT_PRIORITY_SEQ,V_ALERT_PRIORITY_CODE,N_ALERT_PRIORITY_MIN_SCORE,N
_ALERT_PRIORITY_MAX_SCORE,V_ALERT_TYPE_CODE,V_JRSDCN_CD,V_BUS_DMN_LIST_T
X)
VALUES
(S.N_ALERT_PRIORITY_SEQ,S.V_ALERT_PRIORITY_CODE,S.N_ALERT_PRIORITY_MIN_S
CORE,S.N_ALERT_PRIORITY_MAX_SCORE,S.V_ALERT_TYPE_CODE,S.V_JRSDCN_CD,S.V_
BUS_DMN_LIST_TX)
/