FCT_KOFAX_E2E_THROUGHPUT_INSIGHT

Database

INSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 LINE_OF_BUSINESS_ID INTEGER 4
2 LINE_OF_BUSINESS_CODE CHARACTER VARYING(50) 50
3 LINE_OF_BUSINESS_NAME CHARACTER VARYING(50) 50
4 STATE_ID INTEGER 4
5 STATE_CODE CHARACTER VARYING(255) 255
6 STATE_NAME CHARACTER VARYING(255) 255
7 BRAND_ID INTEGER 4
8 BRAND_CODE CHARACTER VARYING(255) 255
9 BRAND_NAME CHARACTER VARYING(255) 255
10 PROCESS_TYPE_ID INTEGER 4
11 PROCESS_TYPE_CODE CHARACTER VARYING(255) 255
12 PROCESS_TYPE_NAME CHARACTER VARYING(255) 255
13 USER_ID BIGINT 8
14 USER_CODE CHARACTER VARYING(31) 31
15 USER_DOMAIN_NAME CHARACTER VARYING(10) 10
16 USER_LOGIN_NAME CHARACTER VARYING(20) 20
17 USER_FIRST_NAME CHARACTER VARYING(100) 100
18 USER_LAST_NAME CHARACTER VARYING(100) 100
19 USER_FORMATTED_NAME CHARACTER VARYING(201) 201
20 RESOURCE_POOL_ID INTEGER 4
21 RESOURCE_POOL_CODE CHARACTER VARYING(9) 9
22 RESOURCE_POOL_NAME CHARACTER VARYING(9) 9
23 PRODUCTIVITY_GROUP_ID INTEGER 4
24 PRODUCTIVITY_GROUP_CODE CHARACTER VARYING(24) 24
25 PRODUCTIVITY_GROUP_NAME CHARACTER VARYING(24) 24
26 WORK_COMPLETED_DATETIME TIMESTAMP 8
27 WORK_COMPLETED_DATE DATE 4
28 WORK_COMPLETED_TIME TIME 8
29 WORK_COMPLETED_DATE_YEAR INTEGER 4
30 WORK_COMPLETED_DATE_YEAR_LABEL CHARACTER VARYING(13) 13
31 WORK_COMPLETED_DATE_QUARTER INTEGER 4
32 WORK_COMPLETED_DATE_QUARTER_LABEL CHARACTER VARYING(13) 13
33 WORK_COMPLETED_DATE_MONTH INTEGER 4
34 WORK_COMPLETED_DATE_MONTH_LABEL CHARACTER VARYING(13) 13
35 WORK_COMPLETED_DATE_DAY INTEGER 4
36 WORK_COMPLETED_DATE_DAY_LABEL CHARACTER VARYING(13) 13
37 WORK_COMPLETED_DATE_FIN_YEAR INTEGER 4
38 WORK_COMPLETED_DATE_FIN_YEAR_LABEL CHARACTER VARYING(13) 13
39 WORK_COMPLETED_DATE_FIN_QUARTER INTEGER 4
40 WORK_COMPLETED_DATE_FIN_QUARTER_LABEL CHARACTER VARYING(13) 13
41 WORK_COMPLETED_DATE_FIN_MONTH INTEGER 4
42 WORK_COMPLETED_DATE_FIN_MONTH_LABEL CHARACTER VARYING(13) 13
43 WORK_COMPLETED_DATE_FIN_DAY INTEGER 4
44 WORK_COMPLETED_DATE_FIN_DAY_LABEL CHARACTER VARYING(13) 13
45 WORK_COMPLETED_DATE_CURRENT_MONTH CHARACTER VARYING(8) 8
46 WORK_COMPLETED_DATE_PREVIOUS_MONTH CHARACTER VARYING(8) 8
47 WORK_COMPLETED_TIME_HOUR_KEY INTEGER 4
48 WORK_COMPLETED_TIME_HOUR_CODE INTEGER 4
49 WORK_COMPLETED_TIME_TWELVE_HOUR_CLOCK_HOUR_NUMBER INTEGER 4
50 WORK_COMPLETED_TIME_TWELVE_HOUR_CLOCK_HOUR_LABEL CHARACTER VARYING(9) 9
51 WORK_COMPLETED_TIME_TWELVE_HOUR_CLOCK_TIME_PERIOD_LABEL CHARACTER VARYING(9) 9
52 WORK_COMPLETED_TIME_TWENTY_FOUR_HOUR_CLOCK_HOUR_NUMBER INTEGER 4
53 WORK_COMPLETED_TIME_TWENTY_FOUR_HOUR_CLOCK_HOUR_LABEL CHARACTER VARYING(9) 9
54 WORK_COMPLETED_TIME_TWENTY_FOUR_HOUR_CLOCK_PADDED_HOUR_LABEL CHARACTER VARYING(9) 9
55 WORK_COMPLETED_TIME_THREE_HOUR_BAND_KEY INTEGER 4
56 WORK_COMPLETED_TIME_THREE_HOUR_BAND_CODE INTEGER 4
57 WORK_COMPLETED_TIME_THREE_HOUR_BAND_LOWER_LIMIT_NUMBER INTEGER 4
58 WORK_COMPLETED_TIME_THREE_HOUR_BAND_UPPER_LIMIT_NUMBER INTEGER 4
59 WORK_COMPLETED_TIME_THREE_HOUR_BAND_TWNENTY_FOUR_HOUR_LABEL CHARACTER VARYING(31) 31
60 WORK_COMPLETED_TIME_MINUTE_KEY INTEGER 4
61 WORK_COMPLETED_TIME_MINUTE_CODE INTEGER 4
62 WORK_COMPLETED_TIME_MINUTE_NUMBER INTEGER 4
63 WORK_COMPLETED_TIME_MINUTE_LABEL CHARACTER VARYING(9) 9
64 WORK_COMPLETED_TIME_MINUTE_PADDED_LABEL CHARACTER VARYING(9) 9
65 WORK_COMPLETED_TIME_HALF_HOUR_BAND_KEY INTEGER 4
66 WORK_COMPLETED_TIME_HALF_HOUR_BAND_CODE INTEGER 4
67 WORK_COMPLETED_TIME_HALF_HOUR_BAND_LOWER_LIMIT_NUMBER INTEGER 4
68 WORK_COMPLETED_TIME_HALF_HOUR_BAND_UPPER_LIMIT_NUMBER INTEGER 4
69 WORK_COMPLETED_TIME_HALF_HOUR_BAND_LABEL CHARACTER VARYING(31) 31
70 WORK_COMPLETED_TIME_QUARTER_HOUR_BAND_KEY INTEGER 4
71 WORK_COMPLETED_TIME_QUARTER_HOUR_BAND_CODE INTEGER 4
72 WORK_COMPLETED_TIME_QUARTER_HOUR_BAND_LOWER_LIMIT_NUMBER INTEGER 4
73 WORK_COMPLETED_TIME_QUARTER_HOUR_BAND_UPPER_LIMIT_NUMBER INTEGER 4
74 WORK_COMPLETED_TIME_QUARTER_HOUR_BAND_LABEL CHARACTER VARYING(31) 31
75 WORK_COMPLETED_TIME_FIVE_MINUTE_BAND_KEY INTEGER 4
76 WORK_COMPLETED_TIME_FIVE_MINUTE_BAND_CODE INTEGER 4
77 WORK_COMPLETED_TIME_FIVE_MINUTE_BAND_LOWER_LIMIT_NUMBER INTEGER 4
78 WORK_COMPLETED_TIME_FIVE_MINUTE_BAND_UPPER_LIMIT_NUMBER INTEGER 4
79 WORK_COMPLETED_TIME_FIVE_MINUTE_BAND_LABEL CHARACTER VARYING(31) 31
80 RESOLVED_REFERRED_INDICATOR CHARACTER VARYING(8) 8
81 DOCUMENT_BATCH_INDICATOR CHARACTER VARYING(8) 8
82 BATCHES_INDEXED_COUNT INTEGER 4
83 DOCUMENTS_INDEXED_COUNT INTEGER 4