RF_IP_TR_ROL_VW (SQL View)	Index Back
Installed Prod Tree Role View This view returns the distinct role/tree combinations for the Installed Product Viewable Hierarchy tree role configuration table.

RF_IP_TR_ROL_VW

(SQL View)

Installed Prod Tree Role View

This view returns the distinct role/tree combinations for the Installed Product Viewable Hierarchy tree role configuration table.

SELECT ROLENAME , TREECTL_NAME FROM PS_RF_IPRD_TR_ROLE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 ROLENAME Character(30) VARCHAR2(30) NOT NULL The name of a Role in the Role Definition Table (see PSROLEDEFN).
Prompt Table: RB_TD_ROLE_VW

2 TREECTL_NAME Character(15) VARCHAR2(15) NOT NULL Tree Name
Prompt Table: RF_IPRD_TREE_HD

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	ROLENAME	Character(30)	VARCHAR2(30) NOT NULL	The name of a Role in the Role Definition Table (see PSROLEDEFN). Prompt Table: RB_TD_ROLE_VW
2	TREECTL_NAME	Character(15)	VARCHAR2(15) NOT NULL	Tree Name Prompt Table: RF_IPRD_TREE_HD