LSPHONETCVW_LN

(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 = 'PHONE_TYPE' AND %EffdtCheck(PSXLATITEMLANG XL, A, %CurrentDateIn) AND A.FIELDVALUE NOT IN ( SELECT PHONE_TYPE FROM PS_TYPE_CNTL_PHONE WHERE TYPE_CONTROL IN ('D','N'))

  • Related Language Record for LS_PHONE_TC_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 PHONE_TYPE Character(4) VARCHAR2(4) NOT NULL Phone Type
    BUSN=Business
    CAMP=Campus
    CELL=Mobile
    DORM=Dormitory
    FAX=FAX
    HOME=Home
    MAIN=Main
    OTR=Other
    PGR1=Pager 1
    PGR2=Pager 2
    TELX=Telex
    WORK=Work
    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