as516_tbist_windividual

Database

prod_bank_wealth

Schema

sdsrsp01_bank

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 windividual_hiid integer 32
2 pk_tbist_windividual_windividualid integer 32
3 fk_tbist_wbook_wbookid integer 32
4 fk_tbisr_authtype_authtypeid integer 32
5 fk_tbisr_title_titleid integer 32
6 firstnam character varying 765
7 lastnam character varying 765
8 operatesasdesc character varying 300
9 add1addr character varying 300
10 add2addr character varying 300
11 suburbaddr character varying 150
12 stateaddr character varying 9
13 postcodeaddr character varying 12
14 phoneno character varying 150
15 faxno character varying 150
16 mobileno character varying 150
17 emailnam character varying 765
18 receivebrokeremailflag integer 32
19 receivegroupemailflag integer 32
20 ppmnam character varying 765
21 ppmcode character varying 765
22 fk_tbisr_district_districtid integer 32
23 homeloanflag integer 32
24 smallbusflag integer 32
25 commbusbankflag integer 32
26 insuranceflag integer 32
27 accreditationdate timestamp without time zone
28 certificatedate timestamp without time zone
29 terminateddate timestamp without time zone
30 miaano integer 32
31 miaaexpirydate timestamp without time zone
32 licenceno integer 32
33 expirydate timestamp without time zone
34 acl character varying 150
35 osdocrequestdate timestamp without time zone
36 osdocreceiveddate timestamp without time zone
37 sysrl_user character varying 150
38 sysrl_timestamp timestamp without time zone
39 sysr_deleted integer 32
40 sysr_deletedby character varying 150
41 sysr_deletedon timestamp without time zone
42 fk_tbisr_segmentid integer 32
43 fk_tbisr_district_districtid_sbbm integer 32
44 fk_related_windividualid integer 32
45 retailbranchno character varying 150
46 accreditationcode character varying 21
47 fk_tbisr_resourcetype integer 32
48 blacklistedflag integer 32
49 fk_tbist_windividual_officechampion integer 32
50 commercialbrokerflag integer 32
51 commercialaccreditationdate timestamp without time zone
52 commercialterminateddate timestamp without time zone
53 commercialaccreditationcode character varying 30
54 fk_tbist_intuser_intuserid_bbm integer 32
55 fk_tbisr_subsegmentid integer 32
56 retailbrokerflag integer 32
57 crno character varying 150
58 licensetype character varying 30
59 statuschange character varying 150
60 statuschangedate date
61 statuscomment character varying 765
62 broker_uid character varying 255
63 cob date
64 delta_type character varying 3
65 effective_strt_dt timestamp without time zone
66 effective_end_dt timestamp without time zone