LE_ACTION_DESCRW3EB_LE_CPY_VW(SQL View) |
Index Back |
|---|---|
Life Event ItemsLIfe Event Items and descriptions |
| SELECT DISTINCT (A.LE_ACTION_DESCR) , MAX(A.LE_ITEM_ID) FROM PS_W3EB_LE_ITEM A , PS_PTAI_ITEM B WHERE A.LE_ITEM_ID = B.PTAI_ITEM_ID AND A.LE_ACTION_DESCR <> 'Welcome' GROUP BY A.LE_ACTION_DESCR |
| # | 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 |
| 2 | LE_ITEM_ID | Character(31) | VARCHAR2(31) NOT NULL | Action Item ID |