RF_IPTR_RLUS_VW (SQL View)	Index Back
Inst Prod Tree Config Roles This view joins the Role User table with the Roles setup for the Installed Product Tree configuration. It will return the sequence of trees setup for a given user's roles.

RF_IPTR_RLUS_VW

(SQL View)

Inst Prod Tree Config Roles

This view joins the Role User table with the Roles setup for the Installed Product Tree configuration. It will return the sequence of trees setup for a given user's roles.

SELECT B.ROLEUSER , A.ROLENAME , A.SEQNO , A.TREECTL_NAME FROM PS_RF_IPRD_TR_ROLE A , PSROLEUSER B WHERE B.ROLENAME = A.ROLENAME AND A.STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 ROLEUSER Character(30) VARCHAR2(30) NOT NULL Role User

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

3 SEQNO Number(5,0) INTEGER NOT NULL Sequence Number

4 TREECTL_NAME Character(15) VARCHAR2(15) NOT NULL Tree Name

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	ROLEUSER	Character(30)	VARCHAR2(30) NOT NULL	Role User
2	ROLENAME	Character(30)	VARCHAR2(30) NOT NULL	The name of a Role in the Role Definition Table (see PSROLEDEFN).
3	SEQNO	Number(5,0)	INTEGER NOT NULL	Sequence Number
4	TREECTL_NAME	Character(15)	VARCHAR2(15) NOT NULL	Tree Name