Not everything in the appliances table is an installed appliance: planned points, to connect one later, are recorded too. The census identifies them with special codes, such as 99 or 9090.
If a planned point is marked as installed, or the other way around, the census the distributor receives doesn’t match what’s in the home.
The rule
- Checks
- Each row’s census code and the Installed / Planned column.
- Blocks when
- A special code (99, 98, 9090 or 9080) isn’t marked Planned, or a regular code isn’t marked Installed. Rows without an appliance aren’t checked.
- Message to the inspector
- “Appliance 99 can’t have Appliance type marked as Installed.”
- Applies to
- Forms with an appliances table and an Installed / Planned column. The column is set for each form.
Test cases
This is how it’s simulated before saving: if a case doesn’t give the expected result, nothing is saved.
| Situation | Result |
|---|---|
| 99 · Planned | Passes |
| 99 · Installed | Blocks |
| SAAD · Installed | Passes |
| SAAD · Planned | Blocks |
Ask your assistant for it
With the RETGAS connector in Claude, all you have to write is:
«In the appliances table, codes 99, 98, 9090 and 9080 are planned points and must be marked Planned; the rest, Installed. Build the rule and test it with both cases.»
Why it matters
-
What’s really in the home
The census separates what’s installed from what’s planned. The distributor gets the actual state of the installation.
-
Empty rows don’t block
The rule only checks rows with an appliance. A row left blank doesn’t stop the report.
The engine flags and the person decides. Rules only run when they’re active and linked to the form. How they’re configured
A planned point isn’t an appliance. The rule makes sure the census says so.
Other examples
- Times The start time comes before the end time
- Times The visit lasts at least the minimum time
- Photos The photos were taken on the day of the visit
- Result consistency A compliant report can’t have failed items
- Distributors The meter serial on the bill matches the actual meter
- Tables Exposed piping has length, diameter and type
- Calculations The appliances’ power adds up
- Distributors The inspection fee is the one agreed with each distributor
- Appliance census The census code follows each distributor’s format
- Appliance census The census type matches the flue (D.E.P.C.) column
- Appliance census Every appliance is in a registered room
