SALU_TYPE_VW

(SQL View)
 Index Back

Salutation Type table


SELECT A.SALUTATION_TYPE , A.DESCR , A.DESCRSHORT , A.PEOPLE_RELATION1 FROM PS_SALU_TYPE_HD A WHERE A.PEOPLE_RELATION1 <> 'SP'

  • Related Language Record: SALU_TYPE_VW_LN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SALUTATION_TYPE Character(3) VARCHAR2(3) NOT NULL Salutation Type
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    4 PEOPLE_RELATION1 Character(2) VARCHAR2(2) NOT NULL Relationship
    AL=All Relationships
    SP=Spouse Only