GPSC_PNCNT_LANG (SQL View)	Index Back
Element List View Lang Element Browser Element List View Language

GPSC_PNCNT_LANG

(SQL View)

Element List View Lang

Element Browser Element List View Language

SELECT A.PIN_NM ,A.LANGUAGE_CD , A.PIN_CODE , A.DESCR FROM PS_GP_PIN_LANG A WHERE PIN_NUM <= 50000000 UNION SELECT A.PIN_NM , A.LANGUAGE_CD , A.PIN_CODE , A.DESCR FROM PS_GP_PIN_LANG A , PS_GP_ELM_BR_PKG B WHERE B.GP_PKG_NEW_PIN_FLG='Y' AND A.PIN_NUM=(50000000+B.PIN_NUM)

Related Language Record for GPSC_ELM_PINCNT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PIN_NM Character(18) VARCHAR2(18) NOT NULL Element Name field

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

3 PIN_CODE Character(22) VARCHAR2(22) NOT NULL Unique identifier of a PIN (alternate to PIN number). critical for use in merging packages of elements from one database onto another when PINs may or may not be renumbered as they are moved across. Constructed from PIN_NM + COUNTRY of the element definition (GP_PIN)

4 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PIN_NM	Character(18)	VARCHAR2(18) NOT NULL	Element Name field
2	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
3	PIN_CODE	Character(22)	VARCHAR2(22) NOT NULL	Unique identifier of a PIN (alternate to PIN number). critical for use in merging packages of elements from one database onto another when PINs may or may not be renumbered as they are moved across. Constructed from PIN_NM + COUNTRY of the element definition (GP_PIN)
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description