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.

VIEW: IES.IES_SVY_SUMMARY_STATS#

Source

View Text - Preformatted


select SURVEY_ID SURVEY_ID, SURVEY_CYCLE_ID SURVEY_CYCLE_ID, SURVEY_DEPLOYMENT_ID SURVEY_DEPLOYMENT_ID, SURVEY_NAME SURVEY_NAME, SURVEY_CYCLE_NAME SURVEY_CYCLE_NAME, SURVEY_DEPLOYMENT_NAME SURVEY_DEPLOYMENT_NAME, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, DEPLOY_DATE DEPLOY_DATE, RESPONSE_END_DATE RESPONSE_END_DATE, MEDIA_TYPE_CODE MEDIA_TYPE_CODE, LIST_HEADER_ID LIST_HEADER_ID, LIST_NAME LIST_NAME, TOTAL_NO_SENT TOTAL_NO_SENT, TOTAL_NO_ERRORS TOTAL_NO_ERRORS, TOTAL_NO_RESPONSES_RECD TOTAL_NO_RESPONSES_RECD, REFRESH_DATE REFRESH_DATE, F_DELETEDFLAG F_DELETEDFLAG, SECURITY_GROUP_ID SECURITY_GROUP_ID, DEPLOYMENT_STATUS DEPLOYMENT_STATUS, SURVEY_STATUS SURVEY_STATUS, TOTAL_ABANDONED TOTAL_ABANDONED, TOTAL_ABORTED TOTAL_ABORTED from "IES"."IES_SVY_SUMMARY_STATS"

View Text - HTML Formatted

SELECT SURVEY_ID SURVEY_ID
, SURVEY_CYCLE_ID SURVEY_CYCLE_ID
, SURVEY_DEPLOYMENT_ID SURVEY_DEPLOYMENT_ID
, SURVEY_NAME SURVEY_NAME
, SURVEY_CYCLE_NAME SURVEY_CYCLE_NAME
, SURVEY_DEPLOYMENT_NAME SURVEY_DEPLOYMENT_NAME
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, DEPLOY_DATE DEPLOY_DATE
, RESPONSE_END_DATE RESPONSE_END_DATE
, MEDIA_TYPE_CODE MEDIA_TYPE_CODE
, LIST_HEADER_ID LIST_HEADER_ID
, LIST_NAME LIST_NAME
, TOTAL_NO_SENT TOTAL_NO_SENT
, TOTAL_NO_ERRORS TOTAL_NO_ERRORS
, TOTAL_NO_RESPONSES_RECD TOTAL_NO_RESPONSES_RECD
, REFRESH_DATE REFRESH_DATE
, F_DELETEDFLAG F_DELETEDFLAG
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, DEPLOYMENT_STATUS DEPLOYMENT_STATUS
, SURVEY_STATUS SURVEY_STATUS
, TOTAL_ABANDONED TOTAL_ABANDONED
, TOTAL_ABORTED TOTAL_ABORTED
FROM "IES"."IES_SVY_SUMMARY_STATS"