Inclusion of new fields (Enhancement 31232390)
The following Oracle Argus Mart Signal Mart (SM) tables have been modified as a result of changes in the Oracle Argus Safety tables:
Table | Column | Description |
---|---|---|
SM_PRODUCT | AUTH_REPRESENTATIVE_VE | Identifies the authorized representative of the product. |
SM_PRODUCT | AUTH_REPRESENTATIVE_V2 | Store the Japanese value of the authorized representative. |
SM_PRODUCT | MFDS_PRODUCT_CODE | Store a 9-digit unique code per product licensed in South Korea. |
SM_PRODUCT | MFDS_PRODUCT_CODE_SU | Stores the value as blinded or non-blinded for the study case based on unblinding status. |
SM_EVENT_PRODUCT | IMDRF_CODE | Defines clinical sign IMDRF code. |
SM_EVENT_PRODUCT | REVISION | Stores revision number of the datasheet used for the event assessment. |
SM_INGREDIENTS | MFDS_INGREDIENT_CODE | It is 7-digit unique code per Ingredient assigned by South Korea MFDS. |
SM_INGREDIENTS | MFDS_INGREDIENT_CODE_SU | Field is used to store blinded/non-blinded value based on case study. |
SM_PAT_HIST | MFDS_PRODUCT_CODE | MFDS Product Code, It is 9-digit unique code per product licensed in South Korea. |
SM_PREGNANCY | PREG_AT_VACCINE_VE |
Pregnancy at the time of Vaccination 0-No 1-Yes 2-Unknown |
SM_PREGNANCY | PREG_AT_VACCINE_V2 | Pregnancy at the time of Vaccination Japanese decode values. |
Parent topic: Enhancements to Oracle Argus Mart