The activity_classification table

The factor's activity hierarchy, level by level, with the publisher's own codes: what a flat sector label throws away.

Fields#

field type required example meaning
factor_id uuid yes The factor this row annotates.
scheme text yes Which classification scheme the code belongs to.
code text yes The identifier within the scheme: a real code where the scheme has one ('D', '311511'), else the segment name for a names-only publisher tree.
label text the native label at this level
level integer yes 1-based from the top
parent_code text the node one level up, same scheme
origin text yes source / mapped

Notes#

Join across libraries only on a scheme marked is_standard.