W3EB_LE_ITEM_VW

(SQL View)
 Index Back

List of Action Item

List of existing Action Items for eBenefits

SELECT A.LE_ACTION_DESCR , A.LE_ITEM_ID , A.LE_ACTION_REQD , A.LE_ACTION_SMRY , A.LE_ACTION_SERVICE FROM PS_W3EB_LE_ITEM A , PS_PTAI_ITEM B WHERE A.LE_ITEM_ID = B.PTAI_ITEM_ID

  • Related Language Record: W3EB_LE_IT_LANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LE_ACTION_DESCR Character(35) VARCHAR2(35) NOT NULL Action Item Title on the pagelet

    Prompt Table: W3EB_LE_ITEM_VW

    2 LE_ITEM_ID Character(31) VARCHAR2(31) NOT NULL Action Item ID

    Prompt Table: W3EB_LE_ITEM_VW

    3 LE_ACTION_REQD Character(1) VARCHAR2(1) NOT NULL Is the action item required
    N=No
    Y=Yes

    Default Value: N

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

    Default Value: N

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

    Prompt Table: W3EB_LE_SERV_VW