FT_ERR_ROWS(SQL Table) |
Index Back |
---|---|
Error Staging LogThis 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 |