HCSC_CLK_CNTALN (SQL View)	Index Back
RelLng View for GP Countries This is the related language view for GP Countries,

HCSC_CLK_CNTALN

(SQL View)

RelLng View for GP Countries

This is the related language view for GP Countries,

SELECT A.COUNTRY , A.LANGUAGE_CD , A.DESCR FROM PS_COUNTRYTBL_LANG A UNION %SQL(HCSC_CLK_UNION_ALLCNTRY_LN)

Related Language Record for HCSC_CLK_CNTAVW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
2	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description