[Home] [Help] [Dependency Information]
Object Name: | IES_SVY_LIST_ENTRY_SUMM_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_ENTRY_SUMM table
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 |
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;
APPS.IES_SVY_LIST_ENTRY_SUMM_V is not referenced by any database object
|
|
|