FT_INTEGRATE_TYPEI=Inbound
O=Outbound
FT_OBJECT_IDENTFT_ERR_OBJ_VW(SQL View) |
Index Back |
|---|---|
Fusion transform error objectsFusion transform error objects |
| SELECT DISTINCT L.FT_INTEGRATE_TYPE , L.FT_OBJECT_IDENT , X.XLATLONGNAME FROM PS_FT_ERROR_LOG L , PSXLATITEM X WHERE X.FIELDNAME = 'FT_OBJECT_IDENT' AND X.FIELDVALUE = L.FT_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) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | FT_INTEGRATE_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Integration Type
I=Inbound O=Outbound |
| 2 | FT_OBJECT_IDENT |
Character(4) | VARCHAR2(4) NOT NULL | A unique value to identify each objects. Use the following ranges, 0000-0999 outbound 1000-1999 inbound |
| 3 | XLATLONGNAME | Character(30) | VARCHAR2(30) NOT NULL | Translate Long Name |