FCT_CALL_INSIGHT

Database

INSNZP01_CL

Schema

CLPADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 SOURCE_ID INTEGER 4
2 CALL_ID INTEGER 4
3 CALL_START TIMESTAMP 8
4 CALL_END TIMESTAMP 8
5 CALL_DURATION INTEGER 4
6 CALL_DIRECTION CHARACTER VARYING(10) 10
7 COUNT_SEGMENTS INTEGER 4
8 SEGMENT_ID INTEGER 4
9 SEGMENT_START TIMESTAMP 8
10 SEGMENT_END TIMESTAMP 8
11 SEGMENT_DURATION INTEGER 4
12 GCIS_CUSTOMER_NUMBER INTEGER 4
13 GCIS_CUSTOMER_BRAND CHARACTER VARYING(10) 10
14 CUSTOMER_NUMBER INTEGER 4
15 ANSLOGIN CHARACTER VARYING(16) 16
16 CONSULTANT_UNUMBER CHARACTER VARYING(10) 10
17 LOCATION_NAME_TREESTAFF CHARACTER VARYING(255) 255
18 STATE_NAME_TREESTAFF CHARACTER VARYING(255) 255
19 REGION_NAME_TREESTAFF CHARACTER VARYING(255) 255
20 COUNTRY_NAME_TREESTAFF CHARACTER VARYING(255) 255
21 SPLIT_NUM INTEGER 4
22 ACD_ID INTEGER 4
23 SPLIT_NAME_TREESKILL CHARACTER VARYING(255) 255
24 QUEUE_NAME_SYNONYM CHARACTER VARYING(60) 60
25 REPORT_GROUP_NAME_TREESKILL CHARACTER VARYING(20) 20
26 BRAND_NAME_TREESKILL CHARACTER VARYING(255) 255
27 BRAND_GROUP_NAME_TREESKILL CHARACTER VARYING(255) 255
28 DEPARTMENT_NAME_TREESKILL CHARACTER VARYING(255) 255
29 HEAD_OF_CATEGORY_NAME_TREESKILL CHARACTER VARYING(255) 255
30 AREA_NAME_TREESKILL CHARACTER VARYING(255) 255
31 BU_NAME_TREESKILL CHARACTER VARYING(255) 255
32 FUNCTION_NAME_TREESKILL CHARACTER VARYING(255) 255
33 PRODUCT_NAME_TREESKILL CHARACTER VARYING(255) 255
34 PRODUCT_GROUPNAME_TREESKILL CHARACTER VARYING(255) 255
35 QUICK_ASSIST_TIMESTAMP TIMESTAMP 8
36 SEGSTART_DUP_RNK INTEGER 4
37 UCID CHARACTER VARYING(40) 40
38 ACWTIME INTEGER 4
39 AGT_RELEASED INTEGER 4
40 ANSHOLDTIME INTEGER 4
41 CONFERENCE INTEGER 4
42 CONSULTTIME INTEGER 4
43 DA_QUEUED INTEGER 4
44 DISPIVECTOR INTEGER 4
45 DISPOSITION INTEGER 4
46 DISPTIME INTEGER 4
47 DISPVDN CHARACTER VARYING(16) 16
48 FIRSTIVECTOR INTEGER 4
49 FIRSTVDN CHARACTER VARYING(16) 16
50 HELD INTEGER 4
51 HOLDABN INTEGER 4
52 ORIGHOLDTIME INTEGER 4
53 SPLIT1 INTEGER 4
54 SPLIT2 INTEGER 4
55 SPLIT3 INTEGER 4
56 TALKTIME INTEGER 4
57 TRANSFERRED INTEGER 4
58 QUEUETIME INTEGER 4
59 RINGTIME INTEGER 4