| Actor | Fragment | Worker | State |
|---|---|---|---|
| 53367 | 2552 | 3 | running |
| 53368 | 2552 | 3 | running |
| 53823 | 2559 | 3 | running |
| 53824 | 2559 | 3 | running |
| 53825 | 2554 | 3 | running |
| 53826 | 2554 | 3 | running |
| 53827 | 2553 | 3 | running |
| 53828 | 2553 | 3 | running |
| 53860 | 2555 | 3 | running |
| 53861 | 2555 | 3 | running |
| 54160 | 2558 | 3 | running |
| 54161 | 2558 | 3 | 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 = '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 = '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
)