GVT_ACTN_PRMPT

(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.EFFDT , B.EFF_STATUS , B.ACTION_DESCR FROM PS_GVT_ACTVTY_PGRP A ,PS_ACTION_TBL B WHERE B.EFF_STATUS = 'A' 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.PNLGRPNAME = A.PNLGRPNAME AND C.ACTION = B.ACTION))

  • Related Language Record: GVT_ACTN_PP_LNG

    • # 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 EFFDT Date(10) DATE Effective Date
    6 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive
    7 ACTION_DESCR Character(50) VARCHAR2(50) NOT NULL Action Description