[Home] [Help] [Dependency Information]
Object Name: | IES_SVY_LIST_SUMMARY_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This is a view on IES_SVY_LIST_SUMMARY table
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 |
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;
|
|
|