P6_ERR_OBJ_LVW

(SQL View)
 Index Back

Transform error objects

Transform error objects

SELECT DISTINCT L.P6_INTEGRATE_TYPE , L.P6_OBJECT_IDENT , X.LANGUAGE_CD , X.XLATLONGNAME FROM PS_P6_ERROR_LOG L , PSXLATITEMLANG X WHERE X.FIELDNAME = 'P6_OBJECT_IDENT' AND X.FIELDVALUE = L.P6_OBJECT_IDENT AND X.EFFDT = ( SELECT MAX(X1.EFFDT) FROM PSXLATITEMLANG X1 WHERE X.FIELDNAME = X1.FIELDNAME AND X.FIELDVALUE = X1.FIELDVALUE AND X.LANGUAGE_CD = X1.LANGUAGE_CD AND X.EFFDT <= %CurrentDateIn)

  • Related Language Record for P6_ERR_OBJM_VW P6_ERR_OBJT_VW P6_ERR_OBJ_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_OBJECT_IDENT Character(4) VARCHAR2(4) NOT NULL A unique value to identify each object.
    0000=Project Header
    0050=Project Team
    0100=Activities
    0200=Project Budget
    0300=Resources
    0400=Resource Rates
    0500=Resource Assignments
    0600=Timesheet
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name