SAE_LDAPNMUSGLN

(SQL View)
 Index Back

Name Usage Related Language

Related language view with a sub select to get the minimum name usage order for a given name usage, for each employee id. Keyed by employee id and name usage.

SELECT A.EMPLID , A.NAME_USAGE , B.LANGUAGE_CD , B.NAME_TYPE_DESCR FROM %Table(SCC_EQNM_USG_VW) A , %Table(NAME_TYPE_LNG) B WHERE B.NAME_TYPE = A.NAME_TYPE

  • Related Language Record for SAE_LDAPNMUSGVW

  • Parent record: HCR_PERSON_I

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: HCR_PERSON_I

    2 NAME_USAGE Character(10) VARCHAR2(10) NOT NULL Name Usage

    Prompt Table: NAME_USAGE_TBL

    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 NAME_TYPE_DESCR Character(30) VARCHAR2(30) NOT NULL Name Type