GDP_PARENT_LVW

(SQL View)
 Index Back

GDP Parent Action Rel Lang

Guided Process Parent Action View Related Language

SELECT A.GDP_TEMPLATE_ID , A.GDP_ACTION_ITEM_ID , B.LANGUAGE_CD , B.GDP_LABEL FROM PS_GDP_TMPL_ITEM A , PS_GDP_ITEM_LNG B WHERE A.GDP_TEMPLATE_ID = B.GDP_TEMPLATE_ID AND A.GDP_ACTION_ITEM_ID = B.GDP_ACTION_ITEM_ID AND A.GDP_SUMMARY = 'Y'

  • Parent Record Of GDP_PARENT_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 GDP_TEMPLATE_ID Character(10) VARCHAR2(10) NOT NULL Guided Process Template ID
    2 GDP_ACTION_ITEM_ID Character(31) VARCHAR2(31) NOT NULL Guided Process Action Item ID
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 GDP_LABEL Character(100) VARCHAR2(100) NOT NULL Guided Process Title