EMAIL_TYPE_VW

(SQL View)
 Index Back

Email Type - Type control

SS Email types with type control

SELECT X.FIELDVALUE ,X.XLATLONGNAME FROM PSXLATITEM X WHERE X.FIELDNAME = 'E_ADDR_TYPE' AND X.EFFDT =( SELECT MAX(X_ED.EFFDT) FROM PSXLATITEM X_ED WHERE X_ED.FIELDNAME = X.FIELDNAME AND X_ED.FIELDVALUE = X.FIELDVALUE AND X_ED.EFFDT <= %CurrentDateIn AND X_ED.EFF_STATUS = 'A') AND X.EFF_STATUS = 'A'

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