NOTE: Log file opened at Tue, 28 May 2024 06:43:12.440 1 The SAS System Tuesday, May 28, 2024 06:43:00 AM NOTE: Copyright (c) 2016 by SAS Institute Inc., Cary, NC, USA. NOTE: SAS (r) Proprietary Software V.03.05 (TS5M0 MBCS3170) Licensed to SIAM COMMERCIAL BANK - SUPP.31, Site 70301459. NOTE: This session is executing on the Linux 4.18.0-513.9.1.el8_9.x86_64 (LIN X64) platform. NOTE: Additional host information: Linux LIN X64 4.18.0-513.9.1.el8_9.x86_64 #1 SMP Thu Nov 16 10:29:04 EST 2023 x86_64 Red Hat Enterprise Linux release 8.9 (Ootpa) NOTE: SAS initialization used: real time 0.01 seconds cpu time 0.01 seconds 1 /* --------------------------------------------------------------------------------------------------------------------- 1 ! */ 2 /* Batch : /opt/sas/sasconfig/99_batch/05_agp/GROUP_09_02_AGP_PREP01.sas */ 3 /* --------------------------------------------------------------------------------------------------------------------- 3 ! */ 4 /* ---------------- */ 5 /* Pre-Process */ 6 /* ---------------- */ 7 8 /*Get SAS VIYA TOKEN from SAS Logon*/ 9 %let sas_viya_token = %sysget(SAS_VIYA_TOKEN); 10 %let token = %sysget(SAS_VIYA_TOKEN); 11 %let access_token = %sysget(SAS_VIYA_TOKEN); 12 %let viyaurl=%sysfunc(getoption(servicesbaseurl)); 13 %let servicesbaseurl=%sysfunc(getoption(servicesbaseurl)); 14 15 /*include aml_autoexec*/ 16 %include '/opt/sas/spre/home/SASFoundation/ucmacros/amlcoresrv/x_batch_preprocess.sas'; 67 %x_batch_preprocess(autoexec_nm='aml_autoexec'); WARNING: The argument to macro function %SYSGET is not defined as a system variable. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds HTTPCALL='https://amltmvmss1prd.scbcorp.onmicrosoft.com:443/identities/users/sas/memberships?depth=-1' IS_BATCH_USER='Y' NOTE: The quoted string currently being processed has become more than 262 bytes long. You might have unbalanced quotation marks. NOTE: PROCEDURE HTTP used (Total process time): real time 0.50 seconds cpu time 0.02 seconds NOTE: 404 Not Found NOTE: JSON data is only read once. To read the JSON again, reassign the JSON LIBNAME. NOTE: Map file /opt/sas/amltmprd/config/var/tmp/compsrv/default/SAS_workAFBE000C8DD6_amltmvspre1prd/employee.map was created. NOTE: Libref INJS was successfully assigned as follows: Engine: JSON Physical Name: /opt/sas/amltmprd/config/var/tmp/compsrv/default/SAS_workAFBE000C8DD6_amltmvspre1prd/#LN00014 NOTE: Copying INJS.ALLDATA to WORK.ALLDATA (memtype=DATA). 2 The SAS System Tuesday, May 28, 2024 06:43:00 AM NOTE: BUFSIZE is not cloned when copying across different engines. System Option for BUFSIZE was used. NOTE: There were 8 observations read from the data set INJS.ALLDATA. NOTE: The data set WORK.ALLDATA has 8 observations and 5 variables. NOTE: Copying INJS.DETAILS to WORK.DETAILS (memtype=DATA). NOTE: BUFSIZE is not cloned when copying across different engines. System Option for BUFSIZE was used. NOTE: There were 1 observations read from the data set INJS.DETAILS. NOTE: The data set WORK.DETAILS has 1 observations and 4 variables. NOTE: Copying INJS.LINKS to WORK.LINKS (memtype=DATA). NOTE: BUFSIZE is not cloned when copying across different engines. System Option for BUFSIZE was used. NOTE: There were 1 observations read from the data set INJS.LINKS. NOTE: The data set WORK.LINKS has 1 observations and 2 variables. NOTE: Copying INJS.ROOT to WORK.ROOT (memtype=DATA). NOTE: BUFSIZE is not cloned when copying across different engines. System Option for BUFSIZE was used. NOTE: There were 1 observations read from the data set INJS.ROOT. NOTE: The data set WORK.ROOT has 1 observations and 5 variables. NOTE: PROCEDURE COPY used (Total process time): real time 0.01 seconds cpu time 0.02 seconds NOTE: There were 8 observations read from the data set WORK.ALLDATA. NOTE: The data set WORK.ALLDATA has 8 observations and 6 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: There were 8 observations read from the data set WORK.ALLDATA. NOTE: The data set WORK.ALL_ALLDATA has 8 observations and 6 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column). 30176:16 NOTE: Variable rel is uninitialized. NOTE: Variable uri is uninitialized. ordinal_root=1 ordinal_links=1 rel= syscall= uri=. _ERROR_=0 _N_=1 NOTE: There were 1 observations read from the data set WORK.LINKS. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column). 30176:55 NOTE: There were 8 observations read from the data set WORK.ALL_ALLDATA. NOTE: The data set WORK._NULL has 0 observations and 6 variables. 3 The SAS System Tuesday, May 28, 2024 06:43:00 AM NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.01 seconds FCF_EMPLOYEE_ACCESS=0 NOTE: Credential obtained from Viya credentials service. NOTE: Libref LND was successfully assigned as follows: Engine: SQLSVR Physical Name: amltmdb_lnd NOTE: Credential obtained from Viya credentials service. NOTE: Libref PSTLND was successfully assigned as follows: Engine: SQLSVR Physical Name: amltmdb_lnd NOTE: Credential obtained from Viya credentials service. NOTE: Libref REJ was successfully assigned as follows: Engine: SQLSVR Physical Name: amltmdb_lnd NOTE: Credential obtained from Viya credentials service. NOTE: Libref STG was successfully assigned as follows: Engine: SQLSVR Physical Name: amltmdb_stg NOTE: Credential obtained from Viya credentials service. NOTE: Libref CORE was successfully assigned as follows: Engine: SQLSVR Physical Name: amltmdb NOTE: Credential obtained from Viya credentials service. NOTE: Libref AMLWL was successfully assigned as follows: Engine: SQLSVR Physical Name: amltmdb NOTE: Credential obtained from Viya credentials service. NOTE: Libref AMLKC was successfully assigned as follows: Engine: SQLSVR Physical Name: amltmdb NOTE: Credential obtained from Viya credentials service. NOTE: Libref KC was successfully assigned as follows: Engine: SQLSVR Physical Name: amltmdb NOTE: Credential obtained from Viya credentials service. NOTE: Libref COREVW was successfully assigned as follows: Engine: SQLSVR Physical Name: amltmdb NOTE: PROCEDURE SQL used (Total process time): real time 0.14 seconds cpu time 0.07 seconds LOAD_DT=17MAY2024 YYYYMMDD_LOAD_DT=20240517 ASOF=20240517 V_AS_OF_DATE=2024-05-17 ASOF_DT=2024-05-17 LOAD_START_DTTM= 17MAY2024:00:00:00 LOAD_END_DTTM= 17MAY2024:23:59:59 NOTE: Extraneous text on %RETURN statement ignored. NOTE: Extraneous text on %RETURN statement ignored. NOTE: Extraneous text on %RETURN statement ignored. NOTE: Extraneous text on %RETURN statement ignored. 4 The SAS System Tuesday, May 28, 2024 06:43:00 AM NOTE: Extraneous text on %RETURN statement ignored. NOTE: Extraneous text on %RETURN statement ignored. NOTE: Extraneous text on %RETURN statement ignored. NOTE: Extraneous text on %RETURN statement ignored. NOTE: Extraneous text on %RETURN statement ignored. NOTE: Extraneous text on %RETURN statement ignored. NOTE: Extraneous text on %RETURN statement ignored. NOTE: Extraneous text on %RETURN statement ignored. NOTE: Extraneous text on %RETURN statement ignored. NOTE: Extraneous text on %RETURN statement ignored. NOTE: Extraneous text on %RETURN statement ignored. NOTE: Extraneous text on %RETURN statement ignored. NOTE: Extraneous text on %RETURN statement ignored. NOTE: Extraneous text on %RETURN statement ignored. NOTE: Extraneous text on %RETURN statement ignored. NOTE: Extraneous text on %RETURN statement ignored. NOTE: Extraneous text on %RETURN statement ignored. NOTE: Extraneous text on %RETURN statement ignored. NOTE: Extraneous text on %RETURN statement ignored. NOTE: Extraneous text on %RETURN statement ignored. NOTE: Extraneous text on %RETURN statement ignored. NOTE: Extraneous text on %RETURN statement ignored. NOTE: Extraneous text on %RETURN statement ignored. NOTE: Extraneous text on %RETURN statement ignored. NOTE: Extraneous text on %RETURN statement ignored. NOTE: Extraneous text on %RETURN statement ignored. NOTE: Extraneous text on %RETURN statement ignored. NOTE: Extraneous text on %RETURN statement ignored. NOTE: Extraneous text on %RETURN statement ignored. NOTE: Extraneous text on %RETURN statement ignored. The definitions in the ENUSA locale are as follows: /*------------------------------------------------------------------*/ /* CASE DEFINITION(S) */ /* */ /* Case definitions are used by the following: */ /* dqCase function */ /*------------------------------------------------------------------*/ Lower Proper Proper (Address Number) Proper (Business Title) Proper (City - State/Province - Postal Code) Proper (Given Name) Proper (Name) Proper (Organization) Proper (Site) Upper Upper (Legal Form) /*------------------------------------------------------------------*/ /* EXTRACTION DEFINITION(S) */ /* */ /* Extraction definitions are used by the following: */ /* dqExtract function */ /* dqExtInfoGet function */ /* dqExtTokenGet function */ /* dqExtTokenPut function */ /*------------------------------------------------------------------*/ Brand/Manufacturer Token: Brand/Manufacturer Token: Additional Info Contact Info Token: NAME Token: ORGANIZATION Token: ADDRESS Token: E-MAIL Token: PHONE Token: ADDITIONAL INFO Product Attributes Token: Colors Token: Materials Token: Dimensions Token: Package/UOM Token: Part Numbers Token: Additional Info /*------------------------------------------------------------------*/ /* GENDER DEFINITION(S) */ /* */ /* Gender definitions are used by the following: */ /* dqGender function */ /* dqGenderParsed function */ /*------------------------------------------------------------------*/ Name The associated parse definition is "Name". /*------------------------------------------------------------------*/ /* GUESS DEFINITION(S) */ /* */ /* Guess definitions are used by the following: */ /* dqLocaleGuess function */ /*------------------------------------------------------------------*/ Country Phone /*------------------------------------------------------------------*/ /* IDENTIFICATION DEFINITION(S) */ /* */ /* Identification definitions are used by the following: */ /* dqIdentify function */ /*------------------------------------------------------------------*/ Date (DMY Validation - Numeric Only) Date (MDY Validation - Numeric Only) Date (YMD Validation - Numeric Only) E-mail (Country Identification) E-mail (Validation) Field Content Field Content (Global) Field Name Offensive Phone (Validation) /*------------------------------------------------------------------*/ /* MATCH DEFINITION(S) */ /* */ /* Match definitions are used by the following: */ /* dqMatch function */ /* dqMatchParsed function */ /* dqMatchInfoGet function */ /* DQMATCH procedure, CRITERIA statement */ /* DQSCHEME procedure, CREATE statement */ /*------------------------------------------------------------------*/ Account Number Address Address (PO Box Only) Address (Street Only) Business Title The associated parse definition is "Business Title". City City - State/Province - Postal Code The associated parse definition is "City - State/Province - Postal Code". Country Date (DMY) The associated parse definition is "Date (DMY)". Date (DMY) (with Combinations) The associated parse definition is "Date (DMY)". Date (MDY) The associated parse definition is "Date (MDY)". Date (MDY) (with Combinations) The associated parse definition is "Date (MDY)". Date (YMD) The associated parse definition is "Date (YMD)". Date/Time (DMY) The associated parse definition is "Date/Time (DMY)". Date/Time (MDY) The associated parse definition is "Date/Time (MDY)". Date/Time (YMD) The associated parse definition is "Date/Time (YMD)". E-mail The associated parse definition is "E-mail". E-mail (with Combinations) Field Name Name The associated parse definition is "Name". Name (with Combinations) Name (with Suggestions) The associated parse definition is "Name". Organization Phone Postal Code The associated parse definition is "Postal Code". State/Province Text Text (Long) /*------------------------------------------------------------------*/ /* PARSE DEFINITION(S) */ /* */ /* Parse definitions are used by the following: */ /* dqParse function */ /* dqParseInfoGet function */ /* dqParseTokenGet function */ /* dqParseTokenPut function */ /* dqToken function */ /*------------------------------------------------------------------*/ Address Token: Recipient Token: Building/Site Token: Street Token: Extension Token: PO Box Token: Additional Info Address (Detailed) Token: Recipient Token: Building/Site Token: Street Number Token: Predirectional Token: Street Name Token: Street Type Token: Postdirectional Token: Extension Token: PO Box Token: Additional Info Address (Full) Token: Recipient Token: Building/Site Token: Street Token: Extension Token: PO Box Token: City Token: State/Province Token: Postal Code Token: Country Token: Additional Info Address (Global) Token: Recipient Token: Building/Site Token: Street Token: Extension Token: PO Box Token: Additional Info Business Title Token: Position Token: Level Token: Location Token: Department Token: Grade City - State/Province - Postal Code Token: City Token: State Token: ZIP City - State/Province - Postal Code (Global) Token: City Token: State/Province Token: Postal Code Token: Additional Info Date (DMY) Token: Day Token: Month Token: Year Date (MDY) Token: Day Token: Month Token: Year Date (YMD) Token: Day Token: Month Token: Year Date/Time (DMY) Token: Year Token: Month Token: Day Token: Weekday Token: Hours Token: Minutes Token: Seconds Token: Time Extension Date/Time (MDY) Token: Year Token: Month Token: Day Token: Weekday Token: Hours Token: Minutes Token: Seconds Token: Time Extension Date/Time (YMD) Token: Year Token: Month Token: Day Token: Weekday Token: Hours Token: Minutes Token: Seconds Token: Time Extension Dimensions Token: Length Token: Width Token: Height Token: Inside Diameter Token: Outside Diameter Token: Size Token: Other E-mail Token: Mailbox Token: Sub-Domain Token: Top-Level Domain Token: Additional Info IBAN Token: Country Code Token: Basic Bank Account Number Token: Key IBAN (Detailed) Token: Country Code Token: Control Key Token: Basic Bank Account Number Token: Bank Code Token: Sort Code Token: Account Number Token: Key Name Token: Prefix Token: Given Name Token: Middle Name Token: Family Name Token: Suffix Token: Title/Additional Info Name (Address Update) Token: Prefix Token: Given Name Token: Middle Name Token: Family Name Token: Suffix Token: Title/Additional Info Name (Global) Token: Prefix Token: Given Name Token: Middle Name Token: Family Name Token: Suffix Token: Title/Additional Info Name (Multiple Name) Token: Name 1 Token: Name 2 Name/Organization Token: Name Token: Organization Organization Token: Name Token: Legal Form Token: Site Token: Additional Info Organization (Global) Token: Name Token: Legal Form Token: Site Token: Additional Info Organization (Multiple) Token: Organization 1 Token: Organization 2 Package/UOM Token: Quantity Token: Package Token: Units Token: UOM Token: Additional Info Phone Token: Country Code Token: Area Code Token: Base Number Token: Extension Token: Line Type Token: Additional Info Phone (Global) Token: Country Code Token: Area Code Token: Base Number Token: Extension Token: Line Type Token: Additional Info Postal Code Token: ZIP Token: ZIP Add-on Website Token: Scheme Token: Hostname Token: Project /*------------------------------------------------------------------*/ /* PATTERN DEFINITION(S) */ /* */ /* Pattern definitions are used by the following: */ /* dqPattern function */ /*------------------------------------------------------------------*/ Character Character (Script Identification) Word Word (Script Identification) /*------------------------------------------------------------------*/ /* STANDARDIZATION DEFINITION(S) */ /* */ /* Standardization definitions are used by the following: */ /* dqStandardize function */ /*------------------------------------------------------------------*/ ASCII Non-Printable Character Removal Address Anonymize E-mail Domain Brand to Manufacturer Business Title Business Title (No Parse) City City - State/Province - Postal Code Color Reduction Country Country (ISO 2 Char) Country (ISO 3 Char) Country (ISO Number) Country (Region) Country (Sub-Region) Date (DMY) Date (MDY) Date (YMD) Date/Time (DMY) Basic Date/Time (DMY) Extended Date/Time (MDY) Basic Date/Time (MDY) Extended Date/Time (YMD) Basic Date/Time (YMD) Extended Dimensions E-mail HTML Character Reference Conversion Hyphen/Dash Removal Hyphen/Dash Space Replacement IBAN (Electronic) IBAN (Printed) Mask Address Except Street Type Mask All Characters Mask All Characters Except First and Last Mask Digits Mask E-mail Domain Mask E-mail Mailbox Mask E-mail Mailbox Except First and Last Characters Mask E-mail Sub-Domain Mask Letters Mask Partial String Mask Phone Number Material Multiple Space Collapse Name Non-Alphanumeric Removal Non-Number Removal Number Removal Organization Package/UOM Part Number Phone Phone (Electronic) Phone (with Country Code) Phone Country Code to Country Name Postal Code Punctuation Removal Punctuation Space Replacement Size Space Removal State/Province (Abbreviation) State/Province (Full Name) Surrounding Quote Removal Symbol Removal Symbol Space Replacement Truncate Word to Initial URL Website WARNING: The argument to macro function %SYSGET is not defined as a system variable. 5 The SAS System Tuesday, May 28, 2024 06:43:00 AM NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: Libref STG_WTCH was successfully assigned as follows: Engine: V9 Physical Name: /opt/sas/amltmprd/config/var/tmp/compsrv/default/SAS_workAFBE000C8DD6_amltmvspre1prd/stage NOTE: Credential obtained from Viya credentials service. NOTE: Libref WTCHLST was successfully assigned as follows: Engine: SQLSVR Physical Name: amltmdb NOTE: Credential obtained from Viya credentials service. NOTE: Libref AMLKC was successfully assigned as follows: Engine: SQLSVR Physical Name: amltmdb NOTE: Credential obtained from Viya credentials service. NOTE: Libref AMLPREP was successfully assigned as follows: Engine: SQLSVR Physical Name: amltmdb NOTE: Credential obtained from Viya credentials service. NOTE: Libref FDHDATA was successfully assigned as follows: Engine: POSTGRES Physical Name: amltmvviyad1prd.scbcorp.onmicrosoft.com NOTE: Credential obtained from Viya credentials service. NOTE: Libref FDHMDATA was successfully assigned as follows: Engine: POSTGRES Physical Name: amltmvviyad1prd.scbcorp.onmicrosoft.com SYMBOLGEN: Macro variable NO resolves to SYMBOLGEN: Macro variable NO resolves to MPRINT(X_BATCH_PREPROCESS): source2; SYMBOLGEN: Macro variable AUTOEXEC_NM resolves to 'aml_autoexec' MLOGIC(X_BATCH_PREPROCESS): %IF condition &autoexec_nm.='fcf_va_autoexec' is FALSE MLOGIC(X_BATCH_PREPROCESS): Ending execution. 34118 34119 /* -------- */ 34120 /* Group_09 */ 34121 /* -------- */ 34122 /* ------------------------------------------------ */ 34123 /* Seq 1 : JOB_AGP_X_FCF_TRANSACTION_PREP */ 34124 /* ------------------------------------------------ */ 34125 %x_fcf_asofdttm(action = GET, job_name='SOL'); MLOGIC(X_FCF_ASOFDTTM): Beginning execution. MLOGIC(X_FCF_ASOFDTTM): Parameter ACTION has value GET MLOGIC(X_FCF_ASOFDTTM): Parameter JOB_NAME has value 'SOL' MLOGIC(X_FCF_ASOFDTTM): %LET (variable name is JOB_NAME) SYMBOLGEN: Macro variable JOB_NAME resolves to 'SOL' MLOGIC(X_FCF_ASOFDTTM): %IF condition not %symexist(fcf_run_asofdttm) is TRUE MLOGIC(X_FCF_ASOFDTTM): %GLOBAL FCF_RUN_ASOFDTTM MLOGIC(X_FCF_ASOFDTTM): %IF condition not %symexist(runasofdate) is TRUE MLOGIC(X_FCF_ASOFDTTM): %GLOBAL RUNASOFDATE MLOGIC(X_FCF_ASOFDTTM): %IF condition not %symexist(runasofdatetime) is TRUE MLOGIC(X_FCF_ASOFDTTM): %GLOBAL RUNASOFDATETIME MLOGIC(X_FCF_ASOFDTTM): %IF condition not %symexist(start_run_asofdttm) is TRUE MLOGIC(X_FCF_ASOFDTTM): %GLOBAL START_RUN_ASOFDTTM MLOGIC(X_FCF_ASOFDTTM): %IF condition not %symexist(start_runasofdate) is TRUE MLOGIC(X_FCF_ASOFDTTM): %GLOBAL START_RUNASOFDATE 6 The SAS System Tuesday, May 28, 2024 06:43:00 AM MLOGIC(X_FCF_ASOFDTTM): %IF condition not %symexist(start_runasofdatetime) is TRUE MLOGIC(X_FCF_ASOFDTTM): %GLOBAL START_RUNASOFDATETIME MLOGIC(X_FCF_ASOFDTTM): %IF condition not %symexist(end_run_asofdttm) is TRUE MLOGIC(X_FCF_ASOFDTTM): %GLOBAL END_RUN_ASOFDTTM MLOGIC(X_FCF_ASOFDTTM): %IF condition not %symexist(end_runasofdate) is TRUE MLOGIC(X_FCF_ASOFDTTM): %GLOBAL END_RUNASOFDATE MLOGIC(X_FCF_ASOFDTTM): %IF condition not %symexist(end_runasofdatetime) is TRUE MLOGIC(X_FCF_ASOFDTTM): %GLOBAL END_RUNASOFDATETIME MLOGIC(X_FCF_ASOFDTTM): %IF condition not %symexist(fcf_last_asofdttm) is TRUE MLOGIC(X_FCF_ASOFDTTM): %GLOBAL FCF_LAST_ASOFDTTM MLOGIC(X_FCF_ASOFDTTM): %IF condition not %symexist(lastasofdate) is TRUE MLOGIC(X_FCF_ASOFDTTM): %GLOBAL LASTASOFDATE MLOGIC(X_FCF_ASOFDTTM): %IF condition not %symexist(lastasofdatetime) is TRUE MLOGIC(X_FCF_ASOFDTTM): %GLOBAL LASTASOFDATETIME MLOGIC(X_FCF_ASOFDTTM): %IF condition not %symexist(start_last_asofdttm) is TRUE MLOGIC(X_FCF_ASOFDTTM): %GLOBAL START_LAST_ASOFDTTM MLOGIC(X_FCF_ASOFDTTM): %IF condition not %symexist(start_lastasofdate) is TRUE MLOGIC(X_FCF_ASOFDTTM): %GLOBAL START_LASTASOFDATE MLOGIC(X_FCF_ASOFDTTM): %IF condition not %symexist(start_lastasofdatetime) is TRUE MLOGIC(X_FCF_ASOFDTTM): %GLOBAL START_LASTASOFDATETIME MLOGIC(X_FCF_ASOFDTTM): %IF condition not %symexist(end_last_asofdttm) is TRUE MLOGIC(X_FCF_ASOFDTTM): %GLOBAL END_LAST_ASOFDTTM MLOGIC(X_FCF_ASOFDTTM): %IF condition not %symexist(end_lastasofdate) is TRUE MLOGIC(X_FCF_ASOFDTTM): %GLOBAL END_LASTASOFDATE MLOGIC(X_FCF_ASOFDTTM): %IF condition not %symexist(end_lastasofdatetime) is TRUE MLOGIC(X_FCF_ASOFDTTM): %GLOBAL END_LASTASOFDATETIME MLOGIC(X_FCF_ASOFDTTM): %IF condition not %symexist(max_used_asofdttm) is TRUE MLOGIC(X_FCF_ASOFDTTM): %GLOBAL MAX_USED_ASOFDTTM MLOGIC(X_FCF_ASOFDTTM): %IF condition not %symexist(last_eom_dttm) is TRUE MLOGIC(X_FCF_ASOFDTTM): %GLOBAL LAST_EOM_DTTM MLOGIC(X_FCF_ASOFDTTM): %IF condition not %symexist(last_eom_date) is TRUE MLOGIC(X_FCF_ASOFDTTM): %GLOBAL LAST_EOM_DATE MLOGIC(X_FCF_ASOFDTTM): %LET (variable name is CURRENT_DTTM) MLOGIC(X_FCF_ASOFDTTM): %LET (variable name is CURRENT_DTTM) SYMBOLGEN: Macro variable CURRENT_DTTM resolves to 2032497795.12743 MLOGIC(X_FCF_ASOFDTTM): %LET (variable name is ORIG_OPTION_SQLMAPPUTTO) MLOGIC(X_FCF_ASOFDTTM): %PUT &=orig_option_sqlmapputto. SYMBOLGEN: Macro variable ORIG_OPTION_SQLMAPPUTTO resolves to NONE ORIG_OPTION_SQLMAPPUTTO=NONE SYMBOLGEN: Macro variable DBFLAVOR resolves to sqlsvr SYMBOLGEN: Macro variable ORIG_OPTION_SQLMAPPUTTO resolves to NONE MLOGIC(X_FCF_ASOFDTTM): %IF condition %upcase(&dbflavor.) eq SQLSVR and "&orig_option_sqlmapputto." ne "NONE" is FALSE SYMBOLGEN: Macro variable JOB_NAME resolves to 'SOL' MLOGIC(X_FCF_ASOFDTTM): %IF condition &job_name. = 'SOL' is TRUE MPRINT(X_FCF_ASOFDTTM): proc sql noprint; MPRINT(X_FCF_ASOFDTTM): select put(load_end_dttm,best.),put(datepart(load_date),yymmddn8.),load_date, put(load_start_dttm,best.),put(datepart(load_start_dttm),yymmddn8.),load_start_dttm, put(load_end_dttm,best.),put(datepart(load_end_dttm),yymmddn8.),load_end_dttm into :fcf_run_asofdttm,:runasofdate,:runasofdatetime, :start_run_asofdttm,:start_runasofdate,:start_runasofdatetime, :end_run_asofdttm,:end_runasofdate,:end_runasofdatetime from core.ctrl_load_control where load_date in ( select min(load_date) from core.ctrl_load_control where sol_load_flag = 'N' ); MPRINT(X_FCF_ASOFDTTM): quit; NOTE: PROCEDURE SQL used (Total process time): real time 0.22 seconds cpu time 0.11 seconds MPRINT(X_FCF_ASOFDTTM): proc sql noprint; MPRINT(X_FCF_ASOFDTTM): select put(load_end_dttm,best.),put(datepart(load_date),yymmddn8.),load_date, 7 The SAS System Tuesday, May 28, 2024 06:43:00 AM put(load_start_dttm,best.),put(datepart(load_start_dttm),yymmddn8.),load_start_dttm, put(load_end_dttm,best.),put(datepart(load_end_dttm),yymmddn8.),load_end_dttm, put(load_date,best.) into :fcf_last_asofdttm,:lastasofdate,:lastasofdatetime, :start_last_asofdttm,:start_lastasofdate,:start_lastasofdatetime, :end_last_asofdttm,:end_lastasofdate,:end_lastasofdatetime, :max_used_asofdttm from core.ctrl_load_control where load_date in ( select max(load_date) from core.ctrl_load_control where sol_load_flag = 'Y' ); MPRINT(X_FCF_ASOFDTTM): quit; NOTE: PROCEDURE SQL used (Total process time): real time 0.22 seconds cpu time 0.10 seconds MLOGIC(FCF_RCSET): Beginning execution. SYMBOLGEN: Macro variable SYSERR resolves to 0 MLOGIC(FCF_RCSET): Parameter ERROR has value 0 SYMBOLGEN: Macro variable ERROR resolves to 0 SYMBOLGEN: Macro variable TRANS_RC resolves to 0 MLOGIC(FCF_RCSET): %IF condition (&error gt &trans_rc) is FALSE SYMBOLGEN: Macro variable ERROR resolves to 0 SYMBOLGEN: Macro variable JOB_RC resolves to 0 MLOGIC(FCF_RCSET): %IF condition (&error gt &job_rc) is FALSE MLOGIC(FCF_RCSET): Ending execution. SYMBOLGEN: Macro variable TRANS_RC resolves to 0 SYMBOLGEN: Macro variable TRANS_RC resolves to 0 MLOGIC(X_FCF_ASOFDTTM): %IF condition &trans_rc. eq 3 or &trans_rc. ge 5 is FALSE SYMBOLGEN: Macro variable MAX_USED_ASOFDTTM resolves to 2031350400 MLOGIC(X_FCF_ASOFDTTM): %IF condition &max_used_asofdttm. = . is FALSE SYMBOLGEN: Macro variable ACTION resolves to GET MLOGIC(X_FCF_ASOFDTTM): %IF condition %upcase(&action)=GET is TRUE MLOGIC(X_FCF_ASOFDTTM): %LET (variable name is FCF_RUN_ASOFDTTM) SYMBOLGEN: Macro variable FCF_RUN_ASOFDTTM resolves to 2031523199 MLOGIC(X_FCF_ASOFDTTM): %LET (variable name is RUNASOFDATE) SYMBOLGEN: Macro variable RUNASOFDATE resolves to 20240516 MLOGIC(X_FCF_ASOFDTTM): %LET (variable name is RUNASOFDATETIME) SYMBOLGEN: Macro variable RUNASOFDATETIME resolves to 16MAY2024:00:00:00.000 MLOGIC(X_FCF_ASOFDTTM): %LET (variable name is START_RUN_ASOFDTTM) SYMBOLGEN: Macro variable START_RUN_ASOFDTTM resolves to 2031436800 MLOGIC(X_FCF_ASOFDTTM): %LET (variable name is START_RUNASOFDATE) SYMBOLGEN: Macro variable START_RUNASOFDATE resolves to 20240516 MLOGIC(X_FCF_ASOFDTTM): %LET (variable name is START_RUNASOFDATETIME) SYMBOLGEN: Macro variable START_RUNASOFDATETIME resolves to 16MAY2024:00:00:00.000 MLOGIC(X_FCF_ASOFDTTM): %LET (variable name is END_RUN_ASOFDTTM) SYMBOLGEN: Macro variable END_RUN_ASOFDTTM resolves to 2031523199 MLOGIC(X_FCF_ASOFDTTM): %LET (variable name is END_RUNASOFDATE) SYMBOLGEN: Macro variable END_RUNASOFDATE resolves to 20240516 MLOGIC(X_FCF_ASOFDTTM): %LET (variable name is END_RUNASOFDATETIME) SYMBOLGEN: Macro variable END_RUNASOFDATETIME resolves to 16MAY2024:23:59:59.000 MLOGIC(X_FCF_ASOFDTTM): %LET (variable name is FCF_LAST_ASOFDTTM) SYMBOLGEN: Macro variable FCF_LAST_ASOFDTTM resolves to 2031436799 MLOGIC(X_FCF_ASOFDTTM): %LET (variable name is LASTASOFDATE) SYMBOLGEN: Macro variable LASTASOFDATE resolves to 20240515 MLOGIC(X_FCF_ASOFDTTM): %LET (variable name is LASTASOFDATETIME) SYMBOLGEN: Macro variable LASTASOFDATETIME resolves to 15MAY2024:00:00:00.000 MLOGIC(X_FCF_ASOFDTTM): %LET (variable name is START_LAST_ASOFDTTM) SYMBOLGEN: Macro variable START_LAST_ASOFDTTM resolves to 2031350400 MLOGIC(X_FCF_ASOFDTTM): %LET (variable name is START_LASTASOFDATE) SYMBOLGEN: Macro variable START_LASTASOFDATE resolves to 20240515 MLOGIC(X_FCF_ASOFDTTM): %LET (variable name is START_LASTASOFDATETIME) SYMBOLGEN: Macro variable START_LASTASOFDATETIME resolves to 15MAY2024:00:00:00.000 8 The SAS System Tuesday, May 28, 2024 06:43:00 AM MLOGIC(X_FCF_ASOFDTTM): %LET (variable name is END_LAST_ASOFDTTM) SYMBOLGEN: Macro variable END_LAST_ASOFDTTM resolves to 2031436799 MLOGIC(X_FCF_ASOFDTTM): %LET (variable name is END_LASTASOFDATE) SYMBOLGEN: Macro variable END_LASTASOFDATE resolves to 20240515 MLOGIC(X_FCF_ASOFDTTM): %LET (variable name is END_LASTASOFDATETIME) SYMBOLGEN: Macro variable END_LASTASOFDATETIME resolves to 15MAY2024:23:59:59.000 MLOGIC(X_FCF_ASOFDTTM): %LET (variable name is MAX_USED_ASOFDTTM) SYMBOLGEN: Macro variable MAX_USED_ASOFDTTM resolves to 2031350400 MLOGIC(X_FCF_ASOFDTTM): %LET (variable name is LAST_EOM_DTTM) SYMBOLGEN: Macro variable FCF_RUN_ASOFDTTM resolves to 2031523199 MLOGIC(X_FCF_ASOFDTTM): %LET (variable name is LAST_EOM_DATE) SYMBOLGEN: Macro variable FCF_RUN_ASOFDTTM resolves to 2031523199 SYMBOLGEN: Macro variable ACTION resolves to GET MLOGIC(X_FCF_ASOFDTTM): %IF condition %upcase(&action)=RESET is FALSE SYMBOLGEN: Macro variable DBFLAVOR resolves to sqlsvr SYMBOLGEN: Macro variable ORIG_OPTION_SQLMAPPUTTO resolves to NONE MLOGIC(X_FCF_ASOFDTTM): %IF condition %upcase(&dbflavor) eq SQLSVR and "&orig_option_sqlmapputto." ne "NONE" is FALSE MLOGIC(X_FCF_ASOFDTTM): %PUT &=fcf_run_asofdttm SYMBOLGEN: Macro variable FCF_RUN_ASOFDTTM resolves to 2031523199 FCF_RUN_ASOFDTTM=2031523199 MLOGIC(X_FCF_ASOFDTTM): %PUT &=runasofdate SYMBOLGEN: Macro variable RUNASOFDATE resolves to 20240516 RUNASOFDATE=20240516 MLOGIC(X_FCF_ASOFDTTM): %PUT &=runasofdatetime SYMBOLGEN: Macro variable RUNASOFDATETIME resolves to 16MAY2024:00:00:00.000 RUNASOFDATETIME=16MAY2024:00:00:00.000 MLOGIC(X_FCF_ASOFDTTM): %PUT &=start_run_asofdttm SYMBOLGEN: Macro variable START_RUN_ASOFDTTM resolves to 2031436800 START_RUN_ASOFDTTM=2031436800 MLOGIC(X_FCF_ASOFDTTM): %PUT &=start_runasofdate SYMBOLGEN: Macro variable START_RUNASOFDATE resolves to 20240516 START_RUNASOFDATE=20240516 MLOGIC(X_FCF_ASOFDTTM): %PUT &=start_runasofdatetime SYMBOLGEN: Macro variable START_RUNASOFDATETIME resolves to 16MAY2024:00:00:00.000 START_RUNASOFDATETIME=16MAY2024:00:00:00.000 MLOGIC(X_FCF_ASOFDTTM): %PUT &=end_run_asofdttm SYMBOLGEN: Macro variable END_RUN_ASOFDTTM resolves to 2031523199 END_RUN_ASOFDTTM=2031523199 MLOGIC(X_FCF_ASOFDTTM): %PUT &=end_runasofdate SYMBOLGEN: Macro variable END_RUNASOFDATE resolves to 20240516 END_RUNASOFDATE=20240516 MLOGIC(X_FCF_ASOFDTTM): %PUT &=end_runasofdatetime SYMBOLGEN: Macro variable END_RUNASOFDATETIME resolves to 16MAY2024:23:59:59.000 END_RUNASOFDATETIME=16MAY2024:23:59:59.000 MLOGIC(X_FCF_ASOFDTTM): %PUT &=fcf_last_asofdttm SYMBOLGEN: Macro variable FCF_LAST_ASOFDTTM resolves to 2031436799 FCF_LAST_ASOFDTTM=2031436799 MLOGIC(X_FCF_ASOFDTTM): %PUT &=lastasofdate SYMBOLGEN: Macro variable LASTASOFDATE resolves to 20240515 LASTASOFDATE=20240515 MLOGIC(X_FCF_ASOFDTTM): %PUT &=lastasofdatetime SYMBOLGEN: Macro variable LASTASOFDATETIME resolves to 15MAY2024:00:00:00.000 LASTASOFDATETIME=15MAY2024:00:00:00.000 MLOGIC(X_FCF_ASOFDTTM): %PUT &=start_last_asofdttm SYMBOLGEN: Macro variable START_LAST_ASOFDTTM resolves to 2031350400 START_LAST_ASOFDTTM=2031350400 MLOGIC(X_FCF_ASOFDTTM): %PUT &=start_lastasofdate SYMBOLGEN: Macro variable START_LASTASOFDATE resolves to 20240515 9 The SAS System Tuesday, May 28, 2024 06:43:00 AM START_LASTASOFDATE=20240515 MLOGIC(X_FCF_ASOFDTTM): %PUT &=start_lastasofdatetime SYMBOLGEN: Macro variable START_LASTASOFDATETIME resolves to 15MAY2024:00:00:00.000 START_LASTASOFDATETIME=15MAY2024:00:00:00.000 MLOGIC(X_FCF_ASOFDTTM): %PUT &=end_last_asofdttm SYMBOLGEN: Macro variable END_LAST_ASOFDTTM resolves to 2031436799 END_LAST_ASOFDTTM=2031436799 MLOGIC(X_FCF_ASOFDTTM): %PUT &=end_lastasofdate SYMBOLGEN: Macro variable END_LASTASOFDATE resolves to 20240515 END_LASTASOFDATE=20240515 MLOGIC(X_FCF_ASOFDTTM): %PUT &=end_lastasofdatetime SYMBOLGEN: Macro variable END_LASTASOFDATETIME resolves to 15MAY2024:23:59:59.000 END_LASTASOFDATETIME=15MAY2024:23:59:59.000 MLOGIC(X_FCF_ASOFDTTM): %PUT &=max_used_asofdttm SYMBOLGEN: Macro variable MAX_USED_ASOFDTTM resolves to 2031350400 MAX_USED_ASOFDTTM=2031350400 MLOGIC(X_FCF_ASOFDTTM): %PUT &=last_eom_dttm SYMBOLGEN: Macro variable LAST_EOM_DTTM resolves to 2030054400 LAST_EOM_DTTM=2030054400 MLOGIC(X_FCF_ASOFDTTM): %PUT &=last_eom_date SYMBOLGEN: Macro variable LAST_EOM_DATE resolves to 20240430 LAST_EOM_DATE=20240430 MLOGIC(X_FCF_ASOFDTTM): Ending execution. 34126 %x_fcf_transactions_prep(run_asofdate=&runasofdate., cash_fact=Y, event_fact=Y); MLOGIC(X_FCF_TRANSACTIONS_PREP): Beginning execution. SYMBOLGEN: Macro variable RUNASOFDATE resolves to 20240516 MLOGIC(X_FCF_TRANSACTIONS_PREP): Parameter RUN_ASOFDATE has value 20240516 MLOGIC(X_FCF_TRANSACTIONS_PREP): Parameter CASH_FACT has value Y MLOGIC(X_FCF_TRANSACTIONS_PREP): Parameter EVENT_FACT has value Y MPRINT(X_FCF_TRANSACTIONS_PREP): options varlenchk=nowarn; MLOGIC(X_FCF_TRANSACTIONS_PREP): %LOCAL _FCFMODULE_ MLOGIC(X_FCF_TRANSACTIONS_PREP): %LET (variable name is _FCFMODULE_) MLOGIC(X_FCF_TRANSACTIONS_PREP): %LET (variable name is SYSRC) MLOGIC(X_FCF_TRANSACTIONS_PREP): %LET (variable name is JOB_RC) MLOGIC(X_FCF_TRANSACTIONS_PREP): %LET (variable name is TRANS_RC) MLOGIC(X_FCF_TRANSACTIONS_PREP): %LET (variable name is SQLRC) MLOGIC(X_FCF_TRANSACTIONS_PREP): %LET (variable name is SYSCC) MLOGIC(X_FCF_TRANSACTIONS_PREP): %LET (variable name is SEQUENCE_NO) MLOGIC(X_FCF_TRANSACTIONS_PREP): %LET (variable name is ETLS_STARTTIME) MLOGIC(X_FCF_TRANSACTIONS_PREP): %LET (variable name is RUN_ASOFDATE_STR) SYMBOLGEN: Macro variable RUN_ASOFDATE resolves to 20240516 MLOGIC(X_FCF_TRANSACTIONS_PREP): %LET (variable name is ETLS_JOBNAME) MLOGIC(X_FCF_TRANSACTIONS_PREP): %LET (variable name is STEP_NAME) MLOGIC(X_FCF_TRANSACTIONS_PREP): %LET (variable name is STEP_TIMESTAMP) MLOGIC(X_FCF_TRANSACTIONS_PREP): %PUT NOTE: Start &step_name [ &step_timestamp ] SYMBOLGEN: Macro variable STEP_NAME resolves to Run x_transaction_prep process SYMBOLGEN: Macro variable STEP_TIMESTAMP resolves to 28MAY24:06:43:16 NOTE: Start Run x_transaction_prep process [ 28MAY24:06:43:16 ] MPRINT(X_FCF_TRANSACTIONS_PREP): proc sql noprint; SYMBOLGEN: Macro variable DBCONNDSNCORE resolves to dsn='amltmdb' MPRINT(X_FCF_TRANSACTIONS_PREP): connect to sqlsvr ( dsn='amltmdb' AuthDomain="Cs.batch" ); NOTE: Credential obtained from Viya credentials service. MPRINT(X_FCF_TRANSACTIONS_PREP): select param_value into :skip_flag from connection to sqlsvr ( select param_value from core.ctrl_parameter where param_name = 'AGP_TRANSACTION_PREP_SKIP' ); MPRINT(X_FCF_TRANSACTIONS_PREP): disconnect from sqlsvr; MPRINT(X_FCF_TRANSACTIONS_PREP): quit; NOTE: PROCEDURE SQL used (Total process time): real time 0.10 seconds 10 The SAS System Tuesday, May 28, 2024 06:43:00 AM cpu time 0.03 seconds MLOGIC(X_FCF_TRANSACTIONS_PREP): %PUT &=skip_flag SYMBOLGEN: Macro variable SKIP_FLAG resolves to N SKIP_FLAG=N SYMBOLGEN: Macro variable SKIP_FLAG resolves to N MLOGIC(X_FCF_TRANSACTIONS_PREP): %IF condition &skip_flag. eq Y is FALSE MPRINT(X_FCF_TRANSACTIONS_PREP): proc sql noprint; SYMBOLGEN: Macro variable DBCONNDSNCORE resolves to dsn='amltmdb' MPRINT(X_FCF_TRANSACTIONS_PREP): connect to sqlsvr ( dsn='amltmdb' AuthDomain="Cs.batch" ); NOTE: Credential obtained from Viya credentials service. SYMBOLGEN: Macro variable RUN_ASOFDATE_STR resolves to '20240516' SYMBOLGEN: Some characters in the above value which were subject to macro quoting have been unquoted for printing. MPRINT(X_FCF_TRANSACTIONS_PREP): select daily_flag into :load_daily_flg from connection to sqlsvr ( select daily_flag from core.ctrl_load_control where load_date = '20240516' ); MPRINT(X_FCF_TRANSACTIONS_PREP): disconnect from sqlsvr; MPRINT(X_FCF_TRANSACTIONS_PREP): quit; NOTE: PROCEDURE SQL used (Total process time): real time 0.10 seconds cpu time 0.02 seconds MLOGIC(X_FCF_TRANSACTIONS_PREP): %PUT &=load_daily_flg SYMBOLGEN: Macro variable LOAD_DAILY_FLG resolves to Y LOAD_DAILY_FLG=Y SYMBOLGEN: Macro variable LOAD_DAILY_FLG resolves to Y MLOGIC(X_FCF_TRANSACTIONS_PREP): %IF condition &load_daily_flg. ne Y is FALSE MLOGIC(X_FCF_TRANSACTIONS_PREP): %LET (variable name is STEP_NAME) MLOGIC(X_FCF_TRANSACTIONS_PREP): %LET (variable name is STEP_TIMESTAMP) MLOGIC(X_FCF_TRANSACTIONS_PREP): %PUT NOTE: Start &step_name [ &step_timestamp ] SYMBOLGEN: Macro variable STEP_NAME resolves to Delete existing data from amlprep.x_transactions SYMBOLGEN: Macro variable STEP_TIMESTAMP resolves to 28MAY24:06:43:16 NOTE: Start Delete existing data from amlprep.x_transactions [ 28MAY24:06:43:16 ] MPRINT(X_FCF_TRANSACTIONS_PREP): proc sql buffersize = 100000 threads; SYMBOLGEN: Macro variable DBCONNDSNCORE resolves to dsn='amltmdb' MPRINT(X_FCF_TRANSACTIONS_PREP): connect to sqlsvr ( dsn='amltmdb' AuthDomain="Cs.batch" ); NOTE: Credential obtained from Viya credentials service. SYMBOLGEN: Macro variable RUN_ASOFDATE_STR resolves to '20240516' SYMBOLGEN: Some characters in the above value which were subject to macro quoting have been unquoted for printing. MPRINT(X_FCF_TRANSACTIONS_PREP): execute( delete from amlprep.x_transactions where cast(transaction_dttm as date) = '20240516' ) by sqlsvr; 11 The SAS System Tuesday, May 28, 2024 06:43:00 AM NOTE: No data found/modified. MPRINT(X_FCF_TRANSACTIONS_PREP): disconnect from sqlsvr; MPRINT(X_FCF_TRANSACTIONS_PREP): quit; NOTE: PROCEDURE SQL used (Total process time): real time 3.70 seconds cpu time 0.04 seconds MLOGIC(RCSET): Beginning execution. SYMBOLGEN: Macro variable SYSERR resolves to 0 MLOGIC(RCSET): Parameter ERROR has value 0 SYMBOLGEN: Macro variable ERROR resolves to 0 SYMBOLGEN: Macro variable TRANS_RC resolves to 0 MLOGIC(RCSET): %IF condition (&error gt &trans_rc) is FALSE SYMBOLGEN: Macro variable ERROR resolves to 0 SYMBOLGEN: Macro variable JOB_RC resolves to 0 MLOGIC(RCSET): %IF condition (&error gt &job_rc) is FALSE MLOGIC(RCSET): Ending execution. MPRINT(X_FCF_TRANSACTIONS_PREP): ; MLOGIC(RCSET): Beginning execution. SYMBOLGEN: Macro variable SQLRC resolves to 0 MLOGIC(RCSET): Parameter ERROR has value 0 SYMBOLGEN: Macro variable ERROR resolves to 0 SYMBOLGEN: Macro variable TRANS_RC resolves to 0 MLOGIC(RCSET): %IF condition (&error gt &trans_rc) is FALSE SYMBOLGEN: Macro variable ERROR resolves to 0 SYMBOLGEN: Macro variable JOB_RC resolves to 0 MLOGIC(RCSET): %IF condition (&error gt &job_rc) is FALSE MLOGIC(RCSET): Ending execution. MPRINT(X_FCF_TRANSACTIONS_PREP): ; SYMBOLGEN: Macro variable TRANS_RC resolves to 0 SYMBOLGEN: Macro variable TRANS_RC resolves to 0 SYMBOLGEN: Macro variable SQLRC resolves to 0 SYMBOLGEN: Macro variable SQLRC resolves to 0 MLOGIC(X_FCF_TRANSACTIONS_PREP): %IF condition (&trans_rc eq 3 or &trans_rc ge 5) or (&sqlrc eq 3 or &sqlrc ge 5) is FALSE MLOGIC(X_FCF_TRANSACTIONS_PREP): %LET (variable name is STEP_TIMESTAMP) MLOGIC(X_FCF_TRANSACTIONS_PREP): %PUT NOTE: Finish &step_name [ &step_timestamp ] SYMBOLGEN: Macro variable STEP_NAME resolves to Delete existing data from amlprep.x_transactions SYMBOLGEN: Macro variable STEP_TIMESTAMP resolves to 28MAY24:06:43:19 NOTE: Finish Delete existing data from amlprep.x_transactions [ 28MAY24:06:43:19 ] SYMBOLGEN: Macro variable CASH_FACT resolves to Y MLOGIC(X_FCF_TRANSACTIONS_PREP): %IF condition &cash_fact. = Y is TRUE MLOGIC(X_FCF_TRANSACTIONS_PREP): %LET (variable name is STEP_NAME) MLOGIC(X_FCF_TRANSACTIONS_PREP): %LET (variable name is STEP_TIMESTAMP) MLOGIC(X_FCF_TRANSACTIONS_PREP): %PUT NOTE: Start &step_name [ &step_timestamp ] SYMBOLGEN: Macro variable STEP_NAME resolves to create table amlprep.x_temp_wl_identifier SYMBOLGEN: Macro variable STEP_TIMESTAMP resolves to 28MAY24:06:43:19 NOTE: Start create table amlprep.x_temp_wl_identifier [ 28MAY24:06:43:19 ] MPRINT(X_FCF_TRANSACTIONS_PREP): proc sql buffersize = 100000 threads; SYMBOLGEN: Macro variable DBCONNDSNCORE resolves to dsn='amltmdb' MPRINT(X_FCF_TRANSACTIONS_PREP): connect to sqlsvr ( dsn='amltmdb' AuthDomain="Cs.batch" ); NOTE: Credential obtained from Viya credentials service. MPRINT(X_FCF_TRANSACTIONS_PREP): execute ( drop table if exists amlprep.x_temp_wl_identifier ) by sqlsvr; MPRINT(X_FCF_TRANSACTIONS_PREP): execute( select distinct identifier_number, identifier_type, case when sum(WL_TMP.watchlist_ind) = 1 then 'Y' else 'N' end watchlist_ind, case when sum(WL_TMP.greylist_ind) = 1 then 'Y' else 'N' end greylist_ind, case when sum(WL_TMP.risklist_ind) = 1 then 'Y' else 'N' end risklist_ind into amlprep.x_temp_wl_identifier from ( select identifier_number , identifier_type, case when watch_list_name = 'WTCH' and identifier_number is not null then 1 else 0 end as watchlist_ind, case when watch_list_name = 'GREY' and identifier_number is not null then 1 else 0 end as greylist_ind, case when watch_list_name = 'RISK' 12 The SAS System Tuesday, May 28, 2024 06:43:00 AM and identifier_number is not null then 1 else 0 end as risklist_ind from amlwatchlist.fsc_wl_entity WL_ENT inner join amlwatchlist.fsc_wl_identifier WL_ID on WL_ENT.entity_watch_list_key = WL_ID.entity_watch_list_key and WL_ENT.current_ind = 'Y' and WL_ENT.x_delete_flg = 'N' and WL_ID.current_ind = 'Y' and WL_ID.identifier_number is not null ) WL_TMP group by identifier_number , identifier_type ) by sqlsvr; MPRINT(X_FCF_TRANSACTIONS_PREP): disconnect from sqlsvr; MPRINT(X_FCF_TRANSACTIONS_PREP): quit; NOTE: PROCEDURE SQL used (Total process time): real time 0.55 seconds cpu time 0.02 seconds MLOGIC(RCSET): Beginning execution. SYMBOLGEN: Macro variable SYSERR resolves to 0 MLOGIC(RCSET): Parameter ERROR has value 0 SYMBOLGEN: Macro variable ERROR resolves to 0 SYMBOLGEN: Macro variable TRANS_RC resolves to 0 MLOGIC(RCSET): %IF condition (&error gt &trans_rc) is FALSE SYMBOLGEN: Macro variable ERROR resolves to 0 SYMBOLGEN: Macro variable JOB_RC resolves to 0 MLOGIC(RCSET): %IF condition (&error gt &job_rc) is FALSE MLOGIC(RCSET): Ending execution. MPRINT(X_FCF_TRANSACTIONS_PREP): ; MLOGIC(RCSET): Beginning execution. SYMBOLGEN: Macro variable SQLRC resolves to 0 MLOGIC(RCSET): Parameter ERROR has value 0 SYMBOLGEN: Macro variable ERROR resolves to 0 SYMBOLGEN: Macro variable TRANS_RC resolves to 0 MLOGIC(RCSET): %IF condition (&error gt &trans_rc) is FALSE SYMBOLGEN: Macro variable ERROR resolves to 0 SYMBOLGEN: Macro variable JOB_RC resolves to 0 MLOGIC(RCSET): %IF condition (&error gt &job_rc) is FALSE MLOGIC(RCSET): Ending execution. MPRINT(X_FCF_TRANSACTIONS_PREP): ; SYMBOLGEN: Macro variable TRANS_RC resolves to 0 SYMBOLGEN: Macro variable TRANS_RC resolves to 0 SYMBOLGEN: Macro variable SQLRC resolves to 0 SYMBOLGEN: Macro variable SQLRC resolves to 0 MLOGIC(X_FCF_TRANSACTIONS_PREP): %IF condition (&trans_rc eq 3 or &trans_rc ge 5) or (&sqlrc eq 3 or &sqlrc ge 5) is FALSE MLOGIC(X_FCF_TRANSACTIONS_PREP): %LET (variable name is STEP_TIMESTAMP) MLOGIC(X_FCF_TRANSACTIONS_PREP): %PUT NOTE: Finish &step_name [ &step_timestamp ] SYMBOLGEN: Macro variable STEP_NAME resolves to create table amlprep.x_temp_wl_identifier SYMBOLGEN: Macro variable STEP_TIMESTAMP resolves to 28MAY24:06:43:20 NOTE: Finish create table amlprep.x_temp_wl_identifier [ 28MAY24:06:43:20 ] MLOGIC(X_FCF_TRANSACTIONS_PREP): %LET (variable name is STEP_NAME) MLOGIC(X_FCF_TRANSACTIONS_PREP): %LET (variable name is STEP_TIMESTAMP) MLOGIC(X_FCF_TRANSACTIONS_PREP): %PUT NOTE: Start &step_name. [ &step_timestamp. ] SYMBOLGEN: Macro variable STEP_NAME resolves to create table x_temp_remitter SYMBOLGEN: Macro variable STEP_TIMESTAMP resolves to 28MAY24:06:43:20 NOTE: Start create table x_temp_remitter [ 28MAY24:06:43:20 ] MPRINT(X_FCF_TRANSACTIONS_PREP): proc sql buffersize = 100000 threads; SYMBOLGEN: Macro variable DBCONNDSNCORE resolves to dsn='amltmdb' MPRINT(X_FCF_TRANSACTIONS_PREP): connect to sqlsvr ( dsn='amltmdb' AuthDomain="Cs.batch" ); NOTE: Credential obtained from Viya credentials service. MPRINT(X_FCF_TRANSACTIONS_PREP): execute ( drop table if exists amlprep.x_temp_remitter ) by sqlsvr; SYMBOLGEN: Macro variable RUN_ASOFDATE_STR resolves to '20240516' SYMBOLGEN: Some characters in the above value which were subject to macro quoting have been unquoted for printing. MPRINT(X_FCF_TRANSACTIONS_PREP): execute( select RB.bank_name, RCL.x_code AS cntry_wl_ind, RBL.x_code AS bank_wl_ind, BB.transaction_key into amlprep.x_temp_remitter from core.fsc_cash_flow_fact CFF inner join core.fsc_cash_flow_bank_bridge BB ON 13 The SAS System Tuesday, May 28, 2024 06:43:00 AM CFF.transaction_key = BB.transaction_key inner join core.fsc_bank_dim RB ON BB.bank_key = RB.bank_key left join amlwatchlist.x_fsc_wl_location RBL ON RBL.watch_list_name = 'HRFI' and RB.bank_number = RBL.x_code and RBL.change_current_ind = 'Y' and RBL.delete_flg = 'N' and RBL.x_code is not null left join amlwatchlist.x_fsc_wl_location RCL on RB.bank_country_code = RCL.x_code and RCL.watch_list_name = 'HRCT' and RCL.change_current_ind = 'Y' and RCL.delete_flg = 'N' and RCL.x_code is not null where BB.role_desc = 'REMITTER' and cast(CFF.transaction_dttm as date) = '20240516' ) by sqlsvr; MPRINT(X_FCF_TRANSACTIONS_PREP): disconnect from sqlsvr; MPRINT(X_FCF_TRANSACTIONS_PREP): quit; NOTE: PROCEDURE SQL used (Total process time): real time 13:54.11 cpu time 0.03 seconds MLOGIC(RCSET): Beginning execution. SYMBOLGEN: Macro variable SYSERR resolves to 0 MLOGIC(RCSET): Parameter ERROR has value 0 SYMBOLGEN: Macro variable ERROR resolves to 0 SYMBOLGEN: Macro variable TRANS_RC resolves to 0 MLOGIC(RCSET): %IF condition (&error gt &trans_rc) is FALSE SYMBOLGEN: Macro variable ERROR resolves to 0 SYMBOLGEN: Macro variable JOB_RC resolves to 0 MLOGIC(RCSET): %IF condition (&error gt &job_rc) is FALSE MLOGIC(RCSET): Ending execution. MPRINT(X_FCF_TRANSACTIONS_PREP): ; MLOGIC(RCSET): Beginning execution. SYMBOLGEN: Macro variable SQLRC resolves to 0 MLOGIC(RCSET): Parameter ERROR has value 0 SYMBOLGEN: Macro variable ERROR resolves to 0 SYMBOLGEN: Macro variable TRANS_RC resolves to 0 MLOGIC(RCSET): %IF condition (&error gt &trans_rc) is FALSE SYMBOLGEN: Macro variable ERROR resolves to 0 SYMBOLGEN: Macro variable JOB_RC resolves to 0 MLOGIC(RCSET): %IF condition (&error gt &job_rc) is FALSE MLOGIC(RCSET): Ending execution. MPRINT(X_FCF_TRANSACTIONS_PREP): ; SYMBOLGEN: Macro variable TRANS_RC resolves to 0 SYMBOLGEN: Macro variable TRANS_RC resolves to 0 SYMBOLGEN: Macro variable SQLRC resolves to 0 SYMBOLGEN: Macro variable SQLRC resolves to 0 MLOGIC(X_FCF_TRANSACTIONS_PREP): %IF condition (&trans_rc eq 3 or &trans_rc ge 5) or (&sqlrc eq 3 or &sqlrc ge 5) is FALSE MLOGIC(X_FCF_TRANSACTIONS_PREP): %LET (variable name is STEP_TIMESTAMP) MLOGIC(X_FCF_TRANSACTIONS_PREP): %PUT NOTE: Finish &step_name [ &step_timestamp ] SYMBOLGEN: Macro variable STEP_NAME resolves to create table x_temp_remitter SYMBOLGEN: Macro variable STEP_TIMESTAMP resolves to 28MAY24:06:57:14 NOTE: Finish create table x_temp_remitter [ 28MAY24:06:57:14 ] MLOGIC(X_FCF_TRANSACTIONS_PREP): %LET (variable name is STEP_NAME) MLOGIC(X_FCF_TRANSACTIONS_PREP): %LET (variable name is STEP_TIMESTAMP) MLOGIC(X_FCF_TRANSACTIONS_PREP): %PUT NOTE: Start &step_name. [ &step_timestamp. ] SYMBOLGEN: Macro variable STEP_NAME resolves to create table x_temp_beneficiary SYMBOLGEN: Macro variable STEP_TIMESTAMP resolves to 28MAY24:06:57:14 NOTE: Start create table x_temp_beneficiary [ 28MAY24:06:57:14 ] MPRINT(X_FCF_TRANSACTIONS_PREP): proc sql buffersize = 100000 threads; SYMBOLGEN: Macro variable DBCONNDSNCORE resolves to dsn='amltmdb' MPRINT(X_FCF_TRANSACTIONS_PREP): connect to sqlsvr ( dsn='amltmdb' AuthDomain="Cs.batch" ); NOTE: Credential obtained from Viya credentials service. MPRINT(X_FCF_TRANSACTIONS_PREP): execute ( drop table if exists amlprep.x_temp_beneficiary ) by sqlsvr; SYMBOLGEN: Macro variable RUN_ASOFDATE_STR resolves to '20240516' SYMBOLGEN: Some characters in the above value which were subject to macro quoting have been unquoted for printing. MPRINT(X_FCF_TRANSACTIONS_PREP): execute( select RB.bank_name, RCL.x_code AS cntry_wl_ind, RBL.x_code AS bank_wl_ind, 14 The SAS System Tuesday, May 28, 2024 06:43:00 AM BB.transaction_key into amlprep.x_temp_beneficiary from core.fsc_cash_flow_fact CFF inner join core.fsc_cash_flow_bank_bridge BB ON CFF.transaction_key = BB.transaction_key inner join core.fsc_bank_dim RB ON BB.bank_key = RB.bank_key left join amlwatchlist.x_fsc_wl_location RBL ON RBL.watch_list_name = 'HRFI' and RB.bank_number = RBL.x_code and RBL.change_current_ind = 'Y' and RBL.delete_flg = 'N' and RBL.x_code is not null left join amlwatchlist.x_fsc_wl_location RCL on RB.bank_country_code = RCL.x_code and RCL.watch_list_name = 'HRCT' and RCL.change_current_ind = 'Y' and RCL.delete_flg = 'N' and RCL.x_code is not null where BB.role_desc = 'BENEFICIARY' and cast(CFF.transaction_dttm as date) = '20240516' ) by sqlsvr; MPRINT(X_FCF_TRANSACTIONS_PREP): disconnect from sqlsvr; MPRINT(X_FCF_TRANSACTIONS_PREP): quit; NOTE: PROCEDURE SQL used (Total process time): real time 11:07.11 cpu time 0.03 seconds MLOGIC(RCSET): Beginning execution. SYMBOLGEN: Macro variable SYSERR resolves to 0 MLOGIC(RCSET): Parameter ERROR has value 0 SYMBOLGEN: Macro variable ERROR resolves to 0 SYMBOLGEN: Macro variable TRANS_RC resolves to 0 MLOGIC(RCSET): %IF condition (&error gt &trans_rc) is FALSE SYMBOLGEN: Macro variable ERROR resolves to 0 SYMBOLGEN: Macro variable JOB_RC resolves to 0 MLOGIC(RCSET): %IF condition (&error gt &job_rc) is FALSE MLOGIC(RCSET): Ending execution. MPRINT(X_FCF_TRANSACTIONS_PREP): ; MLOGIC(RCSET): Beginning execution. SYMBOLGEN: Macro variable SQLRC resolves to 0 MLOGIC(RCSET): Parameter ERROR has value 0 SYMBOLGEN: Macro variable ERROR resolves to 0 SYMBOLGEN: Macro variable TRANS_RC resolves to 0 MLOGIC(RCSET): %IF condition (&error gt &trans_rc) is FALSE SYMBOLGEN: Macro variable ERROR resolves to 0 SYMBOLGEN: Macro variable JOB_RC resolves to 0 MLOGIC(RCSET): %IF condition (&error gt &job_rc) is FALSE MLOGIC(RCSET): Ending execution. MPRINT(X_FCF_TRANSACTIONS_PREP): ; SYMBOLGEN: Macro variable TRANS_RC resolves to 0 SYMBOLGEN: Macro variable TRANS_RC resolves to 0 SYMBOLGEN: Macro variable SQLRC resolves to 0 SYMBOLGEN: Macro variable SQLRC resolves to 0 MLOGIC(X_FCF_TRANSACTIONS_PREP): %IF condition (&trans_rc eq 3 or &trans_rc ge 5) or (&sqlrc eq 3 or &sqlrc ge 5) is FALSE MLOGIC(X_FCF_TRANSACTIONS_PREP): %LET (variable name is STEP_TIMESTAMP) MLOGIC(X_FCF_TRANSACTIONS_PREP): %PUT NOTE: Finish &step_name [ &step_timestamp ] SYMBOLGEN: Macro variable STEP_NAME resolves to create table x_temp_beneficiary SYMBOLGEN: Macro variable STEP_TIMESTAMP resolves to 28MAY24:07:08:21 NOTE: Finish create table x_temp_beneficiary [ 28MAY24:07:08:21 ] MLOGIC(X_FCF_TRANSACTIONS_PREP): %LET (variable name is STEP_NAME) MLOGIC(X_FCF_TRANSACTIONS_PREP): %LET (variable name is STEP_TIMESTAMP) MLOGIC(X_FCF_TRANSACTIONS_PREP): %PUT NOTE: Start &step_name [ &step_timestamp ] SYMBOLGEN: Macro variable STEP_NAME resolves to create table x_temp_cash_flow_fact_seq SYMBOLGEN: Macro variable STEP_TIMESTAMP resolves to 28MAY24:07:08:21 NOTE: Start create table x_temp_cash_flow_fact_seq [ 28MAY24:07:08:21 ] MPRINT(X_FCF_TRANSACTIONS_PREP): proc sql buffersize = 100000 threads; SYMBOLGEN: Macro variable DBCONNDSNCORE resolves to dsn='amltmdb' MPRINT(X_FCF_TRANSACTIONS_PREP): connect to sqlsvr ( dsn='amltmdb' AuthDomain="Cs.batch" ); NOTE: Credential obtained from Viya credentials service. MPRINT(X_FCF_TRANSACTIONS_PREP): execute ( drop table if exists amlprep.x_temp_cash_flow_fact_seq) by sqlsvr; SYMBOLGEN: Macro variable SEQUENCE_NO resolves to 1 SYMBOLGEN: Macro variable RUN_ASOFDATE_STR resolves to '20240516' 15 The SAS System Tuesday, May 28, 2024 06:43:00 AM SYMBOLGEN: Some characters in the above value which were subject to macro quoting have been unquoted for printing. MPRINT(X_FCF_TRANSACTIONS_PREP): execute ( select transaction_key ,row_number() over (order by transaction_key) % 1 + 1 as rownum into amlprep.x_temp_cash_flow_fact_seq from core.fsc_cash_flow_fact where cast(transaction_dttm as date) = '20240516' ) by sqlsvr; MPRINT(X_FCF_TRANSACTIONS_PREP): disconnect from sqlsvr; MPRINT(X_FCF_TRANSACTIONS_PREP): quit; NOTE: PROCEDURE SQL used (Total process time): real time 1:12.09 cpu time 0.04 seconds MLOGIC(RCSET): Beginning execution. SYMBOLGEN: Macro variable SYSERR resolves to 0 MLOGIC(RCSET): Parameter ERROR has value 0 SYMBOLGEN: Macro variable ERROR resolves to 0 SYMBOLGEN: Macro variable TRANS_RC resolves to 0 MLOGIC(RCSET): %IF condition (&error gt &trans_rc) is FALSE SYMBOLGEN: Macro variable ERROR resolves to 0 SYMBOLGEN: Macro variable JOB_RC resolves to 0 MLOGIC(RCSET): %IF condition (&error gt &job_rc) is FALSE MLOGIC(RCSET): Ending execution. MPRINT(X_FCF_TRANSACTIONS_PREP): ; MLOGIC(RCSET): Beginning execution. SYMBOLGEN: Macro variable SQLRC resolves to 0 MLOGIC(RCSET): Parameter ERROR has value 0 SYMBOLGEN: Macro variable ERROR resolves to 0 SYMBOLGEN: Macro variable TRANS_RC resolves to 0 MLOGIC(RCSET): %IF condition (&error gt &trans_rc) is FALSE SYMBOLGEN: Macro variable ERROR resolves to 0 SYMBOLGEN: Macro variable JOB_RC resolves to 0 MLOGIC(RCSET): %IF condition (&error gt &job_rc) is FALSE MLOGIC(RCSET): Ending execution. MPRINT(X_FCF_TRANSACTIONS_PREP): ; MLOGIC(X_FCF_TRANSACTIONS_PREP): %LET (variable name is STEP_TIMESTAMP) MLOGIC(X_FCF_TRANSACTIONS_PREP): %PUT NOTE: Finish &step_name [ &step_timestamp ] SYMBOLGEN: Macro variable STEP_NAME resolves to create table x_temp_cash_flow_fact_seq SYMBOLGEN: Macro variable STEP_TIMESTAMP resolves to 28MAY24:07:09:33 NOTE: Finish create table x_temp_cash_flow_fact_seq [ 28MAY24:07:09:33 ] SYMBOLGEN: Macro variable SEQUENCE_NO resolves to 1 MLOGIC(X_FCF_TRANSACTIONS_PREP): %DO loop beginning; index variable SEQUENCE_ID; start value is 1; stop value is 1; by value is 1. MLOGIC(X_FCF_TRANSACTIONS_PREP): %LET (variable name is STEP_NAME) SYMBOLGEN: Macro variable SEQUENCE_ID resolves to 1 MLOGIC(X_FCF_TRANSACTIONS_PREP): %LET (variable name is STEP_TIMESTAMP) MLOGIC(X_FCF_TRANSACTIONS_PREP): %PUT NOTE: Start &step_name. [ &step_timestamp. ] SYMBOLGEN: Macro variable STEP_NAME resolves to create table x_temp_cash_flow_fact_1 SYMBOLGEN: Macro variable STEP_TIMESTAMP resolves to 28MAY24:07:09:33 NOTE: Start create table x_temp_cash_flow_fact_1 [ 28MAY24:07:09:33 ] MPRINT(X_FCF_TRANSACTIONS_PREP): proc sql buffersize = 100000 threads; SYMBOLGEN: Macro variable DBCONNDSNCORE resolves to dsn='amltmdb' MPRINT(X_FCF_TRANSACTIONS_PREP): connect to sqlsvr ( dsn='amltmdb' AuthDomain="Cs.batch" ); NOTE: Credential obtained from Viya credentials service. SYMBOLGEN: Macro variable SEQUENCE_ID resolves to 1 MPRINT(X_FCF_TRANSACTIONS_PREP): execute ( drop table if exists amlprep.x_temp_cash_flow_fact_1 ) by sqlsvr; SYMBOLGEN: Macro variable RUN_ASOFDATE_STR resolves to '20240516' SYMBOLGEN: Some characters in the above value which were subject to macro quoting have been unquoted for printing. SYMBOLGEN: Macro variable RUN_ASOFDATE resolves to 20240516 SYMBOLGEN: Macro variable SEQUENCE_ID resolves to 1 SYMBOLGEN: Macro variable SEQUENCE_ID resolves to 1 16 The SAS System Tuesday, May 28, 2024 06:43:00 AM MPRINT(X_FCF_TRANSACTIONS_PREP): execute( select distinct ACCT_D.account_number, cast(ACCT_D.account_type_desc as varchar(20)) as account_type_desc, cast(ACCT_D.product_category_name as varchar(35)) as product_category_name, cast(ACCT_D.currency_based_account_ind as varchar(1)) as currency_based_account_ind, cast(ACCT_D.account_tax_state_code as varchar(3)) as account_tax_state_code, PTY_D.party_number, PTY_D.annual_income_amount, cast(PTY_D.politically_exposed_person_ind as varchar(1)) as politically_exposed_person_ind , cast(PTY_D.customer_since_date as date) as customer_since_date, KCEF.override_score_class_code as risk_classification, KCEF.last_susp_actv_rpt_date, KCEF.last_cash_trans_rpt_date, CF_FCT.currency_amount, CF_FCT.transaction_dttm, cast(CF_FCT.posted_dttm as date) as posted_date, TRN_TYP_D.transaction_cdi_code, TRN_TYP_D.primary_medium_desc, TRN_TYP_D.secondary_medium_desc, COALESCE(TRN_TYP_D.tertiary_medium_desc,'NULL') as tertiary_medium_desc, TRN_TYP_D.mechanism_desc, TRN_TYP_D.trancode, TRN_D.transaction_reference_number, TRN_D.transaction_description, cast(BRCH_D.street_state_code as varchar(3)) as branch_street_state_code, BRCH_D.branch_number, BRCH_D.branch_name, cast(BRCH_D.branch_type_desc as varchar(10)) as branch_type_desc, ASC_D.associate_number, ASC_D.associate_name, EXT_BEN_D.external_party_number as ext_beneficiary_party_number, EXT_BEN_D.full_name as ext_beneficiary_party_name, cast(EXT_BEN_D.ext_party_account_comp_key as varchar(150)) as ext_beneficiary_comp_key, EXT_REM_D.external_party_number as ext_remitter_party_number, EXT_REM_D.full_name as ext_remitter_party_name, cast(EXT_REM_D.ext_party_account_comp_key as varchar(150)) as ext_remitter_comp_key, cast(EXT_EXE_D.ext_party_account_comp_key as varchar(150)) as ext_executing_comp_key, cast(CF_FCT.country_code as varchar(2)) as txn_country_code, cast(CF_FCT.transaction_currency_code as varchar(3)) as txn_currency_code, TRN_ST_D.status_desc, TRN_ST_D.status_reason_desc, CF_FCT.transaction_key, CF_FCT.transaction_type_key, CF_FCT.remitter_ext_party_key, CF_FCT.beneficiary_ext_party_key, CF_FCT.executing_party_key, CF_FCT.executing_ext_party_key, PTY_D.party_key, ACCT_D.account_key, ACCT_D.account_name as x_account_name, ACCT_D.account_primary_branch_name, SEC_ACCT_D.account_number as x_secondary_account_number, SEC_ACCT_D.account_name as x_secondary_account_name, PTY_D.party_identification_id as x_party_identification_id, PTY_D.party_identification_type_desc as x_party_identification_type_desc, BRCH_D.street_postal_code as x_street_postal_code, datediff(day,PTY_D.customer_since_date,'20240516') as x_account_age_days, BRCH_D.street_state_name as x_txn_branch_province, ACCT_D.x_have_atm_ind, ACCT_D.account_open_date as x_account_open_date, PTY_D.x_occupation_code, PTY_D.x_occupation_desc, ACCT_D.x_account_purpose_desc, ACCT_D.x_apply_ibank_date, ACCT_D.x_balance_amount, ACCT_D.account_close_date as x_account_close_date, BRCH_D.x_region_name as x_region_name, 20240516 as x_ptn_yyyymmdd, PTY_D.X_PARTY_TYPE_CODE as x_party_type_code, CF_FCT.X_MG_REM_COUNTRY_CODE as x_mg_rem_country_code, case when (substring(ACCT_D.account_type_desc,1,5)) = '' or (substring(ACCT_D.account_type_desc,1,5)) is null or (substring(ACCT_D.account_type_desc,1,5)) = 'UNKNO' then 'UNKNOWN' else (substring(ACCT_D.account_type_desc,1,5)) end as c_acc_segment_cd into amlprep.x_temp_cash_flow_fact_1 from core.fsc_cash_flow_fact CF_FCT inner join core.fsc_account_dim ACCT_D on CF_FCT.account_key = ACCT_D.account_key and coalesce(ACCT_D.x_delete_flg,'N') = 'N' inner join core.fsc_party_account_bridge PTY_ACC_BR on ACCT_D.account_number = PTY_ACC_BR.account_number and PTY_ACC_BR.change_current_ind='Y' and coalesce(PTY_ACC_BR.x_delete_flg,'N') = 'N' and PTY_ACC_BR.role_key = 1 inner join core.fsc_party_dim PTY_D on PTY_ACC_BR.party_number = PTY_D.party_number and PTY_D.change_current_ind = 'Y' and coalesce(PTY_D.x_delete_flg,'N') = 'N' inner join core.fsc_transaction_dim TRN_D on CF_FCT.transaction_key = TRN_D.transaction_key inner join core.fsc_transaction_type_dim TRN_TYP_D on CF_FCT.transaction_type_key = TRN_TYP_D.transaction_type_key inner join core.fsc_transaction_status_dim TRN_ST_D on CF_FCT.transaction_status_key = TRN_ST_D.transaction_status_key inner join core.fsc_branch_dim BRCH_D on CF_FCT.branch_key = BRCH_D.branch_key and BRCH_D.change_current_ind = 'Y' inner join core.fsc_associate_dim ASC_D on CF_FCT.associate_key = ASC_D.associate_key and ASC_D.change_current_ind = 'Y' inner join core.fsc_ext_party_account_dim EXT_BEN_D on CF_FCT.beneficiary_ext_party_key=EXT_BEN_D.ext_party_account_key inner join core.fsc_ext_party_account_dim EXT_REM_D on CF_FCT.remitter_ext_party_key=EXT_REM_D.ext_party_account_key inner join core.fsc_ext_party_account_dim EXT_EXE_D on CF_FCT.executing_ext_party_key=EXT_EXE_D.ext_party_account_key inner join kc.entity_fact KCEF on PTY_ACC_BR.party_number = KCEF.primary_entity_number and KCEF.change_current_ind = 'Y' inner join core.fsc_account_dim SEC_ACCT_D on CF_FCT.secondary_account_key = SEC_ACCT_D.account_key and coalesce(SEC_ACCT_D.x_delete_flg,'N') = 'N' inner join amlprep.x_temp_cash_flow_fact_seq as CFF_SEQ on CF_FCT.transaction_key = CFF_SEQ.transaction_key and CFF_SEQ.rownum = 1 ) by sqlsvr; MPRINT(X_FCF_TRANSACTIONS_PREP): disconnect from sqlsvr; MPRINT(X_FCF_TRANSACTIONS_PREP): quit; NOTE: PROCEDURE SQL used (Total process time): real time 29:49.82 cpu time 0.03 seconds