RY_DOC_LANG_VW (SQL View)	Index Back
Document language Code Document language Code Temp View

RY_DOC_LANG_VW

(SQL View)

Document language Code

Document language Code Temp View

SELECT a.LANGUAGE_CD , a.LANGUAGE_CD , b.XLATLONGNAME FROM PSLANGUAGES a , PSXLATITEM b WHERE a.LANGUAGE_CD = b.FIELDVALUE AND a.INSTALLED = 1 AND b.FIELDNAME = 'LANGUAGE_CD'

Related Language Record: RY_DOC_LANG_LVW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 LANG_CD Character(3) VARCHAR2(3) NOT NULL Language Code Field. This Field is imported into CRM DB from Human Resources Database.

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

3 RY_DOC_LANG_CD Character(50) VARCHAR2(50) NOT NULL Language Code for Online Marketing Documents

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	LANG_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code Field. This Field is imported into CRM DB from Human Resources Database.
2	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
3	RY_DOC_LANG_CD	Character(50)	VARCHAR2(50) NOT NULL	Language Code for Online Marketing Documents