GPSG_NID_TAX_VW (SQL View)	Index Back
GP Singapore - Tax Ref Id Selects the National Id used as the Tax Reference Id for Singapore employees

GPSG_NID_TAX_VW

(SQL View)

GP Singapore - Tax Ref Id

Selects the National Id used as the Tax Reference Id for Singapore employees

SELECT EMPLID , T.DESCRSHORT , N.NATIONAL_ID FROM PS_PERS_NID N , PS_NID_TYPE_TBL T WHERE N.TAX_REF_ID_SGP = 'Y' AND N.COUNTRY = 'SGP' AND T.COUNTRY = 'SGP' AND T.NATIONAL_ID_TYPE = N.NATIONAL_ID_TYPE

Parent record: PERSON

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 GPSG_TAX_REF_TYPE Character(10) VARCHAR2(10) NOT NULL Singapore IRAS Tax Reference Id Type

3 NATIONAL_ID Character(20) VARCHAR2(20) NOT NULL National ID

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	GPSG_TAX_REF_TYPE	Character(10)	VARCHAR2(10) NOT NULL	Singapore IRAS Tax Reference Id Type
3	NATIONAL_ID	Character(20)	VARCHAR2(20) NOT NULL	National ID