PV_ROLE_ACTN_V2 (SQL View)	Index Back
ePro Role Action 8/30/07 - JK - Added Record Description.

PV_ROLE_ACTN_V2

(SQL View)

ePro Role Action

8/30/07 - JK - Added Record Description.

SELECT ' ' , A.PV_TRANSACTION , A.PV_ACTION , A.PV_ACT_CATEGORY_CD , A.PV_OBJECTTYPE , A.PV_ACT_CONTROL , A.PV_REQUESTER_FLG , A.PV_FORM_NAME , A.PV_ACT_TYPE FROM PS_PV_ACTIONS A

Parent record: PV_ACTIONS

# 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: PSROLEDEFN

2 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

3 PV_ACTION Character(60) VARCHAR2(60) NOT NULL Action Name
Prompt Table: PV_ACTIONS_VW2

4 PV_ACT_CATEGORY_CD Character(6) VARCHAR2(6) NOT NULL Category Code
Prompt Table: PV_ACT_CAT_VW

5 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

6 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

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	ROLENAME	Character(30)	VARCHAR2(30) NOT NULL	The name of a Role in the Role Definition Table (see PSROLEDEFN). Prompt Table: PSROLEDEFN
2	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
3	PV_ACTION	Character(60)	VARCHAR2(60) NOT NULL	Action Name Prompt Table: PV_ACTIONS_VW2
4	PV_ACT_CATEGORY_CD	Character(6)	VARCHAR2(6) NOT NULL	Category Code Prompt Table: PV_ACT_CAT_VW
5	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
6	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
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