FT_INTEGRATE_TYPEI=Inbound
O=Outbound
FT_OBJECT_IDENTLANGUAGE_CDFT_ERR_OBJ_LVW(SQL View) |
Index Back |
|---|---|
Fusion transform error objectsFusion transform error objects |
| SELECT DISTINCT L.FT_INTEGRATE_TYPE , L.FT_OBJECT_IDENT , X.LANGUAGE_CD , X.XLATLONGNAME FROM PS_FT_ERROR_LOG L , PSXLATITEMLANG X WHERE X.FIELDNAME = 'FT_OBJECT_IDENT' AND X.FIELDVALUE = L.FT_OBJECT_IDENT AND X.EFFDT = ( SELECT MAX(X1.EFFDT) FROM PSXLATITEMLANG X1 WHERE X.FIELDNAME = X1.FIELDNAME AND X.FIELDVALUE = X1.FIELDVALUE AND X.LANGUAGE_CD = X1.LANGUAGE_CD 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 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | XLATLONGNAME | Character(30) | VARCHAR2(30) NOT NULL | Translate Long Name |