GP_PAYGROUPPrompt Table: GP_PYGRP
EFFDTPrompt Table: GPSG_IRAS_CPY
Prompt Table: GPSG_ER_CPF_REF
Prompt Table: GPSG_PSLP
GPSGP_PYGRP_VW(SQL View) |
Index Back |
|---|---|
GP Sgp Pay Group extensionSingapore Country Extension record to store Pay Group data needed for Singapore. |
| SELECT A.GP_PAYGROUP ,A. EFFDT , A.GPSG_CPY_TAX_REF , A.GPSG_CPF_EMPLR_REF , A.GPSG_PAYSLIP_ID , B.PAY_ENTITY FROM PS_GP_PYGRP_SGPSG A , PS_GP_PYGRP B WHERE A.GP_PAYGROUP = B.GP_PAYGROUP |
| # | 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 |
| 6 | PAY_ENTITY | Character(10) | VARCHAR2(10) NOT NULL | Pay Entity |