Add 'Days away from work' (HNS_INJURED_PERSONS. DAYS_AWAY_FROM_WORK) to OTBI Environment Health and

User_ML9H2

Organization Name

THE SECRETARY OF STATE FOR DEFENCE (MOD) - DATACENTRE SERVICES

Description

Add missing data items to OTBI subject area.

In the Fusion Health and Safety app, when in inserting data on the Event detail screen, for the type 'Illness, Virus, or Injury', when the 'Absent From Work For More Than 1 Day' box is ticked, a section of the form becomes visible that allows for the insertion of a 'Number of days absent from work' and the 'Returned to work date'. This is held on the table.field HNS_INJURED_PERSONS.DAYS_AWAY_FROM_WRK and RTN_TO_WRK_DATE.

These data items are NOT brought through to anywhere in the OTBI subject areas for Health and Safety and so cannot be reported on in OTBI. They are NOT DFF fields.

I believe this is a mistake or oversight as all the data on these tables should be available in OTBI. I believe that these are 'new' items in the app so should automatically have been included in OTBI.

Use Case and Business Need

It is essential to bring these data items into the relevant OTBI subject area in order to report on them using OTBI, and so produce reports that are integrated with the rest of the data in these subject areas.

I need to produce reports that highlight Incidents with a number of criteria - one being where there was absence for > 6 days, others around the nature of the incidents. This is not possible to produce proper reporting in OTBI because of these missing data items.

More details

The items are missing from OTBI so it cannot be reported on.

Original Idea Number: 98211aa5d1

Brendan J. Doyle-Oracle

Hi there,

Thank you for your idea. I am relocating it to our Transactional Reporting (OTBI) Idea Lab for proper review: https://cloudcustomerconnect.oracle.com/resources/b2df648d2a/summary 

Best,

Brendan J. Doyle