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.

[Home] [Help]

View: IES_SVY_SUMMARY_STATS_V

Product:	IES - Scripting
Description:
Implementation/DBA Data:	APPS.IES_SVY_SUMMARY_STATS_V

View Text

SELECT SSS.SURVEY_ID SURVEY_ID
, SSS.SURVEY_CYCLE_ID SURVEY_CYCLE_ID
, SSS.SURVEY_DEPLOYMENT_ID SURVEY_DEPLOYMENT_ID
, SSS.SURVEY_NAME SURVEY_NAME
, SSS.SURVEY_CYCLE_NAME SURVEY_CYCLE_NAME
, SSS.SURVEY_DEPLOYMENT_NAME SURVEY_DEPLOYMENT_NAME
, SSS.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, SSS.DEPLOY_DATE DEPLOY_DATE
, SSS.RESPONSE_END_DATE RESPONSE_END_DATE
, SSS.MEDIA_TYPE_CODE MEDIA_TYPE_CODE
, SSS.LIST_HEADER_ID LIST_HEADER_ID
, SSS.LIST_NAME LIST_NAME
, SSS.TOTAL_NO_SENT TOTAL_NO_SENT
, SSS.TOTAL_NO_ERRORS TOTAL_NO_ERRORS
, SSS.TOTAL_NO_RESPONSES_RECD TOTAL_NO_RESPONSES_RECD
, SSS.REFRESH_DATE REFRESH_DATE
, SSS.F_DELETEDFLAG F_DELETEDFLAG
, SSS.SECURITY_GROUP_ID SECURITY_GROUP_ID
FROM IES_SVY_SUMMARY_STATS SSS

Columns

Name
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