[Home] [Help] [Dependency Information]
Object Name: | IES_SVY_LIST_SUMMARY |
---|---|
Object Type: | TABLE |
Owner: | IES |
Subobject Name: | |
Status: | VALID |
This table is joined with IES_AMS_LIST_HEADERS_V and provides the ability to slice and dice by various list attributes like vendor etc.
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IES_SVY_LIST_SUMMARY_N1 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY | SURVEY_ID |
IES_SVY_LIST_SUMMARY_N2 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY | SURVEY_NAME |
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_DEPLOYMENT_ID | NUMBER | Unique Identifier for each deployment (foreign key on ies_svy_deplyments_all) | ||
SURVEY_CYCLE_NAME | VARCHAR2 | (240) | Name of cycle in survey | |
DEPLOYMENT_NAME | VARCHAR2 | (240) | Name of Deployment in a cycle | |
LIST_HEADER_ID | NUMBER | Unique identifier for List Header (foreign key to | ||
TARGET_RESPONSE_PERCENT | NUMBER | Count of lists | ||
RESPONSE_DATE | DATE | Date Response was received | ||
LIST_NAME | VARCHAR2 | (240) | Name of the list | |
NO_SENT | NUMBER | Number Sent | ||
NO_RESPONSES | NUMBER | Number of responses received | ||
NO_ERRORS | NUMBER | Number of errors | ||
SECURITY_GROUP_ID | NUMBER | (15) | Used for the hosted enviroment |
Cut, paste (and edit) the following text to query this object:
SELECT SURVEY_ID
, SURVEY_NAME
, SURVEY_CYCLE_ID
, SURVEY_DEPLOYMENT_ID
, SURVEY_CYCLE_NAME
, DEPLOYMENT_NAME
, LIST_HEADER_ID
, TARGET_RESPONSE_PERCENT
, RESPONSE_DATE
, LIST_NAME
, NO_SENT
, NO_RESPONSES
, NO_ERRORS
, SECURITY_GROUP_ID
FROM IES.IES_SVY_LIST_SUMMARY;
IES.IES_SVY_LIST_SUMMARY does not reference any database object
IES.IES_SVY_LIST_SUMMARY is referenced by following:
|
|
|