GP_PAYGROUPPrompt Table: GP_PYGRP
EFFDTPrompt Table: GPSG_IRAS_CPY
Prompt Table: GPSG_ER_CPF_REF
Prompt Table: GPSG_PSLP
GP_PYGRP_SGPSG(SQL Table) |
Index Back |
|---|---|
GP Sgp Pay Group extensionSingapore Country Extension record to store Pay Group data needed for Singapore. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GP_PAYGROUP |
Character(10) | VARCHAR2(10) NOT NULL |
Global Payroll pay group
Prompt Table: GP_PYGRP |
| 2 | EFFDT |
Date(10) | DATE NOT NULL | Effective Date |
| 3 | GPSG_CPY_TAX_REF | Character(11) | VARCHAR2(11) NOT NULL |
Singapore Company Tax Reference Number
Prompt Table: GPSG_IRAS_CPY |
| 4 | GPSG_CPF_EMPLR_REF | Character(15) | VARCHAR2(15) NOT NULL |
CPF Employer Reference no.
Prompt Table: GPSG_ER_CPF_REF |
| 5 | GPSG_PAYSLIP_ID | Character(18) | VARCHAR2(18) NOT NULL |
Defines the payslip template ID
Prompt Table: GPSG_PSLP |