GVT_ACTN_PP_LNG

(SQL View)
 Index Back

Job Actions by WIP Actions

07/21/03 Lee - ICE508075000 - Add substring to viewtext for SQL validator.

SELECT A.GVT_WIP_RECORD , A.GVT_WIP_ACTVTY , A.PNLGRPNAME , B.ACTION , B.LANGUAGE_CD , B.EFFDT , B.ACTION_DESCR FROM PS_GVT_ACTVTY_PGRP A ,PS_ACTION_LNG B WHERE A.GVT_WIP_RECORD = 'USFED' AND (A.GVT_ALL_JOB_ACTNS = 'Y' OR EXISTS ( SELECT 'X' FROM PS_GVT_ACTVTY_ACTN C WHERE C.GVT_WIP_RECORD = A.GVT_WIP_RECORD AND C.GVT_WIP_ACTVTY = A.GVT_WIP_ACTVTY AND C.ACTION = B.ACTION))

  • Related Language Record for GVT_ACTN_PRMPT

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 GVT_WIP_RECORD Character(25) VARCHAR2(25) NOT NULL WIP record transaction.
    2 GVT_WIP_ACTVTY Character(10) VARCHAR2(10) NOT NULL Federal WIP activity
    3 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name
    4 ACTION Character(3) VARCHAR2(3) NOT NULL Action
    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 EFFDT Date(10) DATE Effective Date
    7 ACTION_DESCR Character(50) VARCHAR2(50) NOT NULL Action Description