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 |