P6_INTG_DATA_TYPEM=Master Data
P=Project Data
T=Time Data
P6_OBJECT_IDENT0000=Project Header
0050=Project Team
0100=Activities
0200=Project Budget
0300=Resources
0400=Resource Rates
0500=Resource Assignments
0600=Timesheet
P6_ERR_OBJ_VW(SQL View) |
Index Back |
|---|---|
P6 transform error objectsP6 transform error objects. P6_OBJECT_IDENT. |
| SELECT DISTINCT 'P' , L.P6_OBJECT_IDENT , X.XLATLONGNAME FROM PS_P6_ERROR_LOG L , PSXLATITEM X WHERE X.FIELDNAME = 'P6_OBJECT_IDENT' AND X.FIELDVALUE = L.P6_OBJECT_IDENT AND X.EFFDT = ( SELECT MAX(X1.EFFDT) FROM PSXLATITEM X1 WHERE X.FIELDNAME = X1.FIELDNAME AND X.FIELDVALUE = X1.FIELDVALUE AND X.EFFDT <= %CurrentDateIn) AND L.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_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 |
| 3 | XLATLONGNAME | Character(30) | VARCHAR2(30) NOT NULL | Translate Long Name |