FCT_KOFAX_DOCUMENT_PROCESSING_INSIGHT

Database

INSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 BATCHID INTEGER 4
2 DOCNUMBER INTEGER 4
3 ROOTBATCHID INTEGER 4
4 BATCH_NAME CHARACTER VARYING(128) 128
5 CLAIM_NUMBER CHARACTER VARYING(2000) 2000
6 PENTAHO_RECEIVED_DATETIME TIMESTAMP 8
7 PENTAHO_RECEIVED_DATE_YEAR INTEGER 4
8 PENTAHO_RECEIVED_DATE_YEAR_LABEL CHARACTER VARYING(13) 13
9 PENTAHO_RECEIVED_DATE_QUARTER INTEGER 4
10 PENTAHO_RECEIVED_DATE_QUARTER_LABEL CHARACTER VARYING(13) 13
11 PENTAHO_RECEIVED_DATE_MONTH INTEGER 4
12 PENTAHO_RECEIVED_DATE_MONTH_LABEL CHARACTER VARYING(13) 13
13 PENTAHO_RECEIVED_DATE_DAY INTEGER 4
14 PENTAHO_RECEIVED_DATE_DAY_LABEL CHARACTER VARYING(13) 13
15 PENTAHO_RECEIVED_DATE_FIN_YEAR INTEGER 4
16 PENTAHO_RECEIVED_DATE_FIN_YEAR_LABEL CHARACTER VARYING(13) 13
17 PENTAHO_RECEIVED_DATE_FIN_QUARTER INTEGER 4
18 PENTAHO_RECEIVED_DATE_FIN_QUARTER_LABEL CHARACTER VARYING(13) 13
19 PENTAHO_RECEIVED_DATE_FIN_MONTH INTEGER 4
20 PENTAHO_RECEIVED_DATE_FIN_MONTH_LABEL CHARACTER VARYING(13) 13
21 PENTAHO_RECEIVED_DATE_FIN_DAY INTEGER 4
22 PENTAHO_RECEIVED_DATE_FIN_DAY_LABEL CHARACTER VARYING(13) 13
23 PENTAHO_RECEIVED_DATE_CURRENT_MONTH CHARACTER VARYING(8) 8
24 PENTAHO_RECEIVED_DATE_PREVIOUS_MONTH CHARACTER VARYING(8) 8
25 PENTAHO_RECEIVED_TIME_HOUR_KEY INTEGER 4
26 PENTAHO_RECEIVED_TIME_HOUR_CODE INTEGER 4
27 PENTAHO_RECEIVED_TIME_TWELVE_HOUR_CLOCK_HOUR_NUMBER INTEGER 4
28 PENTAHO_RECEIVED_TIME_TWELVE_HOUR_CLOCK_HOUR_LABEL CHARACTER VARYING(9) 9
29 PENTAHO_RECEIVED_TIME_TWELVE_HOUR_CLOCK_TIME_PERIOD_LABEL CHARACTER VARYING(9) 9
30 PENTAHO_RECEIVED_TIME_TWENTY_FOUR_HOUR_CLOCK_HOUR_NUMBER INTEGER 4
31 PENTAHO_RECEIVED_TIME_TWENTY_FOUR_HOUR_CLOCK_HOUR_LABEL CHARACTER VARYING(9) 9
32 PENTAHO_RECEIVED_TIME_TWENTY_FOUR_HOUR_CLOCK_PADDED_HOUR_LABEL CHARACTER VARYING(9) 9
33 PENTAHO_RECEIVED_TIME_THREE_HOUR_BAND_KEY INTEGER 4
34 PENTAHO_RECEIVED_TIME_THREE_HOUR_BAND_CODE INTEGER 4
35 PENTAHO_RECEIVED_TIME_THREE_HOUR_BAND_LOWER_LIMIT_NUMBER INTEGER 4
36 PENTAHO_RECEIVED_TIME_THREE_HOUR_BAND_UPPER_LIMIT_NUMBER INTEGER 4
37 PENTAHO_RECEIVED_TIME_THREE_HOUR_BAND_TWNENTY_FOUR_HOUR_LABEL CHARACTER VARYING(31) 31
38 PENTAHO_RECEIVED_TIME_MINUTE_KEY INTEGER 4
39 PENTAHO_RECEIVED_TIME_MINUTE_CODE INTEGER 4
40 PENTAHO_RECEIVED_TIME_MINUTE_NUMBER INTEGER 4
41 PENTAHO_RECEIVED_TIME_MINUTE_LABEL CHARACTER VARYING(9) 9
42 PENTAHO_RECEIVED_TIME_MINUTE_PADDED_LABEL CHARACTER VARYING(9) 9
43 PENTAHO_RECEIVED_TIME_HALF_HOUR_BAND_KEY INTEGER 4
44 PENTAHO_RECEIVED_TIME_HALF_HOUR_BAND_CODE INTEGER 4
45 PENTAHO_RECEIVED_TIME_HALF_HOUR_BAND_LOWER_LIMIT_NUMBER INTEGER 4
46 PENTAHO_RECEIVED_TIME_HALF_HOUR_BAND_UPPER_LIMIT_NUMBER INTEGER 4
47 PENTAHO_RECEIVED_TIME_HALF_HOUR_BAND_LABEL CHARACTER VARYING(31) 31
48 PENTAHO_RECEIVED_TIME_QUARTER_HOUR_BAND_KEY INTEGER 4
49 PENTAHO_RECEIVED_TIME_QUARTER_HOUR_BAND_CODE INTEGER 4
50 PENTAHO_RECEIVED_TIME_QUARTER_HOUR_BAND_LOWER_LIMIT_NUMBER INTEGER 4
51 PENTAHO_RECEIVED_TIME_QUARTER_HOUR_BAND_UPPER_LIMIT_NUMBER INTEGER 4
52 PENTAHO_RECEIVED_TIME_QUARTER_HOUR_BAND_LABEL CHARACTER VARYING(31) 31
53 PENTAHO_RECEIVED_TIME_FIVE_MINUTE_BAND_KEY INTEGER 4
54 PENTAHO_RECEIVED_TIME_FIVE_MINUTE_BAND_CODE INTEGER 4
55 PENTAHO_RECEIVED_TIME_FIVE_MINUTE_BAND_LOWER_LIMIT_NUMBER INTEGER 4
56 PENTAHO_RECEIVED_TIME_FIVE_MINUTE_BAND_UPPER_LIMIT_NUMBER INTEGER 4
57 PENTAHO_RECEIVED_TIME_FIVE_MINUTE_BAND_LABEL CHARACTER VARYING(31) 31
58 PENTAHO_SCAN_DATETIME TIMESTAMP 8
59 PENTAHO_SCAN_DATE_YEAR INTEGER 4
60 PENTAHO_SCAN_DATE_YEAR_LABEL CHARACTER VARYING(13) 13
61 PENTAHO_SCAN_DATE_QUARTER INTEGER 4
62 PENTAHO_SCAN_DATE_QUARTER_LABEL CHARACTER VARYING(13) 13
63 PENTAHO_SCAN_DATE_MONTH INTEGER 4
64 PENTAHO_SCAN_DATE_MONTH_LABEL CHARACTER VARYING(13) 13
65 PENTAHO_SCAN_DATE_DAY INTEGER 4
66 PENTAHO_SCAN_DATE_DAY_LABEL CHARACTER VARYING(13) 13
67 PENTAHO_SCAN_DATE_FIN_YEAR INTEGER 4
68 PENTAHO_SCAN_DATE_FIN_YEAR_LABEL CHARACTER VARYING(13) 13
69 PENTAHO_SCAN_DATE_FIN_QUARTER INTEGER 4
70 PENTAHO_SCAN_DATE_FIN_QUARTER_LABEL CHARACTER VARYING(13) 13
71 PENTAHO_SCAN_DATE_FIN_MONTH INTEGER 4
72 PENTAHO_SCAN_DATE_FIN_MONTH_LABEL CHARACTER VARYING(13) 13
73 PENTAHO_SCAN_DATE_FIN_DAY INTEGER 4
74 PENTAHO_SCAN_DATE_FIN_DAY_LABEL CHARACTER VARYING(13) 13
75 PENTAHO_SCAN_DATE_CURRENT_MONTH CHARACTER VARYING(8) 8
76 PENTAHO_SCAN_DATE_PREVIOUS_MONTH CHARACTER VARYING(8) 8
77 PENTAHO_SCAN_TIME_HOUR_KEY INTEGER 4
78 PENTAHO_SCAN_TIME_HOUR_CODE INTEGER 4
79 PENTAHO_SCAN_TIME_TWELVE_HOUR_CLOCK_HOUR_NUMBER INTEGER 4
80 PENTAHO_SCAN_TIME_TWELVE_HOUR_CLOCK_HOUR_LABEL CHARACTER VARYING(9) 9
81 PENTAHO_SCAN_TIME_TWELVE_HOUR_CLOCK_TIME_PERIOD_LABEL CHARACTER VARYING(9) 9
82 PENTAHO_SCAN_TIME_TWENTY_FOUR_HOUR_CLOCK_HOUR_NUMBER INTEGER 4
83 PENTAHO_SCAN_TIME_TWENTY_FOUR_HOUR_CLOCK_HOUR_LABEL CHARACTER VARYING(9) 9
84 PENTAHO_SCAN_TIME_TWENTY_FOUR_HOUR_CLOCK_PADDED_HOUR_LABEL CHARACTER VARYING(9) 9
85 PENTAHO_SCAN_TIME_THREE_HOUR_BAND_KEY INTEGER 4
86 PENTAHO_SCAN_TIME_THREE_HOUR_BAND_CODE INTEGER 4
87 PENTAHO_SCAN_TIME_THREE_HOUR_BAND_LOWER_LIMIT_NUMBER INTEGER 4
88 PENTAHO_SCAN_TIME_THREE_HOUR_BAND_UPPER_LIMIT_NUMBER INTEGER 4
89 PENTAHO_SCAN_TIME_THREE_HOUR_BAND_TWNENTY_FOUR_HOUR_LABEL CHARACTER VARYING(31) 31
90 PENTAHO_SCAN_TIME_MINUTE_KEY INTEGER 4
91 PENTAHO_SCAN_TIME_MINUTE_CODE INTEGER 4
92 PENTAHO_SCAN_TIME_MINUTE_NUMBER INTEGER 4
93 PENTAHO_SCAN_TIME_MINUTE_LABEL CHARACTER VARYING(9) 9
94 PENTAHO_SCAN_TIME_MINUTE_PADDED_LABEL CHARACTER VARYING(9) 9
95 PENTAHO_SCAN_TIME_HALF_HOUR_BAND_KEY INTEGER 4
96 PENTAHO_SCAN_TIME_HALF_HOUR_BAND_CODE INTEGER 4
97 PENTAHO_SCAN_TIME_HALF_HOUR_BAND_LOWER_LIMIT_NUMBER INTEGER 4
98 PENTAHO_SCAN_TIME_HALF_HOUR_BAND_UPPER_LIMIT_NUMBER INTEGER 4
99 PENTAHO_SCAN_TIME_HALF_HOUR_BAND_LABEL CHARACTER VARYING(31) 31
100 PENTAHO_SCAN_TIME_QUARTER_HOUR_BAND_KEY INTEGER 4
101 PENTAHO_SCAN_TIME_QUARTER_HOUR_BAND_CODE INTEGER 4
102 PENTAHO_SCAN_TIME_QUARTER_HOUR_BAND_LOWER_LIMIT_NUMBER INTEGER 4
103 PENTAHO_SCAN_TIME_QUARTER_HOUR_BAND_UPPER_LIMIT_NUMBER INTEGER 4
104 PENTAHO_SCAN_TIME_QUARTER_HOUR_BAND_LABEL CHARACTER VARYING(31) 31
105 PENTAHO_SCAN_TIME_FIVE_MINUTE_BAND_KEY INTEGER 4
106 PENTAHO_SCAN_TIME_FIVE_MINUTE_BAND_CODE INTEGER 4
107 PENTAHO_SCAN_TIME_FIVE_MINUTE_BAND_LOWER_LIMIT_NUMBER INTEGER 4
108 PENTAHO_SCAN_TIME_FIVE_MINUTE_BAND_UPPER_LIMIT_NUMBER INTEGER 4
109 PENTAHO_SCAN_TIME_FIVE_MINUTE_BAND_LABEL CHARACTER VARYING(31) 31
110 KOFAX_INGESTION_DATETIME TIMESTAMP 8
111 KOFAX_INGESTION_DATE_YEAR INTEGER 4
112 KOFAX_INGESTION_DATE_YEAR_LABEL CHARACTER VARYING(13) 13
113 KOFAX_INGESTION_DATE_QUARTER INTEGER 4
114 KOFAX_INGESTION_DATE_QUARTER_LABEL CHARACTER VARYING(13) 13
115 KOFAX_INGESTION_DATE_MONTH INTEGER 4
116 KOFAX_INGESTION_DATE_MONTH_LABEL CHARACTER VARYING(13) 13
117 KOFAX_INGESTION_DATE_DAY INTEGER 4
118 KOFAX_INGESTION_DATE_DAY_LABEL CHARACTER VARYING(13) 13
119 KOFAX_INGESTION_DATE_FIN_YEAR INTEGER 4
120 KOFAX_INGESTION_DATE_FIN_YEAR_LABEL CHARACTER VARYING(13) 13
121 KOFAX_INGESTION_DATE_FIN_QUARTER INTEGER 4
122 KOFAX_INGESTION_DATE_FIN_QUARTER_LABEL CHARACTER VARYING(13) 13
123 KOFAX_INGESTION_DATE_FIN_MONTH INTEGER 4
124 KOFAX_INGESTION_DATE_FIN_MONTH_LABEL CHARACTER VARYING(13) 13
125 KOFAX_INGESTION_DATE_FIN_DAY INTEGER 4
126 KOFAX_INGESTION_DATE_FIN_DAY_LABEL CHARACTER VARYING(13) 13
127 KOFAX_INGESTION_DATE_CURRENT_MONTH CHARACTER VARYING(8) 8
128 KOFAX_INGESTION_DATE_PREVIOUS_MONTH CHARACTER VARYING(8) 8
129 KOFAX_INGESTION_TIME_HOUR_KEY INTEGER 4
130 KOFAX_INGESTION_TIME_HOUR_CODE INTEGER 4
131 KOFAX_INGESTION_TIME_TWELVE_HOUR_CLOCK_HOUR_NUMBER INTEGER 4
132 KOFAX_INGESTION_TIME_TWELVE_HOUR_CLOCK_HOUR_LABEL CHARACTER VARYING(9) 9
133 KOFAX_INGESTION_TIME_TWELVE_HOUR_CLOCK_TIME_PERIOD_LABEL CHARACTER VARYING(9) 9
134 KOFAX_INGESTION_TIME_TWENTY_FOUR_HOUR_CLOCK_HOUR_NUMBER INTEGER 4
135 KOFAX_INGESTION_TIME_TWENTY_FOUR_HOUR_CLOCK_HOUR_LABEL CHARACTER VARYING(9) 9
136 KOFAX_INGESTION_TIME_TWENTY_FOUR_HOUR_CLOCK_PADDED_HOUR_LABEL CHARACTER VARYING(9) 9
137 KOFAX_INGESTION_TIME_THREE_HOUR_BAND_KEY INTEGER 4
138 KOFAX_INGESTION_TIME_THREE_HOUR_BAND_CODE INTEGER 4
139 KOFAX_INGESTION_TIME_THREE_HOUR_BAND_LOWER_LIMIT_NUMBER INTEGER 4
140 KOFAX_INGESTION_TIME_THREE_HOUR_BAND_UPPER_LIMIT_NUMBER INTEGER 4
141 KOFAX_INGESTION_TIME_THREE_HOUR_BAND_TWNENTY_FOUR_HOUR_LABEL CHARACTER VARYING(31) 31
142 KOFAX_INGESTION_TIME_MINUTE_KEY INTEGER 4
143 KOFAX_INGESTION_TIME_MINUTE_CODE INTEGER 4
144 KOFAX_INGESTION_TIME_MINUTE_NUMBER INTEGER 4
145 KOFAX_INGESTION_TIME_MINUTE_LABEL CHARACTER VARYING(9) 9
146 KOFAX_INGESTION_TIME_MINUTE_PADDED_LABEL CHARACTER VARYING(9) 9
147 KOFAX_INGESTION_TIME_HALF_HOUR_BAND_KEY INTEGER 4
148 KOFAX_INGESTION_TIME_HALF_HOUR_BAND_CODE INTEGER 4
149 KOFAX_INGESTION_TIME_HALF_HOUR_BAND_LOWER_LIMIT_NUMBER INTEGER 4
150 KOFAX_INGESTION_TIME_HALF_HOUR_BAND_UPPER_LIMIT_NUMBER INTEGER 4
151 KOFAX_INGESTION_TIME_HALF_HOUR_BAND_LABEL CHARACTER VARYING(31) 31
152 KOFAX_INGESTION_TIME_QUARTER_HOUR_BAND_KEY INTEGER 4
153 KOFAX_INGESTION_TIME_QUARTER_HOUR_BAND_CODE INTEGER 4
154 KOFAX_INGESTION_TIME_QUARTER_HOUR_BAND_LOWER_LIMIT_NUMBER INTEGER 4
155 KOFAX_INGESTION_TIME_QUARTER_HOUR_BAND_UPPER_LIMIT_NUMBER INTEGER 4
156 KOFAX_INGESTION_TIME_QUARTER_HOUR_BAND_LABEL CHARACTER VARYING(31) 31
157 KOFAX_INGESTION_TIME_FIVE_MINUTE_BAND_KEY INTEGER 4
158 KOFAX_INGESTION_TIME_FIVE_MINUTE_BAND_CODE INTEGER 4
159 KOFAX_INGESTION_TIME_FIVE_MINUTE_BAND_LOWER_LIMIT_NUMBER INTEGER 4
160 KOFAX_INGESTION_TIME_FIVE_MINUTE_BAND_UPPER_LIMIT_NUMBER INTEGER 4
161 KOFAX_INGESTION_TIME_FIVE_MINUTE_BAND_LABEL CHARACTER VARYING(31) 31
162 KOFAX_COMPLETION_DATETIME TIMESTAMP 8
163 KOFAX_COMPLETION_DATE_YEAR INTEGER 4
164 KOFAX_COMPLETION_DATE_YEAR_LABEL CHARACTER VARYING(13) 13
165 KOFAX_COMPLETION_DATE_QUARTER INTEGER 4
166 KOFAX_COMPLETION_DATE_QUARTER_LABEL CHARACTER VARYING(13) 13
167 KOFAX_COMPLETION_DATE_MONTH INTEGER 4
168 KOFAX_COMPLETION_DATE_MONTH_LABEL CHARACTER VARYING(13) 13
169 KOFAX_COMPLETION_DATE_DAY INTEGER 4
170 KOFAX_COMPLETION_DATE_DAY_LABEL CHARACTER VARYING(13) 13
171 KOFAX_COMPLETION_DATE_FIN_YEAR INTEGER 4
172 KOFAX_COMPLETION_DATE_FIN_YEAR_LABEL CHARACTER VARYING(13) 13
173 KOFAX_COMPLETION_DATE_FIN_QUARTER INTEGER 4
174 KOFAX_COMPLETION_DATE_FIN_QUARTER_LABEL CHARACTER VARYING(13) 13
175 KOFAX_COMPLETION_DATE_FIN_MONTH INTEGER 4
176 KOFAX_COMPLETION_DATE_FIN_MONTH_LABEL CHARACTER VARYING(13) 13
177 KOFAX_COMPLETION_DATE_FIN_DAY INTEGER 4
178 KOFAX_COMPLETION_DATE_FIN_DAY_LABEL CHARACTER VARYING(13) 13
179 KOFAX_COMPLETION_DATE_CURRENT_MONTH CHARACTER VARYING(8) 8
180 KOFAX_COMPLETION_DATE_PREVIOUS_MONTH CHARACTER VARYING(8) 8
181 KOFAX_COMPLETION_TIME_HOUR_KEY INTEGER 4
182 KOFAX_COMPLETION_TIME_HOUR_CODE INTEGER 4
183 KOFAX_COMPLETION_TIME_TWELVE_HOUR_CLOCK_HOUR_NUMBER INTEGER 4
184 KOFAX_COMPLETION_TIME_TWELVE_HOUR_CLOCK_HOUR_LABEL CHARACTER VARYING(9) 9
185 KOFAX_COMPLETION_TIME_TWELVE_HOUR_CLOCK_TIME_PERIOD_LABEL CHARACTER VARYING(9) 9
186 KOFAX_COMPLETION_TIME_TWENTY_FOUR_HOUR_CLOCK_HOUR_NUMBER INTEGER 4
187 KOFAX_COMPLETION_TIME_TWENTY_FOUR_HOUR_CLOCK_HOUR_LABEL CHARACTER VARYING(9) 9
188 KOFAX_COMPLETION_TIME_TWENTY_FOUR_HOUR_CLOCK_PADDED_HOUR_LABEL CHARACTER VARYING(9) 9
189 KOFAX_COMPLETION_TIME_THREE_HOUR_BAND_KEY INTEGER 4
190 KOFAX_COMPLETION_TIME_THREE_HOUR_BAND_CODE INTEGER 4
191 KOFAX_COMPLETION_TIME_THREE_HOUR_BAND_LOWER_LIMIT_NUMBER INTEGER 4
192 KOFAX_COMPLETION_TIME_THREE_HOUR_BAND_UPPER_LIMIT_NUMBER INTEGER 4
193 KOFAX_COMPLETION_TIME_THREE_HOUR_BAND_TWNENTY_FOUR_HOUR_LABEL CHARACTER VARYING(31) 31
194 KOFAX_COMPLETION_TIME_MINUTE_KEY INTEGER 4
195 KOFAX_COMPLETION_TIME_MINUTE_CODE INTEGER 4
196 KOFAX_COMPLETION_TIME_MINUTE_NUMBER INTEGER 4
197 KOFAX_COMPLETION_TIME_MINUTE_LABEL CHARACTER VARYING(9) 9
198 KOFAX_COMPLETION_TIME_MINUTE_PADDED_LABEL CHARACTER VARYING(9) 9
199 KOFAX_COMPLETION_TIME_HALF_HOUR_BAND_KEY INTEGER 4
200 KOFAX_COMPLETION_TIME_HALF_HOUR_BAND_CODE INTEGER 4
201 KOFAX_COMPLETION_TIME_HALF_HOUR_BAND_LOWER_LIMIT_NUMBER INTEGER 4
202 KOFAX_COMPLETION_TIME_HALF_HOUR_BAND_UPPER_LIMIT_NUMBER INTEGER 4
203 KOFAX_COMPLETION_TIME_HALF_HOUR_BAND_LABEL CHARACTER VARYING(31) 31
204 KOFAX_COMPLETION_TIME_QUARTER_HOUR_BAND_KEY INTEGER 4
205 KOFAX_COMPLETION_TIME_QUARTER_HOUR_BAND_CODE INTEGER 4
206 KOFAX_COMPLETION_TIME_QUARTER_HOUR_BAND_LOWER_LIMIT_NUMBER INTEGER 4
207 KOFAX_COMPLETION_TIME_QUARTER_HOUR_BAND_UPPER_LIMIT_NUMBER INTEGER 4
208 KOFAX_COMPLETION_TIME_QUARTER_HOUR_BAND_LABEL CHARACTER VARYING(31) 31
209 KOFAX_COMPLETION_TIME_FIVE_MINUTE_BAND_KEY INTEGER 4
210 KOFAX_COMPLETION_TIME_FIVE_MINUTE_BAND_CODE INTEGER 4
211 KOFAX_COMPLETION_TIME_FIVE_MINUTE_BAND_LOWER_LIMIT_NUMBER INTEGER 4
212 KOFAX_COMPLETION_TIME_FIVE_MINUTE_BAND_UPPER_LIMIT_NUMBER INTEGER 4
213 KOFAX_COMPLETION_TIME_FIVE_MINUTE_BAND_LABEL CHARACTER VARYING(31) 31
214 PENTAHO_RECEIVED_TO_PENTAHO_SCAN_INTERVAL_BAND_ID INTEGER 4
215 PENTAHO_RECEIVED_TO_PENTAHO_SCAN_INTERVAL_BAND_LOWER_SECOND_LIMIT INTEGER 4
216 PENTAHO_RECEIVED_TO_PENTAHO_SCAN_INTERVAL_BAND_UPPER_SECOND_LIMIT INTEGER 4
217 PENTAHO_RECEIVED_TO_PENTAHO_SCAN_INTERVAL_BAND_LABEL CHARACTER VARYING(13) 13
218 PENTAHO_SCAN_TO_KOFAX_INGESTION_INTERVAL_BAND_ID INTEGER 4
219 PENTAHO_SCAN_TO_KOFAX_INGESTION_INTERVAL_BAND_LOWER_SECOND_LIMIT INTEGER 4
220 PENTAHO_SCAN_TO_KOFAX_INGESTION_INTERVAL_BAND_UPPER_SECOND_LIMIT INTEGER 4
221 PENTAHO_SCAN_TO_KOFAX_INGESTION_INTERVAL_BAND_LABEL CHARACTER VARYING(13) 13
222 KOFAX_INGESTION_TO_KOFAX_COMPLETION_INTERVAL_BAND_ID INTEGER 4
223 KOFAX_INGESTION_TO_KOFAX_COMPLETION_INTERVAL_BAND_LOWER_SECOND_LIMIT INTEGER 4
224 KOFAX_INGESTION_TO_KOFAX_COMPLETION_INTERVAL_BAND_UPPER_SECOND_LIMIT INTEGER 4
225 KOFAX_INGESTION_TO_KOFAX_COMPLETION_INTERVAL_BAND_LABEL CHARACTER VARYING(13) 13
226 PENTAHO_RECEIVED_TO_KOFAX_INGESTION_INTERVAL_BAND_ID INTEGER 4
227 PENTAHO_RECEIVED_TO_KOFAX_INGESTION_INTERVAL_BAND_LOWER_SECOND_LIMIT INTEGER 4
228 PENTAHO_RECEIVED_TO_KOFAX_INGESTION_INTERVAL_BAND_UPPER_SECOND_LIMIT INTEGER 4
229 PENTAHO_RECEIVED_TO_KOFAX_INGESTION_INTERVAL_BAND_LABEL CHARACTER VARYING(13) 13
230 END_TO_END_PROCESSING_INTERVAL_BAND_ID INTEGER 4
231 END_TO_END_PROCESSING_INTERVAL_BAND_LOWER_SECOND_LIMIT INTEGER 4
232 END_TO_END_PROCESSING_INTERVAL_BAND_UPPER_SECOND_LIMIT INTEGER 4
233 END_TO_END_PROCESSING_INTERVAL_BAND_LABEL CHARACTER VARYING(13) 13
234 DOCUMENT_TYPE_ID INTEGER 4
235 DOCUMENT_TYPE_CODE CHARACTER VARYING(2000) 2000
236 DOCUMENT_TYPE_NAME CHARACTER VARYING(2000) 2000
237 DOCUMENT_SUB_TYPE_ID INTEGER 4
238 DOCUMENT_SUB_TYPE_CODE CHARACTER VARYING(2000) 2000
239 DOCUMENT_SUB_TYPE_NAME CHARACTER VARYING(2000) 2000
240 LINE_OF_BUSINESS_ID INTEGER 4
241 LINE_OF_BUSINESS_CODE CHARACTER VARYING(50) 50
242 LINE_OF_BUSINESS_NAME CHARACTER VARYING(50) 50
243 STATE_ID INTEGER 4
244 STATE_CODE CHARACTER VARYING(2000) 2000
245 STATE_NAME CHARACTER VARYING(2000) 2000
246 BRAND_ID INTEGER 4
247 BRAND_CODE CHARACTER VARYING(2000) 2000
248 BRAND_NAME CHARACTER VARYING(2000) 2000
249 PROCESS_TYPE_ID INTEGER 4
250 PROCESS_TYPE_CODE CHARACTER VARYING(2000) 2000
251 PROCESS_TYPE_NAME CHARACTER VARYING(2000) 2000
252 PENTAHO_CHANNEL_ID INTEGER 4
253 PENTAHO_CHANNEL_CODE CHARACTER VARYING(2000) 2000
254 PENTAHO_CHANNEL_NAME CHARACTER VARYING(2000) 2000
255 USER_ID BIGINT 8
256 USER_CODE CHARACTER VARYING(31) 31
257 USER_DOMAIN_NAME CHARACTER VARYING(10) 10
258 USER_LOGIN_NAME CHARACTER VARYING(20) 20
259 USER_FIRST_NAME CHARACTER VARYING(100) 100
260 USER_LAST_NAME CHARACTER VARYING(100) 100
261 USER_FORMATTED_NAME CHARACTER VARYING(201) 201
262 RESOURCE_POOL_ID INTEGER 4
263 RESOURCE_POOL_CODE CHARACTER VARYING(9) 9
264 RESOURCE_POOL_NAME CHARACTER VARYING(9) 9
265 INDEXING_ACTION_GROUP_ID BIGINT 8
266 INDEXING_ACTION_GROUP_CODE CHARACTER VARYING(128) 128
267 INDEXING_ACTION_GROUP_NAME CHARACTER VARYING(128) 128
268 INDEXING_ACTION_ID BIGINT 8
269 INDEXING_ACTION_CODE CHARACTER VARYING(128) 128
270 INDEXING_ACTION_NAME CHARACTER VARYING(128) 128
271 DOCUMENT_PROCESSING_STATUS CHARACTER VARYING(9) 9
272 PENTAHO_RECEIVED_TO_PENTAHO_SCAN_SECONDS_INTERVAL BIGINT 8
273 PENTAHO_SCAN_TO_KOFAX_INGESTION_SECONDS_INTERVAL BIGINT 8
274 KOFAX_INGESTION_TO_KOFAX_COMPLETION_SECONDS_INTERVAL BIGINT 8
275 PENTAHO_RECEIVED_TO_KOFAX_INGESTION_SECONDS_INTERVAL BIGINT 8
276 END_TO_END_PROCESSING_SECONDS_INTERVAL BIGINT 8
277 DOCUMENT_COUNT INTEGER 4