WP_AGRT_PRD_LNG

(SQL View)
Index Back

Approved Agreement


SELECT DISTINCT A.WP_AGREEMENT_ID , B.PERIOD_ID , A2.LANGUAGE_CD , A.DESCR50 , A.DESCRSHORT FROM PS_WP_AGREEMENT A , PS_WP_AGREEMNT_LNG A2 , PS_WP_AGRT_PERIOD B WHERE A.WP_AGRT_STATUS = 'A' AND A.WP_AGREEMENT_ID = B.WP_AGREEMENT_ID AND A.WP_AGREEMENT_ID = A2.WP_AGREEMENT_ID

  • Related Language Record for WP_AGRT_PRD_VW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 WP_AGREEMENT_ID Character(5) VARCHAR2(5) NOT NULL Profit-Sharing: Agreement Identifier
    2 PERIOD_ID Character(12) VARCHAR2(12) NOT NULL Time Period ID
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
    5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description