PV_TRANSACTIONADM=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
ROLENAMEPrompt Table: PSROLEDEFN
PV_ROLE_ACT_V(SQL View) |
Index Back |
|---|---|
Role Actions8/30/07 - JK - Added Record Description. |
| SELECT DISTINCT A.PV_TRANSACTION , A.ROLENAME FROM PS_PV_ROLE_ACTION A WHERE A.PV_TRANSACTION <> ' ' |
| # | 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 |