OpenConstruction Academy
Sign in / Register
EN

Theory before task 2 · 8 min

Asset data the client can load

Asset data against the client's requirements

After this lecture you can

  1. Say what asset information requirements are for.
  2. Check component rows against every rule.
  3. Work out the compliance of an asset data file.
1 / 3

The client's rules

The appointing party states its asset information requirements: which fields each asset must carry so its maintenance system can plan work. Common ones are a unique name, a known space, an installation date, an expected life and, for equipment, a serial number.

Example. A pump with no space cannot be found by the technician sent to service it.
2 / 3

One gap fails the row

A row passes only if it meets every rule that applies to it. A Name used twice fails both rows, because the system cannot tell the two assets apart. A rule for equipment does not apply to doors.

Example. Of 20 rows, 3 with a gap and 2 sharing a Name leave 15 that pass.
Rows that pass
15
Rows with a gap
3
Rows sharing a Name
2
Common mistake

Failing a repeated Name once

The second row with the same Name looks like the copy, so only it is failed. Both are wrong: nobody knows which asset the first row describes either.

Example. Sort the rows by Name before you check anything else.

Compliance of a component sheet

Different numbers from your task.

Not to scale
The problem
  • 20 rows. 3 rows miss a required field.
  • 2 other rows share one Name.
Step 1 of 2

Rows that pass

How many rows pass?

20 − 3 − 2 = 15.

Step 2 of 2

Compliance

Compliance, in %?

15 × 100 ÷ 20 = 75 %.

In short. Every rule on every row; a shared Name fails every row that uses it.

Check yourself

Question 1 of 3

Two rows share a Name. How many fail?

  • Right.

  • The first is just as ambiguous.

  • A shared Name is a gap in itself.

Question 2 of 3

The requirements ask for serial numbers on equipment. A door has none. Does it pass?

  • Right. The rule does not apply to doors.

  • Only the rules that apply to it.

  • Fire doors are not equipment either.

Question 3 of 3

40 rows; 6 fail on a field and 2 more share a Name. Compliance, in %?

32 × 100 ÷ 40 = 80 %.

Read the source

Free official texts. The lecture cites clause numbers and puts the rules in its own words.