SP_FR_ENT_NONVW (SQL View)	Index Back
Worksheet Report Entities Prompt table for Business Unit or Tree Node values as the reporting entity.

SP_FR_ENT_NONVW

(SQL View)

Worksheet Report Entities

Prompt table for Business Unit or Tree Node values as the reporting entity.

SELECT DISTINCT OPRID ,WORKSHEET_ID ,FR_REPORT_ENTITY FROM PS_FR_WS_BU_SEL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

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	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
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