DIM_OBP_GENPACT_DATAENRICH_HANDLE_TIME

Database

SDSNZP05_BANK

Schema

BANKPADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 MAIN_SUBMISSION CHARACTER VARYING(20) 20
2 MAIN_UPDATEDATE DATE 4
3 START_TIME TIMESTAMP 8
4 GENPACT_START_HANDLE_TIME TIMESTAMP 8
5 GENPACT_START_OF_HANDLE_TIME TIMESTAMP 8
6 GENPACT_END_OF_HANDLE_TIME TIMESTAMP 8
7 END_TIME TIMESTAMP 8
8 GENPACT_START_OF_HANDLE_TIME_STATE CHARACTER VARYING(100) 100
9 GENPACT_START_OF_HANDLE_TIME_SUBSTATE CHARACTER VARYING(20) 20
10 GENPACT_START_OF_VERSION INTEGER 4
11 GENPACT_END_OF_HANDLE_TIME_STATE CHARACTER VARYING(100) 100
12 GENPACT_END_OF_HANDLE_TIME_SUBSTATE CHARACTER VARYING(20) 20
13 GENPACT_END_OF_VERSION INTEGER 4
14 MAIN_TITLE CHARACTER VARYING(500) 500
15 MAIN_OUTCOME CHARACTER VARYING(100) 100
16 MAIN_STATE CHARACTER VARYING(100) 100
17 MAIN_SUBSTATE CHARACTER VARYING(20) 20
18 START_HANDL_TIME_TITLE CHARACTER VARYING(500) 500
19 START_HANDL_TIME_OUTCOME CHARACTER VARYING(100) 100
20 START_HANDL_TIME_SUBSTATE CHARACTER VARYING(20) 20
21 START_HANDL_TIME_ASSIGNEESDISPLAYNAME CHARACTER VARYING(4000) 4000
22 START_HANDL_TIME_STATE CHARACTER VARYING(100) 100
23 START_SUBMISSION CHARACTER VARYING(20) 20
24 LAST_SUS_COMP_SUBMISSION CHARACTER VARYING(20) 20
25 ALL_SUB_ASSI_RES_SUBMISSION CHARACTER VARYING(20) 20
26 SUB_ASSI_RES_SUBMISSION CHARACTER VARYING(20) 20
27 ALL_SUB_SUSPENDED_SUBMISSION CHARACTER VARYING(20) 20