GP_ABS_PI_PG_LV

(SQL View)
 Index Back

Abs Mgmt PI Pay Groups - RL

Abs Mgmt PI Pay Groups - RL

SELECT B.COMPANY ,B.PAYGROUP ,B.LANGUAGE_CD ,B.EFFDT ,B.DESCR FROM PS_PAYGROUP_TBL A ,PS_PAYGROUP_LANG B WHERE A.EFF_STATUS = 'A' AND A.PI_CONFIG_ID <> ' ' AND A.COMPANY = B.COMPANY AND A.PAYGROUP = B.PAYGROUP AND A.EFFDT = B.EFFDT

  • Related Language Record for GP_ABS_PI_PG_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
    2 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description