GP_ABS_PYGRP_LV

(SQL View)
Index Back

Abs Mgmt Mapped PNA/PI Paygrps

Related Language View

SELECT DISTINCT A.ABS_PAY_SYSTEM_CD ,A.EFFDT ,C.COMPANY ,C.PAYGROUP ,C.LANGUAGE_CD ,C.DESCR FROM PS_GP_ABS_PAYGROUP A , PS_GP_ABS_PYGRPMAP B , PS_PAYGROUP_LANG C WHERE A.ABS_PAY_SYSTEM_CD = B.ABS_PAY_SYSTEM_CD AND A.EFFDT = B.EFFDT AND A.EFF_STATUS = 'A' AND B.COMPANY = C.COMPANY AND B.PAYGROUP = C.PAYGROUP AND C.EFFDT = ( SELECT MAX(D.EFFDT) FROM PS_PAYGROUP_LANG D WHERE D.COMPANY = C.COMPANY AND D.PAYGROUP = C.PAYGROUP AND D.EFFDT <= A.EFFDT)

  • Related Language Record for GP_ABS_PYGRP_VW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PAY_SYSTEM_FLG Character(2) VARCHAR2(2) NOT NULL Payroll System
    GP=Global Payroll
    NA=Payroll for North America
    OT=Other
    PI=Payroll Interface
    2 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    3 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
    4 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group
    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description