Skip to content

Check whether a month contains a jobcode

How-to guide

Which jobcodes did I book this month, and how much on each?

std_jobcodes {from?, to?} returns one row per distinct item with the number of days, the hours, the dates and the share of the range’s booked hours.

Did I book anything on order 900140 or holiday (0010) in August?

std_jobcodes {from: "2026-08-01", to: "2026-08-31", codes: ["900140", "0010"]}. An empty result means none of the codes is present.

A code matches a non-chargeable order, a chargeable sales order, a sales order item or an attendance type. Leading zeros do not matter (900140 matches the stored 000000900140).

For the Multiproject timesheet, the equivalent question is answered by mp stats / mp_stats; see Project proportions.