GPSG_PYGRP_VW (SQL View)	Index Back
Search View - Paygroup Based on the Employer Tax Reference No., to show only the corresponding Paygroup mapped to it.

GPSG_PYGRP_VW

(SQL View)

Search View - Paygroup

Based 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

#	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