GP_WC_LISTID_VW

(SQL View)
 Index Back

PROMPT FOR LIST ID

Prompt table for list id in work centre

SELECT PTAI_LIST_ID , PTAI_LABEL FROM PS_PTAI_LIST WHERE PTAI_ACTIVE_FLG = 'Y' AND OBJECTOWNERID LIKE ('HG%') AND PTAI_IS_TMPL = 'Y'

  • Related Language Record: GP_WC_LT_LNG_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PTAI_LIST_ID Character(31) VARCHAR2(31) NOT NULL Action Items - Action Item List ID
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description