Some more questions about planned and unplanned downtimes
The following questions arise on the subject of planned and unplanned downtimes
1)All the WORKPLACE_IDs and WORKPLACE_NAMES for a given organization along with their organizational hierarchy.
2)Availability (%)/day of a Workplace. We need something like, if we query with a WORKPLACE_ID and a date, it should return the availability or metrics to calculate the availability.
3)Planned Downtime (%)/ day of a workplace.
4)Unplanned Downtime (%) /day of a workplace.
5)All the possible Downtime codes with their description.
6)Downtime codes of Workplace on any given day. This is deep insight into the items 3 and 4.