PTAI_PRSETLVW

(SQL View)
 Index Back

Action Items - Priv Set L View

Action Items privilege set id language view.

SELECT B.PTAI_PRIVSET_ID , A.LANGUAGE_CD , A.DESCR , A.DESCR254 FROM %Table(PTAI_PRSET_LNG) A , %Table(PTAI_PRIVSET) B WHERE A.PTAI_PRIVSET_ID = B.PTAI_PRIVSET_ID AND B.ACTIVE_FLAG = 'A' AND B.PTAI_FEATURE = 'AI'

  • Related Language Record for PTAI_PRIVSETVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PTAI_PRIVSET_ID Character(30) VARCHAR2(30) NOT NULL Privilege Set ID
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254