P6_ERR_MCNT2_VW

(SQL View)
 Index Back

Transform map error count-Mst

Transform map error count - Master Data.

SELECT A.P6_INTEGRATE_TYPE , A.P6_ERROR_TYPE , B.OPRID , B.RUN_CNTL_ID , B.PROC_INSTANCE_SYNC , B.RQSTDTTM , A.PROCESS_INSTANCE , A.BUSINESS_UNIT , A.EOTF_MAP_NAME , A.P6_FIELDNAME_S01 , A.P6_VALUE_S01 , A.P6_VALUE_S02 , A.P6_VALUE_S03 , A.P6_VALUE_S04 , A.P6_VALUE_S05 , A.P6_VALUE_S06 , A.P6_VALUE_S07 , A.P6_VALUE_S08 , A.P6_VALUE_S09 , A.P6_VALUE_S10 , A.P6_VALUE_S11 , A.P6_VALUE_S12 , A.P6_VALUE_S13 , A.P6_VALUE_S14 , A.P6_VALUE_S15 , A.P6_FLDCNT_SOURCE , COUNT(*) FROM PS_P6_ERROR_LOG A , PS_P6_SYNC_HD_MST B WHERE A.OPRID = B.OPRID AND A.RUN_CNTL_ID = B.RUN_CNTL_ID AND A.PROC_INSTANCE_SYNC = B.PROC_INSTANCE_SYNC GROUP BY A.P6_INTEGRATE_TYPE, A.P6_ERROR_TYPE, B.OPRID, B.RUN_CNTL_ID, B.PROC_INSTANCE_SYNC, B.RQSTDTTM, A.PROCESS_INSTANCE, A.BUSINESS_UNIT, A.EOTF_MAP_NAME, A.P6_FIELDNAME_S01, A.P6_VALUE_S01, A.P6_VALUE_S02, A.P6_VALUE_S03, A.P6_VALUE_S04, A.P6_VALUE_S05, A.P6_VALUE_S06, A.P6_VALUE_S07, A.P6_VALUE_S08, A.P6_VALUE_S09, A.P6_VALUE_S10, A.P6_VALUE_S11, A.P6_VALUE_S12, A.P6_VALUE_S13, A.P6_VALUE_S14, A.P6_VALUE_S15, A.P6_FLDCNT_SOURCE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 P6_INTEGRATE_TYPE Character(1) VARCHAR2(1) NOT NULL Integration Type
I=Inbound
O=Outbound
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 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
4 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
5 PROC_INSTANCE_SYNC Number(10,0) DECIMAL(10) NOT NULL Process Instance Sync
6 RQSTDTTM DateTime(26) TIMESTAMP Request Date/Time
7 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
8 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
9 EOTF_MAP_NAME Character(150) VARCHAR2(150) NOT NULL Map Name
10 P6_FIELDNAME_S01 Character(18) VARCHAR2(18) NOT NULL Source Field Name 1
11 P6_VALUE_S01 Character(254) VARCHAR2(254) NOT NULL Source Value 1
12 P6_VALUE_S02 Character(254) VARCHAR2(254) NOT NULL Source Value 2
13 P6_VALUE_S03 Character(254) VARCHAR2(254) NOT NULL Source Value 3
14 P6_VALUE_S04 Character(254) VARCHAR2(254) NOT NULL Source Value 4
15 P6_VALUE_S05 Character(254) VARCHAR2(254) NOT NULL Source Value 5
16 P6_VALUE_S06 Character(254) VARCHAR2(254) NOT NULL Source Value 6
17 P6_VALUE_S07 Character(128) VARCHAR2(128) NOT NULL Source Value 7
18 P6_VALUE_S08 Character(128) VARCHAR2(128) NOT NULL Source Value 8
19 P6_VALUE_S09 Character(128) VARCHAR2(128) NOT NULL Source Value 9
20 P6_VALUE_S10 Character(128) VARCHAR2(128) NOT NULL Source Value 10
21 P6_VALUE_S11 Character(128) VARCHAR2(128) NOT NULL Source Value 11
22 P6_VALUE_S12 Character(64) VARCHAR2(64) NOT NULL Source Value 12
23 P6_VALUE_S13 Character(64) VARCHAR2(64) NOT NULL Source Value 13
24 P6_VALUE_S14 Character(64) VARCHAR2(64) NOT NULL Source Value 14
25 P6_VALUE_S15 Character(64) VARCHAR2(64) NOT NULL Source Value 15
26 P6_FLDCNT_SOURCE Number(3,0) SMALLINT NOT NULL Source Field Count
27 P6_ERROR_COUNT Number(10,0) DECIMAL(10) NOT NULL Error Count