FT_ERR_MAP_VW (SQL View)	Index Back
Fusion extract error objects Fusion extract error objects

FT_ERR_MAP_VW

(SQL View)

Fusion extract error objects

SELECT DISTINCT FT_INTEGRATE_TYPE , FT_ERROR_TYPE , EOTF_MAP_NAME FROM PS_FT_ERROR_LOG UNION SELECT DISTINCT FT_INTEGRATE_TYPE , ' ' , EOTF_MAP_NAME FROM PS_FT_ERROR_LOG

# 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_ERROR_TYPE Character(4) VARCHAR2(4) NOT NULL Error types for fusion extract
BOBJ=Entire object bypassed
DMAP=Unable to load DVM map
DUPN=Duplicate Content Item Name
DVM=Unable to map the DVM value(s)
FOBJ=Object not supported by Fusion
MJOB=Employee with multiple jobs
MOBJ=Missing reference object
MSAL=Multiple Salary Bases
NTER=Termination row updates
OOBJ=Other Objects Bypassed
PNOV=Position override
POBJ=Object Bypassed By Parent
ROBJ=Reference to object in error
XMAP=Unable to load XREF map
XREF=Unable to map the XREF

3 EOTF_MAP_NAME Character(150) VARCHAR2(150) NOT NULL Map Name

#	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_ERROR_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Error types for fusion extract BOBJ=Entire object bypassed DMAP=Unable to load DVM map DUPN=Duplicate Content Item Name DVM=Unable to map the DVM value(s) FOBJ=Object not supported by Fusion MJOB=Employee with multiple jobs MOBJ=Missing reference object MSAL=Multiple Salary Bases NTER=Termination row updates OOBJ=Other Objects Bypassed PNOV=Position override POBJ=Object Bypassed By Parent ROBJ=Reference to object in error XMAP=Unable to load XREF map XREF=Unable to map the XREF
3	EOTF_MAP_NAME	Character(150)	VARCHAR2(150) NOT NULL	Map Name