W3EB_LE_LIST_VW

(SQL View)
 Index Back

Action Item - List

View of the PTAI_LIST

SELECT A.LE_TEMPLATE_ID , A.LE_TEMPLATE_DESC , A.LIFE_EVENT_TYPE , A.DATA_TYPE_CD FROM PS_W3EB_LE_LIST A , PS_PTAI_LIST B WHERE A.LE_TEMPLATE_ID = B.PTAI_LIST_ID AND B.PTAI_FIELD1_LBL = 'HEB'

  • Related Language Record: W3EB_LE_LS_LANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LE_TEMPLATE_ID Character(31) VARCHAR2(31) NOT NULL auto generated Template ID generated by Tools for the List
    2 LE_TEMPLATE_DESC Character(30) VARCHAR2(30) NOT NULL Title for the Life Event pagelet
    3 LIFE_EVENT_TYPE Character(3) VARCHAR2(3) NOT NULL Type of Life Event (e.g. Birth, Adoption, Marriage)
    A=Adoption
    B=Birth
    D=Divorce
    M=Marriage

    Prompt Table: W3EB_LE_RULES

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