Hi.
NBI_RESOURCE_FACTS will give you some capacity datas.
In this example the monthly capacity of each resource (in days)
Hope it helps...
Fred
SELECT RF.RESOURCE_ID,
TRUNC(RF.FACT_DATE, 'MONTH'),
SUM(RF.AVAILABLE_HOURS)/8
FROM NIKU.NBI_RESOURCE_FACTS RF
GROUP BY RF.RESOURCE_ID, TRUNC(RF.FACT_DATE, 'MONTH')