GM_PERS_EDLN_VW

(SQL View)
 Index Back

Accomplishments Related Lang

ACCOMPLISH_LANG is the language record related to ACCOMPLISHMENTS. A related language record enables text fields on a table to be translated into various languages for use in other countries.

SELECT A.EMPLID , A.ACCOMPLISHMENT , A.DT_ISSUED , A.LANGUAGE_CD , A.ISSUED_BY , A.EDUCATOR , A.SCHOOL , A.MAJOR FROM PS_ACCOMPLISH_LANG A

  • Related Language Record for GM_PERS_EDUC_VW

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

    Prompt Table: PERSONAL_DATA

    2 ACCOMPLISHMENT Character(8) VARCHAR2(8) NOT NULL Accomplishment

    Prompt Table: %RECNAME_EDIT

    3 DT_ISSUED Date(10) DATE Issue Date
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 ISSUED_BY Character(30) VARCHAR2(30) NOT NULL Issued By
    6 EDUCATOR Character(50) VARCHAR2(50) NOT NULL Educator
    7 SCHOOL Character(30) VARCHAR2(30) NOT NULL School Name
    8 MAJOR Character(30) VARCHAR2(30) NOT NULL Major