PV_ADM_SRCH_VW

(SQL View)
Index Back

SELECT A.PV_ADM_MAIN_ITEM , A.PV_ADM_SUB_ITEM1 , A.PV_ADM_SUB_ITEM2 , A.SEQNUM , A.PV_ADM_QUERYSTRING , A.PV_MENUITEM , A.PV_BARNAME , A.BARITEMNAME , A.PANELITEMNAME , A.PV_STEP_NUM , A.PV_ADM_REL_ITEM , A.PV_ADM_REL_SUB_GRP , A.MESSAGE_SET_NBR , A.MESSAGE_NBR , A.PV_ADM_DESCR FROM PS_PV_ADM_ITEM_TBL A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PV_ADM_MAIN_ITEM Character(30) VARCHAR2(30) NOT NULL Main Item
2 PV_ADM_SUB_ITEM1 Character(50) VARCHAR2(50) NOT NULL
3 PV_ADM_SUB_ITEM2 Character(50) VARCHAR2(50) NOT NULL PV Admin sub item 2
4 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number

Default Value: 1

5 PV_ADM_QUERYSTRING Character(254) VARCHAR2(254) NOT NULL Admin Item Description
6 PV_MENUITEM Character(30) VARCHAR2(30) NOT NULL Menu Item
DCF=DESIGN_CHARTFIELDS
DGO=DEFINE_GENERAL_OPTIONS
DIC=DEFINE_ITEM_CONTROL_DATA
EAP=ESTABLISH_ASSET_PROCESSING
EBU=ESTABLISH_BUSINESS_UNITS
MIR=MANAGE_INTEGRATION_RULES
MIT=DEFINE_ITEMS
MMS=PV_MARKETSITE
MPC=MANAGE_PROCUREMENT_CARDS
MRO=MAINTAIN_ROLES
MSE=MAINTAIN_SECURITY
MUR=MAINTAIN_USER_PROFILES
MVN=MAINTAIN_SUPPLIERS
POT=PROCESS_OUTBOUND_TRANSACTIONS
PV=PV_MAIN_MENU
SPO=STRUCTURE_PROCUREMENT_OPTIONS
UTI=UTILITIES
WFA=WORKFLOW_ADMINISTRATOR

Default Value: EBU

7 PV_BARNAME Character(30) VARCHAR2(30) NOT NULL Bar Name
ADM=PV_ADMIN
EXF=EXPRESS_FORMS
INQ=INQUIRE
MKS=PV_MARKETSITE
PCD=PCARD
PRC=PROCESS
PRO=PV_PROCESSES
REC=RECEIVING
SET=SETUP
UAD=USE_A-D
UAI=USE_A-I
UAM=USE_A-M
UEP=USE_E-P
UJR=USE_J-R
UNZ=USE_N_Z
URZ=USE_R-Z
USE=USE
USZ=USE_S-Z
VSS=VENDOR_SS
WLT=WORKLIST

Default Value: USE

8 BARITEMNAME Character(30) VARCHAR2(30) NOT NULL Bar Item Name
9 PANELITEMNAME Character(30) VARCHAR2(30) NOT NULL Panel Item Name
10 PV_STEP_NUM Character(10) VARCHAR2(10) NOT NULL Step Number
11 PV_ADM_REL_ITEM Character(30) VARCHAR2(30) NOT NULL Related Main Menu Item
12 PV_ADM_REL_SUB_GRP Character(50) VARCHAR2(50) NOT NULL Related Sub Item Group
13 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.

Default Value: 18036

14 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
15 PV_ADM_DESCR Long Character CLOB Description