P6_ERR_TYPET_VW

(SQL View)
 Index Back

Transform ErrorTypes-Timesheet

Transform Error Types for Timesheet Data integration with P6.

SELECT DISTINCT 'T' , 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 = '0600'

  • Related Language Record: P6_ERR_TYPM_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