GPSG_CPF_PER_VW (SQL View)	Index Back
CPF Personal Data View This view is used for CPF calculation in global payroll SGP. It contains CPF related information such as religion, ethnic category, citizenship, worker type and permanent status date.

GPSG_CPF_PER_VW

(SQL View)

CPF Personal Data View

This view is used for CPF calculation in global payroll SGP. It contains CPF related information such as religion, ethnic category, citizenship, worker type and permanent status date.

SELECT EMPLID ,CITIZENSHIP_STATUS ,WORKER_TYPE_SGP ,PERM_STATUS_DT_SGP FROM PS_CITIZENSHIP WHERE COUNTRY = 'SGP' AND DEPENDENT_ID = ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

2 CITIZENSHIP_STATUS Character(1) VARCHAR2(1) NOT NULL Citizenship Status

3 WORKER_TYPE_SGP Character(2) VARCHAR2(2) NOT NULL Worker's Type - Singapore

4 PERM_STATUS_DT_SGP Date(10) DATE Permanent Status Date

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	CITIZENSHIP_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Citizenship Status
3	WORKER_TYPE_SGP	Character(2)	VARCHAR2(2) NOT NULL	Worker's Type - Singapore
4	PERM_STATUS_DT_SGP	Date(10)	DATE	Permanent Status Date