TI_ERROR_LOG(SQL Table) |
Index Back |
|---|---|
Taleo Error Log TableTaleo Error Log Table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | TI_BUSINESS_OBJECT | Character(3) | VARCHAR2(3) NOT NULL |
Business Objects
C=Candidate CM=Candidate CU=Candidate J=Job Template L=Location N=New Hire O=Organization UE=User Employee |
| 2 | TI_ERROR_CODE | Character(5) | VARCHAR2(5) NOT NULL | Error Code |
| 3 | TI_IDENTIFIER | Character(60) | VARCHAR2(60) NOT NULL | Identifier |
| 4 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
| 5 | TI_INTEGRATE_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Peoplesoft to Taleo Integration Type
I=Inbound Data Synchronization O=Outbound Data Synchronization Default Value: O |
| 6 | TI_MESSAGE_KEY | Character(30) | VARCHAR2(30) NOT NULL | Peoplesoft Taleo Integration Message Key |
| 7 | TI_CORRELATION_KEY | Character(30) | VARCHAR2(30) NOT NULL | Peoplesoft Taleo Integration Message Key |
| 8 | FIELDNAME0 | Character(18) | VARCHAR2(18) NOT NULL | Name of Field |
| 9 | FIELDNAME1 | Character(18) | VARCHAR2(18) NOT NULL | Field Name 1 |
| 10 | FIELDNAME2 | Character(18) | VARCHAR2(18) NOT NULL | Field Name 2 |
| 11 | FIELDNAME3 | Character(18) | VARCHAR2(18) NOT NULL | Field Name 3 |
| 12 | FIELDNAME4 | Character(18) | VARCHAR2(18) NOT NULL | Field Name 4 |
| 13 | FIELDNAME5 | Character(18) | VARCHAR2(18) NOT NULL | Field Name 5 |
| 14 | TI_FIELDNAME6 | Character(18) | VARCHAR2(18) NOT NULL | TI_FIELDNAME6 |
| 15 | TI_FIELDNAME7 | Character(18) | VARCHAR2(18) NOT NULL | TI_FIELDNAME7 |
| 16 | TI_FIELDVALUE0 | Character(30) | VARCHAR2(30) NOT NULL | TI_FIELDVALUE0 |
| 17 | TI_FIELDVALUE1 | Character(30) | VARCHAR2(30) NOT NULL | TI_FIELDVALUE1 |
| 18 | TI_FIELDVALUE2 | Character(30) | VARCHAR2(30) NOT NULL | TI_FIELDVALUE2 |
| 19 | TI_FIELDVALUE3 | Character(30) | VARCHAR2(30) NOT NULL | TI_FIELDVALUE3 |
| 20 | TI_FIELDVALUE4 | Character(30) | VARCHAR2(30) NOT NULL | TI_FIELDVALUE4 |
| 21 | TI_FIELDVALUE5 | Character(30) | VARCHAR2(30) NOT NULL | TI_FIELDVALUE5 |
| 22 | TI_FIELDVALUE6 | Character(30) | VARCHAR2(30) NOT NULL | TI_FIELDVALUE6 |
| 23 | TI_FIELDVALUE7 | Character(30) | VARCHAR2(30) NOT NULL | TI_FIELDVALUE7 |
| 24 | TI_IS_WARNING | Character(1) | VARCHAR2(1) NOT NULL |
TI_IS_WARNING
N=Errors Y=Warnings |
| 25 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |