W3EB_LE_HIER

(SQL Table)
 Index Back

Action Item record

Action Items are tied to an Template ID from table W3EB_LE_LIST

  • Related Language Record: W3EB_LE_H1_LANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LE_ITEM_ID Character(31) VARCHAR2(31) NOT NULL Action Item ID
    2 LE_HIER_ITEM Character(31) VARCHAR2(31) NOT NULL Action Item ID

    Default Value: BB

    3 LE_PARENT_ACTION Character(31) VARCHAR2(31) NOT NULL Parent Action Item is used for parent/child relationship. This field will contain the item_id for the parent action.
    4 LE_ACTION_SEQNBR Number(4,0) SMALLINT NOT NULL Squence number for the action item to appear on the pagelet
    5 LE_ACTION_DESCR Character(35) VARCHAR2(35) NOT NULL Action Item Title on the pagelet
    6 LE_ACTION_REQD Character(1) VARCHAR2(1) NOT NULL Is the action item required
    N=No
    Y=Yes
    7 LE_ACTION_SERVICE Character(30) VARCHAR2(30) NOT NULL Transaction page accessed when clicking on the action item

    Prompt Table: W3EB_LE_SERV_VW

    8 SEQNBR Number(5,0) INTEGER NOT NULL Sequence Number
    9 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    10 DATA_TYPE_CD Character(1) VARCHAR2(1) NOT NULL Data Type Code
    N=Customer Data
    S=Sample Data
    Y=System Data

    Default Value: N