view: performance_visibility.notification.notification.fa_notification
as: fa_notification
- operation: union
as: notification_union
left: acct_notification
right: fa_notification
schema: union_schema
- operation: derive
as: notification_derived
source: notification_union
expressions:
- 'toInt(notification_key) as notification_key_int'
- ifThenElse(notification_key_int%5=1,"Account",
ifThenElse(notification_key_int%5=2,"FA","")) as item_type
- '"" as composite_sql'
- '"Performed in bottom 5% of composite in the past month" as notification_desc'
- |
concat("Objective: ",
ifThenElse(risk_type="NS","None Specified",
ifThenElse(risk_type="OI","Income",
ifThenElse(risk_type="OA","Aggressive Income",
ifThenElse(risk_type="OC","Capital Appreciation",
ifThenElse(risk_type="OS","Speculation",""))))),
" > Age: ",toString(sub_category),
" > Account Type: ",toString(account_type)) as composite_desc
- operation: map
as: notification_mapped
source: notification_derived
mappings:
- source: notification_key
target: notification_key_str
- source: notification_key_int
target: notification_key
- source: account_type
target: managed_status
- operation: selectFields
as: pv_notification_meta
source: notification_mapped
fields:
- notification_key
- item_type
- notification_desc
- composite_desc
- composite_sql
- managed_status
- risk_type
- sub_category
- operation: join
as: union_asst_perf
mode: FULL_OUTER
left: acct_asst
right: acctperf
mergeLeftAndRightKeys: true
keys:
- leftKey: acct_key
rightKey: acct_key
- leftKey: year
rightKey: year
- leftKey: month
rightKey: month
- leftKey: rate_source
rightKey: rate_source
- operation: filter
source: acct_master
as: acct_master_filter
filter: toInt(year) = toInt(substr("${today}", 0, 4)) and toInt(month) = toInt(substr("${today}", 5, 7)) and fa_key !='NA'