HCR_TITLE_LN_I

(SQL View)
 Index Back

Rellang Title Table

Related Language table for the title table contain the possible title that can be found before a Surname.

SELECT A.TITLE ,A.LANGUAGE_CD ,A.EFFDT ,A.DESCR FROM PS_TITLE_TBL_LNG A

  • Related Language Record for HCR_TITLE_I

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 TITLE Character(35) VARCHAR2(35) NOT NULL Title
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description