obp24_hst_flx_or_applicants

Database

prod_bank_wealth

Schema

sor_obp

Type

BASE TABLE

Description

 

Columns
# Name Data Type Length
1 applicant_id character varying 150
2 external_party_id character varying 120
3 internal_party_id character varying 120
4 applicant_status character varying 360
5 first_name character varying 762
6 last_name character varying 762
7 mobile_number character varying 150
8 email_id character varying 360
9 party_type character varying 150
10 applicant_serial_number character varying 6
11 is_primary_applicant character varying 3
12 is_existing_customer character varying 3
13 submission_id character varying 150
14 created_by character varying 762
15 creation_date timestamp without time zone
16 last_updated_by character varying 762
17 last_update_date timestamp without time zone
18 object_version_number integer 32
19 entity_status character varying 3
20 domain_object_extn character varying 300
21 signing_method character varying 150
22 name_of_power_of_attorney character varying 150
23 power_of_attorney_number character varying 45
24 date_of_power_of_attorney character varying 45
25 cdc_source_system_code character varying 12
26 cdc_record_type character varying 48
27 cdc_commit_timestamp timestamp without time zone
28 cdc_extract_timestamp timestamp without time zone