SAD_PTAI_LVW

(SQL View)
Index Back

Action Items Lists Vw Rel.Lang

Action Items Lists View for Parent Template Only Rel Lang

SELECT A.PTAI_LIST_ID , E.LANGUAGE_CD , E.PTAI_LABEL FROM PS_PTAI_LIST A , PS_PTAI_LIST_LNG E WHERE A.PTAI_LIST_ID = E.PTAI_LIST_ID AND A.PTAI_IS_TMPL = 'Y'

  • Related Language Record for SAD_PTAI_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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 PTAI_LABEL Character(100) VARCHAR2(100) NOT NULL Action Items - Label