OKC_XPRT_QUESTIONS

Details

Schema: FUSION
Object owner: OKC
Object type: TABLE
Tablespace: APPS_TS_TX_DATA

Primary Key

Name	Columns
OKC_XPRT_QUESTIONS_B_PK	QUESTION_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
QUESTION_ID	NUMBER		18	Yes	This is the primary column for the questions and constants table and is sequence generated.
QUESTION_CODE	VARCHAR2	30			QUESTION_CODE
CONDITION_EXPR_CODE	VARCHAR2	30			Indicates whether the conditions on the questions are 'Any True' or 'All True'. Possible values are 'ALL' or 'ANY'. FK to FND lookup OKC_XPRT_CONDITION_EXPRESSION.
QUESTION_TYPE	VARCHAR2	1		Yes	This indicates the question type. FK to FND lookup OKC_XPRT_QUESTION_TYPE. Possible values are Q and C. Q: Question, C: Constant.
QUESTION_INTENT	VARCHAR2	1		Yes	Intent of Question or Constant. B: Buy, S: Sell.
DISABLED_FLAG	VARCHAR2	1		Yes	Indicates if the question or constant is disabled
QUESTION_DATATYPE	VARCHAR2	1		Yes	Indicates response datatype. FK to FND lookup OKC_XPRT_QUESTION_DATATYPE. B: Boolean, N: Numeric, L: List of values.
VALUE_SET_NAME	VARCHAR2	60			The value set corresponding to the question with response type of List of Values. FK to FND value set.
DEFAULT_VALUE	VARCHAR2	200			Value for Questions/Constants. Question value can be a Value id in case of Value set based Questions or Numeric value in case of Numeric Questions. This is mandatory when defining constants.
MINIMUM_VALUE	NUMBER				Not currently used. For a future release
MAXIMUM_VALUE	NUMBER				Not currently used. For a future release
QUESTION_SYNC_FLAG	VARCHAR2	1		Yes	This will be used to indicate if a question needs to be synchronized with Oracle Confiugrator
OBJECT_VERSION_NUMBER	NUMBER		9	Yes	Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.
REQUEST_ID	NUMBER		18		Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
JOB_DEFINITION_NAME	VARCHAR2	100			Enterprise Service Scheduler: indicates the name of the job that created or last updated the row.
JOB_DEFINITION_PACKAGE	VARCHAR2	900			Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row.
MODULE	VARCHAR2	3			MODULE
HEIGHT	NUMBER		2		HEIGHT
WIDTH	NUMBER		2		WIDTH
CONDITIONAL_FLAG	VARCHAR2	1			Indicates if the Question is conditional. Possible values are 'Y', 'N'.
VARIABLE_CODE	VARCHAR2	30			VARIABLE_CODE

Foreign Keys

Table	Foreign Table	Foreign Key Column
okc_xprt_questions_tl	okc_xprt_questions_b	QUESTION_ID
okc_xprt_question_vals_h	okc_xprt_questions_b	QUESTION_ID
okc_xprt_question_orders	okc_xprt_questions_b	QUESTION_ID
okc_xprt_question_vals	okc_xprt_questions_b	QUESTION_ID
okc_xprt_question_conditions	okc_xprt_questions_b	QUESTION_ID

Indexes

Index	Uniqueness	Tablespace	Columns
OKC_XPRT_QUESTIONS_B_N1	Non Unique	Default	QUESTION_TYPE
OKC_XPRT_QUESTIONS_B_N2	Non Unique	Default	VALUE_SET_NAME
OKC_XPRT_QUESTIONS_B_N3	Non Unique	Default	QUESTION_DATATYPE
OKC_XPRT_QUESTIONS_B_N4	Non Unique	Default	QUESTION_CODE
OKC_XPRT_QUESTIONS_B_U1	Unique	Default	QUESTION_ID