P6_ERR_MAPT_VW

(SQL View)
Index Back

P6 Map Errors - Timesheet Data

P6 Transform Map Errors - Timesheet Data

SELECT DISTINCT 'T' , P6_ERROR_TYPE , EOTF_MAP_NAME FROM PS_P6_ERROR_LOG WHERE P6_OBJECT_IDENT = '0600' UNION SELECT DISTINCT 'T' , ' ' , EOTF_MAP_NAME FROM PS_P6_ERROR_LOG WHERE P6_OBJECT_IDENT = '0600'

# 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