FT_ERR_ROWS

(SQL Table)
Index Back

Error Staging Log

This record stores key val;ues of the rows that comes under 'POBJ' & 'FOBJ' category

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 RECORDNAME Character(15) VARCHAR2(15) NOT NULL Record Name
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 KEY1 Character(65) VARCHAR2(65) NOT NULL First Key
4 KEY2 Character(65) VARCHAR2(65) NOT NULL Second Key
5 KEY3 Character(65) VARCHAR2(65) NOT NULL Third Key
6 KEY4 Character(65) VARCHAR2(65) NOT NULL Fourth Key
7 KEY5 Character(65) VARCHAR2(65) NOT NULL Fifth Key
8 KEY6 Character(65) VARCHAR2(65) NOT NULL Sixth Key
9 KEY7 Character(65) VARCHAR2(65) NOT NULL Seventh Key
10 FT_NUMKEY1 Number(12,0) DECIMAL(12) NOT NULL Number Key 1
11 FT_NUMKEY2 Number(12,0) DECIMAL(12) NOT NULL Number Key 2
12 FT_NUMKEY3 Number(12,0) DECIMAL(12) NOT NULL Number Key 1
13 FT_DTKEY1 Date(10) DATE Date Key Field 1
14 FT_DTKEY2 Date(10) DATE Date Key Field 2
15 FT_DTKEY3 Date(10) DATE Date Key Field 1
16 FT_ERR_LOG_ST Character(1) VARCHAR2(1) NOT NULL Log status of the Staging rows
17 FT_ALTERNATE_KEY Character(254) VARCHAR2(254) NOT NULL Alternate Key