Powered by InfoCaptor


Parameters
NoParameterValue
1Date/TimeReport generated on 05-APR-2007 02:32:18
2EUL OwnerALL Values
3EUL PrefixEUL5
4Workbook CreatorALL Values
5BA CreatorALL Values
Version
Version
5.1.1.0.0.0
Business Areas
Business AreaKeyCreatorCreated ByCreation DateUpdated ByLast Update DateNumber Of Times ModifiedBa Id
Video Store TutorialVIDEO_STORE_TUTORIALSYSTEMSYSTEM25-Oct-2006SYSTEM25-Oct-20060100018
Discoverer V5 - OWB LineageOWB_EUL5_LINEAGESYSTEMSYSTEM25-Oct-2006SYSTEM25-Oct-20060100568
The Discoverer V5 EULTHE_DISCOVERER_V5_EULSYSTEMSYSTEM25-Oct-2006SYSTEM25-Oct-20060100570
Video Store Tutorial
Folders
FolderFolder HiddenFolder TypeDescriptionFolder KeyLast UpdatedFolder Id
Alternate Sort DaysHiddenCustomAlternate Sort DaysDC_ALTERNATE_SORT_DAYS25-Oct-2006100033
Alternate Sort Store SizeHiddenCustomAlternate Sort Store SizeDC_ALTERNATE_SORT_STORE_SIZE25-Oct-2006100035
Calendar DateVisibleSimpleCalendar DatesDC_CALENDAR_DATE25-Oct-2006100024
Fiscal DateVisibleSimpleFiscal DatesDC_FISCAL_DATE25-Oct-2006100025
Monthly Sales AnalysisVisibleComplexMonthly Sales AnalysisDC_MONTHLY_SALES_ANALYSIS25-Oct-2006100030
ProductsVisibleSimpleInformation about productsDC_PRODUCT25-Oct-2006100026
Sales FactsVisibleSimpleSales Fact Information DC_SALES_FACT25-Oct-2006100027
StoreVisibleSimpleInformation about storesDC_STORE25-Oct-2006100028
Stores and Sales DetailsVisibleComplexThis folder groups together store and sales detailsDC_STORE_AND_SALES_DETAILS25-Oct-2006100031
Target SalesVisibleSimpleTarget Sales InformationDC_TARGET_SALES25-Oct-2006100029
Video Analysis InformationVisibleComplexThis folder contains commonly used reporting itemsDC_VIDEO_ANALYSIS_INFORMATION25-Oct-2006100032
Alternate Sort Days
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNoneUnknownUnknown
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Alternate Sort Alternate Sort Days.Alternate SortALTERNATE_SORTALTERNATE_SORT100086
Day Of Week Alternate Sort Days.Day Of WeekDAY_OF_WEEKDAY_OF_WEEK100094
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Alternate Sort Store Size
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNoneUnknownUnknown
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Alternate Sort Alternate Sort Store Size.Alternate SortALTERNATE_SORTALTERNATE_SORT100087
Store Size Alternate Sort Store Size.Store SizeSTORE_SIZESTORE_SIZE100113
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Calendar Date
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
Stores and Sales Details, Video Analysis Information, Monthly Sales AnalysisNoneVIDEO5.TIMES25-OCT-2006
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Calendar DayDay in MonthCalendar Date.Transaction Date TRANSACTION_DATE_DAY100184
Calendar MonthMonth in year that transactions took placeCalendar Date.Transaction Date TRANSACTION_DATE_MONTH100186
Calendar QuarterQuarter in year that transactions took placeCalendar Date.Transaction Date TRANSACTION_DATE_QUARTER100194
Calendar YearYear transactions took placeCalendar Date.Transaction Date TRANSACTION_DATE_YEAR100200
Day Of Week Calendar Date.Day Of WeekDAY_OF_WEEKDAY_OF_WEEK100092
Holiday Flag Calendar Date.Holiday FlagHOLIDAY_FLAGHOLIDAY_FLAG100099
Time Key Calendar Date.Time KeyTIME_KEYTIME_KEY100115
Transaction DateDate transactions took placeCalendar Date.Transaction DateTRANSACTION_DATETRANSACTION_DATE100119
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Calendar Date.Time Key -> Sales Facts.Time KeyCalendar Date.Time Key = Sales Facts.Time KeyAlways exist in master folderNoneYes
Calendar Date.Time Key -> Target Sales.Time KeyCalendar Date.Time Key = Target Sales.Time KeyAlways exist in master folderNoneYes
Fiscal Date
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNoneVIDEO5.TIMES25-OCT-2006
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Day Of Week Fiscal Date.Day Of WeekDAY_OF_WEEKDAY_OF_WEEK100093
Fiscal Date Fiscal Date.Transaction Date FISCAL_DATE100138
Fiscal MonthFiscal month in year that transactions took placeFiscal Date.Transaction Date FISCAL_MONTH100140
Fiscal QuarterFiscal quarter in year that transactions took placeFiscal Date.Transaction Date FISCAL_QUARTER100142
Fiscal YearFiscal year transactions took placeFiscal Date.Transaction Date FISCAL_YEAR100144
Holiday Flag Fiscal Date.Holiday FlagHOLIDAY_FLAGHOLIDAY_FLAG100100
Time Key Fiscal Date.Time KeyTIME_KEYTIME_KEY100116
Transaction DateDate transactions took placeFiscal Date.Transaction DateTRANSACTION_DATETRANSACTION_DATE100120
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Fiscal Date.Time Key -> Sales Facts.Time KeyFiscal Date.Time Key = Sales Facts.Time KeyAlways exist in master folderNoneYes
Fiscal Date.Time Key -> Target Sales.Time KeyFiscal Date.Time Key = Target Sales.Time KeyAlways exist in master folderNoneYes
Monthly Sales Analysis
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneVideo Analysis Information, Calendar Date, Products, Sales Facts, StoreVIDEO5.TIMES VIDEO5.PRODUCT VIDEO5.SALES_FACT VIDEO5.STORE25-OCT-2006 25-OCT-2006 25-OCT-2006 25-OCT-2006
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
AUTO_GENERATED_NAMESection of store product can be found e.g. Video Rental, Video Sale, SnacksProducts.Department DEPARTMENT100134
AUTO_GENERATED_NAME 1Sales region e.g. East, West, CentralStore.Region REGION100158
AUTO_GENERATED_NAME 2City location of storeStore.City CITY100126
AUTO_GENERATED_NAME 3Name of StoreStore.Store Name STORE_NAME100178
AUTO_GENERATED_NAME 4Year transactions took placeCalendar Date.Transaction Date TRANSACTION_DATE_YEAR100217
AUTO_GENERATED_NAME 5Quarter in year that transactions took placeCalendar Date.Transaction Date TRANSACTION_DATE_QUARTER100198
AUTO_GENERATED_NAME 6Month in year that transactions took placeCalendar Date.Transaction Date TRANSACTION_DATE_MONTH100192
Average Monthly Sales per Store Sales Facts.Sales AVERAGE_MONTHLY_SALES_PER_STORE100169
Monthly Sales per StoreTotal sales for one store, one product in one daySales Facts.Sales SALES100167
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Products
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
Stores and Sales Details, Video Analysis Information, Monthly Sales AnalysisNoneVIDEO5.PRODUCT25-OCT-2006
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Age Category Products.Age CategoryAGE_CATEGORYAGE_CATEGORY100085
Brand Products.BrandBRANDBRAND100088
DepartmentSection of store product can be found e.g. Video Rental, Video Sale, SnacksProducts.DepartmentDEPARTMENTDEPARTMENT100095
Full DescriptionExample of Product e.g. Video ClipProducts.Full DescriptionFULL_DESCRIPTIONFULL_DESCRIPTION100098
Product CategoryTheme under product type e.g. Action, Drama, Thriller, Sci-FiProducts.Product CategoryPRODUCT_CATEGORYPRODUCT_CATEGORY100101
Product DescriptionDescriptions e.g. Titles of Movies, Video Game TitlesProducts.Product DescriptionDESCRIPTIONDESCRIPTION100096
Product Key Products.Product KeyPRODUCT_KEYPRODUCT_KEY100102
Product Type Products.Product TypePRODUCT_TYPEPRODUCT_TYPE100104
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Products.Product Key -> Sales Facts.Product KeyProducts.Product Key = Sales Facts.Product KeyAlways exist in master folderNoneYes
Sales Facts
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
Stores and Sales Details, Video Analysis Information, Monthly Sales AnalysisNoneVIDEO5.SALES_FACT25-OCT-2006
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
CostTotal cost for one store, one product in one daySales Facts.CostCOSTCOST100090
Customer Count Sales Facts.Customer CountCUSTOMER_COUNTCUSTOMER_COUNT100091
Product Key Sales Facts.Product KeyPRODUCT_KEYPRODUCT_KEY100103
ProfitTotal profit for one store, one product in one daySales Facts.ProfitPROFITPROFIT100105
SalesTotal sales for one store, one product in one daySales Facts.SalesSALESSALES100108
Store Key Sales Facts.Store KeySTORE_KEYSTORE_KEY100109
Time Key Sales Facts.Time KeyTIME_KEYTIME_KEY100117
Unit SalesVolume of product moved for one store, one product in one daySales Facts.Unit SalesUNIT_SALESUNIT_SALES100121
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Store
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
Stores and Sales Details, Video Analysis Information, Monthly Sales AnalysisNoneVIDEO5.STORE25-OCT-2006
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
CityCity location of storeStore.CityCITYCITY100089
Floor Plan Typee.g. Modern, Compact, OriginalStore.Floor Plan TypeFLOOR_PLAN_TYPEFLOOR_PLAN_TYPE100097
RegionSales region e.g. East, West, CentralStore.RegionREGIONREGION100106
ReportsThree months goals for storesStore.ReportsREPORTSREPORTS100107
Store Key Store.Store KeySTORE_KEYSTORE_KEY100110
Store NameName of StoreStore.Store NameSTORE_NAMESTORE_NAME100111
Store SizeTotal square footage of storeStore.Store SizeSTORE_SIZESTORE_SIZE100112
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Store.Store Key -> Sales Facts.Store KeyStore.Store Key = Sales Facts.Store KeyAlways exist in master folderNoneYes
Stores and Sales Details
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneCalendar Date, Products, Sales Facts, StoreVIDEO5.TIMES VIDEO5.PRODUCT VIDEO5.SALES_FACT VIDEO5.STORE25-OCT-2006 25-OCT-2006 25-OCT-2006 25-OCT-2006
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
AUTO_GENERATED_NAMEName of StoreStore.Store Name STORE_NAME100174
AUTO_GENERATED_NAME 1City location of storeStore.City CITY100122
AUTO_GENERATED_NAME 10Year transactions took placeCalendar Date.Transaction Date CALENDAR_YEAR100202
AUTO_GENERATED_NAME 11Month in year that transactions took placeCalendar Date.Transaction Date CALENDAR_MONTH100188
AUTO_GENERATED_NAME 12Total profit for one store, one product in one daySales Facts.Profit PROFIT100152
AUTO_GENERATED_NAME 2Three months goals for storesStore.Reports REPORTS100160
AUTO_GENERATED_NAME 3e.g. Modern, Compact, OriginalStore.Floor Plan Type FLOOR_PLAN_TYPE100146
AUTO_GENERATED_NAME 4Total square footage of storeStore.Store Size STORE_SIZE100180
AUTO_GENERATED_NAME 5Descriptions e.g. Titles of Movies, Video Game TitlesProducts.Product Description DESCRIPTION100136
AUTO_GENERATED_NAME 6Example of Product e.g. Video ClipProducts.Full Description FULL_DESCRIPTION100148
AUTO_GENERATED_NAME 7Section of store product can be found e.g. Video Rental, Video Sale, SnacksProducts.Department DEPARTMENT100130
AUTO_GENERATED_NAME 8Theme under product type e.g. Action, Drama, Thriller, Sci-FiProducts.Product Category PRODUCT_CATEGORY100150
AUTO_GENERATED_NAME 9Date transactions took placeCalendar Date.Transaction Date TRANSACTION_DATE100182
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Target Sales
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNoneVIDEO5.TARGET_SALES25-OCT-2006
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Target SalesTarget sales figuresTarget Sales.Target SalesTARGET_SALESTARGET_SALES100114
Time Key Target Sales.Time KeyTIME_KEYTIME_KEY100118
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Video Analysis Information
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
Monthly Sales AnalysisCalendar Date, Products, Sales Facts, StoreVIDEO5.TIMES VIDEO5.PRODUCT VIDEO5.SALES_FACT VIDEO5.STORE25-OCT-2006 25-OCT-2006 25-OCT-2006 25-OCT-2006
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
AUTO_GENERATED_NAMESection of store product can be found e.g. Video Rental, Video Sale, SnacksProducts.Department DEPARTMENT100132
AUTO_GENERATED_NAME 1Sales region e.g. East, West, CentralStore.Region REGION100156
AUTO_GENERATED_NAME 10Total cost for one store, one product in one daySales Facts.Cost COST100128
AUTO_GENERATED_NAME 2City location of storeStore.City CITY100124
AUTO_GENERATED_NAME 3Name of StoreStore.Store Name STORE_NAME100176
AUTO_GENERATED_NAME 4Year transactions took placeCalendar Date.Transaction Date CALENDAR_YEAR100204
AUTO_GENERATED_NAME 5Quarter in year that transactions took placeCalendar Date.Transaction Date CALENDAR_QUARTER100196
AUTO_GENERATED_NAME 6Month in year that transactions took placeCalendar Date.Transaction Date CALENDAR_MONTH100190
AUTO_GENERATED_NAME 7Total profit for one store, one product in one daySales Facts.Profit PROFIT100154
AUTO_GENERATED_NAME 8Total sales for one store, one product in one daySales Facts.Sales SALES100162
AUTO_GENERATED_NAME 9Volume of product moved for one store, one product in one daySales Facts.Unit Sales UNIT_SALES100219
Margin Percentage Sales Facts.Profit Sales Facts.Sales MARGIN_PERCENTAGE100164
Rank Sales by Year, Dept, RegionThe rank of sales by year, department and regionCalendar Date.Transaction Date Products.Department Store.Region Sales Facts.Sales RANK_SALES_PARTITION_BY_YEAR__REGION100206
Sales BandA grouping of individual sales into rangesSales Facts.Sales SALES_BAND100171
Sales Last YearThe sales for last year based on department, region and city.Sales Facts.Sales Products.Department Store.Region Store.City Calendar Date.Transaction Date SALES_LAST_YR100211
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Folder Filters
Used In ConditionItemBa NameBase ObjectFilter NameFilter TypeFolder Name
DepartmentVideo Store TutorialVIDEO5.PRODUCT.DEPARTMENTDepartment is Video Rental or Video SaleOptionalVideo Analysis Information
Calendar YearVideo Store TutorialVIDEO5.TIMES.TRANSACTION_DATEYear is 1998 or 1999OptionalVideo Analysis Information
Hierarchies
Hierarchy NameCreated ByHierarchy LevelHierarchy Details
Calendar Date HierarchySystem1Calendar Date.Calendar Year
Calendar Date HierarchySystem2 ^------Calendar Date.Calendar Quarter
Calendar Date HierarchySystem3 ^------Calendar Date.Calendar Month
Calendar Date HierarchySystem4 ^------Calendar Date.Calendar Day
Calendar Date HierarchySystem5 ^------Calendar Date.Transaction Date
Fiscal Calendar HierarchyUser1Fiscal Date.Fiscal Year
Fiscal Calendar HierarchyUser2 ^------Fiscal Date.Fiscal Quarter
Fiscal Calendar HierarchyUser3 ^------Fiscal Date.Fiscal Month
Fiscal Calendar HierarchyUser4 ^------Fiscal Date.Transaction Date
Monthly Sales Analysis Calendar Time HierarchyUser1Monthly Sales Analysis.Calendar Year
Monthly Sales Analysis Calendar Time HierarchyUser2 ^------Monthly Sales Analysis.Calendar Quarter
Monthly Sales Analysis Calendar Time HierarchyUser3 ^------Monthly Sales Analysis.Calendar Month
Monthly Sales Analysis Store HierarchyUser1Monthly Sales Analysis.Region
Monthly Sales Analysis Store HierarchyUser2 ^------Monthly Sales Analysis.City
Monthly Sales Analysis Store HierarchyUser3 ^------Monthly Sales Analysis.Store Name
Product HierarchyUser1Products.Product Type
Product HierarchyUser2 ^------Products.Department
Product HierarchyUser3 ^------Products.Product Category
Product HierarchyUser4 ^------Products.Product Description
Store HierarchyUser1Store.Region
Store HierarchyUser2 ^------Store.City
Store HierarchyUser3 ^------Store.Store Name
Video Analysis Calendar Time HierarchyUser1Video Analysis Information.Calendar Year
Video Analysis Calendar Time HierarchyUser2 ^------Video Analysis Information.Calendar Quarter
Video Analysis Calendar Time HierarchyUser3 ^------Video Analysis Information.Calendar Month
Video Analysis Store HierarchyUser1Video Analysis Information.Region
Video Analysis Store HierarchyUser2 ^------Video Analysis Information.City
Video Analysis Store HierarchyUser3 ^------Video Analysis Information.Store Name
Item Classes
Item Class NamePrimary FolderUsed ByAlternate Sort
Alternate Sort Days.Day Of WeekAlternate Sort Days . Day Of WeekCalendar Date . Day Of WeekAlternate Sort Days.Alternate Sort
Alternate Sort Days.Day Of WeekAlternate Sort Days . Day Of WeekFiscal Date . Day Of WeekAlternate Sort Days.Alternate Sort
Alternate Sort Store Size.Store SizeAlternate Sort Store Size . Store SizeAlternate Sort Store Size . Store SizeAlternate Sort Store Size.Alternate Sort
Alternate Sort Store Size.Store SizeAlternate Sort Store Size . Store SizeStore . Store SizeAlternate Sort Store Size.Alternate Sort
Alternate Sort Store Size.Store SizeAlternate Sort Store Size . Store SizeStores and Sales Details . Store SizeAlternate Sort Store Size.Alternate Sort
Calendar Date.Calendar DayCalendar Date . Calendar DayCalendar Date . Calendar Day.
Calendar Date.Calendar MonthCalendar Date . Calendar MonthCalendar Date . Calendar Month.
Calendar Date.Calendar MonthCalendar Date . Calendar MonthMonthly Sales Analysis . Calendar Month.
Calendar Date.Calendar MonthCalendar Date . Calendar MonthStores and Sales Details . Calendar Month.
Calendar Date.Calendar MonthCalendar Date . Calendar MonthVideo Analysis Information . Calendar Month.
Calendar Date.Calendar QuarterCalendar Date . Calendar QuarterCalendar Date . Calendar Quarter.
Calendar Date.Calendar QuarterCalendar Date . Calendar QuarterMonthly Sales Analysis . Calendar Quarter.
Calendar Date.Calendar QuarterCalendar Date . Calendar QuarterVideo Analysis Information . Calendar Quarter.
Calendar Date.Calendar YearCalendar Date . Calendar YearCalendar Date . Calendar Year.
Calendar Date.Calendar YearCalendar Date . Calendar YearMonthly Sales Analysis . Calendar Year.
Calendar Date.Calendar YearCalendar Date . Calendar YearStores and Sales Details . Calendar Year.
Calendar Date.Calendar YearCalendar Date . Calendar YearVideo Analysis Information . Calendar Year.
Calendar Date.Holiday FlagCalendar Date . Holiday FlagCalendar Date . Holiday Flag.
Calendar Date.Transaction DateCalendar Date . Transaction DateCalendar Date . Transaction Date.
Calendar Date.Transaction DateCalendar Date . Transaction DateStores and Sales Details . Transaction Date.
Fiscal Date.Fiscal DateFiscal Date . Fiscal DateFiscal Date . Fiscal Date.
Fiscal Date.Fiscal MonthFiscal Date . Fiscal MonthFiscal Date . Fiscal Month.
Fiscal Date.Fiscal QuarterFiscal Date . Fiscal QuarterFiscal Date . Fiscal Quarter.
Fiscal Date.Fiscal YearFiscal Date . Fiscal YearFiscal Date . Fiscal Year.
Fiscal Date.Holiday FlagFiscal Date . Holiday FlagFiscal Date . Holiday Flag.
Fiscal Date.Transaction DateFiscal Date . Transaction DateFiscal Date . Transaction Date.
Products.Age CategoryProducts . Age CategoryProducts . Age Category.
Products.BrandProducts . BrandProducts . Brand.
Products.DepartmentProducts . DepartmentMonthly Sales Analysis . Department.
Products.DepartmentProducts . DepartmentProducts . Department.
Products.DepartmentProducts . DepartmentStores and Sales Details . Department.
Products.DepartmentProducts . DepartmentVideo Analysis Information . Department.
Products.Full DescriptionProducts . Full DescriptionProducts . Full Description.
Products.Full DescriptionProducts . Full DescriptionStores and Sales Details . Full Description.
Products.Product CategoryProducts . Product CategoryProducts . Product Category.
Products.Product CategoryProducts . Product CategoryStores and Sales Details . Product Category.
Products.Product DescriptionProducts . Product DescriptionProducts . Product Description.
Products.Product DescriptionProducts . Product DescriptionStores and Sales Details . Product Description.
Products.Product TypeProducts . Product TypeProducts . Product Type.
Store.CityStore . CityMonthly Sales Analysis . City.
Store.CityStore . CityStore . City.
Store.CityStore . CityStores and Sales Details . City.
Store.CityStore . CityVideo Analysis Information . City.
Store.Floor Plan TypeStore . Floor Plan TypeStore . Floor Plan Type.
Store.Floor Plan TypeStore . Floor Plan TypeStores and Sales Details . Floor Plan Type.
Store.RegionStore . RegionMonthly Sales Analysis . Region.
Store.RegionStore . RegionStore . Region.
Store.RegionStore . RegionVideo Analysis Information . Region.
Store.ReportsStore . ReportsStore . Reports.
Store.ReportsStore . ReportsStores and Sales Details . Reports.
Store.Store KeyStore . Store KeyStore . Store Key.
Store.Store NameStore . Store NameMonthly Sales Analysis . Store Name.
Store.Store NameStore . Store NameStore . Store Name.
Store.Store NameStore . Store NameStores and Sales Details . Store Name.
Store.Store NameStore . Store NameVideo Analysis Information . Store Name.
Security
Administration AllowedUser Role Responsibility
YesSYSTEM
NoVIDEO5
NoPUBLIC
Summaries
Summary Set NameOwnerTable NameTable ColumnMap ToFolder NameAggregationItem Name
VIDEO_SUMM_ALLVIDEO5VIDEO_SUMM_ALLCAL_DATE_YRMaps To ===>Video Store TutorialAxis ItemCalendar Year
VIDEO_SUMM_ALLVIDEO5VIDEO_SUMM_ALLCITYMaps To ===>Video Store TutorialAxis ItemCity
VIDEO_SUMM_ALLVIDEO5VIDEO_SUMM_ALLCAL_DATE_MONMaps To ===>Video Store TutorialAxis ItemCalendar Month
VIDEO_SUMM_ALLVIDEO5VIDEO_SUMM_ALLSTORE_NAMEMaps To ===>Video Store TutorialAxis ItemStore Name
VIDEO_SUMM_ALLVIDEO5VIDEO_SUMM_ALLREGIONMaps To ===>Video Store TutorialAxis ItemRegion
VIDEO_SUMM_ALLVIDEO5VIDEO_SUMM_ALLCAL_DATE_QTRMaps To ===>Video Store TutorialAxis ItemCalendar Quarter
VIDEO_SUMM_ALLVIDEO5VIDEO_SUMM_ALLDEPARTMENTMaps To ===>Video Store TutorialAxis ItemDepartment
VIDEO_SUMM_ALLVIDEO5VIDEO_SUMM_ALLCOST_COUNTMaps To ===>Video Store TutorialCountCost
VIDEO_SUMM_ALLVIDEO5VIDEO_SUMM_ALLUNIT_SALES_COUNTMaps To ===>Video Store TutorialCountUnit Sales
VIDEO_SUMM_ALLVIDEO5VIDEO_SUMM_ALLSALES_COUNTMaps To ===>Video Store TutorialCountSales
VIDEO_SUMM_ALLVIDEO5VIDEO_SUMM_ALLPROFIT_COUNTMaps To ===>Video Store TutorialCountProfit
VIDEO_SUMM_ALLVIDEO5VIDEO_SUMM_ALLUNIT_SALES_SUMMaps To ===>Video Store TutorialSumUnit Sales
VIDEO_SUMM_ALLVIDEO5VIDEO_SUMM_ALLPROFIT_SUMMaps To ===>Video Store TutorialSumProfit
VIDEO_SUMM_ALLVIDEO5VIDEO_SUMM_ALLSALES_SUMMaps To ===>Video Store TutorialSumSales
VIDEO_SUMM_ALLVIDEO5VIDEO_SUMM_ALLCOST_SUMMaps To ===>Video Store TutorialSumCost
VIDEO_SUMM_DEPT_REGVIDEO5VIDEO_SUMM_DEPT_REGCAL_DATE_QTRMaps To ===>Video Store TutorialAxis ItemCalendar Quarter
VIDEO_SUMM_DEPT_REGVIDEO5VIDEO_SUMM_DEPT_REGDEPARTMENTMaps To ===>Video Store TutorialAxis ItemDepartment
VIDEO_SUMM_DEPT_REGVIDEO5VIDEO_SUMM_DEPT_REGCAL_DATE_MONMaps To ===>Video Store TutorialAxis ItemCalendar Month
VIDEO_SUMM_DEPT_REGVIDEO5VIDEO_SUMM_DEPT_REGREGIONMaps To ===>Video Store TutorialAxis ItemRegion
VIDEO_SUMM_DEPT_REGVIDEO5VIDEO_SUMM_DEPT_REGCAL_DATE_YRMaps To ===>Video Store TutorialAxis ItemCalendar Year
VIDEO_SUMM_DEPT_REGVIDEO5VIDEO_SUMM_DEPT_REGSALES_COUNTMaps To ===>Video Store TutorialCountSales
VIDEO_SUMM_DEPT_REGVIDEO5VIDEO_SUMM_DEPT_REGUNIT_SALES_COUNTMaps To ===>Video Store TutorialCountUnit Sales
VIDEO_SUMM_DEPT_REGVIDEO5VIDEO_SUMM_DEPT_REGCOST_COUNTMaps To ===>Video Store TutorialCountCost
VIDEO_SUMM_DEPT_REGVIDEO5VIDEO_SUMM_DEPT_REGPROFIT_COUNTMaps To ===>Video Store TutorialCountProfit
VIDEO_SUMM_DEPT_REGVIDEO5VIDEO_SUMM_DEPT_REGUNIT_SALES_SUMMaps To ===>Video Store TutorialSumUnit Sales
VIDEO_SUMM_DEPT_REGVIDEO5VIDEO_SUMM_DEPT_REGPROFIT_SUMMaps To ===>Video Store TutorialSumProfit
VIDEO_SUMM_DEPT_REGVIDEO5VIDEO_SUMM_DEPT_REGSALES_SUMMaps To ===>Video Store TutorialSumSales
VIDEO_SUMM_DEPT_REGVIDEO5VIDEO_SUMM_DEPT_REGCOST_SUMMaps To ===>Video Store TutorialSumCost
VIDEO_SUMM_DEPT_REG_YRVIDEO5VIDEO_SUMM_DEPT_REG_YRREGIONMaps To ===>Video Store TutorialAxis ItemRegion
VIDEO_SUMM_DEPT_REG_YRVIDEO5VIDEO_SUMM_DEPT_REG_YRDEPARTMENTMaps To ===>Video Store TutorialAxis ItemDepartment
VIDEO_SUMM_DEPT_REG_YRVIDEO5VIDEO_SUMM_DEPT_REG_YRCAL_DATE_YRMaps To ===>Video Store TutorialAxis ItemCalendar Year
VIDEO_SUMM_DEPT_REG_YRVIDEO5VIDEO_SUMM_DEPT_REG_YRPROFIT_COUNTMaps To ===>Video Store TutorialCountProfit
VIDEO_SUMM_DEPT_REG_YRVIDEO5VIDEO_SUMM_DEPT_REG_YRSALES_COUNTMaps To ===>Video Store TutorialCountSales
VIDEO_SUMM_DEPT_REG_YRVIDEO5VIDEO_SUMM_DEPT_REG_YRUNIT_SALES_COUNTMaps To ===>Video Store TutorialCountUnit Sales
VIDEO_SUMM_DEPT_REG_YRVIDEO5VIDEO_SUMM_DEPT_REG_YRCOST_COUNTMaps To ===>Video Store TutorialCountCost
VIDEO_SUMM_DEPT_REG_YRVIDEO5VIDEO_SUMM_DEPT_REG_YRCOST_SUMMaps To ===>Video Store TutorialSumCost
VIDEO_SUMM_DEPT_REG_YRVIDEO5VIDEO_SUMM_DEPT_REG_YRPROFIT_SUMMaps To ===>Video Store TutorialSumProfit
VIDEO_SUMM_DEPT_REG_YRVIDEO5VIDEO_SUMM_DEPT_REG_YRSALES_SUMMaps To ===>Video Store TutorialSumSales
VIDEO_SUMM_DEPT_REG_YRVIDEO5VIDEO_SUMM_DEPT_REG_YRUNIT_SALES_SUMMaps To ===>Video Store TutorialSumUnit Sales
VIDEO_SUMM_YRVIDEO5VIDEO_SUMM_YRDEPARTMENTMaps To ===>Video Store TutorialAxis ItemDepartment
VIDEO_SUMM_YRVIDEO5VIDEO_SUMM_YRCAL_DATE_YRMaps To ===>Video Store TutorialAxis ItemCalendar Year
VIDEO_SUMM_YRVIDEO5VIDEO_SUMM_YRSTORE_NAMEMaps To ===>Video Store TutorialAxis ItemStore Name
VIDEO_SUMM_YRVIDEO5VIDEO_SUMM_YRREGIONMaps To ===>Video Store TutorialAxis ItemRegion
VIDEO_SUMM_YRVIDEO5VIDEO_SUMM_YRCITYMaps To ===>Video Store TutorialAxis ItemCity
VIDEO_SUMM_YRVIDEO5VIDEO_SUMM_YRUNIT_SALES_COUNTMaps To ===>Video Store TutorialCountUnit Sales
VIDEO_SUMM_YRVIDEO5VIDEO_SUMM_YRCOST_COUNTMaps To ===>Video Store TutorialCountCost
VIDEO_SUMM_YRVIDEO5VIDEO_SUMM_YRPROFIT_COUNTMaps To ===>Video Store TutorialCountProfit
VIDEO_SUMM_YRVIDEO5VIDEO_SUMM_YRSALES_COUNTMaps To ===>Video Store TutorialCountSales
VIDEO_SUMM_YRVIDEO5VIDEO_SUMM_YRUNIT_SALES_SUMMaps To ===>Video Store TutorialSumUnit Sales
VIDEO_SUMM_YRVIDEO5VIDEO_SUMM_YRSALES_SUMMaps To ===>Video Store TutorialSumSales
VIDEO_SUMM_YRVIDEO5VIDEO_SUMM_YRPROFIT_SUMMaps To ===>Video Store TutorialSumProfit
VIDEO_SUMM_YRVIDEO5VIDEO_SUMM_YRCOST_SUMMaps To ===>Video Store TutorialSumCost
Discoverer V5 - OWB Lineage
Folders
FolderFolder HiddenFolder TypeDescriptionFolder KeyLast UpdatedFolder Id
EUL5 Business Areas & FoldersVisibleComplex EUL5_BA_FOLDERS25-Oct-2006100627
EUL5 Folders & ItemsVisibleComplex EUL5_FOLDERS_ITEMS25-Oct-2006100630
Eul5 Ba Obj LinksVisibleSimple EUL5_BA_OBJ_LINKS25-Oct-2006100582
Eul5 BasVisibleSimple EUL5_BAS25-Oct-2006100577
Eul5 ExpressionsVisibleSimple EUL5_EXPRESSIONS25-Oct-2006100592
Eul5 ObjsVisibleSimple EUL5_OBJS25-Oct-2006100607
EUL5 Business Areas & Folders
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneEul5 Bas, Eul5 Ba Obj Links, Eul5 ObjsSYSTEM.EUL5_BAS SYSTEM.EUL5_BA_OBJ_LINKS SYSTEM.EUL5_OBJS25-OCT-2006 25-OCT-2006 25-OCT-2006
NoneEul5 Bas, Eul5 Ba Obj Links, Eul5 ObjsSYSTEM.EUL5_BAS SYSTEM.EUL5_BA_OBJ_LINKS SYSTEM.EUL5_OBJS25-OCT-2006 25-OCT-2006 25-OCT-2006
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Business Area Created By Eul5 Bas.Ba Created By BA_CREATED_BY101806
Business Area Created Date Eul5 Bas.Ba Created Date BA_CREATED_DATE101808
Business Area Description Eul5 Bas.Ba Description BA_DESCRIPTION101810
Business Area Developer Key Eul5 Bas.Ba Developer Key BA_DEVELOPER_KEY101812
Business Area Id Eul5 Bas.Ba Id BA_ID101814
Business Area Name Eul5 Bas.Ba Name BA_NAME101816
Business Area Updated By Eul5 Bas.Ba Updated By BA_UPDATED_BY101818
Business Area Updated Date Eul5 Bas.Ba Updated Date BA_UPDATED_DATE101820
Date Table Last Analyzed Eul5 Objs.Obj Id DATE_TABLE_LAST_ANALYZED102329
Folder Components Eul5 Objs.Obj Id ITEM4102336
Folder Created By Eul5 Objs.Obj Created By FOLDER_CREATED_BY102096
Folder Created Date Eul5 Objs.Obj Created Date FOLDER_CREATED_DATE102098
Folder DB Object Name Eul5 Objs.Sobj Ext Table FOLDER_DB_OBJ_NAME102100
Folder Dependency Eul5 Objs.Obj Id FOLDER_DEPENDANCY102332
Folder Description Eul5 Objs.Obj Description OBJ_DESCRIPTION102317
Folder Developer Key Eul5 Objs.Obj Developer Key FOLDER_DEVELOPER_KEY102104
Folder Hidden Eul5 Objs.Obj Hidden FOLDER_HIDDEN102112
Folder Id Eul5 Objs.Obj Id OBJ_ID102327
Folder Name Eul5 Objs.Obj Name OBJ_NAME102352
Folder Object Eul5 Objs.Obj Ext Object OBJ_EXT_OBJECT102321
Folder Object Db Link Eul5 Objs.Obj Ext Db Link OBJ_EXT_DB_LINK102319
Folder Object Owner Eul5 Objs.Obj Ext Owner OBJ_EXT_OWNER102323
Folder Sequence Eul5 Ba Obj Links.Bol Sequence FOLDER_SEQUENCE102125
Folder Type Eul5 Objs.Obj Type FOLDER_TYPE102127
Folder Updated By Eul5 Objs.Obj Updated By FOLDER_UPDATED_BY102129
Folder Updated Date Eul5 Objs.Obj Updated Date FOLDER_UPDATED_DATE102131
Table Components Eul5 Objs.Obj Id TABLE_COMPONENTS102550
Business Area Created By Eul5 Bas.Ba Created By BA_CREATED_BY101806
Business Area Created Date Eul5 Bas.Ba Created Date BA_CREATED_DATE101808
Business Area Description Eul5 Bas.Ba Description BA_DESCRIPTION101810
Business Area Developer Key Eul5 Bas.Ba Developer Key BA_DEVELOPER_KEY101812
Business Area Id Eul5 Bas.Ba Id BA_ID101814
Business Area Name Eul5 Bas.Ba Name BA_NAME101816
Business Area Updated By Eul5 Bas.Ba Updated By BA_UPDATED_BY101818
Business Area Updated Date Eul5 Bas.Ba Updated Date BA_UPDATED_DATE101820
Date Table Last Analyzed Eul5 Objs.Obj Id DATE_TABLE_LAST_ANALYZED102329
Folder Components Eul5 Objs.Obj Id ITEM4102336
Folder Created By Eul5 Objs.Obj Created By FOLDER_CREATED_BY102096
Folder Created Date Eul5 Objs.Obj Created Date FOLDER_CREATED_DATE102098
Folder DB Object Name Eul5 Objs.Sobj Ext Table FOLDER_DB_OBJ_NAME102100
Folder Dependency Eul5 Objs.Obj Id FOLDER_DEPENDANCY102332
Folder Description Eul5 Objs.Obj Description OBJ_DESCRIPTION102317
Folder Developer Key Eul5 Objs.Obj Developer Key FOLDER_DEVELOPER_KEY102104
Folder Hidden Eul5 Objs.Obj Hidden FOLDER_HIDDEN102112
Folder Id Eul5 Objs.Obj Id OBJ_ID102327
Folder Name Eul5 Objs.Obj Name OBJ_NAME102352
Folder Object Eul5 Objs.Obj Ext Object OBJ_EXT_OBJECT102321
Folder Object Db Link Eul5 Objs.Obj Ext Db Link OBJ_EXT_DB_LINK102319
Folder Object Owner Eul5 Objs.Obj Ext Owner OBJ_EXT_OWNER102323
Folder Sequence Eul5 Ba Obj Links.Bol Sequence FOLDER_SEQUENCE102125
Folder Type Eul5 Objs.Obj Type FOLDER_TYPE102127
Folder Updated By Eul5 Objs.Obj Updated By FOLDER_UPDATED_BY102129
Folder Updated Date Eul5 Objs.Obj Updated Date FOLDER_UPDATED_DATE102131
Table Components Eul5 Objs.Obj Id TABLE_COMPONENTS102550
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
EUL5 Business Areas & Folders.Folder Id -> EUL5 Conditions.Obj IdEUL5 Business Areas & Folders.Folder Id = EUL5 Conditions.Obj IdAlways exist in master folderNoneYes
EUL5 Business Areas & Folders.Folder Id -> EUL5 Folders & Items.Folder IdEUL5 Business Areas & Folders.Folder Id = EUL5 Folders & Items.Folder IdMight not exist in master folderOuter join on master Yes
EUL5 Business Areas & Folders.Business Area Id -> EUL5 Security.Gba Ba IdEUL5 Business Areas & Folders.Business Area Id = EUL5 Security.Gba Ba IdAlways exist in master folderNoneYes
EUL5 Business Areas & Folders.Folder Id -> EUL5 Summary Mappings.Obj IdEUL5 Business Areas & Folders.Folder Id = EUL5 Summary Mappings.Obj IdAlways exist in master folderNoneYes
EUL5 Business Areas & Folders.Folder Id -> EUL5 Joins.Master Folder IdEUL5 Business Areas & Folders.Folder Id = EUL5 Joins.Master Folder IdAlways exist in master folderNoneYes
EUL5 Folders & Items
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneEul5 Expressions, Eul5 ObjsSYSTEM.EUL5_EXPRESSIONS SYSTEM.EUL5_OBJS25-OCT-2006 25-OCT-2006
NoneEul5 Expressions, Eul5 ObjsSYSTEM.EUL5_EXPRESSIONS SYSTEM.EUL5_OBJS25-OCT-2006 25-OCT-2006
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Actual Item Name Eul5 Expressions.Exp Name ITEM_NAME102241
AutoGen Eul5 Expressions.Exp Name Eul5 Expressions.Exp Id AUTOGEN102247
Database Column Eul5 Expressions.Exp Id DATABASE_COLUMN102224
Folder Description Eul5 Objs.Obj Description FOLDER_DESCRIPTION102102
Folder Developer Key Eul5 Objs.Obj Developer Key FOLDER_DEVELOPER_KEY102106
Folder Hidden Eul5 Objs.Obj Hidden FOLDER_HIDDEN102114
Folder Id Eul5 Objs.Obj Id FOLDER_ID102116
Folder Lineage Eul5 Objs.Obj Developer Key EUL5_LINEAGE102108
Folder Name Eul5 Objs.Obj Name FOLDER_NAME102121
Item Alignment Eul5 Expressions.It Alignment ITEM_ALIGNMENT102199
Item Case Display Eul5 Expressions.It Case Display ITEM_CASE_DISPLAY102201
Item Case Storage Eul5 Expressions.It Case Storage ITEM_CASE_STORAGE102203
Item Created By Eul5 Expressions.Exp Created By ITEM_CREATED_BY102205
Item Created Date Eul5 Expressions.Exp Created Date ITEM_CREATED_DATE102207
Item Data Type Eul5 Expressions.Exp Data Type ITEM_DATA_TYPE102209
Item Dependency Eul5 Expressions.Exp Id ITEM_DEPENDANCY102227
Item Description Eul5 Expressions.Exp Description ITEM_DESCRIPTION102212
Item Developer Key Eul5 Expressions.Exp Developer Key EXP_DEVELOPER_KEY102034
Item External Column Eul5 Expressions.It Ext Column ITEM_EXT_COLUMN102214
Item Format Mask Eul5 Expressions.It Format Mask ITEM_FORMAT_MASK102216
Item Heading Eul5 Expressions.It Heading ITEM_HEADING102218
Item Hidden Eul5 Expressions.It Hidden ITEM_HIDDEN102220
Item Id Eul5 Expressions.Exp Id ITEM_ID102222
Item Lineage Eul5 Expressions.Exp Developer Key ITEM_LINEAGE102233
Item Max Display Width Eul5 Expressions.It Max Disp Width IT_MAX_DISP_WIDTH102260
Item Name Eul5 Expressions.Exp Id ITEM_NAME1102245
Item Placement Eul5 Expressions.It Placement ITEM_PLACEMENT102250
Item Sequence Eul5 Expressions.Exp Sequence ITEM_SEQUENCE102252
Item Updated By Eul5 Expressions.Exp Updated By ITEM_UPDATED_BY102254
Item Updated Date Eul5 Expressions.Exp Updated Date ITEM_UPDATED_DATE102256
Item User Default Format Eul5 Expressions.It User Def Fmt ITEM_USER_DEF_FMT102258
Parameter Multiple Values Allowed Eul5 Expressions.Par Multiple Vals PAR_MULTIPLE_VALS102386
Replace NULL with Eul5 Expressions.It Disp Null Val REPLACE_NULL_WITH102434
Actual Item Name Eul5 Expressions.Exp Name ITEM_NAME102241
AutoGen Eul5 Expressions.Exp Name Eul5 Expressions.Exp Id AUTOGEN102247
Database Column Eul5 Expressions.Exp Id DATABASE_COLUMN102224
Folder Description Eul5 Objs.Obj Description FOLDER_DESCRIPTION102102
Folder Developer Key Eul5 Objs.Obj Developer Key FOLDER_DEVELOPER_KEY102106
Folder Hidden Eul5 Objs.Obj Hidden FOLDER_HIDDEN102114
Folder Id Eul5 Objs.Obj Id FOLDER_ID102116
Folder Lineage Eul5 Objs.Obj Developer Key EUL5_LINEAGE102108
Folder Name Eul5 Objs.Obj Name FOLDER_NAME102121
Item Alignment Eul5 Expressions.It Alignment ITEM_ALIGNMENT102199
Item Case Display Eul5 Expressions.It Case Display ITEM_CASE_DISPLAY102201
Item Case Storage Eul5 Expressions.It Case Storage ITEM_CASE_STORAGE102203
Item Created By Eul5 Expressions.Exp Created By ITEM_CREATED_BY102205
Item Created Date Eul5 Expressions.Exp Created Date ITEM_CREATED_DATE102207
Item Data Type Eul5 Expressions.Exp Data Type ITEM_DATA_TYPE102209
Item Dependency Eul5 Expressions.Exp Id ITEM_DEPENDANCY102227
Item Description Eul5 Expressions.Exp Description ITEM_DESCRIPTION102212
Item Developer Key Eul5 Expressions.Exp Developer Key EXP_DEVELOPER_KEY102034
Item External Column Eul5 Expressions.It Ext Column ITEM_EXT_COLUMN102214
Item Format Mask Eul5 Expressions.It Format Mask ITEM_FORMAT_MASK102216
Item Heading Eul5 Expressions.It Heading ITEM_HEADING102218
Item Hidden Eul5 Expressions.It Hidden ITEM_HIDDEN102220
Item Id Eul5 Expressions.Exp Id ITEM_ID102222
Item Lineage Eul5 Expressions.Exp Developer Key ITEM_LINEAGE102233
Item Max Display Width Eul5 Expressions.It Max Disp Width IT_MAX_DISP_WIDTH102260
Item Name Eul5 Expressions.Exp Id ITEM_NAME1102245
Item Placement Eul5 Expressions.It Placement ITEM_PLACEMENT102250
Item Sequence Eul5 Expressions.Exp Sequence ITEM_SEQUENCE102252
Item Updated By Eul5 Expressions.Exp Updated By ITEM_UPDATED_BY102254
Item Updated Date Eul5 Expressions.Exp Updated Date ITEM_UPDATED_DATE102256
Item User Default Format Eul5 Expressions.It User Def Fmt ITEM_USER_DEF_FMT102258
Parameter Multiple Values Allowed Eul5 Expressions.Par Multiple Vals PAR_MULTIPLE_VALS102386
Replace NULL with Eul5 Expressions.It Disp Null Val REPLACE_NULL_WITH102434
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
EUL5 Folders & Items.Item Id -> EUL5 Item Classes.Exp IdEUL5 Folders & Items.Item Id = EUL5 Item Classes.Exp IdAlways exist in master folderNoneYes
EUL5 Folders & Items.Item Id -> EUL5 Hierarchy.Hil Exp IdEUL5 Folders & Items.Item Id = EUL5 Hierarchy.Hil Exp IdAlways exist in master folderNoneYes
Eul5 Ba Obj Links
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
EUL5 Business Areas & FoldersNoneSYSTEM.EUL5_BA_OBJ_LINKS25-OCT-2006
EUL5 Business Areas & FoldersNoneSYSTEM.EUL5_BA_OBJ_LINKS25-OCT-2006
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Bol Ba Id Eul5 Ba Obj Links.Bol Ba IdBOL_BA_IDBOL_BA_ID100939
Bol Created By Eul5 Ba Obj Links.Bol Created ByBOL_CREATED_BYBOL_CREATED_BY100940
Bol Created Date Eul5 Ba Obj Links.Bol Created DateBOL_CREATED_DATEBOL_CREATED_DATE100941
Bol Element State Eul5 Ba Obj Links.Bol Element StateBOL_ELEMENT_STATEBOL_ELEMENT_STATE100942
Bol Id Eul5 Ba Obj Links.Bol IdBOL_IDBOL_ID100943
Bol Obj Id Eul5 Ba Obj Links.Bol Obj IdBOL_OBJ_IDBOL_OBJ_ID100944
Bol Sequence Eul5 Ba Obj Links.Bol SequenceBOL_SEQUENCEBOL_SEQUENCE100945
Bol Updated By Eul5 Ba Obj Links.Bol Updated ByBOL_UPDATED_BYBOL_UPDATED_BY100946
Bol Updated Date Eul5 Ba Obj Links.Bol Updated DateBOL_UPDATED_DATEBOL_UPDATED_DATE100947
Notm Eul5 Ba Obj Links.NotmNOTMNOTM101398
Bol Ba Id Eul5 Ba Obj Links.Bol Ba IdBOL_BA_IDBOL_BA_ID100939
Bol Created By Eul5 Ba Obj Links.Bol Created ByBOL_CREATED_BYBOL_CREATED_BY100940
Bol Created Date Eul5 Ba Obj Links.Bol Created DateBOL_CREATED_DATEBOL_CREATED_DATE100941
Bol Element State Eul5 Ba Obj Links.Bol Element StateBOL_ELEMENT_STATEBOL_ELEMENT_STATE100942
Bol Id Eul5 Ba Obj Links.Bol IdBOL_IDBOL_ID100943
Bol Obj Id Eul5 Ba Obj Links.Bol Obj IdBOL_OBJ_IDBOL_OBJ_ID100944
Bol Sequence Eul5 Ba Obj Links.Bol SequenceBOL_SEQUENCEBOL_SEQUENCE100945
Bol Updated By Eul5 Ba Obj Links.Bol Updated ByBOL_UPDATED_BYBOL_UPDATED_BY100946
Bol Updated Date Eul5 Ba Obj Links.Bol Updated DateBOL_UPDATED_DATEBOL_UPDATED_DATE100947
Notm Eul5 Ba Obj Links.NotmNOTMNOTM101398
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Eul5 Bas
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
EUL5 Business Areas & FoldersNoneSYSTEM.EUL5_BAS25-OCT-2006
EUL5 Business Areas & FoldersNoneSYSTEM.EUL5_BAS25-OCT-2006
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Ba Created By Eul5 Bas.Ba Created ByBA_CREATED_BYBA_CREATED_BY100924
Ba Created Date Eul5 Bas.Ba Created DateBA_CREATED_DATEBA_CREATED_DATE100925
Ba Description Eul5 Bas.Ba DescriptionBA_DESCRIPTIONBA_DESCRIPTION100926
Ba Developer Key Eul5 Bas.Ba Developer KeyBA_DEVELOPER_KEYBA_DEVELOPER_KEY100927
Ba Element State Eul5 Bas.Ba Element StateBA_ELEMENT_STATEBA_ELEMENT_STATE100928
Ba Ext Name Eul5 Bas.Ba Ext NameBA_EXT_NAMEBA_EXT_NAME100929
Ba Id Eul5 Bas.Ba IdBA_IDBA_ID100930
Ba Name Eul5 Bas.Ba NameBA_NAMEBA_NAME100931
Ba Updated By Eul5 Bas.Ba Updated ByBA_UPDATED_BYBA_UPDATED_BY100932
Ba Updated Date Eul5 Bas.Ba Updated DateBA_UPDATED_DATEBA_UPDATED_DATE100933
Ba User Prop1 Eul5 Bas.Ba User Prop1BA_USER_PROP1BA_USER_PROP1100934
Ba User Prop2 Eul5 Bas.Ba User Prop2BA_USER_PROP2BA_USER_PROP2100935
Notm Eul5 Bas.NotmNOTMNOTM101393
Ba Created By Eul5 Bas.Ba Created ByBA_CREATED_BYBA_CREATED_BY100924
Ba Created Date Eul5 Bas.Ba Created DateBA_CREATED_DATEBA_CREATED_DATE100925
Ba Description Eul5 Bas.Ba DescriptionBA_DESCRIPTIONBA_DESCRIPTION100926
Ba Developer Key Eul5 Bas.Ba Developer KeyBA_DEVELOPER_KEYBA_DEVELOPER_KEY100927
Ba Element State Eul5 Bas.Ba Element StateBA_ELEMENT_STATEBA_ELEMENT_STATE100928
Ba Ext Name Eul5 Bas.Ba Ext NameBA_EXT_NAMEBA_EXT_NAME100929
Ba Id Eul5 Bas.Ba IdBA_IDBA_ID100930
Ba Name Eul5 Bas.Ba NameBA_NAMEBA_NAME100931
Ba Updated By Eul5 Bas.Ba Updated ByBA_UPDATED_BYBA_UPDATED_BY100932
Ba Updated Date Eul5 Bas.Ba Updated DateBA_UPDATED_DATEBA_UPDATED_DATE100933
Ba User Prop1 Eul5 Bas.Ba User Prop1BA_USER_PROP1BA_USER_PROP1100934
Ba User Prop2 Eul5 Bas.Ba User Prop2BA_USER_PROP2BA_USER_PROP2100935
Notm Eul5 Bas.NotmNOTMNOTM101393
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Eul5 Bas.Ba Id -> Eul5 Access Privs.Gba Ba IdEul5 Bas.Ba Id = Eul5 Access Privs.Gba Ba IdAlways exist in master folderNoneYes
Eul5 Bas.Ba Id -> Eul5 Ba Obj Links.Bol Ba IdEul5 Bas.Ba Id = Eul5 Ba Obj Links.Bol Ba IdMight not exist in master folderOuter join on master Yes
Eul5 Bas.Ba Id -> Eul5 Objs.Obj Ba IdEul5 Bas.Ba Id = Eul5 Objs.Obj Ba IdAlways exist in master folderNoneYes
Eul5 Expressions
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
EUL5 Alternate Sorts, EUL5 Item Classes, EUL5 Conditions, EUL5 Folders & Items, EUL5 Item Class SQL, EUL5 Item Class Used By , EUL5 Joins, EUL5 Summary MappingsNoneSYSTEM.EUL5_EXPRESSIONS25-OCT-2006
EUL5 Alternate Sorts, EUL5 Item Classes, EUL5 Conditions, EUL5 Folders & Items, EUL5 Item Class SQL, EUL5 Item Class Used By , EUL5 Joins, EUL5 Summary MappingsNoneSYSTEM.EUL5_EXPRESSIONS25-OCT-2006
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Auto Generated Exp Name Eul5 Expressions.Exp Id AUTO_GENERATED_EXP_NAME101778
Ci It Id Eul5 Expressions.Ci It IdCI_IT_IDCI_IT_ID101038
Ci Runtime Item Eul5 Expressions.Ci Runtime ItemCI_RUNTIME_ITEMCI_RUNTIME_ITEM101039
Co Nullable Eul5 Expressions.Co NullableCO_NULLABLECO_NULLABLE101041
Exp Created By Eul5 Expressions.Exp Created ByEXP_CREATED_BYEXP_CREATED_BY101148
Exp Created Date Eul5 Expressions.Exp Created DateEXP_CREATED_DATEEXP_CREATED_DATE101149
Exp Data Type Eul5 Expressions.Exp Data TypeEXP_DATA_TYPEEXP_DATA_TYPE101150
Exp Description Eul5 Expressions.Exp DescriptionEXP_DESCRIPTIONEXP_DESCRIPTION101151
Exp Developer Key Eul5 Expressions.Exp Developer KeyEXP_DEVELOPER_KEYEXP_DEVELOPER_KEY101152
Exp Element State Eul5 Expressions.Exp Element StateEXP_ELEMENT_STATEEXP_ELEMENT_STATE101153
Exp Formula Eul5 Expressions.Exp FormulaEXP_FORMULA1EXP_FORMULA1101154
Exp Id Eul5 Expressions.Exp IdEXP_IDEXP_ID101155
Exp Name Eul5 Expressions.Exp NameEXP_NAMEEXP_NAME101156
Exp Sequence Eul5 Expressions.Exp SequenceEXP_SEQUENCEEXP_SEQUENCE101157
Exp Type Eul5 Expressions.Exp TypeEXP_TYPEEXP_TYPE101158
Exp Updated By Eul5 Expressions.Exp Updated ByEXP_UPDATED_BYEXP_UPDATED_BY101159
Exp Updated Date Eul5 Expressions.Exp Updated DateEXP_UPDATED_DATEEXP_UPDATED_DATE101160
Exp User Prop1 Eul5 Expressions.Exp User Prop1EXP_USER_PROP1EXP_USER_PROP1101161
Exp User Prop2 Eul5 Expressions.Exp User Prop2EXP_USER_PROP2EXP_USER_PROP2101162
Fil App Type Eul5 Expressions.Fil App TypeFIL_APP_TYPEFIL_APP_TYPE101214
Fil Doc Id Eul5 Expressions.Fil Doc IdFIL_DOC_IDFIL_DOC_ID101215
Fil Ext Filter Eul5 Expressions.Fil Ext FilterFIL_EXT_FILTERFIL_EXT_FILTER101216
Fil Obj Id Eul5 Expressions.Fil Obj IdFIL_OBJ_IDFIL_OBJ_ID101217
Fil Runtime Filter Eul5 Expressions.Fil Runtime FilterFIL_RUNTIME_FILTERFIL_RUNTIME_FILTER101218
It Alignment Eul5 Expressions.It AlignmentIT_ALIGNMENTIT_ALIGNMENT101329
It Case Display Eul5 Expressions.It Case DisplayIT_CASE_DISPLAYIT_CASE_DISPLAY101330
It Case Storage Eul5 Expressions.It Case StorageIT_CASE_STORAGEIT_CASE_STORAGE101331
It Disp Null Val Eul5 Expressions.It Disp Null ValIT_DISP_NULL_VALIT_DISP_NULL_VAL101332
It Doc Id Eul5 Expressions.It Doc IdIT_DOC_IDIT_DOC_ID101333
It Dom Id Eul5 Expressions.It Dom IdIT_DOM_IDIT_DOM_ID101334
It Ext Column Eul5 Expressions.It Ext ColumnIT_EXT_COLUMNIT_EXT_COLUMN101335
It Format Mask Eul5 Expressions.It Format MaskIT_FORMAT_MASKIT_FORMAT_MASK101336
It Fun Id Eul5 Expressions.It Fun IdIT_FUN_IDIT_FUN_ID101337
It Heading Eul5 Expressions.It HeadingIT_HEADINGIT_HEADING101338
It Hidden Eul5 Expressions.It HiddenIT_HIDDENIT_HIDDEN101339
It Max Data Width Eul5 Expressions.It Max Data WidthIT_MAX_DATA_WIDTHIT_MAX_DATA_WIDTH101340
It Max Disp Width Eul5 Expressions.It Max Disp WidthIT_MAX_DISP_WIDTHIT_MAX_DISP_WIDTH101341
It Obj Id Eul5 Expressions.It Obj IdIT_OBJ_IDIT_OBJ_ID101342
It Placement Eul5 Expressions.It PlacementIT_PLACEMENTIT_PLACEMENT101343
It User Def Fmt Eul5 Expressions.It User Def FmtIT_USER_DEF_FMTIT_USER_DEF_FMT101344
It Word Wrap Eul5 Expressions.It Word WrapIT_WORD_WRAPIT_WORD_WRAP101345
Jp Key Id Eul5 Expressions.Jp Key IdJP_KEY_IDJP_KEY_ID101348
Notm Eul5 Expressions.NotmNOTMNOTM101406
P Case Sensitive Eul5 Expressions.P Case SensitiveP_CASE_SENSITIVEP_CASE_SENSITIVE101503
Par Multiple Vals Eul5 Expressions.Par Multiple ValsPAR_MULTIPLE_VALSPAR_MULTIPLE_VALS101494
Auto Generated Exp Name Eul5 Expressions.Exp Id AUTO_GENERATED_EXP_NAME101778
Ci It Id Eul5 Expressions.Ci It IdCI_IT_IDCI_IT_ID101038
Ci Runtime Item Eul5 Expressions.Ci Runtime ItemCI_RUNTIME_ITEMCI_RUNTIME_ITEM101039
Co Nullable Eul5 Expressions.Co NullableCO_NULLABLECO_NULLABLE101041
Exp Created By Eul5 Expressions.Exp Created ByEXP_CREATED_BYEXP_CREATED_BY101148
Exp Created Date Eul5 Expressions.Exp Created DateEXP_CREATED_DATEEXP_CREATED_DATE101149
Exp Data Type Eul5 Expressions.Exp Data TypeEXP_DATA_TYPEEXP_DATA_TYPE101150
Exp Description Eul5 Expressions.Exp DescriptionEXP_DESCRIPTIONEXP_DESCRIPTION101151
Exp Developer Key Eul5 Expressions.Exp Developer KeyEXP_DEVELOPER_KEYEXP_DEVELOPER_KEY101152
Exp Element State Eul5 Expressions.Exp Element StateEXP_ELEMENT_STATEEXP_ELEMENT_STATE101153
Exp Formula Eul5 Expressions.Exp FormulaEXP_FORMULA1EXP_FORMULA1101154
Exp Id Eul5 Expressions.Exp IdEXP_IDEXP_ID101155
Exp Name Eul5 Expressions.Exp NameEXP_NAMEEXP_NAME101156
Exp Sequence Eul5 Expressions.Exp SequenceEXP_SEQUENCEEXP_SEQUENCE101157
Exp Type Eul5 Expressions.Exp TypeEXP_TYPEEXP_TYPE101158
Exp Updated By Eul5 Expressions.Exp Updated ByEXP_UPDATED_BYEXP_UPDATED_BY101159
Exp Updated Date Eul5 Expressions.Exp Updated DateEXP_UPDATED_DATEEXP_UPDATED_DATE101160
Exp User Prop1 Eul5 Expressions.Exp User Prop1EXP_USER_PROP1EXP_USER_PROP1101161
Exp User Prop2 Eul5 Expressions.Exp User Prop2EXP_USER_PROP2EXP_USER_PROP2101162
Fil App Type Eul5 Expressions.Fil App TypeFIL_APP_TYPEFIL_APP_TYPE101214
Fil Doc Id Eul5 Expressions.Fil Doc IdFIL_DOC_IDFIL_DOC_ID101215
Fil Ext Filter Eul5 Expressions.Fil Ext FilterFIL_EXT_FILTERFIL_EXT_FILTER101216
Fil Obj Id Eul5 Expressions.Fil Obj IdFIL_OBJ_IDFIL_OBJ_ID101217
Fil Runtime Filter Eul5 Expressions.Fil Runtime FilterFIL_RUNTIME_FILTERFIL_RUNTIME_FILTER101218
It Alignment Eul5 Expressions.It AlignmentIT_ALIGNMENTIT_ALIGNMENT101329
It Case Display Eul5 Expressions.It Case DisplayIT_CASE_DISPLAYIT_CASE_DISPLAY101330
It Case Storage Eul5 Expressions.It Case StorageIT_CASE_STORAGEIT_CASE_STORAGE101331
It Disp Null Val Eul5 Expressions.It Disp Null ValIT_DISP_NULL_VALIT_DISP_NULL_VAL101332
It Doc Id Eul5 Expressions.It Doc IdIT_DOC_IDIT_DOC_ID101333
It Dom Id Eul5 Expressions.It Dom IdIT_DOM_IDIT_DOM_ID101334
It Ext Column Eul5 Expressions.It Ext ColumnIT_EXT_COLUMNIT_EXT_COLUMN101335
It Format Mask Eul5 Expressions.It Format MaskIT_FORMAT_MASKIT_FORMAT_MASK101336
It Fun Id Eul5 Expressions.It Fun IdIT_FUN_IDIT_FUN_ID101337
It Heading Eul5 Expressions.It HeadingIT_HEADINGIT_HEADING101338
It Hidden Eul5 Expressions.It HiddenIT_HIDDENIT_HIDDEN101339
It Max Data Width Eul5 Expressions.It Max Data WidthIT_MAX_DATA_WIDTHIT_MAX_DATA_WIDTH101340
It Max Disp Width Eul5 Expressions.It Max Disp WidthIT_MAX_DISP_WIDTHIT_MAX_DISP_WIDTH101341
It Obj Id Eul5 Expressions.It Obj IdIT_OBJ_IDIT_OBJ_ID101342
It Placement Eul5 Expressions.It PlacementIT_PLACEMENTIT_PLACEMENT101343
It User Def Fmt Eul5 Expressions.It User Def FmtIT_USER_DEF_FMTIT_USER_DEF_FMT101344
It Word Wrap Eul5 Expressions.It Word WrapIT_WORD_WRAPIT_WORD_WRAP101345
Jp Key Id Eul5 Expressions.Jp Key IdJP_KEY_IDJP_KEY_ID101348
Notm Eul5 Expressions.NotmNOTMNOTM101406
P Case Sensitive Eul5 Expressions.P Case SensitiveP_CASE_SENSITIVEP_CASE_SENSITIVE101503
Par Multiple Vals Eul5 Expressions.Par Multiple ValsPAR_MULTIPLE_VALSPAR_MULTIPLE_VALS101494
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Eul5 Expressions.Exp Id -> Eul5 Domains.Dom It Id LovEul5 Expressions.Exp Id = Eul5 Domains.Dom It Id LovAlways exist in master folderNoneYes
Eul5 Expressions.Exp Id -> Eul5 Bq Deps.Bid It IdEul5 Expressions.Exp Id = Eul5 Bq Deps.Bid It IdAlways exist in master folderNoneYes
Eul5 Expressions.Exp Id -> Eul5 Sub Queries.Sq Fil IdEul5 Expressions.Exp Id = Eul5 Sub Queries.Sq Fil IdAlways exist in master folderNoneYes
Eul5 Expressions.Exp Id -> Eul5 Ig Exp Links.Kil Exp IdEul5 Expressions.Exp Id = Eul5 Ig Exp Links.Kil Exp IdMight not exist in master folderNoneYes
Eul5 Expressions.Exp Id -> Eul5 Sq Crrltns.Sqc It Inner IdEul5 Expressions.Exp Id = Eul5 Sq Crrltns.Sqc It Inner IdAlways exist in master folderNoneYes
Eul5 Expressions.Exp Id -> Eul5 Sub Queries.Sq It IdEul5 Expressions.Exp Id = Eul5 Sub Queries.Sq It IdAlways exist in master folderNoneYes
Eul5 Expressions.Exp Id -> Eul5 Exp Deps.Cd Exp IdEul5 Expressions.Exp Id = Eul5 Exp Deps.Cd Exp IdAlways exist in master folderNoneYes
Eul5 Expressions.Exp Id -> Eul5 Domains.Dom It Id RankEul5 Expressions.Exp Id = Eul5 Domains.Dom It Id RankAlways exist in master folderNoneYes
Eul5 Expressions.Exp Id -> Eul5 Ig Exp Links.Hil Exp IdEul5 Expressions.Exp Id = Eul5 Ig Exp Links.Hil Exp IdMight not exist in master folderNoneYes
Eul5 Expressions.Exp Id -> Eul5 Exp Deps.Cid Exp IdEul5 Expressions.Exp Id = Eul5 Exp Deps.Cid Exp IdAlways exist in master folderNoneYes
Eul5 Expressions.Exp Id -> Eul5 Sum Bitmaps.Sb Exp IdEul5 Expressions.Exp Id = Eul5 Sum Bitmaps.Sb Exp IdMight not exist in master folderNoneYes
Eul5 Expressions.Exp Id -> Eul5 Exp Deps.Pd P IdEul5 Expressions.Exp Id = Eul5 Exp Deps.Pd P IdAlways exist in master folderNoneYes
Eul5 Expressions.Exp Id -> Eul5 Sq Crrltns.Sqc It Outer IdEul5 Expressions.Exp Id = Eul5 Sq Crrltns.Sqc It Outer IdAlways exist in master folderNoneYes
Eul5 Expressions.Exp Id -> Eul5 Bq Deps.Bfild Fil IdEul5 Expressions.Exp Id = Eul5 Bq Deps.Bfild Fil IdAlways exist in master folderNoneYes
Eul5 Expressions.Exp Id -> Eul5 Exp Deps.Ped Exp IdEul5 Expressions.Exp Id = Eul5 Exp Deps.Ped Exp IdAlways exist in master folderNoneYes
Eul5 Expressions.Exp Id -> Eul5 Segments.Seg Exp IdEul5 Expressions.Exp Id = Eul5 Segments.Seg Exp IdAlways exist in master folderNoneYes
Eul5 Expressions.Exp Id -> Eul5 Sumo Exp Usgs.Siu Exp IdEul5 Expressions.Exp Id = Eul5 Sumo Exp Usgs.Siu Exp IdAlways exist in master folderNoneYes
Eul5 Objs
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
EUL5 Alternate Sorts, EUL5 Item Classes, EUL5 Business Areas & Folders, EUL5 Conditions, EUL5 Folders & Items, EUL5 Item Class SQL, EUL5 Item Class Used By , EUL5 Summary MappingsNoneSYSTEM.EUL5_OBJS25-OCT-2006
EUL5 Alternate Sorts, EUL5 Item Classes, EUL5 Business Areas & Folders, EUL5 Conditions, EUL5 Folders & Items, EUL5 Item Class SQL, EUL5 Item Class Used By , EUL5 Summary MappingsNoneSYSTEM.EUL5_OBJS25-OCT-2006
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Notm Eul5 Objs.NotmNOTMNOTM101420
Obj Ba Id Eul5 Objs.Obj Ba IdOBJ_BA_IDOBJ_BA_ID101439
Obj Cbo Hint Eul5 Objs.Obj Cbo HintOBJ_CBO_HINTOBJ_CBO_HINT101440
Obj Created By Eul5 Objs.Obj Created ByOBJ_CREATED_BYOBJ_CREATED_BY101441
Obj Created Date Eul5 Objs.Obj Created DateOBJ_CREATED_DATEOBJ_CREATED_DATE101442
Obj Description Eul5 Objs.Obj DescriptionOBJ_DESCRIPTIONOBJ_DESCRIPTION101443
Obj Developer Key Eul5 Objs.Obj Developer KeyOBJ_DEVELOPER_KEYOBJ_DEVELOPER_KEY101444
Obj Distinct Flag Eul5 Objs.Obj Distinct FlagOBJ_DISTINCT_FLAGOBJ_DISTINCT_FLAG101445
Obj Element State Eul5 Objs.Obj Element StateOBJ_ELEMENT_STATEOBJ_ELEMENT_STATE101446
Obj Ext Db Link Eul5 Objs.Obj Ext Db LinkOBJ_EXT_DB_LINKOBJ_EXT_DB_LINK101447
Obj Ext Object Eul5 Objs.Obj Ext ObjectOBJ_EXT_OBJECTOBJ_EXT_OBJECT101448
Obj Ext Owner Eul5 Objs.Obj Ext OwnerOBJ_EXT_OWNEROBJ_EXT_OWNER101449
Obj Hidden Eul5 Objs.Obj HiddenOBJ_HIDDENOBJ_HIDDEN101450
Obj Id Eul5 Objs.Obj IdOBJ_IDOBJ_ID101451
Obj Name Eul5 Objs.Obj NameOBJ_NAMEOBJ_NAME101452
Obj Ndeterministic Eul5 Objs.Obj NdeterministicOBJ_NDETERMINISTICOBJ_NDETERMINISTIC101453
Obj Object Sql1 Eul5 Objs.Obj Object Sql1OBJ_OBJECT_SQL1OBJ_OBJECT_SQL1101454
Obj Object Sql2 Eul5 Objs.Obj Object Sql2OBJ_OBJECT_SQL2OBJ_OBJECT_SQL2101455
Obj Object Sql3 Eul5 Objs.Obj Object Sql3OBJ_OBJECT_SQL3OBJ_OBJECT_SQL3101456
Obj Type Eul5 Objs.Obj TypeOBJ_TYPEOBJ_TYPE101457
Obj Updated By Eul5 Objs.Obj Updated ByOBJ_UPDATED_BYOBJ_UPDATED_BY101458
Obj Updated Date Eul5 Objs.Obj Updated DateOBJ_UPDATED_DATEOBJ_UPDATED_DATE101459
Obj User Prop1 Eul5 Objs.Obj User Prop1OBJ_USER_PROP1OBJ_USER_PROP1101460
Obj User Prop2 Eul5 Objs.Obj User Prop2OBJ_USER_PROP2OBJ_USER_PROP2101461
Sobj Ext Table Eul5 Objs.Sobj Ext TableSOBJ_EXT_TABLESOBJ_EXT_TABLE101643
Notm Eul5 Objs.NotmNOTMNOTM101420
Obj Ba Id Eul5 Objs.Obj Ba IdOBJ_BA_IDOBJ_BA_ID101439
Obj Cbo Hint Eul5 Objs.Obj Cbo HintOBJ_CBO_HINTOBJ_CBO_HINT101440
Obj Created By Eul5 Objs.Obj Created ByOBJ_CREATED_BYOBJ_CREATED_BY101441
Obj Created Date Eul5 Objs.Obj Created DateOBJ_CREATED_DATEOBJ_CREATED_DATE101442
Obj Description Eul5 Objs.Obj DescriptionOBJ_DESCRIPTIONOBJ_DESCRIPTION101443
Obj Developer Key Eul5 Objs.Obj Developer KeyOBJ_DEVELOPER_KEYOBJ_DEVELOPER_KEY101444
Obj Distinct Flag Eul5 Objs.Obj Distinct FlagOBJ_DISTINCT_FLAGOBJ_DISTINCT_FLAG101445
Obj Element State Eul5 Objs.Obj Element StateOBJ_ELEMENT_STATEOBJ_ELEMENT_STATE101446
Obj Ext Db Link Eul5 Objs.Obj Ext Db LinkOBJ_EXT_DB_LINKOBJ_EXT_DB_LINK101447
Obj Ext Object Eul5 Objs.Obj Ext ObjectOBJ_EXT_OBJECTOBJ_EXT_OBJECT101448
Obj Ext Owner Eul5 Objs.Obj Ext OwnerOBJ_EXT_OWNEROBJ_EXT_OWNER101449
Obj Hidden Eul5 Objs.Obj HiddenOBJ_HIDDENOBJ_HIDDEN101450
Obj Id Eul5 Objs.Obj IdOBJ_IDOBJ_ID101451
Obj Name Eul5 Objs.Obj NameOBJ_NAMEOBJ_NAME101452
Obj Ndeterministic Eul5 Objs.Obj NdeterministicOBJ_NDETERMINISTICOBJ_NDETERMINISTIC101453
Obj Object Sql1 Eul5 Objs.Obj Object Sql1OBJ_OBJECT_SQL1OBJ_OBJECT_SQL1101454
Obj Object Sql2 Eul5 Objs.Obj Object Sql2OBJ_OBJECT_SQL2OBJ_OBJECT_SQL2101455
Obj Object Sql3 Eul5 Objs.Obj Object Sql3OBJ_OBJECT_SQL3OBJ_OBJECT_SQL3101456
Obj Type Eul5 Objs.Obj TypeOBJ_TYPEOBJ_TYPE101457
Obj Updated By Eul5 Objs.Obj Updated ByOBJ_UPDATED_BYOBJ_UPDATED_BY101458
Obj Updated Date Eul5 Objs.Obj Updated DateOBJ_UPDATED_DATEOBJ_UPDATED_DATE101459
Obj User Prop1 Eul5 Objs.Obj User Prop1OBJ_USER_PROP1OBJ_USER_PROP1101460
Obj User Prop2 Eul5 Objs.Obj User Prop2OBJ_USER_PROP2OBJ_USER_PROP2101461
Sobj Ext Table Eul5 Objs.Sobj Ext TableSOBJ_EXT_TABLESOBJ_EXT_TABLE101643
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Eul5 Objs.Obj Id -> Eul5 Obj Deps.Od Obj Id ToEul5 Objs.Obj Id = Eul5 Obj Deps.Od Obj Id ToAlways exist in master folderNoneYes
Eul5 Objs.Obj Id -> Eul5 Sub Queries.Sq Obj IdEul5 Objs.Obj Id = Eul5 Sub Queries.Sq Obj IdAlways exist in master folderNoneYes
Eul5 Objs.Obj Id -> Eul5 Ba Obj Links.Bol Obj IdEul5 Objs.Obj Id = Eul5 Ba Obj Links.Bol Obj IdAlways exist in master folderNoneYes
Eul5 Objs.Obj Id -> Eul5 Key Cons.Key Obj IdEul5 Objs.Obj Id = Eul5 Key Cons.Key Obj IdAlways exist in master folderNoneYes
Eul5 Objs.Obj Id -> Eul5 Expressions.Fil Obj IdEul5 Objs.Obj Id = Eul5 Expressions.Fil Obj IdMight not exist in master folderNoneYes
Eul5 Objs.Obj Id -> Eul5 Obj Deps.Od Obj Id FromEul5 Objs.Obj Id = Eul5 Obj Deps.Od Obj Id FromAlways exist in master folderNoneYes
Eul5 Objs.Obj Id -> Eul5 Asmp Cons.Aoc Obj IdEul5 Objs.Obj Id = Eul5 Asmp Cons.Aoc Obj IdAlways exist in master folderNoneYes
Eul5 Objs.Obj Id -> Eul5 Segments.Seg Cuo IdEul5 Objs.Obj Id = Eul5 Segments.Seg Cuo IdAlways exist in master folderNoneYes
Eul5 Objs.Obj Id -> Eul5 Obj Join Usgs.Oju Obj IdEul5 Objs.Obj Id = Eul5 Obj Join Usgs.Oju Obj IdAlways exist in master folderNoneYes
Eul5 Objs.Obj Id -> Eul5 Key Cons.Fk Obj Id RemoteEul5 Objs.Obj Id = Eul5 Key Cons.Fk Obj Id RemoteMight not exist in master folderNoneYes
Eul5 Objs.Obj Id -> Eul5 Segments.Seg Obj IdEul5 Objs.Obj Id = Eul5 Segments.Seg Obj IdAlways exist in master folderNoneYes
Eul5 Objs.Obj Id -> Eul5 Expressions.It Obj IdEul5 Objs.Obj Id = Eul5 Expressions.It Obj IdMight not exist in master folderNoneYes
Folder Filters
Used In ConditionItemBa NameBase ObjectFilter NameFilter TypeFolder Name
Hierarchies
Hierarchy NameCreated ByHierarchy LevelHierarchy Details
EUL5 Folders & Business Areas to ItemsUser1EUL5 Business Areas & Folders.Folder Name
EUL5 Folders & Business Areas to ItemsUser2 ^------EUL5 Folders & Items.Folder Name
EUL5 Folders & Business Areas to ItemsUser3 ^------EUL5 Folders & Items.Database Column
EUL5 Folders to TablesUser1EUL5 Folders & Items.Folder Name
EUL5 Folders to TablesUser2 ^------EUL5 Business Areas & Folders.Table Components
Item Classes
Item Class NamePrimary FolderUsed ByAlternate Sort
EUL5 Business Areas & Folders.Business Area NameEUL5 Business Areas & Folders . Business Area NameEUL5 Business Areas & Folders . Business Area Name.
EUL5 Business Areas & Folders.Folder DB Object NameEUL5 Business Areas & Folders . Folder DB Object NameEUL5 Business Areas & Folders . Folder DB Object Name.
EUL5 Business Areas & Folders.Folder HiddenEUL5 Business Areas & Folders . Folder HiddenEUL5 Business Areas & Folders . Folder Hidden.
EUL5 Business Areas & Folders.Folder NameEUL5 Business Areas & Folders . Folder NameEUL5 Business Areas & Folders . Folder Name.
EUL5 Business Areas & Folders.Folder NameEUL5 Business Areas & Folders . Folder NameEUL5 Folders & Items . Folder Name.
EUL5 Business Areas & Folders.Folder NameEUL5 Business Areas & Folders . Folder NameEul5 Objs . Obj Name.
EUL5 Business Areas & Folders.Folder Object Db LinkEUL5 Business Areas & Folders . Folder Object Db LinkEUL5 Business Areas & Folders . Folder Object Db Link.
EUL5 Business Areas & Folders.Folder Object OwnerEUL5 Business Areas & Folders . Folder Object OwnerEUL5 Business Areas & Folders . Folder Object Owner.
EUL5 Business Areas & Folders.Folder TypeEUL5 Business Areas & Folders . Folder TypeEUL5 Business Areas & Folders . Folder Type.
EUL5 Folders & Items.Actual Item NameEUL5 Folders & Items . Actual Item NameEUL5 Folders & Items . Actual Item Name.
EUL5 Folders & Items.Item Data TypeEUL5 Folders & Items . Item Data TypeEUL5 Folders & Items . Item Data Type.
EUL5 Folders & Items.Item External ColumnEUL5 Folders & Items . Item External ColumnEUL5 Folders & Items . Item External Column.
EUL5 Folders & Items.Item HiddenEUL5 Folders & Items . Item HiddenEUL5 Folders & Items . Item Hidden.
EUL5 Folders & Items.Item NameEUL5 Folders & Items . Item NameEUL5 Folders & Items . Item Name.
Security
Administration AllowedUser Role Responsibility
YesSYSTEM
Summaries
Summary Set NameOwnerTable NameTable ColumnMap ToFolder NameAggregationItem Name
The Discoverer V5 EUL
Folders
FolderFolder HiddenFolder TypeDescriptionFolder KeyLast UpdatedFolder Id
EUL5 All ObjectsVisibleCustomEUL5 All ObjectsEUL5_ALL_OBJECTS25-Oct-2006100642
EUL5 All Table PrivilegesVisibleCustomEUL5 All Table PrivilegesEUL5_ALL_TABLE_PRIVILEGES25-Oct-2006100644
EUL5 All UsersVisibleCustomEUL5 All UsersEUL5_ALL_USERS25-Oct-2006100646
EUL5 Alternate SortsVisibleComplex EUL5_ALTERNATE_SORTS25-Oct-2006100626
EUL5 Business Areas & FoldersVisibleComplex EUL5_BA_FOLDERS25-Oct-2006100627
EUL5 ConditionsVisibleComplex EUL5_CONDITIONS25-Oct-2006100628
EUL5 Dba Jobs RunningVisibleSimpleAll jobs in the database which are currently running, join v$lock and job$EUL5_DBA_JOBS_RUNNING25-Oct-2006100586
EUL5 Existing Summary Combos VisibleComplex EUL5_EXST_SUMM_COMBOS25-Oct-2006100629
EUL5 Folders & ItemsVisibleComplex EUL5_FOLDERS_ITEMS25-Oct-2006100630
EUL5 HierarchyVisibleComplex EUL5_HIERARCHY25-Oct-2006100631
EUL5 Item Class SQLHiddenComplex EUL5_ITEM_CLASS_SQL25-Oct-2006100633
EUL5 Item Class Used By HiddenComplex EUL5_ITEM_CLASS_USED_BY25-Oct-2006100634
EUL5 Item ClassesVisibleComplex EUL5_ITEM_CLASSES25-Oct-2006100632
EUL5 JoinsVisibleComplex EUL5_JOINS25-Oct-2006100635
EUL5 PrivilegesVisibleComplex EUL5_PRIVILEGES25-Oct-2006100636
EUL5 SecurityVisibleComplex EUL5_SECURITY25-Oct-2006100637
EUL5 Summary FoldersVisibleComplex EUL5_SUMMARY_FOLDERS25-Oct-2006100638
EUL5 Summary MappingsVisibleComplex EUL5_SUMMARY_MAPPINGS25-Oct-2006100639
EUL5 Table Privileges ReceivedVisibleCustomEUL5 Table Privileges ReceivedEUL5_TABLE_PRIVILEGES_RECEIVED25-Oct-2006100648
EUL5 User JobsVisibleSimpleAll jobs owned by this userEUL5_USER_JOBS25-Oct-2006100623
EUL5 Users QueriesVisibleComplex EUL5_USERS_QUERIES25-Oct-2006100640
EUL5 Workbook ManagementVisibleComplex EUL5_WORKBOOK_MGMT25-Oct-2006100641
Eul5 Access PrivsVisibleSimple EUL5_ACCESS_PRIVS25-Oct-2006100572
Eul5 App ParamsVisibleSimple EUL5_APP_PARAMS25-Oct-2006100573
Eul5 Asm PoliciesVisibleSimple EUL5_ASM_POLICIES25-Oct-2006100576
Eul5 Asmp ConsVisibleSimple EUL5_ASMP_CONS25-Oct-2006100574
Eul5 Asmp LogsVisibleSimple EUL5_ASMP_LOGS25-Oct-2006100575
Eul5 Ba Obj LinksVisibleSimple EUL5_BA_OBJ_LINKS25-Oct-2006100582
Eul5 BasVisibleSimple EUL5_BAS25-Oct-2006100577
Eul5 Batch ParamsVisibleSimple EUL5_BATCH_PARAMS25-Oct-2006100578
Eul5 Batch QueriesVisibleSimple EUL5_BATCH_QUERIES25-Oct-2006100579
Eul5 Batch ReportsVisibleSimple EUL5_BATCH_REPORTS25-Oct-2006100580
Eul5 Batch SheetsVisibleSimple EUL5_BATCH_SHEETS25-Oct-2006100581
Eul5 Bq DepsVisibleSimple EUL5_BQ_DEPS25-Oct-2006100583
Eul5 Bq TablesVisibleSimple EUL5_BQ_TABLES25-Oct-2006100584
Eul5 Br RunsVisibleSimple EUL5_BR_RUNS25-Oct-2006100585
Eul5 Dbh NodesVisibleSimple EUL5_DBH_NODES25-Oct-2006100587
Eul5 DocumentsVisibleSimple EUL5_DOCUMENTS25-Oct-2006100588
Eul5 DomainsVisibleSimple EUL5_DOMAINS25-Oct-2006100589
Eul5 Elem XrefsVisibleSimple EUL5_ELEM_XREFS25-Oct-2006100590
Eul5 Eul UsersVisibleSimple EUL5_EUL_USERS25-Oct-2006100591
Eul5 Exp DepsVisibleSimple EUL5_EXP_DEPS25-Oct-2006100593
Eul5 ExpressionsVisibleSimple EUL5_EXPRESSIONS25-Oct-2006100592
Eul5 Freq UnitsVisibleSimple EUL5_FREQ_UNITS25-Oct-2006100594
Eul5 Fun ArgumentsVisibleSimple EUL5_FUN_ARGUMENTS25-Oct-2006100596
Eul5 Fun CtgsVisibleSimple EUL5_FUN_CTGS25-Oct-2006100597
Eul5 Fun Fc LinksVisibleSimple EUL5_FUN_FC_LINKS25-Oct-2006100598
Eul5 FunctionsVisibleSimple EUL5_FUNCTIONS25-Oct-2006100595
Eul5 GatewaysVisibleSimple EUL5_GATEWAYS25-Oct-2006100599
Eul5 Hi NodesVisibleSimple EUL5_HI_NODES25-Oct-2006100601
Eul5 Hi SegmentsVisibleSimple EUL5_HI_SEGMENTS25-Oct-2006100602
Eul5 HierarchiesVisibleSimple EUL5_HIERARCHIES25-Oct-2006100600
Eul5 Ig Exp LinksVisibleSimple EUL5_IG_EXP_LINKS25-Oct-2006100603
Eul5 Ihs Fk LinksVisibleSimple EUL5_IHS_FK_LINKS25-Oct-2006100604
Eul5 Key ConsVisibleSimple EUL5_KEY_CONS25-Oct-2006100605
Eul5 Named ElemsVisibleSimple EUL5_NAMED_ELEMS25-Oct-2006100606
Eul5 Obj DepsVisibleSimple EUL5_OBJ_DEPS25-Oct-2006100608
Eul5 Obj Join UsgsVisibleSimple EUL5_OBJ_JOIN_USGS25-Oct-2006100609
Eul5 ObjsVisibleSimple EUL5_OBJS25-Oct-2006100607
Eul5 Odbc CatalogsVisibleSimple EUL5_ODBC_CATALOGS25-Oct-2006100610
Eul5 Odbc SchemasVisibleSimple EUL5_ODBC_SCHEMAS25-Oct-2006100611
Eul5 Plan TableVisibleSimple EUL5_PLAN_TABLE25-Oct-2006100612
Eul5 Qpp StatsVisibleSimple EUL5_QPP_STATS25-Oct-2006100613
Eul5 SegmentsVisibleSimple EUL5_SEGMENTS25-Oct-2006100614
Eul5 SequencesVisibleSimple EUL5_SEQUENCES25-Oct-2006100615
Eul5 Sq CrrltnsVisibleSimple EUL5_SQ_CRRLTNS25-Oct-2006100616
Eul5 Sub QueriesVisibleSimple EUL5_SUB_QUERIES25-Oct-2006100617
Eul5 Sum BitmapsVisibleSimple EUL5_SUM_BITMAPS25-Oct-2006100621
Eul5 Sum Rfsh SetsVisibleSimple EUL5_SUM_RFSH_SETS25-Oct-2006100622
Eul5 Summary ObjsVisibleSimple EUL5_SUMMARY_OBJS25-Oct-2006100618
Eul5 Summary Objs CopyVisibleSimple EUL5_SUMMARY_OBJS125-Oct-2006100619
Eul5 Sumo Exp UsgsVisibleSimple EUL5_SUMO_EXP_USGS25-Oct-2006100620
Eul5 VersionsVisibleSimple EUL5_VERSIONS25-Oct-2006100624
Eul5 Worksheet SqlVisibleSimple EUL5_WORKSHEET_SQL25-Oct-2006100625
EUL5 All Objects
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNoneUnknownUnknown
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Created EUL5 All Objects.CreatedCREATEDCREATED101042
Data Object Id EUL5 All Objects.Data Object IdDATA_OBJECT_IDDATA_OBJECT_ID101044
EUL Version Description EUL5 All Objects.Owner EUL_VERSION_DESCRIPTION101969
EUL Version Minimum Code EUL5 All Objects.Owner EUL_VERSION_MINIMUM_CODE_101974
EUL Version Name EUL5 All Objects.Owner EUL_VERSION_NAME101979
EUL Version Release EUL5 All Objects.Owner EUL_VERSION_RELEASE101984
EUL Version Timestamp EUL5 All Objects.Owner EUL_VERSION_TIMESTAMP101989
Generated EUL5 All Objects.GeneratedGENERATEDGENERATED101250
Last Ddl Time EUL5 All Objects.Last Ddl TimeLAST_DDL_TIMELAST_DDL_TIME101368
Object Id EUL5 All Objects.Object IdOBJECT_IDOBJECT_ID101431
Object Name EUL5 All Objects.Object NameOBJECT_NAMEOBJECT_NAME101433
Object Type EUL5 All Objects.Object TypeOBJECT_TYPEOBJECT_TYPE101437
Owner EUL5 All Objects.OwnerOWNEROWNER101487
Secondary EUL5 All Objects.SecondarySECONDARYSECONDARY101604
Status EUL5 All Objects.StatusSTATUSSTATUS101692
Subobject Name EUL5 All Objects.Subobject NameSUBOBJECT_NAMESUBOBJECT_NAME101693
Temporary EUL5 All Objects.TemporaryTEMPORARYTEMPORARY101730
Timestamp EUL5 All Objects.TimestampTIMESTAMPTIMESTAMP101735
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
EUL5 All Objects.Owner -> EUL5 All Table Privileges.OwnerEUL5 All Objects.Owner = EUL5 All Table Privileges.OwnerAlways exist in master folderNoneYes
EUL5 All Objects.Owner -> EUL5 Table Privileges Received.OwnerEUL5 All Objects.Owner = EUL5 Table Privileges Received.OwnerAlways exist in master folderNoneYes
EUL5 All Table Privileges
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNoneUnknownUnknown
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Grantable EUL5 All Table Privileges.GrantableGRANTABLEGRANTABLE101252
Grantee EUL5 All Table Privileges.GranteeGRANTEEGRANTEE101254
Grantor EUL5 All Table Privileges.GrantorGRANTORGRANTOR101256
Hierarchy EUL5 All Table Privileges.HierarchyHIERARCHYHIERARCHY101268
Owner EUL5 All Table Privileges.OwnerOWNEROWNER101488
Privilege EUL5 All Table Privileges.PrivilegePRIVILEGEPRIVILEGE101499
Table Name EUL5 All Table Privileges.Table NameTABLE_NAMETABLE_NAME101728
User USER102591
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
EUL5 All Users
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNoneUnknownUnknown
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Created EUL5 All Users.CreatedCREATEDCREATED101043
EUL SA EUL_SA101967
EUL Version Description EUL_VERSION_DESCRIPTION101972
EUL Version Minimum Code EUL_VERSION_MINIMUM_CODE_101977
EUL Version Name EUL_VERSION_NAME101982
EUL Version Release EUL_VERSION_RELEASE101987
EUL Version Timestamp EUL_VERSION_TIMESTAMP101992
User USER102592
User Id EUL5 All Users.User IdUSER_IDUSER_ID101740
Username EUL5 All Users.UsernameUSERNAMEUSERNAME101739
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
EUL5 All Users.Username -> EUL5 All Objects.OwnerEUL5 All Users.Username = EUL5 All Objects.OwnerAlways exist in master folderOuter join on detail Yes
EUL5 Alternate Sorts
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
EUL5 Item ClassesEul5 Domains, Eul5 Expressions, Eul5 ObjsSYSTEM.EUL5_DOMAINS SYSTEM.EUL5_EXPRESSIONS SYSTEM.EUL5_OBJS25-OCT-2006 25-OCT-2006 25-OCT-2006
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Actual Exp Name Eul5 Expressions.Exp Name EXP_NAME102050
Dom Cardinality Eul5 Domains.Dom Cardinality DOM_CARDINALITY101883
Dom Data Type Eul5 Domains.Dom Data Type DOM_DATA_TYPE101891
Dom Description Eul5 Domains.Dom Description DOM_DESCRIPTION101899
Dom Id Eul5 Domains.Dom Id DOM_ID101907
Dom It Id Lov Eul5 Domains.Dom It Id Lov DOM_IT_ID_LOV101913
Dom It Id Rank Eul5 Domains.Dom It Id Rank DOM_IT_ID_RANK101921
Dom Last Exec Time Eul5 Domains.Dom Last Exec Time DOM_LAST_EXEC_TIME101929
Dom Logical Item Eul5 Domains.Dom Logical Item DOM_LOGICAL_ITEM101937
Dom Name Eul5 Domains.Dom Name DOM_NAME101945
Dom Sys Generated Eul5 Domains.Dom Sys Generated DOM_SYS_GENERATED101955
Exp Id Eul5 Expressions.Exp Id EXP_ID102038
Exp Name Eul5 Expressions.Exp Id AUTO_GENERATED_EXP_NAME101781
Obj Id Eul5 Objs.Obj Id OBJ_ID102325
Obj Name Eul5 Objs.Obj Name OBJ_NAME102350
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
EUL5 Alternate Sorts.Dom Id -> EUL5 Item Class Used By .Dom IdEUL5 Alternate Sorts.Dom Id = EUL5 Item Class Used By .Dom IdMight not exist in master folderOuter join on master Yes
EUL5 Business Areas & Folders
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneEul5 Bas, Eul5 Ba Obj Links, Eul5 ObjsSYSTEM.EUL5_BAS SYSTEM.EUL5_BA_OBJ_LINKS SYSTEM.EUL5_OBJS25-OCT-2006 25-OCT-2006 25-OCT-2006
NoneEul5 Bas, Eul5 Ba Obj Links, Eul5 ObjsSYSTEM.EUL5_BAS SYSTEM.EUL5_BA_OBJ_LINKS SYSTEM.EUL5_OBJS25-OCT-2006 25-OCT-2006 25-OCT-2006
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Business Area Created By Eul5 Bas.Ba Created By BA_CREATED_BY101806
Business Area Created Date Eul5 Bas.Ba Created Date BA_CREATED_DATE101808
Business Area Description Eul5 Bas.Ba Description BA_DESCRIPTION101810
Business Area Developer Key Eul5 Bas.Ba Developer Key BA_DEVELOPER_KEY101812
Business Area Id Eul5 Bas.Ba Id BA_ID101814
Business Area Name Eul5 Bas.Ba Name BA_NAME101816
Business Area Updated By Eul5 Bas.Ba Updated By BA_UPDATED_BY101818
Business Area Updated Date Eul5 Bas.Ba Updated Date BA_UPDATED_DATE101820
Date Table Last Analyzed Eul5 Objs.Obj Id DATE_TABLE_LAST_ANALYZED102329
Folder Components Eul5 Objs.Obj Id ITEM4102336
Folder Created By Eul5 Objs.Obj Created By FOLDER_CREATED_BY102096
Folder Created Date Eul5 Objs.Obj Created Date FOLDER_CREATED_DATE102098
Folder DB Object Name Eul5 Objs.Sobj Ext Table FOLDER_DB_OBJ_NAME102100
Folder Dependency Eul5 Objs.Obj Id FOLDER_DEPENDANCY102332
Folder Description Eul5 Objs.Obj Description OBJ_DESCRIPTION102317
Folder Developer Key Eul5 Objs.Obj Developer Key FOLDER_DEVELOPER_KEY102104
Folder Hidden Eul5 Objs.Obj Hidden FOLDER_HIDDEN102112
Folder Id Eul5 Objs.Obj Id OBJ_ID102327
Folder Name Eul5 Objs.Obj Name OBJ_NAME102352
Folder Object Eul5 Objs.Obj Ext Object OBJ_EXT_OBJECT102321
Folder Object Db Link Eul5 Objs.Obj Ext Db Link OBJ_EXT_DB_LINK102319
Folder Object Owner Eul5 Objs.Obj Ext Owner OBJ_EXT_OWNER102323
Folder Sequence Eul5 Ba Obj Links.Bol Sequence FOLDER_SEQUENCE102125
Folder Type Eul5 Objs.Obj Type FOLDER_TYPE102127
Folder Updated By Eul5 Objs.Obj Updated By FOLDER_UPDATED_BY102129
Folder Updated Date Eul5 Objs.Obj Updated Date FOLDER_UPDATED_DATE102131
Table Components Eul5 Objs.Obj Id TABLE_COMPONENTS102550
Business Area Created By Eul5 Bas.Ba Created By BA_CREATED_BY101806
Business Area Created Date Eul5 Bas.Ba Created Date BA_CREATED_DATE101808
Business Area Description Eul5 Bas.Ba Description BA_DESCRIPTION101810
Business Area Developer Key Eul5 Bas.Ba Developer Key BA_DEVELOPER_KEY101812
Business Area Id Eul5 Bas.Ba Id BA_ID101814
Business Area Name Eul5 Bas.Ba Name BA_NAME101816
Business Area Updated By Eul5 Bas.Ba Updated By BA_UPDATED_BY101818
Business Area Updated Date Eul5 Bas.Ba Updated Date BA_UPDATED_DATE101820
Date Table Last Analyzed Eul5 Objs.Obj Id DATE_TABLE_LAST_ANALYZED102329
Folder Components Eul5 Objs.Obj Id ITEM4102336
Folder Created By Eul5 Objs.Obj Created By FOLDER_CREATED_BY102096
Folder Created Date Eul5 Objs.Obj Created Date FOLDER_CREATED_DATE102098
Folder DB Object Name Eul5 Objs.Sobj Ext Table FOLDER_DB_OBJ_NAME102100
Folder Dependency Eul5 Objs.Obj Id FOLDER_DEPENDANCY102332
Folder Description Eul5 Objs.Obj Description OBJ_DESCRIPTION102317
Folder Developer Key Eul5 Objs.Obj Developer Key FOLDER_DEVELOPER_KEY102104
Folder Hidden Eul5 Objs.Obj Hidden FOLDER_HIDDEN102112
Folder Id Eul5 Objs.Obj Id OBJ_ID102327
Folder Name Eul5 Objs.Obj Name OBJ_NAME102352
Folder Object Eul5 Objs.Obj Ext Object OBJ_EXT_OBJECT102321
Folder Object Db Link Eul5 Objs.Obj Ext Db Link OBJ_EXT_DB_LINK102319
Folder Object Owner Eul5 Objs.Obj Ext Owner OBJ_EXT_OWNER102323
Folder Sequence Eul5 Ba Obj Links.Bol Sequence FOLDER_SEQUENCE102125
Folder Type Eul5 Objs.Obj Type FOLDER_TYPE102127
Folder Updated By Eul5 Objs.Obj Updated By FOLDER_UPDATED_BY102129
Folder Updated Date Eul5 Objs.Obj Updated Date FOLDER_UPDATED_DATE102131
Table Components Eul5 Objs.Obj Id TABLE_COMPONENTS102550
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
EUL5 Business Areas & Folders.Folder Id -> EUL5 Conditions.Obj IdEUL5 Business Areas & Folders.Folder Id = EUL5 Conditions.Obj IdAlways exist in master folderNoneYes
EUL5 Business Areas & Folders.Folder Id -> EUL5 Folders & Items.Folder IdEUL5 Business Areas & Folders.Folder Id = EUL5 Folders & Items.Folder IdMight not exist in master folderOuter join on master Yes
EUL5 Business Areas & Folders.Business Area Id -> EUL5 Security.Gba Ba IdEUL5 Business Areas & Folders.Business Area Id = EUL5 Security.Gba Ba IdAlways exist in master folderNoneYes
EUL5 Business Areas & Folders.Folder Id -> EUL5 Summary Mappings.Obj IdEUL5 Business Areas & Folders.Folder Id = EUL5 Summary Mappings.Obj IdAlways exist in master folderNoneYes
EUL5 Business Areas & Folders.Folder Id -> EUL5 Joins.Master Folder IdEUL5 Business Areas & Folders.Folder Id = EUL5 Joins.Master Folder IdAlways exist in master folderNoneYes
EUL5 Conditions
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneEul5 Expressions, Eul5 Exp Deps, Eul5 ObjsSYSTEM.EUL5_EXPRESSIONS SYSTEM.EUL5_EXP_DEPS SYSTEM.EUL5_OBJS25-OCT-2006 25-OCT-2006 25-OCT-2006
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Actual Condition Name Eul5 Expressions.Exp Name EXP_NAME102052
Condition Created By Eul5 Expressions.Exp Created By EXP_CREATED_BY102020
Condition Created Date Eul5 Expressions.Exp Created Date EXP_CREATED_DATE102022
Condition Description Eul5 Expressions.Exp Description EXP_DESCRIPTION102028
Condition Developer Key Eul5 Expressions.Exp Developer Key EXP_DEVELOPER_KEY102032
Condition Name Eul5 Expressions.Exp Id AUTO_GENERATED_EXP_NAME101783
Condition Updated By Eul5 Expressions.Exp Updated By EXP_UPDATED_BY102072
Condition Updated Date Eul5 Expressions.Exp Updated Date EXP_UPDATED_DATE102074
Database Object Eul5 Exp Deps.Ped Exp Id DATABASE_OBJECT101833
Ed Id Eul5 Exp Deps.Ed Id ED_ID101963
Ed Type Eul5 Exp Deps.Ed Type ED_TYPE101965
Exp Id Eul5 Expressions.Exp Id EXP_ID102040
Exp Type Eul5 Expressions.Exp Type EXP_TYPE102068
Fil App Type Eul5 Expressions.Fil App Type FIL_APP_TYPE102080
Fil Ext Filter Eul5 Expressions.Fil Ext Filter FIL_EXT_FILTER102082
Folder Name Eul5 Objs.Obj Name OBJ_NAME102354
Jp Key Id Eul5 Expressions.Jp Key Id JP_KEY_ID102281
Mandatory/Optional Eul5 Expressions.Fil Runtime Filter MANDATORY_OPTIONAL102315
Obj Id Eul5 Objs.Obj Id OBJ_ID102340
Pd P Id Eul5 Exp Deps.Pd P Id PD_P_ID102388
Ped Exp Id Eul5 Exp Deps.Ped Exp Id PED_EXP_ID102390
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
EUL5 Conditions.Ped Exp Id -> Eul5 Expressions.Exp IdEUL5 Conditions.Ped Exp Id = Eul5 Expressions.Exp IdAlways exist in master folderNoneYes
EUL5 Dba Jobs Running
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNoneSYS.DBA_JOBS_RUNNINGNot Analyzed
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
FailuresHow many times has this job started and failed since its last success?EUL5 Dba Jobs Running.FailuresFAILURESFAILURES101174
InstanceThe instance number restricted to run the jobEUL5 Dba Jobs Running.InstanceINSTANCEINSTANCE101326
JobIdentifier of job. This job is currently executing.EUL5 Dba Jobs Running.JobJOBJOB101346
Last DateDate that this job last successfully executedEUL5 Dba Jobs Running.Last DateLAST_DATELAST_DATE101366
Last SecSame as LAST_DATE. This is when the last successful execution started.EUL5 Dba Jobs Running.Last SecLAST_SECLAST_SEC101369
SidIdentifier of process which is executing the job. See v$lock.EUL5 Dba Jobs Running.SidSIDSID101639
This DateDate that this job started executing (usually null if not executing)EUL5 Dba Jobs Running.This DateTHIS_DATETHIS_DATE101731
This SecSame as THIS_DATE. This is when the last successful execution started.EUL5 Dba Jobs Running.This SecTHIS_SECTHIS_SEC101733
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
EUL5 Existing Summary Combos
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
EUL5 Summary Folders, EUL5 Summary Mappings, EUL5 Users QueriesEul5 Summary Objs, Eul5 Sum Rfsh Sets, EUL5 User JobsSYSTEM.EUL5_SUMMARY_OBJS SYSTEM.EUL5_SUM_RFSH_SETS SYS.USER_JOBS25-OCT-2006 25-OCT-2006 Not Analyzed
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
BrokenIf Y, no attempt is being made to run this job. See dbms_jobq.broken(job).EUL5 User Jobs.Broken BROKEN101822
FailuresHow many times has this job started and failed since its last success?EUL5 User Jobs.Failures FAILURES102076
JobIdentifier of job. Neither import/export nor repeated executions change it.EUL5 User Jobs.Job JOB102262
Priv UserUSER whose default privileges apply to this jobEUL5 User Jobs.Priv User PRIV_USER102402
Sdo Last Refresh Eul5 Summary Objs.Sdo Last Refresh SDO_LAST_REFRESH102448
Sdo Num Rows Eul5 Summary Objs.Sdo Num Rows SDO_NUM_ROWS102450
Srs Auto Refresh Eul5 Sum Rfsh Sets.Srs Auto Refresh SRS_AUTO_REFRESH102474
Srs Description Eul5 Sum Rfsh Sets.Srs Description SRS_DESCRIPTION102478
Srs Id Eul5 Sum Rfsh Sets.Srs Id SRS_ID102480
Srs Last Refresh Eul5 Sum Rfsh Sets.Srs Last Refresh SRS_LAST_REFRESH102482
Srs Name Eul5 Sum Rfsh Sets.Srs Name SRS_NAME102488
Srs Next Refresh Eul5 Sum Rfsh Sets.Srs Next Refresh SRS_NEXT_REFRESH102494
Srs Online Eul5 Sum Rfsh Sets.Srs Online SRS_ONLINE102498
Srs State Eul5 Sum Rfsh Sets.Srs State SRS_STATE102502
Srs Type Eul5 Sum Rfsh Sets.Srs State SRS_TYPE102513
Sumo Id Eul5 Summary Objs.Sumo Id SUMO_ID102534
Sumo Internal Eul5 Summary Objs.Sumo Internal SUMO_INTERNAL102538
Sumo Join State Eul5 Summary Objs.Sumo Join State SUMO_JOIN_STATE102544
Sumo Type Eul5 Summary Objs.Sumo Type SUMO_TYPE102546
Sumo Validity Eul5 Summary Objs.Sumo Validity SUMO_VALIDITY102548
Total TimeTotal wallclock time spent by the system on this job, in secondsEUL5 User Jobs.Total Time TOTAL_TIME102559
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
EUL5 Existing Summary Combos .Job -> EUL5 Dba Jobs Running.JobEUL5 Existing Summary Combos .Job = EUL5 Dba Jobs Running.JobMight not exist in master folderOne to one joinYes
EUL5 Existing Summary Combos .Sumo Id -> Eul5 Summary Objs.Sdo Sbo IdEUL5 Existing Summary Combos .Sumo Id = Eul5 Summary Objs.Sdo Sbo IdMight not exist in master folderOuter join on master Yes
EUL5 Folders & Items
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneEul5 Expressions, Eul5 ObjsSYSTEM.EUL5_EXPRESSIONS SYSTEM.EUL5_OBJS25-OCT-2006 25-OCT-2006
NoneEul5 Expressions, Eul5 ObjsSYSTEM.EUL5_EXPRESSIONS SYSTEM.EUL5_OBJS25-OCT-2006 25-OCT-2006
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Actual Item Name Eul5 Expressions.Exp Name ITEM_NAME102241
AutoGen Eul5 Expressions.Exp Name Eul5 Expressions.Exp Id AUTOGEN102247
Database Column Eul5 Expressions.Exp Id DATABASE_COLUMN102224
Folder Description Eul5 Objs.Obj Description FOLDER_DESCRIPTION102102
Folder Developer Key Eul5 Objs.Obj Developer Key FOLDER_DEVELOPER_KEY102106
Folder Hidden Eul5 Objs.Obj Hidden FOLDER_HIDDEN102114
Folder Id Eul5 Objs.Obj Id FOLDER_ID102116
Folder Lineage Eul5 Objs.Obj Developer Key EUL5_LINEAGE102108
Folder Name Eul5 Objs.Obj Name FOLDER_NAME102121
Item Alignment Eul5 Expressions.It Alignment ITEM_ALIGNMENT102199
Item Case Display Eul5 Expressions.It Case Display ITEM_CASE_DISPLAY102201
Item Case Storage Eul5 Expressions.It Case Storage ITEM_CASE_STORAGE102203
Item Created By Eul5 Expressions.Exp Created By ITEM_CREATED_BY102205
Item Created Date Eul5 Expressions.Exp Created Date ITEM_CREATED_DATE102207
Item Data Type Eul5 Expressions.Exp Data Type ITEM_DATA_TYPE102209
Item Dependency Eul5 Expressions.Exp Id ITEM_DEPENDANCY102227
Item Description Eul5 Expressions.Exp Description ITEM_DESCRIPTION102212
Item Developer Key Eul5 Expressions.Exp Developer Key EXP_DEVELOPER_KEY102034
Item External Column Eul5 Expressions.It Ext Column ITEM_EXT_COLUMN102214
Item Format Mask Eul5 Expressions.It Format Mask ITEM_FORMAT_MASK102216
Item Heading Eul5 Expressions.It Heading ITEM_HEADING102218
Item Hidden Eul5 Expressions.It Hidden ITEM_HIDDEN102220
Item Id Eul5 Expressions.Exp Id ITEM_ID102222
Item Lineage Eul5 Expressions.Exp Developer Key ITEM_LINEAGE102233
Item Max Display Width Eul5 Expressions.It Max Disp Width IT_MAX_DISP_WIDTH102260
Item Name Eul5 Expressions.Exp Id ITEM_NAME1102245
Item Placement Eul5 Expressions.It Placement ITEM_PLACEMENT102250
Item Sequence Eul5 Expressions.Exp Sequence ITEM_SEQUENCE102252
Item Updated By Eul5 Expressions.Exp Updated By ITEM_UPDATED_BY102254
Item Updated Date Eul5 Expressions.Exp Updated Date ITEM_UPDATED_DATE102256
Item User Default Format Eul5 Expressions.It User Def Fmt ITEM_USER_DEF_FMT102258
Parameter Multiple Values Allowed Eul5 Expressions.Par Multiple Vals PAR_MULTIPLE_VALS102386
Replace NULL with Eul5 Expressions.It Disp Null Val REPLACE_NULL_WITH102434
Actual Item Name Eul5 Expressions.Exp Name ITEM_NAME102241
AutoGen Eul5 Expressions.Exp Name Eul5 Expressions.Exp Id AUTOGEN102247
Database Column Eul5 Expressions.Exp Id DATABASE_COLUMN102224
Folder Description Eul5 Objs.Obj Description FOLDER_DESCRIPTION102102
Folder Developer Key Eul5 Objs.Obj Developer Key FOLDER_DEVELOPER_KEY102106
Folder Hidden Eul5 Objs.Obj Hidden FOLDER_HIDDEN102114
Folder Id Eul5 Objs.Obj Id FOLDER_ID102116
Folder Lineage Eul5 Objs.Obj Developer Key EUL5_LINEAGE102108
Folder Name Eul5 Objs.Obj Name FOLDER_NAME102121
Item Alignment Eul5 Expressions.It Alignment ITEM_ALIGNMENT102199
Item Case Display Eul5 Expressions.It Case Display ITEM_CASE_DISPLAY102201
Item Case Storage Eul5 Expressions.It Case Storage ITEM_CASE_STORAGE102203
Item Created By Eul5 Expressions.Exp Created By ITEM_CREATED_BY102205
Item Created Date Eul5 Expressions.Exp Created Date ITEM_CREATED_DATE102207
Item Data Type Eul5 Expressions.Exp Data Type ITEM_DATA_TYPE102209
Item Dependency Eul5 Expressions.Exp Id ITEM_DEPENDANCY102227
Item Description Eul5 Expressions.Exp Description ITEM_DESCRIPTION102212
Item Developer Key Eul5 Expressions.Exp Developer Key EXP_DEVELOPER_KEY102034
Item External Column Eul5 Expressions.It Ext Column ITEM_EXT_COLUMN102214
Item Format Mask Eul5 Expressions.It Format Mask ITEM_FORMAT_MASK102216
Item Heading Eul5 Expressions.It Heading ITEM_HEADING102218
Item Hidden Eul5 Expressions.It Hidden ITEM_HIDDEN102220
Item Id Eul5 Expressions.Exp Id ITEM_ID102222
Item Lineage Eul5 Expressions.Exp Developer Key ITEM_LINEAGE102233
Item Max Display Width Eul5 Expressions.It Max Disp Width IT_MAX_DISP_WIDTH102260
Item Name Eul5 Expressions.Exp Id ITEM_NAME1102245
Item Placement Eul5 Expressions.It Placement ITEM_PLACEMENT102250
Item Sequence Eul5 Expressions.Exp Sequence ITEM_SEQUENCE102252
Item Updated By Eul5 Expressions.Exp Updated By ITEM_UPDATED_BY102254
Item Updated Date Eul5 Expressions.Exp Updated Date ITEM_UPDATED_DATE102256
Item User Default Format Eul5 Expressions.It User Def Fmt ITEM_USER_DEF_FMT102258
Parameter Multiple Values Allowed Eul5 Expressions.Par Multiple Vals PAR_MULTIPLE_VALS102386
Replace NULL with Eul5 Expressions.It Disp Null Val REPLACE_NULL_WITH102434
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
EUL5 Folders & Items.Item Id -> EUL5 Item Classes.Exp IdEUL5 Folders & Items.Item Id = EUL5 Item Classes.Exp IdAlways exist in master folderNoneYes
EUL5 Folders & Items.Item Id -> EUL5 Hierarchy.Hil Exp IdEUL5 Folders & Items.Item Id = EUL5 Hierarchy.Hil Exp IdAlways exist in master folderNoneYes
EUL5 Hierarchy
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneEul5 Hierarchies, Eul5 Hi Nodes, Eul5 Ig Exp LinksSYSTEM.EUL5_HIERARCHIES SYSTEM.EUL5_HI_NODES SYSTEM.EUL5_IG_EXP_LINKS25-OCT-2006 25-OCT-2006 25-OCT-2006
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Actual Hierarchy Name Eul5 Hierarchies.Actual Hi Name HI_NAME102150
Actual Item Name Eul5 Hi Nodes.Hn Name HN_NAME102190
AutoGen Eul5 Hierarchies.Actual Hi Name Eul5 Hierarchies.Actual Hi Name Eul5 Hierarchies.Ibh Dbh Id Eul5 Hierarchies.Actual Hi Name Eul5 Hierarchies.Ibh Dbh Id Eul5 Hierarchies.Actual Hi Name Eul5 Hierarchies.Ibh Dbh Id AUTOGEN102169
AutoGen Hierarchy Node Eul5 Hi Nodes.Hn Name AUTOGEN_HIERARCHY_NODE102192
Database Item Eul5 Ig Exp Links.Hil Exp Id DATABASE_ITEM102141
Dbh Default Eul5 Hierarchies.Dbh Default DBH_DEFAULT101846
Generation Eul5 Hierarchies.Hi Sys Generated GENERATION102174
Hi Ext Hierarchy Eul5 Hierarchies.Hi Ext Hierarchy HI_EXT_HIERARCHY102146
Hi Id Eul5 Hierarchies.Hi Id HI_ID102148
Hi Sys Generated Eul5 Hierarchies.Hi Sys Generated HI_SYS_GENERATED102172
Hi Type Eul5 Hierarchies.Hi Type HI_TYPE102176
Hierarchy Item Eul5 Hierarchies.Hi Id Eul5 Hi Nodes.Hn Id Eul5 Hi Nodes.Hn Name Eul5 Hi Nodes.Hn Id Eul5 Hi Nodes.Hn Id HIERARCHY_ITEM102312
Hierarchy Name Eul5 Hierarchies.Actual Hi Name Eul5 Hierarchies.Ibh Dbh Id Eul5 Hierarchies.Actual Hi Name Eul5 Hierarchies.Ibh Dbh Id Eul5 Hierarchies.Actual Hi Name Eul5 Hierarchies.Ibh Dbh Id HI_NAME1102167
Hil Exp Id Eul5 Ig Exp Links.Hil Exp Id HIL_EXP_ID102139
Hil Hn Id Eul5 Ig Exp Links.Hil Hn Id HIL_HN_ID102144
Hn Created By Eul5 Hi Nodes.Hn Created By HN_CREATED_BY102178
Hn Created Date Eul5 Hi Nodes.Hn Created Date HN_CREATED_DATE102180
Hn Description Eul5 Hi Nodes.Hn Description HN_DESCRIPTION102182
Hn Ext Node Eul5 Hi Nodes.Hn Ext Node HN_EXT_NODE102184
Hn Hi Id Eul5 Hi Nodes.Hn Hi Id HN_HI_ID102186
Hn Id Eul5 Hi Nodes.Hn Id HN_ID102188
Ibh Dbh Id Eul5 Hierarchies.Ibh Dbh Id IBH_DBH_ID102197
Item Name Eul5 Hi Nodes.Hn Name Eul5 Hi Nodes.Hn Id Eul5 Hi Nodes.Hn Id AUTO_GENERATED_HN_NAME102194
Level Eul5 Hierarchies.Hi Id Eul5 Hi Nodes.Hn Id LEVEL102308
Order Eul5 Hierarchies.Hi Id Eul5 Ig Exp Links.Hil Hn Id ORDER102376
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
EUL5 Item Class SQL
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
EUL5 Item ClassesEul5 Domains, Eul5 Expressions, Eul5 ObjsSYSTEM.EUL5_DOMAINS SYSTEM.EUL5_EXPRESSIONS SYSTEM.EUL5_OBJS25-OCT-2006 25-OCT-2006 25-OCT-2006
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Actual Exp Name Eul5 Expressions.Exp Name EXP_NAME102056
Dom Cardinality Eul5 Domains.Dom Cardinality DOM_CARDINALITY101885
Dom Data Type Eul5 Domains.Dom Data Type DOM_DATA_TYPE101893
Dom Description Eul5 Domains.Dom Description DOM_DESCRIPTION101901
Dom Id Eul5 Domains.Dom Id DOM_ID101909
Dom It Id Lov Eul5 Domains.Dom It Id Lov DOM_IT_ID_LOV101915
Dom It Id Rank Eul5 Domains.Dom It Id Rank DOM_IT_ID_RANK101923
Dom Last Exec Time Eul5 Domains.Dom Last Exec Time DOM_LAST_EXEC_TIME101931
Dom Logical Item Eul5 Domains.Dom Logical Item DOM_LOGICAL_ITEM101939
Dom Name Eul5 Domains.Dom Name DOM_NAME101947
Dom Sys Generated Eul5 Domains.Dom Sys Generated DOM_SYS_GENERATED101957
Exp Id Eul5 Expressions.Exp Id EXP_ID102042
Exp Name Eul5 Expressions.Exp Id AUTO_GENERATED_EXP_NAME101785
Obj Id Eul5 Objs.Obj Id OBJ_ID102342
Obj Name Eul5 Objs.Obj Name OBJ_NAME102358
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
EUL5 Item Class SQL.Dom Id -> EUL5 Item Class Used By .Dom IdEUL5 Item Class SQL.Dom Id = EUL5 Item Class Used By .Dom IdMight not exist in master folderOuter join on master Yes
EUL5 Item Class Used By
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
EUL5 Item ClassesEul5 Domains, Eul5 Expressions, Eul5 ObjsSYSTEM.EUL5_DOMAINS SYSTEM.EUL5_EXPRESSIONS SYSTEM.EUL5_OBJS25-OCT-2006 25-OCT-2006 25-OCT-2006
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Actual Exp Name Eul5 Expressions.Exp Name EXP_NAME102058
Dom Cardinality Eul5 Domains.Dom Cardinality DOM_CARDINALITY101887
Dom Data Type Eul5 Domains.Dom Data Type DOM_DATA_TYPE101895
Dom Description Eul5 Domains.Dom Description DOM_DESCRIPTION101903
Dom Id Eul5 Domains.Dom Id DOM_ID101911
Dom It Id Lov Eul5 Domains.Dom It Id Lov DOM_IT_ID_LOV101917
Dom It Id Rank Eul5 Domains.Dom It Id Rank DOM_IT_ID_RANK101925
Dom Last Exec Time Eul5 Domains.Dom Last Exec Time DOM_LAST_EXEC_TIME101933
Dom Logical Item Eul5 Domains.Dom Logical Item DOM_LOGICAL_ITEM101941
Dom Name Eul5 Domains.Dom Name DOM_NAME101949
Dom Sys Generated Eul5 Domains.Dom Sys Generated DOM_SYS_GENERATED101959
Exp Id Eul5 Expressions.Exp Id EXP_ID102044
Exp Name Eul5 Expressions.Exp Id AUTO_GENERATED_EXP_NAME101787
Obj Id Eul5 Objs.Obj Id OBJ_ID102344
Obj Name Eul5 Objs.Obj Name OBJ_NAME102360
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
EUL5 Item Classes
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneEUL5 Alternate Sorts, Eul5 Domains, Eul5 Expressions, Eul5 Objs, EUL5 Item Class SQL, EUL5 Item Class Used By SYSTEM.EUL5_DOMAINS SYSTEM.EUL5_EXPRESSIONS SYSTEM.EUL5_OBJS25-OCT-2006 25-OCT-2006 25-OCT-2006
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Actual Item Class Name Eul5 Domains.Dom Name DOM_NAME101951
Actual Item Name Eul5 Expressions.Exp Name EXP_NAME1102062
Alternate Sort Actual Item Eul5 Expressions.Exp Name EXP_NAME102054
Alternate Sort Folder Eul5 Objs.Obj Name OBJ_NAME102356
Alternate Sort Item Eul5 Expressions.Exp Id AUTO_GENERATED_EXP_NAME1101793
AutoGen Eul5 Domains.Dom Name AUTOGEN101953
Dom Cardinality Eul5 Domains.Dom Cardinality DOM_CARDINALITY101889
Dom Data Type Eul5 Domains.Dom Data Type DOM_DATA_TYPE101897
Dom It Id Lov Eul5 Domains.Dom It Id Lov DOM_IT_ID_LOV101919
Dom It Id Rank Eul5 Domains.Dom It Id Rank DOM_IT_ID_RANK101927
Dom Last Exec Time Eul5 Domains.Dom Last Exec Time DOM_LAST_EXEC_TIME101935
Dom Logical Item Eul5 Domains.Dom Logical Item DOM_LOGICAL_ITEM101943
Dom Sys Generated Eul5 Domains.Dom Sys Generated DOM_SYS_GENERATED101961
Exp Id Eul5 Expressions.Exp Id EXP_ID102046
Folder Name Eul5 Objs.Obj Name OBJ_NAME1102364
Item Class Description Eul5 Domains.Dom Description DOM_DESCRIPTION101905
Item Class Name Eul5 Domains.Dom Name Eul5 Objs.Obj Name Eul5 Expressions.Exp Id DYNAMIC_ITEM_CLASS_NAME102368
Item Name Eul5 Expressions.Exp Id AUTO_GENERATED_EXP_NAME101789
Obj Id Eul5 Objs.Obj Id OBJ_ID102346
Primary Folder Eul5 Objs.Obj Name OBJ_NAME2102366
Primary Item Eul5 Expressions.Exp Id EXP_NAME2102064
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
EUL5 Joins
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneEul5 Expressions, Eul5 Key ConsSYSTEM.EUL5_EXPRESSIONS SYSTEM.EUL5_KEY_CONS25-OCT-2006 25-OCT-2006
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Actual Join Name Eul5 Key Cons.Key Name KEY_NAME102293
AutoGen Eul5 Key Cons.Key Name AUTOGEN102295
Detail Folder Id Eul5 Key Cons.Key Obj Id KEY_OBJ_ID102302
Exp Data Type Eul5 Expressions.Exp Data Type EXP_DATA_TYPE102024
Exp Formula Eul5 Expressions.Exp Formula EXP_FORMULA1102036
Exp Id Eul5 Expressions.Exp Id EXP_ID102048
Fk Dtl No Master Eul5 Key Cons.Fk Dtl No Master FK_DTL_NO_MASTER102084
Fk Key Id Remote Eul5 Key Cons.Fk Key Id Remote FK_KEY_ID_REMOTE102086
Fk Mandatory Eul5 Key Cons.Fk Mandatory FK_MANDATORY102088
Fk Mstr No Detail Eul5 Key Cons.Fk Mstr No Detail FK_MSTR_NO_DETAIL102090
Fk One To One Eul5 Key Cons.Fk One To One FK_ONE_TO_ONE102094
Join Description Eul5 Key Cons.Key Description KEY_DESCRIPTION102285
Join Details - Detail Item values: Eul5 Key Cons.Fk Mandatory JOIN_DETAILS__DETAIL_ITEM_VALUES102266
Join Developer Key Eul5 Key Cons.Key Developer Key KEY_DEVELOPER_KEY102287
Join Master --> Detail Eul5 Expressions.Exp Id JOIN_MASTER__DETAIL102273
Join Name Eul5 Key Cons.Key Name Eul5 Expressions.Exp Id Eul5 Key Cons.Key Name JOIN_NAME102297
Jp Key Id Eul5 Expressions.Jp Key Id JP_KEY_ID102283
Key Ext Key Eul5 Key Cons.Key Ext Key KEY_EXT_KEY102289
Key Id Eul5 Key Cons.Key Id KEY_ID102291
Key Updated By Eul5 Key Cons.Key Updated By KEY_UPDATED_BY102304
Key Updated Date Eul5 Key Cons.Key Updated Date KEY_UPDATED_DATE102306
Master Folder Id Eul5 Key Cons.Fk Obj Id Remote FK_OBJ_ID_REMOTE102092
One to One join Eul5 Key Cons.Fk One To One ONE_TO_ONE102372
Optional Join Configurations Eul5 Key Cons.Fk Mstr No Detail Eul5 Key Cons.Fk Dtl No Master Eul5 Key Cons.Fk One To One OPTIONAL_JOIN_CONFIGURATIONS102382
Outer Join on Detail Eul5 Key Cons.Fk Mstr No Detail OPTIONAL_JOIN_CONFIGUATIONS102374
Outer Join on Master Eul5 Key Cons.Fk Dtl No Master OUTER_JOIN_ON_MASTER102380
P Case Sensitive Eul5 Expressions.P Case Sensitive P_CASE_SENSITIVE102404
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
EUL5 Privileges
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneEul5 Access Privs, Eul5 App Params, Eul5 Eul UsersSYSTEM.EUL5_ACCESS_PRIVS SYSTEM.EUL5_APP_PARAMS SYSTEM.EUL5_EUL_USERS25-OCT-2006 25-OCT-2006 25-OCT-2006
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Ap Eu Id Eul5 Access Privs.Ap Eu Id AP_EU_ID101763
Ap Id Eul5 Access Privs.Ap Id AP_ID101765
Ap Type Eul5 Access Privs.Ap Type AP_TYPE101771
App Description Mn Eul5 App Params.App Description Mn APP_DESCRIPTION_MN101751
App Id Eul5 App Params.App Id APP_ID101753
App Name Mn Eul5 App Params.App Name Mn APP_NAME_MN101755
App Type Eul5 App Params.App Type APP_TYPE101757
Eu Batch Cmt Sz Eul5 Eul Users.Eu Batch Cmt Sz EU_BATCH_CMT_SZ101994
Eu Batch Expiry Eul5 Eul Users.Eu Batch Expiry EU_BATCH_EXPIRY101996
Eu Batch Jobs Lmt Eul5 Eul Users.Eu Batch Jobs Lmt EU_BATCH_JOBS_LMT101998
Eu Batch Qtime Lmt Eul5 Eul Users.Eu Batch Qtime Lmt EU_BATCH_QTIME_LMT102000
Eu Batch Rep User Eul5 Eul Users.Eu Batch Rep User EU_BATCH_REP_USER102002
Eu Batch Wnd End Eul5 Eul Users.Eu Batch Wnd End EU_BATCH_WND_END102004
Eu Batch Wnd Start Eul5 Eul Users.Eu Batch Wnd Start EU_BATCH_WND_START102006
Eu Query Est Lmt Eul5 Eul Users.Eu Query Est Lmt EU_QUERY_EST_LMT102008
Eu Query Time Lmt Eul5 Eul Users.Eu Query Time Lmt EU_QUERY_TIME_LMT102010
Eu Role Flag Eul5 Eul Users.Eu Role Flag EU_ROLE_FLAG102012
Eu Row Fetch Lmt Eul5 Eul Users.Eu Row Fetch Lmt EU_ROW_FETCH_LMT102016
Eu Use Pub Privs Eul5 Eul Users.Eu Use Pub Privs EU_USE_PUB_PRIVS102018
Gba Ba Id Eul5 Access Privs.Gba Ba Id GBA_BA_ID102133
Gp App Id Eul5 Access Privs.Gp App Id GP_APP_ID102137
Privilege Eul5 App Params.App Name Mn PRIVILEGE102392
Privilege Description Eul5 App Params.App Description Mn PRIVILEGE_DESCRIPTION102395
Privilege Sequence Eul5 App Params.App Name Mn PRIVILEGE_SEQUENCE102399
Sp Default Value Eul5 App Params.Sp Default Value SP_DEFAULT_VALUE102470
Sp Value Eul5 App Params.Sp Value SP_VALUE102472
User Type Eul5 Eul Users.Eu Role Flag USER_TYPE102603
Username Eul5 Eul Users.Eu Role Flag Eul5 Eul Users.Eu Username Username102607
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
EUL5 Security
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneEul5 Access Privs, Eul5 Eul UsersSYSTEM.EUL5_ACCESS_PRIVS SYSTEM.EUL5_EUL_USERS25-OCT-2006 25-OCT-2006
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Administration Allowed Eul5 Access Privs.Ap Priv Level ADMINISTRATION_ALLOWED101769
Ap Priv Level Eul5 Access Privs.Ap Priv Level AP_PRIV_LEVEL101767
Ap Type Eul5 Access Privs.Ap Type AP_TYPE101773
Eu Role Flag Eul5 Eul Users.Eu Role Flag EU_ROLE_FLAG102014
Gba Ba Id Eul5 Access Privs.Gba Ba Id GBA_BA_ID102135
User Type Eul5 Access Privs.Ap Priv Level USER_TYPE102605
Username Eul5 Eul Users.Eu Role Flag Eul5 Eul Users.Eu Username USERNAME102594
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
EUL5 Summary Folders
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
EUL5 Summary MappingsEul5 Summary Objs, EUL5 Existing Summary Combos , Eul5 Sum Rfsh Sets, EUL5 User JobsSYSTEM.EUL5_SUMMARY_OBJS25-OCT-2006
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Automatic Refresh Eul5 Sum Rfsh Sets.Srs Auto Refresh SRS_AUTO_REFRESH102476
Available for use in queries Eul5 Sum Rfsh Sets.Srs Online Eul5 Sum Rfsh Sets.Srs State AVAILABLE_FOR_USE_IN_QUERIES102504
Batch Process IdIdentifier of job. Neither import/export nor repeated executions change it.EUL5 User Jobs.Job JOB102264
Database Link Eul5 Summary Objs.Sdo Database Link SDO_DATABASE_LINK102442
Date Last Refresh Eul5 Sum Rfsh Sets.Srs Last Refresh SRS_LAST_REFRESH102486
Date Next Refresh Eul5 Sum Rfsh Sets.Srs Next Refresh SRS_NEXT_REFRESH102496
FailuresHow many times has this job started and failed since its last success?EUL5 User Jobs.Failures FAILURES102078
Internal Eul5 Summary Objs.Sumo Internal SUMO_INTERNAL102540
Last Refresh Eul5 Sum Rfsh Sets.Srs Last Refresh LAST_REFRESH102484
No Of Rows Eul5 Summary Objs.Sdo Num Rows SDO_NUM_ROWS102452
Refresh Date Eul5 Sum Rfsh Sets.Srs Next Refresh Eul5 Sum Rfsh Sets.Srs State REFRESH_DATE102515
Srs Online Eul5 Sum Rfsh Sets.Srs Online SRS_ONLINE102500
Srs State Eul5 Sum Rfsh Sets.Srs State SRS_STATE102509
Srs Type Eul5 Sum Rfsh Sets.Srs State SRS_TYPE102518
Summary Set Name Eul5 Sum Rfsh Sets.Srs Name SRS_NAME102490
Summary Status Eul5 Sum Rfsh Sets.Srs State SUMMARY_STATUS102529
Sumo Id Eul5 Summary Objs.Sumo Id SUMO_ID102536
Table Name Eul5 Summary Objs.Sdo Table Name SDO_TABLE_NAME102456
Table Owner Eul5 Summary Objs.Sdo Table Owner SDO_TABLE_OWNER102460
Total TimeTotal wallclock time spent by the system on this job, in secondsEUL5 User Jobs.Total Time TOTAL_TIME102561
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
EUL5 Summary Folders.Sumo Id -> Eul5 Summary Objs.Sumo IdEUL5 Summary Folders.Sumo Id = Eul5 Summary Objs.Sumo IdAlways exist in master folderNoneYes
EUL5 Summary Mappings
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneEul5 Expressions, Eul5 Objs, Eul5 Summary Objs, Eul5 Sumo Exp Usgs, EUL5 Summary Folders, EUL5 Existing Summary Combos , Eul5 Sum Rfsh Sets, EUL5 User JobsSYSTEM.EUL5_EXPRESSIONS SYSTEM.EUL5_OBJS SYSTEM.EUL5_SUMMARY_OBJS SYSTEM.EUL5_SUMO_EXP_USGS25-OCT-2006 25-OCT-2006 25-OCT-2006 25-OCT-2006
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Auto Generated Exp Name Eul5 Expressions.Exp Id AUTO_GENERATED_EXP_NAME101791
Available for use in queries Eul5 Sum Rfsh Sets.Srs Online Eul5 Sum Rfsh Sets.Srs State AVAILABLE_FOR_USE_IN_QUERIES102507
Database Link Eul5 Summary Objs.Sdo Database Link DATABASE_LINK102444
Exp Data Type Eul5 Expressions.Exp Data Type EXP_DATA_TYPE102026
Exp Description Eul5 Expressions.Exp Description EXP_DESCRIPTION102030
Exp Name Eul5 Expressions.Exp Name EXP_NAME102060
Exp Sequence Eul5 Expressions.Exp Sequence EXP_SEQUENCE102066
Exp Type Eul5 Expressions.Exp Type EXP_TYPE102070
Obj Id Eul5 Objs.Obj Id OBJ_ID102348
Obj Name Eul5 Objs.Obj Name OBJ_NAME102362
Sdo Database Link Eul5 Summary Objs.Sdo Database Link SDO_DATABASE_LINK102446
Sdo Table Name Eul5 Summary Objs.Sdo Table Name SDO_TABLE_NAME102458
Sdo Table Owner Eul5 Summary Objs.Sdo Table Owner SDO_TABLE_OWNER102462
Seu Ext Column Eul5 Sumo Exp Usgs.Seu Ext Column SEU_EXT_COLUMN102464
Siu Item Modified Eul5 Sumo Exp Usgs.Siu Item Modified SIU_ITEM_MODIFIED102466
Smiu Fun Id Eul5 Sumo Exp Usgs.Smiu Fun Id SMIU_FUN_ID102468
Srs State Eul5 Sum Rfsh Sets.Srs State SRS_STATE102511
Srs Type Eul5 Sum Rfsh Sets.Srs State SRS_TYPE102520
Summary Set Name Eul5 Sum Rfsh Sets.Srs Name SRS_NAME102492
Summary Status Eul5 Sum Rfsh Sets.Srs State SUMMARY_STATUS102532
Sumo Internal Eul5 Summary Objs.Sumo Internal SUMO_INTERNAL102542
Table Name Eul5 Summary Objs.Sdo Table Name TABLE_NAME102553
Table Owner Eul5 Summary Objs.Sdo Table Owner TABLE_OWNER102555
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
EUL5 Summary Mappings.Smiu Fun Id -> Eul5 Functions.Fun IdEUL5 Summary Mappings.Smiu Fun Id = Eul5 Functions.Fun IdMight not exist in master folderOuter join on detail Yes
EUL5 Table Privileges Received
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNoneUnknownUnknown
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Grantable EUL5 Table Privileges Received.GrantableGRANTABLEGRANTABLE101253
Grantee EUL5 Table Privileges Received.GranteeGRANTEEGRANTEE101255
Grantor EUL5 Table Privileges Received.GrantorGRANTORGRANTOR101257
Hierarchy EUL5 Table Privileges Received.HierarchyHIERARCHYHIERARCHY101269
Owner EUL5 Table Privileges Received.OwnerOWNEROWNER101489
Privilege EUL5 Table Privileges Received.PrivilegePRIVILEGEPRIVILEGE101500
Table Name EUL5 Table Privileges Received.Table NameTABLE_NAMETABLE_NAME101729
User USER102593
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
EUL5 User Jobs
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
EUL5 Existing Summary Combos , EUL5 Summary Folders, EUL5 Summary Mappings, EUL5 Users QueriesNoneSYS.USER_JOBSNot Analyzed
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
BrokenIf Y, no attempt is being made to run this job. See dbms_jobq.broken(job).EUL5 User Jobs.BrokenBROKENBROKEN100991
FailuresHow many times has this job started and failed since its last success?EUL5 User Jobs.FailuresFAILURESFAILURES101175
InstanceInstance number restricted to run the jobEUL5 User Jobs.InstanceINSTANCEINSTANCE101327
IntervalA date function, evaluated at the start of execution, becomes next NEXT_DATEEUL5 User Jobs.IntervalINTERVALINTERVAL101328
JobIdentifier of job. Neither import/export nor repeated executions change it.EUL5 User Jobs.JobJOBJOB101347
Last DateDate that this job last successfully executedEUL5 User Jobs.Last DateLAST_DATELAST_DATE101367
Last SecSame as LAST_DATE. This is when the last successful execution started.EUL5 User Jobs.Last SecLAST_SECLAST_SEC101370
Log UserUSER who was logged in when the job was submittedEUL5 User Jobs.Log UserLOG_USERLOG_USER101371
Misc Enva versioned raw maintained by the kernel, for other session parametersEUL5 User Jobs.Misc EnvMISC_ENVMISC_ENV101372
Next DateDate that this job will next be executedEUL5 User Jobs.Next DateNEXT_DATENEXT_DATE101385
Next SecSame as NEXT_DATE. The job becomes due for execution at this time.EUL5 User Jobs.Next SecNEXT_SECNEXT_SEC101386
Nls Envalter session parameters describing the NLS environment of the jobEUL5 User Jobs.Nls EnvNLS_ENVNLS_ENV101387
Priv UserUSER whose default privileges apply to this jobEUL5 User Jobs.Priv UserPRIV_USERPRIV_USER101501
Schema Userselect * from bar means select * from schema_user.bar EUL5 User Jobs.Schema UserSCHEMA_USERSCHEMA_USER101576
This DateDate that this job started executing (usually null if not executing)EUL5 User Jobs.This DateTHIS_DATETHIS_DATE101732
This SecSame as THIS_DATE. This is when the last successful execution started.EUL5 User Jobs.This SecTHIS_SECTHIS_SEC101734
Total TimeTotal wallclock time spent by the system on this job, in secondsEUL5 User Jobs.Total TimeTOTAL_TIMETOTAL_TIME101737
WhatBody of the anonymous PL/SQL block that this job executesEUL5 User Jobs.WhatWHATWHAT101747
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
EUL5 Users Queries
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneEul5 Qpp Stats, Eul5 Summary Objs, Eul5 Summary Objs Copy, EUL5 Existing Summary Combos , Eul5 Sum Rfsh Sets, EUL5 User JobsSYSTEM.EUL5_QPP_STATS SYSTEM.EUL5_SUMMARY_OBJS05-MAR-2007 25-OCT-2006
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Act Cpu Time Eul5 Qpp Stats.Act Cpu Time QS_ACT_CPU_TIME102406
Act Elap Time Eul5 Qpp Stats.Act Elap Time QS_ACT_ELAP_TIME102408
Condition Items Eul5 Qpp Stats.Id CONDITION_NAME101831
Created By Eul5 Qpp Stats.Created By QS_CREATED_BY102412
Created Date Eul5 Qpp Stats.Created Date QS_CREATED_DATE102414
Date Stamp Eul5 Qpp Stats.Created Date DATE_STAMP101836
Date Stamp Month Eul5 Qpp Stats.Created Date DATE_STAMP_MONTH101838
Date Stamp Quarter Eul5 Qpp Stats.Created Date DATE_STAMP_QUARTER101840
Date Stamp Year Eul5 Qpp Stats.Created Date DATE_STAMP_YEAR101842
Date Worksheet Last Ran Eul5 Qpp Stats.Created Date DATE_WORKSHEET_LAST_RAN101844
Folders Queried Eul5 Qpp Stats.Object Use Key FOLDER_NAME102123
Id Eul5 Qpp Stats.Id QS_ID102416
Items Queried Eul5 Qpp Stats.Id ITEM_NAME102243
Join Ids Eul5 Qpp Stats.Id JOIN_IDS102271
Join Name Eul5 Qpp Stats.Id JOIN_NAME102279
No of Queries Eul5 Qpp Stats.Id NO_OF_QUERIES102418
Num Rows Eul5 Qpp Stats.Num Rows QS_NUM_ROWS102420
Optimizer Cost Eul5 Qpp Stats.Optimizer Cost QS_COST102410
Owner=User Eul5 Qpp Stats.Doc Owner Eul5 Qpp Stats.Created By OWNERUSER102618
Query Status Eul5 Qpp Stats.State QUERY_STATUS102432
Rows Retrieved Eul5 Qpp Stats.Num Rows ROWS_RETRIEVED102438
Sbo Max Item Comb Eul5 Summary Objs Copy.Sbo Max Item Comb SBO_MAX_ITEM_COMB102440
Sdo Id Eul5 Qpp Stats.Sdo Id QS_SDO_ID102422
Sdo Sbo Id Eul5 Summary Objs.Sdo Sbo Id SDO_SBO_ID102454
State Eul5 Qpp Stats.State QS_STATE102424
Summary Fit Eul5 Qpp Stats.Summary Fit Id SUMMARY_FIT102525
Summary Name Eul5 Sum Rfsh Sets.Srs Name SUMMARY_NAME102527
Usernames Eul5 Qpp Stats.Created By USERNAMES102599
Workbook Name Eul5 Qpp Stats.Doc Name WORKBOOK_NAME102612
Workbook Owner Eul5 Qpp Stats.Doc Owner WORKBOOK_OWNER102614
Worksheet Name Eul5 Qpp Stats.Doc Details WORKSHEET_NAME102621
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
EUL5 Workbook Management
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneEul5 Access Privs, Eul5 Documents, Eul5 Eul UsersSYSTEM.EUL5_ACCESS_PRIVS SYSTEM.EUL5_DOCUMENTS SYSTEM.EUL5_EUL_USERS25-OCT-2006 Unknown 25-OCT-2006
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Date Document Created Eul5 Documents.Doc Created Date DOC_CREATED_DATE101863
Date Document Shared Eul5 Access Privs.Ap Created Date AP_CREATED_DATE101761
Doc Content Type Eul5 Documents.Doc Content Type DOC_CONTENT_TYPE101857
Doc Developer Key Eul5 Documents.Doc Developer Key DOC_DEVELOPER_KEY101867
Doc Id Eul5 Documents.Doc Id DOC_ID101871
Document Batch Eul5 Documents.Doc Batch DOC_BATCH101855
Document Created By Eul5 Documents.Doc Created By DOC_CREATED_BY101859
Document Description Eul5 Documents.Doc Description DOC_DESCRIPTION101865
Document Name Eul5 Documents.Doc Name DOC_NAME101875
Document Shared with Eul5 Eul Users.Eu Role Flag Eul5 Eul Users.Eu Username DOCUMENT_SHARED_WITH101850
Document Size (KB) Eul5 Documents.Doc Length DOC_LENGTH101873
Document Updated By Eul5 Documents.Doc Updated By DOC_UPDATED_BY101877
Document Updated Date Eul5 Documents.Doc Updated Date DOC_UPDATED_DATE101881
Doument Shared By Eul5 Access Privs.Ap Created By AP_CREATED_BY101759
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
EUL5 Workbook Management.Document Name -> EUL5 Users Queries.Workbook NameEUL5 Workbook Management.Document Name = EUL5 Users Queries.Workbook NameMight not exist in master folderOuter join on master Yes
Eul5 Access Privs
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
EUL5 Privileges, EUL5 Security, EUL5 Workbook ManagementNoneSYSTEM.EUL5_ACCESS_PRIVS25-OCT-2006
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Ap Created By Eul5 Access Privs.Ap Created ByAP_CREATED_BYAP_CREATED_BY100902
Ap Created Date Eul5 Access Privs.Ap Created DateAP_CREATED_DATEAP_CREATED_DATE100903
Ap Element State Eul5 Access Privs.Ap Element StateAP_ELEMENT_STATEAP_ELEMENT_STATE100904
Ap Eu Id Eul5 Access Privs.Ap Eu IdAP_EU_IDAP_EU_ID100905
Ap Id Eul5 Access Privs.Ap IdAP_IDAP_ID100906
Ap Priv Level Eul5 Access Privs.Ap Priv LevelAP_PRIV_LEVELAP_PRIV_LEVEL100907
Ap Type Eul5 Access Privs.Ap TypeAP_TYPEAP_TYPE100908
Ap Updated By Eul5 Access Privs.Ap Updated ByAP_UPDATED_BYAP_UPDATED_BY100909
Ap Updated Date Eul5 Access Privs.Ap Updated DateAP_UPDATED_DATEAP_UPDATED_DATE100910
Gba Ba Id Eul5 Access Privs.Gba Ba IdGBA_BA_IDGBA_BA_ID101248
Gd Doc Id Eul5 Access Privs.Gd Doc IdGD_DOC_IDGD_DOC_ID101249
Gp App Id Eul5 Access Privs.Gp App IdGP_APP_IDGP_APP_ID101251
Notm Eul5 Access Privs.NotmNOTMNOTM101388
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Eul5 App Params
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
EUL5 PrivilegesNoneSYSTEM.EUL5_APP_PARAMS25-OCT-2006
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
App Created By Eul5 App Params.App Created ByAPP_CREATED_BYAPP_CREATED_BY100893
App Created Date Eul5 App Params.App Created DateAPP_CREATED_DATEAPP_CREATED_DATE100894
App Description Mn Eul5 App Params.App Description MnAPP_DESCRIPTION_MNAPP_DESCRIPTION_MN100895
App Element State Eul5 App Params.App Element StateAPP_ELEMENT_STATEAPP_ELEMENT_STATE100896
App Id Eul5 App Params.App IdAPP_IDAPP_ID100897
App Name Mn Eul5 App Params.App Name MnAPP_NAME_MNAPP_NAME_MN100898
App Type Eul5 App Params.App TypeAPP_TYPEAPP_TYPE100899
App Updated By Eul5 App Params.App Updated ByAPP_UPDATED_BYAPP_UPDATED_BY100900
App Updated Date Eul5 App Params.App Updated DateAPP_UPDATED_DATEAPP_UPDATED_DATE100901
Notm Eul5 App Params.NotmNOTMNOTM101389
Sp Default Value Eul5 App Params.Sp Default ValueSP_DEFAULT_VALUESP_DEFAULT_VALUE101644
Sp Value Eul5 App Params.Sp ValueSP_VALUESP_VALUE101645
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Eul5 App Params.App Id -> Eul5 Access Privs.Gp App IdEul5 App Params.App Id = Eul5 Access Privs.Gp App IdMight not exist in master folderNoneYes
Eul5 Asm Policies
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNoneSYSTEM.EUL5_ASM_POLICIES25-OCT-2006
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Asmp Created By Eul5 Asm Policies.Asmp Created ByASMP_CREATED_BYASMP_CREATED_BY100911
Asmp Created Date Eul5 Asm Policies.Asmp Created DateASMP_CREATED_DATEASMP_CREATED_DATE100912
Asmp Description Eul5 Asm Policies.Asmp DescriptionASMP_DESCRIPTIONASMP_DESCRIPTION100913
Asmp Developer Key Eul5 Asm Policies.Asmp Developer KeyASMP_DEVELOPER_KEYASMP_DEVELOPER_KEY100914
Asmp Element State Eul5 Asm Policies.Asmp Element StateASMP_ELEMENT_STATEASMP_ELEMENT_STATE100915
Asmp Id Eul5 Asm Policies.Asmp IdASMP_IDASMP_ID100916
Asmp Name Eul5 Asm Policies.Asmp NameASMP_NAMEASMP_NAME100917
Asmp Updated By Eul5 Asm Policies.Asmp Updated ByASMP_UPDATED_BYASMP_UPDATED_BY100918
Asmp Updated Date Eul5 Asm Policies.Asmp Updated DateASMP_UPDATED_DATEASMP_UPDATED_DATE100919
Asmp User Prop1 Eul5 Asm Policies.Asmp User Prop1ASMP_USER_PROP1ASMP_USER_PROP1100920
Asmp User Prop2 Eul5 Asm Policies.Asmp User Prop2ASMP_USER_PROP2ASMP_USER_PROP2100921
Notm Eul5 Asm Policies.NotmNOTMNOTM101392
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Eul5 Asm Policies.Asmp Id -> Eul5 Summary Objs.Sumo Asmp IdEul5 Asm Policies.Asmp Id = Eul5 Summary Objs.Sumo Asmp IdAlways exist in master folderNoneYes
Eul5 Asm Policies.Asmp Id -> Eul5 Asmp Logs.Apl Asmp IdEul5 Asm Policies.Asmp Id = Eul5 Asmp Logs.Apl Asmp IdAlways exist in master folderNoneYes
Eul5 Asm Policies.Asmp Id -> Eul5 Summary Objs Copy.Sumo Asmp IdEul5 Asm Policies.Asmp Id = Eul5 Summary Objs Copy.Sumo Asmp IdAlways exist in master folderNoneYes
Eul5 Asm Policies.Asmp Id -> Eul5 Asmp Cons.Apc Asmp IdEul5 Asm Policies.Asmp Id = Eul5 Asmp Cons.Apc Asmp IdAlways exist in master folderNoneYes
Eul5 Asmp Cons
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNoneSYSTEM.EUL5_ASMP_CONS25-OCT-2006
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Aoc Obj Id Eul5 Asmp Cons.Aoc Obj IdAOC_OBJ_IDAOC_OBJ_ID100873
Apc Asmp Id Eul5 Asmp Cons.Apc Asmp IdAPC_ASMP_IDAPC_ASMP_ID100874
Apc Cons Type Eul5 Asmp Cons.Apc Cons TypeAPC_CONS_TYPEAPC_CONS_TYPE100875
Apc Created By Eul5 Asmp Cons.Apc Created ByAPC_CREATED_BYAPC_CREATED_BY100876
Apc Created Date Eul5 Asmp Cons.Apc Created DateAPC_CREATED_DATEAPC_CREATED_DATE100877
Apc Element State Eul5 Asmp Cons.Apc Element StateAPC_ELEMENT_STATEAPC_ELEMENT_STATE100878
Apc Id Eul5 Asmp Cons.Apc IdAPC_IDAPC_ID100879
Apc Type Eul5 Asmp Cons.Apc TypeAPC_TYPEAPC_TYPE100880
Apc Updated By Eul5 Asmp Cons.Apc Updated ByAPC_UPDATED_BYAPC_UPDATED_BY100881
Apc Updated Date Eul5 Asmp Cons.Apc Updated DateAPC_UPDATED_DATEAPC_UPDATED_DATE100882
Asoc Sumo Id Eul5 Asmp Cons.Asoc Sumo IdASOC_SUMO_IDASOC_SUMO_ID100922
Auc Eu Id Eul5 Asmp Cons.Auc Eu IdAUC_EU_IDAUC_EU_ID100923
Notm Eul5 Asmp Cons.NotmNOTMNOTM101390
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Eul5 Asmp Logs
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNoneSYSTEM.EUL5_ASMP_LOGS25-OCT-2006
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Apl Asmp Id Eul5 Asmp Logs.Apl Asmp IdAPL_ASMP_IDAPL_ASMP_ID100883
Apl Created By Eul5 Asmp Logs.Apl Created ByAPL_CREATED_BYAPL_CREATED_BY100884
Apl Created Date Eul5 Asmp Logs.Apl Created DateAPL_CREATED_DATEAPL_CREATED_DATE100885
Apl Element State Eul5 Asmp Logs.Apl Element StateAPL_ELEMENT_STATEAPL_ELEMENT_STATE100886
Apl Event Type Eul5 Asmp Logs.Apl Event TypeAPL_EVENT_TYPEAPL_EVENT_TYPE100887
Apl Id Eul5 Asmp Logs.Apl IdAPL_IDAPL_ID100888
Apl Sumo Id Eul5 Asmp Logs.Apl Sumo IdAPL_SUMO_IDAPL_SUMO_ID100889
Apl Timestamp Eul5 Asmp Logs.Apl TimestampAPL_TIMESTAMPAPL_TIMESTAMP100890
Apl Updated By Eul5 Asmp Logs.Apl Updated ByAPL_UPDATED_BYAPL_UPDATED_BY100891
Apl Updated Date Eul5 Asmp Logs.Apl Updated DateAPL_UPDATED_DATEAPL_UPDATED_DATE100892
Notm Eul5 Asmp Logs.NotmNOTMNOTM101391
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Eul5 Ba Obj Links
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
EUL5 Business Areas & FoldersNoneSYSTEM.EUL5_BA_OBJ_LINKS25-OCT-2006
EUL5 Business Areas & FoldersNoneSYSTEM.EUL5_BA_OBJ_LINKS25-OCT-2006
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Bol Ba Id Eul5 Ba Obj Links.Bol Ba IdBOL_BA_IDBOL_BA_ID100939
Bol Created By Eul5 Ba Obj Links.Bol Created ByBOL_CREATED_BYBOL_CREATED_BY100940
Bol Created Date Eul5 Ba Obj Links.Bol Created DateBOL_CREATED_DATEBOL_CREATED_DATE100941
Bol Element State Eul5 Ba Obj Links.Bol Element StateBOL_ELEMENT_STATEBOL_ELEMENT_STATE100942
Bol Id Eul5 Ba Obj Links.Bol IdBOL_IDBOL_ID100943
Bol Obj Id Eul5 Ba Obj Links.Bol Obj IdBOL_OBJ_IDBOL_OBJ_ID100944
Bol Sequence Eul5 Ba Obj Links.Bol SequenceBOL_SEQUENCEBOL_SEQUENCE100945
Bol Updated By Eul5 Ba Obj Links.Bol Updated ByBOL_UPDATED_BYBOL_UPDATED_BY100946
Bol Updated Date Eul5 Ba Obj Links.Bol Updated DateBOL_UPDATED_DATEBOL_UPDATED_DATE100947
Notm Eul5 Ba Obj Links.NotmNOTMNOTM101398
Bol Ba Id Eul5 Ba Obj Links.Bol Ba IdBOL_BA_IDBOL_BA_ID100939
Bol Created By Eul5 Ba Obj Links.Bol Created ByBOL_CREATED_BYBOL_CREATED_BY100940
Bol Created Date Eul5 Ba Obj Links.Bol Created DateBOL_CREATED_DATEBOL_CREATED_DATE100941
Bol Element State Eul5 Ba Obj Links.Bol Element StateBOL_ELEMENT_STATEBOL_ELEMENT_STATE100942
Bol Id Eul5 Ba Obj Links.Bol IdBOL_IDBOL_ID100943
Bol Obj Id Eul5 Ba Obj Links.Bol Obj IdBOL_OBJ_IDBOL_OBJ_ID100944
Bol Sequence Eul5 Ba Obj Links.Bol SequenceBOL_SEQUENCEBOL_SEQUENCE100945
Bol Updated By Eul5 Ba Obj Links.Bol Updated ByBOL_UPDATED_BYBOL_UPDATED_BY100946
Bol Updated Date Eul5 Ba Obj Links.Bol Updated DateBOL_UPDATED_DATEBOL_UPDATED_DATE100947
Notm Eul5 Ba Obj Links.NotmNOTMNOTM101398
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Eul5 Bas
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
EUL5 Business Areas & FoldersNoneSYSTEM.EUL5_BAS25-OCT-2006
EUL5 Business Areas & FoldersNoneSYSTEM.EUL5_BAS25-OCT-2006
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Ba Created By Eul5 Bas.Ba Created ByBA_CREATED_BYBA_CREATED_BY100924
Ba Created Date Eul5 Bas.Ba Created DateBA_CREATED_DATEBA_CREATED_DATE100925
Ba Description Eul5 Bas.Ba DescriptionBA_DESCRIPTIONBA_DESCRIPTION100926
Ba Developer Key Eul5 Bas.Ba Developer KeyBA_DEVELOPER_KEYBA_DEVELOPER_KEY100927
Ba Element State Eul5 Bas.Ba Element StateBA_ELEMENT_STATEBA_ELEMENT_STATE100928
Ba Ext Name Eul5 Bas.Ba Ext NameBA_EXT_NAMEBA_EXT_NAME100929
Ba Id Eul5 Bas.Ba IdBA_IDBA_ID100930
Ba Name Eul5 Bas.Ba NameBA_NAMEBA_NAME100931
Ba Updated By Eul5 Bas.Ba Updated ByBA_UPDATED_BYBA_UPDATED_BY100932
Ba Updated Date Eul5 Bas.Ba Updated DateBA_UPDATED_DATEBA_UPDATED_DATE100933
Ba User Prop1 Eul5 Bas.Ba User Prop1BA_USER_PROP1BA_USER_PROP1100934
Ba User Prop2 Eul5 Bas.Ba User Prop2BA_USER_PROP2BA_USER_PROP2100935
Notm Eul5 Bas.NotmNOTMNOTM101393
Ba Created By Eul5 Bas.Ba Created ByBA_CREATED_BYBA_CREATED_BY100924
Ba Created Date Eul5 Bas.Ba Created DateBA_CREATED_DATEBA_CREATED_DATE100925
Ba Description Eul5 Bas.Ba DescriptionBA_DESCRIPTIONBA_DESCRIPTION100926
Ba Developer Key Eul5 Bas.Ba Developer KeyBA_DEVELOPER_KEYBA_DEVELOPER_KEY100927
Ba Element State Eul5 Bas.Ba Element StateBA_ELEMENT_STATEBA_ELEMENT_STATE100928
Ba Ext Name Eul5 Bas.Ba Ext NameBA_EXT_NAMEBA_EXT_NAME100929
Ba Id Eul5 Bas.Ba IdBA_IDBA_ID100930
Ba Name Eul5 Bas.Ba NameBA_NAMEBA_NAME100931
Ba Updated By Eul5 Bas.Ba Updated ByBA_UPDATED_BYBA_UPDATED_BY100932
Ba Updated Date Eul5 Bas.Ba Updated DateBA_UPDATED_DATEBA_UPDATED_DATE100933
Ba User Prop1 Eul5 Bas.Ba User Prop1BA_USER_PROP1BA_USER_PROP1100934
Ba User Prop2 Eul5 Bas.Ba User Prop2BA_USER_PROP2BA_USER_PROP2100935
Notm Eul5 Bas.NotmNOTMNOTM101393
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Eul5 Bas.Ba Id -> Eul5 Access Privs.Gba Ba IdEul5 Bas.Ba Id = Eul5 Access Privs.Gba Ba IdAlways exist in master folderNoneYes
Eul5 Bas.Ba Id -> Eul5 Ba Obj Links.Bol Ba IdEul5 Bas.Ba Id = Eul5 Ba Obj Links.Bol Ba IdMight not exist in master folderOuter join on master Yes
Eul5 Bas.Ba Id -> Eul5 Objs.Obj Ba IdEul5 Bas.Ba Id = Eul5 Objs.Obj Ba IdAlways exist in master folderNoneYes
Eul5 Batch Params
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNoneSYSTEM.EUL5_BATCH_PARAMS25-OCT-2006
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Bp Bs Id Eul5 Batch Params.Bp Bs IdBP_BS_IDBP_BS_ID100948
Bp Created By Eul5 Batch Params.Bp Created ByBP_CREATED_BYBP_CREATED_BY100949
Bp Created Date Eul5 Batch Params.Bp Created DateBP_CREATED_DATEBP_CREATED_DATE100950
Bp Element State Eul5 Batch Params.Bp Element StateBP_ELEMENT_STATEBP_ELEMENT_STATE100951
Bp Id Eul5 Batch Params.Bp IdBP_IDBP_ID100952
Bp Name Eul5 Batch Params.Bp NameBP_NAMEBP_NAME100953
Bp Updated By Eul5 Batch Params.Bp Updated ByBP_UPDATED_BYBP_UPDATED_BY100954
Bp Updated Date Eul5 Batch Params.Bp Updated DateBP_UPDATED_DATEBP_UPDATED_DATE100955
Bp Value1 Eul5 Batch Params.Bp Value1BP_VALUE1BP_VALUE1100956
Bp Value2 Eul5 Batch Params.Bp Value2BP_VALUE2BP_VALUE2100957
Bp Value3 Eul5 Batch Params.Bp Value3BP_VALUE3BP_VALUE3100958
Bp Value4 Eul5 Batch Params.Bp Value4BP_VALUE4BP_VALUE4100959
Bp Value5 Eul5 Batch Params.Bp Value5BP_VALUE5BP_VALUE5100960
Bp Value6 Eul5 Batch Params.Bp Value6BP_VALUE6BP_VALUE6100961
Notm Eul5 Batch Params.NotmNOTMNOTM101394
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Eul5 Batch Queries
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNoneSYSTEM.EUL5_BATCH_QUERIES25-OCT-2006
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Bq Bs Id Eul5 Batch Queries.Bq Bs IdBQ_BS_IDBQ_BS_ID100979
Bq Created By Eul5 Batch Queries.Bq Created ByBQ_CREATED_BYBQ_CREATED_BY100980
Bq Created Date Eul5 Batch Queries.Bq Created DateBQ_CREATED_DATEBQ_CREATED_DATE100981
Bq Element State Eul5 Batch Queries.Bq Element StateBQ_ELEMENT_STATEBQ_ELEMENT_STATE100982
Bq Id Eul5 Batch Queries.Bq IdBQ_IDBQ_ID100983
Bq Query Id Eul5 Batch Queries.Bq Query IdBQ_QUERY_IDBQ_QUERY_ID100984
Bq Result Sql 1 Eul5 Batch Queries.Bq Result Sql 1BQ_RESULT_SQL_1BQ_RESULT_SQL_1100985
Bq Result Sql 2 Eul5 Batch Queries.Bq Result Sql 2BQ_RESULT_SQL_2BQ_RESULT_SQL_2100986
Bq Result Sql 3 Eul5 Batch Queries.Bq Result Sql 3BQ_RESULT_SQL_3BQ_RESULT_SQL_3100987
Bq Result Sql 4 Eul5 Batch Queries.Bq Result Sql 4BQ_RESULT_SQL_4BQ_RESULT_SQL_4100988
Bq Updated By Eul5 Batch Queries.Bq Updated ByBQ_UPDATED_BYBQ_UPDATED_BY100989
Bq Updated Date Eul5 Batch Queries.Bq Updated DateBQ_UPDATED_DATEBQ_UPDATED_DATE100990
Notm Eul5 Batch Queries.NotmNOTMNOTM101395
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Eul5 Batch Queries.Bq Id -> Eul5 Bq Tables.Bqt Bq IdEul5 Batch Queries.Bq Id = Eul5 Bq Tables.Bqt Bq IdAlways exist in master folderNoneYes
Eul5 Batch Queries.Bq Id -> Eul5 Segments.Seg Bq IdEul5 Batch Queries.Bq Id = Eul5 Segments.Seg Bq IdAlways exist in master folderNoneYes
Eul5 Batch Queries.Bq Id -> Eul5 Bq Deps.Bqd Bq IdEul5 Batch Queries.Bq Id = Eul5 Bq Deps.Bqd Bq IdAlways exist in master folderNoneYes
Eul5 Batch Reports
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNoneSYSTEM.EUL5_BATCH_REPORTS25-OCT-2006
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Br Auto Refresh Eul5 Batch Reports.Br Auto RefreshBR_AUTO_REFRESHBR_AUTO_REFRESH101005
Br Completion Date Eul5 Batch Reports.Br Completion DateBR_COMPLETION_DATEBR_COMPLETION_DATE101006
Br Created By Eul5 Batch Reports.Br Created ByBR_CREATED_BYBR_CREATED_BY101007
Br Created Date Eul5 Batch Reports.Br Created DateBR_CREATED_DATEBR_CREATED_DATE101008
Br Description Eul5 Batch Reports.Br DescriptionBR_DESCRIPTIONBR_DESCRIPTION101009
Br Element State Eul5 Batch Reports.Br Element StateBR_ELEMENT_STATEBR_ELEMENT_STATE101010
Br Eu Id Eul5 Batch Reports.Br Eu IdBR_EU_IDBR_EU_ID101011
Br Expiry Eul5 Batch Reports.Br ExpiryBR_EXPIRYBR_EXPIRY101012
Br Id Eul5 Batch Reports.Br IdBR_IDBR_ID101013
Br Job Id Eul5 Batch Reports.Br Job IdBR_JOB_IDBR_JOB_ID101014
Br Name Eul5 Batch Reports.Br NameBR_NAMEBR_NAME101015
Br Next Run Date Eul5 Batch Reports.Br Next Run DateBR_NEXT_RUN_DATEBR_NEXT_RUN_DATE101016
Br Num Freq Units Eul5 Batch Reports.Br Num Freq UnitsBR_NUM_FREQ_UNITSBR_NUM_FREQ_UNITS101017
Br Overwrite Rslts Eul5 Batch Reports.Br Overwrite RsltsBR_OVERWRITE_RSLTSBR_OVERWRITE_RSLTS101018
Br Report Schema Eul5 Batch Reports.Br Report SchemaBR_REPORT_SCHEMABR_REPORT_SCHEMA101019
Br Rfu Id Eul5 Batch Reports.Br Rfu IdBR_RFU_IDBR_RFU_ID101020
Br Updated By Eul5 Batch Reports.Br Updated ByBR_UPDATED_BYBR_UPDATED_BY101021
Br Updated Date Eul5 Batch Reports.Br Updated DateBR_UPDATED_DATEBR_UPDATED_DATE101022
Br Workbook Name Eul5 Batch Reports.Br Workbook NameBR_WORKBOOK_NAMEBR_WORKBOOK_NAME101023
Notm Eul5 Batch Reports.NotmNOTMNOTM101396
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Eul5 Batch Reports.Br Id -> Eul5 Br Runs.Brr Br IdEul5 Batch Reports.Br Id = Eul5 Br Runs.Brr Br IdAlways exist in master folderNoneYes
Eul5 Batch Reports.Br Id -> Eul5 Batch Sheets.Bs Br IdEul5 Batch Reports.Br Id = Eul5 Batch Sheets.Bs Br IdAlways exist in master folderNoneYes
Eul5 Batch Sheets
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNoneSYSTEM.EUL5_BATCH_SHEETS25-OCT-2006
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Bs Br Id Eul5 Batch Sheets.Bs Br IdBS_BR_IDBS_BR_ID101024
Bs Created By Eul5 Batch Sheets.Bs Created ByBS_CREATED_BYBS_CREATED_BY101025
Bs Created Date Eul5 Batch Sheets.Bs Created DateBS_CREATED_DATEBS_CREATED_DATE101026
Bs Element State Eul5 Batch Sheets.Bs Element StateBS_ELEMENT_STATEBS_ELEMENT_STATE101027
Bs Id Eul5 Batch Sheets.Bs IdBS_IDBS_ID101028
Bs Sheet Id Eul5 Batch Sheets.Bs Sheet IdBS_SHEET_IDBS_SHEET_ID101029
Bs Sheet Name Eul5 Batch Sheets.Bs Sheet NameBS_SHEET_NAMEBS_SHEET_NAME101030
Bs Updated By Eul5 Batch Sheets.Bs Updated ByBS_UPDATED_BYBS_UPDATED_BY101031
Bs Updated Date Eul5 Batch Sheets.Bs Updated DateBS_UPDATED_DATEBS_UPDATED_DATE101032
Notm Eul5 Batch Sheets.NotmNOTMNOTM101397
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Eul5 Batch Sheets.Bs Id -> Eul5 Batch Params.Bp Bs IdEul5 Batch Sheets.Bs Id = Eul5 Batch Params.Bp Bs IdAlways exist in master folderNoneYes
Eul5 Batch Sheets.Bs Id -> Eul5 Batch Queries.Bq Bs IdEul5 Batch Sheets.Bs Id = Eul5 Batch Queries.Bq Bs IdAlways exist in master folderNoneYes
Eul5 Bq Deps
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNoneSYSTEM.EUL5_BQ_DEPS25-OCT-2006
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Bfild Fil Id Eul5 Bq Deps.Bfild Fil IdBFILD_FIL_IDBFILD_FIL_ID100936
Bfund Fun Id Eul5 Bq Deps.Bfund Fun IdBFUND_FUN_IDBFUND_FUN_ID100937
Bid It Id Eul5 Bq Deps.Bid It IdBID_IT_IDBID_IT_ID100938
Bqd Bq Id Eul5 Bq Deps.Bqd Bq IdBQD_BQ_IDBQD_BQ_ID100962
Bqd Created By Eul5 Bq Deps.Bqd Created ByBQD_CREATED_BYBQD_CREATED_BY100963
Bqd Created Date Eul5 Bq Deps.Bqd Created DateBQD_CREATED_DATEBQD_CREATED_DATE100964
Bqd Element State Eul5 Bq Deps.Bqd Element StateBQD_ELEMENT_STATEBQD_ELEMENT_STATE100965
Bqd Id Eul5 Bq Deps.Bqd IdBQD_IDBQD_ID100966
Bqd Type Eul5 Bq Deps.Bqd TypeBQD_TYPEBQD_TYPE100967
Bqd Updated By Eul5 Bq Deps.Bqd Updated ByBQD_UPDATED_BYBQD_UPDATED_BY100968
Bqd Updated Date Eul5 Bq Deps.Bqd Updated DateBQD_UPDATED_DATEBQD_UPDATED_DATE100969
Notm Eul5 Bq Deps.NotmNOTMNOTM101399
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Eul5 Bq Tables
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNoneSYSTEM.EUL5_BQ_TABLES25-OCT-2006
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Bqt Bq Id Eul5 Bq Tables.Bqt Bq IdBQT_BQ_IDBQT_BQ_ID100970
Bqt Brr Id Eul5 Bq Tables.Bqt Brr IdBQT_BRR_IDBQT_BRR_ID100971
Bqt Created By Eul5 Bq Tables.Bqt Created ByBQT_CREATED_BYBQT_CREATED_BY100972
Bqt Created Date Eul5 Bq Tables.Bqt Created DateBQT_CREATED_DATEBQT_CREATED_DATE100973
Bqt Element State Eul5 Bq Tables.Bqt Element StateBQT_ELEMENT_STATEBQT_ELEMENT_STATE100974
Bqt Id Eul5 Bq Tables.Bqt IdBQT_IDBQT_ID100975
Bqt Table Name Eul5 Bq Tables.Bqt Table NameBQT_TABLE_NAMEBQT_TABLE_NAME100976
Bqt Updated By Eul5 Bq Tables.Bqt Updated ByBQT_UPDATED_BYBQT_UPDATED_BY100977
Bqt Updated Date Eul5 Bq Tables.Bqt Updated DateBQT_UPDATED_DATEBQT_UPDATED_DATE100978
Notm Eul5 Bq Tables.NotmNOTMNOTM101400
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Eul5 Br Runs
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNoneSYSTEM.EUL5_BR_RUNS25-OCT-2006
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Brr Act Elap Time Eul5 Br Runs.Brr Act Elap TimeBRR_ACT_ELAP_TIMEBRR_ACT_ELAP_TIME100992
Brr Br Id Eul5 Br Runs.Brr Br IdBRR_BR_IDBRR_BR_ID100993
Brr Created By Eul5 Br Runs.Brr Created ByBRR_CREATED_BYBRR_CREATED_BY100994
Brr Created Date Eul5 Br Runs.Brr Created DateBRR_CREATED_DATEBRR_CREATED_DATE100995
Brr Element State Eul5 Br Runs.Brr Element StateBRR_ELEMENT_STATEBRR_ELEMENT_STATE100996
Brr Id Eul5 Br Runs.Brr IdBRR_IDBRR_ID100997
Brr Run Date Eul5 Br Runs.Brr Run DateBRR_RUN_DATEBRR_RUN_DATE100998
Brr Run Number Eul5 Br Runs.Brr Run NumberBRR_RUN_NUMBERBRR_RUN_NUMBER100999
Brr State Eul5 Br Runs.Brr StateBRR_STATEBRR_STATE101000
Brr Svr Err Code Eul5 Br Runs.Brr Svr Err CodeBRR_SVR_ERR_CODEBRR_SVR_ERR_CODE101001
Brr Svr Err Text Eul5 Br Runs.Brr Svr Err TextBRR_SVR_ERR_TEXTBRR_SVR_ERR_TEXT101002
Brr Updated By Eul5 Br Runs.Brr Updated ByBRR_UPDATED_BYBRR_UPDATED_BY101003
Brr Updated Date Eul5 Br Runs.Brr Updated DateBRR_UPDATED_DATEBRR_UPDATED_DATE101004
Notm Eul5 Br Runs.NotmNOTMNOTM101401
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Eul5 Br Runs.Brr Id -> Eul5 Bq Tables.Bqt Brr IdEul5 Br Runs.Brr Id = Eul5 Bq Tables.Bqt Brr IdAlways exist in master folderNoneYes
Eul5 Dbh Nodes
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNoneSYSTEM.EUL5_DBH_NODES25-OCT-2006
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Dhn Created By Eul5 Dbh Nodes.Dhn Created ByDHN_CREATED_BYDHN_CREATED_BY101046
Dhn Created Date Eul5 Dbh Nodes.Dhn Created DateDHN_CREATED_DATEDHN_CREATED_DATE101047
Dhn Data Fmt Msk Eul5 Dbh Nodes.Dhn Data Fmt MskDHN_DATA_FMT_MSKDHN_DATA_FMT_MSK101048
Dhn Description Eul5 Dbh Nodes.Dhn DescriptionDHN_DESCRIPTIONDHN_DESCRIPTION101049
Dhn Developer Key Eul5 Dbh Nodes.Dhn Developer KeyDHN_DEVELOPER_KEYDHN_DEVELOPER_KEY101050
Dhn Disp Fmt Msk Eul5 Dbh Nodes.Dhn Disp Fmt MskDHN_DISP_FMT_MSKDHN_DISP_FMT_MSK101051
Dhn Element State Eul5 Dbh Nodes.Dhn Element StateDHN_ELEMENT_STATEDHN_ELEMENT_STATE101052
Dhn Hi Id Eul5 Dbh Nodes.Dhn Hi IdDHN_HI_IDDHN_HI_ID101053
Dhn Id Eul5 Dbh Nodes.Dhn IdDHN_IDDHN_ID101054
Dhn Name Eul5 Dbh Nodes.Dhn NameDHN_NAMEDHN_NAME101055
Dhn Updated By Eul5 Dbh Nodes.Dhn Updated ByDHN_UPDATED_BYDHN_UPDATED_BY101056
Dhn Updated Date Eul5 Dbh Nodes.Dhn Updated DateDHN_UPDATED_DATEDHN_UPDATED_DATE101057
Dhn User Prop1 Eul5 Dbh Nodes.Dhn User Prop1DHN_USER_PROP1DHN_USER_PROP1101058
Dhn User Prop2 Eul5 Dbh Nodes.Dhn User Prop2DHN_USER_PROP2DHN_USER_PROP2101059
Notm Eul5 Dbh Nodes.NotmNOTMNOTM101402
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Eul5 Dbh Nodes.Dhn Id -> Eul5 Hi Segments.Dhs Dhn Id ChildEul5 Dbh Nodes.Dhn Id = Eul5 Hi Segments.Dhs Dhn Id ChildAlways exist in master folderNoneYes
Eul5 Dbh Nodes.Dhn Id -> Eul5 Hi Segments.Dhs Dhn Id ParentEul5 Dbh Nodes.Dhn Id = Eul5 Hi Segments.Dhs Dhn Id ParentAlways exist in master folderNoneYes
Eul5 Documents
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
EUL5 Workbook ManagementNoneSYSTEM.EUL5_DOCUMENTSUnknown
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Doc Batch Eul5 Documents.Doc BatchDOC_BATCHDOC_BATCH101064
Doc Content Type Eul5 Documents.Doc Content TypeDOC_CONTENT_TYPEDOC_CONTENT_TYPE101065
Doc Created By Eul5 Documents.Doc Created ByDOC_CREATED_BYDOC_CREATED_BY101066
Doc Created Date Eul5 Documents.Doc Created DateDOC_CREATED_DATEDOC_CREATED_DATE101067
Doc Description Eul5 Documents.Doc DescriptionDOC_DESCRIPTIONDOC_DESCRIPTION101068
Doc Developer Key Eul5 Documents.Doc Developer KeyDOC_DEVELOPER_KEYDOC_DEVELOPER_KEY101069
Doc Document Eul5 Documents.Doc DocumentDOC_DOCUMENTDOC_DOCUMENT101070
Doc Element State Eul5 Documents.Doc Element StateDOC_ELEMENT_STATEDOC_ELEMENT_STATE101071
Doc Eu Id Eul5 Documents.Doc Eu IdDOC_EU_IDDOC_EU_ID101072
Doc Id Eul5 Documents.Doc IdDOC_IDDOC_ID101073
Doc Length Eul5 Documents.Doc LengthDOC_LENGTHDOC_LENGTH101074
Doc Name Eul5 Documents.Doc NameDOC_NAMEDOC_NAME101075
Doc Updated By Eul5 Documents.Doc Updated ByDOC_UPDATED_BYDOC_UPDATED_BY101076
Doc Updated Date Eul5 Documents.Doc Updated DateDOC_UPDATED_DATEDOC_UPDATED_DATE101077
Doc User Prop1 Eul5 Documents.Doc User Prop1DOC_USER_PROP1DOC_USER_PROP1101078
Doc User Prop2 Eul5 Documents.Doc User Prop2DOC_USER_PROP2DOC_USER_PROP2101079
Notm Eul5 Documents.NotmNOTMNOTM101403
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Eul5 Documents.Doc Id -> Eul5 Expressions.It Doc IdEul5 Documents.Doc Id = Eul5 Expressions.It Doc IdAlways exist in master folderNoneYes
Eul5 Documents.Doc Id -> Eul5 Access Privs.Gd Doc IdEul5 Documents.Doc Id = Eul5 Access Privs.Gd Doc IdMight not exist in master folderOuter join on detail Yes
Eul5 Documents.Doc Id -> Eul5 Expressions.Fil Doc IdEul5 Documents.Doc Id = Eul5 Expressions.Fil Doc IdAlways exist in master folderNoneYes
Eul5 Domains
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
EUL5 Alternate Sorts, EUL5 Item Classes, EUL5 Item Class SQL, EUL5 Item Class Used By NoneSYSTEM.EUL5_DOMAINS25-OCT-2006
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Dom Array Fetch Sz Eul5 Domains.Dom Array Fetch SzDOM_ARRAY_FETCH_SZDOM_ARRAY_FETCH_SZ101080
Dom Cached Eul5 Domains.Dom CachedDOM_CACHEDDOM_CACHED101081
Dom Cardinality Eul5 Domains.Dom CardinalityDOM_CARDINALITYDOM_CARDINALITY101082
Dom Created By Eul5 Domains.Dom Created ByDOM_CREATED_BYDOM_CREATED_BY101083
Dom Created Date Eul5 Domains.Dom Created DateDOM_CREATED_DATEDOM_CREATED_DATE101084
Dom Data Type Eul5 Domains.Dom Data TypeDOM_DATA_TYPEDOM_DATA_TYPE101085
Dom Description Eul5 Domains.Dom DescriptionDOM_DESCRIPTIONDOM_DESCRIPTION101086
Dom Developer Key Eul5 Domains.Dom Developer KeyDOM_DEVELOPER_KEYDOM_DEVELOPER_KEY101087
Dom Dist Ord By Eul5 Domains.Dom Dist Ord ByDOM_DIST_ORD_BYDOM_DIST_ORD_BY101088
Dom Element State Eul5 Domains.Dom Element StateDOM_ELEMENT_STATEDOM_ELEMENT_STATE101089
Dom Ftch Immediate Eul5 Domains.Dom Ftch ImmediateDOM_FTCH_IMMEDIATEDOM_FTCH_IMMEDIATE101090
Dom Id Eul5 Domains.Dom IdDOM_IDDOM_ID101091
Dom It Id Lov Eul5 Domains.Dom It Id LovDOM_IT_ID_LOVDOM_IT_ID_LOV101092
Dom It Id Rank Eul5 Domains.Dom It Id RankDOM_IT_ID_RANKDOM_IT_ID_RANK101093
Dom Last Exec Time Eul5 Domains.Dom Last Exec TimeDOM_LAST_EXEC_TIMEDOM_LAST_EXEC_TIME101094
Dom Logical Item Eul5 Domains.Dom Logical ItemDOM_LOGICAL_ITEMDOM_LOGICAL_ITEM101095
Dom Name Eul5 Domains.Dom NameDOM_NAMEDOM_NAME101096
Dom Show Navigator Eul5 Domains.Dom Show NavigatorDOM_SHOW_NAVIGATORDOM_SHOW_NAVIGATOR101097
Dom Sys Generated Eul5 Domains.Dom Sys GeneratedDOM_SYS_GENERATEDDOM_SYS_GENERATED101098
Dom Updated By Eul5 Domains.Dom Updated ByDOM_UPDATED_BYDOM_UPDATED_BY101099
Dom Updated Date Eul5 Domains.Dom Updated DateDOM_UPDATED_DATEDOM_UPDATED_DATE101100
Dom User Prop1 Eul5 Domains.Dom User Prop1DOM_USER_PROP1DOM_USER_PROP1101101
Dom User Prop2 Eul5 Domains.Dom User Prop2DOM_USER_PROP2DOM_USER_PROP2101102
Notm Eul5 Domains.NotmNOTMNOTM101404
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Eul5 Domains.Dom Id -> Eul5 Expressions.It Dom IdEul5 Domains.Dom Id = Eul5 Expressions.It Dom IdAlways exist in master folderNoneYes
Eul5 Elem Xrefs
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNoneSYSTEM.EUL5_ELEM_XREFS25-OCT-2006
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Condition Name Eul5 Elem Xrefs.To Type Eul5 Elem Xrefs.To Id Eul5 Elem Xrefs.To Actual Name CONDITION_NAME102566
Dependency Type Eul5 Elem Xrefs.To Type DEPENDENCY_TYPE101848
From Id Eul5 Elem Xrefs.From IdEX_FROM_IDEX_FROM_ID101163
From Type Eul5 Elem Xrefs.From TypeEX_FROM_TYPEEX_FROM_TYPE101164
Id Eul5 Elem Xrefs.IdEX_IDEX_ID101165
Item Name Eul5 Elem Xrefs.To Type Eul5 Elem Xrefs.To Id ITEM_NAME102572
Join Name Eul5 Elem Xrefs.To Type Eul5 Elem Xrefs.To Id Eul5 Elem Xrefs.To Devkey JOIN_NAME102580
State Eul5 Elem Xrefs.StateEX_STATEEX_STATE101166
To Actual Name Eul5 Elem Xrefs.To Actual NameEX_TO_NAMEEX_TO_NAME101169
To Autogen Name Eul5 Elem Xrefs.To Type Eul5 Elem Xrefs.To Type Eul5 Elem Xrefs.To Id Eul5 Elem Xrefs.To Devkey Eul5 Elem Xrefs.To Type Eul5 Elem Xrefs.To Id Eul5 Elem Xrefs.To Type Eul5 Elem Xrefs.To Id Eul5 Elem Xrefs.To Actual Name TO_AUTOGEN_NAME102583
To Condition Id Eul5 Elem Xrefs.To Type Eul5 Elem Xrefs.To Id TO_CONDITION_ID102563
To Devkey Eul5 Elem Xrefs.To DevkeyEX_TO_DEVKEYEX_TO_DEVKEY101167
To Id Eul5 Elem Xrefs.To IdEX_TO_IDEX_TO_ID101168
To Item Id Eul5 Elem Xrefs.To Type Eul5 Elem Xrefs.To Id TO_ITEM_ID102569
To Join Id Eul5 Elem Xrefs.To Type Eul5 Elem Xrefs.To Id Eul5 Elem Xrefs.To Devkey TO_NAME102575
To Name Eul5 Elem Xrefs.To Actual Name Eul5 Elem Xrefs.To Type Eul5 Elem Xrefs.To Type Eul5 Elem Xrefs.To Id Eul5 Elem Xrefs.To Devkey Eul5 Elem Xrefs.To Type Eul5 Elem Xrefs.To Id Eul5 Elem Xrefs.To Type Eul5 Elem Xrefs.To Id Eul5 Elem Xrefs.To Actual Name TO_NAME1102588
To Par Devkey Eul5 Elem Xrefs.To Par DevkeyEX_TO_PAR_DEVKEYEX_TO_PAR_DEVKEY101170
To Par Name Eul5 Elem Xrefs.To Par NameEX_TO_PAR_NAMEEX_TO_PAR_NAME101171
To Type Eul5 Elem Xrefs.To TypeEX_TO_TYPEEX_TO_TYPE101172
Type Eul5 Elem Xrefs.TypeEX_TYPEEX_TYPE101173
doc_id Eul5 Elem Xrefs.From Id DOC_ID101869
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Eul5 Elem Xrefs.doc_id -> Eul5 Documents.Doc IdEul5 Elem Xrefs.doc_id = Eul5 Documents.Doc IdMight not exist in master folderNoneYes
Eul5 Eul Users
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
EUL5 Privileges, EUL5 Security, EUL5 Workbook ManagementNoneSYSTEM.EUL5_EUL_USERS25-OCT-2006
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Eu Batch Cmt Sz Eul5 Eul Users.Eu Batch Cmt SzEU_BATCH_CMT_SZEU_BATCH_CMT_SZ101127
Eu Batch Expiry Eul5 Eul Users.Eu Batch ExpiryEU_BATCH_EXPIRYEU_BATCH_EXPIRY101128
Eu Batch Jobs Lmt Eul5 Eul Users.Eu Batch Jobs LmtEU_BATCH_JOBS_LMTEU_BATCH_JOBS_LMT101129
Eu Batch Qtime Lmt Eul5 Eul Users.Eu Batch Qtime LmtEU_BATCH_QTIME_LMTEU_BATCH_QTIME_LMT101130
Eu Batch Rep User Eul5 Eul Users.Eu Batch Rep UserEU_BATCH_REP_USEREU_BATCH_REP_USER101131
Eu Batch Wnd End Eul5 Eul Users.Eu Batch Wnd EndEU_BATCH_WND_ENDEU_BATCH_WND_END101132
Eu Batch Wnd Start Eul5 Eul Users.Eu Batch Wnd StartEU_BATCH_WND_STARTEU_BATCH_WND_START101133
Eu Created By Eul5 Eul Users.Eu Created ByEU_CREATED_BYEU_CREATED_BY101134
Eu Created Date Eul5 Eul Users.Eu Created DateEU_CREATED_DATEEU_CREATED_DATE101135
Eu Element State Eul5 Eul Users.Eu Element StateEU_ELEMENT_STATEEU_ELEMENT_STATE101136
Eu Id Eul5 Eul Users.Eu IdEU_IDEU_ID101137
Eu Last Batch Acc Eul5 Eul Users.Eu Last Batch AccEU_LAST_BATCH_ACCEU_LAST_BATCH_ACC101138
Eu Query Est Lmt Eul5 Eul Users.Eu Query Est LmtEU_QUERY_EST_LMTEU_QUERY_EST_LMT101139
Eu Query Time Lmt Eul5 Eul Users.Eu Query Time LmtEU_QUERY_TIME_LMTEU_QUERY_TIME_LMT101140
Eu Role Flag Eul5 Eul Users.Eu Role FlagEU_ROLE_FLAGEU_ROLE_FLAG101141
Eu Row Fetch Lmt Eul5 Eul Users.Eu Row Fetch LmtEU_ROW_FETCH_LMTEU_ROW_FETCH_LMT101142
Eu Security Model Eul5 Eul Users.Eu Security ModelEU_SECURITY_MODELEU_SECURITY_MODEL101143
Eu Updated By Eul5 Eul Users.Eu Updated ByEU_UPDATED_BYEU_UPDATED_BY101144
Eu Updated Date Eul5 Eul Users.Eu Updated DateEU_UPDATED_DATEEU_UPDATED_DATE101145
Eu Use Pub Privs Eul5 Eul Users.Eu Use Pub PrivsEU_USE_PUB_PRIVSEU_USE_PUB_PRIVS101147
Eu Username Eul5 Eul Users.Eu UsernameEU_USERNAMEEU_USERNAME101146
Notm Eul5 Eul Users.NotmNOTMNOTM101405
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Eul5 Eul Users.Eu Id -> Eul5 Asmp Cons.Auc Eu IdEul5 Eul Users.Eu Id = Eul5 Asmp Cons.Auc Eu IdAlways exist in master folderNoneYes
Eul5 Eul Users.Eu Id -> Eul5 Documents.Doc Eu IdEul5 Eul Users.Eu Id = Eul5 Documents.Doc Eu IdAlways exist in master folderNoneYes
Eul5 Eul Users.Eu Id -> Eul5 Sum Rfsh Sets.Srs Eu IdEul5 Eul Users.Eu Id = Eul5 Sum Rfsh Sets.Srs Eu IdAlways exist in master folderNoneYes
Eul5 Eul Users.Eu Id -> Eul5 Access Privs.Ap Eu IdEul5 Eul Users.Eu Id = Eul5 Access Privs.Ap Eu IdMight not exist in master folderOuter join on master Yes
Eul5 Eul Users.Eu Id -> Eul5 Batch Reports.Br Eu IdEul5 Eul Users.Eu Id = Eul5 Batch Reports.Br Eu IdAlways exist in master folderNoneYes
Eul5 Exp Deps
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
EUL5 ConditionsNoneSYSTEM.EUL5_EXP_DEPS25-OCT-2006
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Cd Exp Id Eul5 Exp Deps.Cd Exp IdCD_EXP_IDCD_EXP_ID101035
Cfd Fun Id Eul5 Exp Deps.Cfd Fun IdCFD_FUN_IDCFD_FUN_ID101036
Cid Exp Id Eul5 Exp Deps.Cid Exp IdCID_EXP_IDCID_EXP_ID101037
Ed Created By Eul5 Exp Deps.Ed Created ByED_CREATED_BYED_CREATED_BY101103
Ed Created Date Eul5 Exp Deps.Ed Created DateED_CREATED_DATEED_CREATED_DATE101104
Ed Element State Eul5 Exp Deps.Ed Element StateED_ELEMENT_STATEED_ELEMENT_STATE101105
Ed Id Eul5 Exp Deps.Ed IdED_IDED_ID101106
Ed Type Eul5 Exp Deps.Ed TypeED_TYPEED_TYPE101107
Ed Updated By Eul5 Exp Deps.Ed Updated ByED_UPDATED_BYED_UPDATED_BY101108
Ed Updated Date Eul5 Exp Deps.Ed Updated DateED_UPDATED_DATEED_UPDATED_DATE101109
Notm Eul5 Exp Deps.NotmNOTMNOTM101407
Pd P Id Eul5 Exp Deps.Pd P IdPD_P_IDPD_P_ID101495
Ped Exp Id Eul5 Exp Deps.Ped Exp IdPED_EXP_IDPED_EXP_ID101496
Pfd Fun Id Eul5 Exp Deps.Pfd Fun IdPFD_FUN_IDPFD_FUN_ID101497
Psd Sq Id Eul5 Exp Deps.Psd Sq IdPSD_SQ_IDPSD_SQ_ID101502
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Eul5 Expressions
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
EUL5 Alternate Sorts, EUL5 Item Classes, EUL5 Conditions, EUL5 Folders & Items, EUL5 Item Class SQL, EUL5 Item Class Used By , EUL5 Joins, EUL5 Summary MappingsNoneSYSTEM.EUL5_EXPRESSIONS25-OCT-2006
EUL5 Alternate Sorts, EUL5 Item Classes, EUL5 Conditions, EUL5 Folders & Items, EUL5 Item Class SQL, EUL5 Item Class Used By , EUL5 Joins, EUL5 Summary MappingsNoneSYSTEM.EUL5_EXPRESSIONS25-OCT-2006
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Auto Generated Exp Name Eul5 Expressions.Exp Id AUTO_GENERATED_EXP_NAME101778
Ci It Id Eul5 Expressions.Ci It IdCI_IT_IDCI_IT_ID101038
Ci Runtime Item Eul5 Expressions.Ci Runtime ItemCI_RUNTIME_ITEMCI_RUNTIME_ITEM101039
Co Nullable Eul5 Expressions.Co NullableCO_NULLABLECO_NULLABLE101041
Exp Created By Eul5 Expressions.Exp Created ByEXP_CREATED_BYEXP_CREATED_BY101148
Exp Created Date Eul5 Expressions.Exp Created DateEXP_CREATED_DATEEXP_CREATED_DATE101149
Exp Data Type Eul5 Expressions.Exp Data TypeEXP_DATA_TYPEEXP_DATA_TYPE101150
Exp Description Eul5 Expressions.Exp DescriptionEXP_DESCRIPTIONEXP_DESCRIPTION101151
Exp Developer Key Eul5 Expressions.Exp Developer KeyEXP_DEVELOPER_KEYEXP_DEVELOPER_KEY101152
Exp Element State Eul5 Expressions.Exp Element StateEXP_ELEMENT_STATEEXP_ELEMENT_STATE101153
Exp Formula Eul5 Expressions.Exp FormulaEXP_FORMULA1EXP_FORMULA1101154
Exp Id Eul5 Expressions.Exp IdEXP_IDEXP_ID101155
Exp Name Eul5 Expressions.Exp NameEXP_NAMEEXP_NAME101156
Exp Sequence Eul5 Expressions.Exp SequenceEXP_SEQUENCEEXP_SEQUENCE101157
Exp Type Eul5 Expressions.Exp TypeEXP_TYPEEXP_TYPE101158
Exp Updated By Eul5 Expressions.Exp Updated ByEXP_UPDATED_BYEXP_UPDATED_BY101159
Exp Updated Date Eul5 Expressions.Exp Updated DateEXP_UPDATED_DATEEXP_UPDATED_DATE101160
Exp User Prop1 Eul5 Expressions.Exp User Prop1EXP_USER_PROP1EXP_USER_PROP1101161
Exp User Prop2 Eul5 Expressions.Exp User Prop2EXP_USER_PROP2EXP_USER_PROP2101162
Fil App Type Eul5 Expressions.Fil App TypeFIL_APP_TYPEFIL_APP_TYPE101214
Fil Doc Id Eul5 Expressions.Fil Doc IdFIL_DOC_IDFIL_DOC_ID101215
Fil Ext Filter Eul5 Expressions.Fil Ext FilterFIL_EXT_FILTERFIL_EXT_FILTER101216
Fil Obj Id Eul5 Expressions.Fil Obj IdFIL_OBJ_IDFIL_OBJ_ID101217
Fil Runtime Filter Eul5 Expressions.Fil Runtime FilterFIL_RUNTIME_FILTERFIL_RUNTIME_FILTER101218
It Alignment Eul5 Expressions.It AlignmentIT_ALIGNMENTIT_ALIGNMENT101329
It Case Display Eul5 Expressions.It Case DisplayIT_CASE_DISPLAYIT_CASE_DISPLAY101330
It Case Storage Eul5 Expressions.It Case StorageIT_CASE_STORAGEIT_CASE_STORAGE101331
It Disp Null Val Eul5 Expressions.It Disp Null ValIT_DISP_NULL_VALIT_DISP_NULL_VAL101332
It Doc Id Eul5 Expressions.It Doc IdIT_DOC_IDIT_DOC_ID101333
It Dom Id Eul5 Expressions.It Dom IdIT_DOM_IDIT_DOM_ID101334
It Ext Column Eul5 Expressions.It Ext ColumnIT_EXT_COLUMNIT_EXT_COLUMN101335
It Format Mask Eul5 Expressions.It Format MaskIT_FORMAT_MASKIT_FORMAT_MASK101336
It Fun Id Eul5 Expressions.It Fun IdIT_FUN_IDIT_FUN_ID101337
It Heading Eul5 Expressions.It HeadingIT_HEADINGIT_HEADING101338
It Hidden Eul5 Expressions.It HiddenIT_HIDDENIT_HIDDEN101339
It Max Data Width Eul5 Expressions.It Max Data WidthIT_MAX_DATA_WIDTHIT_MAX_DATA_WIDTH101340
It Max Disp Width Eul5 Expressions.It Max Disp WidthIT_MAX_DISP_WIDTHIT_MAX_DISP_WIDTH101341
It Obj Id Eul5 Expressions.It Obj IdIT_OBJ_IDIT_OBJ_ID101342
It Placement Eul5 Expressions.It PlacementIT_PLACEMENTIT_PLACEMENT101343
It User Def Fmt Eul5 Expressions.It User Def FmtIT_USER_DEF_FMTIT_USER_DEF_FMT101344
It Word Wrap Eul5 Expressions.It Word WrapIT_WORD_WRAPIT_WORD_WRAP101345
Jp Key Id Eul5 Expressions.Jp Key IdJP_KEY_IDJP_KEY_ID101348
Notm Eul5 Expressions.NotmNOTMNOTM101406
P Case Sensitive Eul5 Expressions.P Case SensitiveP_CASE_SENSITIVEP_CASE_SENSITIVE101503
Par Multiple Vals Eul5 Expressions.Par Multiple ValsPAR_MULTIPLE_VALSPAR_MULTIPLE_VALS101494
Auto Generated Exp Name Eul5 Expressions.Exp Id AUTO_GENERATED_EXP_NAME101778
Ci It Id Eul5 Expressions.Ci It IdCI_IT_IDCI_IT_ID101038
Ci Runtime Item Eul5 Expressions.Ci Runtime ItemCI_RUNTIME_ITEMCI_RUNTIME_ITEM101039
Co Nullable Eul5 Expressions.Co NullableCO_NULLABLECO_NULLABLE101041
Exp Created By Eul5 Expressions.Exp Created ByEXP_CREATED_BYEXP_CREATED_BY101148
Exp Created Date Eul5 Expressions.Exp Created DateEXP_CREATED_DATEEXP_CREATED_DATE101149
Exp Data Type Eul5 Expressions.Exp Data TypeEXP_DATA_TYPEEXP_DATA_TYPE101150
Exp Description Eul5 Expressions.Exp DescriptionEXP_DESCRIPTIONEXP_DESCRIPTION101151
Exp Developer Key Eul5 Expressions.Exp Developer KeyEXP_DEVELOPER_KEYEXP_DEVELOPER_KEY101152
Exp Element State Eul5 Expressions.Exp Element StateEXP_ELEMENT_STATEEXP_ELEMENT_STATE101153
Exp Formula Eul5 Expressions.Exp FormulaEXP_FORMULA1EXP_FORMULA1101154
Exp Id Eul5 Expressions.Exp IdEXP_IDEXP_ID101155
Exp Name Eul5 Expressions.Exp NameEXP_NAMEEXP_NAME101156
Exp Sequence Eul5 Expressions.Exp SequenceEXP_SEQUENCEEXP_SEQUENCE101157
Exp Type Eul5 Expressions.Exp TypeEXP_TYPEEXP_TYPE101158
Exp Updated By Eul5 Expressions.Exp Updated ByEXP_UPDATED_BYEXP_UPDATED_BY101159
Exp Updated Date Eul5 Expressions.Exp Updated DateEXP_UPDATED_DATEEXP_UPDATED_DATE101160
Exp User Prop1 Eul5 Expressions.Exp User Prop1EXP_USER_PROP1EXP_USER_PROP1101161
Exp User Prop2 Eul5 Expressions.Exp User Prop2EXP_USER_PROP2EXP_USER_PROP2101162
Fil App Type Eul5 Expressions.Fil App TypeFIL_APP_TYPEFIL_APP_TYPE101214
Fil Doc Id Eul5 Expressions.Fil Doc IdFIL_DOC_IDFIL_DOC_ID101215
Fil Ext Filter Eul5 Expressions.Fil Ext FilterFIL_EXT_FILTERFIL_EXT_FILTER101216
Fil Obj Id Eul5 Expressions.Fil Obj IdFIL_OBJ_IDFIL_OBJ_ID101217
Fil Runtime Filter Eul5 Expressions.Fil Runtime FilterFIL_RUNTIME_FILTERFIL_RUNTIME_FILTER101218
It Alignment Eul5 Expressions.It AlignmentIT_ALIGNMENTIT_ALIGNMENT101329
It Case Display Eul5 Expressions.It Case DisplayIT_CASE_DISPLAYIT_CASE_DISPLAY101330
It Case Storage Eul5 Expressions.It Case StorageIT_CASE_STORAGEIT_CASE_STORAGE101331
It Disp Null Val Eul5 Expressions.It Disp Null ValIT_DISP_NULL_VALIT_DISP_NULL_VAL101332
It Doc Id Eul5 Expressions.It Doc IdIT_DOC_IDIT_DOC_ID101333
It Dom Id Eul5 Expressions.It Dom IdIT_DOM_IDIT_DOM_ID101334
It Ext Column Eul5 Expressions.It Ext ColumnIT_EXT_COLUMNIT_EXT_COLUMN101335
It Format Mask Eul5 Expressions.It Format MaskIT_FORMAT_MASKIT_FORMAT_MASK101336
It Fun Id Eul5 Expressions.It Fun IdIT_FUN_IDIT_FUN_ID101337
It Heading Eul5 Expressions.It HeadingIT_HEADINGIT_HEADING101338
It Hidden Eul5 Expressions.It HiddenIT_HIDDENIT_HIDDEN101339
It Max Data Width Eul5 Expressions.It Max Data WidthIT_MAX_DATA_WIDTHIT_MAX_DATA_WIDTH101340
It Max Disp Width Eul5 Expressions.It Max Disp WidthIT_MAX_DISP_WIDTHIT_MAX_DISP_WIDTH101341
It Obj Id Eul5 Expressions.It Obj IdIT_OBJ_IDIT_OBJ_ID101342
It Placement Eul5 Expressions.It PlacementIT_PLACEMENTIT_PLACEMENT101343
It User Def Fmt Eul5 Expressions.It User Def FmtIT_USER_DEF_FMTIT_USER_DEF_FMT101344
It Word Wrap Eul5 Expressions.It Word WrapIT_WORD_WRAPIT_WORD_WRAP101345
Jp Key Id Eul5 Expressions.Jp Key IdJP_KEY_IDJP_KEY_ID101348
Notm Eul5 Expressions.NotmNOTMNOTM101406
P Case Sensitive Eul5 Expressions.P Case SensitiveP_CASE_SENSITIVEP_CASE_SENSITIVE101503
Par Multiple Vals Eul5 Expressions.Par Multiple ValsPAR_MULTIPLE_VALSPAR_MULTIPLE_VALS101494
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Eul5 Expressions.Exp Id -> Eul5 Domains.Dom It Id LovEul5 Expressions.Exp Id = Eul5 Domains.Dom It Id LovAlways exist in master folderNoneYes
Eul5 Expressions.Exp Id -> Eul5 Bq Deps.Bid It IdEul5 Expressions.Exp Id = Eul5 Bq Deps.Bid It IdAlways exist in master folderNoneYes
Eul5 Expressions.Exp Id -> Eul5 Sub Queries.Sq Fil IdEul5 Expressions.Exp Id = Eul5 Sub Queries.Sq Fil IdAlways exist in master folderNoneYes
Eul5 Expressions.Exp Id -> Eul5 Ig Exp Links.Kil Exp IdEul5 Expressions.Exp Id = Eul5 Ig Exp Links.Kil Exp IdMight not exist in master folderNoneYes
Eul5 Expressions.Exp Id -> Eul5 Sq Crrltns.Sqc It Inner IdEul5 Expressions.Exp Id = Eul5 Sq Crrltns.Sqc It Inner IdAlways exist in master folderNoneYes
Eul5 Expressions.Exp Id -> Eul5 Sub Queries.Sq It IdEul5 Expressions.Exp Id = Eul5 Sub Queries.Sq It IdAlways exist in master folderNoneYes
Eul5 Expressions.Exp Id -> Eul5 Exp Deps.Cd Exp IdEul5 Expressions.Exp Id = Eul5 Exp Deps.Cd Exp IdAlways exist in master folderNoneYes
Eul5 Expressions.Exp Id -> Eul5 Domains.Dom It Id RankEul5 Expressions.Exp Id = Eul5 Domains.Dom It Id RankAlways exist in master folderNoneYes
Eul5 Expressions.Exp Id -> Eul5 Ig Exp Links.Hil Exp IdEul5 Expressions.Exp Id = Eul5 Ig Exp Links.Hil Exp IdMight not exist in master folderNoneYes
Eul5 Expressions.Exp Id -> Eul5 Exp Deps.Cid Exp IdEul5 Expressions.Exp Id = Eul5 Exp Deps.Cid Exp IdAlways exist in master folderNoneYes
Eul5 Expressions.Exp Id -> Eul5 Sum Bitmaps.Sb Exp IdEul5 Expressions.Exp Id = Eul5 Sum Bitmaps.Sb Exp IdMight not exist in master folderNoneYes
Eul5 Expressions.Exp Id -> Eul5 Exp Deps.Pd P IdEul5 Expressions.Exp Id = Eul5 Exp Deps.Pd P IdAlways exist in master folderNoneYes
Eul5 Expressions.Exp Id -> Eul5 Sq Crrltns.Sqc It Outer IdEul5 Expressions.Exp Id = Eul5 Sq Crrltns.Sqc It Outer IdAlways exist in master folderNoneYes
Eul5 Expressions.Exp Id -> Eul5 Bq Deps.Bfild Fil IdEul5 Expressions.Exp Id = Eul5 Bq Deps.Bfild Fil IdAlways exist in master folderNoneYes
Eul5 Expressions.Exp Id -> Eul5 Exp Deps.Ped Exp IdEul5 Expressions.Exp Id = Eul5 Exp Deps.Ped Exp IdAlways exist in master folderNoneYes
Eul5 Expressions.Exp Id -> Eul5 Segments.Seg Exp IdEul5 Expressions.Exp Id = Eul5 Segments.Seg Exp IdAlways exist in master folderNoneYes
Eul5 Expressions.Exp Id -> Eul5 Sumo Exp Usgs.Siu Exp IdEul5 Expressions.Exp Id = Eul5 Sumo Exp Usgs.Siu Exp IdAlways exist in master folderNoneYes
Eul5 Freq Units
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNoneSYSTEM.EUL5_FREQ_UNITS25-OCT-2006
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Notm Eul5 Freq Units.NotmNOTMNOTM101408
Rfu Created By Eul5 Freq Units.Rfu Created ByRFU_CREATED_BYRFU_CREATED_BY101552
Rfu Created Date Eul5 Freq Units.Rfu Created DateRFU_CREATED_DATERFU_CREATED_DATE101553
Rfu Element State Eul5 Freq Units.Rfu Element StateRFU_ELEMENT_STATERFU_ELEMENT_STATE101554
Rfu Id Eul5 Freq Units.Rfu IdRFU_IDRFU_ID101555
Rfu Name Mn Eul5 Freq Units.Rfu Name MnRFU_NAME_MNRFU_NAME_MN101556
Rfu Sequence Eul5 Freq Units.Rfu SequenceRFU_SEQUENCERFU_SEQUENCE101557
Rfu Sql Expression Eul5 Freq Units.Rfu Sql ExpressionRFU_SQL_EXPRESSIONRFU_SQL_EXPRESSION101558
Rfu Updated By Eul5 Freq Units.Rfu Updated ByRFU_UPDATED_BYRFU_UPDATED_BY101559
Rfu Updated Date Eul5 Freq Units.Rfu Updated DateRFU_UPDATED_DATERFU_UPDATED_DATE101560
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Eul5 Freq Units.Rfu Id -> Eul5 Sum Rfsh Sets.Srs Rfu IdEul5 Freq Units.Rfu Id = Eul5 Sum Rfsh Sets.Srs Rfu IdAlways exist in master folderNoneYes
Eul5 Freq Units.Rfu Id -> Eul5 Batch Reports.Br Rfu IdEul5 Freq Units.Rfu Id = Eul5 Batch Reports.Br Rfu IdAlways exist in master folderNoneYes
Eul5 Fun Arguments
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNoneSYSTEM.EUL5_FUN_ARGUMENTS25-OCT-2006
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Fa Created By Eul5 Fun Arguments.Fa Created ByFA_CREATED_BYFA_CREATED_BY101176
Fa Created Date Eul5 Fun Arguments.Fa Created DateFA_CREATED_DATEFA_CREATED_DATE101177
Fa Data Type Eul5 Fun Arguments.Fa Data TypeFA_DATA_TYPEFA_DATA_TYPE101178
Fa Description Mn Eul5 Fun Arguments.Fa Description MnFA_DESCRIPTION_MNFA_DESCRIPTION_MN101179
Fa Description S Eul5 Fun Arguments.Fa Description SFA_DESCRIPTION_SFA_DESCRIPTION_S101180
Fa Developer Key Eul5 Fun Arguments.Fa Developer KeyFA_DEVELOPER_KEYFA_DEVELOPER_KEY101181
Fa Element State Eul5 Fun Arguments.Fa Element StateFA_ELEMENT_STATEFA_ELEMENT_STATE101182
Fa Fun Id Eul5 Fun Arguments.Fa Fun IdFA_FUN_IDFA_FUN_ID101183
Fa Id Eul5 Fun Arguments.Fa IdFA_IDFA_ID101184
Fa Name Mn Eul5 Fun Arguments.Fa Name MnFA_NAME_MNFA_NAME_MN101185
Fa Name S Eul5 Fun Arguments.Fa Name SFA_NAME_SFA_NAME_S101186
Fa Optional Eul5 Fun Arguments.Fa OptionalFA_OPTIONALFA_OPTIONAL101187
Fa Position Eul5 Fun Arguments.Fa PositionFA_POSITIONFA_POSITION101188
Fa Updated By Eul5 Fun Arguments.Fa Updated ByFA_UPDATED_BYFA_UPDATED_BY101189
Fa Updated Date Eul5 Fun Arguments.Fa Updated DateFA_UPDATED_DATEFA_UPDATED_DATE101190
Fa User Prop1 Eul5 Fun Arguments.Fa User Prop1FA_USER_PROP1FA_USER_PROP1101191
Fa User Prop2 Eul5 Fun Arguments.Fa User Prop2FA_USER_PROP2FA_USER_PROP2101192
Notm Eul5 Fun Arguments.NotmNOTMNOTM101410
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Eul5 Fun Ctgs
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNoneSYSTEM.EUL5_FUN_CTGS25-OCT-2006
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Fc Created By Eul5 Fun Ctgs.Fc Created ByFC_CREATED_BYFC_CREATED_BY101193
Fc Created Date Eul5 Fun Ctgs.Fc Created DateFC_CREATED_DATEFC_CREATED_DATE101194
Fc Description Mn Eul5 Fun Ctgs.Fc Description MnFC_DESCRIPTION_MNFC_DESCRIPTION_MN101195
Fc Description S Eul5 Fun Ctgs.Fc Description SFC_DESCRIPTION_SFC_DESCRIPTION_S101196
Fc Developer Key Eul5 Fun Ctgs.Fc Developer KeyFC_DEVELOPER_KEYFC_DEVELOPER_KEY101197
Fc Element State Eul5 Fun Ctgs.Fc Element StateFC_ELEMENT_STATEFC_ELEMENT_STATE101198
Fc Id Eul5 Fun Ctgs.Fc IdFC_IDFC_ID101199
Fc Name Mn Eul5 Fun Ctgs.Fc Name MnFC_NAME_MNFC_NAME_MN101200
Fc Name S Eul5 Fun Ctgs.Fc Name SFC_NAME_SFC_NAME_S101201
Fc Updated By Eul5 Fun Ctgs.Fc Updated ByFC_UPDATED_BYFC_UPDATED_BY101202
Fc Updated Date Eul5 Fun Ctgs.Fc Updated DateFC_UPDATED_DATEFC_UPDATED_DATE101203
Fc User Prop1 Eul5 Fun Ctgs.Fc User Prop1FC_USER_PROP1FC_USER_PROP1101204
Fc User Prop2 Eul5 Fun Ctgs.Fc User Prop2FC_USER_PROP2FC_USER_PROP2101205
Notm Eul5 Fun Ctgs.NotmNOTMNOTM101411
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Eul5 Fun Ctgs.Fc Id -> Eul5 Fun Fc Links.Ffl Fc IdEul5 Fun Ctgs.Fc Id = Eul5 Fun Fc Links.Ffl Fc IdAlways exist in master folderNoneYes
Eul5 Fun Fc Links
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNoneSYSTEM.EUL5_FUN_FC_LINKS25-OCT-2006
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Ffl Created By Eul5 Fun Fc Links.Ffl Created ByFFL_CREATED_BYFFL_CREATED_BY101206
Ffl Created Date Eul5 Fun Fc Links.Ffl Created DateFFL_CREATED_DATEFFL_CREATED_DATE101207
Ffl Element State Eul5 Fun Fc Links.Ffl Element StateFFL_ELEMENT_STATEFFL_ELEMENT_STATE101208
Ffl Fc Id Eul5 Fun Fc Links.Ffl Fc IdFFL_FC_IDFFL_FC_ID101209
Ffl Fun Id Eul5 Fun Fc Links.Ffl Fun IdFFL_FUN_IDFFL_FUN_ID101210
Ffl Id Eul5 Fun Fc Links.Ffl IdFFL_IDFFL_ID101211
Ffl Updated By Eul5 Fun Fc Links.Ffl Updated ByFFL_UPDATED_BYFFL_UPDATED_BY101212
Ffl Updated Date Eul5 Fun Fc Links.Ffl Updated DateFFL_UPDATED_DATEFFL_UPDATED_DATE101213
Notm Eul5 Fun Fc Links.NotmNOTMNOTM101412
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Eul5 Functions
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNoneSYSTEM.EUL5_FUNCTIONS25-OCT-2006
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Fun Available Eul5 Functions.Fun AvailableFUN_AVAILABLEFUN_AVAILABLE101225
Fun Built In Eul5 Functions.Fun Built InFUN_BUILT_INFUN_BUILT_IN101226
Fun Created By Eul5 Functions.Fun Created ByFUN_CREATED_BYFUN_CREATED_BY101227
Fun Created Date Eul5 Functions.Fun Created DateFUN_CREATED_DATEFUN_CREATED_DATE101228
Fun Data Type Eul5 Functions.Fun Data TypeFUN_DATA_TYPEFUN_DATA_TYPE101229
Fun Description Mn Eul5 Functions.Fun Description MnFUN_DESCRIPTION_MNFUN_DESCRIPTION_MN101230
Fun Description S Eul5 Functions.Fun Description SFUN_DESCRIPTION_SFUN_DESCRIPTION_S101231
Fun Developer Key Eul5 Functions.Fun Developer KeyFUN_DEVELOPER_KEYFUN_DEVELOPER_KEY101232
Fun Element State Eul5 Functions.Fun Element StateFUN_ELEMENT_STATEFUN_ELEMENT_STATE101233
Fun Ext Db Link Eul5 Functions.Fun Ext Db LinkFUN_EXT_DB_LINKFUN_EXT_DB_LINK101234
Fun Ext Name Eul5 Functions.Fun Ext NameFUN_EXT_NAMEFUN_EXT_NAME101235
Fun Ext Owner Eul5 Functions.Fun Ext OwnerFUN_EXT_OWNERFUN_EXT_OWNER101236
Fun Ext Package Eul5 Functions.Fun Ext PackageFUN_EXT_PACKAGEFUN_EXT_PACKAGE101237
Fun Function Type Eul5 Functions.Fun Function TypeFUN_FUNCTION_TYPEFUN_FUNCTION_TYPE101238
Fun Hidden Eul5 Functions.Fun HiddenFUN_HIDDENFUN_HIDDEN101239
Fun Id Eul5 Functions.Fun IdFUN_IDFUN_ID101240
Fun Maximum Args Eul5 Functions.Fun Maximum ArgsFUN_MAXIMUM_ARGSFUN_MAXIMUM_ARGS101241
Fun Minimum Args Eul5 Functions.Fun Minimum ArgsFUN_MINIMUM_ARGSFUN_MINIMUM_ARGS101242
Fun Name Eul5 Functions.Fun NameFUN_NAMEFUN_NAME101243
Fun Updated By Eul5 Functions.Fun Updated ByFUN_UPDATED_BYFUN_UPDATED_BY101244
Fun Updated Date Eul5 Functions.Fun Updated DateFUN_UPDATED_DATEFUN_UPDATED_DATE101245
Fun User Prop1 Eul5 Functions.Fun User Prop1FUN_USER_PROP1FUN_USER_PROP1101246
Fun User Prop2 Eul5 Functions.Fun User Prop2FUN_USER_PROP2FUN_USER_PROP2101247
Notm Eul5 Functions.NotmNOTMNOTM101409
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Eul5 Functions.Fun Id -> Eul5 Exp Deps.Cfd Fun IdEul5 Functions.Fun Id = Eul5 Exp Deps.Cfd Fun IdAlways exist in master folderNoneYes
Eul5 Functions.Fun Id -> Eul5 Exp Deps.Pfd Fun IdEul5 Functions.Fun Id = Eul5 Exp Deps.Pfd Fun IdAlways exist in master folderNoneYes
Eul5 Functions.Fun Id -> Eul5 Sumo Exp Usgs.Sfu Fun IdEul5 Functions.Fun Id = Eul5 Sumo Exp Usgs.Sfu Fun IdAlways exist in master folderNoneYes
Eul5 Functions.Fun Id -> Eul5 Sumo Exp Usgs.Smiu Fun IdEul5 Functions.Fun Id = Eul5 Sumo Exp Usgs.Smiu Fun IdAlways exist in master folderNoneYes
Eul5 Functions.Fun Id -> Eul5 Sum Bitmaps.Sb Fun IdEul5 Functions.Fun Id = Eul5 Sum Bitmaps.Sb Fun IdAlways exist in master folderNoneYes
Eul5 Functions.Fun Id -> Eul5 Fun Arguments.Fa Fun IdEul5 Functions.Fun Id = Eul5 Fun Arguments.Fa Fun IdAlways exist in master folderNoneYes
Eul5 Functions.Fun Id -> Eul5 Bq Deps.Bfund Fun IdEul5 Functions.Fun Id = Eul5 Bq Deps.Bfund Fun IdAlways exist in master folderNoneYes
Eul5 Functions.Fun Id -> Eul5 Fun Fc Links.Ffl Fun IdEul5 Functions.Fun Id = Eul5 Fun Fc Links.Ffl Fun IdAlways exist in master folderNoneYes
Eul5 Functions.Fun Id -> Eul5 Expressions.It Fun IdEul5 Functions.Fun Id = Eul5 Expressions.It Fun IdAlways exist in master folderNoneYes
Eul5 Gateways
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNoneSYSTEM.EUL5_GATEWAYS25-OCT-2006
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Egw Database Link Eul5 Gateways.Egw Database LinkEGW_DATABASE_LINKEGW_DATABASE_LINK101110
Egw Schema Eul5 Gateways.Egw SchemaEGW_SCHEMAEGW_SCHEMA101111
Egw Sql Paradigm Eul5 Gateways.Egw Sql ParadigmEGW_SQL_PARADIGMEGW_SQL_PARADIGM101112
Egw Version Eul5 Gateways.Egw VersionEGW_VERSIONEGW_VERSION101113
Gw Created By Eul5 Gateways.Gw Created ByGW_CREATED_BYGW_CREATED_BY101258
Gw Created Date Eul5 Gateways.Gw Created DateGW_CREATED_DATEGW_CREATED_DATE101259
Gw Description Eul5 Gateways.Gw DescriptionGW_DESCRIPTIONGW_DESCRIPTION101260
Gw Element State Eul5 Gateways.Gw Element StateGW_ELEMENT_STATEGW_ELEMENT_STATE101261
Gw Gateway Name Eul5 Gateways.Gw Gateway NameGW_GATEWAY_NAMEGW_GATEWAY_NAME101262
Gw Id Eul5 Gateways.Gw IdGW_IDGW_ID101263
Gw Product Name Eul5 Gateways.Gw Product NameGW_PRODUCT_NAMEGW_PRODUCT_NAME101264
Gw Type Eul5 Gateways.Gw TypeGW_TYPEGW_TYPE101265
Gw Updated By Eul5 Gateways.Gw Updated ByGW_UPDATED_BYGW_UPDATED_BY101266
Gw Updated Date Eul5 Gateways.Gw Updated DateGW_UPDATED_DATEGW_UPDATED_DATE101267
Notm Eul5 Gateways.NotmNOTMNOTM101413
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Eul5 Hi Nodes
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
EUL5 HierarchyNoneSYSTEM.EUL5_HI_NODES25-OCT-2006
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Auto Generated Hn Folder Node Name Eul5 Hi Nodes.Hn Id AUTO_GENERATED_HN_FOLDER_NODE_NAME101795
Auto Generated Hn Item Node Name Eul5 Hi Nodes.Hn Id AUTO_GENERATED_HN_NAME101799
Auto Generated Hn Name Eul5 Hi Nodes.Hn Id Eul5 Hi Nodes.Hn Id AUTO_GNERATED_HN_NAME101803
Hn Created By Eul5 Hi Nodes.Hn Created ByHN_CREATED_BYHN_CREATED_BY101286
Hn Created Date Eul5 Hi Nodes.Hn Created DateHN_CREATED_DATEHN_CREATED_DATE101287
Hn Description Eul5 Hi Nodes.Hn DescriptionHN_DESCRIPTIONHN_DESCRIPTION101288
Hn Developer Key Eul5 Hi Nodes.Hn Developer KeyHN_DEVELOPER_KEYHN_DEVELOPER_KEY101289
Hn Element State Eul5 Hi Nodes.Hn Element StateHN_ELEMENT_STATEHN_ELEMENT_STATE101290
Hn Ext Node Eul5 Hi Nodes.Hn Ext NodeHN_EXT_NODEHN_EXT_NODE101291
Hn Hi Id Eul5 Hi Nodes.Hn Hi IdHN_HI_IDHN_HI_ID101292
Hn Id Eul5 Hi Nodes.Hn IdHN_IDHN_ID101293
Hn Name Eul5 Hi Nodes.Hn NameHN_NAMEHN_NAME101294
Hn Updated By Eul5 Hi Nodes.Hn Updated ByHN_UPDATED_BYHN_UPDATED_BY101295
Hn Updated Date Eul5 Hi Nodes.Hn Updated DateHN_UPDATED_DATEHN_UPDATED_DATE101296
Hn User Prop1 Eul5 Hi Nodes.Hn User Prop1HN_USER_PROP1HN_USER_PROP1101297
Hn User Prop2 Eul5 Hi Nodes.Hn User Prop2HN_USER_PROP2HN_USER_PROP2101298
Notm Eul5 Hi Nodes.NotmNOTMNOTM101415
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Eul5 Hi Nodes.Hn Id -> Eul5 Ig Exp Links.Hil Hn IdEul5 Hi Nodes.Hn Id = Eul5 Ig Exp Links.Hil Hn IdAlways exist in master folderNoneYes
Eul5 Hi Nodes.Hn Id -> Eul5 Hi Segments.Ihs Hn Id ChildEul5 Hi Nodes.Hn Id = Eul5 Hi Segments.Ihs Hn Id ChildAlways exist in master folderNoneYes
Eul5 Hi Nodes.Hn Id -> Eul5 Hi Segments.Ihs Hn Id ParentEul5 Hi Nodes.Hn Id = Eul5 Hi Segments.Ihs Hn Id ParentAlways exist in master folderNoneYes
Eul5 Hi Segments
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNoneSYSTEM.EUL5_HI_SEGMENTS25-OCT-2006
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Dhs Dhn Id Child Eul5 Hi Segments.Dhs Dhn Id ChildDHS_DHN_ID_CHILDDHS_DHN_ID_CHILD101060
Dhs Dhn Id Parent Eul5 Hi Segments.Dhs Dhn Id ParentDHS_DHN_ID_PARENTDHS_DHN_ID_PARENT101061
Dhs Hi Id Eul5 Hi Segments.Dhs Hi IdDHS_HI_IDDHS_HI_ID101062
Hs Created By Eul5 Hi Segments.Hs Created ByHS_CREATED_BYHS_CREATED_BY101299
Hs Created Date Eul5 Hi Segments.Hs Created DateHS_CREATED_DATEHS_CREATED_DATE101300
Hs Element State Eul5 Hi Segments.Hs Element StateHS_ELEMENT_STATEHS_ELEMENT_STATE101301
Hs Id Eul5 Hi Segments.Hs IdHS_IDHS_ID101302
Hs Type Eul5 Hi Segments.Hs TypeHS_TYPEHS_TYPE101303
Hs Updated By Eul5 Hi Segments.Hs Updated ByHS_UPDATED_BYHS_UPDATED_BY101304
Hs Updated Date Eul5 Hi Segments.Hs Updated DateHS_UPDATED_DATEHS_UPDATED_DATE101305
Ihs Hi Id Eul5 Hi Segments.Ihs Hi IdIHS_HI_IDIHS_HI_ID101323
Ihs Hn Id Child Eul5 Hi Segments.Ihs Hn Id ChildIHS_HN_ID_CHILDIHS_HN_ID_CHILD101324
Ihs Hn Id Parent Eul5 Hi Segments.Ihs Hn Id ParentIHS_HN_ID_PARENTIHS_HN_ID_PARENT101325
Notm Eul5 Hi Segments.NotmNOTMNOTM101416
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Eul5 Hi Segments.Hs Id -> Eul5 Ihs Fk Links.Ifl Ihs IdEul5 Hi Segments.Hs Id = Eul5 Ihs Fk Links.Ifl Ihs IdAlways exist in master folderNoneYes
Eul5 Hierarchies
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
EUL5 HierarchyNoneSYSTEM.EUL5_HIERARCHIES25-OCT-2006
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Actual Hi Name Eul5 Hierarchies.Actual Hi NameHI_NAMEHI_NAME101279
AutoGen Date Hierarchy Template Name Eul5 Hierarchies.Ibh Dbh Id AUTOGEN_DATE_HIERARCHY_TEMPLATE_NAME101775
AutoGen Exp Id Eul5 Hierarchies.Ibh Dbh Id Eul5 Hierarchies.Actual Hi Name HI_NAME_EXP_ID102152
AutoGen Exp Name Eul5 Hierarchies.Ibh Dbh Id Eul5 Hierarchies.Actual Hi Name AUTOGEN_EXP_NAME102156
AutoGen Folder Name Eul5 Hierarchies.Ibh Dbh Id Eul5 Hierarchies.Actual Hi Name AUTOGEN_FOLDER_NAME102159
Dbh Default Eul5 Hierarchies.Dbh DefaultDBH_DEFAULTDBH_DEFAULT101045
Hi Created By Eul5 Hierarchies.Hi Created ByHI_CREATED_BYHI_CREATED_BY101272
Hi Created Date Eul5 Hierarchies.Hi Created DateHI_CREATED_DATEHI_CREATED_DATE101273
Hi Description Eul5 Hierarchies.Hi DescriptionHI_DESCRIPTIONHI_DESCRIPTION101274
Hi Developer Key Eul5 Hierarchies.Hi Developer KeyHI_DEVELOPER_KEYHI_DEVELOPER_KEY101275
Hi Element State Eul5 Hierarchies.Hi Element StateHI_ELEMENT_STATEHI_ELEMENT_STATE101276
Hi Ext Hierarchy Eul5 Hierarchies.Hi Ext HierarchyHI_EXT_HIERARCHYHI_EXT_HIERARCHY101277
Hi Id Eul5 Hierarchies.Hi IdHI_IDHI_ID101278
Hi Name Eul5 Hierarchies.Actual Hi Name Eul5 Hierarchies.Ibh Dbh Id Eul5 Hierarchies.Actual Hi Name Eul5 Hierarchies.Ibh Dbh Id Eul5 Hierarchies.Actual Hi Name Eul5 Hierarchies.Ibh Dbh Id HI_NAME1102162
Hi Sys Generated Eul5 Hierarchies.Hi Sys GeneratedHI_SYS_GENERATEDHI_SYS_GENERATED101280
Hi Type Eul5 Hierarchies.Hi TypeHI_TYPEHI_TYPE101281
Hi Updated By Eul5 Hierarchies.Hi Updated ByHI_UPDATED_BYHI_UPDATED_BY101282
Hi Updated Date Eul5 Hierarchies.Hi Updated DateHI_UPDATED_DATEHI_UPDATED_DATE101283
Hi User Prop1 Eul5 Hierarchies.Hi User Prop1HI_USER_PROP1HI_USER_PROP1101284
Hi User Prop2 Eul5 Hierarchies.Hi User Prop2HI_USER_PROP2HI_USER_PROP2101285
Ibh Dbh Id Eul5 Hierarchies.Ibh Dbh IdIBH_DBH_IDIBH_DBH_ID101306
Notm Eul5 Hierarchies.NotmNOTMNOTM101414
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Eul5 Hierarchies.Hi Id -> Eul5 Dbh Nodes.Dhn Hi IdEul5 Hierarchies.Hi Id = Eul5 Dbh Nodes.Dhn Hi IdAlways exist in master folderNoneYes
Eul5 Hierarchies.Hi Id -> Eul5 Hi Nodes.Hn Hi IdEul5 Hierarchies.Hi Id = Eul5 Hi Nodes.Hn Hi IdAlways exist in master folderNoneYes
Eul5 Hierarchies.Hi Id -> Eul5 Hi Segments.Ihs Hi IdEul5 Hierarchies.Hi Id = Eul5 Hi Segments.Ihs Hi IdAlways exist in master folderNoneYes
Eul5 Hierarchies.Hi Id -> Eul5 Hi Segments.Dhs Hi IdEul5 Hierarchies.Hi Id = Eul5 Hi Segments.Dhs Hi IdAlways exist in master folderNoneYes
Eul5 Ig Exp Links
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
EUL5 HierarchyNoneSYSTEM.EUL5_IG_EXP_LINKS25-OCT-2006
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Hil Exp Id Eul5 Ig Exp Links.Hil Exp IdHIL_EXP_IDHIL_EXP_ID101270
Hil Hn Id Eul5 Ig Exp Links.Hil Hn IdHIL_HN_IDHIL_HN_ID101271
Iel Created By Eul5 Ig Exp Links.Iel Created ByIEL_CREATED_BYIEL_CREATED_BY101308
Iel Created Date Eul5 Ig Exp Links.Iel Created DateIEL_CREATED_DATEIEL_CREATED_DATE101309
Iel Element State Eul5 Ig Exp Links.Iel Element StateIEL_ELEMENT_STATEIEL_ELEMENT_STATE101310
Iel Id Eul5 Ig Exp Links.Iel IdIEL_IDIEL_ID101311
Iel Type Eul5 Ig Exp Links.Iel TypeIEL_TYPEIEL_TYPE101312
Iel Updated By Eul5 Ig Exp Links.Iel Updated ByIEL_UPDATED_BYIEL_UPDATED_BY101313
Iel Updated Date Eul5 Ig Exp Links.Iel Updated DateIEL_UPDATED_DATEIEL_UPDATED_DATE101314
Kil Exp Id Eul5 Ig Exp Links.Kil Exp IdKIL_EXP_IDKIL_EXP_ID101363
Kil Key Id Eul5 Ig Exp Links.Kil Key IdKIL_KEY_IDKIL_KEY_ID101364
Kil Sequence Eul5 Ig Exp Links.Kil SequenceKIL_SEQUENCEKIL_SEQUENCE101365
Notm Eul5 Ig Exp Links.NotmNOTMNOTM101417
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Eul5 Ihs Fk Links
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNoneSYSTEM.EUL5_IHS_FK_LINKS25-OCT-2006
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Ifl Created By Eul5 Ihs Fk Links.Ifl Created ByIFL_CREATED_BYIFL_CREATED_BY101315
Ifl Created Date Eul5 Ihs Fk Links.Ifl Created DateIFL_CREATED_DATEIFL_CREATED_DATE101316
Ifl Element State Eul5 Ihs Fk Links.Ifl Element StateIFL_ELEMENT_STATEIFL_ELEMENT_STATE101317
Ifl Id Eul5 Ihs Fk Links.Ifl IdIFL_IDIFL_ID101318
Ifl Ihs Id Eul5 Ihs Fk Links.Ifl Ihs IdIFL_IHS_IDIFL_IHS_ID101319
Ifl Key Id Eul5 Ihs Fk Links.Ifl Key IdIFL_KEY_IDIFL_KEY_ID101320
Ifl Updated By Eul5 Ihs Fk Links.Ifl Updated ByIFL_UPDATED_BYIFL_UPDATED_BY101321
Ifl Updated Date Eul5 Ihs Fk Links.Ifl Updated DateIFL_UPDATED_DATEIFL_UPDATED_DATE101322
Notm Eul5 Ihs Fk Links.NotmNOTMNOTM101418
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Eul5 Key Cons
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
EUL5 JoinsNoneSYSTEM.EUL5_KEY_CONS25-OCT-2006
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Fk Dtl No Master Eul5 Key Cons.Fk Dtl No MasterFK_DTL_NO_MASTERFK_DTL_NO_MASTER101219
Fk Key Id Remote Eul5 Key Cons.Fk Key Id RemoteFK_KEY_ID_REMOTEFK_KEY_ID_REMOTE101220
Fk Mandatory Eul5 Key Cons.Fk MandatoryFK_MANDATORYFK_MANDATORY101221
Fk Mstr No Detail Eul5 Key Cons.Fk Mstr No DetailFK_MSTR_NO_DETAILFK_MSTR_NO_DETAIL101222
Fk Obj Id Remote Eul5 Key Cons.Fk Obj Id RemoteFK_OBJ_ID_REMOTEFK_OBJ_ID_REMOTE101223
Fk One To One Eul5 Key Cons.Fk One To OneFK_ONE_TO_ONEFK_ONE_TO_ONE101224
Key Created By Eul5 Key Cons.Key Created ByKEY_CREATED_BYKEY_CREATED_BY101349
Key Created Date Eul5 Key Cons.Key Created DateKEY_CREATED_DATEKEY_CREATED_DATE101350
Key Description Eul5 Key Cons.Key DescriptionKEY_DESCRIPTIONKEY_DESCRIPTION101351
Key Developer Key Eul5 Key Cons.Key Developer KeyKEY_DEVELOPER_KEYKEY_DEVELOPER_KEY101352
Key Element State Eul5 Key Cons.Key Element StateKEY_ELEMENT_STATEKEY_ELEMENT_STATE101353
Key Ext Key Eul5 Key Cons.Key Ext KeyKEY_EXT_KEYKEY_EXT_KEY101354
Key Id Eul5 Key Cons.Key IdKEY_IDKEY_ID101355
Key Name Eul5 Key Cons.Key NameKEY_NAMEKEY_NAME101356
Key Obj Id Eul5 Key Cons.Key Obj IdKEY_OBJ_IDKEY_OBJ_ID101357
Key Type Eul5 Key Cons.Key TypeKEY_TYPEKEY_TYPE101358
Key Updated By Eul5 Key Cons.Key Updated ByKEY_UPDATED_BYKEY_UPDATED_BY101359
Key Updated Date Eul5 Key Cons.Key Updated DateKEY_UPDATED_DATEKEY_UPDATED_DATE101360
Key User Prop1 Eul5 Key Cons.Key User Prop1KEY_USER_PROP1KEY_USER_PROP1101361
Key User Prop2 Eul5 Key Cons.Key User Prop2KEY_USER_PROP2KEY_USER_PROP2101362
Notm Eul5 Key Cons.NotmNOTMNOTM101419
Uk Primary Eul5 Key Cons.Uk PrimaryUK_PRIMARYUK_PRIMARY101738
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Eul5 Key Cons.Key Id -> Eul5 Ig Exp Links.Kil Key IdEul5 Key Cons.Key Id = Eul5 Ig Exp Links.Kil Key IdMight not exist in master folderNoneYes
Eul5 Key Cons.Fk Key Id Remote -> Eul5 Ig Exp Links.Kil Key IdEul5 Key Cons.Fk Key Id Remote = Eul5 Ig Exp Links.Kil Key IdAlways exist in master folderNoneYes
Eul5 Key Cons.Key Id -> Eul5 Expressions.Jp Key IdEul5 Key Cons.Key Id = Eul5 Expressions.Jp Key IdMight not exist in master folderNoneYes
Eul5 Key Cons.Key Id -> Eul5 Sum Bitmaps.Sb Key IdEul5 Key Cons.Key Id = Eul5 Sum Bitmaps.Sb Key IdMight not exist in master folderNoneYes
Eul5 Key Cons.Key Id -> Eul5 Ihs Fk Links.Ifl Key IdEul5 Key Cons.Key Id = Eul5 Ihs Fk Links.Ifl Key IdAlways exist in master folderNoneYes
Eul5 Key Cons.Key Id -> Eul5 Obj Join Usgs.Oju Key IdEul5 Key Cons.Key Id = Eul5 Obj Join Usgs.Oju Key IdAlways exist in master folderNoneYes
Eul5 Named Elems
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNoneSYSTEM.EUL5_NAMED_ELEMSNot Analyzed
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
El Base Type Eul5 Named Elems.El Base TypeEL_BASE_TYPEEL_BASE_TYPE101114
El Created By Eul5 Named Elems.El Created ByEL_CREATED_BYEL_CREATED_BY101115
El Created Date Eul5 Named Elems.El Created DateEL_CREATED_DATEEL_CREATED_DATE101116
El Id Eul5 Named Elems.El IdEL_IDEL_ID101117
El Parent Id Eul5 Named Elems.El Parent IdEL_PARENT_IDEL_PARENT_ID101118
El Parent Type Eul5 Named Elems.El Parent TypeEL_PARENT_TYPEEL_PARENT_TYPE101119
El Type Eul5 Named Elems.El TypeEL_TYPEEL_TYPE101120
El Updated By Eul5 Named Elems.El Updated ByEL_UPDATED_BYEL_UPDATED_BY101121
El Updated Date Eul5 Named Elems.El Updated DateEL_UPDATED_DATEEL_UPDATED_DATE101122
Nel Description Eul5 Named Elems.Nel DescriptionNEL_DESCRIPTIONNEL_DESCRIPTION101379
Nel Developer Key Eul5 Named Elems.Nel Developer KeyNEL_DEVELOPER_KEYNEL_DEVELOPER_KEY101380
Nel Devkey Frozen Eul5 Named Elems.Nel Devkey FrozenNEL_DEVKEY_FROZENNEL_DEVKEY_FROZEN101381
Nel Name Eul5 Named Elems.Nel NameNEL_NAMENEL_NAME101382
Nel User Prop1 Eul5 Named Elems.Nel User Prop1NEL_USER_PROP1NEL_USER_PROP1101383
Nel User Prop2 Eul5 Named Elems.Nel User Prop2NEL_USER_PROP2NEL_USER_PROP2101384
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Eul5 Obj Deps
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNoneSYSTEM.EUL5_OBJ_DEPS25-OCT-2006
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Notm Eul5 Obj Deps.NotmNOTMNOTM101421
Od Created By Eul5 Obj Deps.Od Created ByOD_CREATED_BYOD_CREATED_BY101463
Od Created Date Eul5 Obj Deps.Od Created DateOD_CREATED_DATEOD_CREATED_DATE101464
Od Element State Eul5 Obj Deps.Od Element StateOD_ELEMENT_STATEOD_ELEMENT_STATE101465
Od Id Eul5 Obj Deps.Od IdOD_IDOD_ID101466
Od Obj Id From Eul5 Obj Deps.Od Obj Id FromOD_OBJ_ID_FROMOD_OBJ_ID_FROM101467
Od Obj Id To Eul5 Obj Deps.Od Obj Id ToOD_OBJ_ID_TOOD_OBJ_ID_TO101468
Od Updated By Eul5 Obj Deps.Od Updated ByOD_UPDATED_BYOD_UPDATED_BY101469
Od Updated Date Eul5 Obj Deps.Od Updated DateOD_UPDATED_DATEOD_UPDATED_DATE101470
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Eul5 Obj Join Usgs
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNoneSYSTEM.EUL5_OBJ_JOIN_USGS25-OCT-2006
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Notm Eul5 Obj Join Usgs.NotmNOTMNOTM101422
Oju Created By Eul5 Obj Join Usgs.Oju Created ByOJU_CREATED_BYOJU_CREATED_BY101471
Oju Created Date Eul5 Obj Join Usgs.Oju Created DateOJU_CREATED_DATEOJU_CREATED_DATE101472
Oju Element State Eul5 Obj Join Usgs.Oju Element StateOJU_ELEMENT_STATEOJU_ELEMENT_STATE101473
Oju Id Eul5 Obj Join Usgs.Oju IdOJU_IDOJU_ID101474
Oju Join Modified Eul5 Obj Join Usgs.Oju Join ModifiedOJU_JOIN_MODIFIEDOJU_JOIN_MODIFIED101475
Oju Key Id Eul5 Obj Join Usgs.Oju Key IdOJU_KEY_IDOJU_KEY_ID101476
Oju Obj Id Eul5 Obj Join Usgs.Oju Obj IdOJU_OBJ_IDOJU_OBJ_ID101477
Oju Sumo Id Eul5 Obj Join Usgs.Oju Sumo IdOJU_SUMO_IDOJU_SUMO_ID101478
Oju Updated By Eul5 Obj Join Usgs.Oju Updated ByOJU_UPDATED_BYOJU_UPDATED_BY101479
Oju Updated Date Eul5 Obj Join Usgs.Oju Updated DateOJU_UPDATED_DATEOJU_UPDATED_DATE101480
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Eul5 Objs
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
EUL5 Alternate Sorts, EUL5 Item Classes, EUL5 Business Areas & Folders, EUL5 Conditions, EUL5 Folders & Items, EUL5 Item Class SQL, EUL5 Item Class Used By , EUL5 Summary MappingsNoneSYSTEM.EUL5_OBJS25-OCT-2006
EUL5 Alternate Sorts, EUL5 Item Classes, EUL5 Business Areas & Folders, EUL5 Conditions, EUL5 Folders & Items, EUL5 Item Class SQL, EUL5 Item Class Used By , EUL5 Summary MappingsNoneSYSTEM.EUL5_OBJS25-OCT-2006
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Notm Eul5 Objs.NotmNOTMNOTM101420
Obj Ba Id Eul5 Objs.Obj Ba IdOBJ_BA_IDOBJ_BA_ID101439
Obj Cbo Hint Eul5 Objs.Obj Cbo HintOBJ_CBO_HINTOBJ_CBO_HINT101440
Obj Created By Eul5 Objs.Obj Created ByOBJ_CREATED_BYOBJ_CREATED_BY101441
Obj Created Date Eul5 Objs.Obj Created DateOBJ_CREATED_DATEOBJ_CREATED_DATE101442
Obj Description Eul5 Objs.Obj DescriptionOBJ_DESCRIPTIONOBJ_DESCRIPTION101443
Obj Developer Key Eul5 Objs.Obj Developer KeyOBJ_DEVELOPER_KEYOBJ_DEVELOPER_KEY101444
Obj Distinct Flag Eul5 Objs.Obj Distinct FlagOBJ_DISTINCT_FLAGOBJ_DISTINCT_FLAG101445
Obj Element State Eul5 Objs.Obj Element StateOBJ_ELEMENT_STATEOBJ_ELEMENT_STATE101446
Obj Ext Db Link Eul5 Objs.Obj Ext Db LinkOBJ_EXT_DB_LINKOBJ_EXT_DB_LINK101447
Obj Ext Object Eul5 Objs.Obj Ext ObjectOBJ_EXT_OBJECTOBJ_EXT_OBJECT101448
Obj Ext Owner Eul5 Objs.Obj Ext OwnerOBJ_EXT_OWNEROBJ_EXT_OWNER101449
Obj Hidden Eul5 Objs.Obj HiddenOBJ_HIDDENOBJ_HIDDEN101450
Obj Id Eul5 Objs.Obj IdOBJ_IDOBJ_ID101451
Obj Name Eul5 Objs.Obj NameOBJ_NAMEOBJ_NAME101452
Obj Ndeterministic Eul5 Objs.Obj NdeterministicOBJ_NDETERMINISTICOBJ_NDETERMINISTIC101453
Obj Object Sql1 Eul5 Objs.Obj Object Sql1OBJ_OBJECT_SQL1OBJ_OBJECT_SQL1101454
Obj Object Sql2 Eul5 Objs.Obj Object Sql2OBJ_OBJECT_SQL2OBJ_OBJECT_SQL2101455
Obj Object Sql3 Eul5 Objs.Obj Object Sql3OBJ_OBJECT_SQL3OBJ_OBJECT_SQL3101456
Obj Type Eul5 Objs.Obj TypeOBJ_TYPEOBJ_TYPE101457
Obj Updated By Eul5 Objs.Obj Updated ByOBJ_UPDATED_BYOBJ_UPDATED_BY101458
Obj Updated Date Eul5 Objs.Obj Updated DateOBJ_UPDATED_DATEOBJ_UPDATED_DATE101459
Obj User Prop1 Eul5 Objs.Obj User Prop1OBJ_USER_PROP1OBJ_USER_PROP1101460
Obj User Prop2 Eul5 Objs.Obj User Prop2OBJ_USER_PROP2OBJ_USER_PROP2101461
Sobj Ext Table Eul5 Objs.Sobj Ext TableSOBJ_EXT_TABLESOBJ_EXT_TABLE101643
Notm Eul5 Objs.NotmNOTMNOTM101420
Obj Ba Id Eul5 Objs.Obj Ba IdOBJ_BA_IDOBJ_BA_ID101439
Obj Cbo Hint Eul5 Objs.Obj Cbo HintOBJ_CBO_HINTOBJ_CBO_HINT101440
Obj Created By Eul5 Objs.Obj Created ByOBJ_CREATED_BYOBJ_CREATED_BY101441
Obj Created Date Eul5 Objs.Obj Created DateOBJ_CREATED_DATEOBJ_CREATED_DATE101442
Obj Description Eul5 Objs.Obj DescriptionOBJ_DESCRIPTIONOBJ_DESCRIPTION101443
Obj Developer Key Eul5 Objs.Obj Developer KeyOBJ_DEVELOPER_KEYOBJ_DEVELOPER_KEY101444
Obj Distinct Flag Eul5 Objs.Obj Distinct FlagOBJ_DISTINCT_FLAGOBJ_DISTINCT_FLAG101445
Obj Element State Eul5 Objs.Obj Element StateOBJ_ELEMENT_STATEOBJ_ELEMENT_STATE101446
Obj Ext Db Link Eul5 Objs.Obj Ext Db LinkOBJ_EXT_DB_LINKOBJ_EXT_DB_LINK101447
Obj Ext Object Eul5 Objs.Obj Ext ObjectOBJ_EXT_OBJECTOBJ_EXT_OBJECT101448
Obj Ext Owner Eul5 Objs.Obj Ext OwnerOBJ_EXT_OWNEROBJ_EXT_OWNER101449
Obj Hidden Eul5 Objs.Obj HiddenOBJ_HIDDENOBJ_HIDDEN101450
Obj Id Eul5 Objs.Obj IdOBJ_IDOBJ_ID101451
Obj Name Eul5 Objs.Obj NameOBJ_NAMEOBJ_NAME101452
Obj Ndeterministic Eul5 Objs.Obj NdeterministicOBJ_NDETERMINISTICOBJ_NDETERMINISTIC101453
Obj Object Sql1 Eul5 Objs.Obj Object Sql1OBJ_OBJECT_SQL1OBJ_OBJECT_SQL1101454
Obj Object Sql2 Eul5 Objs.Obj Object Sql2OBJ_OBJECT_SQL2OBJ_OBJECT_SQL2101455
Obj Object Sql3 Eul5 Objs.Obj Object Sql3OBJ_OBJECT_SQL3OBJ_OBJECT_SQL3101456
Obj Type Eul5 Objs.Obj TypeOBJ_TYPEOBJ_TYPE101457
Obj Updated By Eul5 Objs.Obj Updated ByOBJ_UPDATED_BYOBJ_UPDATED_BY101458
Obj Updated Date Eul5 Objs.Obj Updated DateOBJ_UPDATED_DATEOBJ_UPDATED_DATE101459
Obj User Prop1 Eul5 Objs.Obj User Prop1OBJ_USER_PROP1OBJ_USER_PROP1101460
Obj User Prop2 Eul5 Objs.Obj User Prop2OBJ_USER_PROP2OBJ_USER_PROP2101461
Sobj Ext Table Eul5 Objs.Sobj Ext TableSOBJ_EXT_TABLESOBJ_EXT_TABLE101643
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Eul5 Objs.Obj Id -> Eul5 Obj Deps.Od Obj Id ToEul5 Objs.Obj Id = Eul5 Obj Deps.Od Obj Id ToAlways exist in master folderNoneYes
Eul5 Objs.Obj Id -> Eul5 Sub Queries.Sq Obj IdEul5 Objs.Obj Id = Eul5 Sub Queries.Sq Obj IdAlways exist in master folderNoneYes
Eul5 Objs.Obj Id -> Eul5 Ba Obj Links.Bol Obj IdEul5 Objs.Obj Id = Eul5 Ba Obj Links.Bol Obj IdAlways exist in master folderNoneYes
Eul5 Objs.Obj Id -> Eul5 Key Cons.Key Obj IdEul5 Objs.Obj Id = Eul5 Key Cons.Key Obj IdAlways exist in master folderNoneYes
Eul5 Objs.Obj Id -> Eul5 Expressions.Fil Obj IdEul5 Objs.Obj Id = Eul5 Expressions.Fil Obj IdMight not exist in master folderNoneYes
Eul5 Objs.Obj Id -> Eul5 Obj Deps.Od Obj Id FromEul5 Objs.Obj Id = Eul5 Obj Deps.Od Obj Id FromAlways exist in master folderNoneYes
Eul5 Objs.Obj Id -> Eul5 Asmp Cons.Aoc Obj IdEul5 Objs.Obj Id = Eul5 Asmp Cons.Aoc Obj IdAlways exist in master folderNoneYes
Eul5 Objs.Obj Id -> Eul5 Segments.Seg Cuo IdEul5 Objs.Obj Id = Eul5 Segments.Seg Cuo IdAlways exist in master folderNoneYes
Eul5 Objs.Obj Id -> Eul5 Obj Join Usgs.Oju Obj IdEul5 Objs.Obj Id = Eul5 Obj Join Usgs.Oju Obj IdAlways exist in master folderNoneYes
Eul5 Objs.Obj Id -> Eul5 Key Cons.Fk Obj Id RemoteEul5 Objs.Obj Id = Eul5 Key Cons.Fk Obj Id RemoteMight not exist in master folderNoneYes
Eul5 Objs.Obj Id -> Eul5 Segments.Seg Obj IdEul5 Objs.Obj Id = Eul5 Segments.Seg Obj IdAlways exist in master folderNoneYes
Eul5 Objs.Obj Id -> Eul5 Expressions.It Obj IdEul5 Objs.Obj Id = Eul5 Expressions.It Obj IdMight not exist in master folderNoneYes
Eul5 Odbc Catalogs
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNoneSYSTEM.EUL5_ODBC_CATALOGSNot Analyzed
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Oc Catalog Name Eul5 Odbc Catalogs.Oc Catalog NameOC_CATALOG_NAMEOC_CATALOG_NAME101462
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Eul5 Odbc Schemas
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNoneSYSTEM.EUL5_ODBC_SCHEMASNot Analyzed
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Os Schema Name Eul5 Odbc Schemas.Os Schema NameOS_SCHEMA_NAMEOS_SCHEMA_NAME101484
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Eul5 Plan Table
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNoneSYSTEM.EUL5_PLAN_TABLEUnknown
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Bytes Eul5 Plan Table.BytesBYTESBYTES101033
Cardinality Eul5 Plan Table.CardinalityCARDINALITYCARDINALITY101034
Cost Eul5 Plan Table.CostCOSTCOST101040
Distribution Eul5 Plan Table.DistributionDISTRIBUTIONDISTRIBUTION101063
Id Eul5 Plan Table.IdIDID101307
Object Instance Eul5 Plan Table.Object InstanceOBJECT_INSTANCEOBJECT_INSTANCE101432
Object Name Eul5 Plan Table.Object NameOBJECT_NAMEOBJECT_NAME101434
Object Node Eul5 Plan Table.Object NodeOBJECT_NODEOBJECT_NODE101435
Object Owner Eul5 Plan Table.Object OwnerOBJECT_OWNEROBJECT_OWNER101436
Object Type Eul5 Plan Table.Object TypeOBJECT_TYPEOBJECT_TYPE101438
Operation Eul5 Plan Table.OperationOPERATIONOPERATION101481
Optimizer Eul5 Plan Table.OptimizerOPTIMIZEROPTIMIZER101482
Options Eul5 Plan Table.OptionsOPTIONSOPTIONS101483
Other Eul5 Plan Table.OtherOTHEROTHER101485
Other Tag Eul5 Plan Table.Other TagOTHER_TAGOTHER_TAG101486
Parent Id Eul5 Plan Table.Parent IdPARENT_IDPARENT_ID101490
Partition Id Eul5 Plan Table.Partition IdPARTITION_IDPARTITION_ID101491
Partition Start Eul5 Plan Table.Partition StartPARTITION_STARTPARTITION_START101492
Partition Stop Eul5 Plan Table.Partition StopPARTITION_STOPPARTITION_STOP101493
Position Eul5 Plan Table.PositionPOSITIONPOSITION101498
Remarks Eul5 Plan Table.RemarksREMARKSREMARKS101551
Search Columns Eul5 Plan Table.Search ColumnsSEARCH_COLUMNSSEARCH_COLUMNS101603
Statement Id Eul5 Plan Table.Statement IdSTATEMENT_IDSTATEMENT_ID101691
Timestamp Eul5 Plan Table.TimestampTIMESTAMPTIMESTAMP101736
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Eul5 Qpp Stats
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
EUL5 Users QueriesNoneSYSTEM.EUL5_QPP_STATS05-MAR-2007
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Act Cpu Time Eul5 Qpp Stats.Act Cpu TimeQS_ACT_CPU_TIMEQS_ACT_CPU_TIME101504
Act Elap Time Eul5 Qpp Stats.Act Elap TimeQS_ACT_ELAP_TIMEQS_ACT_ELAP_TIME101505
Condition Item Ids Eul5 Qpp Stats.Id CONDITION_ITEM_IDS101824
Condition Items Eul5 Qpp Stats.Id CONDITION_NAME101827
Created By Eul5 Qpp Stats.Created ByQS_CREATED_BYQS_CREATED_BY101507
Created Date Eul5 Qpp Stats.Created DateQS_CREATED_DATEQS_CREATED_DATE101508
Dbmp0 Eul5 Qpp Stats.Dbmp0QS_DBMP0QS_DBMP0101509
Dbmp1 Eul5 Qpp Stats.Dbmp1QS_DBMP1QS_DBMP1101510
Dbmp2 Eul5 Qpp Stats.Dbmp2QS_DBMP2QS_DBMP2101511
Dbmp3 Eul5 Qpp Stats.Dbmp3QS_DBMP3QS_DBMP3101512
Dbmp4 Eul5 Qpp Stats.Dbmp4QS_DBMP4QS_DBMP4101513
Dbmp5 Eul5 Qpp Stats.Dbmp5QS_DBMP5QS_DBMP5101514
Dbmp6 Eul5 Qpp Stats.Dbmp6QS_DBMP6QS_DBMP6101515
Dbmp7 Eul5 Qpp Stats.Dbmp7QS_DBMP7QS_DBMP7101516
Doc Details Eul5 Qpp Stats.Doc DetailsQS_DOC_DETAILSQS_DOC_DETAILS101517
Doc Name Eul5 Qpp Stats.Doc NameQS_DOC_NAMEQS_DOC_NAME101518
Doc Owner Eul5 Qpp Stats.Doc OwnerQS_DOC_OWNERQS_DOC_OWNER101519
Est Elap Time Eul5 Qpp Stats.Est Elap TimeQS_EST_ELAP_TIMEQS_EST_ELAP_TIME101520
Fbmp0 Eul5 Qpp Stats.Fbmp0QS_FBMP0QS_FBMP0101521
Fbmp1 Eul5 Qpp Stats.Fbmp1QS_FBMP1QS_FBMP1101522
Fbmp2 Eul5 Qpp Stats.Fbmp2QS_FBMP2QS_FBMP2101523
Fbmp3 Eul5 Qpp Stats.Fbmp3QS_FBMP3QS_FBMP3101524
Fbmp4 Eul5 Qpp Stats.Fbmp4QS_FBMP4QS_FBMP4101525
Fbmp5 Eul5 Qpp Stats.Fbmp5QS_FBMP5QS_FBMP5101526
Fbmp6 Eul5 Qpp Stats.Fbmp6QS_FBMP6QS_FBMP6101527
Fbmp7 Eul5 Qpp Stats.Fbmp7QS_FBMP7QS_FBMP7101528
Folder Name Eul5 Qpp Stats.Object Use Key FOLDER_NAME102118
Id Eul5 Qpp Stats.IdQS_IDQS_ID101529
Item Ids Eul5 Qpp Stats.Id ITEM_IDS102230
Item Name Eul5 Qpp Stats.Id ITEM_NAME102237
Jbmp0 Eul5 Qpp Stats.Jbmp0QS_JBMP0QS_JBMP0101530
Jbmp1 Eul5 Qpp Stats.Jbmp1QS_JBMP1QS_JBMP1101531
Jbmp2 Eul5 Qpp Stats.Jbmp2QS_JBMP2QS_JBMP2101532
Jbmp3 Eul5 Qpp Stats.Jbmp3QS_JBMP3QS_JBMP3101533
Jbmp4 Eul5 Qpp Stats.Jbmp4QS_JBMP4QS_JBMP4101534
Jbmp5 Eul5 Qpp Stats.Jbmp5QS_JBMP5QS_JBMP5101535
Jbmp6 Eul5 Qpp Stats.Jbmp6QS_JBMP6QS_JBMP6101536
Jbmp7 Eul5 Qpp Stats.Jbmp7QS_JBMP7QS_JBMP7101537
Join Ids Eul5 Qpp Stats.Id JOIN_IDS102268
Join Name Eul5 Qpp Stats.Id JOIN_NAME102276
Mbmp0 Eul5 Qpp Stats.Mbmp0QS_MBMP0QS_MBMP0101538
Mbmp1 Eul5 Qpp Stats.Mbmp1QS_MBMP1QS_MBMP1101539
Mbmp2 Eul5 Qpp Stats.Mbmp2QS_MBMP2QS_MBMP2101540
Mbmp3 Eul5 Qpp Stats.Mbmp3QS_MBMP3QS_MBMP3101541
Mbmp4 Eul5 Qpp Stats.Mbmp4QS_MBMP4QS_MBMP4101542
Mbmp5 Eul5 Qpp Stats.Mbmp5QS_MBMP5QS_MBMP5101543
Mbmp6 Eul5 Qpp Stats.Mbmp6QS_MBMP6QS_MBMP6101544
Mbmp7 Eul5 Qpp Stats.Mbmp7QS_MBMP7QS_MBMP7101545
Num Rows Eul5 Qpp Stats.Num RowsQS_NUM_ROWSQS_NUM_ROWS101546
Object Use Key Eul5 Qpp Stats.Object Use KeyQS_OBJECT_USE_KEYQS_OBJECT_USE_KEY101547
Optimizer Cost Eul5 Qpp Stats.Optimizer CostQS_COSTQS_COST101506
Query Status Eul5 Qpp Stats.State QUERY_STATUS102430
Rows Retrieved Eul5 Qpp Stats.Num Rows ROWS_RETRIEVED102436
Sdo Id Eul5 Qpp Stats.Sdo IdQS_SDO_IDQS_SDO_ID101548
State Eul5 Qpp Stats.StateQS_STATEQS_STATE101549
Summary Fit Eul5 Qpp Stats.Summary Fit Id SUMMARY_FIT102522
Summary Fit Id Eul5 Qpp Stats.Summary Fit IdQS_SUMMARY_FITQS_SUMMARY_FIT101550
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Eul5 Segments
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNoneSYSTEM.EUL5_SEGMENTS25-OCT-2006
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Notm Eul5 Segments.NotmNOTMNOTM101423
Seg Bq Id Eul5 Segments.Seg Bq IdSEG_BQ_IDSEG_BQ_ID101605
Seg Chunk1 Eul5 Segments.Seg Chunk1SEG_CHUNK1SEG_CHUNK1101606
Seg Chunk2 Eul5 Segments.Seg Chunk2SEG_CHUNK2SEG_CHUNK2101607
Seg Chunk3 Eul5 Segments.Seg Chunk3SEG_CHUNK3SEG_CHUNK3101608
Seg Chunk4 Eul5 Segments.Seg Chunk4SEG_CHUNK4SEG_CHUNK4101609
Seg Created By Eul5 Segments.Seg Created BySEG_CREATED_BYSEG_CREATED_BY101610
Seg Created Date Eul5 Segments.Seg Created DateSEG_CREATED_DATESEG_CREATED_DATE101611
Seg Cuo Id Eul5 Segments.Seg Cuo IdSEG_CUO_IDSEG_CUO_ID101612
Seg El Id Eul5 Segments.Seg El IdSEG_EL_IDSEG_EL_ID101614
Seg Element State Eul5 Segments.Seg Element StateSEG_ELEMENT_STATESEG_ELEMENT_STATE101613
Seg Exp Id Eul5 Segments.Seg Exp IdSEG_EXP_IDSEG_EXP_ID101615
Seg Id Eul5 Segments.Seg IdSEG_IDSEG_ID101616
Seg Obj Id Eul5 Segments.Seg Obj IdSEG_OBJ_IDSEG_OBJ_ID101617
Seg Seg Type Eul5 Segments.Seg Seg TypeSEG_SEG_TYPESEG_SEG_TYPE101618
Seg Sequence Eul5 Segments.Seg SequenceSEG_SEQUENCESEG_SEQUENCE101619
Seg Sms Id Eul5 Segments.Seg Sms IdSEG_SMS_IDSEG_SMS_ID101621
Seg Sumo Id Eul5 Segments.Seg Sumo IdSEG_SUMO_IDSEG_SUMO_ID101622
Seg Updated By Eul5 Segments.Seg Updated BySEG_UPDATED_BYSEG_UPDATED_BY101623
Seg Updated Date Eul5 Segments.Seg Updated DateSEG_UPDATED_DATESEG_UPDATED_DATE101624
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Eul5 Sequences
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNoneSYSTEM.EUL5_SEQUENCES25-OCT-2006
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Id Eul5 Sequences.IdSEQ_IDSEQ_ID101625
Name Eul5 Sequences.NameSEQ_NAMESEQ_NAME101626
Nextval Eul5 Sequences.NextvalSEQ_NEXTVALSEQ_NEXTVAL101627
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Eul5 Sq Crrltns
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNoneSYSTEM.EUL5_SQ_CRRLTNS25-OCT-2006
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Notm Eul5 Sq Crrltns.NotmNOTMNOTM101424
Sqc Created By Eul5 Sq Crrltns.Sqc Created BySQC_CREATED_BYSQC_CREATED_BY101646
Sqc Created Date Eul5 Sq Crrltns.Sqc Created DateSQC_CREATED_DATESQC_CREATED_DATE101647
Sqc Element State Eul5 Sq Crrltns.Sqc Element StateSQC_ELEMENT_STATESQC_ELEMENT_STATE101648
Sqc Id Eul5 Sq Crrltns.Sqc IdSQC_IDSQC_ID101649
Sqc It Inner Id Eul5 Sq Crrltns.Sqc It Inner IdSQC_IT_INNER_IDSQC_IT_INNER_ID101650
Sqc It Outer Id Eul5 Sq Crrltns.Sqc It Outer IdSQC_IT_OUTER_IDSQC_IT_OUTER_ID101651
Sqc Sq Id Eul5 Sq Crrltns.Sqc Sq IdSQC_SQ_IDSQC_SQ_ID101652
Sqc Updated By Eul5 Sq Crrltns.Sqc Updated BySQC_UPDATED_BYSQC_UPDATED_BY101653
Sqc Updated Date Eul5 Sq Crrltns.Sqc Updated DateSQC_UPDATED_DATESQC_UPDATED_DATE101654
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Eul5 Sub Queries
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNoneSYSTEM.EUL5_SUB_QUERIES25-OCT-2006
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Notm Eul5 Sub Queries.NotmNOTMNOTM101425
Sq Created By Eul5 Sub Queries.Sq Created BySQ_CREATED_BYSQ_CREATED_BY101656
Sq Created Date Eul5 Sub Queries.Sq Created DateSQ_CREATED_DATESQ_CREATED_DATE101657
Sq Description Eul5 Sub Queries.Sq DescriptionSQ_DESCRIPTIONSQ_DESCRIPTION101658
Sq Developer Key Eul5 Sub Queries.Sq Developer KeySQ_DEVELOPER_KEYSQ_DEVELOPER_KEY101659
Sq Element State Eul5 Sub Queries.Sq Element StateSQ_ELEMENT_STATESQ_ELEMENT_STATE101660
Sq Fil Id Eul5 Sub Queries.Sq Fil IdSQ_FIL_IDSQ_FIL_ID101661
Sq Id Eul5 Sub Queries.Sq IdSQ_IDSQ_ID101662
Sq It Id Eul5 Sub Queries.Sq It IdSQ_IT_IDSQ_IT_ID101663
Sq Name Eul5 Sub Queries.Sq NameSQ_NAMESQ_NAME101664
Sq Obj Id Eul5 Sub Queries.Sq Obj IdSQ_OBJ_IDSQ_OBJ_ID101665
Sq Updated By Eul5 Sub Queries.Sq Updated BySQ_UPDATED_BYSQ_UPDATED_BY101666
Sq Updated Date Eul5 Sub Queries.Sq Updated DateSQ_UPDATED_DATESQ_UPDATED_DATE101667
Sq User Prop1 Eul5 Sub Queries.Sq User Prop1SQ_USER_PROP1SQ_USER_PROP1101668
Sq User Prop2 Eul5 Sub Queries.Sq User Prop2SQ_USER_PROP2SQ_USER_PROP2101669
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Eul5 Sub Queries.Sq Id -> Eul5 Exp Deps.Psd Sq IdEul5 Sub Queries.Sq Id = Eul5 Exp Deps.Psd Sq IdAlways exist in master folderNoneYes
Eul5 Sub Queries.Sq Id -> Eul5 Sq Crrltns.Sqc Sq IdEul5 Sub Queries.Sq Id = Eul5 Sq Crrltns.Sqc Sq IdAlways exist in master folderNoneYes
Eul5 Sum Bitmaps
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNoneSYSTEM.EUL5_SUM_BITMAPS25-OCT-2006
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Notm Eul5 Sum Bitmaps.NotmNOTMNOTM101429
Sb Bitmap Eul5 Sum Bitmaps.Sb BitmapSB_BITMAPSB_BITMAP101565
Sb Created By Eul5 Sum Bitmaps.Sb Created BySB_CREATED_BYSB_CREATED_BY101566
Sb Created Date Eul5 Sum Bitmaps.Sb Created DateSB_CREATED_DATESB_CREATED_DATE101567
Sb Element State Eul5 Sum Bitmaps.Sb Element StateSB_ELEMENT_STATESB_ELEMENT_STATE101568
Sb Exp Id Eul5 Sum Bitmaps.Sb Exp IdSB_EXP_IDSB_EXP_ID101569
Sb Fun Id Eul5 Sum Bitmaps.Sb Fun IdSB_FUN_IDSB_FUN_ID101570
Sb Id Eul5 Sum Bitmaps.Sb IdSB_IDSB_ID101571
Sb Key Id Eul5 Sum Bitmaps.Sb Key IdSB_KEY_IDSB_KEY_ID101572
Sb Sequence Eul5 Sum Bitmaps.Sb SequenceSB_SEQUENCESB_SEQUENCE101573
Sb Updated By Eul5 Sum Bitmaps.Sb Updated BySB_UPDATED_BYSB_UPDATED_BY101574
Sb Updated Date Eul5 Sum Bitmaps.Sb Updated DateSB_UPDATED_DATESB_UPDATED_DATE101575
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Eul5 Sum Rfsh Sets
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
EUL5 Existing Summary Combos , EUL5 Summary Folders, EUL5 Summary Mappings, EUL5 Users QueriesNoneSYSTEM.EUL5_SUM_RFSH_SETS25-OCT-2006
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Notm Eul5 Sum Rfsh Sets.NotmNOTMNOTM101430
Srs Auto Refresh Eul5 Sum Rfsh Sets.Srs Auto RefreshSRS_AUTO_REFRESHSRS_AUTO_REFRESH101670
Srs Created By Eul5 Sum Rfsh Sets.Srs Created BySRS_CREATED_BYSRS_CREATED_BY101671
Srs Created Date Eul5 Sum Rfsh Sets.Srs Created DateSRS_CREATED_DATESRS_CREATED_DATE101672
Srs Description Eul5 Sum Rfsh Sets.Srs DescriptionSRS_DESCRIPTIONSRS_DESCRIPTION101673
Srs Developer Key Eul5 Sum Rfsh Sets.Srs Developer KeySRS_DEVELOPER_KEYSRS_DEVELOPER_KEY101674
Srs Element State Eul5 Sum Rfsh Sets.Srs Element StateSRS_ELEMENT_STATESRS_ELEMENT_STATE101675
Srs Eu Id Eul5 Sum Rfsh Sets.Srs Eu IdSRS_EU_IDSRS_EU_ID101676
Srs Id Eul5 Sum Rfsh Sets.Srs IdSRS_IDSRS_ID101677
Srs Job Id Eul5 Sum Rfsh Sets.Srs Job IdSRS_JOB_IDSRS_JOB_ID101678
Srs Last Refresh Eul5 Sum Rfsh Sets.Srs Last RefreshSRS_LAST_REFRESHSRS_LAST_REFRESH101679
Srs Name Eul5 Sum Rfsh Sets.Srs NameSRS_NAMESRS_NAME101680
Srs Next Refresh Eul5 Sum Rfsh Sets.Srs Next RefreshSRS_NEXT_REFRESHSRS_NEXT_REFRESH101681
Srs Num Freq Units Eul5 Sum Rfsh Sets.Srs Num Freq UnitsSRS_NUM_FREQ_UNITSSRS_NUM_FREQ_UNITS101682
Srs Online Eul5 Sum Rfsh Sets.Srs OnlineSRS_ONLINESRS_ONLINE101683
Srs Refresh Count Eul5 Sum Rfsh Sets.Srs Refresh CountSRS_REFRESH_COUNTSRS_REFRESH_COUNT101684
Srs Rfu Id Eul5 Sum Rfsh Sets.Srs Rfu IdSRS_RFU_IDSRS_RFU_ID101685
Srs State Eul5 Sum Rfsh Sets.Srs StateSRS_STATESRS_STATE101686
Srs Updated By Eul5 Sum Rfsh Sets.Srs Updated BySRS_UPDATED_BYSRS_UPDATED_BY101687
Srs Updated Date Eul5 Sum Rfsh Sets.Srs Updated DateSRS_UPDATED_DATESRS_UPDATED_DATE101688
Srs User Prop1 Eul5 Sum Rfsh Sets.Srs User Prop1SRS_USER_PROP1SRS_USER_PROP1101689
Srs User Prop2 Eul5 Sum Rfsh Sets.Srs User Prop2SRS_USER_PROP2SRS_USER_PROP2101690
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Eul5 Sum Rfsh Sets.Srs Id -> Eul5 Summary Objs Copy.Sbo Srs IdEul5 Sum Rfsh Sets.Srs Id = Eul5 Summary Objs Copy.Sbo Srs IdMight not exist in master folderNoneYes
Eul5 Sum Rfsh Sets.Srs Job Id -> EUL5 User Jobs.JobEul5 Sum Rfsh Sets.Srs Job Id = EUL5 User Jobs.JobAlways exist in master folderOuter join on detail One to one joinYes
Eul5 Sum Rfsh Sets.Srs Id -> Eul5 Summary Objs.Sbo Srs IdEul5 Sum Rfsh Sets.Srs Id = Eul5 Summary Objs.Sbo Srs IdMight not exist in master folderNoneYes
Eul5 Summary Objs
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
EUL5 Existing Summary Combos , EUL5 Summary Folders, EUL5 Summary Mappings, EUL5 Users QueriesNoneSYSTEM.EUL5_SUMMARY_OBJS25-OCT-2006
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Ems Commit Size Eul5 Summary Objs.Ems Commit SizeEMS_COMMIT_SIZEEMS_COMMIT_SIZE101123
Ems State Eul5 Summary Objs.Ems StateEMS_STATEEMS_STATE101125
Msdo Refresh Reqd Eul5 Summary Objs.Msdo Refresh ReqdMSDO_REFRESH_REQDMSDO_REFRESH_REQD101373
Msdo Svr Err Code Eul5 Summary Objs.Msdo Svr Err CodeMSDO_SVR_ERR_CODEMSDO_SVR_ERR_CODE101375
Msdo Svr Err Text Eul5 Summary Objs.Msdo Svr Err TextMSDO_SVR_ERR_TEXTMSDO_SVR_ERR_TEXT101377
Notm Eul5 Summary Objs.NotmNOTMNOTM101426
Sbo Max Item Comb Eul5 Summary Objs.Sbo Max Item CombSBO_MAX_ITEM_COMBSBO_MAX_ITEM_COMB101561
Sbo Srs Id Eul5 Summary Objs.Sbo Srs IdSBO_SRS_IDSBO_SRS_ID101563
Sdo Bitmap Pos Eul5 Summary Objs.Sdo Bitmap PosSDO_BITMAP_POSSDO_BITMAP_POS101577
Sdo Database Link Eul5 Summary Objs.Sdo Database LinkSDO_DATABASE_LINKSDO_DATABASE_LINK101579
Sdo Last Refresh Eul5 Summary Objs.Sdo Last RefreshSDO_LAST_REFRESHSDO_LAST_REFRESH101581
Sdo Num Axis Items Eul5 Summary Objs.Sdo Num Axis ItemsSDO_NUM_AXIS_ITEMSSDO_NUM_AXIS_ITEMS101583
Sdo Num Joins Eul5 Summary Objs.Sdo Num JoinsSDO_NUM_JOINSSDO_NUM_JOINS101585
Sdo Num Rows Eul5 Summary Objs.Sdo Num RowsSDO_NUM_ROWSSDO_NUM_ROWS101587
Sdo Num Usgs Eul5 Summary Objs.Sdo Num UsgsSDO_NUM_USGSSDO_NUM_USGS101589
Sdo Object Sql1 Eul5 Summary Objs.Sdo Object Sql1SDO_OBJECT_SQL1SDO_OBJECT_SQL1101591
Sdo Object Sql2 Eul5 Summary Objs.Sdo Object Sql2SDO_OBJECT_SQL2SDO_OBJECT_SQL2101593
Sdo Object Sql3 Eul5 Summary Objs.Sdo Object Sql3SDO_OBJECT_SQL3SDO_OBJECT_SQL3101595
Sdo Sbo Id Eul5 Summary Objs.Sdo Sbo IdSDO_SBO_IDSDO_SBO_ID101597
Sdo Table Name Eul5 Summary Objs.Sdo Table NameSDO_TABLE_NAMESDO_TABLE_NAME101599
Sdo Table Owner Eul5 Summary Objs.Sdo Table OwnerSDO_TABLE_OWNERSDO_TABLE_OWNER101601
Sumo Active Eul5 Summary Objs.Sumo ActiveSUMO_ACTIVESUMO_ACTIVE101694
Sumo Asmp Id Eul5 Summary Objs.Sumo Asmp IdSUMO_ASMP_IDSUMO_ASMP_ID101696
Sumo Created By Eul5 Summary Objs.Sumo Created BySUMO_CREATED_BYSUMO_CREATED_BY101698
Sumo Created Date Eul5 Summary Objs.Sumo Created DateSUMO_CREATED_DATESUMO_CREATED_DATE101700
Sumo Element State Eul5 Summary Objs.Sumo Element StateSUMO_ELEMENT_STATESUMO_ELEMENT_STATE101702
Sumo Ext Db Link Eul5 Summary Objs.Sumo Ext Db LinkSUMO_EXT_DB_LINKSUMO_EXT_DB_LINK101704
Sumo Ext Object Eul5 Summary Objs.Sumo Ext ObjectSUMO_EXT_OBJECTSUMO_EXT_OBJECT101706
Sumo Ext Owner Eul5 Summary Objs.Sumo Ext OwnerSUMO_EXT_OWNERSUMO_EXT_OWNER101708
Sumo Id Eul5 Summary Objs.Sumo IdSUMO_IDSUMO_ID101710
Sumo Internal Eul5 Summary Objs.Sumo InternalSUMO_INTERNALSUMO_INTERNAL101712
Sumo Item Deleted Eul5 Summary Objs.Sumo Item DeletedSUMO_ITEM_DELETEDSUMO_ITEM_DELETED101714
Sumo Item Modified Eul5 Summary Objs.Sumo Item ModifiedSUMO_ITEM_MODIFIEDSUMO_ITEM_MODIFIED101716
Sumo Join State Eul5 Summary Objs.Sumo Join StateSUMO_JOIN_STATESUMO_JOIN_STATE101718
Sumo Type Eul5 Summary Objs.Sumo TypeSUMO_TYPESUMO_TYPE101720
Sumo Updated By Eul5 Summary Objs.Sumo Updated BySUMO_UPDATED_BYSUMO_UPDATED_BY101722
Sumo Updated Date Eul5 Summary Objs.Sumo Updated DateSUMO_UPDATED_DATESUMO_UPDATED_DATE101724
Sumo Validity Eul5 Summary Objs.Sumo ValiditySUMO_VALIDITYSUMO_VALIDITY101726
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Eul5 Summary Objs.Sumo Id -> Eul5 Asmp Logs.Apl Sumo IdEul5 Summary Objs.Sumo Id = Eul5 Asmp Logs.Apl Sumo IdAlways exist in master folderNoneYes
Eul5 Summary Objs.Sumo Id -> Eul5 Asmp Cons.Asoc Sumo IdEul5 Summary Objs.Sumo Id = Eul5 Asmp Cons.Asoc Sumo IdAlways exist in master folderNoneYes
Eul5 Summary Objs.Sumo Id -> Eul5 Sumo Exp Usgs.Seu Sumo IdEul5 Summary Objs.Sumo Id = Eul5 Sumo Exp Usgs.Seu Sumo IdAlways exist in master folderNoneYes
Eul5 Summary Objs.Sumo Id -> Eul5 Qpp Stats.Sdo IdEul5 Summary Objs.Sumo Id = Eul5 Qpp Stats.Sdo IdMight not exist in master folderOuter join on master Yes
Eul5 Summary Objs.Sumo Id -> Eul5 Segments.Seg Sumo IdEul5 Summary Objs.Sumo Id = Eul5 Segments.Seg Sumo IdAlways exist in master folderNoneYes
Eul5 Summary Objs.Sumo Id -> Eul5 Segments.Seg Sms IdEul5 Summary Objs.Sumo Id = Eul5 Segments.Seg Sms IdAlways exist in master folderNoneYes
Eul5 Summary Objs.Sumo Id -> Eul5 Obj Join Usgs.Oju Sumo IdEul5 Summary Objs.Sumo Id = Eul5 Obj Join Usgs.Oju Sumo IdAlways exist in master folderNoneYes
Eul5 Summary Objs Copy
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
EUL5 Users QueriesNoneSYSTEM.EUL5_SUMMARY_OBJS25-OCT-2006
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Ems Commit Size Eul5 Summary Objs Copy.Ems Commit SizeEMS_COMMIT_SIZEEMS_COMMIT_SIZE101124
Ems State Eul5 Summary Objs Copy.Ems StateEMS_STATEEMS_STATE101126
Msdo Refresh Reqd Eul5 Summary Objs Copy.Msdo Refresh ReqdMSDO_REFRESH_REQDMSDO_REFRESH_REQD101374
Msdo Svr Err Code Eul5 Summary Objs Copy.Msdo Svr Err CodeMSDO_SVR_ERR_CODEMSDO_SVR_ERR_CODE101376
Msdo Svr Err Text Eul5 Summary Objs Copy.Msdo Svr Err TextMSDO_SVR_ERR_TEXTMSDO_SVR_ERR_TEXT101378
Notm Eul5 Summary Objs Copy.NotmNOTMNOTM101427
Sbo Max Item Comb Eul5 Summary Objs Copy.Sbo Max Item CombSBO_MAX_ITEM_COMBSBO_MAX_ITEM_COMB101562
Sbo Srs Id Eul5 Summary Objs Copy.Sbo Srs IdSBO_SRS_IDSBO_SRS_ID101564
Sdo Bitmap Pos Eul5 Summary Objs Copy.Sdo Bitmap PosSDO_BITMAP_POSSDO_BITMAP_POS101578
Sdo Database Link Eul5 Summary Objs Copy.Sdo Database LinkSDO_DATABASE_LINKSDO_DATABASE_LINK101580
Sdo Last Refresh Eul5 Summary Objs Copy.Sdo Last RefreshSDO_LAST_REFRESHSDO_LAST_REFRESH101582
Sdo Num Axis Items Eul5 Summary Objs Copy.Sdo Num Axis ItemsSDO_NUM_AXIS_ITEMSSDO_NUM_AXIS_ITEMS101584
Sdo Num Joins Eul5 Summary Objs Copy.Sdo Num JoinsSDO_NUM_JOINSSDO_NUM_JOINS101586
Sdo Num Rows Eul5 Summary Objs Copy.Sdo Num RowsSDO_NUM_ROWSSDO_NUM_ROWS101588
Sdo Num Usgs Eul5 Summary Objs Copy.Sdo Num UsgsSDO_NUM_USGSSDO_NUM_USGS101590
Sdo Object Sql1 Eul5 Summary Objs Copy.Sdo Object Sql1SDO_OBJECT_SQL1SDO_OBJECT_SQL1101592
Sdo Object Sql2 Eul5 Summary Objs Copy.Sdo Object Sql2SDO_OBJECT_SQL2SDO_OBJECT_SQL2101594
Sdo Object Sql3 Eul5 Summary Objs Copy.Sdo Object Sql3SDO_OBJECT_SQL3SDO_OBJECT_SQL3101596
Sdo Sbo Id Eul5 Summary Objs Copy.Sdo Sbo IdSDO_SBO_IDSDO_SBO_ID101598
Sdo Table Name Eul5 Summary Objs Copy.Sdo Table NameSDO_TABLE_NAMESDO_TABLE_NAME101600
Sdo Table Owner Eul5 Summary Objs Copy.Sdo Table OwnerSDO_TABLE_OWNERSDO_TABLE_OWNER101602
Sumo Active Eul5 Summary Objs Copy.Sumo ActiveSUMO_ACTIVESUMO_ACTIVE101695
Sumo Asmp Id Eul5 Summary Objs Copy.Sumo Asmp IdSUMO_ASMP_IDSUMO_ASMP_ID101697
Sumo Created By Eul5 Summary Objs Copy.Sumo Created BySUMO_CREATED_BYSUMO_CREATED_BY101699
Sumo Created Date Eul5 Summary Objs Copy.Sumo Created DateSUMO_CREATED_DATESUMO_CREATED_DATE101701
Sumo Element State Eul5 Summary Objs Copy.Sumo Element StateSUMO_ELEMENT_STATESUMO_ELEMENT_STATE101703
Sumo Ext Db Link Eul5 Summary Objs Copy.Sumo Ext Db LinkSUMO_EXT_DB_LINKSUMO_EXT_DB_LINK101705
Sumo Ext Object Eul5 Summary Objs Copy.Sumo Ext ObjectSUMO_EXT_OBJECTSUMO_EXT_OBJECT101707
Sumo Ext Owner Eul5 Summary Objs Copy.Sumo Ext OwnerSUMO_EXT_OWNERSUMO_EXT_OWNER101709
Sumo Id Eul5 Summary Objs Copy.Sumo IdSUMO_IDSUMO_ID101711
Sumo Internal Eul5 Summary Objs Copy.Sumo InternalSUMO_INTERNALSUMO_INTERNAL101713
Sumo Item Deleted Eul5 Summary Objs Copy.Sumo Item DeletedSUMO_ITEM_DELETEDSUMO_ITEM_DELETED101715
Sumo Item Modified Eul5 Summary Objs Copy.Sumo Item ModifiedSUMO_ITEM_MODIFIEDSUMO_ITEM_MODIFIED101717
Sumo Join State Eul5 Summary Objs Copy.Sumo Join StateSUMO_JOIN_STATESUMO_JOIN_STATE101719
Sumo Type Eul5 Summary Objs Copy.Sumo TypeSUMO_TYPESUMO_TYPE101721
Sumo Updated By Eul5 Summary Objs Copy.Sumo Updated BySUMO_UPDATED_BYSUMO_UPDATED_BY101723
Sumo Updated Date Eul5 Summary Objs Copy.Sumo Updated DateSUMO_UPDATED_DATESUMO_UPDATED_DATE101725
Sumo Validity Eul5 Summary Objs Copy.Sumo ValiditySUMO_VALIDITYSUMO_VALIDITY101727
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Eul5 Summary Objs Copy.Sumo Id -> Eul5 Sumo Exp Usgs.Seu Sumo IdEul5 Summary Objs Copy.Sumo Id = Eul5 Sumo Exp Usgs.Seu Sumo IdAlways exist in master folderNoneYes
Eul5 Summary Objs Copy.Sumo Id -> Eul5 Segments.Seg Sms IdEul5 Summary Objs Copy.Sumo Id = Eul5 Segments.Seg Sms IdAlways exist in master folderNoneYes
Eul5 Summary Objs Copy.Sumo Id -> Eul5 Asmp Logs.Apl Sumo IdEul5 Summary Objs Copy.Sumo Id = Eul5 Asmp Logs.Apl Sumo IdAlways exist in master folderNoneYes
Eul5 Summary Objs Copy.Sumo Id -> Eul5 Obj Join Usgs.Oju Sumo IdEul5 Summary Objs Copy.Sumo Id = Eul5 Obj Join Usgs.Oju Sumo IdAlways exist in master folderNoneYes
Eul5 Summary Objs Copy.Sumo Id -> Eul5 Segments.Seg Sumo IdEul5 Summary Objs Copy.Sumo Id = Eul5 Segments.Seg Sumo IdAlways exist in master folderNoneYes
Eul5 Summary Objs Copy.Sumo Id -> Eul5 Summary Objs.Sdo Sbo IdEul5 Summary Objs Copy.Sumo Id = Eul5 Summary Objs.Sdo Sbo IdMight not exist in master folderOuter join on master Yes
Eul5 Summary Objs Copy.Sumo Id -> Eul5 Asmp Cons.Asoc Sumo IdEul5 Summary Objs Copy.Sumo Id = Eul5 Asmp Cons.Asoc Sumo IdAlways exist in master folderNoneYes
Eul5 Sumo Exp Usgs
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
EUL5 Summary MappingsNoneSYSTEM.EUL5_SUMO_EXP_USGS25-OCT-2006
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Notm Eul5 Sumo Exp Usgs.NotmNOTMNOTM101428
Seu Created By Eul5 Sumo Exp Usgs.Seu Created BySEU_CREATED_BYSEU_CREATED_BY101628
Seu Created Date Eul5 Sumo Exp Usgs.Seu Created DateSEU_CREATED_DATESEU_CREATED_DATE101629
Seu Element State Eul5 Sumo Exp Usgs.Seu Element StateSEU_ELEMENT_STATESEU_ELEMENT_STATE101630
Seu Ext Column Eul5 Sumo Exp Usgs.Seu Ext ColumnSEU_EXT_COLUMNSEU_EXT_COLUMN101631
Seu Id Eul5 Sumo Exp Usgs.Seu IdSEU_IDSEU_ID101632
Seu Sumo Id Eul5 Sumo Exp Usgs.Seu Sumo IdSEU_SUMO_IDSEU_SUMO_ID101633
Seu Type Eul5 Sumo Exp Usgs.Seu TypeSEU_TYPESEU_TYPE101634
Seu Updated By Eul5 Sumo Exp Usgs.Seu Updated BySEU_UPDATED_BYSEU_UPDATED_BY101635
Seu Updated Date Eul5 Sumo Exp Usgs.Seu Updated DateSEU_UPDATED_DATESEU_UPDATED_DATE101636
Seu Visible Eul5 Sumo Exp Usgs.Seu VisibleSEU_VISIBLESEU_VISIBLE101637
Sfu Fun Id Eul5 Sumo Exp Usgs.Sfu Fun IdSFU_FUN_IDSFU_FUN_ID101638
Siu Exp Id Eul5 Sumo Exp Usgs.Siu Exp IdSIU_EXP_IDSIU_EXP_ID101640
Siu Item Modified Eul5 Sumo Exp Usgs.Siu Item ModifiedSIU_ITEM_MODIFIEDSIU_ITEM_MODIFIED101641
Smiu Fun Id Eul5 Sumo Exp Usgs.Smiu Fun IdSMIU_FUN_IDSMIU_FUN_ID101642
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Eul5 Versions
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNoneSYSTEM.EUL5_VERSIONS25-OCT-2006
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Description Eul5 Versions.DescriptionVER_DESCRIPTIONVER_DESCRIPTION101741
Eul Timestamp Eul5 Versions.Eul TimestampVER_EUL_TIMESTAMPVER_EUL_TIMESTAMP101742
Min Code Ver Eul5 Versions.Min Code VerVER_MIN_CODE_VERVER_MIN_CODE_VER101743
Name Eul5 Versions.NameVER_NAMEVER_NAME101744
Release Eul5 Versions.ReleaseVER_RELEASEVER_RELEASE101745
Sa Eul5 Versions.SaVER_SAVER_SA101746
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Eul5 Worksheet Sql
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNoneSYSTEM.EUL5_WORKSHEET_SQL25-OCT-2006
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Query Name Eul5 Worksheet Sql.Workbook Owner Eul5 Worksheet Sql.Workbook Name Eul5 Worksheet Sql.Worksheet Name QUERY_NAME102426
Seg Sequence Eul5 Worksheet Sql.Seg SequenceSEG_SEQUENCESEG_SEQUENCE101620
Sql Segment Eul5 Worksheet Sql.Sql SegmentSQL_SEGMENTSQL_SEGMENT101655
Total Number of Worksheets Eul5 Worksheet Sql.Workbook Owner Eul5 Worksheet Sql.Workbook Name Eul5 Worksheet Sql.Worksheet Name TOTAL_NUMBER_OF_WORKSHEETS102557
Workbook Name Eul5 Worksheet Sql.Workbook NameWORKBOOK_NAMEWORKBOOK_NAME101748
Workbook Owner Eul5 Worksheet Sql.Workbook OwnerWORKBOOK_OWNERWORKBOOK_OWNER101749
Worksheet Name Eul5 Worksheet Sql.Worksheet NameWORKSHEET_NAMEWORKSHEET_NAME101750
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Eul5 Worksheet Sql -> EUL5 Users QueriesEul5 Worksheet Sql.Workbook Owner = EUL5 Users Queries.Workbook Owner Eul5 Worksheet Sql.Workbook Name = EUL5 Users Queries.Workbook Name Eul5 Worksheet Sql.Worksheet Name = EUL5 Users Queries.Worksheet NameMight not exist in master folderNoneNo
Folder Filters
Used In ConditionItemBa NameBase ObjectFilter NameFilter TypeFolder Name
Doc Content TypeThe Discoverer V5 EULSYSTEM.EUL5_DOCUMENTS.DOC_CONTENT_TYPEDoc Content Type = 'application/vnd.oracle-disco.wb'MandatoryEul5 Documents
App IdThe Discoverer V5 EULSYSTEM.EUL5_APP_PARAMS.APP_IDApp Id <> 1018MandatoryEUL5 Privileges
Gba Ba IdThe Discoverer V5 EULSYSTEM.EUL5_ACCESS_PRIVS.GBA_BA_IDGba Ba Id IS NULL MandatoryEUL5 Privileges
Gba Ba IdThe Discoverer V5 EULSYSTEM.EUL5_ACCESS_PRIVS.GBA_BA_IDGba Ba Id IS NOT NULL MandatoryEUL5 Security
Doc Content TypeThe Discoverer V5 EULSYSTEM.EUL5_DOCUMENTS.DOC_CONTENT_TYPEDoc Content Type = 'application/vnd.oracle-disco.wb'MandatoryEUL5 Workbook Management
Hierarchies
Hierarchy NameCreated ByHierarchy LevelHierarchy Details
EUL5 Ad-Hoc WorkbooksUser1EUL5 Users Queries.Workbook Name
EUL5 Ad-Hoc WorkbooksUser2 ^------EUL5 Users Queries.Usernames
EUL5 Ad-Hoc WorkbooksUser3 ^------EUL5 Users Queries.Worksheet Name
EUL5 Conditions DrillUser1EUL5 Conditions.Folder Name
EUL5 Conditions DrillUser2 ^------EUL5 Conditions.Database Object
EUL5 DocumentsUser1EUL5 Workbook Management.Document Name
EUL5 DocumentsUser2 ^------EUL5 Workbook Management.Document Description
EUL5 DocumentsUser3 ^------EUL5 Workbook Management.Document Updated By
EUL5 DocumentsUser4 ^------EUL5 Workbook Management.Document Updated Date
EUL5 DocumentsUser5 ^------EUL5 Workbook Management.Doc Developer Key
EUL5 Folders & Business Areas to ItemsUser1EUL5 Business Areas & Folders.Folder Name
EUL5 Folders & Business Areas to ItemsUser2 ^------EUL5 Folders & Items.Folder Name
EUL5 Folders & Business Areas to ItemsUser3 ^------EUL5 Folders & Items.Database Column
EUL5 Folders to TablesUser1EUL5 Folders & Items.Folder Name
EUL5 Folders to TablesUser2 ^------EUL5 Business Areas & Folders.Table Components
EUL5 PrivilegeUser1EUL5 Privileges.Username
EUL5 PrivilegeUser2 ^------EUL5 Privileges.User Type
EUL5 Queries by User DrillUser1EUL5 Users Queries.Usernames
EUL5 Queries by User DrillUser2 ^------EUL5 Users Queries.Folders Queried
EUL5 Queries by User DrillUser3 ^------EUL5 Users Queries.Items Queried
EUL5 Queries by User DrillUser4 ^------EUL5 Users Queries.Summary Name
EUL5 SecurityUser1EUL5 Security.Username
EUL5 SecurityUser2 ^------EUL5 Security.User Type
EUL5 Users QueriesUser1EUL5 Users Queries.Usernames
EUL5 Users QueriesUser2 ^------EUL5 Users Queries.Workbook Name
EUL5 Users QueriesUser3 ^------EUL5 Users Queries.Workbook Owner
EUL5 Users QueriesUser4 ^------EUL5 Users Queries.Worksheet Name
EUL5 Users QueriesUser5 ^------EUL5 Users Queries.Folders Queried
EUL5 Users QueriesUser6 ^------EUL5 Users Queries.Items Queried
EUL5 Users QueriesUser7 ^------EUL5 Users Queries.Summary Name
EUL5 Users QueriesUser8 ^------EUL5 Workbook Management.Document Size (KB)
EUL5 Users QueriesUser9 ^------EUL5 Workbook Management.Doc Developer Key
EUL5 Users Queries & SummariesUser1EUL5 Users Queries.Summary Name
EUL5 Users Queries & SummariesUser2 ^------EUL5 Users Queries.Folders Queried
EUL5 Users Queries & SummariesUser3 ^------EUL5 Users Queries.Items Queried
EUL5 Users Queries & SummariesUser4 ^------EUL5 Users Queries.Date Stamp
EUL5 Users Queries & SummariesUser5 ^------EUL5 Users Queries.Usernames
EUL5 Users Queries Date DrillUser1EUL5 Users Queries.Date Stamp Year
EUL5 Users Queries Date DrillUser2 ^------EUL5 Users Queries.Date Stamp Quarter
EUL5 Users Queries Date DrillUser3 ^------EUL5 Users Queries.Date Stamp Month
Item Classes
Item Class NamePrimary FolderUsed ByAlternate Sort
EUL5 Business Areas & Folders.Business Area NameEUL5 Business Areas & Folders . Business Area NameEUL5 Business Areas & Folders . Business Area Name.
EUL5 Business Areas & Folders.Folder DB Object NameEUL5 Business Areas & Folders . Folder DB Object NameEUL5 Business Areas & Folders . Folder DB Object Name.
EUL5 Business Areas & Folders.Folder HiddenEUL5 Business Areas & Folders . Folder HiddenEUL5 Business Areas & Folders . Folder Hidden.
EUL5 Business Areas & Folders.Folder NameEUL5 Business Areas & Folders . Folder NameEUL5 Alternate Sorts . Obj Name.
EUL5 Business Areas & Folders.Folder NameEUL5 Business Areas & Folders . Folder NameEUL5 Business Areas & Folders . Folder Name.
EUL5 Business Areas & Folders.Folder NameEUL5 Business Areas & Folders . Folder NameEUL5 Conditions . Folder Name.
EUL5 Business Areas & Folders.Folder NameEUL5 Business Areas & Folders . Folder NameEUL5 Folders & Items . Folder Name.
EUL5 Business Areas & Folders.Folder NameEUL5 Business Areas & Folders . Folder NameEUL5 Item Class Used By . Obj Name.
EUL5 Business Areas & Folders.Folder NameEUL5 Business Areas & Folders . Folder NameEUL5 Item Classes . Alternate Sort Folder.
EUL5 Business Areas & Folders.Folder NameEUL5 Business Areas & Folders . Folder NameEUL5 Item Classes . Folder Name.
EUL5 Business Areas & Folders.Folder NameEUL5 Business Areas & Folders . Folder NameEUL5 Item Classes . Primary Folder.
EUL5 Business Areas & Folders.Folder NameEUL5 Business Areas & Folders . Folder NameEUL5 Summary Mappings . Obj Name.
EUL5 Business Areas & Folders.Folder NameEUL5 Business Areas & Folders . Folder NameEul5 Objs . Obj Name.
EUL5 Business Areas & Folders.Folder Object Db LinkEUL5 Business Areas & Folders . Folder Object Db LinkEUL5 Business Areas & Folders . Folder Object Db Link.
EUL5 Business Areas & Folders.Folder Object OwnerEUL5 Business Areas & Folders . Folder Object OwnerEUL5 Business Areas & Folders . Folder Object Owner.
EUL5 Business Areas & Folders.Folder TypeEUL5 Business Areas & Folders . Folder TypeEUL5 Business Areas & Folders . Folder Type.
EUL5 Folders & Items.Actual Item NameEUL5 Folders & Items . Actual Item NameEUL5 Folders & Items . Actual Item Name.
EUL5 Folders & Items.Item Data TypeEUL5 Folders & Items . Item Data TypeEUL5 Folders & Items . Item Data Type.
EUL5 Folders & Items.Item External ColumnEUL5 Folders & Items . Item External ColumnEUL5 Folders & Items . Item External Column.
EUL5 Folders & Items.Item HiddenEUL5 Folders & Items . Item HiddenEUL5 Folders & Items . Item Hidden.
EUL5 Folders & Items.Item NameEUL5 Folders & Items . Item NameEUL5 Folders & Items . Item Name.
EUL5 Hierarchy.Actual Item NameEUL5 Hierarchy . Actual Item NameEUL5 Hierarchy . Actual Item Name.
EUL5 Hierarchy.Item NameEUL5 Hierarchy . Item NameEUL5 Hierarchy . Item Name.
Security
Administration AllowedUser Role Responsibility
YesSYSTEM
Summaries
Summary Set NameOwnerTable NameTable ColumnMap ToFolder NameAggregationItem Name
Workbook Info
Workbook NameCreated BySize [kb]Creation DateDoc Developer KeyDoc Id
Analytic Function ExamplesSYSTEM9925-Oct-2006ANALYTIC_FUNCTION_EXAMPLES100455
EUL AccessSYSTEM6325-Oct-2006EUL5_ACCESS103289
EUL Data DefinitionSYSTEM13225-Oct-2006EUL_DATA_DEFINITION103290
EUL Query StatisticsSYSTEM14225-Oct-2006QUERY_STATISTICS103292
EUL Workbook ManagementSYSTEM10025-Oct-2006WORKBOOK_MANAGMENT1103293
LineageSYSTEM2125-Oct-2006LINEAGE103291
Lineage 1SYSTEM1725-Oct-2006LINEAGE1103294
New Features ExamplesSYSTEM3425-Oct-2006NEW_FEATURES_EXAMPLES100456
Video Tutorial WorkbookSYSTEM2425-Oct-2006VIDEO_TUTORIAL_WORKBOOK100457
Analytic Function Examples
Workbook Dependencies
Dependency TypeFolderDependency NameFolder KeyDependency Key
JoinSales FactsStore.Store Key -> Sales Facts.Store KeyDC_SALES_FACTSTORE_SALES_FACTS
JoinSales FactsCalendar Date.Time Key -> Sales Facts.Time KeyDC_SALES_FACTCALENDAR_DATE_SALES_FACTS
JoinSales FactsProducts.Product Key -> Sales Facts.Product KeyDC_SALES_FACTPRODUCTS_SALES_FACTS
ItemCalendar DateCalendar YearDC_CALENDAR_DATETRANSACTION_DATE_YEAR
ItemCalendar DateCalendar MonthDC_CALENDAR_DATETRANSACTION_DATE_MONTH
ItemCalendar DateCalendar QuarterDC_CALENDAR_DATETRANSACTION_DATE_QUARTER
ItemProductsProduct CategoryDC_PRODUCTPRODUCT_CATEGORY
ItemProductsProduct TypeDC_PRODUCTPRODUCT_TYPE
ItemProductsProduct DescriptionDC_PRODUCTDESCRIPTION
ItemSales FactsSalesDC_SALES_FACTSALES
ItemStoreRegionDC_STOREREGION
ItemStoreCityDC_STORECITY
Workbook Sharing Info
Shared WithShared With Date
>> PUBLIC25-Oct-2006
EUL Access
Workbook Dependencies
Dependency TypeFolderDependency NameFolder KeyDependency Key
Workbook Sharing Info
Shared WithShared With Date
>> PUBLIC25-Oct-2006
EUL Data Definition
Workbook Dependencies
Dependency TypeFolderDependency NameFolder KeyDependency Key
Workbook Sharing Info
Shared WithShared With Date
>> Document Not Shared
EUL Query Statistics
Workbook Dependencies
Dependency TypeFolderDependency NameFolder KeyDependency Key
Workbook Sharing Info
Shared WithShared With Date
>> Document Not Shared
EUL Workbook Management
Workbook Dependencies
Dependency TypeFolderDependency NameFolder KeyDependency Key
Workbook Sharing Info
Shared WithShared With Date
>> Document Not Shared
Lineage
Workbook Dependencies
Dependency TypeFolderDependency NameFolder KeyDependency Key
Workbook Sharing Info
Shared WithShared With Date
>> PUBLIC25-Oct-2006
Lineage 1
Workbook Dependencies
Dependency TypeFolderDependency NameFolder KeyDependency Key
Workbook Sharing Info
Shared WithShared With Date
>> PUBLIC25-Oct-2006
New Features Examples
Workbook Dependencies
Dependency TypeFolderDependency NameFolder KeyDependency Key
JoinSales FactsCalendar Date.Time Key -> Sales Facts.Time KeyDC_SALES_FACTCALENDAR_DATE_SALES_FACTS
JoinSales FactsStore.Store Key -> Sales Facts.Store KeyDC_SALES_FACTSTORE_SALES_FACTS
ItemCalendar DateCalendar YearDC_CALENDAR_DATETRANSACTION_DATE_YEAR
ItemSales FactsSalesDC_SALES_FACTSALES
ItemSales FactsProfitDC_SALES_FACTPROFIT
ItemStoreRegionDC_STOREREGION
ItemStoreStore NameDC_STORESTORE_NAME
ItemVideo Analysis Information DC_VIDEO_ANALYSIS_INFORMATIONSALES
ItemVideo Analysis Information DC_VIDEO_ANALYSIS_INFORMATIONREGION
ItemVideo Analysis Information DC_VIDEO_ANALYSIS_INFORMATIONCALENDAR_YEAR
ItemVideo Analysis Information DC_VIDEO_ANALYSIS_INFORMATIONCALENDAR_QUARTER
ItemVideo Analysis Information DC_VIDEO_ANALYSIS_INFORMATIONPROFIT
Workbook Sharing Info
Shared WithShared With Date
>> PUBLIC25-Oct-2006
Video Tutorial Workbook
Workbook Dependencies
Dependency TypeFolderDependency NameFolder KeyDependency Key
ItemStoreRegionDC_STOREREGION
ItemStoreStore NameDC_STORESTORE_NAME
ItemVideo Analysis Information DC_VIDEO_ANALYSIS_INFORMATIONSALES
ItemVideo Analysis Information DC_VIDEO_ANALYSIS_INFORMATIONCALENDAR_YEAR
ItemVideo Analysis Information DC_VIDEO_ANALYSIS_INFORMATIONDEPARTMENT
ItemVideo Analysis Information DC_VIDEO_ANALYSIS_INFORMATIONREGION
ItemVideo Analysis Information DC_VIDEO_ANALYSIS_INFORMATIONPROFIT
ConditionVideo Analysis InformationDepartment is Video Rental or Video SaleDC_VIDEO_ANALYSIS_INFORMATIONDEPARTMENT_IS_VIDEO_RENTAL_OR_VIDEO_SALE
Workbook Sharing Info
Shared WithShared With Date
>> PUBLIC25-Oct-2006
Workbook Summary
Report NameWork SheetTable View UsedItems UsedTable Join UsedJoinsOjbkey
Analytic Function ExamplesRank of SalesRegionCalendar Date, Sales Facts, StoreCity, Region, Calendar Year, Sales SUMCalendar Date.Time Key -> Sales Facts.Time Key, Store.Store Key -> Sales Facts.Store Key100024.100027.100028
Analytic Function ExamplesTop N Bottom NCity, Region, Sales, Calendar YearCalendar Date, Products, Sales Facts, StoreCity, Product Description, Region, Calendar Year, Sales SUMCalendar Date.Time Key -> Sales Facts.Time Key, Products.Product Key -> Sales Facts.Product Key, Store.Store Key -> Sales Facts.Store Key100024.100026.100027.100028
EUL AccessAccess Privileges Given On My ObjectsNoneEUL5 All Table PrivilegesGrantable, Grantee, Grantor, Owner, Privilege, Table NameNone100644
EUL AccessAccess Privileges On Other Users ObjectsNoneEUL5 Table Privileges ReceivedGrantable, Grantee, Grantor, Owner, Privilege, Table Name, UserNone100648
EUL AccessAccess to Database ObjectsNoneEUL5 All Objects, EUL5 All UsersObject Name, Object Type, Username, UserEUL5 All Users.Username -> EUL5 All Objects.Owner100642.100646
EUL Data DefinitionBusiness Areas & FoldersNoneEUL5 Business Areas & FoldersBusiness Area Name, Folder Hidden, Folder Type, Date Table Last Analyzed, Folder Name, Table ComponentsNone100627
EUL Data DefinitionConditionsNoneEul5 Expressions, EUL5 Business Areas & Folders, EUL5 ConditionsBusiness Area Name, Actual Condition Name, Mandatory/Optional, Folder NameEUL5 Business Areas & Folders.Folder Id -> EUL5 Conditions.Obj Id, EUL5 Conditions.Ped Exp Id -> Eul5 Expressions.Exp Id100592.100627.100628
EUL Data DefinitionConditionsNoneEul5 Expressions, EUL5 Business Areas & Folders, EUL5 ConditionsBusiness Area Name, Database Object, Actual Condition Name, Mandatory/Optional, Folder NameEUL5 Business Areas & Folders.Folder Id -> EUL5 Conditions.Obj Id, EUL5 Conditions.Ped Exp Id -> Eul5 Expressions.Exp Id100592.100627.100628
EUL Data DefinitionEnd User Layer (EUL) - VersionNoneEul5 VersionsReleaseNone100624
EUL Data DefinitionFolders & ItemsNoneEUL5 Business Areas & Folders, EUL5 Folders & ItemsBusiness Area Name, Folder Hidden, Folder Name, Folder Type, Item Dependency, Item Name, AutoGenEUL5 Business Areas & Folders.Folder Id -> EUL5 Folders & Items.Folder Id100627.100630
EUL Data DefinitionHierarchiesNoneEUL5 Business Areas & Folders, EUL5 HierarchyBusiness Area Name, Hierarchy Name, AutoGen, Generation, AutoGen Hierarchy Node, Hierarchy Item, OrderEUL5 Business Areas & Folders.Folder Id -> EUL5 Folders & Items.Folder Id, EUL5 Folders & Items.Item Id -> EUL5 Hierarchy.Hil Exp Id100627.100631
EUL Data DefinitionItem ClassesNoneEUL5 Business Areas & Folders, EUL5 Item ClassesItem Name, Alternate Sort Item, Business Area Name, AutoGen, Primary Item, Alternate Sort Folder, Folder Name, Primary Folder, Item Class NameEUL5 Business Areas & Folders.Folder Id -> EUL5 Folders & Items.Folder Id, EUL5 Folders & Items.Item Id -> EUL5 Item Classes.Exp Id100627.100632
EUL Data DefinitionJoinsNoneEUL5 Business Areas & Folders, EUL5 JoinsBusiness Area Name, Join Details - Detail Item values:, Join Master --> Detail, AutoGen, Join Name, Optional Join ConfigurationsEUL5 Business Areas & Folders.Folder Id -> EUL5 Joins.Master Folder Id100627.100635
EUL Data DefinitionJoinsNoneEUL5 Business Areas & Folders, EUL5 JoinsJoin Details - Detail Item values:, Join Master --> Detail, AutoGen, Join Name, Folder Name, Optional Join ConfigurationsEUL5 Business Areas & Folders.Folder Id -> EUL5 Joins.Master Folder Id100627.100635
EUL Data DefinitionPrivilegesNoneEUL5 PrivilegesPrivilege, Privilege Description, Privilege Sequence, UsernameNone100636
EUL Data DefinitionSecurityNoneEUL5 Business Areas & Folders, EUL5 SecurityAdministration Allowed, Business Area Name, UsernameEUL5 Business Areas & Folders.Business Area Id -> EUL5 Security.Gba Ba Id100627.100637
EUL Data DefinitionSummary MappingSummary Set NameEul5 Functions, EUL5 Business Areas & Folders, EUL5 Summary MappingsAuto Generated Exp Name, Business Area Name, Obj Name, Seu Ext Column, Summary Set Name, Available for use in queries, Table Name, Table OwnerEUL5 Business Areas & Folders.Folder Id -> EUL5 Summary Mappings.Obj Id, EUL5 Summary Mappings.Smiu Fun Id -> Eul5 Functions.Fun Id100595.100627.100639
EUL Query StatisticsAd-hoc & Pre-defined Queries by UserNoneEUL5 Users Queries, EUL5 Workbook ManagementDate Stamp Month, Date Stamp Year, No of Queries, UsernamesEUL5 Workbook Management.Document Name -> EUL5 Users Queries.Workbook Name100640.100641
EUL Query StatisticsAd-hoc & Pre-defined Queries by WorkbookNoneEUL5 Users Queries, EUL5 Workbook ManagementDate Stamp Month, Date Stamp Year, No of Queries, Workbook NameEUL5 Workbook Management.Document Name -> EUL5 Users Queries.Workbook Name100640.100641
EUL Query StatisticsAd-hoc & Pre-defined Queries that used a SummaryNoneEUL5 Users Queries, EUL5 Workbook ManagementDate Stamp Month, Date Stamp Year, No of Queries, Summary NameEUL5 Workbook Management.Document Name -> EUL5 Users Queries.Workbook Name100640.100641
EUL Query StatisticsAdvanced Query StatisticsNoneEUL5 Users Queries, EUL5 Workbook ManagementCondition Items, Date Stamp Month, Date Stamp Year, Date Worksheet Last Ran, Folders Queried, Items Queried, Join Name, Optimizer Cost, No of Queries, Query Status, Rows Retrieved, Summary Fit, Summary Name, Workbook Name, Worksheet NameEUL5 Workbook Management.Document Name -> EUL5 Users Queries.Workbook Name100640.100641
EUL Query StatisticsWorkbook Query StatisticsNoneEUL5 Users Queries, EUL5 Workbook ManagementDate Stamp Month, Date Stamp Year, Date Worksheet Last Ran, Folders Queried, Items Queried, No of Queries, Workbook Name, Worksheet NameEUL5 Workbook Management.Document Name -> EUL5 Users Queries.Workbook Name100640.100641
EUL Query StatisticsWorkbooks Queried by UserNoneEUL5 Users Queries, EUL5 Workbook ManagementDate Stamp Month, Date Stamp Year, Date Worksheet Last Ran, No of Queries, Usernames, Workbook Name, Worksheet NameEUL5 Workbook Management.Document Name -> EUL5 Users Queries.Workbook Name100640.100641
EUL Query StatisticsWorkbooks that used SummariesNoneEUL5 Users Queries, EUL5 Workbook ManagementDate Stamp Month, Date Stamp Year, Date Worksheet Last Ran, No of Queries, Summary Name, Workbook NameEUL5 Workbook Management.Document Name -> EUL5 Users Queries.Workbook Name100640.100641
EUL Workbook ManagementEnd User Layer (EUL) - VersionNoneEul5 VersionsReleaseNone100624
EUL Workbook ManagementWorkbook AccessNoneEUL5 Workbook ManagementDate Document Shared, Document Shared with, Document Created By, Date Document Created, Document Size (KB), Document NameNone100641
EUL Workbook ManagementWorkbook DependencyNoneEul5 Documents, Eul5 Elem XrefsDoc Developer Key, Doc Name, To Devkey, To Par Devkey, To Par Name, To NameEul5 Elem Xrefs.doc_id -> Eul5 Documents.Doc Id100588.100590
EUL Workbook ManagementWorkbook Dependency - Conditions LookupNoneEul5 Expressions, EUL5 Business Areas & Folders, EUL5 ConditionsBusiness Area Name, Condition Developer Key, Actual Condition Name, Mandatory/Optional, Folder NameEUL5 Business Areas & Folders.Folder Id -> EUL5 Conditions.Obj Id, EUL5 Conditions.Ped Exp Id -> Eul5 Expressions.Exp Id100592.100627.100628
EUL Workbook ManagementWorkbook Dependency - Folders & Items LookupNoneEUL5 Business Areas & Folders, EUL5 Folders & ItemsBusiness Area Name, Item Developer Key, Folder Developer Key, Folder Hidden, Folder Name, Folder Type, Item Hidden, Item NameEUL5 Business Areas & Folders.Folder Id -> EUL5 Folders & Items.Folder Id100627.100630
EUL Workbook ManagementWorkbook Dependency - Joins LookupNoneEUL5 Business Areas & Folders, EUL5 JoinsBusiness Area Name, Join Master --> Detail, Join Developer Key, Join Name, Folder NameEUL5 Business Areas & Folders.Folder Id -> EUL5 Joins.Master Folder Id100627.100635
EUL Workbook ManagementWorksheet SQL InspectorNoneEul5 Worksheet SqlSeg Sequence, Sql Segment, Workbook Name, Workbook Owner, Worksheet NameNone100625
New Features ExamplesConditional FormatsNoneVideo Analysis InformationRegion, Calendar Quarter, Calendar Year, Sales SUM, Profit SUMNone100032
New Features ExamplesParametersRegion, Store NameCalendar Date, Sales Facts, StoreRegion, Store Name, Calendar Year, Profit SUM, Sales SUMCalendar Date.Time Key -> Sales Facts.Time Key, Store.Store Key -> Sales Facts.Store Key100024.100027.100028
Workbook1Sheet 1NoneEUL5 Folders & ItemsItem Developer Key, Folder Description, Folder Developer Key, Folder Lineage, Folder Hidden, Folder Id, Folder Name, Item Alignment, Item Case Display, Item Case Storage, Item Created By, Item Created Date, Item Data Type, Item Description, Item External Column, Item Format Mask, Item Heading, Item Hidden, Item Id, Database Column, Item Dependency, Item Lineage, Actual Item Name, Item Name, AutoGen, Item Placement, Item Sequence, Item Updated By, Item Updated Date, Item User Default Format, Item Max Display Width, Parameter Multiple Values Allowed, Replace NULL withNone100630
Workbook1Sheet 1NoneEul5 Batch QueriesBq Bs Id, Bq Created By, Bq Created Date, Bq Element State, Bq Id, Bq Query Id, Bq Result Sql 1, Bq Result Sql 2, Bq Result Sql 3, Bq Result Sql 4, Bq Updated By, Bq Updated Date, NotmNone100579
Workbook10Sheet 1NoneEUL5 PrivilegesApp Description Mn, App Id, App Name Mn, App Type, Ap Eu Id, Ap Id, Ap Type, Eu Batch Cmt Sz, Eu Batch Expiry, Eu Batch Jobs Lmt, Eu Batch Qtime Lmt, Eu Batch Rep User, Eu Batch Wnd End, Eu Batch Wnd Start, Eu Query Est Lmt, Eu Query Time Lmt, Eu Role Flag, Eu Row Fetch Lmt, Eu Use Pub Privs, Gba Ba Id, Gp App Id, Privilege, Privilege Description, Privilege Sequence, Sp Default Value, Sp Value, User Type, UsernameNone100636
Workbook11Sheet 1NoneEUL5 Existing Summary Combos Broken, Job, Priv User, Sdo Last Refresh, Sdo Num Rows, Srs Auto Refresh, Srs Description, Srs Id, Srs Last Refresh, Srs Name, Srs Next Refresh, Srs Online, Srs State, Srs Type, Sumo Id, Sumo Internal, Sumo Join State, Sumo Type, Sumo Validity, Failures SUM, Total Time SUMNone100629
Workbook12Sheet 1NoneEUL5 Summary FoldersBatch Process Id, Database Link, No Of Rows, Table Name, Table Owner, Automatic Refresh, Last Refresh, Date Last Refresh, Summary Set Name, Date Next Refresh, Srs Online, Available for use in queries, Srs State, Refresh Date, Srs Type, Summary Status, Sumo Id, Internal, Failures SUM, Total Time SUMNone100638
Workbook13Sheet 1NoneEUL5 Workbook ManagementDoument Shared By, Date Document Shared, Document Shared with, Document Batch, Document Created By, Date Document Created, Document Description, Doc Developer Key, Doc Id, Document Size (KB), Document Name, Document Updated By, Document Updated DateNone100641
Workbook3Sheet 1NoneEul5 ObjsNotm, Obj Ba Id, Obj Cbo Hint, Obj Created By, Obj Created Date, Obj Description, Obj Developer Key, Obj Distinct Flag, Obj Element State, Obj Ext Db Link, Obj Ext Object, Obj Ext Owner, Obj Hidden, Obj Id, Obj Name, Obj Ndeterministic, Obj Object Sql1, Obj Object Sql2, Obj Object Sql3, Obj Type, Obj Updated By, Obj Updated Date, Obj User Prop1, Obj User Prop2, Sobj Ext TableNone100607
Workbook6Sheet 1NoneEUL5 Business Areas & FoldersBusiness Area Created By, Business Area Created Date, Business Area Description, Business Area Developer Key, Business Area Id, Business Area Name, Business Area Updated By, Business Area Updated Date, Folder Created By, Folder Created Date, Folder DB Object Name, Folder Developer Key, Folder Hidden, Folder Sequence, Folder Type, Folder Updated By, Folder Updated Date, Folder Description, Folder Object Db Link, Folder Object, Folder Object Owner, Folder Id, Date Table Last Analyzed, Folder Dependency, Folder Components, Folder Name, Table ComponentsNone100627
Workbook7Sheet 1NoneEUL5 Folders & ItemsItem Developer Key, Folder Description, Folder Developer Key, Folder Lineage, Folder Hidden, Folder Id, Folder Name, Item Alignment, Item Case Display, Item Case Storage, Item Created By, Item Created Date, Item Data Type, Item Description, Item External Column, Item Format Mask, Item Heading, Item Hidden, Item Id, Database Column, Item Dependency, Item Lineage, Actual Item Name, Item Name, AutoGen, Item Placement, Item Sequence, Item Updated By, Item Updated Date, Item User Default Format, Item Max Display Width, Parameter Multiple Values Allowed, Replace NULL withNone100630
Workbook8Sheet 1NoneEUL5 Users QueriesCondition Items, Date Stamp, Date Stamp Month, Date Stamp Quarter, Date Stamp Year, Date Worksheet Last Ran, Folders Queried, Items Queried, Join Ids, Join Name, Act Cpu Time, Act Elap Time, Optimizer Cost, Created By, Created Date, No of Queries, Num Rows, State, Query Status, Rows Retrieved, Summary Fit, Summary Name, Usernames, Workbook Name, Workbook Owner, Owner=User, Worksheet NameNone100640
Workbook8Sheet 1NoneEUL5 Users QueriesCondition Items, Date Stamp, Date Stamp Month, Date Stamp Quarter, Date Stamp Year, Date Worksheet Last Ran, Folders Queried, Items Queried, Join Ids, Join Name, Act Cpu Time, Act Elap Time, Optimizer Cost, Created By, Created Date, No of Queries, Num Rows, State, Query Status, Rows Retrieved, Summary Fit, Summary Name, Workbook Name, Workbook Owner, Owner=UserNone100640
Workbook9Sheet 1NoneEUL5 SecurityAp Priv Level, Administration Allowed, Ap Type, Eu Role Flag, Gba Ba Id, Username, User TypeNone100637
Privileges
User Role ResponsibilityPrivlegesPrivilege Description
PUBLICUser EditionAbility to use Oracle Discoverer User Edition
PUBLIC Create/Edit QueryAbility to create new worksheets or edit existing ones. Without this option, a user only has the ability to run predefined worksheets
PUBLIC Collect Query StatisticsDetermines if running queries in Oracle Discoverer will then collect performance statistics
PUBLIC Item DrillAbility to use item drills, drill to related items and drill from summary to detail items (hyperdrill) within Oracle Discoverer User Edition
PUBLIC Drill OutAbility to drill out to launch other applications from Oracle Discoverer User Edition
PUBLIC Grant WorkbookAbility to grant access to workbooks to other users
PUBLIC Save Workbooks to DatabaseAbility to save workbooks to the database
PUBLIC Create LinkAbility to create links in workbooks
PUBLICScheduled Workbooks Tab Run Queries OnlineScheduling Repository must be enabled to run queries offline. Ability to always run queries online. Without this option, the user can only schedule the workbook.
PUBLICUnknown PrivlegeUnknown Privlege
SYSTEMAdministrationAbility to use Oracle Discoverer Administration Edition
SYSTEM Format Business AreaAbility to edit only the formatting information in an existing business area
SYSTEM Create/Edit Business AreaAbility to create new business areas and edit existing ones
SYSTEM Create SummariesAbility to create summary tables
SYSTEM Set PrivilegeAbility to grant and revoke End User Layer (TM) privileges
SYSTEM Manage Scheduled WorkbooksAbility to maintain the scheduled workbooks of end-users
SYSTEMUser EditionAbility to use Oracle Discoverer User Edition
SYSTEM Create/Edit QueryAbility to create new worksheets or edit existing ones. Without this option, a user only has the ability to run predefined worksheets
SYSTEM Collect Query StatisticsDetermines if running queries in Oracle Discoverer will then collect performance statistics
SYSTEM Item DrillAbility to use item drills, drill to related items and drill from summary to detail items (hyperdrill) within Oracle Discoverer User Edition
SYSTEM Drill OutAbility to drill out to launch other applications from Oracle Discoverer User Edition
SYSTEM Grant WorkbookAbility to grant access to workbooks to other users
SYSTEM Schedule WorkbooksAbility to Create and Edit Shedule Workbooks
SYSTEM Save Workbooks to DatabaseAbility to save workbooks to the database
SYSTEMScheduled Workbooks Tab Run Queries OnlineScheduling Repository must be enabled to run queries offline. Ability to always run queries online. Without this option, the user can only schedule the workbook.
SYSTEMUnknown PrivlegeUnknown Privlege
VIDEO5AdministrationAbility to use Oracle Discoverer Administration Edition
VIDEO5 Format Business AreaAbility to edit only the formatting information in an existing business area
VIDEO5 Create/Edit Business AreaAbility to create new business areas and edit existing ones
VIDEO5 Create SummariesAbility to create summary tables
VIDEO5 Set PrivilegeAbility to grant and revoke End User Layer (TM) privileges
VIDEO5 Manage Scheduled WorkbooksAbility to maintain the scheduled workbooks of end-users
VIDEO5User EditionAbility to use Oracle Discoverer User Edition
VIDEO5 Create/Edit QueryAbility to create new worksheets or edit existing ones. Without this option, a user only has the ability to run predefined worksheets
VIDEO5 Collect Query StatisticsDetermines if running queries in Oracle Discoverer will then collect performance statistics
VIDEO5 Item DrillAbility to use item drills, drill to related items and drill from summary to detail items (hyperdrill) within Oracle Discoverer User Edition
VIDEO5 Drill OutAbility to drill out to launch other applications from Oracle Discoverer User Edition
VIDEO5 Grant WorkbookAbility to grant access to workbooks to other users
VIDEO5 Schedule WorkbooksAbility to Create and Edit Shedule Workbooks
VIDEO5 Save Workbooks to DatabaseAbility to save workbooks to the database
VIDEO5 Create LinkAbility to create links in workbooks
VIDEO5Scheduled Workbooks Tab Run Queries OnlineScheduling Repository must be enabled to run queries offline. Ability to always run queries online. Without this option, the user can only schedule the workbook.