How Age Fields are Calculated

Vault Safety automatically calculates and populates the Age (normalized), Age at Onset, and Age Group fields

Sections in this article

About Auto-Calculated Age Fields

This article clarifies how Vault Safety calculates the following Age fields:

  • Age (normalized) (age_normalized_year__v)
  • Age at Onset (age_value__v)
  • Age Group (age_group__v)

Age (Normalized)

Vault Safety automatically calculates the Age (normalized) field in the Case Patient section when the required data points are available:

  • The Case Date of Birth
  • The Case Adverse Event Event Onset. If an Event Onset is not available, the system uses the Case Receipt Date.

    Note If there are multiple Case Adverse Events, the system uses the earliest event to calculate the age. For fetal adverse events, the system uses the event closest to the birth date.

If an Age at Onset value and unit already exists on the Case (for example, from E2B import), the system uses this value to populate the Age (normalized), converted to years.

Note The Age (normalized) field does not appear by default and an administrator must add it to the Case page layout.

Age at Onset

Once the system automatically calculates Age (normalized), it populates the equivalent value to Age at Onset.

Age Group

The system determines and automatically populates the patient’s Age Group depending on the Age at Onset:

Age Group Age at Onset
Fetus 0 weeks/days/hours/minutes old
Neonate More than 0 to less than 4 weeks old
Infant 4 weeks to less than 12 months old
Child 1 year to less than 12 years old
Adolescent 12 years to less than 18 years old
Adult 18 years to less than 65 years old
Elderly 65 years and older

How to Trigger Auto-Calculation of Age Fields

When you add or update the relevant fields on the Case or the Case Adverse Event, the system recalculates the Age (normalized).

Once Age at Onset is populated, the system calculates the Age Group based on this field.

Age (Normalized), Age at Onset, and Age Group Diagrams

The following diagrams show how the system auto-calculates the Age (normalized), Age at Onset, and the Age Group fields using the date intervals between the patient’s Date of Birth and the Adverse Event Event Onset.

Scenario 1: Age (Normalized) Populates Age at Onset

Age (normalized) and Age at Onset Scenario A
Age (normalized) and Age at Onset Scenario A
  • 1The Case contains a Date of Birth and Event Onset value but no Age at Onset.
  • 2The system automatically calculates Age (normalized) and uses this value to populate Age at Onset. The system then uses the Age at Onset value to calculate Age Group.

Scenario 2: Age at Onset Populates Age (Normalized)

Age (normalized) and Age at Onset Scenario B
Age (normalized) and Age at Onset Scenario B
  • 1The Case contains an Age at Onset value (from E2B import) and no Date of Birth or Event Onset value.
  • 2The system automatically uses the Age at Onset field value to populate Age Group and Age (normalized), converting it into “years” if not already.

Scenario 3: Override Age at Onset

Age (normalized) and Age at Onset Scenario C
Age (normalized) and Age at Onset Scenario C
  • 1The Case contains a Date of Birth and Event Onset value but no Age at Onset.
  • 2The system automatically calculates Age (normalized) and uses this value to populate Age at Onset. The system then uses the Age at Onset value to calculate Age Group.
  • 3You can override the Age at Onset by manually entering a value in this field. After saving the Case, the system retains this Age at Onset value and uses it to re-populate Age (normalized) and Age Group.

Scenario 4: Override Age (Normalized)

Age (normalized) and Age at Onset Scenario D
Age (normalized) and Age at Onset Scenario D
  • 1The Case contains an Age at Onset value (from E2B import) as well as a Date of Birth and Event Onset value.
  • 2The system automatically uses the Age at Onset field value to populate Age Group and Age (normalized), converting it into “years” if not already.
  • 3You can override the Event Onset by manually entering a value in this field.
  • 4After saving the Case, the system re-calculates the Age (normalized) field and re-populates the Age at Onset with this value. The system then uses the Age at Onset value to calculate Age Group.
    Note that overriding the Date of Birth value in step 3 also results in the the system re-calculating Age (normalized).

Auto-Calculations Field Reference
How Case Relatedness is Calculated
Feedback?