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

PV_ROLE_ACTN_V3

(SQL View)

Role Action View

SELECT DISTINCT A.PV_TRANSACTION , A.PV_ACTION , A.PV_OBJECTTYPE , A.PV_ACT_CONTROL , A.PRIORITY , B.ROLEUSER , A.PV_REQUESTER_FLG , A.PV_FORM_NAME , A.PV_ACT_TYPE FROM PS_PV_ROLE_ACTION A , PSROLEUSER B , PS_ROLEXLATOPR C WHERE A.ROLENAME=B.ROLENAME AND B.ROLEUSER= C.ROLEUSER AND A.PV_ACTION <> 'INITIAL_PAGE_DEFAULT' AND A.PRIORITY = ( SELECT MIN(A1.PRIORITY) FROM PS_PV_ROLE_ACTION A1 , PSROLEUSER B1 , PS_ROLEXLATOPR C1 WHERE A1.ROLENAME=B1.ROLENAME AND B1.ROLEUSER= C1.ROLEUSER AND A1.PV_ACTION <> 'INITIAL_PAGE_DEFAULT' AND C1.ROLEUSER =C.ROLEUSER AND A1.PV_ACTION=A.PV_ACTION)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PV_TRANSACTION Character(3) VARCHAR2(3) NOT NULL Transaction
ADM=Administration
BYR=Buyer Center
CMN=Common Actions
EXP=Expense
INV=Invoice
PRG=Progress Log
RCV=Receiving
REQ=Requisition
SUP=Supplier Administration
SWO=Work Order
TIM=Timesheet
WKL=Workflow

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

3 PV_OBJECTTYPE Character(2) VARCHAR2(2) NOT NULL Object Type
B=Buttons
D=Data
D2=Data
F1=Fields
F2=Fields
H=Hyperlinks
I1=Icon and Hyperlink
IP=Initial Page
P1=Page
P2=Page
S1=Sections
S2=Sections

4 PV_ACT_CONTROL Character(4) VARCHAR2(4) NOT NULL Action Controls
100=CATALOG
1000=EXTERNAL CATALOGS
200=EXPRESS REQUISITION
2000=TEMPLATES
300=SPECIAL REQUEST
400=FAVORITES
500=WEB
600=FORMS
700=ePro SERVICES
701=Fixed Cost Service
702=Variable Cost Service
703=Time and Materials
800=SERVICE REQUEST
900=RECENTLY ORDERED
A=Enabled
C=Catalog Item Only
D=Disabled
E=Editable
H=Hide
V=Display Only

5 PRIORITY Number(3,0) SMALLINT NOT NULL Priority

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

7 PV_REQUESTER_FLG Character(1) VARCHAR2(1) NOT NULL Requester Role Action

8 PV_FORM_NAME Character(18) VARCHAR2(18) NOT NULL Form Name

9 PV_ACT_TYPE Character(1) VARCHAR2(1) NOT NULL Action type defined as eProcurement or sProcurement or both
B=ePro&sPro
E=ePro Only
S=sPro Only

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PV_TRANSACTION	Character(3)	VARCHAR2(3) NOT NULL	Transaction ADM=Administration BYR=Buyer Center CMN=Common Actions EXP=Expense INV=Invoice PRG=Progress Log RCV=Receiving REQ=Requisition SUP=Supplier Administration SWO=Work Order TIM=Timesheet WKL=Workflow
2	PV_ACTION	Character(60)	VARCHAR2(60) NOT NULL	Action Name
3	PV_OBJECTTYPE	Character(2)	VARCHAR2(2) NOT NULL	Object Type B=Buttons D=Data D2=Data F1=Fields F2=Fields H=Hyperlinks I1=Icon and Hyperlink IP=Initial Page P1=Page P2=Page S1=Sections S2=Sections
4	PV_ACT_CONTROL	Character(4)	VARCHAR2(4) NOT NULL	Action Controls 100=CATALOG 1000=EXTERNAL CATALOGS 200=EXPRESS REQUISITION 2000=TEMPLATES 300=SPECIAL REQUEST 400=FAVORITES 500=WEB 600=FORMS 700=ePro SERVICES 701=Fixed Cost Service 702=Variable Cost Service 703=Time and Materials 800=SERVICE REQUEST 900=RECENTLY ORDERED A=Enabled C=Catalog Item Only D=Disabled E=Editable H=Hide V=Display Only
5	PRIORITY	Number(3,0)	SMALLINT NOT NULL	Priority
6	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
7	PV_REQUESTER_FLG	Character(1)	VARCHAR2(1) NOT NULL	Requester Role Action
8	PV_FORM_NAME	Character(18)	VARCHAR2(18) NOT NULL	Form Name
9	PV_ACT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Action type defined as eProcurement or sProcurement or both B=ePro&sPro E=ePro Only S=sPro Only