You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Need the Table/Field Mapping for Absence Plans and their Eligibility Profiles

Accepted answer
62
Views
7
Comments
edited Jun 29, 2018 5:01PM in Workforce Management 7 comments

Summary

Need the Table/Field Mapping for Absence Plans and their Eligibility Profiles

Content

Hi i am trying to put a script that extracts the setup of Absence Plans. I could not find the right join between Absence Plans table and Eligibility profiles to pull the Eligibility Profile for each Absence Plan.

Here is the sql which i am working on. If you run this sql this will not return any data. Once you comment this join

--AND BELP.ELIGY_PRFL_ID = ANCP.BEN_ELIG_PROFILE_ID

from the following query it will give the result but not right.

Please help me with this.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!