Complete question bank, scoring methodology, pillar structure, and data schema. Version 1.0.
Email This Document
Sends a formatted HTML version to Ben Heslop and Alexander Moir.
Egalitarian Mode · 5 Pillars
Influence through reputation, reciprocity, and collective belonging.
Hierarchical Mode · 5 Pillars
Influence through rank, structure, and direct exchange.
Raw responses
Each of the 30 questions receives a rating of 1–5.
Reverse scoring
Where reverse_scored: true, the score is 6 − rating. No current questions use this, but the field is supported.
Pillar score
Mean of the pillar's 3 questions, normalised: ((mean − 1) / 4) × 100.
Mode averages
egalitarian_average = mean of 5 egalitarian scores. hierarchical_average = mean of 5 hierarchical scores.
Mode Dominance Score
((hierarchical_avg − egalitarian_avg) + 100) / 2 · 0 = maximally egalitarian · 50 = balanced · 100 = maximally hierarchical
Dominant Mode Label
egalitarian if score < 45 · hierarchical if score > 55 · balanced otherwise
| Field | Type | Description |
|---|---|---|
| user_uuid | string | FK to UserProfile.user_uuid |
| user_email | string | Fast lookup key |
| survey_type | enum | pilar_self_assessment |
| survey_version | string | Currently 1.0 |
| raw_responses | object | question_id → rating (1–5) |
| calculated_pillar_scores | object | 10 normalised scores (0–100) |
| egalitarian_average | number | Mean of 5 egalitarian scores |
| hierarchical_average | number | Mean of 5 hierarchical scores |
| mode_dominance_score | number | 0 = egalitarian · 100 = hierarchical |
| dominant_mode_label | enum | egalitarian | hierarchical | balanced |
| demographics_snapshot | object | position, age, industry, experience |
| submitted_at | ISO 8601 | Submission timestamp |