1. select
2.     dimuserenrollmentid,
3.     operation,
4.     intpartnerID,
5.     enrollmentid,
6.     userid,
7.     role,
8.     roletype,
9.     enrolledtoid,
10.     enrolledtotype,
11.     startdatetime,
12.     enddatetime,
13.     status,
14.     CreatedBy,
15.     UpdatedBy,
16.     CreatedDateTime,
17.     UpdatedDateTime,
18.     scdtimestamp,
19.     Isdeleted,
20.     statementid
21. from
22.     dw.dimuserenrollment
23. where
24.     rowversion > '2018/08/18 00:30:10.000000000'
25.     and rowversion <= '2018/09/11 08:44:51.000000000'
26.     and intpartnerid in (
27.         select
28.             IntegrationPartnerName
29.         from
30.             etl.IntegrationPartner
31.         WHERE
32.             IntegrationPartnerID in (
33.                 SELECT
34.                     cast(trim(split_part(t.id,
35.                     ',',
36.                     n.levelid + 1)) as int) As IntPartnerID
37.                 FROM
38.                     dw.dimparentchildlevel n cross
39.                 join
40.                     (
41.                         select
42.                             '4,7' as id
43.                     ) as t
44.                 where
45.                     trim(split_part(t.id, ',', n.levelid + 1)) <> ''
46.                     and trim(split_part(t.id, ',', n.levelid + 1)) is not null
47.                 )
48.         )