Values for column SECOND_PASS_INDICATOR in RESPONSES table (Doc ID 2119692.1)

Last updated on DECEMBER 03, 2019

Applies to:

Goal

More information about the values for column SECOND_PASS_INDICATOR in table RXC.RESPONSES.
The structure of the table is as shown below.
Name Null Type
---------------------------- -------- -------------
RESPONSE_ID NOT NULL NUMBER(15)
RESPONSE_ENTRY_TS NOT NULL DATE
ENTERED_BY NOT NULL VARCHAR2(30)
RECEIVED_DCM_ID NOT NULL NUMBER(10)
DCM_QUESTION_ID NOT NULL NUMBER(10)
DCM_QUESTION_GROUP_ID NOT NULL NUMBER(10)
CLINICAL_STUDY_ID NOT NULL NUMBER(10)
REPEAT_SN NOT NULL NUMBER(3)
END_TS NOT NULL DATE
VALIDATION_STATUS NOT NULL VARCHAR2(3)
SECOND_PASS_INDICATOR VARCHAR2(1)
VALUE_TEXT VARCHAR2(200)
DISCREPANCY_INDICATOR VARCHAR2(1)
DATA_CHANGE_REASON_TYPE_CODE VARCHAR2(15)
DATA_COMMENT_TEXT VARCHAR2(200)
AUDIT_COMMENT_TEXT VARCHAR2(200)
EXCEPTION_VALUE_TEXT VARCHAR2(200)

Questions:
1. Why there are different values for this column SECOND_PASS_INDICATOR in OC?
2. If there is any impact for these different values of SECOND_PASS_INDICATOR to the information in OC?
3. Is there any settings for this column SECOND_PASS_INDICATOR in admin module in OC?
 

Solution

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