SAE_LDAP_NAMELN

(SQL View)
 Index Back

SAIP LDAP NAME LANGUAGE VIEW

SAIP LDAP NAME RELATED LANGUAGE VIEW

SELECT A.EMPLID ,A.NAME_TYPE ,B.LANGUAGE_CD ,B.NAME_TYPE_DESCR FROM %Table(HCR_PER_NAME_I) A ,%Table(NAME_TYPE_LNG) B WHERE A.EFF_STATUS = 'A' AND %EffdtCheck(HCR_PER_NAME_I A2, A, %CurrentDateIn) AND B.NAME_TYPE = A.NAME_TYPE

  • Related Language Record for SAE_LDAP_NAMEVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 NAME_TYPE Character(3) VARCHAR2(3) NOT NULL Type of Name
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 NAME_TYPE_DESCR Character(30) VARCHAR2(30) NOT NULL Name Type