PHONE_TYPE_VW

(SQL View)
 Index Back

Phone Type - Type control

SS Phone types with type control

SELECT X.FIELDVALUE , X.XLATLONGNAME FROM PSXLATITEM X WHERE X.FIELDNAME = 'PHONE_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: PHONE_TYPE_VWL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PHONE_TYPE Character(4) VARCHAR2(4) NOT NULL Phone Type
    BUSN=Business
    CAMP=Campus
    CELL=Mobile
    DORM=Dormitory
    FAX=FAX
    HOME=Home
    MAIN=Main
    OTR=Other
    PGR1=Pager 1
    PGR2=Pager 2
    TELX=Telex
    WORK=Work
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description