Your UX is waiting ...interact, engage, explore in Las Vegas at CloudWorld 2023

Learn more
Need the Table/Field Mapping for Absence Qualified Entitlements — Cloud Customer Connect
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 Qualified Entitlements

Received Response
74
Views
3
Comments
edited Sep 12, 2018 9:56AM in Workforce Management 3 comments

Summary

Need the Table/Field Mapping for Absence Qualified Entitlements

Content

Hi Experts,

Naviation Person Management -> Manage Employment -> Manage Absence Records scroll down to Qualified Entitlements section, I've written small sql query to extract person Plan, Plan Period, Payment Percentage, Qualified Entitlement, Used , Remaining. My issue is SUMM_UNITS column is not matching with what's displayed on screen value (i.e Used). 

Your help is highly appreciate on this.

select "ANC_PER_ABS_ENTRIES"."PER_ABSENCE_ENTRY_ID" as "PER_ABSENCE_ENTRY_ID",
 "ANC_PER_ABS_ENTRIES"."ATTRIBUTE2",
 "ANC_PER_ABS_ENTRIES"."DURATION",
"ANC_ABSENCE_PLANS_VL"."NAME" as "PLAN_NAME",

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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