PY_LCKPNLGRP_VW

(SQL View)
 Index Back

Component Description

List of Components available for Payroll Lock Down feature

SELECT DISTINCT A.PNLGRPNAME , B.DESCR , C.XLATLONGNAME , A.PY_ELIG_PAYTGT FROM PS_PY_LCK_PG_ENABL A , PSPNLGRPDEFN B , PSXLATITEM C WHERE A.PY_COMP_ENABLED = 'Y' AND A.PNLGRPNAME = B.PNLGRPNAME AND A.MARKET = B.MARKET AND C.FIELDNAME = 'OBJECTOWNERID' AND C.FIELDVALUE = A.OBJECTOWNERID

  • Related Language Record: PY_LCKPGRP_LANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 PY_PROD_NAME Character(30) VARCHAR2(30) NOT NULL Product Name
    4 PY_ELIG_PAYTGT Character(1) VARCHAR2(1) NOT NULL Indicator for Component eligible for Payroll Target

    Y/N Table Edit