P6_ERR_TYPE_VW

(SQL View)
 Index Back

Transform Error types-Project

Transform Error types - Project Data.

SELECT DISTINCT 'P' , L.P6_ERROR_TYPE , X.XLATLONGNAME , X.XLATSHORTNAME FROM PS_P6_ERROR_LOG L , PSXLATITEM X WHERE X.FIELDNAME = 'P6_ERROR_TYPE' AND X.FIELDVALUE = L.P6_ERROR_TYPE AND %EffdtCheck(PSXLATITEM X1, X, %CURRENTDATEIN) AND X.EFF_STATUS = 'A' AND L.P6_OBJECT_IDENT IN ('0000', '0100', '0200', '0500')

  • Related Language Record: P6_ERR_TYPE_LVW

    • # 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 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name
    4 XLATSHORTNAME Character(10) VARCHAR2(10) NOT NULL Translate Value Short Name