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

VIEW: APPS.IES_SVY_LIST_ENTRY_SUMM_V

Object Details
Object Name: IES_SVY_LIST_ENTRY_SUMM_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

View Type

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


This is a view on IES_SVY_LIST_ENTRY_SUMM table


[View Source]

Columns
Name Datatype Length Mandatory Comments
SURVEY_ID NUMBER

Foreign key to IES_SVY_SURVEYS_V
SURVEY_NAME VARCHAR2 (80)
Survey Name
SURVEY_CYCLE_ID NUMBER

Foreign Key to IES_SVY_CYCLES_V
SURVEY_CYCLE_NAME VARCHAR2 (80)
Cycle Name
SURVEY_DEPLOYMENT_ID NUMBER

Foreign Key to IES_SVY_DEPLYMNTS_V
DEPLOYMENT_NAME VARCHAR2 (80)
Deployment Name
MINIMUM_RESPONSE_PERCENT NUMBER

This is the Target Response percent from the deployment.
LIST_ENTRY_ID NUMBER

Foreign key to IES_AMS_LIST_ENTRIES_V
LIST_HEADER_ID NUMBER

Foreign key to IES_AMS_LIST_HEADERS_V
RESPONSE_DATE DATE

The date on which the response was received.
NO_RESPONSES NUMBER

Total no of responses received
NO_SENT NUMBER

Total no of invitations sent
NO_ERRORS NUMBER

Total no of errors
Query Text

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


SELECT SURVEY_ID
,      SURVEY_NAME
,      SURVEY_CYCLE_ID
,      SURVEY_CYCLE_NAME
,      SURVEY_DEPLOYMENT_ID
,      DEPLOYMENT_NAME
,      MINIMUM_RESPONSE_PERCENT
,      LIST_ENTRY_ID
,      LIST_HEADER_ID
,      RESPONSE_DATE
,      NO_RESPONSES
,      NO_SENT
,      NO_ERRORS
FROM APPS.IES_SVY_LIST_ENTRY_SUMM_V;

Dependencies

[top of page]

APPS.IES_SVY_LIST_ENTRY_SUMM_V references the following:

SchemaAPPS
SynonymIES_SVY_LIST_ENTRY_SUMM

APPS.IES_SVY_LIST_ENTRY_SUMM_V is not referenced by any database object