| Actor | Fragment | Worker | State |
|---|---|---|---|
| 737871 | 61078 | 51 | running |
| 737872 | 61078 | 51 | running |
| 737873 | 61080 | 51 | running |
| 737874 | 61080 | 51 | running |
| 737949 | 61070 | 51 | running |
| 737950 | 61070 | 51 | running |
| 737951 | 61081 | 51 | running |
| 737952 | 61081 | 51 | running |
| 737953 | 61071 | 51 | running |
| 737954 | 61071 | 51 | running |
| 737955 | 61072 | 51 | running |
| 737956 | 61072 | 51 | 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
)