TBIST_WINDIVIDUAL_20210128

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 WINDIVIDUAL_HIID INTEGER 4
2 PK_TBIST_WINDIVIDUAL_WINDIVIDUALID INTEGER 4
3 FK_TBIST_WBOOK_WBOOKID INTEGER 4
4 FK_TBISR_AUTHTYPE_AUTHTYPEID INTEGER 4
5 FK_TBISR_TITLE_TITLEID INTEGER 4
6 FIRSTNAM CHARACTER VARYING(255) 255
7 LASTNAM CHARACTER VARYING(255) 255
8 OPERATESASDESC CHARACTER VARYING(100) 100
9 ADD1ADDR CHARACTER VARYING(100) 100
10 ADD2ADDR CHARACTER VARYING(100) 100
11 SUBURBADDR CHARACTER VARYING(50) 50
12 STATEADDR CHARACTER VARYING(3) 3
13 POSTCODEADDR CHARACTER VARYING(4) 4
14 PHONENO CHARACTER VARYING(50) 50
15 FAXNO CHARACTER VARYING(50) 50
16 MOBILENO CHARACTER VARYING(50) 50
17 EMAILNAM CHARACTER VARYING(255) 255
18 RECEIVEBROKEREMAILFLAG INTEGER 4
19 RECEIVEGROUPEMAILFLAG INTEGER 4
20 PPMNAM CHARACTER VARYING(255) 255
21 PPMCODE CHARACTER VARYING(255) 255
22 FK_TBISR_DISTRICT_DISTRICTID INTEGER 4
23 HOMELOANFLAG INTEGER 4
24 SMALLBUSFLAG INTEGER 4
25 COMMBUSBANKFLAG INTEGER 4
26 INSURANCEFLAG INTEGER 4
27 ACCREDITATIONDATE TIMESTAMP 8
28 CERTIFICATEDATE TIMESTAMP 8
29 TERMINATEDDATE TIMESTAMP 8
30 MIAANO INTEGER 4
31 MIAAEXPIRYDATE TIMESTAMP 8
32 LICENCENO INTEGER 4
33 EXPIRYDATE TIMESTAMP 8
34 ACL CHARACTER VARYING(50) 50
35 OSDOCREQUESTDATE TIMESTAMP 8
36 OSDOCRECEIVEDDATE TIMESTAMP 8
37 SYSRL_USER CHARACTER VARYING(50) 50
38 SYSRL_TIMESTAMP TIMESTAMP 8
39 SYSR_DELETED INTEGER 4
40 SYSR_DELETEDBY CHARACTER VARYING(50) 50
41 SYSR_DELETEDON TIMESTAMP 8
42 FK_TBISR_SEGMENTID INTEGER 4
43 FK_TBISR_DISTRICT_DISTRICTID_SBBM INTEGER 4
44 FK_RELATED_WINDIVIDUALID INTEGER 4
45 RETAILBRANCHNO CHARACTER VARYING(50) 50
46 ACCREDITATIONCODE CHARACTER(7) 7
47 FK_TBISR_RESOURCETYPE INTEGER 4
48 BLACKLISTEDFLAG INTEGER 4
49 FK_TBIST_WINDIVIDUAL_OFFICECHAMPION INTEGER 4
50 COMMERCIALBROKERFLAG INTEGER 4
51 COMMERCIALACCREDITATIONDATE TIMESTAMP 8
52 COMMERCIALTERMINATEDDATE TIMESTAMP 8
53 COMMERCIALACCREDITATIONCODE CHARACTER VARYING(10) 10
54 FK_TBIST_INTUSER_INTUSERID_BBM INTEGER 4
55 FK_TBISR_SUBSEGMENTID INTEGER 4
56 RETAILBROKERFLAG INTEGER 4
57 CRNO CHARACTER VARYING(50) 50
58 LICENSETYPE NATIONAL CHARACTER(10) 10
59 STATUSCHANGE CHARACTER VARYING(50) 50
60 STATUSCHANGEDATE DATE 4
61 STATUSCOMMENT CHARACTER VARYING(255) 255
62 COB DATE 4
63 DELTA_TYPE CHARACTER VARYING(1) 1
64 EFFECTIVE_STRT_DT TIMESTAMP 8
65 EFFECTIVE_END_DT TIMESTAMP 8
66 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
67 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
68 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
69 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8