Location
The Location entity provides the data columns necessary to identify the actual place a job was worked by or scheduled for an employee. The Location entity is based on the Business Structure defined in the application.
Supported Dataview types
Employee Dataview |
Business Structure Dataview |
Employee Time Series Dataview |
Business Structure Time Series Dataview |
---|---|---|---|
X |
X |
X |
Data granularity
Not applicable. Location provides only dimensional data.
Columns
Label |
Description |
Key |
---|---|---|
Employee Count |
Number of employees with a primary job in a location as of the end date of the specified time period |
LOCATION_EMPLOYEE_COUNT |
Location Address |
LOCATION_ADDRESS | |
Location Description |
LOCATION_DESCRIPTION | |
Location Id |
Uniquely identifies business location. |
LOCATION_ID |
Location Job Sort Order |
The sort order associated with the defined job. |
LOCATION_JOB_SORT_ORDER |
Location Name |
LOCATION_NAME | |
Location Name (Path) |
LOCATION_PATH | |
Location’s Assigned Currency |
LOCATION_ASSIGNED_CURRENCY |
Related entities
Employee Dataview
- Schedule Events
- Schedule Events Pay Code Edit
- Schedule Tag Segment
- Scheduled Paycode Edit
- Scheduled Shift Segment
- Shift Segment Tag
Business Structure Dataview
- Actual Volume
- Actual Volume — Schedule Zone
- Actual Volume – Schedule Zone Set
- Actual Volume — Standard Shift
- Actual Volume — Standard Shift Set
- Actual Volume Detail
- Actual Volume Detail — Schedule Zone
- Actual Volume Detail — Standard Shift
- Analytics
- Budget Volume
- Budget Volume — Schedule Zone
- Budget Volume – Schedule Zone Set
- Budget Volume — Standard Shift
- Budget Volume – Standard Shift Set
- Budget Volume Detail
- Budget Volume – Schedule Zone
- Budget Volume Detail – Standard Shift
- Coverage — Scheduled Count
- Coverage Detail — Scheduled Count
- Plan Volume
- Plan Volume — Schedule Zone
- Plan Volume — Schedule Zone Set
- Plan Volume — Standard Shift
- Plan Volume — Standard Shift Set
- Plan Volume Detail
- Plan Volume Detail — Schedule Zone
- Plan Volume Detail — Standard Shift
- Posted Schedule
- Schedule Events
- Schedule Events Pay Code Edit
- Schedule Tag Segment
- Schedule Zone
- Schedule Zone Set
- Schedule Zone Set Assignment
- Scheduled Shift Segment
- Shift Segment Tag
- Workload — Budgeted Count
- Workload — Planned Count
Additional information
The Location entity columns are primarily used in Business Structure Dataviews.
Core entity
Employee | Organization | Day | Organizational Job | Paycode | Labor Category |
---|---|---|---|---|---|
X |
Relationship
One-to-One | One-to-Many |
---|---|
X |