wkcc__LocationWellnessFact__c
Aggregates wellness counts by location and status. This object rolls up the location hierarchy, aggregating status counts for all employees directly linked to a location or linked to any record in that location’s descendent hierarchy. This object is available in orgs that have Work.com installed.
Location Wellness Facts are created and updated whenever Locations change, or Employee Crisis Assessments change, or Employees change locations. These records hold summaries to make dashboard queries more performant. Wellness fact records are created for each wellness status type for a particular location and include both the percent of employees and the count of employees in that wellness status bracket. Wellness facts also include the total employee count in that particular location, such that Wellness Status Employee Count / Location Employee Count = Wellness Percent.
Directly related counts are maintained for level 1 locations. Cascading counts are maintained for level 1 and level 2 locations.
create(), delete(), describeLayout(), describeSObjects(), getDeleted(), getUpdated(), query(), retrieve(), undelete(), update(), upsert()
| 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__LocationEmployeeCount__c | double | Create, Filter, Sort, Update | The total count of employees regardless of wellness status. |
| wkcc__LocationLevel__c | double | Filter, Nillable, Sort | The related location’s location level. |
| 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 This field is available in orgs that have Workplace Command Center 4.2 and later installed. |
| wkcc__WellnessPercent__c | percent | Filter, Nillable, Sort | The percent of the location’s employees that are in the wellness status. |
| wkcc__WellnessStatusEmployeeCount__c | double | Create, Filter, Sort, Update | The count of employees having the wellness status. |
| wkcc__WellnessStatus__c | string | Create, Filter, Group, Sort, Update | The wellness status for the employee. |