GPSG_FWL_DT_VW (SQL View)	Index Back
FWL Dates Used to fetch FWL Start Date and To date

GPSG_FWL_DT_VW

(SQL View)

FWL Dates

Used to fetch FWL Start Date and To date

SELECT EMPLID , CITIZENSHIP_STATUS , WORKER_TYPE_SGP , A.EFFDT AS START_DATE , ( SELECT MIN(EFFDT-1) FROM PS_CTZSHIP_SGP B WHERE country ='SGP' AND A.EMPLID = B.EMPLID AND A.EFFDT < B.EFFDT ) AS TO_DATE FROM PS_CTZSHIP_SGP A WHERE COUNTRY ='SGP' AND CITIZENSHIP_STATUS = '6'

# 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 GPSG_FWL_ST_DATE Date(10) DATE To hold FWL start date

5 GPSG_FWL_TO_DATE Date(10) DATE To hold FWL to 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	GPSG_FWL_ST_DATE	Date(10)	DATE	To hold FWL start date
5	GPSG_FWL_TO_DATE	Date(10)	DATE	To hold FWL to Date