@Melody Smith If I'm understanding your question correctly.Using Query Manager, I would either query the BAS_PARTIC_PLAN or corresponding Base Benefit Table, e.g. HEALTH_BENEFITS. Then criteria of COVERAGE_ELECT=E on the plan you're inquiring about, returning the field COVERAGE_ELECT_DT and selecting the Aggregate function MIN. Also make sure the default effective date criteria is removed/modified. Of course there are some caveats to this, such as if an event was reprocessed at later date, but I would think you would obtain decent results.
Looks like your connection to Quest Oracle Community was lost, please wait while we try to reconnect.