PV_ROLE_ACTN_VW (SQL View)	Index Back
Role Action View Role Action View

PV_ROLE_ACTN_VW

(SQL View)

Role Action View

SELECT A.PV_ACTION , B.ROLEUSER FROM PS_PV_ROLE_ACTION A , PSROLEUSER B , PS_ROLEXLATOPR C WHERE A.ROLENAME=B.ROLENAME AND B.ROLEUSER=C.ROLEUSER

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PV_ACTION Character(60) VARCHAR2(60) NOT NULL Action Name

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PV_ACTION	Character(60)	VARCHAR2(60) NOT NULL	Action Name
2	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).