OBP24_HST_FLX_PI_KYC_HISTORIES_B

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 PARTY_ID CHARACTER VARYING(40) 40
2 SRL_NO NUMERIC(30,0) 19
3 MANUAL_KYC_STATUS CHARACTER(3) 3
4 AUTOMATIC_KYC_STATUS CHARACTER(3) 3
5 KYC_STATUS CHARACTER(3) 3
6 MANUAL_KYC_PROCESS_STATUS CHARACTER(3) 3
7 AUTOMATIC_KYC_PROCESS_STATUS CHARACTER(3) 3
8 CONDITION CHARACTER VARYING(3) 3
9 INITIATION_DATE TIMESTAMP 8
10 MANUAL_KYC_DATE TIMESTAMP 8
11 AUTOMATIC_KYC_DATE TIMESTAMP 8
12 MANUAL_KYC_COMMENTS CHARACTER VARYING(300) 300
13 AUTOMATIC_KYC_COMMENTS CHARACTER VARYING(300) 300
14 MANUAL_KYC_BY CHARACTER VARYING(64) 64
15 EXPIRY_DATE TIMESTAMP 8
16 FLG_OVERRIDDEN CHARACTER(1) 1
17 OVERRIDDEN_REASON_TXT CHARACTER VARYING(300) 300
18 CREATED_BY CHARACTER VARYING(254) 254
19 CREATION_DATE TIMESTAMP 8
20 LAST_UPDATED_BY CHARACTER VARYING(254) 254
21 LAST_UPDATE_DATE TIMESTAMP 8
22 OBJECT_VERSION_NUMBER INTEGER 4
23 OBJECT_STATUS_FLAG CHARACTER(1) 1
24 DETERMINANT_VALUE CHARACTER VARYING(60) 60
25 DOMAIN_OBJECT_EXTN CHARACTER VARYING(100) 100
26 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
27 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
28 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
29 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8