EMAIL_TYPE_SRVW

(SQL View)
 Index Back

SELECT A.FIELDVALUE , XLATLONGNAME FROM ( SELECT B.FIELDVALUE , B.XLATLONGNAME FROM PSXLATITEM B WHERE B.FIELDNAME= 'E_ADDR_TYPE') A, PS_TYPE_CNTL_EMAIL C WHERE A.FIELDVALUE=C.E_ADDR_TYPE AND C.TYPE_CONTROL NOT IN ('N','D')

  • Related Language Record: EMAILTYPXLVW_LN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 FIELDVALUE Character(4) VARCHAR2(4) NOT NULL Field Value
    2 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name