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]

VIEW: APPS.IES_SVY_SUMMARY_STATS_V

Object Details

Object Name:	IES_SVY_SUMMARY_STATS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IES.IES_SVY_SUMMARY_STATS_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

View on IES_SVY_SUMMARY_STATS table

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
SURVEY_ID	NUMBER		Yes	Unique id for Survey. Foreign Key to IES_SVY_SURVEYS_V.SURVEY_ID
SURVEY_CYCLE_ID	NUMBER		Yes	Unique identifier for IES_SVY_SURVEY_CYCLES_V
SURVEY_DEPLOYMENT_ID	NUMBER		Yes	Unique identifier for deployment_id FK IES_SVY_DEPLYMENTS_V survey_deployment_id
SURVEY_NAME	VARCHAR2	(80)		Survey Name
SURVEY_CYCLE_NAME	VARCHAR2	(80)		Survey Cycle Name
SURVEY_DEPLOYMENT_NAME	VARCHAR2	(80)		Survey Deployment Name
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	Object version number required for HTML interfaces
DEPLOYMENT_STATUS	VARCHAR2	(30)		Status of the deployment
SURVEY_STATUS	VARCHAR2	(30)		Status of the survey
TOTAL_ABANDONED	NUMBER			Number of abandoned responses
TOTAL_ABORTED	NUMBER			Number of aborted responses.
DEPLOY_DATE	DATE		Yes	Deployment Date
RESPONSE_END_DATE	DATE		Yes	Response End Date
MEDIA_TYPE_CODE	VARCHAR2	(30)	Yes	Media Type Web or Call Center
LIST_HEADER_ID	NUMBER			List Header Id
LIST_NAME	VARCHAR2	(240)		List Name
TOTAL_NO_SENT	NUMBER	(10)		To number of invitations sent
TOTAL_NO_ERRORS	NUMBER	(10)		Total number of errors
TOTAL_NO_RESPONSES_RECD	NUMBER	(10)	Yes	Total number of responses received
REFRESH_DATE	DATE			Refresh Date
F_DELETEDFLAG	VARCHAR2	(1)		Used by AOM for soft delete

Query Text

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


SELECT SURVEY_ID
,      SURVEY_CYCLE_ID
,      SURVEY_DEPLOYMENT_ID
,      SURVEY_NAME
,      SURVEY_CYCLE_NAME
,      SURVEY_DEPLOYMENT_NAME
,      OBJECT_VERSION_NUMBER
,      DEPLOYMENT_STATUS
,      SURVEY_STATUS
,      TOTAL_ABANDONED
,      TOTAL_ABORTED
,      DEPLOY_DATE
,      RESPONSE_END_DATE
,      MEDIA_TYPE_CODE
,      LIST_HEADER_ID
,      LIST_NAME
,      TOTAL_NO_SENT
,      TOTAL_NO_ERRORS
,      TOTAL_NO_RESPONSES_RECD
,      REFRESH_DATE
,      F_DELETEDFLAG
FROM APPS.IES_SVY_SUMMARY_STATS_V;

Dependencies

[top of page]

APPS.IES_SVY_SUMMARY_STATS_V references the following:

APPS: IES_SVY_SUMMARY_STATS

APPS.IES_SVY_SUMMARY_STATS_V is referenced by following:

APPS: IES_SURVEY_SUMMARY - show dependent code