Started looking into some best practices violation in the repository. So build a query which helps to identify the Number of Force Active Fields in a Buscomp. My personal recommendation is to have <30 Force Active fields in a Buscomp. But depends on BC to BC and Business case.
COUNT(A.FORCEACTIVE) AS NUM_OF_FORCEACTIVE
A.BUSCOMP_ID = B.ROW_ID AND
A.BUSCOMP_ID IN (SELECT B.ROW_ID FROM SIEBEL.S_BUSCOMP B)
OUTPUT TO E:\TEMP\FORCEACTIVE2.TXT