Dimensions

Dimension	Description	Analyze by date
WFM Group	Employees can be classified into unique billboard groups. This dimension table contains the list of all billboard groups which exist in the system.	Group UTC Update Date
WFM Posting Status	Contains the list of all possible statuses of the shift trade. These are the complete list of the statuses: PENDING ACTIVE CLAIMED CANCELLED WITHDRAWN EXPIRED REJECTED	Posting Status UTC Update Date
WFM Shift Posting	Contains all the shift trade transactions and the corresponding status.	Shift Posting Shift Date
WFM Workflow Status	Contains the list of all possible statuses of the shift trade workflow. These are the complete list of the statuses: PENDING IN PROGRESS SUCCESS FAILED	Workflow Status UTC Update Date
Shift	Stores standardized details about work shifts, such as shift ID, name, start time, end time, and duration, to support consistent scheduling	Scheduling
Shift Activity	Captures standardized details of activities performed within a shift, such as activity ID, name, category, and description, to enable analysis of work patterns and productivity	Scheduling
Shift Attribute	Defines descriptive attributes of a shift such as type, location, department, or work pattern that provide additional context for analysis and reporting	Scheduling
Shift Label	Stores predefined labels or tags such as day shift, night shift, overtime, or holiday that categorize and annotate shifts for easier reporting and analysis	Scheduling
Shift Detail Layer	Holds granular information about individual shifts such as shift ID, employee assignment, role, timings, and status to provide detailed context for operational and analytical reporting	Scheduling
Shift Offer Shift	Captures details of shifts that are offered or made available to employees such as offer ID, shift type, timings, eligibility, and status to support workforce scheduling and acceptance tracking	Scheduling
Claim Type	Stores standardized categories of claims such as medical, travel, insurance, or reimbursement to ensure consistent classification and reporting in claim-related analyses	Shift Billboard

WFM Group

Employees can be classified into unique billboard groups. This dimension table contains the list of all billboard groups which exist in the system.

Group UTC Update Date

WFM Posting Status

Contains the list of all possible statuses of the shift trade. These are the complete list of the statuses:

PENDING
ACTIVE
CLAIMED
CANCELLED
WITHDRAWN
EXPIRED
REJECTED

Posting Status UTC Update Date

WFM Shift Posting

Contains all the shift trade transactions and the corresponding status.

Shift Posting Shift Date

WFM Workflow Status

Contains the list of all possible statuses of the shift trade workflow. These are the complete list of the statuses:

PENDING
IN PROGRESS
SUCCESS
FAILED

Workflow Status UTC Update Date

Shift

Stores standardized details about work shifts, such as shift ID, name, start time, end time, and duration, to support consistent scheduling

Scheduling

Shift Activity

Captures standardized details of activities performed within a shift, such as activity ID, name, category, and description, to enable analysis of work patterns and productivity

Scheduling

Shift Attribute

Defines descriptive attributes of a shift such as type, location, department, or work pattern that provide additional context for analysis and reporting

Scheduling

Shift Label

Stores predefined labels or tags such as day shift, night shift, overtime, or holiday that categorize and annotate shifts for easier reporting and analysis

Scheduling

Shift Detail Layer

Holds granular information about individual shifts such as shift ID, employee assignment, role, timings, and status to provide detailed context for operational and analytical reporting

Scheduling

Shift Offer Shift

Captures details of shifts that are offered or made available to employees such as offer ID, shift type, timings, eligibility, and status to support workforce scheduling and acceptance tracking

Scheduling

Claim Type

Stores standardized categories of claims such as medical, travel, insurance, or reimbursement to ensure consistent classification and reporting in claim-related analyses

Shift Billboard