EE_PHON_TYP_LNG

(SQL View)
 Index Back

Phone Types by Employee.

Phone Types by Employee. Used as prompt record in EMERGENCY_CNTCT.

SELECT A.EMPLID , A.PHONE_TYPE , B.LANGUAGE_CD , B.XLATLONGNAME FROM PS_PERSONAL_PHONE A , XLATTABLE_LNG B WHERE B.FIELDNAME = 'PHONE_TYPE' AND B.FIELDVALUE = A.PHONE_TYPE AND B.EFFDT = ( SELECT MAX(B1.EFFDT) FROM XLATTABLE_LNG B1 WHERE B.FIELDNAME = B1.FIELDNAME AND B.FIELDVALUE = B1.FIELDVALUE AND B1.EFFDT <= %CurrentDateIn )

  • Related Language Record for EE_PHONE_TYP_VW SCC_PERPHNTY_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 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name