NAME_NOXLAT_VW

(SQL View)
 Index Back

No Name Translation View

View showing all installed languages and the ones selected for no name translation. This view is used to populate the grid on the NAME_NOXLAT_TBL page.

SELECT A.LANGUAGE_CD , A.HCR_NO_TRANSLATION , A.HCR_SOURCE_IND FROM PS_NAME_NOXLAT_TBL A , PSLANGUAGES B WHERE B.LANGUAGE_CD = A.LANGUAGE_CD AND B.INSTALLED = 1 UNION SELECT A.LANGUAGE_CD , 'N' , 'N' FROM PSLANGUAGES A WHERE A.INSTALLED = 1 AND NOT EXISTS ( SELECT 'X' FROM PS_NAME_NOXLAT_TBL B WHERE B.LANGUAGE_CD = A.LANGUAGE_CD)

# 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_NO_TRANSLATION Character(1) VARCHAR2(1) NOT NULL Indicates whether or not the data should be translated.

Y/N Table Edit

Default Value: N

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

Y/N Table Edit

Default Value: N