SP_FR_ENT_CLSVW (SQL View)	Index Back
Worksheet Report Entities Security view of FR_WS_ENT_NONVW. The sub-select is to exclude any tree nodes with Business Units that the user does not have access to.

SP_FR_ENT_CLSVW

(SQL View)

Worksheet Report Entities

Security view of FR_WS_ENT_NONVW. The sub-select is to exclude any tree nodes with Business Units that the user does not have access to.

SELECT DISTINCT B.OPRCLASS , A.WORKSHEET_ID , A.FR_REPORT_ENTITY FROM PS_FR_WS_BU_SEL A , PS_SEC_BU_CLS B , PSOPRDEFN U WHERE U.OPRCLASS = B.OPRCLASS AND A.OPRID = U.OPRID AND B.BUSINESS_UNIT = A.BUSINESS_UNIT AND NOT EXISTS ( SELECT 'X' FROM PS_FR_WS_BU_SEL C WHERE C.WORKSHEET_ID = A.WORKSHEET_ID AND C.OPRID = A.OPRID AND C.FR_REPORT_ENTITY = A.FR_REPORT_ENTITY AND C.BUSINESS_UNIT NOT IN ( SELECT A2.BUSINESS_UNIT FROM PS_SEC_BU_CLS A2 , PSOPRDEFN U2 WHERE U2.OPRCLASS = A2.OPRCLASS AND U2.OPRID = C.OPRID))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRCLASS Character(30) VARCHAR2(30) NOT NULL Operator Class

2 WORKSHEET_ID Character(20) VARCHAR2(20) NOT NULL Cash Flows Worksheet ID

3 FR_REPORT_ENTITY Character(20) VARCHAR2(20) NOT NULL Report Entity

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRCLASS	Character(30)	VARCHAR2(30) NOT NULL	Operator Class
2	WORKSHEET_ID	Character(20)	VARCHAR2(20) NOT NULL	Cash Flows Worksheet ID
3	FR_REPORT_ENTITY	Character(20)	VARCHAR2(20) NOT NULL	Report Entity