WFMBurst package
Abstracted model of database schema that is designed to support bursting. Bursting is a Cognos Business Intelligence (BI) supported method of pre-generating reports to minimize system load and generation time.
This topic describes the main categories in the WFMBurst package and lists the query subjects in each category.
See Query subjects.
Burst Actual Results
Contains the historical data (for example, POS data) that is imported into the system and used by the forecast generation process. Includes these query subjects:
- Actual Results
- Burst Team
- Forecast Driver
- Location
- Store
- User
- Workbrain Group
Burst Census
Contains census information. Includes these query subjects:
- Burst Team
- Calc Group
- Census
- Census Team
- Day Part
- Employee
- Pay Group
- Shift Pattern
- User
- Workbrain Group
Burst Employee Information
Contains employee information, including default labor settings and UDF data definitions. Includes these query subjects:
- Burst Employee
- Calc Group
- Currency
- Currency (User Locale)
- Currency Conversion
- Currency Conversion Group
- Employee Badge
- Employee Job
- Pay Group
- Shift Pattern
- User
- Team
- Team (with optional Sub Teams)
- Workbrain Group
The subcategory includes these query subjects:
- Department
- Docket
- Docket Activities
- Employee Default Labor
- Job
- Project
The subcategory includes these query subjects:
- Employee UDF Data
Burst Forecasting
Provides access to the output of the forecast generation process. Includes these query subjects:
- Burst Team
- Forecast Driver
- Forecasts
- Location
- Store
- User
- Workbrain Group
Burst Historical Payroll Cost
Contains the historical payroll cost data that is imported into the system. Includes these query subjects:
- Burst Team
- Employee
- Historical Payroll Cost
- Location
- Store
- User
- Workbrain Group
Burst Schedule Analysis
Contains information about generated schedules, including score and cost values. Includes these query subjects:
- Burst Team
- Location
- Schedule
- Schedule Cost
- Schedule Store
- Store
- User
- Workbrain Group
Burst Scheduling
Contains schedule shift detail information. Includes these query subjects:
- Burst Team
- Employee
- Employee Schedule Settings
- Location
- Scheduled Shift
- Shift Pattern
- Store
- User
- Workbrain Group
Burst Staffing
Contains staffing interval requirements for stores and departments that are associated with schedules. Includes these query subjects:
- Burst Team
- Location
- Required Job
- Required Job Rate
- Required Skill
- Staffing Requirement (SO)
- Store
- User
- Workbrain Group
Burst Work
Contains all time tracking information. Includes these query subjects:
- Bad Reason
- Burst Team
- Calc Group
- Currency
- Currency (User Locale)
- Currency Conversion Group
- Currency Conversion (Work Day)
- Department
- Docket
- Docket Activities
- Employee
- Hour Type
- Job
- Location
- Pay Group
- Project
- Shift
- Shift Pattern
- Store
- Team
- Time Code
- Time Code Controllable
- Time Code Uncontrollable
- User
- Work
- Work Day
- Workbrain Group
Burst Work Schedule Aggregation
The User Aggregated Work query subject returns data in a staging table that is tailored to contain work and scheduling information. The staging table must be pre-populated using a pre-processing task.
This category includes these query subjects:
- Calc Group
- Calendar Date
- Department
- Docket
- Employee
- Hour Type
- Job
- Pay Group
- Project
- Team
- User
- User Aggregated Work
- Workbrain Group