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_SUMMARY_STATS

Object Details

Object Name:	IES_SVY_SUMMARY_STATS
Object Type:	TABLE
Owner:	IES
FND Design Data:	IES.IES_SVY_SUMMARY_STATS
Subobject Name:
Status:	VALID

This table contains the summary information of responses per deployment. A summary program sums up informations such as total no of invitaitons and
reminders sent, total no of responses received , total no of errors etc.

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IES_SVY_SUMM_STAT_N1	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	SURVEY_DEPLOYMENT_ID
IES_SVY_SUMM_STAT_N2	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	SURVEY_ID
IES_SVY_SUMM_STAT_N3	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	SURVEY_NAME

Columns

Name	Datatype	Length	Mandatory	Comments
SURVEY_ID	NUMBER		Yes	Unique Identifier for Survey
SURVEY_CYCLE_ID	NUMBER		Yes	Unique Identifier for Cycle
SURVEY_DEPLOYMENT_ID	NUMBER		Yes	Unique Identifier per Deployment
SURVEY_NAME	VARCHAR2	(80)		Name of Survey
SURVEY_CYCLE_NAME	VARCHAR2	(80)		Name of Cycle
SURVEY_DEPLOYMENT_NAME	VARCHAR2	(80)		Name of Deployment
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	Object version number required for HTML interfaces
DEPLOY_DATE	DATE		Yes	Date of deployment of Survey
RESPONSE_END_DATE	DATE		Yes	Last date of deployment before deployment closes
MEDIA_TYPE_CODE	VARCHAR2	(30)	Yes	Type of media on which survey was deployed
LIST_HEADER_ID	NUMBER			Unique Identifier for List (foreign key to AMS_LIST_HEADERS)
LIST_NAME	VARCHAR2	(240)		Name of List from LIST_HEADER_ID
TOTAL_NO_SENT	NUMBER	(10)		Total Number of Invitations sent
TOTAL_NO_ERRORS	NUMBER	(10)		Total Number of Errors per Deployment
TOTAL_NO_RESPONSES_RECD	NUMBER	(10)	Yes	Total Number of Responses per Deployment
REFRESH_DATE	DATE			Date the summary table was last refreshed
F_DELETEDFLAG	VARCHAR2	(1)		Used by AOM for soft Delete
SECURITY_GROUP_ID	NUMBER	(15)		Used in Hosted Environments
DEPLOYMENT_STATUS	VARCHAR2	(30)		Status of the deployment
SURVEY_STATUS	VARCHAR2	(30)		Status of the survey
TOTAL_ABANDONED	NUMBER			Total Abandoned responses
TOTAL_ABORTED	NUMBER			Total Aborted responses.

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
,      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
,      SECURITY_GROUP_ID
,      DEPLOYMENT_STATUS
,      SURVEY_STATUS
,      TOTAL_ABANDONED
,      TOTAL_ABORTED
FROM IES.IES_SVY_SUMMARY_STATS;

Dependencies

[top of page]

IES.IES_SVY_SUMMARY_STATS does not reference any database object

IES.IES_SVY_SUMMARY_STATS is referenced by following:

IES: IES_SVY_SUMMARY_STATS#