| Actor | Fragment | Worker | State |
|---|---|---|---|
| 121459 | 25153 | 26 | running |
| 121460 | 25153 | 26 | running |
| 121461 | 25161 | 26 | running |
| 121462 | 25161 | 26 | running |
| 121463 | 25156 | 26 | running |
| 121464 | 25156 | 26 | running |
| 121465 | 25154 | 26 | running |
| 121466 | 25154 | 26 | running |
| 121467 | 25162 | 26 | running |
| 121468 | 25162 | 26 | running |
| 121469 | 25155 | 26 | running |
| 121470 | 25155 | 26 | running |
CREATE MATERIALIZED VIEW insights.party_account_direct_mv AS
SELECT
inv.party_id,
inv.customer_relationship_id,
inv.entity_id AS account_id,
inv.effective_from AS effective_start_date,
inv.effective_to AS effective_end_date,
CAST('all' AS VARCHAR) AS type
FROM olap.party_involvements_dm AS inv
JOIN insights.open_accounts_mv AS oa
ON oa.account_id = inv.entity_id
JOIN party.customer_relationships AS cr
ON cr.id = inv.customer_relationship_id
AND cr.type = 'CUSTOMER'
AND cr.status = 'ACTIVE'
AND cr.disabled_at IS NULL
WHERE
inv.entity_type = 'ACCOUNT'
AND inv.involvement_type IN ('ACCOUNT_HOLDER', 'JOINT_ACCOUNT_HOLDER')
AND inv.status = 'ACTIVE'
AND inv.disabled_at IS NULL
AND (
inv.effective_to IS NULL OR inv.effective_to > inv.effective_from
)
UNION ALL
SELECT
inv.party_id,
inv.customer_relationship_id,
inv.entity_id AS account_id,
inv.effective_from AS effective_start_date,
inv.effective_to AS effective_end_date,
CAST(CASE WHEN oa.is_restricted THEN 'restricted' ELSE 'un_restricted' END AS VARCHAR) AS type
FROM olap.party_involvements_dm AS inv
JOIN insights.open_accounts_mv AS oa
ON oa.account_id = inv.entity_id
JOIN party.customer_relationships AS cr
ON cr.id = inv.customer_relationship_id
AND cr.type = 'CUSTOMER'
AND cr.status = 'ACTIVE'
AND cr.disabled_at IS NULL
WHERE
inv.entity_type = 'ACCOUNT'
AND inv.involvement_type IN ('ACCOUNT_HOLDER', 'JOINT_ACCOUNT_HOLDER')
AND inv.status = 'ACTIVE'
AND inv.disabled_at IS NULL
AND (
inv.effective_to IS NULL OR inv.effective_to > inv.effective_from
)