GPDE_SI_VSNR_VW (SQL View)	Index Back
View for German SI number View for German SI number

GPDE_SI_VSNR_VW

(SQL View)

View for German SI number

SELECT EMPLID , %Substring(NATIONAL_ID ,1,12) FROM PS_PERS_NID WHERE COUNTRY = 'DEU' AND NATIONAL_ID_TYPE = 'VSNR'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 GPDE_DV_RVNR Character(12) VARCHAR2(12) NOT NULL Pension Insurance Number

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	GPDE_DV_RVNR	Character(12)	VARCHAR2(12) NOT NULL	Pension Insurance Number