GPSG_PYGRP_VW(SQL View) |
Index Back |
---|---|
Search View - PaygroupBased on the Employer Tax Reference No., to show only the corresponding Paygroup mapped to it. |
SELECT PG.GPSG_CPY_TAX_REF ,PG.GP_PAYGROUP FROM PS_GP_PYGRP_SGPSG PG |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | GPSG_CPY_TAX_REF | Character(11) | VARCHAR2(11) NOT NULL | Singapore Company Tax Reference Number |
2 | GP_PAYGROUP | Character(10) | VARCHAR2(10) NOT NULL | Global Payroll pay group |