wkcc__LocationWellnessAggregation__c

Aggregates wellness counts by location and status of employees directly linked to a location. This object is available in orgs that have Workplace Command Center version 4.2 and later installed.

Supported Calls

create(), delete(), describeLayout(), describeSObjects(), getDeleted(), getUpdated(), query(), retrieve(), undelete(), update(), upsert()

Fields

Field Type Properties Description
Name string Autonumber, Defaulted on create, Filter, idLookup, Sort The record name.
OwnerId reference Create, Defaulted on create, Filter, Group, Sort, Update The ID of the user who currently owns this record. Default value is the user logged in to the API to perform the create.
wkcc__ExternalId__c string Create, Filter, Group, idLookup, Sort, Update A unique identifier for the record in the format ["Cascade" + ":" +] <Location Id> + ‘:’ + <Wellness Status>. The cascade prefix is only present in records that include child location wellness status values. This field is unique within your organization.
wkcc__LocationIndividualCount__c double Create, Defaulted on create, Filter, Sort, Update The total count of individuals regardless of wellness status.
wkcc__Location__c reference Create, Filter, Group, Nillable, Sort, Update The related Location.
wkcc__NeedsReaggregation__c boolean Create, Defaulted on create, Filter, Group, Sort, Update Indicates to a batch process that wellness status data (specifically, employee counts with each status) must be reaggregated (true). This field is reset to false after the batch process reaggregates the data.
wkcc__WellnessPercent__c percent Filter, Nillable, Sort The calculated percent of the location’s employees that are in the wellness status.
wkcc__WellnessStatusIndividualCount__c double Create, Defaulted on create, Filter, Sort, Update The count of individuals having the wellness status.
wkcc__WellnessStatus__c string Create, Filter, Group, Sort, Update The wellness status for the individual.

wkcc__WellnessPercent__c Example

IF(
  wkcc__LocationIndividualCount__c = 0,
  0,
  wkcc__WellnessStatusIndividualCount__c / wkcc__LocationIndividualCount__c
)