HCR_NM_TYP_LN_I

(SQL View)
 Index Back

Name Type Table (rel. Lang.)

Used to store Types of Names that a person can have and the order that they are displayed

SELECT A.NAME_TYPE ,A.LANGUAGE_CD ,A.NAME_TYPE_DESCR ,A.NAME_TYPE_SHORT FROM PS_NAME_TYPE_LNG A

  • Related Language Record for HCR_NM_TYP_I

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 NAME_TYPE Character(3) VARCHAR2(3) NOT NULL Type of Name
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 NAME_TYPE_DESCR Character(30) VARCHAR2(30) NOT NULL Name Type Description
    4 NAME_TYPE_SHORT Character(15) VARCHAR2(15) NOT NULL Short Name Type Description