| 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 |