Job Time Recording is Construction Base's own site/job time recording system. For every job and every day you record who worked how long, which equipment and materials were used, and which type of work the hours belong to - and eventually release the recorded hours into the weekly time sheets.
A Job Time Recording document is organized as a header, lines and values, and goes through a simple release workflow (Open > To Validate > Registered).
Data Model
Each Job Time Recording document consists of three related tables.
Header
One header record represents a single time recording document, typically one site report for one day.
Field
Description
No.
The document number, assigned from the number series configured on the Jobs Setup.
Document Date
The date the recorded hours belong to. Can only be changed while the document is still Open.
Status
The current step in the release workflow: Open, To Validate or Registered. See Status Workflow below.
Job No. / Job Description
The job the recording belongs to. Changing the job clears the linked order and automatically looks up the job's sales order.
Job Task No.
The job task the recording belongs to.
Order No.
The sales order (Bill of Quantities) linked to the job. Changing it is automatically applied to all existing lines of the document.
Lines
Each line represents one resource, item, piece of equipment, type of work, or other document element. The Line Type determines what kind of line it is.
Line Type
Description
Workers
Personnel booked on the job (own employees or resources of type Person).
Equipment
Machinery, resources or resource groups of type Machine used on the job.
Material
Items or catalog items consumed on the job.
Type of Work
Defines the columns of the input matrix (see Type of Work below) - the tasks the hours/quantities of the other lines are booked against.
Confirmation
Service confirmation text lines.
Information
Free-text remark lines.
Refueling
Refueling records for machinery.
Attachment
A picture or file attached to the document.
Email-Recipients
Contact persons the document is sent to by e-mail.
Comment
Comment lines.
Subcontractor
Type-of-work lines linked to a subcontractor's purchase order for invoicing.
Within Workers, Equipment and Material lines, the Type field further classifies the line:
Personal - a person resource, either picked freely from the resources of type Person, or - if "Use Job Person" is enabled - restricted to the employees already assigned to the job.
Resource / Resource Group - a Business Central resource or resource group (type Person on Workers lines, type Machine on Equipment lines).
Item - a warehouse item (Material lines).
Katalogartikel (catalog item) - an item taken from a MEGABAU vendor material catalog.
Kataloggerät (catalog machine) - equipment taken from a MEGABAU machinery catalog.
Machine - the company's own machinery (Equipment lines).
Selecting a line's No. automatically fills in the description, unit of measure and, where applicable, the price. If the selected resource is set up as a team leader, you are asked whether the whole team should be added as additional lines in one step.
Values
The value table stores the actual hours or quantities. Each value belongs to one line (row) and, for normal bookings, to one Type of Work line (column) - together they form the cells of the input matrix.
Field
Description
Value
The recorded hours or quantity for this row/column combination.
Type of Work Line No.
The Type of Work line (matrix column) the value is booked against.
Worker Line No.
For break entries, the Workers line the break belongs to.
Von / Bis (From / To)
The start/end time of a break entry; the Value (break duration in hours) is calculated automatically from these two times.
Status Workflow
A time recording document moves through three statuses:
Status
Description
Open
The document can be freely edited. This is the initial status.
To Validate
The document has been submitted for checking (Validate action).
Registered
The document has been released (Register action): the recorded hours are transferred into the weekly time sheets and the document is locked.
Important
Header and line data can only be changed while the document is Open. Inserting, modifying or deleting a line, or changing the Document Date, on a document that is not Open results in an error.
Driver, Guest Night and Extra Charge
On Workers and Equipment lines you can additionally record:
Driver - whether the person was driving alone, driving with passengers, was a passenger, or was driving privately.
Guest Night - whether an overnight stay applies.
Extra Charge - whether other allowances apply.
Comment - a free-text comment for the line.
Break Times
Instead of entering a single break duration, you can record several separate break intervals for a Workers line via the Break field's AssistEdit. Each break is entered as a From/To time; the individual breaks are summed into the line's total break time, which is then used to calculate the End Time (Start Time + booked hours + break time).
Type of Work
The Type of Work lines define the matrix columns that hours and quantities are booked against (for example individual construction tasks). For each type of work you can specify:
Field
Description
No. / Description
Identifies the type of work; the description can come either from the job's own types of work ("Use Job Type of Work") or from the general types of work.
Work Type Code
Determines, among other things, whether hours booked against this type of work are printed on the daily construction report.
Absence Reason
Used for absence-related types of work.
Construction Work Key
The construction work key (Bauarbeitsschlüssel) associated with the type of work.
BoQ No.
Links the type of work to a position in the Bill of Quantities of the linked sales order.
Quantity (per Number)
A quantity recorded per type of work, independent of the hour bookings.
Subcontractor Boq Purchase Order No. / Line
For subcontractor lines, the purchase order (and BoQ position) the hours are invoiced against.
Input Matrix
The input matrix is the main entry screen: each row is a Workers, Equipment or Material line, each column is a Type of Work line (up to 32 columns), and entering a value in a cell books that many hours (or that quantity) for the row against that type of work. The row's Total column shows the sum of all its cells.
Selecting the No. field opens the lookup appropriate for the line's Type - for example the job's assigned employees for personnel (with the option to select several employees at once, which creates one line per selected employee), the item or catalog item list for materials, or the machinery/resource list for equipment.
Note
On phones, the matrix is simplified: instead of columns, the types of work are shown and edited one at a time.
Actions
New empty Time Record
Creates a new, blank time recording document.
Duplicate (New Site Report)
Creates a full copy of the current document - header, lines and values - dated on the next working day, with status reset to Open. Useful for repeating a similar daily site report from one day to the next.
Validate
Moves an Open document to status To Validate.
Reopen
Moves a document from To Validate back to Open.
Register
Releases a document that is To Validate: the recorded hours are transferred into the weekly time sheets and the status becomes Registered.
Mobile Time Entry
Job Time Recording can also be opened and filled in from the Mobile App, which provides a simplified entry point for site staff.
Related information
Original Construction Base Features, Mobile App Integration Mobile App integration lets Construction Base recognize which Business Central users are working in a mobile role, and offers them a small set of mobile-optimized entry points for common site tasks - time recording, repair time, machinery overview and machinery logistics...
Job Time Recording
Selecting the No. field opens the lookup appropriate for the line's Type - for example the job's assigned employees for personnel (with the option to select several employees at once, which creates one line per selected employee), the item or catalog item list for materials, or the machinery/resource list for equipment.
