P6_ERR_CNT3_VW(SQL View) |
Index Back |
|---|---|
TransformError count-TimesheetP6 Transform Error count - Timesheet data |
| SELECT A.P6_INTEGRATE_TYPE , B.OPRID , B.RUN_CNTL_ID , B.PROC_INSTANCE_SYNC , B.RQSTDTTM , A.PROCESS_INSTANCE , A.P6_ERROR_TYPE , A.EOTF_MAP_NAME , A.P6_OBJECT_IDENT , A.BUSINESS_UNIT , A.PROJECT_ID , A.PROJECT_OBJECTID , 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 , A.P6_ALTERNATE_REC , A.P6_REQUIRED_FLAG , COUNT(*) FROM PS_P6_ERROR_LOG A , PS_P6_SYNC_HD_TIME 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 , B.OPRID, B.RUN_CNTL_ID , B.PROC_INSTANCE_SYNC, B.RQSTDTTM, A.PROCESS_INSTANCE , A.P6_ERROR_TYPE , A.EOTF_MAP_NAME , A.P6_OBJECT_IDENT , A.BUSINESS_UNIT , A.PROJECT_ID , A.PROJECT_OBJECTID , 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 , A.P6_ALTERNATE_REC , A.P6_REQUIRED_FLAG |
| # | 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 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 4 | PROC_INSTANCE_SYNC | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance Sync |
| 5 | RQSTDTTM | DateTime(26) | TIMESTAMP | Request Date/Time |
| 6 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 7 | 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 |
| 8 | EOTF_MAP_NAME | Character(150) | VARCHAR2(150) NOT NULL | Map Name |
| 9 | 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 |
| 10 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 11 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL | Project Id ChartField |
| 12 | PROJECT_OBJECTID | Number(10,0) | DECIMAL(10) NOT NULL | A unique ID that is the Project key to a corresponding table in an external system such as Primavera. |
| 13 | P6_FIELDNAME_S01 | Character(18) | VARCHAR2(18) NOT NULL | Source Field Name 1 |
| 14 | P6_VALUE_S01 | Character(254) | VARCHAR2(254) NOT NULL | Source Value 1 |
| 15 | P6_VALUE_S02 | Character(254) | VARCHAR2(254) NOT NULL | Source Value 2 |
| 16 | P6_VALUE_S03 | Character(254) | VARCHAR2(254) NOT NULL | Source Value 3 |
| 17 | P6_VALUE_S04 | Character(254) | VARCHAR2(254) NOT NULL | Source Value 4 |
| 18 | P6_VALUE_S05 | Character(254) | VARCHAR2(254) NOT NULL | Source Value 5 |
| 19 | P6_VALUE_S06 | Character(254) | VARCHAR2(254) NOT NULL | Source Value 6 |
| 20 | P6_VALUE_S07 | Character(128) | VARCHAR2(128) NOT NULL | Source Value 7 |
| 21 | P6_VALUE_S08 | Character(128) | VARCHAR2(128) NOT NULL | Source Value 8 |
| 22 | P6_VALUE_S09 | Character(128) | VARCHAR2(128) NOT NULL | Source Value 9 |
| 23 | P6_VALUE_S10 | Character(128) | VARCHAR2(128) NOT NULL | Source Value 10 |
| 24 | P6_VALUE_S11 | Character(128) | VARCHAR2(128) NOT NULL | Source Value 11 |
| 25 | P6_VALUE_S12 | Character(64) | VARCHAR2(64) NOT NULL | Source Value 12 |
| 26 | P6_VALUE_S13 | Character(64) | VARCHAR2(64) NOT NULL | Source Value 13 |
| 27 | P6_VALUE_S14 | Character(64) | VARCHAR2(64) NOT NULL | Source Value 14 |
| 28 | P6_VALUE_S15 | Character(64) | VARCHAR2(64) NOT NULL | Source Value 15 |
| 29 | P6_FLDCNT_SOURCE | Number(3,0) | SMALLINT NOT NULL | Source Field Count |
| 30 | P6_ALTERNATE_REC | Character(254) | VARCHAR2(254) NOT NULL | Source Record |
| 31 | P6_REQUIRED_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Required Field
N=No Y=Yes |
| 32 | P6_ERROR_COUNT | Number(10,0) | DECIMAL(10) NOT NULL | Error Count |