GP_ABS_NA_PG_LV

(SQL View)
 Index Back

Abs Mgmt PNA Pay Groups - RL

Abs Mgmt PNA Pay Groups - RL

SELECT B.COMPANY ,B.PAYGROUP ,B.LANGUAGE_CD ,A.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_NA_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