GPTH_NID_VW (SQL View)	Index Back
National ID View National ID View

GPTH_NID_VW

(SQL View)

National ID View

SELECT A.EMPLID ,B.COUNTRY ,B.NATIONAL_ID_TYPE ,B.NATIONAL_ID ,C.NATIONAL_ID AS GPTH_SI_EE_ACCT FROM PS_PERSON A LEFT OUTER JOIN PS_PERS_NID B ON (A.EMPLID = B.EMPLID AND B.NATIONAL_ID_TYPE = 'PID' AND B.COUNTRY='THA') LEFT OUTER JOIN PS_PERS_NID C ON (A.EMPLID = C.EMPLID AND C.NATIONAL_ID_TYPE = 'SSO ID' AND C.COUNTRY='THA')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Default Value: NEW

2 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
Prompt Table: NID_TYPE_VW

3 NATIONAL_ID_TYPE Character(6) VARCHAR2(6) NOT NULL National ID Type
Default Value: NID_TYPE2_VW.NATIONAL_ID_TYPE
Prompt Table: NID_TYPE1_VW

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

5 GPTH_SI_EE_ACCT Character(20) VARCHAR2(20) NOT NULL Payee Social Security Number

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Default Value: NEW
2	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country Prompt Table: NID_TYPE_VW
3	NATIONAL_ID_TYPE	Character(6)	VARCHAR2(6) NOT NULL	National ID Type Default Value: NID_TYPE2_VW.NATIONAL_ID_TYPE Prompt Table: NID_TYPE1_VW
4	NATIONAL_ID	Character(20)	VARCHAR2(20) NOT NULL	National ID
5	GPTH_SI_EE_ACCT	Character(20)	VARCHAR2(20) NOT NULL	Payee Social Security Number