obp24_hst_flx_pi_emp_profile

Database

prod_bank_wealth

Schema

sor_obp

Type

BASE TABLE

Description

 

Columns
# Name Data Type Length
1 profile_id character varying 90
2 party_id character varying 120
3 start_date timestamp without time zone
4 end_date timestamp without time zone
5 employer_name character varying 360
6 employer_address_line1_txt character varying 360
7 employer_address_line2_txt character varying 360
8 employer_address_line3_txt character varying 360
9 employer_address_line4_txt character varying 360
10 employer_address_line5_txt character varying 360
11 employer_address_line6_txt character varying 360
12 employer_address_line7_txt character varying 360
13 employer_address_line8_txt character varying 360
14 employer_address_state_id character varying 360
15 employer_address_country_id character varying 360
16 employer_address_city_id character varying 360
17 employer_address_zip_code character varying 360
18 ref_phone_country_code character varying 30
19 ref_phone_number character varying 90
20 ref_operator character varying 30
21 gross_income_amt double precision 53
22 company_type character varying 90
23 department_name character varying 360
24 employment_type character varying 90
25 employment_status_type character varying 90
26 verified_by_name character varying 360
27 verification_date timestamp without time zone
28 verifier_designation_txt character varying 450
29 remarks_txt character varying 360
30 verifier_emp_id character varying 30
31 verification_status character varying 90
32 employeeid_txt character varying 360
33 profession_id character varying 90
34 industry_id character varying 90
35 designation_txt character varying 450
36 contact_person_name character varying 360
37 contact_person_desig_name character varying 450
38 contact_person_email_txt character varying 360
39 contact_person_mobile character varying 90
40 contact_person_landline character varying 90
41 emp_mobile_number character varying 90
42 emp_mobile_country_code character varying 90
43 emp_phone_country_code character varying 30
44 emp_phone_number character varying 90
45 emp_ref_operator character varying 30
46 emp_email_address_domain character varying 120
47 emp_email_address_user character varying 90
48 ref_phone_extn character varying 120
49 ref_phone_area_code character varying 120
50 determinant_value character varying 180
51 employer_address_line9_txt character varying 360
52 employer_address_line10_txt character varying 360
53 employer_address_line11_txt character varying 360
54 employer_address_line12_txt character varying 360
55 emp_pfl_index double precision 53
56 is_primary character varying 3
57 profile_status character varying 60
58 domain_object_extn character varying 300
59 industry_category character varying 180
60 occupation_category character varying 180
61 cdc_source_system_code character varying 12
62 cdc_record_type character varying 48
63 cdc_commit_timestamp timestamp without time zone
64 cdc_extract_timestamp timestamp without time zone