EMAIL_TYP_VW

(SQL View)
 Index Back

Prompt view for Email Types

Prompt view for Email Types

SELECT FIELDVALUE , XLATLONGNAME FROM PS_HR_XLAT_EFF_VW WHERE FIELDNAME = 'E_ADDR_TYPE'

  • Related Language Record: EMAIL_TYP_VWL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 E_ADDR_TYPE Character(4) VARCHAR2(4) NOT NULL Email Type
    BUSN=Business
    CAMP=Campus
    DORM=Dormitory
    HOME=Home
    OTHR=Other
    2 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name