SCC_EC_PHN_LNG

(SQL View)
Index Back

Phone Types by Employee.

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

SELECT A.EMPLID , A.PHONE_TYPE , B.LANGUAGE_CD , B.XLATLONGNAME FROM PS_PERSONAL_PHONE A LEFT OUTER JOIN PS_TYPE_CNTL_PHONE C ON A.PHONE_TYPE=C.PHONE_TYPE , XLATTABLE_LNG B WHERE B.FIELDNAME = 'PHONE_TYPE' AND B.FIELDVALUE = A.PHONE_TYPE AND %EffdtCheck(XLATTABLE_LNG B1, B, %CurrentDateIn) AND ((C.Type_Control <>'N' AND C.TYPE_CONTROL IS NOT NULL) OR c.Type_Control IS NULL)

  • Related Language Record for SCC_EC_PHN_TYP
  • # 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