obp24_hst_flx_pi_parties_b

Database

prod_bank_wealth

Schema

sor_obp

Type

BASE TABLE

Description

 

Columns
# Name Data Type Length
1 party_id character varying 120
2 party_type character varying 9
3 onboarding_date timestamp without time zone
4 alternate_party_id character varying 120
5 income_tax_number character varying 120
6 email_id character varying 360
7 web_site character varying 1080
8 bankruptcy_flag character varying 3
9 country_of_origin_id character varying 270
10 phone_country_code character varying 30
11 phone_area_code character varying 30
12 phone_number character varying 60
13 phone_extension character varying 30
14 onboarding_channel_id character varying 120
15 information_source_txt character varying 765
16 birth_place character varying 180
17 language_id character varying 90
18 birth_date timestamp without time zone
19 gender_type character varying 9
20 domicile character varying 150
21 nationality_id character varying 90
22 income_category_id character varying 90
23 mobile_country_code character varying 30
24 mobile_number character varying 135
25 non_resident_flag character varying 3
26 disabled_flag character varying 3
27 flg_bank_employee character varying 3
28 demise_date timestamp without time zone
29 height_in_cm double precision 53
30 weight_in_kg double precision 53
31 blood_group_type character varying 12
32 diseases_desc character varying 360
33 diseases character varying 360
34 mother_maiden_name character varying 360
35 industry_type character varying 150
36 occupation_type character varying 150
37 ethnicity character varying 90
38 race character varying 90
39 religion character varying 90
40 swift_id character varying 90
41 bic_id character varying 90
42 incorporation_date timestamp without time zone
43 commencement_date timestamp without time zone
44 holding_pattern_type character varying 9
45 place_of_incorporation character varying 270
46 country_incorporation character varying 270
47 employee_strength character varying 45
48 business_category_id character varying 90
49 no_years_in_business double precision 53
50 no_of_customers double precision 53
51 no_of_vendors double precision 53
52 countries_exposed_to_txt character varying 360
53 business_desc character varying 360
54 contact_person_name character varying 1080
55 contact_person_desig character varying 360
56 contact_person_email character varying 1080
57 contact_person_mobileno character varying 135
58 contact_person_landlineno character varying 360
59 smoking_indicator character varying 3
60 is_blacklisted character varying 3
61 trustee_type character varying 9
62 number_of_trustees smallint 16
63 number_of_directors smallint 16
64 has_listed_secretary character varying 3
65 no_of_shares_held bigint 64
66 flg_startup_business character varying 3
67 flg_owner_atleast_two_years character varying 3
68 flg_share_holder_of_bank character varying 3
69 ownership_percentage bigint 64
70 created_by character varying 762
71 creation_date timestamp without time zone
72 last_updated_by character varying 762
73 last_update_date timestamp without time zone
74 object_version_number integer 32
75 object_status_flag character varying 3
76 determinant_value character varying 120
77 retirement_date timestamp without time zone
78 emergency_contact_details character varying 900
79 flg_cust_delinquent character varying 3
80 flg_in_collections character varying 3
81 flg_financial_hardship character varying 3
82 relief_expiry_date timestamp without time zone
83 resident_status_id character varying 30
84 no_of_financial_dependents character varying 6
85 honors character varying 240
86 address_type character varying 15
87 relationship_manager_id character varying 90
88 relationship_manager_name character varying 765
89 preferred_contact_frequency character varying 60
90 preferred_contact character varying 90
91 work_phone_number character varying 135
92 organization_type character varying 30
93 organization_status character varying 150
94 abn_status_indicator character varying 150
95 organization_description character varying 150
96 ind_classification_code_desc character varying 1500
97 establishment_date timestamp without time zone
98 country_of_establishment character varying 150
99 cguid character varying 150
100 ind_classification_code character varying 150
101 corporate_type character varying 30
102 contract_details character varying 360
103 valuation_type_code character varying 360
104 valuation_asset_type character varying 360
105 contract_start_date timestamp without time zone
106 contract_end_date timestamp without time zone
107 no_of_branches double precision 53
108 disclose_res_dtls_flag character varying 3
109 residency_chng_date timestamp without time zone
110 foreign_country_for_tax character varying 270
111 foreign_country_tin character varying 120
112 party_status character varying 60
113 resident_country character varying 270
114 industry_category character varying 150
115 occupation_category character varying 150
116 flg_electronic_communication character varying 3
117 cdc_source_system_code character varying 12
118 cdc_record_type character varying 48
119 cdc_commit_timestamp timestamp without time zone
120 cdc_extract_timestamp timestamp without time zone