FT_ERR_RPT_VW2 (SQL View)	Index Back
Error Type Description View to store long description of Fusion Integration error tpyes.

FT_ERR_RPT_VW2

(SQL View)

Error Type Description

View to store long description of Fusion Integration error tpyes.

SELECT B.FIELDVALUE , B.XLATLONGNAME FROM PSXLATITEM B WHERE B.fieldname = 'FT_ERROR_TYPE' AND B.EFF_STATUS = 'A' AND B.EFFDT = ( SELECT MAX(A.EFFDT) FROM PSXLATITEM A WHERE a.fieldvalue = B.FIELDVALUE AND a.fieldname = B.FIELDNAME AND A.EFFDT <= %CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 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

2 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	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
2	XLATLONGNAME	Character(30)	VARCHAR2(30) NOT NULL	Translate Long Name