Understanding the GeoCRM record model

How clients, projects, jobs, dockets, logs, tests, calculations and reports relate.

This is the most useful page in these docs. GeoCRM keeps a lot of record types, and they nest inside each other in a specific way. Once you understand the shape, the rest of the application is straightforward.

The core chain

Client → Project → Job → Docket

  • A Client is the company or individual you work for. Clients are either an Organisation or an Individual.
  • A Project is a site. It has a project number (for example 12274) and a site address. A client usually has several projects.
  • A Job is a scheduled piece of work at a project. It has a job number (for example #13167), a start and end time, and an assigned crew. A project usually has several jobs.
  • A Docket is created automatically with every job. It is the field record — work entries, photos, time on site — and it is what gets signed, reported on and invoiced. One job, one docket.

The important thing to remember: you don't create dockets. Creating a job creates its docket for you.

Records that hang off a job

Depending on the kind of work, a job also produces:

  • Ground Log (GL-13159-01) — a subsurface investigation. One ground log holds several investigation locations: boreholes, trial pits, CPTs and monitoring wells.
  • DCP Test (DCP-00003) — a dynamic cone penetrometer field record. It can stand alone or be linked to a ground log.
  • Work Request (WR-4001) — a laboratory job. It holds samples, and each sample holds worksheets (the individual tests).

Records that sit above the work

  • Calculation (CALC-00005) — a saved engineering design check, such as a bearing capacity assessment. Calculations keep a full revision history.
  • Report (RB-12272-001) — a document built in the Report Builder that assembles narrative, calculations, logs, test results and images into something you can issue.

Numbering reference

Record Format Example
Project Sequential number 12274
Job # + number #13167
Docket Project–docket 12275-3829
Work request WR- + number WR-4001
Sample S- + request + letter S-4001A
Ground log GL- + job + set GL-13159-01
DCP test DCP- + number DCP-00003
Calculation CALC- + number CALC-00005
Report RB- + project + number RB-12272-001

You can paste any of these numbers into the global search to jump straight to the record.