Query 6212 Employee Absence - PBI API

Sustainability, Microsoft.Sustainability.PowerBIReports

src/Apps/W1/Sustainability/app/src/PowerBI/APIs/EmployeeAbsencePBIAPI.Query.al31 lines, Copyright (c) Microsoft Corporation. MIT

namespace Microsoft.Sustainability.PowerBIReports;using Microsoft.HumanResources.Absence;query 6212 "Employee Absence - PBI API"{    Access = Internal;    QueryType = API;    AboutText = 'Provides access to employee absence records including dates, causes, quantities, and descriptions. Enables Power BI reports to analyze workforce attendance patterns, absence trends, and their correlation with sustainability and social responsibility metrics.';    Caption = 'Power BI Employee Absence';    APIPublisher = 'microsoft';    APIGroup = 'analytics';    ApiVersion = 'v0.5', 'v1.0';    EntityName = 'pbiEmployeeAbsence';    EntitySetName = 'pbiEmployeeAbsences';    DataAccessIntent = ReadOnly;    elements    {        dataitem(employeeabsence; "Employee Absence")        {            column(employeeNo; "Employee No.") { }            column(entryNo; "Entry No.") { }            column(fromDate; "From Date") { }            column(toDate; "To Date") { }            column(causeofAbsenceCode; "Cause of Absence Code") { }            column(quantitybase; "Quantity (Base)") { }            column(description; Description) { }        }    }}