W3EB_LE_ITEM

(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_I2_LANG

  • Parent record: W3EB_LE_LIST

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

    Default Value: BB

    2 LE_TEMPLATE_ID Character(31) VARCHAR2(31) NOT NULL auto generated Template ID generated by Tools for the List

    Default Value: AA

    3 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    4 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.
    5 LE_ACTION_SEQNBR Number(4,0) SMALLINT NOT NULL Squence number for the action item to appear on the pagelet
    6 LE_ACTION_DESCR Character(35) VARCHAR2(35) NOT NULL Action Item Title on the pagelet
    7 LE_ACTION_REQD Character(1) VARCHAR2(1) NOT NULL Is the action item required
    N=No
    Y=Yes

    Default Value: N

    8 LE_ACTION_SERVICE Character(30) VARCHAR2(30) NOT NULL Transaction page accessed when clicking on the action item

    Prompt Table: W3EB_LE_SERV_VW

    9 LE_ACTION_SMRY Character(1) VARCHAR2(1) NOT NULL Is this a parent action item
    N=No
    Y=Yes

    Default Value: N

    10 LE_DEPEND_ACTION Character(31) VARCHAR2(31) NOT NULL Dependent action item. Another action item is dependent on this action item.
    11 DEPENDENT_ITEM Character(1) VARCHAR2(1) NOT NULL used to denote a dependent action item

    Y/N Table Edit

    Default Value: N

    12 DATA_TYPE_CD Character(1) VARCHAR2(1) NOT NULL Data Type Code
    N=Customer Data
    S=Sample Data
    Y=System Data

    Default Value: N