GPSG_NIDTYP_LNG (SQL View)	Index Back
Singapore National ID Type LNG Singapore National ID types LNG

GPSG_NIDTYP_LNG

(SQL View)

Singapore National ID Type LNG

Singapore National ID types LNG

SELECT A.NATIONAL_ID_TYPE , A.LANGUAGE_CD , A.DESCRSHORT FROM PS_NID_TYPE_LANG A WHERE A.COUNTRY = 'SGP'

Related Language Record for GPSG_NID_TYP_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 NATIONAL_ID_TYPE Character(6) VARCHAR2(6) NOT NULL National ID Type
Prompt Table: NID_TYPE_TBL

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

3 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	NATIONAL_ID_TYPE	Character(6)	VARCHAR2(6) NOT NULL	National ID Type Prompt Table: NID_TYPE_TBL
2	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
3	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description