P6_ERR_OBJM_VW

(SQL View)
 Index Back

P6 Transform Error Objects-M

P6 Transform Error Objects for Master Data.. P6_OBJECT_IDENT.

SELECT DISTINCT 'M' , L.P6_OBJECT_IDENT , X.XLATLONGNAME FROM PS_P6_ERROR_LOG L , PSXLATITEM X WHERE X.FIELDNAME = 'P6_OBJECT_IDENT' AND X.FIELDVALUE = L.P6_OBJECT_IDENT AND X.EFFDT = ( SELECT MAX(X1.EFFDT) FROM PSXLATITEM X1 WHERE X.FIELDNAME = X1.FIELDNAME AND X.FIELDVALUE = X1.FIELDVALUE AND X.EFFDT <= %CurrentDateIn) AND L.P6_OBJECT_IDENT IN ('0300', '0400')

  • Related Language Record: P6_ERR_OBJ_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_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 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name