This page contains the official ‣ as inlined database and the technical documentation on how it is build. It targets Stocklers that maintain the ‣, users of ‣ should not use this page and instead create database views relevant for their use cases, see Classic Tech Tasks Views for more help.
Displayed Outputs are named as per the property name, without the suffix “output”.
e.g. the Status output is called “Status”
Internal values are named using the property name, with the suffix **Intl.
e.g. the Internal Status is called
Status Intl
Computations must be in snake_case with be self explicit names (some shortcuts can be used to improve readability). Characteristics fields must be postfixed by their source:
xxx_out_override: An override of the outputs for the characteristic xxx
<aside> 🪲 This field must be used only when the Tech Task service bugs and doesn’t computed the correct value.
</aside>
xxx_comp: Computed value by the Tech Task service for the characteristic xxx
<aside> 🕳️ When the computed value is equal to the internal value this field is kept empty.
</aside>
xxx_out: Non pretty formatted output (to easily build views) of characteristic xxx
<aside>
🔀 Reads xxx_out_override, fallback to xxx_comp, fallback to Xxx Intl
</aside>
<aside>
👀 Properties available ((…) are hidden when empty and […] always hidden)
Always displayed
<aside> 🔝
In the heading, frequently updated inputs:
Status Internal
Work Duration Internal
Gain Internal
</aside>
<aside> <img src="notion://custom_emoji/d5f8e949-51aa-4506-b147-e9e03f2d36f9/1330c632-6ae8-8054-bde4-007a73add71d" alt="notion://custom_emoji/d5f8e949-51aa-4506-b147-e9e03f2d36f9/1330c632-6ae8-8054-bde4-007a73add71d" width="40px" />
See field documentation.
</aside>
<aside> ↕️
Relations (Enabled Tasks & Prerequisites)
</aside>
Hidden in the right panel
<aside> ✍️
Less frequently updated inputs:
Complexity Internal
Teams Internal
</aside>
<aside> <img src="/icons/list_purple.svg" alt="/icons/list_purple.svg" width="40px" />
All other properties
</aside>
Computation properties are always hidden to improve readability, they are split into two groups:
🐘 Metadata
Properties automatically calculated by Notion (Created at, Created By, Updated At) and those set by notion automation (Started At)
🤖 Computations
Computations done in the Tech Task service by:
xxx_comp values and updates ‣ accordingly<aside>
🐌 Notion sometimes takes time to register updates and therefore computations might happen up to 30 seconds after the visual update. You can speed up the process by saving the page (cmd / ctrl + S)
</aside>