EOPM_SUPD_MNUVW

(SQL View)
 Index Back

PUM Menu Item Export View

Automates Security Updates. Record to store menu changes (or additions) that need to be processed by Change Assistant AE. The table contains all details of a menu as they would be entered manually in App Designer.

SELECT MENUNAME ,BARNAME ,ITEMNAME ,PTIASPRPTNO ,ITEMNUM ,ITEMTYPE ,PNLGRPNAME ,MARKET ,BARLABEL ,ITEMLABEL ,XFERCOUNT ,SEARCHRECNAME ,EOPM_SELECTED ,'2' ,EOPM_STATUS_DT ,EOPM_SUPD_ACTION ,0 ,EOPM_SUPD_LOADED ,'PPLSOFT' ,%CurrentDateTimeIn ,DESCRLONG FROM PS_EOPM_SUPD_MNU

  • Related Language Record: EOPM_SUPDMLNGV

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 MENUNAME Character(30) VARCHAR2(30) NOT NULL Menu Name (see PSMENUDEFN).

    Prompt Table: PSMENUDEFN

    2 BARNAME Character(30) VARCHAR2(30) NOT NULL Menu Bar Name

    Prompt Table: %EDITTABLE

    3 ITEMNAME Character(30) VARCHAR2(30) NOT NULL Item Name

    Prompt Table: %EDITTABLE2

    4 PTIASPRPTNO Number(10,0) DECIMAL(10) NOT NULL BUG Number
    5 ITEMNUM Number(4,0) SMALLINT NOT NULL Item Number
    6 ITEMTYPE Number(2,0) SMALLINT NOT NULL Item Type
    7 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name
    8 MARKET Character(3) VARCHAR2(3) NOT NULL Market

    Default Value: GBL

    9 BARLABEL Character(10) VARCHAR2(10) NOT NULL Menu Bar Label
    10 ITEMLABEL Character(30) VARCHAR2(30) NOT NULL Menu Item Label
    11 XFERCOUNT Number(4,0) SMALLINT NOT NULL Panel Transfer Count
    12 SEARCHRECNAME Character(15) VARCHAR2(15) NOT NULL Search Record Name
    13 EOPM_SELECTED Character(1) VARCHAR2(1) NOT NULL selected

    Default Value: Y

    14 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

    Default Value: 1

    15 EOPM_STATUS_DT Date(10) DATE status date of PUM security project
    16 EOPM_SUPD_ACTION Character(3) VARCHAR2(3) NOT NULL udpate action
    ADD=Add
    DEL=Delete

    Default Value: ADD

    17 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    18 EOPM_SUPD_LOADED Character(1) VARCHAR2(1) NOT NULL items are loaded.
    19 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    20 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    21 DESCRLONG Long Character CLOB Long Description