[Home] [Help] [Dependency Information]
Object Name: | IES_SVY_LIST_ENTRY_SUMM |
---|---|
Object Type: | TABLE |
Owner: | IES |
Subobject Name: | |
Status: | VALID |
This table is joined with IES_AMS_LIST_ENTRIES_V and provides the ability to slice and dice by various list entry attributes like city, state , zip etc.
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IES_SVY_LST_ENT_SUMM_N1 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY | SURVEY_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SURVEY_ID | NUMBER | Unique Identifier for each survey | ||
SURVEY_NAME | VARCHAR2 | (80) | Name of Survey | |
SURVEY_CYCLE_ID | NUMBER | Unique Identifier for each cycle of survey (Foriegn key on ies_svy_cycles_all) | ||
SURVEY_CYCLE_NAME | VARCHAR2 | (80) | Name of cycle in survey | |
SURVEY_DEPLOYMENT_ID | NUMBER | Unique Identifier for each deployment (foreign key on ies_svy_deplyments_all) | ||
DEPLOYMENT_NAME | VARCHAR2 | (80) | Name of Deployment in a cycle | |
LIST_ENTRY_ID | NUMBER | Unique Identifier for List Entry | ||
LIST_HEADER_ID | NUMBER | Unique identifier for List Header (foreign key to | ||
RESPONSE_DATE | DATE | Date of Response | ||
MINIMUM_RESPONSE_PERCENT | NUMBER | Lowest Percentage at which survey is considered successfully deployed | ||
NO_RESPONSES | NUMBER | Total number of responses | ||
NO_ERRORS | NUMBER | Total Number of errors | ||
NO_SENT | NUMBER | Total number of respondents the survey was sent too. | ||
SECURITY_GROUP_ID | NUMBER | (15) | Used for Hosted Environment |
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_ENTRY_ID
, LIST_HEADER_ID
, RESPONSE_DATE
, MINIMUM_RESPONSE_PERCENT
, NO_RESPONSES
, NO_ERRORS
, NO_SENT
, SECURITY_GROUP_ID
FROM IES.IES_SVY_LIST_ENTRY_SUMM;
IES.IES_SVY_LIST_ENTRY_SUMM does not reference any database object
IES.IES_SVY_LIST_ENTRY_SUMM is referenced by following:
|
|
|