My Oracle Support Banner

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

Last updated on JULY 17, 2018

Applies to:

Oracle Clinical - Version 4.6.0 and later
Information in this document applies to any platform.

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


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