WCS_PGLT_PNL_VW

(SQL View)
 Index Back

Components with Comp Charts

Lists all components where any of the pages contains the common compensation chart subpage object.

SELECT CMP.PNLGRPNAME , CMP.MARKET , CMP.DESCR , CMP.DESCRLONG FROM PSPNLGRPDEFN CMP , PSPNLGROUP GRP , PSPNLFIELD FLD WHERE CMP.PNLGRPNAME = GRP.PNLGRPNAME AND CMP.MARKET = GRP.MARKET AND GRP.PNLNAME = FLD.PNLNAME AND (( FLD.FIELDTYPE = 11 AND CMP.OBJECTOWNERID IN ('HWCS') AND FLD.SUBPNLNAME = 'WCS_ECM_PGLT' ) OR ( FLD.FIELDTYPE = 21 AND CMP.OBJECTOWNERID IN ('HWCS') AND FLD.SUBPNLNAME = 'WCS_ECM_MSS_CHART' ))

  • Related Language Record: PSPNLGDEFNLANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name
    2 MARKET Character(3) VARCHAR2(3) NOT NULL Market
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 DESCRLONG Long Character CLOB Long Description