NAME_NOXLAT_VW1

(SQL View)
Index Back

No Name Translation View 1

Join of NAME_NOXLAT_TBL and installed languages from PSLANGUAGES.

SELECT A.LANGUAGE_CD , A.HCR_SOURCE_IND FROM PS_NAME_NOXLAT_TBL A , PSLANGUAGES B WHERE A.HCR_NO_TRANSLATION = 'Y' AND B.LANGUAGE_CD = A.LANGUAGE_CD AND B.INSTALLED = 1

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

Prompt Table: PSLANGUAGES

2 HCR_SOURCE_IND Character(1) VARCHAR2(1) NOT NULL Source indicator.

Y/N Table Edit

Default Value: N