P6_ERR_MAP_VW(SQL View) |
Index Back |
---|---|
P6 Map Errors - Project DataP6 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 |