PV_ADM_ITEM_TBL(SQL Table) |
Index Back |
|---|---|
Administer ePro Menu Items8/30/07 - JK - Added Record Description. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(30) | VARCHAR2(30) NOT NULL | Main Item | |
| 2 | Character(50) | VARCHAR2(50) NOT NULL | ||
| 3 | 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 |