[Home] [Help] [Dependency Information]
Object Name: | IES_SVY_FOOTPRINT_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 a join with ies_transactions, ies_panels, ies_panel_data, ies_footprinting_data. It gathers data for footprinting report.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DSCRIPT_ID | NUMBER | Yes | Foreign Key to IES_DEPLOYED_SCRIPTS | |
TRANSACTION_ID | NUMBER | Yes | Foreign key to IES_TRANSACTIONS | |
START_TIME | DATE | Time the script was started | ||
PANEL_NAME | VARCHAR2 | (256) | Yes | Name of the Panel |
PANEL_ID | NUMBER | Yes | Foreign Key to IES_PANEL | |
TOTAL_TIME | NUMBER | Total Time spent on that panel | ||
NUM_PANEL_DATA_ID | NUMBER | Foreign key to IES_PANEL_DATA | ||
MIN_TIME | NUMBER | Minimum time spent on this panel across all run of the script | ||
MAX_TIME | NUMBER | Maximum time spent on this panel across all run of the script |
Cut, paste (and edit) the following text to query this object:
SELECT DSCRIPT_ID
, TRANSACTION_ID
, START_TIME
, PANEL_NAME
, PANEL_ID
, TOTAL_TIME
, NUM_PANEL_DATA_ID
, MIN_TIME
, MAX_TIME
FROM APPS.IES_SVY_FOOTPRINT_V;
APPS.IES_SVY_FOOTPRINT_V is not referenced by any database object
|
|
|