IncidentDataAggregate table
Important
Some or all of this functionality is available as part of a preview release. The content and the functionality are subject to change.
The IncidentDataAggregate table contains denormalized data for incidents that affect an organization’s workforce.
Inputs
The table is generated by fetching data from the following environmental, social, and governance (ESG) data model tables:
Incident: Stores incident (an event, typically negative, that occurs at a specific date and time). It uses the IncidentType reference table. To support the prebuilt metrics, this table already contains a set of incident types. You can add other values as required.
IncidentRelatedParty: Stores the relationship of an employee or nonemployee party impacted by the incident.
For details on ingesting, transforming, and loading data into ESG data model tables, go to ESG data estate overview.
This table shows the IncidentsDataAggregate table column details and mapping of columns to ESG data model tables.
| Column name | Is nullable | Description | Mapping to ESG data model |
|---|---|---|---|
| IncidentId | Required | Unique identifier of the incident. | Incident.IncidentId |
| PartyId | Required | Party impacted by the incident, such as an employee. | Incident.IncidentId > IncidentRelatedParty.PartyId |
| PartyTypeName | Required | Party type of the party. | Incident.IncidentId > IncidentRelatedParty.PartyId > Party.PartyTypeId > PartyType.PartyTypeName |
| WorkforceCategory | Calculated value | Indicates whether the impacted party is an employee of the organization. | Calculated column. If IncidentRelatedParty.PartyId matches with Employee.PartyId, WorkforceCategory is Employee; otherwise, it's Non Employee. |
| IncidentTypeName | Required | Type of the incident, such as Discrimination or Work-related ill health. | Incident.IncidentTypeId > IncidentType.IncidentTypeName |
| IncidentTypeId | Required | Unique identifier of the incident type. | Incident.IncidentTypeId |
| TotalWorkerHoursLost | Optional | Total number of work hours lost as a result of the incident. | TotalWorkerHoursLost |
| IncidentPeriodStartTimestamp | Required | Timestamp when the incident started. | IncidentPeriodStartTimestamp |
| IncidentPeriodEndTimestamp | Optional | Timestamp when the incident ended. | IncidentPeriodEndTimestamp |
Note
If there are records in the measurement tables, but the attributes mapped to required fields in the aggregate table are missing, then aggregate table generation fails. You need to ensure that data for required fields is available for all the records in the ESG data model measurement tables.
The CreateAggregateForIncidentMetrics_INTB notebook contains the computation logic to generate the IncidentDataAggregate table in the ComputedESGMetrics_LH.
