PV_CM_LINKS_VW2(SQL View) |
Index Back |
---|
SELECT PV_ADM_MAIN_ITEM , PV_ADM_SUB_ITEM1 , PV_ADM_SUB_ITEM2 , DESCR100 , PV_MENUITEM , PV_BARNAME , BARITEMNAME , PANELITEMNAME , PV_ADM_REL_SUB_GRP , MESSAGE_SET_NBR , MESSAGE_NBR , PV_ADM_QUERYSTRING , PV_ADM_DESCR FROM PS_PV_CM_LINKS_TBL |
# | 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 | Sub-item Group |
4 | DESCR100 | Character(100) | VARCHAR2(100) NOT NULL | Length 100 Description |
5 | 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 |
6 | 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 |
7 | BARITEMNAME | Character(30) | VARCHAR2(30) NOT NULL | Bar Item Name |
8 | PANELITEMNAME | Character(30) | VARCHAR2(30) NOT NULL | Panel Item Name |
9 | PV_ADM_REL_SUB_GRP | Character(50) | VARCHAR2(50) NOT NULL | Related Sub Item Group |
10 | 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 |
11 | MESSAGE_NBR | Number(5,0) | INTEGER NOT NULL | Message Number. This field refers to the Message Number in the Message Catalog. |
12 | PV_ADM_QUERYSTRING | Character(254) | VARCHAR2(254) NOT NULL | Query String |
13 | PV_ADM_DESCR | Long Character | CLOB | Description |