OBP24_FLX_OR_APPLICATION_METRIC_B

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 APPLICATION_ID CHARACTER VARYING(100) 100
2 APPLN_STATE CHARACTER VARYING(50) 50
3 APPLN_PREV_STATE CHARACTER VARYING(50) 50
4 CURR_PROCESS_STAGE CHARACTER VARYING(50) 50
5 WITHDRAW_SUBM_TRIGGER_STAGE CHARACTER VARYING(50) 50
6 APPLN_VERIFICATN_START TIMESTAMP 8
7 APPLN_VERIFICATN_END TIMESTAMP 8
8 APPLN_VERIFICATN_DURATION DOUBLE PRECISION 8
9 STRUCTURE_SOLN_START TIMESTAMP 8
10 STRUCTURE_SOLN_END TIMESTAMP 8
11 STRUCTURE_SOLN_DURATION DOUBLE PRECISION 8
12 LMI_PROCESSING_START TIMESTAMP 8
13 LMI_PROCESSING_END TIMESTAMP 8
14 LMI_PROCESSING_DURATION DOUBLE PRECISION 8
15 CCI_PROCESSING_START TIMESTAMP 8
16 CCI_PROCESSING_END TIMESTAMP 8
17 CCI_PROCESSING_DURATION DOUBLE PRECISION 8
18 OFFER_GEN_DISPATCH_START TIMESTAMP 8
19 OFFER_GEN_DISPATCH_END TIMESTAMP 8
20 OFFER_GEN_DISPATCH_DURATION DOUBLE PRECISION 8
21 OFFER_ACC_AND_EXEC_START TIMESTAMP 8
22 OFFER_ACC_AND_EXEC_END TIMESTAMP 8
23 OFFER_ACC_AND_EXEC_DURATION DOUBLE PRECISION 8
24 CREATE_ACCOUNT_START TIMESTAMP 8
25 CREATE_ACCOUNT_END TIMESTAMP 8
26 CREATE_ACCOUNT_DURATION DOUBLE PRECISION 8
27 SETTLEMENT_INSTR_START TIMESTAMP 8
28 SETTLEMENT_INSTR_END TIMESTAMP 8
29 SETTLEMENT_INSTR_DURATION DOUBLE PRECISION 8
30 REWORK_COUNT DOUBLE PRECISION 8
31 LAST_UPDATE_DATE TIMESTAMP 8
32 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
33 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
34 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
35 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8