P6_ERR_TYPM_LVW

(SQL View)
 Index Back

Transform Error types-Master

Transform Error types - Master Data.

SELECT DISTINCT 'M' , L.P6_ERROR_TYPE , X.LANGUAGE_CD , X.XLATLONGNAME , X.XLATSHORTNAME FROM PS_P6_ERROR_LOG L , PSXLATITEMLANG X WHERE X.FIELDNAME = 'P6_ERROR_TYPE' AND X.FIELDVALUE = L.P6_ERROR_TYPE AND %EffdtCheck(PSXLATITEMLANG X1, X, %CURRENTDATEIN) AND L.P6_OBJECT_IDENT IN ('0300', '0400')

  • Related Language Record for P6_ERR_TYPEM_VW P6_ERR_TYPET_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 P6_INTG_DATA_TYPE Character(1) VARCHAR2(1) NOT NULL Integration Data
    M=Master Data
    P=Project Data
    T=Time Data
    2 P6_ERROR_TYPE Character(4) VARCHAR2(4) NOT NULL Error types for Primavera extract
    DMAP=Unable to load DVM map
    DVM=Unable to map the DVM value(s)
    MOBJ=Missing reference object
    ROBJ=Bypassed Due to Parent 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