PSXPOUTDTLNG_VW

(SQL View)
Index Back

BIP Outdest Type View

Related language view for PSXPOUTDSTYP_VW

SELECT %Substring(B.FIELDVALUE, 1, 3) , L.LANGUAGE_CD , L.XLATSHORTNAME , L.XLATLONGNAME FROM PSXLATITEM B , PSXLATITEMLANG L WHERE B.FIELDNAME = 'OUTDESTTYPE' AND B.FIELDNAME = L.FIELDNAME AND B.FIELDVALUE = L.FIELDVALUE AND B.EFFDT = L.EFFDT AND B.FIELDVALUE IN ('0', '2', '3', '4', '5', '6')

  • Related Language Record for PSXPOUTDSTYP_VW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OUTDESTTYPE Character(3) VARCHAR2(3) NOT NULL Process Request output destination type.
    0=Any
    1=(None)
    2=File
    3=Printer
    4=Window
    5=Email
    6=Web
    7=Default
    8=Feed
    9=IB Node

    Default Value: 0

    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 XLATSHORTNAME Character(10) VARCHAR2(10) NOT NULL Translate Value Short Name
    4 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name