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_ROLEACT_SRCH(SQL View) |
Index Back |
|---|
| SELECT A.PV_TRANSACTION , B.XLATLONGNAME , A.ROLENAME FROM PS_PV_ROLE_ACT_CAT A , PSXLATITEM B WHERE A.PV_TRANSACTION = B.FIELDVALUE AND B.FIELDNAME = 'PV_TRANSACTION' AND %EffdtCheck(PSXLATITEM BB, B, %CurrentDateIn) |
| # | 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_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Transaction |
| 3 | ROLENAME |
Character(30) | VARCHAR2(30) NOT NULL |
The name of a Role in the Role Definition Table (see PSROLEDEFN).
Prompt Table: PSROLEDEFN |