Question numbers match their folders: folder 01 contains 01-01, 01-02 and so on. The starter dashboard uses 01-05, 01-08 and 01-02; process filter values come from 01-20. OBP identities and SQL filenames remain stable.
Choose a question for the decision you need to make. Find the equivalent saved question by its number in your supplied collection. If it has not been prepared, ask your administrator to create it from the linked English SQL definition before adding it to a dashboard. Filters act on existing output columns and do not override the source conditions.
The headings below match the English SQL variants in this guide. Use the stable question number to find its equivalent in your supplied collection; names can vary by language and environment.
Before using hours: eligible sums use closed durations greater than zero and up to 12 hours each. Longer reports need review, not automatic rejection. Parallel timers overlap, so these are not attendance hours.
04-01 · Reported hours by starting week
Sum eligible closed time reports by the week in which reporting started.
Recommended display: Table
Available filters: Report-start week.
What the columns mean
Report-start week: The week when time reporting started, not the week when the report closed.
Reported hours: Decimal hours summed from closed reports with duration greater than zero and up to 12 hours each. Overlap is counted in every parallel timer; this is not attendance time.
When checking a discrepancy: Duration is milliseconds. Includes durations greater than zero and up to 12 hours with an end date. Start is not separately required; parallel timers are not merged.
04-02 · Reported hours by chapter
Compare eligible closed reported hours by chapter name.
Recommended display: Table
Available filters: Chapter.
What the columns mean
Chapter: Chapter name stored on a time report. Same-named chapters in different workflows can merge in 04-02.
Reported hours: Decimal hours summed from closed reports with duration greater than zero and up to 12 hours each. Overlap is counted in every parallel timer; this is not attendance time.
When checking a discrepancy: Groups by chapter name without a process identifier. Same-named chapters across processes can merge; missing names get the SQL fallback label.
04-03 · Reported hours by work order and SKU
Compare eligible closed report counts and hours for each order-number × SKU combination.
Recommended display: Table
Available filters: Order, SKU.
What the columns mean
Order: The same kind of identifier as the work-order-number column; different questions use different localized headings.
SKU: The part identifier recorded on the order, run or stock record, according to the question. It is not an individual-unit identifier.
Reported hours: Decimal hours summed from closed reports with duration greater than zero and up to 12 hours each. Overlap is counted in every parallel timer; this is not attendance time.
Reports: Time-report record count.04-03 counts eligible closed reports up to 12 hours;04-04–04-06,04-10 and 06-06 count their defined populations. Compare source conditions first.
When checking a discrepancy: Both measures use reports with duration greater than zero and up to 12 hours. Missing order or SKU can produce blank groups.
04-04 · Time reports by record type
See all report counts by record type alongside hours from eligible closed reports.
Recommended display: Bar chart with value labels
Available filters: Record type.
What the columns mean
Record type: Stored time-report record type, such as manual or automatic where present in the data. Describes how the report was created, not the business activity.
Reports: Time-report record count.04-03 counts eligible closed reports up to 12 hours;04-04–04-06,04-10 and 06-06 count their defined populations. Compare source conditions first.
Valid hours up to12 hours: Eligible closed reported hours with duration greater than zero and up to 12 hours. In 04-04–04-05, the report count includes all reports while the hours use only this subset.
When checking a discrepancy: Counts include every report; hours include only closed durations greater than zero and up to 12 hours. Their populations differ.
04-05 · Time reports by recorded work type
See report counts and eligible closed hours by recorded work classification.
Recommended display: Bar chart with value labels
Available filters: Recorded work type.
What the columns mean
Recorded work type: Work classification recorded in the report. Names depend on the organization; the package does not automatically determine productive work.
Reports: Time-report record count.04-03 counts eligible closed reports up to 12 hours;04-04–04-06,04-10 and 06-06 count their defined populations. Compare source conditions first.
Valid hours up to12 hours: Eligible closed reported hours with duration greater than zero and up to 12 hours. In 04-04–04-05, the report count includes all reports while the hours use only this subset.
When checking a discrepancy: The source does not decide which organizational work types are productive. Count and hour populations differ as in 04-04.
04-06 · Time-report checks
Find how reports distribute across open timers, missing duration, non-positive duration, over 12 hours and closed up to 12 hours.
Recommended display: Bar chart with value labels
Available filters: Report check category.
What the columns mean
Report check category: Open timer, missing duration, non-positive duration, over 12 hours or closed up to 12 hours. Missing end takes precedence as open. Describes a report, not a worker's status.
Reports: Time-report record count.04-03 counts eligible closed reports up to 12 hours;04-04–04-06,04-10 and 06-06 count their defined populations. Compare source conditions first.
When checking a discrepancy: The first matching CASE branch wins. Missing end is classified as open before duration is checked.
04-07 · Open timers
See the total number of reports without an end timestamp.
Recommended display: Single number
Filters: this is an overall scalar with no worker, process or date breakdown. Filtering its single numeric output does not add a missing dimension.
What the columns mean
Open timers: Overall count of reports without an end timestamp. Does not prove current work. This scalar question has no worker breakdown.
When checking a discrepancy: This is an overall measure with no worker or period dimension. An open timer does not prove current attendance or activity.
04-08 · Closed reports longer than 12 hours
See the total number of closed time reports whose stored duration exceeds 12 hours.
Recommended display: Single number
Filters: this is an overall scalar with no worker, process or date breakdown. Filtering its single numeric output does not add a missing dimension.
What the columns mean
Reports over12 hours: Closed reports whose stored duration exceeds 12 hours. A fixed question threshold, not an organizational shift definition.
When checking a discrepancy: The fixed threshold is a package rule, not an organization-specific shift rule. A long report is not automatically wrong.
04-09 · Reports whose end time changed
Count reports whose current end differs from the first stored end.
Recommended display: Single number
Filters: this is an overall scalar with no worker, process or date breakdown. Filtering its single numeric output does not add a missing dimension.
What the columns mean
Reports changed after closing: Reports whose current end timestamp differs from the first stored end. Does not give the reason or editor identity.
When checking a discrepancy: This is not a full audit trail and does not identify the editor or the reason.
04-10 · Time reports by approval status
Count time reports by recorded manager approval status.
Recommended display: Bar chart with value labels
Available filters: Approval status.
What the columns mean
Approval status: Stored manager-approval status. Missing is displayed as NOT_NEEDED, which does not establish an approval process is in use.
Reports: Time-report record count.04-03 counts eligible closed reports up to 12 hours;04-04–04-06,04-10 and 06-06 count their defined populations. Compare source conditions first.
When checking a discrepancy: NULL is displayed as NOT_NEEDED. This does not prove a manager-approval process is configured or completed.