FCT_KOFAX_DOCUMENT_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(50) 50
6 STATE_NAME CHARACTER VARYING(50) 50
7 BRAND_ID INTEGER 4
8 BRAND_CODE CHARACTER VARYING(50) 50
9 BRAND_NAME CHARACTER VARYING(50) 50
10 PROCESS_TYPE_ID INTEGER 4
11 PROCESS_TYPE_CODE CHARACTER VARYING(50) 50
12 PROCESS_TYPE_NAME CHARACTER VARYING(50) 50
13 USER_ID INTEGER 4
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 INDEXING_ACTION_GROUP_ID INTEGER 4
24 INDEXING_ACTION_GROUP_CODE CHARACTER VARYING(128) 128
25 INDEXING_ACTION_GROUP_NAME CHARACTER VARYING(128) 128
26 INDEXING_ACTION_ID INTEGER 4
27 INDEXING_ACTION_CODE CHARACTER VARYING(128) 128
28 INDEXING_ACTION_NAME CHARACTER VARYING(128) 128
29 INDEXING_ACTION_DATETIME TIMESTAMP 8
30 INDEXING_ACTION_DATE DATE 4
31 INDEXING_ACTION_TIME TIME 8
32 INDEXING_ACTION_DATE_YEAR INTEGER 4
33 INDEXING_ACTION_DATE_YEAR_LABEL CHARACTER VARYING(13) 13
34 INDEXING_ACTION_DATE_QUARTER INTEGER 4
35 INDEXING_ACTION_DATE_QUARTER_LABEL CHARACTER VARYING(13) 13
36 INDEXING_ACTION_DATE_MONTH INTEGER 4
37 INDEXING_ACTION_DATE_MONTH_LABEL CHARACTER VARYING(13) 13
38 INDEXING_ACTION_DATE_DAY INTEGER 4
39 INDEXING_ACTION_DATE_DAY_LABEL CHARACTER VARYING(13) 13
40 INDEXING_ACTION_DATE_FIN_YEAR INTEGER 4
41 INDEXING_ACTION_DATE_FIN_YEAR_LABEL CHARACTER VARYING(13) 13
42 INDEXING_ACTION_DATE_FIN_QUARTER INTEGER 4
43 INDEXING_ACTION_DATE_FIN_QUARTER_LABEL CHARACTER VARYING(13) 13
44 INDEXING_ACTION_DATE_FIN_MONTH INTEGER 4
45 INDEXING_ACTION_DATE_FIN_MONTH_LABEL CHARACTER VARYING(13) 13
46 INDEXING_ACTION_DATE_FIN_DAY INTEGER 4
47 INDEXING_ACTION_DATE_FIN_DAY_LABEL CHARACTER VARYING(13) 13
48 INDEXING_ACTION_DATE_CURRENT_MONTH CHARACTER VARYING(8) 8
49 INDEXING_ACTION_DATE_PREVIOUS_MONTH CHARACTER VARYING(8) 8
50 INDEXING_ACTION_TIME_HOUR_KEY INTEGER 4
51 INDEXING_ACTION_TIME_HOUR_CODE INTEGER 4
52 INDEXING_ACTION_TIME_TWELVE_HOUR_CLOCK_HOUR_NUMBER INTEGER 4
53 INDEXING_ACTION_TIME_TWELVE_HOUR_CLOCK_HOUR_LABEL CHARACTER VARYING(9) 9
54 INDEXING_ACTION_TIME_TWELVE_HOUR_CLOCK_TIME_PERIOD_LABEL CHARACTER VARYING(9) 9
55 INDEXING_ACTION_TIME_TWENTY_FOUR_HOUR_CLOCK_HOUR_NUMBER INTEGER 4
56 INDEXING_ACTION_TIME_TWENTY_FOUR_HOUR_CLOCK_HOUR_LABEL CHARACTER VARYING(9) 9
57 INDEXING_ACTION_TIME_TWENTY_FOUR_HOUR_CLOCK_PADDED_HOUR_LABEL CHARACTER VARYING(9) 9
58 INDEXING_ACTION_TIME_THREE_HOUR_BAND_KEY INTEGER 4
59 INDEXING_ACTION_TIME_THREE_HOUR_BAND_CODE INTEGER 4
60 INDEXING_ACTION_TIME_THREE_HOUR_BAND_LOWER_LIMIT_NUMBER INTEGER 4
61 INDEXING_ACTION_TIME_THREE_HOUR_BAND_UPPER_LIMIT_NUMBER INTEGER 4
62 INDEXING_ACTION_TIME_THREE_HOUR_BAND_TWNENTY_FOUR_HOUR_LABEL CHARACTER VARYING(31) 31
63 INDEXING_ACTION_TIME_MINUTE_KEY INTEGER 4
64 INDEXING_ACTION_TIME_MINUTE_CODE INTEGER 4
65 INDEXING_ACTION_TIME_MINUTE_NUMBER INTEGER 4
66 INDEXING_ACTION_TIME_MINUTE_LABEL CHARACTER VARYING(9) 9
67 INDEXING_ACTION_TIME_MINUTE_PADDED_LABEL CHARACTER VARYING(9) 9
68 INDEXING_ACTION_TIME_HALF_HOUR_BAND_KEY INTEGER 4
69 INDEXING_ACTION_TIME_HALF_HOUR_BAND_CODE INTEGER 4
70 INDEXING_ACTION_TIME_HALF_HOUR_BAND_LOWER_LIMIT_NUMBER INTEGER 4
71 INDEXING_ACTION_TIME_HALF_HOUR_BAND_UPPER_LIMIT_NUMBER INTEGER 4
72 INDEXING_ACTION_TIME_HALF_HOUR_BAND_LABEL CHARACTER VARYING(31) 31
73 INDEXING_ACTION_TIME_QUARTER_HOUR_BAND_KEY INTEGER 4
74 INDEXING_ACTION_TIME_QUARTER_HOUR_BAND_CODE INTEGER 4
75 INDEXING_ACTION_TIME_QUARTER_HOUR_BAND_LOWER_LIMIT_NUMBER INTEGER 4
76 INDEXING_ACTION_TIME_QUARTER_HOUR_BAND_UPPER_LIMIT_NUMBER INTEGER 4
77 INDEXING_ACTION_TIME_QUARTER_HOUR_BAND_LABEL CHARACTER VARYING(31) 31
78 INDEXING_ACTION_TIME_FIVE_MINUTE_BAND_KEY INTEGER 4
79 INDEXING_ACTION_TIME_FIVE_MINUTE_BAND_CODE INTEGER 4
80 INDEXING_ACTION_TIME_FIVE_MINUTE_BAND_LOWER_LIMIT_NUMBER INTEGER 4
81 INDEXING_ACTION_TIME_FIVE_MINUTE_BAND_UPPER_LIMIT_NUMBER INTEGER 4
82 INDEXING_ACTION_TIME_FIVE_MINUTE_BAND_LABEL CHARACTER VARYING(31) 31
83 FINAL_NON_FINAL_INDEXING_INDICATOR CHARACTER VARYING(8) 8
84 DOCUMENTS_INDEXED_COUNT INTEGER 4