- 2 Posts
- 279 Views
How to query on benefits Entry Date
In PeopleSoft, is there an easy way to pull the first date an employee was enrolled in a benefit via Query?
@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.