LSEMALTCVW_LANG

(SQL View)
 Index Back

Rel Lang Translate View for SA

Used as a prompt table for SA. It has special list box characteristics which make it useful as a prompt table for all fields prompting against the translate table.

SELECT DISTINCT C.EMPLID , A.FIELDVALUE , A.LANGUAGE_CD , A.EFFDT , A.XLATLONGNAME , A.XLATSHORTNAME FROM PSXLATITEMLANG A , PS_HCR_PERSON_I C WHERE A.FIELDNAME = 'E_ADDR_TYPE' AND %EffdtCheck(PSXLATITEMLANG XL, A, %CurrentDateIn) AND A.FIELDVALUE NOT IN ( SELECT E_ADDR_TYPE FROM PS_TYPE_CNTL_EMAIL WHERE TYPE_CONTROL IN ('D', 'N'))

  • Related Language Record for LS_EMAL_TC_VW LS_EMAL_TC_VW_E

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 E_ADDR_TYPE Character(4) VARCHAR2(4) NOT NULL Email Address Type. Note: Dorm long name has been updated as Dormitory as part of PI26 updates. And, the owner id of the field is updated to CC from HR.
    BUSN=Business
    CAMP=Campus
    DORM=Dormitory
    HOME=Home
    OTHR=Other
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 EFFDT Date(10) DATE Effective Date
    5 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name
    6 XLATSHORTNAME Character(10) VARCHAR2(10) NOT NULL Translate Value Short Name