GPBR_PYGRP_VW

(SQL View)
Index Back

eSocial Pay Group Brazil

eSocial Pay Group Brazil

SELECT GP_PAYGROUP , DESCR FROM PS_GP_PYGRP WHERE EXISTS( SELECT 'X' FROM PS_GP_PYENT A WHERE A.COUNTRY = 'BRA' AND A.PAY_ENTITY = PS_GP_PYGRP.PAY_ENTITY)

  • Related Language Record: GPBR_PYG_VW_LNG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description