SQL query enrollment end date when employee Opt out from the plan

Summary:

How to benefit plan enrollment end date when existing plans opted out by employee.

Content (please ensure you mask any confidential information):

Employee opted out from Pan X1 as of 1 January 2025.

X1 Plan original Enrollment start date : 2022/01/01

X1 Plan Opted out Enrollment start date : 2025/01/01

We are sending data to downstream ,so when existing plans gets opted out then it should be end dated in downstream. I wanted to know which columns to be referred in table ben_prtt_enrt_rslt to get correct end date of the plan enrollment.

Please provide any SQL if you have worked on similar requirement.