PV_ACTIONS_ADD (SQL View)	Index Back
Role Actions 8/30/07 - JK - Added Record Description.

PV_ACTIONS_ADD

(SQL View)

Role Actions

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

SELECT DISTINCT A.PV_TRANSACTION , B.ROLENAME , A.PV_ACT_CATEGORY_CD , A.PV_ACTION , A.PV_OBJECTTYPE , A.PV_ACT_CONTROL FROM PS_PV_ACTIONS A , PSROLEDEFN B

# 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 ROLENAME Character(30) VARCHAR2(30) NOT NULL The name of a Role in the Role Definition Table (see PSROLEDEFN).
Prompt Table: PSROLEDEFN

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

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

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

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