FT_ERR_TYPE_LVW

(SQL View)
 Index Back

Fusion extract error types

Fusion extract error types

SELECT DISTINCT L.FT_INTEGRATE_TYPE , L.FT_ERROR_TYPE , X.LANGUAGE_CD , X.XLATLONGNAME , X.XLATSHORTNAME FROM PS_FT_ERROR_LOG L , PSXLATITEMLANG X WHERE X.FIELDNAME = 'FT_ERROR_TYPE' AND X.FIELDVALUE = L.FT_ERROR_TYPE AND %EffdtCheck(PSXLATITEMLANG X1, X, %CURRENTDATEIN)

  • Related Language Record for FT_ERR_TYPE_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 FT_INTEGRATE_TYPE Character(1) VARCHAR2(1) NOT NULL Integration Type
    I=Inbound
    O=Outbound
    2 FT_ERROR_TYPE Character(4) VARCHAR2(4) NOT NULL Error types for fusion extract
    BOBJ=Entire object bypassed
    DMAP=Unable to load DVM map
    DUPN=Duplicate Content Item Name
    DVM=Unable to map the DVM value(s)
    FOBJ=Object not supported by Fusion
    MJOB=Employee with multiple jobs
    MOBJ=Missing reference object
    MSAL=Multiple Salary Bases
    NTER=Termination row updates
    OOBJ=Other Objects Bypassed
    PNOV=Position override
    POBJ=Object Bypassed By Parent
    ROBJ=Reference to object in error
    XMAP=Unable to load XREF map
    XREF=Unable to map the XREF
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name
    5 XLATSHORTNAME Character(10) VARCHAR2(10) NOT NULL Translate Value Short Name