FT_ERR_RPT_VW4

(SQL View)
 Index Back

Error Reporting

Used with Transformation error reports

SELECT A.PROCESS_INSTANCE ,A.FT_INTEGRATE_TYPE ,A.FT_ERROR_TYPE , A.ft_value_s01 ,A.ft_value_s02 , a.ft_fieldname_s01 ,a.ft_fieldname_s02 , a.eotf_map_name , B.XLATLONGNAME , COUNT(*) FROM PS_FT_ERROR_LOG A , PSXLATITEM B WHERE a.ft_required_flag = 'Y' AND a.ft_object_ident = b.fieldvalue AND a.ft_fieldname_01 <> 'EMPLID' AND b.fieldname = 'FT_OBJECT_IDENT' GROUP BY A.PROCESS_INSTANCE,A.FT_INTEGRATE_TYPE,A.FT_ERROR_TYPE, A.ft_value_s01,A.ft_value_s02, a.ft_fieldname_s01, a.ft_fieldname_s02, a.eotf_map_name, B.XLATLONGNAME

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 FT_INTEGRATE_TYPE Character(1) VARCHAR2(1) NOT NULL Integration Type
I=Inbound
O=Outbound
3 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
4 FT_VALUE_S01 Character(254) VARCHAR2(254) NOT NULL Source Value 1
5 FT_VALUE_S02 Character(254) VARCHAR2(254) NOT NULL Source Value 2
6 FT_FIELDNAME_S01 Character(18) VARCHAR2(18) NOT NULL Source Field Name 1
7 FT_FIELDNAME_S02 Character(18) VARCHAR2(18) NOT NULL Source Field Name 2
8 EOTF_MAP_NAME Character(150) VARCHAR2(150) NOT NULL Map Name
9 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name
10 COUNT_EE Number(12,3) DECIMAL(11,3) NOT NULL Employee Count