Need the Table/Field Mapping for Absence Qualified Entitlements
Summary
Need the Table/Field Mapping for Absence Qualified EntitlementsContent
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",
Tagged:
0