GPBR_PYGRP_VW(SQL View) |
Index Back |
---|---|
eSocial Pay Group BrazileSocial 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) |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(10) | VARCHAR2(10) NOT NULL | Global Payroll pay group | |
2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |