Hello all, I am new to SAS and I am currently working on SAS AML Scenarios. The context: I have information on the parameter values and the required source columns for scenarios that are of my interest. For example, Scenario SAS10005 uses the following: Parameters: p10005_account_type_desc p10005_cdi_indicator p10005_ctr_amount p10005_currency_acct p10005_pri_medium_desc p10005_status_desc and the required Source Tables - Source Columns are: DERIVED - DATE_KEY FSC_ACCOUNT_DIM - ACCOUNT_TYPE_DESC FSC_ACCOUNT_DIM - CURRENCY_BASED_ACCOUNT_IND FSC_CASH_FLOW_FACT - CURRENCY_AMOUNT FSC_CASH_FLOW_FACT - TRANSACTION_KEY FSC_CURRENCY_DIM - CURRENCY_CODE FSC_TRANSACTION_STATUS_DIM - STATUS_DESC FSC_TRANSACTION_TYPE_DIM - PRIMARY_MEDIUM_DESC FSC_TRANSACTION_TYPE_DIM - TRANSACTION_CDI_CODE Now, I want to understand the mapping between the parameters and their relevant columns. For Ex: p10005_account_type_desc is mapped to FSC_ACCOUNT_DIM - ACCOUNT_TYPE_DESC However, I am not able to find the mapping column for p10005_ctr_amount. I thus request your inputs on where can I look for this. Also, to help me work on other parameter mappings, kindly share information on where can I find all the columns of all the underlying tables of SAS AML (Fact, Dimension, Bridge, Transaction and other supporitng tables) Thank you in advance. Chaitanya.
... View more
