tbist_wgroup

Database

prod_bank_wealth

Schema

sor_bdw

Type

BASE TABLE

Description

 

Columns
# Name Data Type Length
1 wgroup_hiid integer 32
2 pk_tbist_wgroup_wgroupid integer 32
3 fk_tbisr_wcommrate_categoryid integer 32
4 trailincrementflag integer 32
5 fixedtrailrate numeric 18
6 groupdesc character varying 765
7 aliascode character varying 225
8 add1addr character varying 300
9 add2addr character varying 300
10 suburbaddr character varying 150
11 stateaddr character varying 9
12 postcodeaddr character varying 12
13 reg1addr character varying 225
14 reg2addr character varying 225
15 regsuburbaddr character varying 150
16 regstateaddr character varying 9
17 regpostcodeaddr character varying 12
18 fk_tbisr_title_dirtitleid integer 32
19 dirlastnam character varying 300
20 dirmiddlenam character varying 300
21 dirfirstnam character varying 300
22 fk_tbisr_title_dirsectitleid integer 32
23 dirseclastnam character varying 300
24 dirsecmiddlenam character varying 300
25 dirsecfirstnam character varying 300
26 abnno character varying 45
27 acnno character varying 45
28 bnno character varying 150
29 phoneno character varying 150
30 faxno character varying 150
31 mobileno character varying 150
32 startdate timestamp without time zone
33 terminationdate timestamp without time zone
34 clawbackarrearsflag integer 32
35 fpoflag integer 32
36 sendsmstotype character varying 150
37 emailnam character varying 300
38 bpwebexportflag integer 32
39 emailinvoicesflag integer 32
40 divisionind character varying 150
41 sysrl_user character varying 150
42 sysrl_timestamp timestamp without time zone
43 sysr_deleted integer 32
44 sysr_deletedby character varying 150
45 sysr_deletedon timestamp without time zone
46 fk_tbisr_grouptype_grouptypeid integer 32
47 fk_tbisr_resourcetype integer 32
48 cob date
49 delta_type character varying 3
50 effective_strt_dt timestamp without time zone
51 effective_end_dt timestamp without time zone