EOPM_MNU_Q_VW(SQL View) |
Index Back |
|---|---|
Menu Data for QueryMenu Data |
| SELECT MENUNAME , BARNAME , ITEMNAME , PTIASPRPTNO , EOPM_STATUS , EOPM_SELECTED , CAST (DESCRLONG AS VARCHAR(30)) FROM PS_EOPM_SUPD_MNU |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | MENUNAME | Character(30) | VARCHAR2(30) NOT NULL | Menu Name (see PSMENUDEFN). |
| 2 | BARNAME | Character(30) | VARCHAR2(30) NOT NULL | Menu Bar Name |
| 3 | ITEMNAME | Character(30) | VARCHAR2(30) NOT NULL | Item Name |
| 4 | PTIASPRPTNO | Number(10,0) | DECIMAL(10) NOT NULL | BUG Number |
| 5 | EOPM_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
set status of PUM security project
1=New 2=Imported 3=Changed 4=Processing 5=Applied 6=Error 7=Tested |
| 6 | EOPM_SELECTED | Character(1) | VARCHAR2(1) NOT NULL | selected |
| 7 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |