P6_ERR_MAP_VW

(SQL View)
Index Back

P6 Map Errors - Project Data

P6 Map Errors - Project Data.

SELECT DISTINCT 'P' , P6_ERROR_TYPE , EOTF_MAP_NAME FROM PS_P6_ERROR_LOG WHERE P6_OBJECT_IDENT IN ('0000','0100','0200','0500') UNION SELECT DISTINCT 'P' , ' ' , EOTF_MAP_NAME FROM PS_P6_ERROR_LOG WHERE P6_OBJECT_IDENT IN ('0000','0100','0200','0500')

# 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 EOTF_MAP_NAME Character(150) VARCHAR2(150) NOT NULL Map Name