I generally call them analysis but thank you for that explanation-I need to get a better understanding of that. I usually only work in the analysis area but we have been relying on another group to provide us with this type of report when we need to make updates based on existing fields in an analysis.

@Nathan CCC I thought the yellow were BIP reports? It is the other way around? Good to know-I MAY have been saying that wrong for 6 months now lol Either way THANK YOU!! I see where I was going wrong trying to string it all together. That last line was the magic bullet. I appreciate it.

@Praveen Kumar Akkala-Oracle is there a way to use something similar to the above sql to access subject areas folders that are a level down or two levels down for example a list of all OTBI reports that use Workforce Management - Person Real Time - Person - Person extra information - population ID