FCT_BNK_DATA_ENRICHMENT_SLA_TAT

Database

SDSNZP05_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 MAIN_SUBMISSION CHARACTER VARYING(20) 20
2 STAR_RATING CHARACTER VARYING(40) 40
3 MAIN_UPDATEDATE DATE 4
4 START_TIME TIMESTAMP 8
5 END_TIME TIMESTAMP 8
6 GENPACT_END_OF_HANDLE_TIME TIMESTAMP 8
7 GENPACT_START_OF_HANDLE_TIME TIMESTAMP 8
8 HANDLE_TIME INTERVAL 12
9 HANDLE_DAY_HOUR BIGINT 8
10 HANDLE_HOUR BIGINT 8
11 HANDLE_MIN NUMERIC(10,2) 19
12 HANDLE_SEC NUMERIC(14,4) 19
13 TOTAL_HANDLE_TIME NUMERIC(24,4) 19
14 START_OF_HANDLE_TIME_SUBMISSION CHARACTER VARYING(20) 20
15 END_OF_HANDLE_TIME_SUBMISSION CHARACTER VARYING(20) 20
16 TOTAL_PEN_HANDLE_TIME NUMERIC(38,4) 19