EMAIL_TYPE_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 AND B.EFFDT = (SELECT MAX(B_ED.EFFDT) FROM PSXLATITEMLANG B_ED WHERE B_ED.FIELDNAME = B.FIELDNAME AND B_ED.FIELDVALUE = B.FIELDVALUE AND B_ED.EFFDT <= %CURRENTDATEIN)

  • Related Language Record for EMAIL_TYPE_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 DESCR Character(30) VARCHAR2(30) NOT NULL Description