Call Log field specifications
This table lists the field-column specifications in the Call Log import interface. Fields with the asterisk (*) symbol are required.
| Col. | Field Name | Type | Size/Format | Description |
|---|---|---|---|---|
| 1 | SHIFTSUM_ID* | Number | 22 | The Shift Summary ID number from the ES_SHIFT_SUMMARY table. |
| 2 | EMP_ID* | Number | 22 | The Employee ID number from the EMPLOYEE table. |
| 3 | WBU_ID | Number | 22 | The Workbrain User ID from the WORKBRAIN_USER table. |
| 4 | REASON_ID | Number | 22 | The Reason ID number from the ES_REASON table. |
| 5 | CLOG_ACTION* | Varchar2 | 40 | The Call Log action. |
| 6 | CLOG_SHIFTDTL_START_TIME | Date | yyyy-MM-dd HH:mm:ss | The Call Log Shift Detail Start Time. |
| 7 | CLOG_SHIFTDTL_END_TIME | Date | yyyy-MM-dd HH:mm:ss | The Call Log Shift Detail End Time. |
| 8 | CLOG_FLAG1 | Varchar2 | 1 | One-character flag for general use. A {space} in one of the flag positions indicates no processing is to be done for that flag. An ampersand (&) in one of the flag positions indicates the flag is to be blanked. |
| 9 | CLOG_FLAG2 | Varchar2 | 1 | One-character flag for general use. |
| 10 | CLOG_FLAG3 | Varchar2 | 1 | One-character flag for general use. |
| 11 | CLOG_FLAG4 | Varchar2 | 1 | One-character flag for general use. |
| 12 | CLOG_FLAG5 | Varchar2 | 1 | One-character flag for general use. |
| 13 | CLOG_UDF1 | Varchar2 | 40 | User defined field. |
| 14 | CLOG_UDF2 | Varchar2 | 40 | User defined field. |
| 15 | CLOG_UDF3 | Varchar2 | 40 | User defined field. |
| 16 | CLOG_UDF4 | Varchar2 | 40 | User defined field. |
| 17 | CLOG_UDF5 | Varchar2 | 40 | User defined field. |