[Home] [Help] [Dependency Information]
Object Name: | IES_SVY_QUES_DATA_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This is a view on IES_SVY_QUES_DATA table
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SURVEY_ID | NUMBER | Unique Identifier for Question Data | ||
SURVEY_NAME | VARCHAR2 | (80) | Survey Campaign Name | |
SURVEY_CYCLE_ID | NUMBER | Identifier for the survey cycle | ||
CYCLE_NAME | VARCHAR2 | (80) | Survey cycle name | |
SURVEY_DEPLOYMENT_ID | NUMBER | Foreign key on IES_SVY_DEPLYMENTS_V | ||
DEPLOYMENT_NAME | VARCHAR2 | (256) | Survey Campaign Deployment Name | |
DSCRIPT_ID | NUMBER | Foreign key to IES_DEPLOYED_SCRIPTS | ||
DSCRIPT_NAME | VARCHAR2 | (256) | Script Name | |
PANEL_ID | NUMBER | Foreign Key to IES_PANELS | ||
PANEL_NAME | VARCHAR2 | (256) | Panel Name | |
QUESTION_ID | NUMBER | Foreign key to IES_QUESTIONS | ||
QUESTION_NAME | VARCHAR2 | (256) | Question Name | |
QUESTION_TYPE | VARCHAR2 | (240) | Type of the question | |
QUESTION_ORDER | NUMBER | Order sequence of the question | ||
LOOKUP_ID | NUMBER | Foreign key to IES_LOOKUPS | ||
ANSWER_ID | NUMBER | Foreign key to IES_ANSWERS | ||
ANSWER_ORDER | NUMBER | Order sequence of the answer | ||
ANSWER_VALUE | VARCHAR2 | (256) | Answer value | |
ANSWER_DISPLAY_VALUE | VARCHAR2 | (256) | Answer display value | |
ANSWER_COUNT | NUMBER | Total answer count |
Cut, paste (and edit) the following text to query this object:
SELECT SURVEY_ID
, SURVEY_NAME
, SURVEY_CYCLE_ID
, CYCLE_NAME
, SURVEY_DEPLOYMENT_ID
, DEPLOYMENT_NAME
, DSCRIPT_ID
, DSCRIPT_NAME
, PANEL_ID
, PANEL_NAME
, QUESTION_ID
, QUESTION_NAME
, QUESTION_TYPE
, QUESTION_ORDER
, LOOKUP_ID
, ANSWER_ID
, ANSWER_ORDER
, ANSWER_VALUE
, ANSWER_DISPLAY_VALUE
, ANSWER_COUNT
FROM APPS.IES_SVY_QUES_DATA_V;
|
|
|