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

VIEW: APPS.IES_SVY_LIST_SUMMARY_V

Object Details
Object Name: IES_SVY_LIST_SUMMARY_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_SUMMARY table


[View Source]

Columns
Name Datatype Length Mandatory Comments
SURVEY_ID NUMBER

Unique Identifier for survey. IES_SVY_SURVEYS_V.SURVEY_ID
SURVEY_NAME VARCHAR2 (80)
Survey Name
SURVEY_CYCLE_ID NUMBER

Unique identifier for survey cycle. FK to IES_SVY_CYCLES_V
SURVEY_CYCLE_NAME VARCHAR2 (240)
Survey Cycle Name
SURVEY_DEPLOYMENT_ID NUMBER

Unique identifier for survey deployment. FK to IES_SVY_DEPLYMENTS_V.survey_deployment_id
DEPLOYMENT_NAME VARCHAR2 (240)
Deployment Name
LIST_HEADER_ID NUMBER

Unique identifier for list. FK to ams_list_headers_all.list_header_id
TARGET_RESPONSE_PERCENT NUMBER

No of responses received.
RESPONSE_DATE DATE

Date the responses were received.
LIST_NAME VARCHAR2 (240)
Name of the List
NO_SENT NUMBER

Number of emails sent
NO_RESPONSES NUMBER

Number responses received
NO_ERRORS NUMBER

Number 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
,      LIST_HEADER_ID
,      TARGET_RESPONSE_PERCENT
,      RESPONSE_DATE
,      LIST_NAME
,      NO_SENT
,      NO_RESPONSES
,      NO_ERRORS
FROM APPS.IES_SVY_LIST_SUMMARY_V;

Dependencies

[top of page]

APPS.IES_SVY_LIST_SUMMARY_V references the following:

SchemaAPPS
SynonymIES_SVY_LIST_SUMMARY
APPS.IES_SVY_LIST_SUMMARY_V is referenced by following:

SchemaAPPS
Package BodyIES_SURVEY_SUMMARY - show dependent code
Package BodyIES_SVY_CREATE_INIT_RECORDS - show dependent code