LC_CNTRY_VWLN (SQL View)	Index Back
Loc Country View Loc Country View

LC_CNTRY_VWLN

(SQL View)

Loc Country View

SELECT a.country , b.language_cd , b.descrshort FROM PS_COUNTRY_TBL a , ps_countrytbl_lang b WHERE a.country = b.country

Related Language Record for LC_CNTRY_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 LC_CNTRY Character(3) VARCHAR2(3) NOT NULL The local country.

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	LC_CNTRY	Character(3)	VARCHAR2(3) NOT NULL	The local country.
2	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
3	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description