eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: IES.IES_SVY_QUES_DATA

Object Details

Object Name:	IES_SVY_QUES_DATA
Object Type:	TABLE
Owner:	IES
Subobject Name:
Status:	VALID

stores summary information about survey question freq

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IES_SVY_QUES_DATA_N1	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	SURVEY_ID
IES_SVY_QUES_DATA_N2	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	SURVEY_NAME

Columns

Name	Datatype	Length	Comments
SURVEY_ID	NUMBER		Unique Identifier for each survey
SURVEY_NAME	VARCHAR2	(80)	Name of Survey
SURVEY_DEPLOYMENT_ID	NUMBER		Unique Identifier for each deployment (foreign key on ies_svy_deplyments_all)
DEPLOYMENT_NAME	VARCHAR2	(256)	Name of Deployment in a cycle
DSCRIPT_ID	NUMBER		Unique Id for Deployed Scripts
DSCRIPT_NAME	VARCHAR2	(256)	Deployed script name
PANEL_ID	NUMBER		Unique identifier for Panel
PANEL_NAME	VARCHAR2	(256)	Name of Panel
QUESTION_ID	NUMBER		Unique Identifier for Question
QUESTION_NAME	VARCHAR2	(256)	Name of Question
LOOKUP_ID	NUMBER		Unique Identifier for lookups
ANSWER_ID	NUMBER		Unique Identifier for Answer
ANSWER_VALUE	VARCHAR2	(256)	Value of Answer
ANSWER_DISPLAY_VALUE	VARCHAR2	(256)	Displayed Answer Value
ANSWER_COUNT	NUMBER		Sum of answers answered
SECURITY_GROUP_ID	NUMBER	(15)	Used for Hosted Environment
QUESTION_TYPE	VARCHAR2	(240)	Type of the question
SURVEY_CYCLE_ID	NUMBER		Unique identifier for survey cycle
QUESTION_ORDER	NUMBER		Sequence of question in survey
ANSWER_ORDER	NUMBER		Sequence of the Answer
CYCLE_NAME	VARCHAR2	(80)	Name of the survey cycle

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT SURVEY_ID
,      SURVEY_NAME
,      SURVEY_DEPLOYMENT_ID
,      DEPLOYMENT_NAME
,      DSCRIPT_ID
,      DSCRIPT_NAME
,      PANEL_ID
,      PANEL_NAME
,      QUESTION_ID
,      QUESTION_NAME
,      LOOKUP_ID
,      ANSWER_ID
,      ANSWER_VALUE
,      ANSWER_DISPLAY_VALUE
,      ANSWER_COUNT
,      SECURITY_GROUP_ID
,      QUESTION_TYPE
,      SURVEY_CYCLE_ID
,      QUESTION_ORDER
,      ANSWER_ORDER
,      CYCLE_NAME
FROM IES.IES_SVY_QUES_DATA;

Dependencies

[top of page]

IES.IES_SVY_QUES_DATA does not reference any database object

IES.IES_SVY_QUES_DATA is referenced by following:

APPS: IES_SVY_QUES_DATA