[Datamart-News] Workday field update (OBIEE)

[Datamart Support * DAS]

There was a request that came in to help with some Workday fields within OBIEE. These are fields that were set as 'numeric' and 'sum', which are causing calculation issues on reports, due to the OBIEE auto sum feature. Therefore, we have altered these fields and changed them from sum to no longer sum.

This will not affect the data pulled into the query, only the way they are summing on reports.

The following fields have been updated:

'Workday - HCM Employee Payroll Register' Subject area:
HCM FTE
PR Gross
PR MTD
PR NET
PR QTD
PR Subject wages
PR Tax and deduction
PR Taxable wages
PR YTD

'Workday - HCM Employee Payroll Register Arrears' Subject area:
AR Balance
AR Gross
AR Net
AR Tax and Deduction
HCM FTE
PR Gross
PR MTD
PR NET
PR QTD
PR Subject wages
PR Tax and deduction
PR Taxable wages
PR YTD

'Workday - HCM Employee Arrears' Subject area:
AR Balance
AR Gross
AR Net
AR Tax and Deduction
HCM FTE

'Workday - HCM Employee' Subject area:
HCM FTE

'Workday-HCM Employee Position Costing' Subject area:
HCM FTE

'Workday - HCM Employee Time Off Balances' Subject area:
HCM FTE
TOB Time Off Beginning Balance
TOB Time Off Ending Balance
TOB Time Off Plan Accrual
TOB Time Off Plan Forfeited
TOB Time Off Taken

'Workday - Payroll Register' Subject area:
PR Gross
PR MTD
PR Net
PR QTD
PR Subject Wages
PR Tax and Deduction Sum
PR Taxable Wages
PR YTD

Thanks,
Aaron Wallace
Sr. Datamart Business Analyst

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://omls.oregon.gov/pipermail/datamart-news/attachments/20231108/d83e3761/attachment.html>