LS_PHON_TYPE_VW

(SQL View)
 Index Back

Translate View for SA

Used as a prompt table for SA. It has special list box characteristics which make it useful as a prompt table for all fields prompting against the translate table.

SELECT DISTINCT C.EMPLID , A.FIELDVALUE , A.EFFDT , A.EFF_STATUS , A.XLATLONGNAME , A.XLATSHORTNAME FROM PSXLATITEM A , PS_HCR_PERSON_I C WHERE A.FIELDNAME = 'PHONE_TYPE' AND %EffdtCheck(PSXLATITEM XL, A, %CurrentDateIn) AND A.EFF_STATUS = 'A' AND A.FIELDVALUE NOT IN ( SELECT PHONE_TYPE FROM PS_TYPE_CNTL_PHONE WHERE TYPE_CONTROL = 'N')

  • Related Language Record: LSPHONTYPEVW_LN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 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
    3 EFFDT Date(10) DATE Effective Date
    4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive
    5 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name
    6 XLATSHORTNAME Character(10) VARCHAR2(10) NOT NULL Translate Value Short Name