OBP24_HST_FLX_CS_VERIFICATIONS_H

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 VERIFICATION_ID CHARACTER VARYING(50) 50
2 HISTORY_ID CHARACTER VARYING(36) 36
3 ORIGINAL_STATUS CHARACTER VARYING(50) 50
4 FINAL_STATUS CHARACTER VARYING(50) 50
5 CREATED_BY CHARACTER VARYING(254) 254
6 CREATION_DATE TIMESTAMP 8
7 LAST_UPDATED_BY CHARACTER VARYING(254) 254
8 LAST_UPDATE_DATE TIMESTAMP 8
9 OBJECT_VERSION_NUMBER INTEGER 4
10 OBJECT_STATUS_FLAG CHARACTER(1) 1
11 VERIFICATION_TYPE_ID CHARACTER VARYING(24) 24
12 ENTITY_LINKAGE_TYPE CHARACTER VARYING(13) 13
13 ENTITY_REFERENCE CHARACTER VARYING(160) 160
14 STATUS CHARACTER VARYING(50) 50
15 EXPIRY_DATE TIMESTAMP 8
16 NATURE CHARACTER VARYING(1) 1
17 RECOMMENDATION CHARACTER VARYING(12) 12
18 COMMENTS CHARACTER VARYING(255) 255
19 AUTHORIZED_USER_COMMENTS CHARACTER VARYING(255) 255
20 CATEGORY_ID CHARACTER VARYING(8) 8
21 DOMAIN_OBJECT_EXTN CHARACTER VARYING(100) 100
22 IS_CONFIRMED CHARACTER(1) 1
23 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
24 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
25 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
26 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8