SALU_TYPE_VW_LN

(SQL View)
 Index Back

Salutation Type table Rel Lang


SELECT A.SALUTATION_TYPE , A1.LANGUAGE_CD , A1.DESCR , A1.DESCRSHORT FROM PS_SALU_TYPE_HD A ,PS_SALU_TYPE_LANG A1 WHERE A.SALUTATION_TYPE = A1.SALUTATION_TYPE AND A.PEOPLE_RELATION1 <> 'SP'

  • Related Language Record for SALU_TYPE_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SALUTATION_TYPE Character(3) VARCHAR2(3) NOT NULL Salutation Type
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description