Differences In LAM_DEATH.AUTOPSY_DONE Between Argus 5 And 7 (Doc ID 2104340.1)

Last updated on JULY 13, 2023

Applies to:

Goal

Differences in LAM_DEATH.AUTOPSY_DONE between Argus 5 and 7

The factory data provided in Argus 7 are different from Argus 5 and from Argus 7 System documentation .

Due to this there is potential that Legacy data entered in Field 'Autopsy done?' will be displayed in Argus 7 incorrectly

Steps to Reproduce:

AS 5.1.3.5

•  [Local Affiliate]
• Create Local Event
• Add an event e.g. 'Back Pain'
• Navigate to 'Event Information'
• Check [x]Death and click on [Details]
• Options for Autopsy Done? are:
• Yes, No, Unknown
• If enter 'Yes', this saves a value of '1' In table LAM_DEATH.AUTOPSY_DONE
• If enter 'No', this saves a value of '0' In table LAM_DEATH.AUTOPSY_DONE
• If enter 'Unknown', this saves a value of '2' In table LAM_DEATH.AUTOPSY_DONE

This matches the below (mentioned in the 7.0.x documentation):

AUTOPSY_DONE, NUMBER, YES, 22.0, 1=YES, 0=NO, 2=UNKNOWN

AS 7.0.2

• [Local Affiliate]
• Create Local Event
• Add an event e.g. 'Back Pain'
• Navigate to 'Event Information'
• Check [x]Death
• Navigate to 'Death Information'
• Add Autopsy Done = Yes, This saves a value of '2' In table LAM_DEATH.AUTOPSY_DONE
• If enter 'No', this saves a value of '1' In table LAM_DEATH.AUTOPSY_DONE
• If enter 'Unknown', this saves a value of '3' In table LAM_DEATH.AUTOPSY_DONE
• If enter no value at all, this saves a value of '0' in table LAM_DEATH.AUTOPSY_DONE

According to documentation and Argus_column_comments_LAM.sql the valid values should be:

COMMENT ON COLUMN LAM_DEATH.AUTOPSY_DONE IS '1=Yes, 0=No, 2=Unknown';

Solution

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