GP_NRP_SEL_VW (SQL View)	Index Back
Setup By Element Lang NRP view for GP ED SET LNG

GP_NRP_SEL_VW

(SQL View)

Setup By Element Lang

NRP view for GP ED SET LNG

SELECT COUNTRY , PIN_NUM + 50000000 ,LANGUAGE_CD ,GP_LABEL_NAME FROM PS_GP_ED_SET_LNG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

2 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number

3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

4 GP_LABEL_NAME Character(30) VARCHAR2(30) NOT NULL Label name.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
2	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number
3	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
4	GP_LABEL_NAME	Character(30)	VARCHAR2(30) NOT NULL	Label name.