Genesys Engage on-premises

 View Only
Discussion Thread View

WFMDB - Need Tables to Pull Time-Off Balances for Agents

  • 1.  WFMDB - Need Tables to Pull Time-Off Balances for Agents

    Posted 03-02-2020 22:17
    ​We are looking to pull Time Off Balances by agent for any particular date out of the WFMDB (or the WFMETLDB if it is available there).  I'm  hoping someone can assist with which table/column (or additional joins) would store this information.  I have attempted to pull in Oracle using the WM_AGENT_TIMEOFF_RULES table with the WM_BALANCE column , but it's not storing the data we need.

    I have read through the WFMDB Genesys documentation and SQL examples, but haven't found anything addressing this specific WFM data.
    #PlatformAdministration

    ------------------------------
    Ryan Hyatt
    JPMorgan Chase
    ------------------------------


Need Help finding something?

Check out the Genesys Knowledge Network - your all-in-one access point for Genesys resources