HI All, We have one requirement with following details :-   Bank requires to develop a custom scenario such that Customers who have monthly transactions on their accounts that exceeds 50000 JOD , with minimum transaction 5 transactions and transaction amount 10000 JOD per single transaction should generate an alert.   Customers who have monthly transactions on their accounts that exceeds 50000 JOD , with minimum transaction 5 transactions and transaction amount 10000 JOD per single transaction should generate an alert. Frequency: Monthly Proposed Scenario Parameters: Account_types(p10236_account_type_desc) - should specify all the account types to be monitored Total_credit_amount (p10236_trans_total) – Total amount of credit transaction Minimum_credit_transaction_count (p10236_day_count) – Minimum number of credit transactions Minimum_transaction_amount (p10236_day_count) – Minimum transaction amount Num_business_days (p10236_num_days) - Number of business days to be considered Status_description (p10236_status_desc) -Specifies whether transaction status SUCCESS or not Currency account indicator (&p10236_currency_acct) --- It will be N Credit or debit indicator (p10236_cdi_indicator) : - Credit (C) and debit (D)   I have created the source file also with help of other sceanrio active code as below :- %let this_macro_name = &sysmacroname; /* save this macro name */ /*----------------------------------------------------------------------------*/ retain p10236_begin_date; format p10236_day_list $512.; /* This init section should be placed before any goto statements. This section of code will only be run when processing the first BY group of the prep data set. Any goto statements placed before it may prevent the init code from being run. */ if run_scenario_init eq 1 then do; p10236_begin_date = input(put(rundate_number-&p10236_num_days+1,num_to_date.),8.); end; /* Skip parties that do not have transactions on the current day */ if date_key{n} < rundate then goto &sysmacroname.; p10236_day_list = ' '; p10236_day_count = 0; p10236_total_amount = 0; do i = n to 1 by -1 until(date_key{i} < p10236_begin_date); if p10236_begin_date <= date_key{i} <= rundate then do; if upcase(account_type_desc{i}) in (&p10236_account_type_desc) and upcase(currency_based_account_ind{i}) in (&p10236_currency_acct) and upcase(transaction_cdi_code{i}) in (&p10236_cdi_indicator) and upcase(status_desc{i}) in (&p10236_status_desc) then do; if currency_amount{i} le &p10236_trans_limit then goto &sysmacroname.; %save_transaction_key (calling_macro=&this_macro_name); p10236_total_amount = sum(p10236_total_amount,currency_amount{i}); repeat = indexw(p10236_day_list,strip(put(date_key{i},8.))); if repeat eq 0 and not missing(date_key{i}) then do; p10236_day_list = catx(' ',p10236_day_list,put(date_key{i},8.)); p10236_day_count + 1; end; end; end; end; /* Compare party values to parameters for a match */ if p10236_day_count ge &p10236_day_count and p10236_total_amount ge &p10236_trans_total then do; actual_values_text = tranwrd(&r10236_threshold_message,'#1',strip(put(p10236_total_amount,nlnum32.)) ); actual_values_text = tranwrd(actual_values_text,'#2',strip(put(p10236_day_count,nlnum32.)) ); actual_values_text = tranwrd(actual_values_text,'#$', "&currency_code" ); output &alert_fname; end; /* EXIT */ &sysmacroname.: ; /* ========================================================================== */ /* END SCENARIO - SAS10236 */ /* ========================================================================== */     I have set the parameter accordingly but Can some body tell what will happen to in below statement :- if currency_amount{i} le &p10236_trans_limit then goto &sysmacroname.;   Can some body help me in this case ? Whether this logic is correct or not ? What will happen in the above statement ? How to debug the this custom scenario ? is there any way to cross check why alerts are not generating ?   @manishiiita @Patrick I request you help on the review the code and guide me changes 🙂 .   ... View more

Hi All,   I have one challenge for while developing the new custom scenario , if any one has implemented this solution ,Please let me know how to proceed.   Requirement is as below :-  Create new Scenario to monitor employee, their spouse and children accounts, and generate alerts when cumulative credit transactions on their accounts exceeds a threshold which is (gross monthly salary of family * 2). Gross income need to be calculated irrespective of the employment with Bank.(Income details are available with Core)  This scenario will have to be executed on a daily basis, and alert need to be generated whenever a transaction makes the cumulative credit amount more than. Total family income *2  Alert should be generated for the Employee Who has been setup as “Reference employee”. This scenario should consider credit transactions of last 30 days or the transactions after the last alert on the customer (Reference employee), whichever is latest.  Transactions to be excluded from monitoring are Medical expenses, Salary, Incentives, Travel expenses, ATM Withdraw and Visa Electron purchases. Accounts to be excluded from monitoring are the accounts of Chairman, board members, Secretary of board of directors, Chief executive officer. We have decided and agreed to make changes in Fsc_Party_Dim table as follow :-   EMPLOYEE_IND, EMPLOYEE_NUMBER and ANNUAL_INCOME_AMOUNT and RELATED_EMPLOYEE_NUMBER fields in FSC_PARTY_DIM table to be populated correctly from Core banking . We will create the scenario which monitor the  transaction makes the cumulative credit amount more than Total family income *2 and will generate the alert for getting matches . In while children we have to exclude the above 18 years child or dependent.But I am not able to create the new custom scenario and not the approach also  If anyone has the idea about how to proceed , @Patrick @manishiiita  @AMSASPlease help me .Many Thanks in advance . I need help on the following points :-  Which is header i need to select while creating the Custom Scenario ? Do i need to change any existing header or I need to create the new header as I am changing the FSC_PARTY_DIM table ? How can i exclude the above 18 years accounts while creating the custom scenario? Is there any existing scenario which satisfy above requirement ? or I can modify any existing scenario for the same ? ... View more