Data Model Meeting Decision (2026-06-03): Add a new Conditional field "age_at_sociodem_collection_missing_reason"

[hknahal]

Background/Challenge

The age_at_sociodem_collection field is required in the data model, but it is not collected by some projects and the current data model does not currently allow missing or unknown values for these fields. For example, MOHCCN did collect age_at_sociodem_collection at all and this field does not allow projects to submit missing/unknown terms.

Decision

As discussed with Claude and Amirah from WG3, we will add a new field called age_at_sociodem_collection_missing_reason as follows:

Field	Requirements	Field Description	Type	Permissible Values
age_at_sociodem_collection_missing_reason	Conditional	If “age_at_sociodemo_collection” is not submitted, select the appropriate missing term indicating the reason for the missing value.	string	Missing - Unknown, Missing - Not collected, Missing - Not provided, Missing - Restricted access

• This field will be conditionally required only if “age_at_sociodem_collection” is left empty, so it provides context as to why the required field is missing.
• Implement conditional validation logic between the two fields:
  1. If “age_at_sociodem_collection” is not provided, then “age_at_sociodem_collection_missing_reason” becomes required.
  2. Both fields cannot be populated at the same time.

Rationale:

This will unblock MOHCCN and allow them to leave the required “age_at_sociodemo_collection” field empty since they do not have any data for this field.

Meeting Notes:

• Summary of Clarifications/Decisions from Working Group 3: Agenda & Discussion Notes - 2026-06-01
• Full Data Model WG agenda and discussion notes here: WG Agenda & Discussion Notes - 2026-06-03