Queries Around Report Mapping Logic For US FDA VAERS Form - Some fields are printing UNKNOWN (Doc ID 2625566.1)

Last updated on JULY 13, 2023

Applies to:

Goal

Queries around report mapping logic for US FDA VAERS Form

After validating US FDA VAERS form it was noted a few discrepancies which are not explained in the Report Mapping Document (Reports TRM). Examples below:

1. Field 'PATIENT NAME FIELD'

This Field in Report Form has below detailed description in TRM:

If empty, this currently prints “Unknown”, however this is not mentioned in TRM notes above.

2. VACCINE ADMINISTERED BY NAME FIELD
 

This Field in Report Form has below detailed description in TRM:

If empty, this currently prints “Unknown”, however this is not mentioned in TRM per above.

3. VACCINE ADMINISTERED BY RESPONSIBLE PHYSICIAN FIELD

This Field in Report Form has below detailed description in TRM:

If empty, this currently prints “Unknown”, however this is not mentioned in TRM per above.

4. VACCINE ADMINISTERED BY FACILITY NAME/ADDRESS FIELD

This Field in Report Form has below detailed description in TRM:

If empty, this currently prints “Unknown”, however this is not mentioned in TRM per above.

5. VACCINE ADMINISTERED BY PHONE FIELD

This Field in Report Form has below detailed description in TRM:

If empty, this currently prints “Unknown”, however this is not mentioned in TRM per above.

6. REPORTER STATE FIELD

 This Field in Report Form has below detailed description in TRM:

Currently it is coded by design to set this to "Unknown" when no data provided (and protect confidentiality unchecked), however this is not mentioned in TRM per above.

7. COUNTY WHERE ADMINISTERED FIELD

This Field in Report Form has below detailed description in TRM:

If empty, this currently prints “Unknown”, however this is not mentioned in TRM per above.

8. PATIENT AGE FIELD

This Field in Report Form has below detailed description in TRM:

• However, when data is entered in Case Form for this field i.e.
• [Patient]
• [Patient]
  
• Date of Birth e.g. 11-MAY-1987, Age is 32 Years, Age Group Adult
• When print FDA VAERS report for this case "Unknown" is printed instead of Age supplied for case
  

9. DATE OF VACCINATION FIELD

This Field in Report Form has below detailed description in TRM:

In above there is no mention of value in form when no data is supplied for this field (date or time)

Currently this populates as "UNKNOWN" by design per other fields

10. ADVERSE EVENT ONSET FIELD

This Field in Report Form has below detailed description in TRM:

However no mention of value in form when no data is supplied for this field (i.e. neither date or time)

Currently this populates as "UNKNOWN" by design per other fields

11. VACCINATED AT FIELD

This Field in Report Form has below detailed description in TRM:

However no mention of value that should be in form when no data is supplied for this field

Currently this populates as "OTHER/UNKNOWN" by design per other fields

12. PURCHASED WITH FIELD

This Field in Report Form has below detailed description in TRM:

However no mention of value that should be in form when no data is supplied for this field

Currently this populates as "OTHER/UNKNOWN" by design per other fields

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.