INX +BI

Add the field/ability to see the date/time a profile was created in INX

Want to be able to group exposure hours by workgroup Location and Mine Type.

Need to be able to report on number of hours as well as number of workers for exposure hours. View currently has organisation, employment class, number of hours but no number of workers field.

Data warehouse fact table InTuition Dim_Courses does not have a deleted flag. Therefore when a course is deleted from InTuition it will still be included as active in the table in the data warehouse.

ExpiryDate calculation is AssessedDate + (ExpiryYears 365d) days rather than 365.25. This results in the expiry date being not correct for the day and month when the expiry years is 99 eg. 2024-11-20 + (99yr 365d) days = 2024-11-20 + 36135d = 2123-10-28 Issue raised with support: https://support.inxsoftware.com/hc/en-us/requests/73408 Issue is also in all reporting, notifications, and anywhere there is an expiry date as the views are using either 365 days or 12 months. https://inxsoftware.canny.io/intuition/p/ccp-specific-date-expiry This has been a long standing issue with InTuition for many years.

We wanted to pull out all conditions that linked to an obligation. It doesn't appeared to be mapped and it is difficult to extract and seeing how many condition and what are they that linked to an obligation.

It should Include basic default fields: Being a paid service, its disappointed to see these fields are not mapped and included. Obligation Fields: Obligation owners and and endorsers

without the custom fields as the source which means inflexible on customise our own report.

Background: We use the Audit - Actions report all the time to identify the number of times actions are being rescheduled. Currently, it is written into our adhoc view, presumably from the Audit - Actions table. Recommendation: We need this information in the Data Warehouse, to create easy to view data metrics using Power BI.

It would be better if we can have the training event date of a person in the data warehouse. This information will be helpful to track if the person has already been nominated to a training event.