EMAIL_TYP_VWL

(SQL View)
 Index Back

Prompt view for Email Types

Prompt view for Email Types

SELECT B.FIELDVALUE , B.LANGUAGE_CD , B.XLATLONGNAME FROM PS_HR_XLAT_EFF_VW A , PSXLATITEMLANG B WHERE A.FIELDNAME = 'E_ADDR_TYPE' AND B.FIELDNAME = A.FIELDNAME AND B.FIELDVALUE = A.FIELDVALUE

  • Related Language Record for EMAIL_TYP_VW

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name